HYTOS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using ID2.Manager.Data.Models;

namespace ID2.Manager.Dapper.Repository

{

    public class DocumentRepository : BaseRepository

    {

        public DocumentRepository(string connectionStr) : base(connectionStr) { }

        public IEnumerable<Documents> GetAllDocuments()

        {

            string query = $@"

select   doc.*

from     dbo.Documents doc

where    IsDeleted=0

order by doc.Seq";

            return Query<Documents>(query);

        }

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

        {

            bool isSuccess = false;

            try

            {

                using (var transaction = base.BeginTransaction())

                {

                    string query = string.Empty;

                    if (delDocList.Count > 0)

                    {

                        string docIDList = string.Join("','", delDocList.Where(x => !string.IsNullOrEmpty(x.DocID)).Select(x => x.DocID).ToList());

                        if (docIDList.Length > 0)

                        {

                            query = $@"

update from dbo.Documents

set   IsDeleted=1

     ,DeletedDate=getdate()

where [DocID] in ('{docIDList}');";

                            base.Execute(query, transaction);

                        }

                    }

                    foreach (Documents doc in docList)

                    {

                        if (string.IsNullOrEmpty(doc.DocID))

                        {

                            query = $@"

insert into dbo.Documents

(

     [DocID]

    ,[DocumentNo]

    ,[RevisonNo]

    ,[RefProjectID]

    ,[DocFilePath]

    ,[DocFileName]

    ,[Place]

    ,[JobLevel]

    ,[IsTypical]

    ,[PersonInCharge]

    ,[ToIsDiscussion]

    ,[ToRemarks]

    ,[ToCreator]

    ,[ToModifier]

    ,[ToCapturePath]

    ,[ToIsMarkup]

    ,[FrReviewStatus]

    ,[FrRemarks]

    ,[FrCreator]

    ,[FrModifier]

    ,[FrCapturePath]

    ,[FrIsMarkup]

    ,[IsID2Work]

    ,[ID2Connection]

    ,[ID2StartDate]

    ,[ID2EndDate]

    ,[ID2JobTime]

    ,[ID2Status]

    ,[ID2Issues]

    ,[AVEVAConnection]

    ,[AVEVAConvertDate]

    ,[AVEVAReviewDate]

    ,[AVEVAStatus]

    ,[AVEVAIssues]

    ,[ReviewFilePath]

    ,[ReviewFileName]

    ,[ProdReviewer]

    ,[ProdIsResult]

    ,[ProdRemarks]

    ,[ClientReviewer]

    ,[ClientIsResult]

    ,[ClientRemarks]

    ,[DTIsGateWay]

    ,[DTIsImport]

    ,[DTIsRegSystem]

    ,[DTRemarks]

)

values 

(

     lower(newid())

    ,@DocumentNo

    ,@RevisonNo

    ,@RefProjectID

    ,@DocFilePath

    ,@DocFileName

    ,@Place

    ,@JobLevel

    ,@IsTypical

    ,@PersonInCharge

    ,@ToIsDiscussion

    ,@ToRemarks

    ,@ToCreator

    ,@ToModifier

    ,@ToCapturePath

    ,@ToIsMarkup

    ,@FrReviewStatus

    ,@FrRemarks

    ,@FrCreator

    ,@FrModifier

    ,@FrCapturePath

    ,@FrIsMarkup

    ,@IsID2Work

    ,@ID2Connection

    ,@ID2StartDate

    ,@ID2EndDate

    ,@ID2JobTime

    ,@ID2Status

    ,@ID2Issues

    ,@AVEVAConnection

    ,@AVEVAConvertDate

    ,@AVEVAReviewDate

    ,@AVEVAStatus

    ,@AVEVAIssues

    ,@ReviewFilePath

    ,@ReviewFileName

    ,@ProdReviewer

    ,@ProdIsResult

    ,@ProdRemarks

    ,@ClientReviewer

    ,@ClientIsResult

    ,@ClientRemarks

    ,@DTIsGateWay

    ,@DTIsImport

    ,@DTIsRegSystem

    ,@DTRemarks

);";

                        }

                        else

                        {

                            query = $@"

update dbo.Documents

set    [DocumentNo]=@DocumentNo,

      ,[RevisonNo]=@RevisonNo,

      ,[RefProjectID]=@RefProjectID,

      ,[DocFilePath]=@DocFilePath,

      ,[DocFileName]=@DocFileName,

      ,[Place]=@Place,

      ,[JobLevel]=@JobLevel,

      ,[IsTypical]=@IsTypical,

      ,[PersonInCharge]=@PersonInCharge,

      ,[ModifiedDate]=getdate(),

      ,[ToIsDiscussion]=@ToIsDiscussion,

      ,[ToRemarks]=@ToRemarks,

      ,[ToCreator]=@ToCreator,

      ,[ToModifier]=@ToModifier,

      ,[ToCapturePath]=@ToCapturePath,

      ,[ToIsMarkup]=@ToIsMarkup,

      ,[FrReviewStatus]=@FrReviewStatus,

      ,[FrRemarks]=@FrRemarks,

      ,[FrCreator]=@FrCreator,

      ,[FrModifier]=@FrModifier,

      ,[FrCapturePath]=@FrCapturePath,

      ,[FrIsMarkup]=@FrIsMarkup,

      ,[IsID2Work]=@IsID2Work,

      ,[ID2Connection]=@ID2Connection,

      ,[ID2StartDate]=@ID2StartDate,

      ,[ID2EndDate]=@ID2EndDate,

      ,[ID2JobTime]=@ID2JobTime,

      ,[ID2Status]=@ID2Status,

      ,[ID2Issues]=@ID2Issues,

      ,[AVEVAConnection]=@AVEVAConnection,

      ,[AVEVAConvertDate]=@AVEVAConvertDate,

      ,[AVEVAReviewDate]=@AVEVAReviewDate,

      ,[AVEVAStatus]=@AVEVAStatus,

      ,[AVEVAIssues]=@AVEVAIssues,

      ,[ReviewFilePath]=@ReviewFilePath,

      ,[ReviewFileName]=@ReviewFileName,

      ,[ProdReviewer]=@ProdReviewer,

      ,[ProdIsResult]=@ProdIsResult,

      ,[ProdRemarks]=@ProdRemarks,

      ,[ClientReviewer]=@ClientReviewer,

      ,[ClientIsResult]=@ClientIsResult,

      ,[ClientRemarks]=@ClientRemarks,

      ,[DTIsGateWay]=@DTIsGateWay,

      ,[DTIsImport]=@DTIsImport,

      ,[DTIsRegSystem]=@DTIsRegSystem,

      ,[DTRemarks]=@DTRemarks

where  [DocID]=@DocID;";

                        }

                        base.Execute(query, doc, transaction);

                    }

                    transaction.Commit();

                    isSuccess = true;

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

            return isSuccess;

        }

    }

}