HYTOS

        protected IDbTransaction _DbTransaction = null;

        public IDbTransaction BeginTransaction()

        {

            if (this._DbConnection.State != ConnectionState.Open)

            {

                this._DbConnection.Open();

            }

            return this._DbConnection.BeginTransaction();

        }

            if (this._DbTransaction != null)

            {

                this._DbTransaction.Commit();

            }

            return this.Execute(query, null, dbTran);

                using (var transaction = base.BeginTransaction())

                            query = $@"delete from dbo.Documents where [DocID] in ('{docIDList}');";

}

        public string RefProjectID { get; set; }

            return other != null && this.DocumentNo == other.DocumentNo && this.RevisonNo == other.RevisonNo && this.RefProjectID == other.RefProjectID && this.IsLatest == other.IsLatest

            return this.DocumentNo.GetHashCode() + this.RevisonNo.GetHashCode() + this.RefProjectID.GetHashCode() + this.IsLatest.GetHashCode()

        //public class DocumentsComparer : IEqualityComparer<Documents>

        //{

        //    public bool Equals(Documents x, Documents y)

        //    {

        //        if (x == null && y == null)

        //            return true;

        //        else if (x == null || y == null)

        //            return false;

        //        else

        //        {

        //            return x.DocumentNo == y.DocumentNo && x.RevisonNo == y.RevisonNo && x.ProjectID == y.ProjectID && x.IsLatest == y.IsLatest

        //                && x.AutoCADFilie == y.AutoCADFilie && x.PDFFile == y.PDFFile && x.MarkupLink == y.MarkupLink && x.AVEVALink == y.AVEVALink

        //                && x.DocFilePath == y.DocFilePath && x.DocFileName == y.DocFileName && x.Place == y.Place && x.JobLevel == y.JobLevel && x.IsTypical == y.IsTypical

        //                && x.PersonInCharge == y.PersonInCharge && x.IsDeleted == y.IsDeleted && x.ToIsDiscussion == y.ToIsDiscussion && x.ToRemarks == y.ToRemarks

        //                && x.ToCreator == y.ToCreator && x.ToModifier == y.ToModifier && x.ToCapturePath == y.ToCapturePath && x.ToIsMarkup == y.ToIsMarkup

        //                && x.FrReviewStatus == y.FrReviewStatus && x.FrRemarks == y.FrRemarks && x.FrCreator == y.FrCreator && x.FrModifier == y.FrModifier

        //                && x.FrCapturePath == y.FrCapturePath && x.FrIsMarkup == y.FrIsMarkup && x.IsID2Work == y.IsID2Work && x.ID2Connection == y.ID2Connection

        //                && x.ID2StartDate == y.ID2StartDate && x.ID2EndDate == y.ID2EndDate && x.ID2JobTime == y.ID2JobTime && x.ID2Status == y.ID2Status

        //                && x.ID2Issues == y.ID2Issues && x.AVEVAConnection == y.AVEVAConnection && x.AVEVAConvertDate == y.AVEVAConvertDate && x.AVEVAReviewDate == y.AVEVAReviewDate

        //                && x.AVEVAStatus == y.AVEVAStatus && x.AVEVAIssues == y.AVEVAIssues && x.ReviewFilePath == y.ReviewFilePath && x.ReviewFileName == y.ReviewFileName

        //                && x.ProdReviewer == y.ProdReviewer && x.ProdIsResult == y.ProdIsResult && x.ProdRemarks == y.ProdRemarks && x.ClientReviewer == y.ClientReviewer

        //                && x.ClientIsResult == y.ClientIsResult && x.ClientRemarks == y.ClientRemarks && x.DTIsGateWay == y.DTIsGateWay && x.DTIsImport == y.DTIsImport

        //                && x.DTIsRegSystem == y.DTIsRegSystem && x.DTRemarks == y.DTRemarks;

        //        }

        //    }

        //    public int GetHashCode(Documents obj)

        //    {

        //        return obj.DocumentNo.GetHashCode() + obj.RevisonNo.GetHashCode() + obj.ProjectID.GetHashCode() + obj.IsLatest.GetHashCode()

        //            + obj.AutoCADFilie.GetHashCode() + obj.PDFFile.GetHashCode() + obj.MarkupLink.GetHashCode() + obj.AVEVALink.GetHashCode()

        //            + obj.DocFilePath.GetHashCode() + obj.DocFileName.GetHashCode() + obj.Place.GetHashCode() + obj.JobLevel.GetHashCode() + obj.IsTypical.GetHashCode()

        //            + obj.PersonInCharge.GetHashCode() + obj.IsDeleted.GetHashCode() + obj.ToIsDiscussion.GetHashCode() + obj.ToRemarks.GetHashCode()

        //            + obj.ToCreator.GetHashCode() + obj.ToModifier.GetHashCode() + obj.ToCapturePath.GetHashCode() + obj.ToIsMarkup.GetHashCode()

        //            + obj.FrReviewStatus.GetHashCode() + obj.FrRemarks.GetHashCode() + obj.FrCreator.GetHashCode() + obj.FrModifier.GetHashCode()

        //            + obj.FrCapturePath.GetHashCode() + obj.FrIsMarkup.GetHashCode() + obj.IsID2Work.GetHashCode() + obj.ID2Connection.GetHashCode()

        //            + obj.ID2StartDate.GetHashCode() + obj.ID2EndDate.GetHashCode() + obj.ID2JobTime.GetHashCode() + obj.ID2Status.GetHashCode()

        //            + obj.ID2Issues.GetHashCode() + obj.AVEVAConnection.GetHashCode() + obj.AVEVAConvertDate.GetHashCode() + obj.AVEVAReviewDate.GetHashCode()

        //            + obj.AVEVAStatus.GetHashCode() + obj.AVEVAIssues.GetHashCode() + obj.ReviewFilePath.GetHashCode() + obj.ReviewFileName.GetHashCode()

        //            + obj.ProdReviewer.GetHashCode() + obj.ProdIsResult.GetHashCode() + obj.ProdRemarks.GetHashCode() + obj.ClientReviewer.GetHashCode()

        //            + obj.ClientIsResult.GetHashCode() + obj.ClientRemarks.GetHashCode() + obj.DTIsGateWay.GetHashCode() + obj.DTIsImport.GetHashCode()

        //            + obj.DTIsRegSystem.GetHashCode() + obj.DTRemarks.GetHashCode();

        //    }

        //}

        public class DocumentsKeyComparer : IEqualityComparer<Documents>

        {

            public bool Equals(Documents x, Documents y)

            {

                if (x == null && y == null)

                    return true;

                else if (x == null || y == null)

                    return false;

                else

                {

                    return x.DocID == y.DocID;

                }

            }

            public int GetHashCode(Documents obj)

            {

                return (obj.DocID != null ? obj.DocID.GetHashCode() : 0);

            }

        }

using System.Reflection;

using static ID2.Manager.Data.Models.Documents;

                    int exRow = 8;

                    //Excel 포멧체크

                        RadMessageBox.Show("Please, check the excel.\n", "Information", MessageBoxButtons.OK, RadMessageIcon.Info);

                    #region 엑셀 필수값 체크(도면 : 이름,담당자, 난이도, Typical)

                    ws.Rows.SelectMany(row => row.AllocatedCells)

                           .Where(col => col.Column.Index > 5 && col.Column.Index < 10 && col.Row.Index > exRow && col.Value == null)

                           .ToList()

                           .ForEach(p => sbErrMsg.Append(", " + p.Column.Name + p.Row.Name));

                        string errMsg = sbErrMsg.ToString().Substring(2);

                        if (errMsg.Length > 100)

                        {

                            errMsg = $"{errMsg.Substring(0, 100)}...";

                        }

                        RadMessageBox.Show($"Please, check null value in excel.\n{errMsg}", "Information", MessageBoxButtons.OK, RadMessageIcon.Info);

                    #endregion

                    #region 엑셀 도명명 중복 값 체크

                                                 .Where(col => col.Column.Index == 6 && col.Row.Index > exRow)

                                                     rowIndex = p.Key,

                                                     docNo = p.Select(x => x.Value.ToString()).FirstOrDefault()

                                                 .GroupBy(g => g.docNo)

                                                 .Select(p => p.Select(x => (x.rowIndex + 1).ToString())

                                                                                            .Aggregate((x, y) => x.ToString() + "," + y.ToString())

                                                                                            .ToString())

                                                 .ToList().ForEach(p => sbErrMsg.Append("\n" + p.ToString()));

                        sbErrMsg.Insert(0, "\n중복 된 도면명 Excel row : ");

                        string errMsg = sbErrMsg.ToString();

                        if (errMsg.Length > 100)

                        {

                            errMsg = $"{errMsg.Substring(0, 100)}...";

                        }

                        RadMessageBox.Show($"Please, check the duplicate value in excel.\n{errMsg}", "Information", MessageBoxButtons.OK, RadMessageIcon.Info);

                    #endregion

                    List<Documents> appendDocuments = new List<Documents>();

                    ws.Rows.Where(row => row.Index > exRow)

                           .ToList()

                           .ForEach(p => appendDocuments.Add(new Documents()

                           {

                               //UID = string.Empty,

                               //Type = this.radTextBoxInsulationType.Text,

                               //TempFrom = ws.Rows[exRow].Cells[p.Column.Index].Value == null ? 0 : Convert.ToSingle(ws.Rows[exRow].Cells[p.Column.Index].Value),

                               //TempTo = ws.Rows[exRow + 2].Cells[p.Column.Index].Value == null ? 0 : Convert.ToSingle(ws.Rows[exRow + 2].Cells[p.Column.Index].Value),

                               //NPS = ws.Rows[p.Row.Index].Cells[0].Value == null ? 0 : Convert.ToSingle(ws.Rows[p.Row.Index].Cells[0].Value),

                               //Thickness = p.Value == null ? 0 : Convert.ToSingle(p.Value)

                               Place = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),

                               DocumentNo = ws.Rows[p.Index].Cells[6].Value == null ? string.Empty : ws.Rows[p.Index].Cells[6].Value.ToString(),

                               PersonInCharge = ws.Rows[p.Index].Cells[7].Value == null ? string.Empty : ws.Rows[p.Index].Cells[7].Value.ToString(),

                               JobLevel = ws.Rows[p.Index].Cells[8].Value == null ? string.Empty : ws.Rows[p.Index].Cells[8].Value.ToString(),

                               IsTypical = ws.Rows[p.Index].Cells[9].Value == null ? string.Empty : ws.Rows[p.Index].Cells[9].Value.ToString(),

                               RevisonNo = ws.Rows[p.Index].Cells[10].Value == null ? string.Empty : ws.Rows[p.Index].Cells[10].Value.ToString(),

                               ToIsDiscussion = ws.Rows[p.Index].Cells[11].Value == null ? string.Empty : ws.Rows[p.Index].Cells[11].Value.ToString(),

                               ToRemarks = ws.Rows[p.Index].Cells[12].Value == null ? string.Empty : ws.Rows[p.Index].Cells[12].Value.ToString(),

                               ToCreator = ws.Rows[p.Index].Cells[13].Value == null ? string.Empty : ws.Rows[p.Index].Cells[13].Value.ToString(),

                               //ToCapturePath = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),

                               //ToIsMarkup = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),

                               FrReviewStatus = ws.Rows[p.Index].Cells[16].Value == null ? string.Empty : ws.Rows[p.Index].Cells[16].Value.ToString(),

                               FrRemarks = ws.Rows[p.Index].Cells[17].Value == null ? string.Empty : ws.Rows[p.Index].Cells[17].Value.ToString(),

                               FrCreator = ws.Rows[p.Index].Cells[18].Value == null ? string.Empty : ws.Rows[p.Index].Cells[18].Value.ToString(),

                               //FrCapturePath = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),

                               //FrIsMarkup = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),

                               IsID2Work = ws.Rows[p.Index].Cells[21].Value == null ? string.Empty : ws.Rows[p.Index].Cells[21].Value.ToString(),

                               //ID2Connection = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),

                               //ID2StartDate = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),

                               //ID2EndDate = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),

                               //ID2JobTime = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),

                               ID2Status = ws.Rows[p.Index].Cells[26].Value == null ? string.Empty : ws.Rows[p.Index].Cells[26].Value.ToString(),

                               ID2Issues = ws.Rows[p.Index].Cells[27].Value == null ? string.Empty : ws.Rows[p.Index].Cells[27].Value.ToString(),

                               //AVEVAConnection = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),

                               //AVEVAConvertDate = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),

                               //AVEVAReviewDate = ws.Rows[p.Index].Cells[5].Value == null ? string.Empty : ws.Rows[p.Index].Cells[5].Value.ToString(),

                               AVEVAStatus = ws.Rows[p.Index].Cells[31].Value == null ? string.Empty : ws.Rows[p.Index].Cells[31].Value.ToString(),

                               AVEVAIssues = ws.Rows[p.Index].Cells[32].Value == null ? string.Empty : ws.Rows[p.Index].Cells[32].Value.ToString(),

                               ProdReviewer = ws.Rows[p.Index].Cells[35].Value == null ? string.Empty : ws.Rows[p.Index].Cells[35].Value.ToString(),

                               ProdIsResult = ws.Rows[p.Index].Cells[36].Value == null ? string.Empty : ws.Rows[p.Index].Cells[36].Value.ToString(),

                               ProdRemarks = ws.Rows[p.Index].Cells[37].Value == null ? string.Empty : ws.Rows[p.Index].Cells[37].Value.ToString(),

                               ClientReviewer = ws.Rows[p.Index].Cells[38].Value == null ? string.Empty : ws.Rows[p.Index].Cells[38].Value.ToString(),

                               ClientIsResult = ws.Rows[p.Index].Cells[39].Value == null ? string.Empty : ws.Rows[p.Index].Cells[39].Value.ToString(),

                               ClientRemarks = ws.Rows[p.Index].Cells[40].Value == null ? string.Empty : ws.Rows[p.Index].Cells[40].Value.ToString(),

                               DTIsGateWay = ws.Rows[p.Index].Cells[41].Value == null ? string.Empty : ws.Rows[p.Index].Cells[41].Value.ToString(),

                               DTIsImport = ws.Rows[p.Index].Cells[42].Value == null ? string.Empty : ws.Rows[p.Index].Cells[42].Value.ToString(),

                               DTIsRegSystem = ws.Rows[p.Index].Cells[43].Value == null ? string.Empty : ws.Rows[p.Index].Cells[43].Value.ToString(),

                               DTRemarks = ws.Rows[p.Index].Cells[44].Value == null ? string.Empty : ws.Rows[p.Index].Cells[44].Value.ToString()

                           }));

                    foreach (Documents appDoc in appendDocuments)

                    {

                        GridViewRowInfo rowInfo = this.radGridViewDocuments.Rows.AddNew();

                        foreach (FieldInfo fieldInfo in appDoc.GetType().GetFields(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.DeclaredOnly))

                        {

                            if (fieldInfo.GetValue(appDoc) != null)

                            {

                                var cols = rowInfo.Cells.Where(x => fieldInfo.Name.Contains($"<{x.ColumnInfo.Name}>"));

                                if (cols.Any())

                                {

                                    cols.FirstOrDefault().Value = fieldInfo.GetValue(appDoc);

                                }

                            }

                        }

                    }

                            templateWorksheet.Cells[rowIndex, 39].Value = doc.ClientIsResult;

            delDocuments.AddRange(this.orgDocuments.Except(this.documents, new DocumentsKeyComparer()));

            bool result = new DocumentController().SetDocumentData(setDocuments, delDocuments);

            if (result)

            {

                RadMessageBox.Show("Save is complete", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Info);

            }