MARKUS

using IFinalPDF;

using KCOMDataModel.Common;

using KCOMDataModel.DataModel;

using log4net;

using log4net.Config;

using MarkupToPDF.Controls.Etc;

using MarkupToPDF.Controls.Shape;

using MarkupToPDF.Controls.Text;

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Linq;

using System.Runtime.Remoting.Channels.Tcp;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Activation;

using System.ServiceModel.Web;

using System.Text;

using System.Threading;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Threading;

namespace KCOM_API

{

    [ServiceContract(Namespace = "")]

    [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]

    //[ServiceBehavior(ConcurrencyMode = ConcurrencyMode.Single, InstanceContextMode = InstanceContextMode.PerCall)]

    public class Common :  System.Web.Services.WebService

    {

        private static log4net.ILog logger;

        public Common()

        {

            XmlConfigurator.Configure();

            //Get logger

            logger = LogManager.GetLogger(typeof(Common));

            //Start logging

            logger.Info("KCOM_API Common Call");

        }

        [OperationContract]

        public string AutoStamping(string project_no, string slip_no, string user_id)

        {

            string result = string.Empty;

            try

            {

                var waiter = new ManualResetEvent(false);

                var staThread = new Thread(() =>

                {

                    result = StampSave(project_no, slip_no, user_id);

                    waiter.Set();

                });

                staThread.SetApartmentState(ApartmentState.STA);

                staThread.Start();

                var timeout = new TimeSpan(0,1,0);

                waiter.WaitOne(timeout);

            }

            catch (Exception exception)

            {

                logger.Error(exception);

                result = exception.ToString();

            }

            return result;

        }

        [OperationContract]

        public ProjectInfo[] GetProjectList()

        {

            ProjectInfo[] result = null;

            try

            {

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

                {

                    result = _entity.RUN_PROJECTS.Where(p=>p.PROJECT_NO != "000000").ToList().Select(x => new ProjectInfo { No = x.PROJECT_NO, Name = $"{x.PROJECT_NO} - {x.PROJECT_NAME}"}).ToArray();

                }

            }

            catch (Exception)

            {

            }

            return result;

        }

        /// <summary>

        /// 심볼로 변경

        /// </summary>

        /// <param name="project_no"></param>

        /// <param name="slip_no"></param>

        /// <param name="user_id"></param>

        private string StampSave(string project_no, string slip_no, string user_id)

        {

            string result = string.Empty;

            try

            {

                logger.Info($"Stamp  ProjecNO : {project_no}  SlipNO : {slip_no}  UserID : {user_id}");

                string _stampData = null;

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

                {

                    var stamp = _entity.PROPERTIES.Where(x=> x.TYPE == "STAMP");

                    if(stamp.Count() > 0)

                    {

                        _stampData = stamp.First().VALUE;

                    }

                    else

                    {

                        result = "STAMP IS NULL.";

                    }

                };

                if (_stampData != null)

                {

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

                    {

                        logger.Info($"Connection CI DataBase :{cIEntity.Connection.Database} DataSource :{cIEntity.Connection.DataSource}");

                        var list = (from doc in cIEntity.DOCUMENT_ITEM

                                    where doc.GROUP_NO == slip_no && doc.PROJECT_NO == project_no

                                    select doc).ToList();

                        string userName = null;

                        var user = GetSelectMember(cIEntity, project_no, slip_no, user_id);

                        if (user.SLIP_COUNT == 0)

                        {

                            result = "Slip No does not exist.";

                        }

                        else

                        {

                            if (user.IS_ORIGINATOR == 0)

                            {

                                result = "User ID is not the Originator for that Slip No.";

                            }

                            else

                            {

                                if (user.USER_NAME == null)

                                {

                                    result = "user name IS NULL.";

                                }

                                else

                                {

                                    userName = user.USER_NAME;

                                    foreach (DOCUMENT_ITEM dOCUMENTITEM in list)

                                    {

                                        DOCINFO dOCINFO = (

                                            from x in cIEntity.DOCINFO

                                            where x.PROJECT_NO == project_no && x.DOCUMENT_ID == dOCUMENTITEM.DOCUMENT_ID

                                            select x).FirstOrDefault<DOCINFO>();

                                        MARKUP_INFO mARKUPINFO = (

                                            from x in cIEntity.MARKUP_INFO

                                            where x.DOCINFO_ID == dOCINFO.ID && x.AVOID_CONSOLIDATE == 0 && x.CONSOLIDATE == 1

                                            select x).FirstOrDefault<MARKUP_INFO>();

                                        if (mARKUPINFO == null)

                                        {

                                            var pageInfo = dOCINFO.DOCPAGE.First();

                                            mARKUPINFO = new MARKUP_INFO()

                                            {

                                                ID = shortGuid(),

                                                DOCINFO_ID = dOCINFO.ID,

                                                USER_ID = user_id,

                                                CREATE_TIME = DateTime.Now,

                                                CONSOLIDATE = 1,

                                                AVOID_CONSOLIDATE = 0,

                                                PART_CONSOLIDATE = 0,

                                                DESCRIPTION = "",

                                                UPDATE_TIME = new DateTime?(DateTime.Now),

                                            };

                                            cIEntity.MARKUP_INFO.AddObject(mARKUPINFO);

                                            MARKUP_INFO_VERSION mARKUPINFOVERSION = new MARKUP_INFO_VERSION()

                                            {

                                                ID = shortGuid(),

                                                MARKUPINFO_ID = mARKUPINFO.ID,

                                                CREATE_DATE = DateTime.Now

                                            };

                                            cIEntity.MARKUP_INFO_VERSION.AddObject(mARKUPINFOVERSION);

                                            Point startPoint = new Point(15, 15);

                                            var symCtrl = GetSymNControl(Convert.ToDouble(pageInfo.PAGE_WIDTH), Convert.ToDouble(pageInfo.PAGE_HEIGHT), mARKUPINFO.USER_ID, mARKUPINFO.ID, startPoint, _stampData);

                                            var bottom = Rect.Offset(symCtrl.ItemRect, new Vector(0, symCtrl.ItemRect.Height));

                                            var txtOriginator = GetTextControl(Convert.ToDouble(pageInfo.PAGE_WIDTH), Convert.ToDouble(pageInfo.PAGE_HEIGHT), mARKUPINFO.USER_ID, mARKUPINFO.ID

                                                           , userName, 20, System.Windows.Media.Color.FromArgb(255, 0, 0, 255), FontWeights.Bold, TextAlignment.Center, bottom, bottom.Top + 3);

                                            var dtfi = new System.Globalization.DateTimeFormatInfo { DateSeparator = "-", ShortDatePattern = @"yyyy/MM/dd" };

                                            var txtDate = GetTextControl(Convert.ToDouble(pageInfo.PAGE_WIDTH), Convert.ToDouble(pageInfo.PAGE_HEIGHT), mARKUPINFO.USER_ID, mARKUPINFO.ID

                                                           , DateTime.Now.ToString("d", dtfi), 20, System.Windows.Media.Color.FromArgb(255, 255, 0, 0), FontWeights.Bold, TextAlignment.Center, bottom, txtOriginator.StartPoint.Y + txtOriginator.BoxHeight + 2);

                                            var symData = symCtrl.GetMarkupData(mARKUPINFO.USER_ID, 1, mARKUPINFOVERSION.ID);

                                            cIEntity.MARKUP_DATA.AddObject(symData);

                                            cIEntity.MARKUP_DATA.AddObject(txtOriginator.GetMarkupData(mARKUPINFO.USER_ID, 1, mARKUPINFOVERSION.ID));

                                            cIEntity.MARKUP_DATA.AddObject(txtDate.GetMarkupData(mARKUPINFO.USER_ID, 1, mARKUPINFOVERSION.ID));

                                        }

                                        cIEntity.SaveChanges();

                                        this.SetFinalPDF(project_no, dOCINFO.ID, mARKUPINFO.ID, user_id);

                                    }

                                }

                            }

                        }

                    }

                }

            }

            catch (Exception ex)

            {

                logger.Error($"StampSave ProjectNO : {project_no} slipNo : {slip_no} userID : {user_id}" + ex);

                result = "Stamp Save Error";

            }

            return result;

        }

        private List<MEMBER> GetMemberQuery(System.Data.Objects.ObjectContext context, string UserID)

        {

            List<MEMBER> result = new List<MEMBER>();

            try

            {

                string query = "SELECT members.ID,members.NAME,members.DEPARTMENT FROM CIEntities.MEMBER as members where members.ID = @userId";

                var param = new[] { new System.Data.Objects.ObjectParameter("userId", UserID) };

                System.Data.Objects.ObjectQuery<System.Data.Common.DbDataRecord> memberQuery

                              = context.CreateQuery<System.Data.Common.DbDataRecord>(query, param);

                if (memberQuery.Count() > 0)

                {

                    foreach (var dataRecord in memberQuery)

                    {

                        MEMBER member = new MEMBER();

                        string userName = dataRecord["NAME"]?.ToString().Trim();

                        string ID = dataRecord["ID"]?.ToString().Trim();

                        string depatment = dataRecord["DEPARTMENT"]?.ToString().Trim();

                        member.NAME = userName;

                        member.ID = ID;

                        member.DEPARTMENT = depatment;

                        result.Add(member);

                    }

                }

            }

            catch (Exception ex)

            {

                throw new Exception("GetMember(System.Data.Objects.ObjectContext context, string UserID) ", ex);

            }

            return result;

        }

        private SelectMember GetSelectMember(System.Data.Objects.ObjectContext context,string ProjectNo,string SlipNo, string UserID)

        {

            SelectMember result = new SelectMember();

            try

            {

                string query = "SELECT_SLIP_ORIGINATOR @P_PROJECT_NO = @ProjectNo , @P_SLIP_NO = @SlipNo  ,@P_USER_ID = @UserID";

                var param = new[]{

                    new System.Data.SqlClient.SqlParameter("ProjectNo", ProjectNo),

                    new System.Data.SqlClient.SqlParameter("SlipNo", SlipNo),

                    new System.Data.SqlClient.SqlParameter("UserID", UserID)

                };

                //var memberQuery = context.ExecuteStoreQuery<System.Data.Common.DbDataRecord>(query, param).ToList();

                //if (memberQuery.Count() > 0)

                //{

                //    result.USER_NAME = memberQuery.First()["USER_NAME"]?.ToString();

                //    result.IS_ORIGINATOR = Convert.ToInt32(memberQuery.First()["IS_ORIGINATOR"]);

                //}

                var memberQuery = context.ExecuteStoreQuery<SelectMember>(query, param).ToList();

                if (memberQuery.Count() > 0)

                {

                    result = memberQuery.First();

                }

            }

            catch (Exception ex)

            {

                throw new Exception("GetMember(System.Data.Objects.ObjectContext context, string UserID) ", ex);

            }

            return result;

        }

        private void StampSave_NoneSymbol(string project_no, string slip_no, string user_id)

        {

            try

            {

                logger.Info($"Stamp  ProjecNO : {project_no}  SlipNO : {slip_no}  UserID : {user_id}");

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

                {

                    logger.Info($"Connection CI DataBase :{cIEntity.Connection.Database} DataSource :{cIEntity.Connection.DataSource}");

                    var list = (from doc in cIEntity.DOCUMENT_ITEM

                                where doc.GROUP_NO == slip_no && doc.PROJECT_NO == project_no

                                select doc).ToList();

                    foreach (DOCUMENT_ITEM dOCUMENTITEM in list)

                    {

                        DOCINFO dOCINFO = (

                            from x in cIEntity.DOCINFO

                            where x.PROJECT_NO == project_no && x.DOCUMENT_ID == dOCUMENTITEM.DOCUMENT_ID

                            select x).FirstOrDefault<DOCINFO>();

                        MARKUP_INFO mARKUPINFO = (

                            from x in cIEntity.MARKUP_INFO

                            where x.DOCINFO_ID == dOCINFO.ID && x.AVOID_CONSOLIDATE == 0 && x.CONSOLIDATE == 1

                            select x).FirstOrDefault<MARKUP_INFO>();

                        if (mARKUPINFO == null)

                        {

                            var pageInfo = dOCINFO.DOCPAGE.First();

                            mARKUPINFO = new MARKUP_INFO()

                            {

                                ID = shortGuid(),

                                DOCINFO_ID = dOCINFO.ID,

                                USER_ID = user_id,

                                CREATE_TIME = DateTime.Now,

                                CONSOLIDATE = 1,

                                AVOID_CONSOLIDATE = 0,

                                PART_CONSOLIDATE = 0,

                                DESCRIPTION = "",

                                UPDATE_TIME = new DateTime?(DateTime.Now),

                            };

                            cIEntity.MARKUP_INFO.AddObject(mARKUPINFO);

                            MARKUP_INFO_VERSION mARKUPINFOVERSION = new MARKUP_INFO_VERSION()

                            {

                                ID = shortGuid(),

                                MARKUPINFO_ID = mARKUPINFO.ID,

                                CREATE_DATE = DateTime.Now

                            };

                            cIEntity.MARKUP_INFO_VERSION.AddObject(mARKUPINFOVERSION);

                            Point startPoint = new Point(15, 15);

                            var rect = Common.GetRectControl(Convert.ToDouble(pageInfo.PAGE_WIDTH), Convert.ToDouble(pageInfo.PAGE_HEIGHT),

                                                    mARKUPINFO.USER_ID, mARKUPINFO.ID, startPoint);

                            var txtApproved = GetTextControl(Convert.ToDouble(pageInfo.PAGE_WIDTH), Convert.ToDouble(pageInfo.PAGE_HEIGHT), mARKUPINFO.USER_ID, mARKUPINFO.ID,

                                                         "APPROVED", 30, System.Windows.Media.Color.FromArgb(255, 255, 0, 0), FontWeights.Bold, TextAlignment.Center, rect.ItemRect, 18);

                            var txtCreator = GetTextControl(Convert.ToDouble(pageInfo.PAGE_WIDTH), Convert.ToDouble(pageInfo.PAGE_HEIGHT), mARKUPINFO.USER_ID, mARKUPINFO.ID

                                            , "By HYOSUNG", 18, System.Windows.Media.Color.FromArgb(255, 255, 0, 0), FontWeights.Bold, TextAlignment.Center, rect.ItemRect, txtApproved.StartPoint.Y + txtApproved.BoxHeight + 3);

                            var bottom = Rect.Offset(rect.ItemRect, new Vector(0, rect.ItemRect.Height));

                            var txtOriginator = GetTextControl(Convert.ToDouble(pageInfo.PAGE_WIDTH), Convert.ToDouble(pageInfo.PAGE_HEIGHT), mARKUPINFO.USER_ID, mARKUPINFO.ID

                                           , mARKUPINFO.USER_ID, 18,System.Windows.Media.Color.FromArgb(255, 255, 0, 0), FontWeights.Bold, TextAlignment.Left, bottom, bottom.Top + 3);

                            var dtfi = new System.Globalization.DateTimeFormatInfo { DateSeparator = "-", ShortDatePattern = @"yyyy/MM/dd" };

                            var txtDate = GetTextControl(Convert.ToDouble(pageInfo.PAGE_WIDTH), Convert.ToDouble(pageInfo.PAGE_HEIGHT), mARKUPINFO.USER_ID, mARKUPINFO.ID

                                           , DateTime.Now.ToString("d", dtfi), 18, System.Windows.Media.Color.FromArgb(255, 255, 0, 0), FontWeights.Bold, TextAlignment.Left, bottom, txtOriginator.StartPoint.Y + txtOriginator.BoxHeight + 2);

                            var rectData = rect.GetMarkupData(mARKUPINFO.USER_ID, 1, mARKUPINFOVERSION.ID);

                            cIEntity.MARKUP_DATA.AddObject(rectData);

                            cIEntity.MARKUP_DATA.AddObject(txtApproved.GetMarkupData(mARKUPINFO.USER_ID, 1, mARKUPINFOVERSION.ID));

                            cIEntity.MARKUP_DATA.AddObject(txtCreator.GetMarkupData(mARKUPINFO.USER_ID, 1, mARKUPINFOVERSION.ID));

                            cIEntity.MARKUP_DATA.AddObject(txtOriginator.GetMarkupData(mARKUPINFO.USER_ID, 1, mARKUPINFOVERSION.ID));

                            cIEntity.MARKUP_DATA.AddObject(txtDate.GetMarkupData(mARKUPINFO.USER_ID, 1, mARKUPINFOVERSION.ID));

                        }

                        cIEntity.SaveChanges();

                        this.SetFinalPDF(project_no, dOCINFO.ID, mARKUPINFO.ID, user_id);

                    }

                }

            }

            catch (Exception ex)

            {

                logger.Error($"StampSave ProjectNO : {project_no} slipNo : {slip_no} userID : {user_id}" + ex);

            }

        }

        private static string shortGuid()

        {

            byte[] bytes = new byte[16];

            using (var provider = System.Security.Cryptography.RandomNumberGenerator.Create())

            {

                provider.GetBytes(bytes);

            }

            var guid = new Guid(bytes);

            return Convert.ToBase64String(guid.ToByteArray())

                .Substring(0, 10)

                .Replace("/", "")

                .Replace("+", "") + DateTime.UtcNow.Ticks.ToString("x");

        }

        private SymControlN GetSymNControl(double PageWidth, double PageHeight, string userId, string markupInfoId, Point startPosition,string StampData)

        {

            SymControlN result = null;

            try

            {

                double height = 80;

                double itemWidth = 180;

                System.Windows.Point startPoint = new System.Windows.Point(startPosition.X, startPosition.Y);

                System.Windows.Point endPoint = new System.Windows.Point(startPosition.X + itemWidth, startPosition.Y + height);

                System.Windows.Point leftBottomPoint = new System.Windows.Point(startPosition.X, startPosition.Y + height);

                System.Windows.Point topRightPoint = new System.Windows.Point(startPosition.X + itemWidth, startPosition.Y);

                result = new SymControlN

                {

                    CommentID = shortGuid(),

                    MarkupInfoID = markupInfoId,

                    UserID = userId,

                    PointSet = new List<Point> { startPoint, leftBottomPoint, endPoint, topRightPoint },

                    StartPoint = startPoint,

                    EndPoint = endPoint,

                    CommentAngle = 0,

                    LeftBottomPoint = leftBottomPoint,

                    TopRightPoint = topRightPoint,

                    Opacity = 1,

                    PathXathData = StampData,

                    Memo = null

                };

            }

            catch (Exception ex)

            {

                System.Diagnostics.Debug.WriteLine(ex.ToString());

            }

            return result;

        }

        private static RectangleControl GetRectControl(double PageWidth, double PageHeight, string USER_ID, string markupInfoId, Point startPosition)

        {

            RectangleControl result = null;

            try

            {

                double height = 80;

                double itemWidth = 180;

                System.Windows.Point startPoint = new System.Windows.Point(startPosition.X, startPosition.Y);

                System.Windows.Point endPoint = new System.Windows.Point(startPosition.X + itemWidth, startPosition.Y + height);

                System.Windows.Point leftBottomPoint = new System.Windows.Point(startPosition.X, startPosition.Y + height);

                System.Windows.Point topRightPoint = new System.Windows.Point(startPosition.X + itemWidth, startPosition.Y);

                result = new RectangleControl

                {

                    CommentID = shortGuid(),

                    MarkupInfoID = markupInfoId,

                    LineSize = 5,

                    Paint = MarkupToPDF.Controls.Common.PaintSet.None,

                    StartPoint = startPoint,

                    EndPoint = endPoint,

                    CommentAngle = 0,

                    StrokeColor = new System.Windows.Media.SolidColorBrush(System.Windows.Media.Color.FromArgb(255, 255, 0x0, 0x0)),

                    //StrokeColor = new System.Windows.Media.SolidColorBrush(System.Windows.Media.Color.FromArgb(255, 64, 224, 208)),

                    FillColor = null,

                    DashSize = new System.Windows.Media.DoubleCollection(new[] { 999999.0 }),

                    Opacity = 1,

                    LeftBottomPoint = leftBottomPoint,

                    TopRightPoint = topRightPoint,

                    PointSet = new List<Point> { startPoint, leftBottomPoint, endPoint, topRightPoint },

                    UserID = USER_ID,

                    Memo = null,

                    SymbolID = null

                };

            }

            catch (Exception ex)

            {

                System.Diagnostics.Debug.WriteLine(ex.ToString());

            }

            return result;

        }

        [STAThread]

        private static TextControl GetTextControl(double PageWidth, double PageHeight, string USER_ID, string markupInfoId, 

            string Text, double fontSize, System.Windows.Media.Color Foreground, FontWeight fontWeight, TextAlignment textAlignment, Rect parentRect, double positionY)

        {

            TextControl result = null;

            try

            {

                var txtSize = ShapeMeasure(new TextBlock

                {

                    Text = Text,

                    FontSize = fontSize,

                    FontWeight = fontWeight,

                    FontFamily = new System.Windows.Media.FontFamily("Arial")

                });

                double startPositionX = parentRect.X;

                switch (textAlignment)

                {

                    case TextAlignment.Right:

                        startPositionX = parentRect.X + parentRect.Width - txtSize.Width;

                        break;

                    case TextAlignment.Center:

                        startPositionX = parentRect.X + parentRect.Width / 2 - txtSize.Width / 2;

                        break;

                }

                Point startPosition = new Point

                {

                    X = startPositionX,

                    Y = positionY

                };

                System.Windows.Point startPoint = new System.Windows.Point(startPosition.X, startPosition.Y);

                System.Windows.Point endPoint = new System.Windows.Point(startPosition.X + txtSize.Width, startPosition.Y + txtSize.Height);

                System.Windows.Point leftBottomPoint = new System.Windows.Point(startPosition.X, startPosition.Y + txtSize.Height);

                System.Windows.Point topRightPoint = new System.Windows.Point(startPosition.X + txtSize.Width, startPosition.Y);

                result = new TextControl

                {

                    CommentID = shortGuid(),

                    MarkupInfoID = markupInfoId,

                    Text = Text,

                    StartPoint = startPoint,

                    EndPoint = endPoint,

                    CanvasX = startPosition.X,

                    CanvasY = startPosition.Y,

                    BoxWidth = txtSize.Width,

                    BoxHeight = txtSize.Height,

                    ControlType_No = 0,

                    LineSize = new Thickness(5),

                    TextSize = fontSize,

                    Foreground = new System.Windows.Media.SolidColorBrush(Foreground),

                    FontSize = 10,

                    UserID = USER_ID,

                    IsHighLight = false,

                    CommentAngle = 0,

                    PointSet = new List<Point>(),

                    Opacity = 1,

                    IsSelected = false,

                    TextFamily = new System.Windows.Media.FontFamily("Arial"),

                    TextStyle = FontStyles.Normal,

                    TextWeight = FontWeights.Bold

                };

            }

            catch (Exception ex)

            {

                throw new Exception("Text Control error");

            }

            return result;

        }

        public static Size ShapeMeasure(UIElement e)

        {

            // Measured Size is bounded to be less than maxSize

            Size maxSize = new Size(

                 double.PositiveInfinity,

                 double.PositiveInfinity);

            e.Measure(maxSize);

            return e.DesiredSize;

        }

        private void SetTextControl(TextControl textControl)

        {

            textControl.Base_TextBlock.Margin = new Thickness(0, 0, 10, 0);

            textControl.Base_TextBox.Visibility = Visibility.Collapsed;

            textControl.Base_TextBlock.Visibility = Visibility.Visible;

        }

        #region Final PDF

        private string _ChanID = null;

        TcpChannel chan = null;

        [OperationContract]

        public FinalPDFResult SetFinalPDF(string ProjectNo, string DocInfoID, string MarkupInfoID, string CreateUSER_ID)

        {

            #region 임시보관

            #endregion

            FinalPDFResult _result = new FinalPDFResult();

            RemFinalPDFObject remObj = null;

            try

            {

                string _finalID = shortGuid();

                int _DocTotalPages = -1;

                string docItemId;

                logger.Info($"SetFinalPDF ProjectNo :{ProjectNo} DocInfoID :{DocInfoID}  MarkupInfoID:{MarkupInfoID}  CreateUSER_ID:{CreateUSER_ID}");

                //string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;

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

                {

                    logger.Info($"Connection CI DataBase :{_ci.Connection.Database} DataSource :{_ci.Connection.DataSource}");

                    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;

                    }

                }

                if (_DocTotalPages > 0)

                {

                    FINAL_PDF fm = new FINAL_PDF()

                    {

                        ID = _finalID,

                        PROJECT_NO = ProjectNo,

                        DOCINFO_ID = DocInfoID,

                        DOCUMENT_ID = docItemId,

                        MARKUPINFO_ID = MarkupInfoID,

                        CREATE_USER_ID = CreateUSER_ID,

                        TOTAL_PAGE = _DocTotalPages,

                        CREATE_DATETIME = DateTime.Now,

                        STATUS = (int)IFinalPDF.FinalStatus.Insert

                    };

                    //string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

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

                    {

                        logger.Info($"Connection KCOM DataBase :{_entity.Connection.Database} DataSource :{_entity.Connection.DataSource}");

                        _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://localhost: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)

            {

                logger.Error($"SetFinalPDF - " + ex);

                _result.Status = FinalStatus.Error;

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

                    _result.Exception = "Final Server Not Connection";

                else _result.Exception = ex.ToString();

            }

            finally

            {

                remObj = null;

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

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

                GC.Collect(2);

            }

            return _result;

        }

        #endregion

    }

    public class SelectMember

    {

        public string USER_NAME { get; set; }

        /// <summary>

        /// 0보다 크면 originator

        /// </summary>

        public int IS_ORIGINATOR { get; set; }

        /// <summary>

        /// 해당 SLIP NO가 있는지

        /// </summary>

        public int SLIP_COUNT { get; set; }

    }

    [DataContract]

    public class ProjectInfo

    {

        [DataMember]

        public string No { get; set; }

        [DataMember]

        public string Name { get; set; }

    }

}