HYTOS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using ID2.Manager.Dapper;

using ID2.Manager.Data.Models;

using ID2.Manager.Dapper.Repository;

namespace ID2.Manager.Controller.Controllers

{

    public class DocumentController : BaseController

    {

        public DocumentController() : base() { }

        public DocumentController(ID2ProjectInfo id2Info) : base(id2Info) { }

        public IEnumerable<Documents> GetAllDocuments()

        {

            using (DocumentRepository rep = new DocumentRepository(this._MSSQLCONNSTR))

            {

                return rep.GetAllDocuments();

            }

        }

        public (IEnumerable<Documents> dwgs, int totalCnt) GetDocuments(string projectCode, string personIncharge, string jobLevel, string documentNo, string isToIsDiscussion, string isFrReviewStatus, string isID2Work, string id2Status, string avevaStatus, string prodIsResult, string clientIsResult)

        {

            using (DocumentRepository rep = new DocumentRepository(this._MSSQLCONNSTR))

            {

                return rep.GetDocuments(projectCode, personIncharge, jobLevel, documentNo, isToIsDiscussion, isFrReviewStatus, isID2Work, id2Status, avevaStatus, prodIsResult, clientIsResult);

            }

        }

        public (IEnumerable<Documents> dwgs, int totalCnt) GetDocuments(List<ID2ProjectInfo> id2Infos, string projectCode, string personIncharge, string jobLevel, string documentNo, string isToIsDiscussion, string isFrReviewStatus, string isID2Work, string id2Status, string avevaStatus, string prodIsResult, string clientIsResult)

        {

            IEnumerable<Documents> docs = this.GetDocuments(projectCode, personIncharge, jobLevel, documentNo, isToIsDiscussion, isFrReviewStatus, isID2Work, id2Status, avevaStatus, prodIsResult, clientIsResult).dwgs;

            List<ID2Drawings> id2docs = null;

            if (id2Infos.Any())

            {

                id2docs = new List<ID2Drawings>();

                id2Infos.ForEach(x =>

                {

                    id2docs.AddRange(new DocumentController(x).GetID2DrawingsByProject(x));

                });

            }

            if (docs != null && id2docs != null && docs.Any() && id2docs.Any())

            {

                var result = from doc in docs

                             join id2 in id2docs on new { projCd = doc.RefProjectCode, DocNo = doc.DocumentNo } equals new { projCd = id2.PROJECTNAME, DocNo = id2.DOCNAME } into gj

                             from dw in gj.DefaultIfEmpty()

                             select new Documents()

                             {

                                 Seq = doc.Seq,

                                 DocID = doc.DocID,

                                 DocumentNo = doc.DocumentNo,

                                 RevisonNo = doc.RevisonNo,

                                 RefProjectCode = doc.RefProjectCode,

                                 IsLatest = doc.IsLatest,

                                 AutoCADFilie = doc.AutoCADFilie,

                                 PDFFile = doc.PDFFile,

                                 MarkupLink = doc.MarkupLink,

                                 AVEVALink = doc.AVEVALink,

                                 DocFilePath = doc.DocFilePath,

                                 DocFileName = doc.DocFileName,

                                 JobLevel = doc.JobLevel,

                                 IsTypical = doc.IsTypical,

                                 PersonInCharge = doc.PersonInCharge,

                                 IsDeleted = doc.IsDeleted,

                                 RegisteredDate = doc.RegisteredDate,

                                 ModifiedDate = doc.ModifiedDate,

                                 DeletedDate = doc.DeletedDate,

                                 ToIsDiscussion = doc.ToIsDiscussion,

                                 ToRemarks = doc.ToRemarks,

                                 ToCreator = doc.ToCreator,

                                 ToCapture = doc.ToCapture,

                                 ToIsMarkup = doc.ToIsMarkup,

                                 FrReviewStatus = doc.FrReviewStatus,

                                 FrRemarks = doc.FrRemarks,

                                 FrCreator = doc.FrCreator,

                                 FrCapture = doc.FrCapture,

                                 FrIsMarkup = doc.FrIsMarkup,

                                 IsID2Work = doc.IsID2Work,

                                 ID2Connection = doc.ID2Connection,

                                 ID2StartDate = doc.ID2StartDate,

                                 ID2EndDate = dw?.DATETIME == null ? (DateTime?)null : Convert.ToDateTime(dw?.DATETIME),

                                 ID2JobTime = doc.ID2JobTime,

                                 ID2Status = doc.ID2Status,

                                 ID2Issues = doc.ID2Issues,

                                 AVEVAConnection = doc.AVEVAConnection,

                                 AVEVAConvertDate = doc.AVEVAConvertDate,

                                 AVEVAReviewDate = doc.AVEVAReviewDate,

                                 AVEVAStatus = doc.AVEVAStatus,

                                 AVEVAIssues = doc.AVEVAIssues,

                                 ReviewFilePath = doc.ReviewFilePath,

                                 ReviewFileName = doc.ReviewFileName,

                                 ProdReviewer = doc.ProdReviewer,

                                 ProdIsResult = doc.ProdIsResult,

                                 ProdRemarks = doc.ProdRemarks,

                                 ClientReviewer = doc.ClientReviewer,

                                 ClientIsResult = doc.ClientIsResult,

                                 ClientRemarks = doc.ClientRemarks,

                                 DTIsGateWay = doc.DTIsGateWay,

                                 DTIsImport = doc.DTIsImport,

                                 DTIsRegSystem = doc.DTIsRegSystem,

                                 DTRemarks = doc.DTRemarks,

                                 MarkupText = doc.MarkupText

                             };

                return (result, 0);

            }

            return (docs, 0);

        }

        public bool SetDocumentData(List<Documents> docList, List<Documents> delDocList, string userId)

        {

            using (DocumentRepository rep = new DocumentRepository(this._MSSQLCONNSTR))

            {

                return rep.SetDocumentData(docList, delDocList, userId);

            }

        }

        public Documents SetID2Worker(Documents doc, string userId)

        {

            using (DocumentRepository rep = new DocumentRepository(this._MSSQLCONNSTR))

            {

                return rep.SetDocumentDataField(doc, userId);

            }

        }

        public Documents SetDocumentDataField(Documents doc, string userId)

        {

            using (DocumentRepository rep = new DocumentRepository(this._MSSQLCONNSTR))

            {

                return rep.SetDocumentDataField(doc, userId);

            }

        }

        //ID2

        public IEnumerable<ID2Drawings> GetID2DrawingsByProject(ID2ProjectInfo id2Info)

        {

            using (DocumentRepository rep = new DocumentRepository(this._ID2CONNSTR))

            {

                return rep.GetID2DrawingsByProject(id2Info);

            }

        }

        public bool SetID2Sync(List<ID2ProjectInfo> id2Infos, string userId)

        {

            bool isSuccess = false;

            try

            {

                IEnumerable<Documents> docs = this.GetAllDocuments();

                List<ID2Drawings> id2docs = null;

                if (id2Infos.Any())

                {

                    id2docs = new List<ID2Drawings>();

                    id2Infos.ForEach(x =>

                    {

                        id2docs.AddRange(new DocumentController(x).GetID2DrawingsByProject(x));

                    });

                }

                if (docs != null && id2docs != null && docs.Any() && id2docs.Any())

                {

                    var result = from doc in docs

                                 join id2 in id2docs on new { projCd = doc.RefProjectCode, DocNo = doc.DocumentNo } equals new { projCd = id2.PROJECTNAME, DocNo = id2.DOCNAME }

                                 select new Documents()

                                 {

                                     DocID = doc.DocID,

                                     ID2EndDate = id2?.DATETIME == null ? (DateTime?)null : Convert.ToDateTime(id2?.DATETIME)

                                 };

                    if (result.Any())

                    {

                        using (DocumentRepository rep = new DocumentRepository(this._MSSQLCONNSTR))

                        {

                            isSuccess = rep.SetDocumentDatasField(result.ToList(), userId);

                        }

                    }

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

            return isSuccess;

        }

    }

}