MARKUS

        [OperationContract]

        public FinalPDFResult ConsolidateMergedPDF(string project_no, string _user_id, string _doc_id, List<MarkupInfoItem> markupInfoItems, string ProjectNo, string DocInfoID, string CreateUserID)

        {

            bool consolidate = false;

            try

            {

                List<KCOMDataModel.DataModel.MARKUP_DATA> instanceDataSet = new List<KCOMDataModel.DataModel.MARKUP_DATA>();

                using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))

                {

                    var markupInfo = Entity.MARKUP_INFO.Where(entity => entity.DOCINFO_ID == _doc_id).OrderByDescending(i => i.CONSOLIDATE).OrderByDescending(j => j.CREATE_TIME).FirstOrDefault();

                    if (markupInfo.CONSOLIDATE == 1)

                    {

                        markupInfo.AVOID_CONSOLIDATE = 1;

                    }

                    foreach (MarkupInfoItem item in markupInfoItems)

                    {

                        Entity.MARKUP_DATA.Where(data => data.MARKUPINFO_VERSION_ID == item.MarkupVersionID).ToList().ForEach(d =>

                        {

                            instanceDataSet.Add(d);

                        });

                    }

                    KCOMDataModel.DataModel.MARKUP_INFO info = new KCOMDataModel.DataModel.MARKUP_INFO();

                    info.ID = shortGuid();

                    info.CONSOLIDATE = 1;

                    info.CREATE_TIME = DateTime.Now;

                    info.DOCINFO_ID = _doc_id;

                    info.UPDATE_TIME = DateTime.Now;

                    info.USER_ID = _user_id;

                    info.AVOID_CONSOLIDATE = 0;

                    Entity.MARKUP_INFO.AddObject(info);

                    Entity.SaveChanges();

                    KCOMDataModel.DataModel.MARKUP_INFO_VERSION info2 = new KCOMDataModel.DataModel.MARKUP_INFO_VERSION

                    {

                        ID = shortGuid(),

                        CREATE_DATE = DateTime.Now,

                        MARKUP_INFO = info,

                    };

                    Entity.SaveChanges();

                    foreach (var item in instanceDataSet)

                    {

                        Entity.MARKUP_DATA.AddObject(new KCOMDataModel.DataModel.MARKUP_DATA

                        {

                            ID = shortGuid(),

                            DATA = item.DATA,

                            DATA_TYPE = item.DATA_TYPE,

                            PAGENUMBER = item.PAGENUMBER,

                            MARKUP_INFO_VERSION = info2,

                            SYMBOL_ID = item.SYMBOL_ID

                        });

                    }

                    Entity.SaveChanges();

                }

                consolidate = true;

            }

            catch (Exception)

            {

                consolidate = false;

            }

            FinalPDFResult _result = new FinalPDFResult();

            if (consolidate == true)

            {

                RemFinalPDFObject remObj = null;

                try

                {

                    string _finalID = shortGuid();

                    int _DocTotalPages = -1;

                    string docItemId;

                    using (CIEntities _ci = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString()))

                    {

                        var _doc = _ci.DOCINFO.Where(info => info.ID == DocInfoID);

                        if (_doc.Count() > 0)

                        {

                            _DocTotalPages = _doc.First().PAGE_COUNT;

                            docItemId = _doc.First().DOCUMENT_ID;

                        }

                        else

                        {

                            _result.Status = FinalStatus.Error;

                            _result.Exception = "페이지 정보를 가져올 수 없습니다.";

                            return _result;

                        }

                    }

                    var Items = GetMarkupInfoItems(ProjectNo, DocInfoID);

                    if (_DocTotalPages > 0)

                    {

                        var item2 = Items.Cast<MarkupInfoItem>().Where(d => d.Consolidate == 1 && d.AvoidConsolidate == 0).FirstOrDefault();

                        FINAL_PDF fm = new FINAL_PDF()

                        {

                            ID = _finalID,

                            PROJECT_NO = ProjectNo,

                            DOCINFO_ID = DocInfoID,

                            DOCUMENT_ID = docItemId,

                            MARKUPINFO_ID = item2.MarkupInfoID,

                            CREATE_USER_ID = CreateUserID,

                            TOTAL_PAGE = _DocTotalPages,

                            CREATE_DATETIME = DateTime.Now,

                            STATUS = (int)IFinalPDF.FinalStatus.Insert

                        };

                        using (KCOMEntities _entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))

                        {

                            _entity.AddToFINAL_PDF(fm);

                            _entity.SaveChanges(System.Data.Objects.SaveOptions.AcceptAllChangesAfterSave);

                        };

                        System.Runtime.Remoting.Channels.IChannel _ch = System.Runtime.Remoting.Channels.ChannelServices.GetChannel("tcp");

                        if (_ch == null)

                        {

                            chan = new TcpChannel();

                            _ChanID = chan.ChannelName;

                            System.Runtime.Remoting.Channels.ChannelServices.RegisterChannel(chan, false);

                            // Create an instance of the remote object

                            using (KCOMEntities ec = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))

                            {

                                //remObj = (RemFinalPDFObject)Activator.GetObject(typeof(RemFinalPDFObject),

                                //                          "tcp://localhost:9092/remFinalPDF");

                                remObj = (RemFinalPDFObject)Activator.GetObject(typeof(RemFinalPDFObject),

                                                          //"tcp://192.168.0.67:9092/remFinalPDF");

                                                          "tcp://192.168.0.67:9092/remFinalPDF");

                            }

                            //"tcp://localhost:8080/remFinalPDF");

                            _result = remObj.SetFinalPDF(ProjectNo, _finalID);

                            _result.FinalID = _finalID;

                            _result.Status = FinalStatus.Success;

                            //MarkupToPDF.MarkupToPDF fa = new MarkupToPDF.MarkupToPDF();

                            //fa.MakeFinalPDF(fm);

                        }

                        else

                        {

                            _ChanID = _ch.ChannelName;

                        }

                    }

                }

                catch (Exception ex)

                {

                    _result.Status = FinalStatus.Error;

                    if (ex.GetType() == typeof(System.Net.Sockets.SocketException))

                        _result.Exception = "Final Server Not Connection";

                }

                finally

                {

                    remObj = null;

                    if (System.Runtime.Remoting.Channels.ChannelServices.GetChannel("tcp") != null)

                        System.Runtime.Remoting.Channels.ChannelServices.UnregisterChannel(chan);

                    GC.Collect(2);

                }

            }

            return _result;

        }