MARKUS

using KCOMDataModel.DataModel;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace DatabaseLoadTest

{

    class Program

    {

        static void Main(string[] args)

        {

            try

            {

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

                {

                    var items = _entity.FINAL_PDF;

                    Console.WriteLine("FinalPDF Count : " + items.Count());

                    foreach (var item in items)

                    {

                        List<MARKUP_DATA> MarkupDataSet = null;

                        DOCINFO DocInfoItem = null;

                        using (CIEntities _ciEntity = new CIEntities(KCOMDataModel.Common.ConnectStringBuilder.ProjectCIConnectString("000000").ToString()))

                        {

                            DocInfoItem = _ciEntity.DOCINFO.Where(x => x.DOCUMENT_ID == item.DOCUMENT_ID).FirstOrDefault();

                            var markupinfoItem = DocInfoItem.MARKUP_INFO.Where(x => x.DOCINFO_ID == DocInfoItem.ID && x.CONSOLIDATE == 1 && x.AVOID_CONSOLIDATE == 0 && x.PART_CONSOLIDATE == 0).FirstOrDefault();

                            if (markupinfoItem.MARKUP_INFO_VERSION.Count > 0)

                            {

                                MarkupDataSet = markupinfoItem.MARKUP_INFO_VERSION.OrderBy(x => x.CREATE_DATE).LastOrDefault().MARKUP_DATA.ToList().OrderBy(x => x.PAGENUMBER).ToList();

                            }

                        }

                        List<MARKUP_DATA> MarkupDataSet2 = null;

                        DOCINFO DocInfoItem2 = null;

                        MARKUP_INFO MarkupInfoItem = null;

                        using (CIEntities _ciEntity = new CIEntities(KCOMDataModel.Common.ConnectStringBuilder.ProjectCIConnectString("000000").ToString()))

                        {

                            var _DOCINFO = _ciEntity.DOCINFO.Where(x => x.DOCUMENT_ID == item.DOCUMENT_ID);

                            if (_DOCINFO.Count() > 0)

                            {

                                DocInfoItem2 = _DOCINFO.First();

                                var infoItems = _ciEntity.MARKUP_INFO.Where(x => x.DOCINFO_ID == DocInfoItem.ID && x.CONSOLIDATE == 1 && x.AVOID_CONSOLIDATE == 0 && x.PART_CONSOLIDATE == 0);

                                if (infoItems.Count() == 0)

                                {

                                    throw new Exception("콘솔리데잇이 작업 요청 후에 수정 / 삭제 되었습니다");

                                }

                                else

                                {

                                    MarkupInfoItem = infoItems.First();

                                    var markupInfoVerItems = _ciEntity.MARKUP_INFO_VERSION.Where(x => x.MARKUPINFO_ID == MarkupInfoItem.ID).ToList();

                                    if (markupInfoVerItems.Count() > 0)

                                    {

                                        var markupInfoVerItem = markupInfoVerItems.OrderByDescending(x => x.CREATE_DATE).First();

                                        MarkupDataSet2 = _ciEntity.MARKUP_DATA.Where(x => x.MARKUPINFO_VERSION_ID == markupInfoVerItem.ID).OrderBy(d => d.PAGENUMBER).ToList();

                                    }

                                    else

                                    {

                                        throw new Exception("MARKUP_INFO_VERSION 이 존재 하지 않습니다");

                                    }

                                }

                            }

                        }

                        if (MarkupDataSet?.Count() != MarkupDataSet?.Count())

                        {

                            Console.WriteLine($"Document ID : {item.DOCUMENT_ID} Error");

                        }

                        System.Threading.Thread.Sleep(100);

                    }

                }

            }

            catch (Exception ex)

            {

                Console.WriteLine(ex.ToString());

            }

            Console.WriteLine("완료");

            Console.ReadLine();

        }

        static void Write(string Log)

        {

        }

    }

}