MARKUS

using IFinalPDF;

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data.Entity.Core.Objects;

using System.Linq;

using System.Runtime.Remoting.Channels.Tcp;

//using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Activation;

using System.Text;

namespace StationControllerService

{

    // 참고: "리팩터링" 메뉴에서 "이름 바꾸기" 명령을 사용하여 코드, svc 및 config 파일에서 클래스 이름 "DataService"을 변경할 수 있습니다.

    // 참고: 이 서비스를 테스트하기 위해 WCF 테스트 클라이언트를 시작하려면 솔루션 탐색기에서 DataService.svc나 DataService.svc.cs를 선택하고 디버깅을 시작하십시오.

    //[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]

    public class DataService : IDataService

    {

        public List<SELECT_CONVERT_ITEM_Result> GET_SELECT_CONVERT_ITEM(string p_ID, string p_PROJECT_NO, string p_DOCUMENT_ID, Nullable<int> p_STATUS, Nullable<int> p_TAKE_COUNT, Nullable<System.DateTime> p_BEGIN_CREATE_DATETIME, Nullable<System.DateTime> p_FINISH_CREATE_DATETIME, Nullable<System.DateTime> p_BEGIN_START_DATETIE, Nullable<System.DateTime> p_FINISH_START_DATETIME, Nullable<System.DateTime> p_BEGIN_END_DATETIME, Nullable<System.DateTime> p_FINISH_END_DATETIME, string p_GROUP_NO, string p_DOCUMENT_NAME, string p_DOCUMENT_NO, string p_REVISION, string p_SERVICE_ID, Nullable<int> p_RECONVERTER, string p_DOCUMENT_URL, Nullable<int> p_ExcptionCheck)

        {

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

            try

            {

                ///var connectionstring = Properties.Resources.ConnectionString;

                using (markusEntities entities = new markusEntities())

                {

                    result = entities.SELECT_CONVERT_ITEM(p_ID, p_PROJECT_NO, p_DOCUMENT_ID, p_STATUS, p_TAKE_COUNT, p_BEGIN_CREATE_DATETIME, p_FINISH_CREATE_DATETIME, p_BEGIN_START_DATETIE, p_FINISH_START_DATETIME, p_BEGIN_END_DATETIME, p_FINISH_END_DATETIME, p_GROUP_NO, p_DOCUMENT_NAME, p_DOCUMENT_NO, p_REVISION, p_SERVICE_ID, p_RECONVERTER, p_DOCUMENT_URL, p_ExcptionCheck).ToList();

                    //System.Diagnostics.Debug.WriteLine("GET_SELECT_CONVERT_ITEM result count :" + result.Count());

                }

            }

            catch (Exception)

            {

                throw new FaultException("GET_SELECT_CONVERT_ITEM");

            }

            return result;

        }

        public int GET_SELECT_RERECONVERT_ITEM(string p_ID, Nullable<int> p_RECONVERTER, Nullable<System.DateTime> p_CREATE_DATETIME, Nullable<int> p_STATUS, Nullable<System.DateTime> p_END_DATETIME)

        {

            int result;

            try

            {

                //var connectionstring = Properties.Resources.ConnectionString;

                using (markusEntities entities = new markusEntities())

                {

                    result = entities.SELECT_RERECONVERT_ITEM(p_ID, p_RECONVERTER, p_CREATE_DATETIME, p_STATUS, p_END_DATETIME);

                }

            }

            catch (Exception)

            {

                throw new FaultException("GET_SELECT_RERECONVERT_ITEM");

            }

            return result;

        }

        public int GET_SELECT_CONVERT_DELETE(string p_ID)

        {

            int result;

            try

            {

                //var connectionstring = Properties.Resources.ConnectionString;

                using (markusEntities entities = new markusEntities())

                {

                    result = entities.SELECT_CONVERT_DELETE(p_ID);

                }

            }

            catch (Exception)

            {

                throw new FaultException("GET_SELECT_CONVERT_DELETE");

            }

            return result;

        }

        public List<SELECT_RUN_PROJECTS_Result> GET_SELECT_RUN_PROJECTS(int p_RUN_PROJECTS)

        {

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

            try

            {

                //var connectionstring = Properties.Resources.ConnectionString;

                using (markusEntities entities = new markusEntities())

                {

                    result = entities.SELECT_RUN_PROJECTS(p_RUN_PROJECTS).ToList();

                }

            }

            catch (Exception ex)

            {

                System.Diagnostics.Debug.WriteLine(ex);

                throw new FaultException("GET_SELECT_RUN_PROJECTS");

            }

            return result;

        }

        public int GET_SELECT_CONVERT_INSERT(string p_ID, string p_PROJECT_NO, string p_DOCUMENT_URL, string p_DOCUMENT_ID)

        {

            int result;

            try

            {

                //var connectionstring = Properties.Resources.ConnectionString;

                using (markusEntities entities = new markusEntities())

                {

                    result = entities.SELECT_CONVERT_INSERT(p_ID, p_PROJECT_NO, p_DOCUMENT_URL, p_DOCUMENT_ID);

                }

            }

            catch (Exception)

            {

                throw new FaultException("GET_SELECT_FINAL_PDF_INSERT");

            }

            return result;

        }

        public List<SELECT_FINAL_PDF_ITEM_Result> GET_SELECT_FINAL_PDF_ITEM(string p_ID, string p_PROJECT_NO, string p_DOCUMENT_ID, string p_MARKUPINFO_ID, string p_DOCINFO_ID, string p_DOCUMENT_NAME, string p_DOCUMENT_NO, string p_CREATE_USER_ID, Nullable<int> p_STATUS, Nullable<int> p_TAKE_COUNT, string p_GROUP_NO, string p_REVISION, Nullable<System.DateTime> p_BEGIN_CREATE_DATETIME, Nullable<System.DateTime> p_FINISH_CREATE_DATETIME, Nullable<System.DateTime> p_BEGIN_START_DATETIE, Nullable<System.DateTime> p_FINISH_START_DATETIME, Nullable<System.DateTime> p_BEGIN_END_DATETIME, Nullable<System.DateTime> p_FINISH_END_DATETIME, string p_DOCUMENT_URL, Nullable<int> p_ExcptionCheck)

        {

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

            try

            {

                //var connectionstring = Properties.Resources.ConnectionString;

                using (markusEntities entities = new markusEntities())

                {

                    result = entities.SELECT_FINAL_PDF_ITEM(p_ID, p_PROJECT_NO, p_DOCUMENT_ID, p_MARKUPINFO_ID, p_DOCINFO_ID, p_DOCUMENT_NAME, p_DOCUMENT_NO, p_CREATE_USER_ID, p_STATUS, p_TAKE_COUNT, p_GROUP_NO, p_REVISION, p_BEGIN_CREATE_DATETIME, p_FINISH_CREATE_DATETIME, p_BEGIN_START_DATETIE, p_FINISH_START_DATETIME, p_BEGIN_END_DATETIME, p_FINISH_END_DATETIME, p_DOCUMENT_URL, p_ExcptionCheck).ToList();

                }

            }

            catch (Exception)

            {

                throw new FaultException("GET_SELECT_FINAL_PDF_ITEM");

            }

            return result;

        }

        public int GET_SELECT_FINAL_PDF_DELETE(string p_ID)

        {

            int result;

            try

            {

                //var connectionstring = Properties.Resources.ConnectionString;

                using (markusEntities entities = new markusEntities())

                {

                    result = entities.SELECT_FINAL_PDF_DELETE(p_ID);

                }

            }

            catch (Exception)

            {

                throw new FaultException("GET_SELECT_FINAL_PDF_DELETE");

            }

            return result;

        }

        public int GET_SELECT_FINAL_PDF_INSERT(string p_ID, string p_PROJECT_NO, string p_DOCUMENT_URL, string p_DOCUMENT_ID)

        {

            int result;

            try

            {

                //var connectionstring = Properties.Resources.ConnectionString;

                using (markusEntities entities = new markusEntities())

                {

                    result = entities.SELECT_FINAL_PDF_INSERT(p_ID, p_PROJECT_NO, p_DOCUMENT_URL, p_DOCUMENT_ID, null, null, null, null);

                }

            }

            catch (Exception)

            {

                throw new FaultException("GET_SELECT_FINAL_PDF_INSERT");

            }

            return result;

        }

        public List<FINALPDF_COUNT_Result> GET_FINALPDF_COUNT(Nullable<int> p_STATUS, Nullable<System.DateTime> p_BEGIN_CREATE_DATETIME, Nullable<System.DateTime> p_FINISH_CREATE_DATETIME)

        {

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

            try

            {

                //var connectionstring = Properties.Resources.ConnectionString;

                using (markusEntities entities = new markusEntities())

                {

                    result = entities.FINALPDF_COUNT(p_STATUS, p_BEGIN_CREATE_DATETIME, p_FINISH_CREATE_DATETIME).ToList();

                }

            }

            catch (Exception)

            {

                throw new FaultException("GET_FINALPDF_COUNT");

            }

            return result;

        }

        public List<CONVERT_COUNT_Result> GET_CONVERT_COUNT(Nullable<int> p_STATUS, Nullable<System.DateTime> p_BEGIN_CREATE_DATETIME, Nullable<System.DateTime> p_FINISH_CREATE_DATETIME)

        {

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

            try

            {

                //var connectionstring = Properties.Resources.ConnectionString;

                using (markusEntities entities = new markusEntities())

                {

                    result = entities.CONVERT_COUNT(p_STATUS, p_BEGIN_CREATE_DATETIME, p_FINISH_CREATE_DATETIME).ToList();

                }

            }

            catch (Exception)

            {

                throw new FaultException("GET_CONVERT_COUNT");

            }

            return result;

        }

        public List<SELECT_DOCUMENT_ITEM_Result> GET_DOCUMENT_ITEM(Nullable<int> p_TAKE_COUNT, string p_REVISION, string p_DOCUMENT_N0, string p_DOCUMENT_NAME, string p_GROUP_N0, string p_ORIGINAL_FILE, string p_DOCUMENT_ID, string p_PROJECT_NO)

        {

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

            try

            {

                //var connectionstring = Properties.Resources.ConnectionString;

                using (markusEntities entities = new markusEntities())

                {

                    result = entities.SELECT_DOCUMENT_ITEM(p_TAKE_COUNT, p_REVISION, p_DOCUMENT_N0, p_DOCUMENT_NAME, p_GROUP_N0, p_ORIGINAL_FILE, p_DOCUMENT_ID, p_PROJECT_NO).ToList();

                }

            }

            catch (Exception ex)

            {

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

                throw new FaultException("GET_DOCUMENT_ITEM");

            }

            return result;

        }

        public List<SELECT_PROPERTIES_RUN_PROJECTS_Result> GET_PROPERTIES_RUN_PROJECTS(string p_PROJECT_NO)

        {

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

            try

            {

                //var connectionstring = Properties.Resources.ConnectionString;

                using (markusEntities entities = new markusEntities())

                {

                    result = entities.SELECT_PROPERTIES_RUN_PROJECTS(p_PROJECT_NO).ToList();

                }

            }

            catch (Exception ex)

            {

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

                throw new FaultException("GET_PROPERTIES_RUN_PROJECTS");

            }

            return result;

        }

        public int GET_RUNANDPROPERTY_INSERT(string p_PROJECT_NO, string p_PROJECT_NAME, string p_TYPE_InitialCatalog, string p_VALUE_InitialCatalog, string p_TYPE_TileSorceStorage,

            string p_VALUE_TileSorceStorage, string p_TYPE_TileSourcePath, string p_VALUE_TileSourcePath, string p_TYPE_FinalPDFStorageRemote, string p_VALUE_FinalPDFStorageRemote,

            string p_TYPE_FinalPDFStorageLocal, string p_VALUE_FinalPDFStorageLocal, string p_TYPE_UpLoadServiceUrl, string p_VALUE_UpLoadServiceUrl, Nullable<int> p_IS_ACTIVITY)

        {

            int result;

            try

            {

                //var connectionstring = Properties.Resources.ConnectionString;

                using (markusEntities entities = new markusEntities())

                {

                    result = entities.SELECT_RUNANDPROPERTY_INSERT(p_PROJECT_NO, p_PROJECT_NAME, p_TYPE_InitialCatalog, p_VALUE_InitialCatalog, p_TYPE_TileSorceStorage, p_VALUE_TileSorceStorage, p_TYPE_TileSourcePath, p_VALUE_TileSourcePath, p_TYPE_FinalPDFStorageRemote,

                        p_VALUE_FinalPDFStorageRemote, p_TYPE_FinalPDFStorageLocal, p_VALUE_FinalPDFStorageLocal, p_TYPE_UpLoadServiceUrl, p_VALUE_UpLoadServiceUrl, p_IS_ACTIVITY);

                }

            }

            catch (Exception ex)

            {

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

                throw new FaultException("GET_RUNANDPROPERTY_INSERT");

            }

            return result;

        }

        public List<FINAL_PDF_MARKUP_CHECK_Result> GET_FINAL_PDF_MARKUP_CHECK(string p_PROJECT_NO, string p_DOCUMENT_ID)

        {

            List<FINAL_PDF_MARKUP_CHECK_Result> results = new List<FINAL_PDF_MARKUP_CHECK_Result>();

            try

            {

                using (markusEntities entities = new markusEntities())

                {

                    results = entities.FINAL_PDF_MARKUP_CHECK(p_PROJECT_NO, p_DOCUMENT_ID).ToList();

                }

            }

            catch (Exception ex)

            {

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

                throw new FaultException("FINAL_PDF_MARKUP_CHECK");

            }

            return results;

        }

        public List<SELECT_DOCINFO_Result> GET_SELECT_DOCINFO(string p_DOCINFO_ID)

        {

            List<SELECT_DOCINFO_Result> results = new List<SELECT_DOCINFO_Result>();

            try

            {

                using (markusEntities entities = new markusEntities())

                {

                    results = entities.SELECT_DOCINFO(p_DOCINFO_ID).ToList();

                }

            }

            catch (Exception ex)

            {

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

                throw new FaultException("GET_SELECT_DOCINFO");

            }

            return results;

        }

        private static string shortGuid()

        {

            byte[] bytes = new byte[16];

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

            {

                provider.GetBytes(bytes);

            }

            var guid = new Guid(bytes);

            return Convert.ToBase64String(guid.ToByteArray())

                .Substring(0, 10)

                .Replace("/", "")

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

        }

        public bool FinalPDF_GetFinalPDFStatus(string DocInfoID, string MarkupInfoID, string CreateUserID)

        {

            bool result = false;

            try

            {

                using (markusEntities _entity = new markusEntities())

                {

                    var finalpdf = _entity.SELECT_FINAL_PDF_ITEM(null, null, null, MarkupInfoID, DocInfoID, null, null, CreateUserID, 4, null, null, null, null, null, null, null, null, null, null, null).ToList();

                    if (finalpdf != null)

                    {

                        result = true;

                    }

                    else

                    {

                        result = false;

                    }

                }

            }

            catch (Exception ex)

            {

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

                throw new FaultException("FinalPDF_GetFinalPDFStatus");

            }

            return result;

        }

        private string _ChanID = null;

        TcpChannel chan = null;

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

        {

            #region 임시보관

            #endregion

            FinalPDFResult _result = new FinalPDFResult();

            RemFinalPDFObject remObj = null;

            try

            {

                string _finalID = shortGuid();

                int _DocTotalPages = -1;

                string docItemId;

                using (markusEntities entities = new markusEntities())

                {

                    var _doc = entities.SELECT_DOCINFO(DocInfoID).ToList();

                    if (_doc.Count() > 0)

                    {

                        _DocTotalPages = _doc.First().PAGE_COUNT.Value;

                        docItemId = _doc.First().DOCUMENT_ID;

                    }

                    else

                    {

                        _result.Status = FinalStatus.Error;

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

                        return _result;

                    }

                }

                if (_DocTotalPages > 0)

                {

                    using (markusEntities entities = new markusEntities())

                    {

                        entities.SELECT_FINAL_PDF_INSERT(_finalID, ProjectNo, DocInfoID, docItemId, MarkupInfoID, CreateUserID, _DocTotalPages, (int)IFinalPDF.FinalStatus.Insert);

                    };

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

                    if (_ch == null)

                    {

                        chan = new TcpChannel();

                        _ChanID = chan.ChannelName;

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

                        // Create an instance of the remote object

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

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

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

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

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

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

                        _result = remObj.SetFinalPDF(ProjectNo, _finalID);

                        _result.FinalID = _finalID;

                        _result.Status = FinalStatus.Success;

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

                        //fa.MakeFinalPDF(fm);

                    }

                    else

                    {

                        _ChanID = _ch.ChannelName;

                    }

                }

            }

            catch (Exception ex)

            {

                System.Diagnostics.Debug.WriteLine("KCOM_API - SetFinalPDF : " + ex.ToString());

                _result.Status = FinalStatus.Error;

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

                    _result.Exception = "Final Server Not Connection";

                else _result.Exception = ex.ToString();

            }

            finally

            {

                remObj = null;

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

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

                GC.Collect(2);

            }

            return _result;

        }

        public List<SELECT_MARKUP_INFO_Result> SELECT_MARKUP_INFO(string p_DOCINFO_ID)

        {

            List<SELECT_MARKUP_INFO_Result> results = new List<SELECT_MARKUP_INFO_Result>();

            try

            {

                using (markusEntities entities = new markusEntities())

                {

                    results = entities.SELECT_MARKUP_INFO(p_DOCINFO_ID).ToList();

                }

            }

            catch (Exception ex)

            {

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

                throw new FaultException("SELECT_MARKUP_INFO");

            }

            return results;

        }

    }

}