MARKUS

<%@ WebService Language="C#" CodeBehind="Conversion.asmx.cs" Class="ConvertionWebService.Conversion" %>

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 DeepView.Toolkit.GuidGenerator;

using MarkupToPDF;

using System.IO;

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using log4net;

using DeepViewDataModel.DataModel;

using DeepViewDataModel.Common;

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

            {

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

                {

                    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.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)

                    {

                        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)

            {

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

            {

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

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

            {

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

            {

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

                {

                    var doc = deepViewEntity.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;

                    }                    

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

                {

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

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

                    {                        

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

                {

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

                    if (doc != null)

                    {

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

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

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

                                }

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

            }

        }

    }

}

<?xml version="1.0" encoding="utf-8"?>

<Project ToolsVersion="12.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">

  <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />

  <PropertyGroup>

    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>

    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>

    <ProductVersion>

    </ProductVersion>

    <SchemaVersion>2.0</SchemaVersion>

    <ProjectGuid>{8B470D8E-ABFF-4C70-8059-0EFB51755E84}</ProjectGuid>

    <ProjectTypeGuids>{349c5851-65df-11da-9384-00065b846f21};{fae04ec0-301f-11d3-bf4b-00c04f79efbc}</ProjectTypeGuids>

    <OutputType>Library</OutputType>

    <AppDesignerFolder>Properties</AppDesignerFolder>

    <RootNamespace>ConvertionWebService</RootNamespace>

    <AssemblyName>ConvertionWebService</AssemblyName>

    <TargetFrameworkVersion>v4.5.2</TargetFrameworkVersion>

    <UseIISExpress>false</UseIISExpress>

    <FileUpgradeFlags>

    </FileUpgradeFlags>

    <UpgradeBackupLocation>

    </UpgradeBackupLocation>

    <OldToolsVersion>4.0</OldToolsVersion>

    <Use64BitIISExpress />

    <IISExpressSSLPort />

    <IISExpressAnonymousAuthentication />

    <IISExpressWindowsAuthentication />

    <IISExpressUseClassicPipelineMode />

    <UseGlobalApplicationHostFile />

    <TargetFrameworkProfile />

  </PropertyGroup>

  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">

    <DebugSymbols>true</DebugSymbols>

    <DebugType>full</DebugType>

    <Optimize>false</Optimize>

    <OutputPath>bin\</OutputPath>

    <DefineConstants>DEBUG;TRACE</DefineConstants>

    <ErrorReport>prompt</ErrorReport>

    <WarningLevel>4</WarningLevel>

    <Prefer32Bit>false</Prefer32Bit>

  </PropertyGroup>

  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">

    <DebugType>pdbonly</DebugType>

    <Optimize>true</Optimize>

    <OutputPath>bin\</OutputPath>

    <DefineConstants>

    </DefineConstants>

    <ErrorReport>prompt</ErrorReport>

    <WarningLevel>4</WarningLevel>

    <Prefer32Bit>false</Prefer32Bit>

  </PropertyGroup>

  <ItemGroup>

    <Reference Include="ConverterPDF, Version=0.0.0.0, Culture=neutral, processorArchitecture=MSIL">

      <SpecificVersion>False</SpecificVersion>

      <HintPath>..\Old_lib\ConverterPDF.dll</HintPath>

    </Reference>

    <Reference Include="DeepView.Toolkit.GuidGenerator, Version=1.0.0.0, Culture=neutral, processorArchitecture=MSIL">

      <SpecificVersion>False</SpecificVersion>

      <HintPath>..\Old_lib\DeepView.Toolkit.GuidGenerator.dll</HintPath>

    </Reference>

    <Reference Include="DeepViewDataModel, Version=1.0.0.0, Culture=neutral, processorArchitecture=AMD64">

      <SpecificVersion>False</SpecificVersion>

      <HintPath>..\Old_lib\daelim\DeepViewDataModel.dll</HintPath>

    </Reference>

    <Reference Include="GemBox.Spreadsheet, Version=39.3.30.1215, Culture=neutral, PublicKeyToken=b1b72c69714d4847, processorArchitecture=MSIL">

      <HintPath>..\packages\GemBox.Spreadsheet.39.3.30.1215\lib\net30\GemBox.Spreadsheet.dll</HintPath>

    </Reference>

    <Reference Include="log4net, Version=2.0.8.0, Culture=neutral, PublicKeyToken=669e0ddf0bb1aa2a, processorArchitecture=MSIL">

      <HintPath>..\packages\log4net.2.0.8\lib\net45-full\log4net.dll</HintPath>

    </Reference>

    <Reference Include="MarkupToPDF">

      <HintPath>..\Old_lib\MarkupToPDF.dll</HintPath>

    </Reference>

    <Reference Include="Microsoft.CSharp" />

    <Reference Include="Newtonsoft.Json, Version=12.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed, processorArchitecture=MSIL">

      <HintPath>..\packages\Newtonsoft.Json.12.0.2\lib\net40\Newtonsoft.Json.dll</HintPath>

    </Reference>

    <Reference Include="System.Data.DataSetExtensions" />

    <Reference Include="System.Data.Entity" />

    <Reference Include="System.Runtime.Remoting" />

    <Reference Include="System.Runtime.Serialization" />

    <Reference Include="System.ServiceModel" />

    <Reference Include="System.Web.DynamicData" />

    <Reference Include="System.Web.Entity" />

    <Reference Include="System.Web.ApplicationServices" />

    <Reference Include="System" />

    <Reference Include="System.Data" />

    <Reference Include="System.Web.Extensions" />

    <Reference Include="System.Drawing" />

    <Reference Include="System.Web" />

    <Reference Include="System.Xml" />

    <Reference Include="System.Configuration" />

    <Reference Include="System.Web.Services" />

    <Reference Include="System.EnterpriseServices" />

    <Reference Include="System.Xml.Linq" />

  </ItemGroup>

  <ItemGroup>

    <Content Include="Conversion.asmx" />

    <None Include="..\Markus.Service.Station\Log.config">

      <Link>Log.config</Link>

      <CopyToOutputDirectory>Always</CopyToOutputDirectory>

    </None>

    <Content Include="DeepViewDataModel.dll.config">

      <CopyToOutputDirectory>Always</CopyToOutputDirectory>

    </Content>

    <None Include="packages.config" />

    <None Include="Properties\PublishProfiles\FILE.pubxml" />

    <Content Include="Web.config" />

    <Content Include="Web.Debug.config">

      <DependentUpon>Web.config</DependentUpon>

    </Content>

    <Content Include="Web.Release.config">

      <DependentUpon>Web.config</DependentUpon>

    </Content>

  </ItemGroup>

  <ItemGroup>

    <Compile Include="Conversion.asmx.cs">

      <DependentUpon>Conversion.asmx</DependentUpon>

      <SubType>Component</SubType>

    </Compile>

    <Compile Include="Properties\AssemblyInfo.cs" />

    <Compile Include="Properties\Settings.Designer.cs">

      <AutoGen>True</AutoGen>

      <DesignTimeSharedInput>True</DesignTimeSharedInput>

      <DependentUpon>Settings.settings</DependentUpon>

    </Compile>

  </ItemGroup>

  <ItemGroup>

    <None Include="Properties\Settings.settings">

      <Generator>SettingsSingleFileGenerator</Generator>

      <LastGenOutput>Settings.Designer.cs</LastGenOutput>

    </None>

  </ItemGroup>

  <ItemGroup>

    <WCFMetadata Include="Service References\" />

  </ItemGroup>

  <ItemGroup>

    <COMReference Include="VBIDE">

      <Guid>{0002E157-0000-0000-C000-000000000046}</Guid>

      <VersionMajor>5</VersionMajor>

      <VersionMinor>3</VersionMinor>

      <Lcid>0</Lcid>

      <WrapperTool>primary</WrapperTool>

      <Isolated>False</Isolated>

      <EmbedInteropTypes>True</EmbedInteropTypes>

    </COMReference>

  </ItemGroup>

  <ItemGroup>

    <ProjectReference Include="..\Markus.Service.DataBase\Markus.Service.DataBase.csproj">

      <Project>{400736fb-92c9-4bc0-b447-e8274103d813}</Project>

      <Name>Markus.Service.DataBase</Name>

    </ProjectReference>

  </ItemGroup>

  <PropertyGroup>

    <VisualStudioVersion Condition="'$(VisualStudioVersion)' == ''">10.0</VisualStudioVersion>

    <VSToolsPath Condition="'$(VSToolsPath)' == ''">$(MSBuildExtensionsPath32)\Microsoft\VisualStudio\v$(VisualStudioVersion)</VSToolsPath>

  </PropertyGroup>

  <PropertyGroup Condition="'$(Configuration)|$(Platform)' == 'Debug|x64'">

    <DebugSymbols>true</DebugSymbols>

    <OutputPath>bin\</OutputPath>

    <DefineConstants>DEBUG;TRACE</DefineConstants>

    <DebugType>full</DebugType>

    <PlatformTarget>x64</PlatformTarget>

    <ErrorReport>prompt</ErrorReport>

    <CodeAnalysisRuleSet>MinimumRecommendedRules.ruleset</CodeAnalysisRuleSet>

    <Prefer32Bit>false</Prefer32Bit>

  </PropertyGroup>

  <PropertyGroup Condition="'$(Configuration)|$(Platform)' == 'Release|x64'">

    <OutputPath>bin\</OutputPath>

    <Optimize>true</Optimize>

    <DebugType>pdbonly</DebugType>

    <PlatformTarget>x64</PlatformTarget>

    <ErrorReport>prompt</ErrorReport>

    <CodeAnalysisRuleSet>MinimumRecommendedRules.ruleset</CodeAnalysisRuleSet>

    <Prefer32Bit>false</Prefer32Bit>

  </PropertyGroup>

  <Import Project="$(MSBuildBinPath)\Microsoft.CSharp.targets" />

  <Import Project="$(VSToolsPath)\WebApplications\Microsoft.WebApplication.targets" Condition="'$(VSToolsPath)' != ''" />

  <Import Project="$(MSBuildExtensionsPath32)\Microsoft\VisualStudio\v10.0\WebApplications\Microsoft.WebApplication.targets" Condition="false" />

  <ProjectExtensions>

    <VisualStudio>

      <FlavorProperties GUID="{349c5851-65df-11da-9384-00065b846f21}">

        <WebProjectProperties>

          <UseIIS>False</UseIIS>

          <AutoAssignPort>True</AutoAssignPort>

          <DevelopmentServerPort>5295</DevelopmentServerPort>

          <DevelopmentServerVPath>/</DevelopmentServerVPath>

          <IISUrl>

          </IISUrl>

          <NTLMAuthentication>False</NTLMAuthentication>

          <UseCustomServer>False</UseCustomServer>

          <CustomServerUrl>

          </CustomServerUrl>

          <SaveServerSettingsInUserFile>False</SaveServerSettingsInUserFile>

        </WebProjectProperties>

      </FlavorProperties>

    </VisualStudio>

  </ProjectExtensions>

  <!-- To modify your build process, add your task inside one of the targets below and uncomment it. 

       Other similar extension points exist, see Microsoft.Common.targets.

  <Target Name="BeforeBuild">

  </Target>

  <Target Name="AfterBuild">

  </Target>

  -->

</Project>

<?xml version="1.0" encoding="utf-8"?>

<configuration>

  <configSections>

    <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

      <section name="DeepViewDataModel.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />

    </sectionGroup>

    <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

      <section name="DeepViewDataModel.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />

    </sectionGroup>

  </configSections>

  <connectionStrings>

    <add name="DeepView_Entity" connectionString="metadata=res://*/DataModel.DeepView_Entity.csdl|res://*/DataModel.DeepView_Entity.ssdl|res://*/DataModel.DeepView_Entity.msl;provider=System.Data.SqlClient;provider=System.Data.SqlClient;provider connection string=&quot;data source=DESKTOP-MARKUS;initial catalog=Markus_V3;persist security info=True;user id=doftech;password=dof1073#;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

  </connectionStrings

  >

  <applicationSettings>

    <DeepViewDataModel.Properties.Settings>

      <setting name="ConverterConnectionString" serializeAs="String">

        <value>data source=.\SQLEXPRESS;initial catalog=Markus;persist security info=True;user id=ConvertService;Password=ConvertService;MultipleActiveResultSets=True;</value>

      </setting>

    </DeepViewDataModel.Properties.Settings>

  </applicationSettings>

</configuration>

using System.Reflection;

using System.Runtime.CompilerServices;

using System.Runtime.InteropServices;

// General Information about an assembly is controlled through the following 

// set of attributes. Change these attribute values to modify the information

// associated with an assembly.

[assembly: AssemblyTitle("ConvertionWebService")]

[assembly: AssemblyDescription("")]

[assembly: AssemblyConfiguration("")]

[assembly: AssemblyCompany("")]

[assembly: AssemblyProduct("ConvertionWebService")]

[assembly: AssemblyCopyright("Copyright ©  2012")]

[assembly: AssemblyTrademark("")]

[assembly: AssemblyCulture("")]

// Setting ComVisible to false makes the types in this assembly not visible 

// to COM components.  If you need to access a type in this assembly from 

// COM, set the ComVisible attribute to true on that type.

[assembly: ComVisible(false)]

// The following GUID is for the ID of the typelib if this project is exposed to COM

[assembly: Guid("3e66fa28-1d2a-4e90-be07-3d3bd749b62c")]

// Version information for an assembly consists of the following four values:

//

//      Major Version

//      Minor Version 

//      Build Number

//      Revision

//

// You can specify all the values or you can default the Revision and Build Numbers 

// by using the '*' as shown below:

[assembly: AssemblyVersion("2.5.6.0")]

[assembly: AssemblyFileVersion("2.5.6.0")]

[assembly: log4net.Config.XmlConfigurator(ConfigFile = "Log.config", Watch = true)]

<?xml version="1.0" encoding="utf-8"?>

<!--

This file is used by the publish/package process of your Web project. You can customize the behavior of this process

by editing this MSBuild file. In order to learn more about this please visit http://go.microsoft.com/fwlink/?LinkID=208121. 

-->

<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">

  <PropertyGroup>

    <WebPublishMethod>FileSystem</WebPublishMethod>

    <LastUsedBuildConfiguration>Release</LastUsedBuildConfiguration>

    <LastUsedPlatform>Any CPU</LastUsedPlatform>

    <SiteUrlToLaunchAfterPublish />

    <ExcludeApp_Data>False</ExcludeApp_Data>

    <publishUrl>D:\Source\MarkusTemp\ServiceBase\ConvertionWebServicePublish</publishUrl>

    <DeleteExistingFiles>True</DeleteExistingFiles>

    <LaunchSiteAfterPublish>True</LaunchSiteAfterPublish>

  </PropertyGroup>

</Project>

//------------------------------------------------------------------------------

// <auto-generated>

//     이 코드는 도구를 사용하여 생성되었습니다.

//     런타임 버전:4.0.30319.42000

//

//     파일 내용을 변경하면 잘못된 동작이 발생할 수 있으며, 코드를 다시 생성하면

//     이러한 변경 내용이 손실됩니다.

// </auto-generated>

//------------------------------------------------------------------------------

namespace ConvertionWebService.Properties {

    [global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()]

    [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator", "15.9.0.0")]

    internal sealed partial class Settings : global::System.Configuration.ApplicationSettingsBase {

        private static Settings defaultInstance = ((Settings)(global::System.Configuration.ApplicationSettingsBase.Synchronized(new Settings())));

        public static Settings Default {

            get {

                return defaultInstance;

            }

        }

        [global::System.Configuration.ApplicationScopedSettingAttribute()]

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.Configuration.DefaultSettingValueAttribute("")]

        public string ErrorNoticeID {

            get {

                return ((string)(this["ErrorNoticeID"]));

            }

        }

        [global::System.Configuration.ApplicationScopedSettingAttribute()]

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.Configuration.DefaultSettingValueAttribute("000000,111111")]

        public string MARKUS_V3_PROJECTS {

            get {

                return ((string)(this["MARKUS_V3_PROJECTS"]));

            }

        }

        [global::System.Configuration.ApplicationScopedSettingAttribute()]

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.Configuration.DefaultSettingValueAttribute("http://localhost:9101/StationService")]

        public string MARKUS_V3_ADDRESS {

            get {

                return ((string)(this["MARKUS_V3_ADDRESS"]));

            }

        }

        [global::System.Configuration.ApplicationScopedSettingAttribute()]

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.Configuration.DefaultSettingValueAttribute("http://172.20.120.141:5977/TileSource/Excelexport/")]

        public string Excelresulturl {

            get {

                return ((string)(this["Excelresulturl"]));

            }

        }

        [global::System.Configuration.ApplicationScopedSettingAttribute()]

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.Configuration.DefaultSettingValueAttribute("\\\\172.20.121.220\\comment3\\TileSource\\Excelexport")]

        public string Excelfilepath {

            get {

                return ((string)(this["Excelfilepath"]));

            }

        }

        [global::System.Configuration.ApplicationScopedSettingAttribute()]

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.Configuration.DefaultSettingValueAttribute("tcp://localhost:8091/remConverterPDF")]

        public string ConverterRemotingUrl {

            get {

                return ((string)(this["ConverterRemotingUrl"]));

            }

        }

    }

}

<?xml version='1.0' encoding='utf-8'?>

<SettingsFile xmlns="http://schemas.microsoft.com/VisualStudio/2004/01/settings" CurrentProfile="(Default)" GeneratedClassNamespace="ConvertionWebService.Properties" GeneratedClassName="Settings">

  <Profiles />

  <Settings>

    <Setting Name="ErrorNoticeID" Type="System.String" Scope="Application">

      <Value Profile="(Default)" />

    </Setting>

    <Setting Name="MARKUS_V3_PROJECTS" Type="System.String" Scope="Application">

      <Value Profile="(Default)">000000,111111</Value>

    </Setting>

    <Setting Name="MARKUS_V3_ADDRESS" Type="System.String" Scope="Application">

      <Value Profile="(Default)">http://localhost:9101/StationService</Value>

    </Setting>

    <Setting Name="Excelresulturl" Type="System.String" Scope="Application">

      <Value Profile="(Default)">http://172.20.120.141:5977/TileSource/Excelexport/</Value>

    </Setting>

    <Setting Name="Excelfilepath" Type="System.String" Scope="Application">

      <Value Profile="(Default)">\\172.20.121.220\comment3\TileSource\Excelexport</Value>

    </Setting>

    <Setting Name="ConverterRemotingUrl" Type="System.String" Scope="Application">

      <Value Profile="(Default)">tcp://localhost:8091/remConverterPDF</Value>

    </Setting>

  </Settings>

</SettingsFile>

<?xml version="1.0"?>

<!-- For more information on using web.config transformation visit http://go.microsoft.com/fwlink/?LinkId=125889 -->

<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">

  <!--

    In the example below, the "SetAttributes" transform will change the value of 

    "connectionString" to use "ReleaseSQLServer" only when the "Match" locator 

    finds an atrribute "name" that has a value of "MyDB".

    <connectionStrings>

      <add name="MyDB" 

        connectionString="Data Source=ReleaseSQLServer;Initial Catalog=MyReleaseDB;Integrated Security=True" 

        xdt:Transform="SetAttributes" xdt:Locator="Match(name)"/>

    </connectionStrings>

  -->

  <system.web>

    <!--

      In the example below, the "Replace" transform will replace the entire 

      <customErrors> section of your web.config file.

      Note that because there is only one customErrors section under the 

      <system.web> node, there is no need to use the "xdt:Locator" attribute.

      <customErrors defaultRedirect="GenericError.htm"

        mode="RemoteOnly" xdt:Transform="Replace">

        <error statusCode="500" redirect="InternalError.htm"/>

      </customErrors>

    -->

  </system.web>

</configuration>

<?xml version="1.0"?>

<!-- For more information on using web.config transformation visit http://go.microsoft.com/fwlink/?LinkId=125889 -->

<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">

  <!--

    In the example below, the "SetAttributes" transform will change the value of 

    "connectionString" to use "ReleaseSQLServer" only when the "Match" locator 

    finds an atrribute "name" that has a value of "MyDB".

    <connectionStrings>

      <add name="MyDB" 

        connectionString="Data Source=ReleaseSQLServer;Initial Catalog=MyReleaseDB;Integrated Security=True" 

        xdt:Transform="SetAttributes" xdt:Locator="Match(name)"/>

    </connectionStrings>

  -->

  <system.web>

    <compilation xdt:Transform="RemoveAttributes(debug)" />

    <!--

      In the example below, the "Replace" transform will replace the entire 

      <customErrors> section of your web.config file.

      Note that because there is only one customErrors section under the 

      <system.web> node, there is no need to use the "xdt:Locator" attribute.

      <customErrors defaultRedirect="GenericError.htm"

        mode="RemoteOnly" xdt:Transform="Replace">

        <error statusCode="500" redirect="InternalError.htm"/>

      </customErrors>

    -->

  </system.web>

</configuration>

<?xml version="1.0"?>

<!--

  For more information on how to configure your ASP.NET application, please visit

  http://go.microsoft.com/fwlink/?LinkId=169433

  -->

<configuration>

  <configSections>

    <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

      <section name="ConvertionWebService.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>

    </sectionGroup>

  </configSections>

  <!--

    web.config 변경 내용에 대한 설명은  http://go.microsoft.com/fwlink/?LinkId=235367을 참고하십시오.

    다음 특성은 <httpRuntime> 태그에 설정할 수 있습니다.

      <system.Web>

        <httpRuntime targetFramework="4.5.2" />

      </system.Web>

  -->

  <system.web>

    <compilation debug="true" targetFramework="4.5.2"/>

    <pages controlRenderingCompatibilityVersion="4.0"/>

  </system.web>

  <applicationSettings>

    <ConvertionWebService.Properties.Settings>

      <setting name="ErrorNoticeID" serializeAs="String">

        <value />

      </setting>

      <setting name="MARKUS_V3_PROJECTS" serializeAs="String">

        <value>000000,111111</value>

      </setting>

      <setting name="MARKUS_V3_ADDRESS" serializeAs="String">

        <value>http://localhost:9101/StationService</value>

      </setting>

      <setting name="Excelresulturl" serializeAs="String">

        <value>http://172.20.120.141:5977/TileSource/Excelexport/</value>

      </setting>

      <setting name="Excelfilepath" serializeAs="String">

        <value>\\172.20.121.220\comment3\TileSource\Excelexport</value>

      </setting>

      <setting name="ConverterRemotingUrl" serializeAs="String">

        <value>tcp://localhost:8091/remConverterPDF</value>

      </setting>

    </ConvertionWebService.Properties.Settings>

  </applicationSettings>

  <system.serviceModel>

    <bindings/>

    <client/>

  </system.serviceModel>

</configuration>

<?xml version="1.0" encoding="utf-8"?>

<packages>

  <package id="GemBox.Spreadsheet" version="39.3.30.1215" targetFramework="net452" />

  <package id="log4net" version="2.0.8" targetFramework="net452" />

  <package id="Newtonsoft.Json" version="12.0.2" targetFramework="net40" requireReinstallation="true" />

</packages>