MARKUS

using IConverterPDF;

using KCOMDataModel.DataModel;

using KCOMDataModel.Common;

using log4net;

using Newtonsoft.Json.Linq;

using System;

using System.IO;

using System.Linq;

using System.Runtime.Remoting.Channels;

using System.Runtime.Remoting.Channels.Tcp;

using System.Text;

using System.Web;

using System.Web.Services;

namespace ConvertionWebService

{

    /// <summary>

    /// Summary description for Conversio

    /// </summary>

    [WebService(Namespace = "http://tempuri.org/")]

    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

    [System.ComponentModel.ToolboxItem(false)]

    public class Conversion : System.Web.Services.WebService

    {

        RemConverterPDFObject remObj = null;

        protected ILog logger = LogManager.GetLogger(typeof(Conversion));

        public Conversion()

        {

            try

            {

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

                if(_ch == null)

                {

                    TcpChannel chan = new TcpChannel();

                    ChannelServices.RegisterChannel(chan, false);

                }

                // Create an instance of the remote object

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

                                                            Properties.Settings.Default.ConverterRemotingUrl);

            }

            catch (Exception ex)

            {

                logger.Error("Conversion Web Service Conversion Error", ex);

                SendNotice(ex.ToString());

            }

        }

        private void SendNotice(string ex)

        {

            if (!string.IsNullOrWhiteSpace(Properties.Settings.Default.ErrorNoticeID))

            {

                var _lstID = Properties.Settings.Default.ErrorNoticeID.Split(';').ToList();

                //EmailClient.EmailClient _client = new EmailClient.EmailClient(_lstID.First());

                StringBuilder _bl = new StringBuilder();

                _bl.AppendLine("Conversion Web Service Error");

                _bl.AppendLine(ex);

                //var _emailResult = _client.SendEmail(_lstID, _lstID, "<Conversion Web Service Error>", _bl.ToString(), false);

            }

            else

            {

                logger.Error("Conversion Web Service Error",new Exception(ex));

            }

        }

        [WebMethod]

        public string ConvertRun(string rev_No, string document_No, string document_Name, string group_No, string prj_No, string document_Id, string document_Url)

        {

            string _result = null;

            try

            {

                logger.Info($"Conversion Web Service ConvertRun call rev_No :{rev_No} document_No : {document_No}  document_Name : {document_Name}  group_No : {group_No}  prj_No : {prj_No}  document_Id : {document_Id}  document_Url : {document_Url}");

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

                {

                    //_result = ConnectStringBuilder.DeepViewConnectionString().ToString();

                    //var _RunProjects = deepViewEntity.RUN_PROJECTS.Where(r => r.PROJECT_NO == projNumber && DateTime.Parse(r.RUN_DATETIME)<= DateTime.Now);

                    //var _RunProjects = deepViewEntity.RUN_PROJECTS.Where(r => r.PROJECT_NO == projNumber);

                    var _RunProjects = deepViewEntity.RUN_PROJECTS.Where(r => r.PROJECT_NO != null);

                    if (_RunProjects.Count() > 0)

                    {

                        _result = SendKcom(rev_No, document_No, document_Name, group_No, prj_No, document_Id, document_Url);

                    }

                    else

                    {

                        _result = false.ToString();

                    }

                }

            }

            catch (Exception ex)

            {

                logger.Error($"Conversion Web Service ConvertRun Error rev_No :{rev_No} document_No : {document_No}  document_Name : {document_Name}  group_No : {group_No}  prj_No : {prj_No}  document_Id : {document_Id}  document_Url : {document_Url}", ex);

                _result = ex.Message.ToString();

                SendNotice("Project NO : " + prj_No + "\r\n  DocumentUrl : " + document_Url + "\r\n Error" + ex.ToString());

            }

            return _result;

        }

        [WebMethod]

        public string ConvertRunIgnoreComment(string rev_No, string document_No, string document_Name, string group_No, string prj_No, string document_Id, string document_Url, string ignoreComment)

        {

            string _result = null;

            try

            {

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

                {

                    //_result = ConnectStringBuilder.DeepViewConnectionString().ToString();

                    //var _RunProjects = deepViewEntity.RUN_PROJECTS.Where(r => r.PROJECT_NO == projNumber && DateTime.Parse(r.RUN_DATETIME)<= DateTime.Now);

                    //var _RunProjects = deepViewEntity.RUN_PROJECTS.Where(r => r.PROJECT_NO == projNumber);

                    var _RunProjects = deepViewEntity.RUN_PROJECTS.Where(r => r.PROJECT_NO != null);

                    if (_RunProjects.Count() > 0)

                    {

                        _result = SendKcom(rev_No, document_No, document_Name, group_No, prj_No, document_Id, document_Url,ignoreComment);

                    }

                    else

                    {

                        _result = false.ToString();

                    }

                }

            }

            catch (Exception ex)

            {

                _result = ex.Message.ToString();

                SendNotice("Project NO : " + prj_No + "\r\n  DocumentUrl : " + document_Url + "\r\n Error" + ex.ToString());

            }

            return _result;

        }

        private string SendKcom(string rev_No, string document_No, string document_Name, string group_No, string prj_No, string document_Id, string document_Url, string ignoreComment)

        {

            string result = false.ToString();

            if (remObj == null)

            {

                result = "Window Service Connection Error";

            }

            else

            {

                //string _id = GetGuid(0, GuidGenerator.GetUniqueGuid()).ToString();

                string _id = shortGuid();

                string _doc_id = ((UInt32)document_Id.GetHashCode()).ToString();

                using (CIEntities _entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString("").ToString()))

                {

                    if (string.IsNullOrEmpty(group_No))

                    {

                        group_No = "0";

                    }

                    if (!document_Url.Contains("http%3a%2f%2f"))

                    {

                        document_Url = Base64Decode(document_Url);

                        document_Url = HttpUtility.UrlEncodeUnicode(document_Url);

                    }

                    document_Name = Base64DecodeFromStr(document_Name);

                    var doc = _entity.DOCUMENT_ITEM.Where(d => d.ID == document_Id).FirstOrDefault();

                    if (doc != null)

                    {

                        if (bool.Parse(ignoreComment))

                        {

                            try

                            {

                                var docinfo = _entity.DOCINFO.Where(x => x.DOCUMENT_ID == doc.DOCUMENT_ID).FirstOrDefault();

                                var markupinfos = _entity.MARKUP_INFO.Where(x => x.DOCINFO_ID == docinfo.ID).ToList();

                                foreach (var markupinfo in markupinfos)

                                {

                                    var markupinfoversions = _entity.MARKUP_INFO_VERSION.Where(x => x.MARKUPINFO_ID == markupinfo.ID).ToList();

                                    foreach (var markupinfoversion in markupinfoversions)

                                    {

                                        var markupdatas = _entity.MARKUP_DATA.Where(x => x.MARKUPINFO_VERSION_ID == markupinfoversion.ID).ToList();

                                        foreach (var markupdata in markupdatas)

                                        {

                                            _entity.DeleteObject(markupdata);

                                        }

                                        _entity.DeleteObject(markupinfoversion);

                                    }

                                    _entity.DeleteObject(markupinfo);

                                }

                                _entity.SaveChanges();

                            }

                            catch (Exception ex)

                            {

                                result = "deleteobject error:"+ex.ToString();

                            }

                        }else

                        {

                            doc.REVISION = rev_No;

                            doc.ORIGINAL_FILE = document_Url;

                            doc.GROUP_NO = group_No;

                            doc.DOCUMENT_NO = document_No;

                            doc.DOCUMENT_NAME = document_Name;

                        }                        

                    }else

                    {

                        _entity.AddToDOCUMENT_ITEM(new DOCUMENT_ITEM

                        {

                            ID = document_Id,

                            REVISION = rev_No,

                            DOCUMENT_NO = document_No,

                            DOCUMENT_NAME = document_Name,

                            GROUP_NO = group_No,

                            ORIGINAL_FILE = document_Url,

                            DOCUMENT_ID = _doc_id,

                            PROJECT_NO = prj_No,

                        });                        

                    }

                    _entity.SaveChanges();

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

                    {

                        _kcomEntity.AddToCONVERTER_DOC(new CONVERTER_DOC

                        {

                            ID = _id,

                            CREATE_DATETIME = DateTime.Now,

                            DOCUMENT_URL = document_Url,

                            PROJECT_NO = prj_No,

                            DOCUMENT_ID = _doc_id,

                        });

                        _kcomEntity.SaveChanges();

                    }

                }

                if (Properties.Settings.Default.MARKUS_V3_PROJECTS.Split(',').Contains(prj_No))

                {

                    try

                    {

                        System.Net.WebClient client = new System.Net.WebClient();

                        var convertResult = client.DownloadString($"{Properties.Settings.Default.MARKUS_V3_ADDRESS}/Rest/ConvertAdd?ProjectNo={prj_No}&ConvertID={_id}");

                        JObject jObject = JObject.Parse(convertResult, new JsonLoadSettings());

                        result = jObject["ConvertAddResult"].ToString();

                    }

                    catch (Exception ex)

                    {

                        result = $"Markus V3 Connect Error {ex.Message}";

                    }

                }

                else

                {

                    var convertResult = remObj.SetConverterPDF(prj_No, _id);

                    if (convertResult.Exception != null)

                    {

                        result = false.ToString();

                    }

                    else

                    {

                        result = true.ToString();

                    }

                }

            }

            return result;

        }

        [WebMethod]

        public string ManualConvert(string rev_No, string document_No, string document_Name, string group_No, string prj_No, string document_Id, string document_Url)

        {

            string _result = null;

            try

            {

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

                {

                    //_result = ConnectStringBuilder.DeepViewConnectionString().ToString();

                    //var _RunProjects = deepViewEntity.RUN_PROJECTS.Where(r => r.PROJECT_NO == projNumber && DateTime.Parse(r.RUN_DATETIME)<= DateTime.Now);

                    //var _RunProjects = deepViewEntity.RUN_PROJECTS.Where(r => r.PROJECT_NO == projNumber);

                    var _RunProjects = deepViewEntity.RUN_PROJECTS.Where(r => r.PROJECT_NO != null);

                    if (_RunProjects.Count() > 0)

                    {

                        _result = ManualSendKcom(rev_No, document_No, document_Name, group_No, prj_No, document_Id, document_Url);

                    }

                    else

                    {

                        _result = false.ToString();

                    }

                }

            }

            catch (Exception ex)

            {

                logger.Error("Conversion Web Service ManualConvert Error", ex);

                _result = ex.Message.ToString();

                SendNotice("Project NO : " + prj_No + "\r\n  DocumentUrl : " + document_Url + "\r\n Error" + ex.ToString());

            }

            return _result;

        }

        [WebMethod]

        public string UpdateUrlEncode(string EnsembleId)

        {

            string _result = null;

            try

            {

                using (CIEntities deepViewEntity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString("").ToString()))

                {

                    var doc = deepViewEntity.DOCUMENT_ITEM.Where(data => data.ID == EnsembleId).FirstOrDefault();

                    string url = doc.ORIGINAL_FILE;

                    if (url.Contains("http://"))

                    {

                        //기존 url 이 인코딩 안되 있으면 인코딩 작업.

                        url = HttpUtility.UrlEncodeUnicode(url);

                        doc.ORIGINAL_FILE = url;

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

                        {

                            var convertdoc = kcomEntity.CONVERTER_DOC.Where(d => d.DOCUMENT_ID == doc.DOCUMENT_ID).FirstOrDefault();

                            if (convertdoc != null)

                                convertdoc.DOCUMENT_URL = url;

                            var docinfo = deepViewEntity.DOCINFO.Where(d => d.DOCUMENT_ID == doc.DOCUMENT_ID).FirstOrDefault();

                            if (docinfo != null)

                                docinfo.ORIGINAL_FILE = url;

                        }

                    }

                    deepViewEntity.SaveChanges();

                }

            }

            catch (Exception ex)

            {

                logger.Error("Conversion Web Service UpdateUrlEncode Error", ex);

                _result = ex.Message.ToString();

            }

            return _result;

        }

        public string Base64DecodeFromStr(string data)

        {

            try

            {

                System.Text.UTF8Encoding encoder = new System.Text.UTF8Encoding();

                System.Text.Decoder utf8Decode = encoder.GetDecoder();

                byte[] todecode_byte = Convert.FromBase64String(data);

                int charCount = utf8Decode.GetCharCount(todecode_byte, 0, todecode_byte.Length);

                char[] decoded_char = new char[charCount];

                utf8Decode.GetChars(todecode_byte, 0, todecode_byte.Length, decoded_char, 0);

                string result = new String(decoded_char);

                return result;

            }

            catch (Exception)

            {

                return data;

            }

        }

        public string Base64Decode(string data)

        {

            try

            {

                if(data.Contains("http://"))

                {

                    return data;

                }else

                {

                    System.Text.UTF8Encoding encoder = new System.Text.UTF8Encoding();

                    System.Text.Decoder utf8Decode = encoder.GetDecoder();

                    byte[] todecode_byte = Convert.FromBase64String(data);

                    int charCount = utf8Decode.GetCharCount(todecode_byte, 0, todecode_byte.Length);

                    char[] decoded_char = new char[charCount];

                    utf8Decode.GetChars(todecode_byte, 0, todecode_byte.Length, decoded_char, 0);

                    string result = new String(decoded_char);

                    return result;

                }

            }

            catch (Exception e)

            {

                throw new Exception("Error in Base64Decode: " + e.Message);

            }

        }

        [WebMethod]

        public string UpdateSlip(string EnsembleId, string SlipNo, string slipLink)

        {

            string _result = null;

            try

            {

                using (CIEntities deepViewEntity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString("").ToString()))

                {

                    var doc = deepViewEntity.DOCUMENT_ITEM.Where(data => data.ID == EnsembleId).FirstOrDefault();

                    if(!string.IsNullOrEmpty(slipLink))

                        doc.GROUP_NO = SlipNo;

                    if(!string.IsNullOrEmpty(slipLink))

                    {

                        if (!slipLink.Contains("http://"))

                            slipLink = Base64Decode(slipLink);

                        throw new Exception("doc.ENSEMBLEINFO_URL not support");

                        //doc.ENSEMBLEINFO_URL = slipLink;

                    }

                    deepViewEntity.SaveChanges();

                }

            }

            catch (Exception ex)

            {

                logger.Error($"Conversion Web Service UpdateSlip Error EnsembleId : {EnsembleId} SlipNo : {SlipNo}   slipLink: {slipLink}", ex);

                _result = ex.Message.ToString();                

            }

            return _result;

        }

        [WebMethod]

        public string UpdateResult(string EnsembleId, string Result, string FinalPDFUrl)

        {

            string _result = null;

            try

            {

                using (CIEntities deepViewEntity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString("").ToString()))

                {

                    var doc = deepViewEntity.DOCUMENT_ITEM.Where(data => data.ID == EnsembleId).FirstOrDefault();

                    doc.RESULT = Result;

                    doc.RESULT_FILE = FinalPDFUrl;

                    deepViewEntity.SaveChanges();

                }

            }

            catch (Exception ex)

            {

                logger.Error("Conversion Web Service UpdateResult Error", ex);

                _result = ex.Message.ToString();

            }

            return _result;

        }

        [WebMethod]

        public string UpdateVP(string EnsembleId, string rev_No, string document_No, string document_Name, string pdf_url)

        {

            string _result = null;

            try

            {

                using (CIEntities deepViewEntity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString("").ToString()))

                {

                    var doc = deepViewEntity.DOCUMENT_ITEM.Where(data => data.ID == EnsembleId).FirstOrDefault();

                    if(!string.IsNullOrEmpty(rev_No))

                        doc.REVISION = rev_No;

                    if (!string.IsNullOrEmpty(document_No))

                        doc.DOCUMENT_NO = document_No;

                    if (!string.IsNullOrEmpty(document_Name))

                        doc.DOCUMENT_NAME = document_Name;

                    if (!string.IsNullOrEmpty(pdf_url))

                    {

                        string url = pdf_url;

                        if (!doc.PROJECT_NO.Equals("150128"))

                        {   

                            url = HttpUtility.UrlEncodeUnicode(url);

                        }

                        doc.ORIGINAL_FILE = url;

                    }                        

                    deepViewEntity.SaveChanges();

                }

            }

            catch (Exception ex)

            {

                logger.Error("Conversion Web Service UpdateVP Error", ex);

                _result = ex.Message.ToString();

            }

            return _result;

        }

        [WebMethod]

		public string UpdatePDFUrl(string EnsembleId, string original_url, string result_url)

        {

            string _result = null;

            try

            {

                using (CIEntities _kcomEntity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString("").ToString()))

                {

                    var doc = _kcomEntity.DOCUMENT_ITEM.Where(data => data.ID == EnsembleId).FirstOrDefault();

                    if (!string.IsNullOrEmpty(original_url))

                    {

                        string url = original_url;

                        url = Base64Decode(url);

                        url = HttpUtility.UrlEncodeUnicode(url);

                        doc.ORIGINAL_FILE = url;

                    }

                    if (!string.IsNullOrEmpty(result_url))

                    {

                        doc.RESULT_FILE = result_url;

                    }

                    _kcomEntity.SaveChanges();

                    _result = true.ToString();

                }

            }

            catch (Exception ex)

            {

                logger.Error("Conversion Web Service UpdateVP Error", ex);

                _result = ex.Message.ToString();

            }

            return _result;

        }

        [WebMethod]

        public string DeleteVP(string id)

        {

            string _result = null;

            try

            {

                using (CIEntities _kcomEntity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString("").ToString()))

                {

                    var doc = _kcomEntity.DOCUMENT_ITEM.Where(data => data.ID == id).FirstOrDefault();

                    if (doc != null)

                    {

                        doc.DOCUMENT_NO = "VOID_" + doc.DOCUMENT_NO;

                        doc.GROUP_NO = "VOID_" + doc.GROUP_NO;

                        //deepViewEntity.DeleteObject(doc);

                        _kcomEntity.SaveChanges();

                        _result = true.ToString();

                    }

                    else

                        _result = "document not found.";

                }

            }

            catch (Exception ex)

            {

                logger.Error("Conversion Web Service DeleteVP Error", ex);

                _result = ex.Message.ToString();

            }

            return _result;

        }

        public string getDocumentID(string id)

        {

            string _doc_id = ((UInt32)id.GetHashCode()).ToString();

            return _doc_id;

        }

        [WebMethod]

        public string CoverConvert(string prj_No, string _id)

        {

            string _result = null;

            try

            {

                SendCoverConvert(prj_No, _id);

            }

            catch (Exception ex)

            {

                logger.Error("Conversion Web Service CoverConvert Error", ex);

                _result = ex.Message.ToString();

            }

            return _result;

        }

        private string SendCoverConvert(string prj_No, string _id)

        {

            if (remObj == null)

            {

                return "Window Service Connection Error";

            }

            else

            {

                var _result = remObj.SetConverterCoverPDF(prj_No, _id);

                if (_result.Exception != null)

                {

                    return false.ToString();

                }

                else

                {

                    return true.ToString();

                }

            }

        }

        private string SendKcom(string rev_No, string document_No, string document_Name, string group_No, string prj_No, string document_Id, string document_Url)

        {

            string result = false.ToString();

            if (remObj == null)

            {

                result  = "Window Service Connection Error";

            }

            else

            {

                //string _id = GetGuid(0, GuidGenerator.GetUniqueGuid()).ToString();

                string _id = shortGuid();

                string _doc_id = ((UInt32)document_Id.GetHashCode()).ToString();

                using (CIEntities _kcomEntity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString("").ToString()))

                {

                    if (string.IsNullOrEmpty(group_No))

                    {

                        group_No = "0";

                    }

                    if (!document_Url.Contains("http%3a%2f%2f"))

                    {

                        document_Url = Base64Decode(document_Url);

                        document_Url = System.Net.WebUtility.UrlEncode(document_Url);

                    }

                    document_Name = Base64DecodeFromStr(document_Name);

                    var doc = _kcomEntity.DOCUMENT_ITEM.Where(d => d.PROJECT_NO == prj_No && d.ID == document_Id).FirstOrDefault();

                    if(doc != null)

                    {

                        doc.DOCUMENT_ID = _doc_id;

                        doc.REVISION = rev_No;                        

                        doc.GROUP_NO = group_No;

                        doc.DOCUMENT_NO = document_No;

                        doc.DOCUMENT_NAME = document_Name;

                        doc.ORIGINAL_FILE = document_Url;

                    }

                    else

                    {

                        _kcomEntity.AddToDOCUMENT_ITEM(new DOCUMENT_ITEM

                        {

                            ID = document_Id,

                            REVISION = rev_No,

                            DOCUMENT_NO = document_No,

                            DOCUMENT_NAME = document_Name,

                            GROUP_NO = group_No,

                            ORIGINAL_FILE = document_Url,

                            DOCUMENT_ID = _doc_id,

                            PROJECT_NO = prj_No,

                        });

                    }

                    _kcomEntity.SaveChanges();

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

                    {

                        _entity.AddToCONVERTER_DOC(new CONVERTER_DOC

                        {

                            ID = _id,

                            CREATE_DATETIME = DateTime.Now,

                            DOCUMENT_URL = document_Url,

                            PROJECT_NO = prj_No,

                            DOCUMENT_ID = _doc_id,

                        });

                        _entity.SaveChanges();

                    }

                }

                if (Properties.Settings.Default.MARKUS_V3_PROJECTS.Split(',').Contains(prj_No))

                {

                    try

                    {

                        System.Net.WebClient client = new System.Net.WebClient();

                        var convertResult = client.DownloadString($"{Properties.Settings.Default.MARKUS_V3_ADDRESS}/Rest/ConvertAdd?ProjectNo={prj_No}&ConvertID={_id}");

                        JObject jObject = JObject.Parse(convertResult, new JsonLoadSettings());

                        result = jObject["ConvertAddResult"].ToString();

                    }

                    catch (Exception ex)

                    {

                        logger.Error("Conversion Web Service SendKcom Error", ex);

                        result = $"Markus V3 Connect Error {ex.Message}";

                    }

                }

                else

                {

                    var convertResult = remObj.SetConverterPDF(prj_No, _id);

                    if (convertResult.Exception != null)

                    {

                        result = false.ToString();

                    }

                    else

                    {

                        result = true.ToString();

                    }

                }

            }

            return result;

        }

        private string ManualSendKcom(string rev_No, string document_No, string document_Name, string group_No, string prj_No, string document_Id, string document_Url)

        {

            if (remObj == null)

            {

                return "Window Service Connection Error";

            }

            else

            {

                //string _id = GetGuid(0, GuidGenerator.GetUniqueGuid()).ToString();

                string _id = shortGuid();

                string _doc_id = ((UInt32)document_Id.GetHashCode()).ToString();

                using (CIEntities _entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString("").ToString()))

                {

                    var doc = _entity.DOCUMENT_ITEM.Where(d =>d.PROJECT_NO ==  prj_No && d.ID == document_Id).FirstOrDefault();

                    if (doc != null)

                    {

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

                        {

                            var converterdoc = kCOMEntities.CONVERTER_DOC.Where(c => c.PROJECT_NO == doc.PROJECT_NO && c.DOCUMENT_ID == doc.DOCUMENT_ID).FirstOrDefault();

                            _entity.DeleteObject(converterdoc);

                            _entity.DeleteObject(doc);

                            _entity.SaveChanges();

                        }

                        document_Url = HttpUtility.UrlDecode(document_Url);

                    }

                    int cnt = _entity.DOCUMENT_ITEM.ToList().Count;

                    if (string.IsNullOrEmpty(group_No))

                    {

                        group_No = "0";

                    }

                    _entity.AddToDOCUMENT_ITEM(new DOCUMENT_ITEM

                    {

                        ID = document_Id,

                        REVISION = rev_No,

                        DOCUMENT_NO = document_No,

                        DOCUMENT_NAME = document_Name,

                        GROUP_NO = group_No,

                        ORIGINAL_FILE = HttpUtility.UrlEncodeUnicode(document_Url),

                        DOCUMENT_ID = _doc_id,

                        PROJECT_NO = prj_No,

                    });

                    _entity.SaveChanges();

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

                    {

                        kCOMEntities.AddToCONVERTER_DOC(new CONVERTER_DOC

                        {

                            ID = _id,

                            CREATE_DATETIME = DateTime.Now,

                            DOCUMENT_URL = HttpUtility.UrlEncodeUnicode(document_Url),

                            PROJECT_NO = prj_No,

                            DOCUMENT_ID = _doc_id,

                        });

                        kCOMEntities.SaveChanges();

                    }

                }

                var _result = remObj.SetConverterPDF(prj_No, _id);

                if (_result.Exception != null)

                {

                    return false.ToString();

                }

                else

                {

                    return true.ToString();

                }

            }

        }

        //private Guid GetGuid(int Count,Guid ID)

        //{

        //    Guid _ID = ID;

        //    string _id = _ID.ToString();

        //    DeepView_Entity _entity = new DeepView_Entity(ConnectStringBuilder.DeepViewConnectionString().ToString());

        //    if (_entity.CONVERTER_DOC.Where(c => c.ID == _id).Count() > 0)

        //    {

        //        _entity.Dispose();

        //        if (Count > 10)

        //        {

        //            new Exception("GetGuid : Not Generator");

        //        }

        //        if (Count < 3)

        //        {

        //            System.Threading.Thread.Sleep(3);

        //        }

        //        GetGuid(Count++,GuidGenerator.GetUniqueGuid());

        //    }

        //    return ID;

        //}

        //GUID생성(최민수 사원 수정)

        public 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");

        }

        [WebMethod]

        public string ExcelExport(string project_no, string slip_no)

        {

            string _result = "false";

            //FileInfo fileInfo2 = new FileInfo(Path.GetTempFileName());

            //fileInfo2.FullName

            try

            {

                // Excel 첫번째 워크시트 가져오기                

                //application = new Excel.Application();

                //workbook = application.Workbooks.Open(xlsxfilepath);

                //worksheet = (Excel.Worksheet)workbook.Worksheets.get_Item("Sheet1");

                string xlsxfilepath = @"C:\WebSite\LogView\Doc_Manager\sample.xlsx";

                GemBox.Spreadsheet.SpreadsheetInfo.SetLicense("EXK0-W4HZ-N518-IMEW");

                GemBox.Spreadsheet.ExcelFile excelFile = new GemBox.Spreadsheet.ExcelFile();

                excelFile.LoadXlsx(xlsxfilepath, GemBox.Spreadsheet.XlsxOptions.PreserveMakeCopy);

                GemBox.Spreadsheet.ExcelWorksheet ws = excelFile.Worksheets[0];

                FileInfo fileInfo2 = new FileInfo(Path.GetTempFileName().Replace(".tmp", ".xlsx"));

                string fileout = @"C:\WebSite\LogView\Doc_Manager\commentexcel_" + DateTime.Now.ToString() + ".xlsx";

                string naspath = Properties.Settings.Default.Excelfilepath;

                    //@"\\172.20.121.220\comment3\TileSource\Excelexport";

                // 데이타 넣기

                int h = 6;

                int w = 1;

                //필터 기능 추가

                //Excel.Range Filter_Range = worksheet.Range["B9:" + Ran + "9"];

                //Filter_Range.AutoFilter(1, Type.Missing, Excel.XlAutoFilterOperator.xlAnd, Type.Missing, true);

                using (CIEntities deepViewEntity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString("").ToString()))

                {

                    var docs = deepViewEntity.DOCUMENT_ITEM.Where(doc => doc.GROUP_NO == slip_no && doc.PROJECT_NO == project_no).ToList();

                    if (docs.Count > 0)

                    {

                        foreach (var doc in docs)

                        {

                            var commentlist = deepViewEntity.MARKUP_DATA.Where(d => d.MARKUP_INFO_VERSION.MARKUP_INFO.DOCINFO.DOCUMENT_ID == doc.DOCUMENT_ID

                            && d.MARKUP_INFO_VERSION.MARKUP_INFO.CONSOLIDATE == 1).ToList();

                            string docNo = doc.DOCUMENT_NO;

                            string docDesc = doc.DOCUMENT_NAME;

                            string docRev = doc.REVISION;

                            foreach (var comment in commentlist)

                            {

                                var member = deepViewEntity.MEMBER.Where(m => m.ID == comment.MARKUP_INFO_VERSION.MARKUP_INFO.USER_ID).FirstOrDefault();

                                string docdept = member.DEPARTMENT;

                                string doccomment = string.Empty;

                                var data = MarkupToPDF.Serialize.Core.JsonSerializerHelper.UnCompressStringAsync(comment.DATA.ToString(),null).ConfigureAwait(false).GetAwaiter().GetResult();

                                switch (Enum.Parse(typeof(MarkupToPDF.Controls.Common.ControlType), comment.DATA_TYPE.ToString()))

                                {

                                    case MarkupToPDF.Controls.Common.ControlType.TextControl:

                                    case MarkupToPDF.Controls.Common.ControlType.TextBorder:

                                    case MarkupToPDF.Controls.Common.ControlType.TextCloud:

                                        {

                                            MarkupToPDF.Serialize.S_Control.S_TextControl instance = MarkupToPDF.Serialize.Core.JsonSerializerHelper.JsonDeserialize<MarkupToPDF.Serialize.S_Control.S_TextControl>(data);

                                            doccomment = instance.Text;

                                        }

                                        break;

                                    case MarkupToPDF.Controls.Common.ControlType.ArrowTextBorderControl:

                                    case MarkupToPDF.Controls.Common.ControlType.ArrowTextCloudControl:

                                    case MarkupToPDF.Controls.Common.ControlType.ArrowTextControl:

                                    case MarkupToPDF.Controls.Common.ControlType.ArrowTransTextBorderControl:

                                    case MarkupToPDF.Controls.Common.ControlType.ArrowTransTextCloudControl:

                                    case MarkupToPDF.Controls.Common.ControlType.ArrowTransTextControl:

                                        {

                                            MarkupToPDF.Serialize.S_Control.S_ArrowTextControl instance = MarkupToPDF.Serialize.Core.JsonSerializerHelper.JsonDeserialize<MarkupToPDF.Serialize.S_Control.S_ArrowTextControl>(data);

                                            doccomment = instance.ArrowText;

                                        }

                                        break;

                                }

                                ws.Cells[h, w].Value = string.Format("{0}\n({1})", docNo, docDesc);

                                ws.Cells[h, w + 1].Value = docRev;

                                ws.Cells[h, w + 2].Value = docdept;

                                ws.Cells[h, w + 3].Value = doccomment;

                                h++;

                            }

                        }

                    }

                    else

                    {

                        _result = "ERROR : 해당 Slip 의 데이터가 없습니다.";

                    }

                }

                int columnCount = ws.CalculateMaxUsedColumns();

                for (int i = 0; i < columnCount; i++)

                    ws.Columns[i].AutoFit();

                //worksheet.Columns.AutoFit();

                // 엑셀파일 저장

                excelFile.Save(fileInfo2.FullName);

                fileInfo2.MoveTo(naspath + "\\" + fileInfo2.Name);

                //workbook.SaveAs(fileout);

                ////workbook.Save();

                //workbook.Close(true);

                //application.Quit();

                _result = Properties.Settings.Default.Excelresulturl + fileInfo2.Name;

            }

            catch (Exception e)

            {

                _result = "ERROR : " + e.ToString();

            }

            return _result;

        }

        private static void ReleaseExcelObject(object obj)

        {

            try

            {

                if (obj != null)

                {

                    obj = null;

                }

            }

            catch (Exception ex)

            {

                obj = null;

                throw ex;

            }

            finally

            {

                GC.Collect();

            }

        }

    }

}