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

        {

            try

            {

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

                {

                    return rep.GetAllDocuments(projectGroupID);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        public (IEnumerable<Documents> dwgs, int totalCnt) GetDocuments(string projectGroupID, List<string> dateTypes, DateTime? frDate, DateTime? toDate, string projectCode, string personIncharge, string jobLevel, string documentNo, string isToIsDiscussion, string isFrReviewStatus, string id2Status, string id2Issues, string avevaStatus, string avevaIssues, string prodIsResult, string clientIsResult, string isGateWay, string isRegSystem)

        {

            try

            {

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

                {

                    return rep.GetDocuments(projectGroupID, dateTypes, frDate, toDate, projectCode, personIncharge, jobLevel, documentNo, isToIsDiscussion, isFrReviewStatus, id2Status, id2Issues, avevaStatus, avevaIssues, prodIsResult, clientIsResult, isGateWay, isRegSystem);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        public (IEnumerable<Documents> dwgs, int totalCnt) GetDocuments(List<ID2ProjectInfo> id2Infos, string projectGroupID, List<string> dateTypes, DateTime? frDate, DateTime? toDate, string projectCode, string personIncharge, string jobLevel, string documentNo, string isToIsDiscussion, string isFrReviewStatus, string id2Issues, string id2Status, string avevaStatus, string avevaIssues, string prodIsResult, string clientIsResult, string isGateWay, string isRegSystem)

        {

            try

            {

                var (dwgs, totalCnt) = this.GetDocuments(projectGroupID, dateTypes, frDate, toDate, projectCode, personIncharge, jobLevel, documentNo, isToIsDiscussion, isFrReviewStatus, id2Status, id2Issues, avevaStatus, avevaIssues, prodIsResult, clientIsResult, isGateWay, isRegSystem);

                IEnumerable<Documents> docs = 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,

                                     JobLevel = doc.JobLevel,

                                     PersonInCharge = doc.PersonInCharge,

                                     ToIsDiscussion = doc.ToIsDiscussion,

                                     ToRemarks = doc.ToRemarks,

                                     ToCreator = doc.ToCreator,

                                     FrReviewStatus = doc.FrReviewStatus,

                                     FrRemarks = doc.FrRemarks,

                                     FrCreator = doc.FrCreator,

                                     ID2StartDate = doc.ID2StartDate,

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

                                     ID2Status = doc.ID2Status,

                                     ID2Issues = doc.ID2Issues,

                                     ReplyModifications = doc.ReplyModifications,

                                     ReplyRequester = doc.ReplyRequester,

                                     IsConvert = doc.IsConvert,

                                     AVEVAPersonInCharge = doc.AVEVAPersonInCharge,

                                     AVEVAWorker = doc.AVEVAWorker,

                                     AVEVAConvertDate = doc.AVEVAConvertDate,

                                     AVEVAReviewDate = doc.AVEVAReviewDate,

                                     AVEVAWorkDate = doc.AVEVAWorkDate,

                                     AVEVAStatus = doc.AVEVAStatus,

                                     AVEVAIssues = doc.AVEVAIssues,

                                     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,

                                     Markups = doc.Markups

                                 };

                    return (result, totalCnt);

                }

                return (dwgs, totalCnt);

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        public int ExistsDocument(string projectGroupID, List<string> newDwgNos)

        {

            try

            {

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

                {

                    return rep.ExistsDocument(projectGroupID, newDwgNos);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

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

        {

            try

            {

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

                {

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

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        public Documents SetID2Worker(Documents doc, string userId)

        {

            try

            {

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

                {

                    return rep.SetDocumentDataField(doc, userId);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        public Documents SetDocumentDataField(Documents doc, string userId)

        {

            try

            {

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

                {

                    return rep.SetDocumentDataField(doc, userId);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        //ID2

        public IEnumerable<ID2Drawings> GetID2DrawingsByProject(ID2ProjectInfo id2Info)

        {

            try

            {

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

                {

                    return rep.GetID2DrawingsByProject(id2Info);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

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

        {

            bool isSuccess = false;

            try

            {

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

                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;

        }

        //Transactions

        public int GetTranKey(string userId, string projectID)

        {

            try

            {

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

                {

                    return rep.GetTranKey(userId, projectID);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        public bool SetTran(int seq, bool isMgt, bool isStart, int itemCount, int markusItemCount)

        {

            try

            {

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

                {

                    return rep.SetTran(seq, isMgt, isStart, itemCount, markusItemCount);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        public string GetTranData(int seq)

        {

            try

            {

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

                {

                    return rep.GetTranData(seq);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        public IEnumerable<Documents> GetTrDocuments(int seq)

        {

            try

            {

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

                {

                    return rep.GetTrDocuments(seq);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

    }

}