MARKUS

using System;

using System.Collections.Generic;

using System.Data.Entity.Core.Objects;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.Text;

namespace StationControllerService

{

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

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

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

                {

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

                {

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

                {

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

                {

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

                }

            }

            catch (Exception)

            {

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

                {

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

                {

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

                {

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

                {

                    result = entities.SELECT_FINAL_PDF_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<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(connectionstring))

                {

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

                {

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

                {

                    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)

            {

                throw new FaultException("GET_DOCUMENT_ITEM");

            }

            return result;

        }

    }

}