MARKUS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Services;

using System.Runtime.Remoting.Channels;

using System.Runtime.Remoting.Channels.Tcp;

using IConverterPDF;

using System.Text;

using DeepViewDataModel.DataModel;

using DeepViewDataModel.Common;

using DeepView.Toolkit.GuidGenerator;

using Excel = Microsoft.Office.Interop.Excel;

using MarkupToPDF;

using System.IO;

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using log4net;

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)

            {

                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

            {

                using (DeepView_Entity deepViewEntity = new DeepView_Entity(ConnectStringBuilder.DeepViewConnectionString().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)

            {

                _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 (DeepView_Entity deepViewEntity = new DeepView_Entity(ConnectStringBuilder.DeepViewConnectionString().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 (DeepView_Entity _entity = new DeepView_Entity(ConnectStringBuilder.DeepViewConnectionString().ToString()))

                {

                    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();

                            }

                        }

                        var converterdoc = _entity.CONVERTER_DOC.Where(c => 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";

                    }

                    if (!prj_No.Equals("150128"))

                    {

                        //Omsk 는 웹서비스 호출 시 인코딩

                        //Omsk 제외는 Markus 에서 인코딩

                        document_Url = HttpUtility.UrlEncodeUnicode(document_Url);

                    }

                    _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.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}&DocumentID={_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 (DeepView_Entity deepViewEntity = new DeepView_Entity(ConnectStringBuilder.DeepViewConnectionString().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)

            {

                _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 (DeepView_Entity deepViewEntity = new DeepView_Entity(ConnectStringBuilder.DeepViewConnectionString().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;

                        var convertdoc = deepViewEntity.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)

            {

                _result = ex.Message.ToString();

            }

            return _result;

        }

        public string Base64Decode(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 e)

            {

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

            }

        }

        [WebMethod]

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

        {

            string _result = null;

            try

            {

                using (DeepView_Entity deepViewEntity = new DeepView_Entity(ConnectStringBuilder.DeepViewConnectionString().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);

                        doc.ENSEMBLEINFO_URL = slipLink;

                    }

                    deepViewEntity.SaveChanges();

                }

            }

            catch (Exception ex)

            {

                _result = ex.Message.ToString();                

            }

            return _result;

        }

        [WebMethod]

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

        {

            string _result = null;

            try

            {

                using (DeepView_Entity deepViewEntity = new DeepView_Entity(ConnectStringBuilder.DeepViewConnectionString().ToString()))

                {

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

                    doc.RESULT = Result;

                    doc.RESULT_FILE = FinalPDFUrl;

                    deepViewEntity.SaveChanges();

                }

            }

            catch (Exception 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 (DeepView_Entity deepViewEntity = new DeepView_Entity(ConnectStringBuilder.DeepViewConnectionString().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)

            {

                _result = ex.Message.ToString();

            }

            return _result;

        }

        [WebMethod]

        public string CoverConvert(string prj_No, string _id)

        {

            string _result = null;

            try

            {

                SendCoverConvert(prj_No, _id);

            }

            catch (Exception 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 (DeepView_Entity _entity = new DeepView_Entity(ConnectStringBuilder.DeepViewConnectionString().ToString()))

                {                    

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

                    if(doc != null)

                    {

                        var converterdoc = _entity.CONVERTER_DOC.Where(c => 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";

                    }

                    if (!prj_No.Equals("150128"))

                    {

                        //Omsk 는 웹서비스 호출 시 인코딩

                        //Omsk 제외는 Markus 에서 인코딩

                        document_Url = HttpUtility.UrlEncodeUnicode(document_Url);

                    }

                    _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.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}&DocumentID={_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;

        }

        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 (DeepView_Entity _entity = new DeepView_Entity(ConnectStringBuilder.DeepViewConnectionString().ToString()))

                {

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

                    if (doc != null)

                    {

                        var converterdoc = _entity.CONVERTER_DOC.Where(c => 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.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,

                    });

                    _entity.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";

            Excel.Application application = null;

            Excel.Workbook workbook = null;

            Excel.Worksheet worksheet = null;

            string xlsxfilepath = @"D:\sample.xlsx";

            string fileout = @"D:\CommentExport_" + DateTime.Now.ToString() + ".xlsx";

            try

            {

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

                application = new Excel.Application();

                workbook = application.Workbooks.Open(xlsxfilepath);

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

                // 데이타 넣기

                int h = 6;

                int w = 2;

                //필터 기능 추가

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

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

                using (DeepView_Entity deepViewEntity = new DeepView_Entity(ConnectStringBuilder.DeepViewConnectionString().ToString()))

                {

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

                    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.UnCompressString(comment.DATA.ToString());

                            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;

                            }

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

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

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

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

                            h++;

                        }

                    }

                }

                worksheet.Columns.AutoFit();

                // 엑셀파일 저장

                workbook.SaveAs(fileout);

                //workbook.Save();

                workbook.Close(true);

                application.Quit();

                _result = fileout;

            }

            catch(Exception e)

            {

                _result = e.Message;

            }

            finally

            {

                System.Diagnostics.Process[] ExCel = System.Diagnostics.Process.GetProcessesByName("EXCEL");

                if (ExCel.Count() != 0)

                {

                    ExCel[0].Kill();

                }

                // Clean up

                ReleaseExcelObject(worksheet);

                ReleaseExcelObject(workbook);

                ReleaseExcelObject(application);

            }

            return _result;

        }

        private static void ReleaseExcelObject(object obj)

        {

            try

            {

                if (obj != null)

                {

                    obj = null;

                }

            }

            catch (Exception ex)

            {

                obj = null;

                throw ex;

            }

            finally

            {

                GC.Collect();

            }

        }

    }

}