HYTOS

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.IO;

using System.Reflection;

using ID2.Manager.Common;

using ID2.Manager.Classes;

using ID2.Manager.Data.Models;

using ID2.Manager.Controller.Controllers;

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

using Telerik.WinControls;

using Telerik.WinControls.UI;

using Telerik.WinControls.Data;

using GemBox.Spreadsheet;

using Newtonsoft.Json;

namespace ID2.Manager

{

    public partial class Main : RadRibbonForm

    {

        readonly Informations informations = Informations.Instance;

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

        List<Documents> orgDocuments = null;

        private readonly Color _SummaryColor = Color.FromArgb(255, 108, 55);

        public Main()

        {

            InitializeComponent();

            this.Initialize();

            SpreadsheetInfo.SetLicense(Properties.Settings.Default.GemBoxLicense);

            this.Load += Main_Load;

            this.radButtonElementSave.Click += RadButtonElementSave_Click;

            this.radButtonElementExcelImport.Click += RadButtonElementExcelImport_Click;

            this.radButtonElementExcelExport.Click += RadButtonElementExcelExport_Click;

            this.radCheckBox1.CheckStateChanged += RadCheckBox_CheckStateChanged;

            this.radCheckBox2.CheckStateChanged += RadCheckBox_CheckStateChanged;

            this.radCheckBox3.CheckStateChanged += RadCheckBox_CheckStateChanged;

            this.radCheckBox4.CheckStateChanged += RadCheckBox_CheckStateChanged;

            this.radButtonSearch.Click += RadButtonSearch_Click;

            this.radButtonMapping.Click += RadButtonMapping_Click;

            this.radGridViewDocuments.ViewCellFormatting += RadGridViewDocuments_ViewCellFormatting;

            this.radGridViewDocuments.CellBeginEdit += RadGridViewDocuments_CellBeginEdit;

            this.radGridViewDocuments.CommandCellClick += RadGridViewDocuments_CommandCellClick;

            this.radGridViewDocuments.MasterView.TableHeaderRow.MinHeight = 36;

            this.radGridViewDocuments.TableElement.RowHeaderColumnWidth = 36;

            this.InitColumnGroupsViewDefinition(this.radGridViewDocuments);

        }

        #region Init, Load

        private void Initialize()

        {

            IEnumerable<UserInfo> allUserList = new UserController().GetAllUserInfo();

            allUserList.ToList().ForEach(x => informations.UserList.Add(x));

        }

        private void Main_Load(object sender, EventArgs e)

        {

            this.radGridViewDocuments.DataSource = this.documents;

        }

        #endregion

        #region Document List 조회

        public void GetDocList()

        {

            this.documents = new DocumentController().GetAllDocuments().ToList();

            this.orgDocuments = JsonConvert.DeserializeObject<List<Documents>>(JsonConvert.SerializeObject(this.documents));

            GridViewComboBoxColumn ColUserList = this.radGridViewDocuments.Columns["PersonInCharge"] as GridViewComboBoxColumn;

            ColUserList.DataSource = informations.UserList;

            ColUserList.DisplayMember = "Name";

            ColUserList.ValueMember = "ID";

            //Data

            if (this.radGridViewDocuments.DataSource != null)

                this.radGridViewDocuments.DataSource = null;

            this.radGridViewDocuments.DataSource = this.documents;

            if (this.radGridViewDocuments.SummaryRowsTop != null)

                this.radGridViewDocuments.SummaryRowsTop.Clear();

            string totalCount = String.Format("{0:#,###}", this.documents.Count());

            //Summary

            GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem()

                {

                    new GridViewSummaryItem("DocumentNo", "{0:#,###} / " + totalCount, GridAggregateFunction.Count)

                };

            this.radGridViewDocuments.SummaryRowsTop.Add(summaryRowItem);

            this.radGridViewDocuments.MasterView.SummaryRows[0].PinPosition = PinnedRowPosition.Top;

            this.radGridViewDocuments.MasterTemplate.BottomPinnedRowsMode = GridViewBottomPinnedRowsMode.Fixed;

        }

        #endregion

        #region button, checkbox event

        private void RadCheckBox_CheckStateChanged(object sender, EventArgs e)

        {

            if (sender is RadCheckBox)

            {

                RadCheckBox checkBox = sender as RadCheckBox;

                if (checkBox.Tag != null)

                {

                    ColumnGroupsViewDefinition columnGroupsView =  this.radGridViewDocuments.MasterTemplate.ViewDefinition as ColumnGroupsViewDefinition;

                    GridViewColumnGroup colGroup = columnGroupsView.GetAllGroups().Where(x => x.Name.Equals(checkBox.Tag.ToString())).FirstOrDefault();

                    if (colGroup != null)

                        colGroup.IsVisible = checkBox.Checked;

                }

            }

            //ColumnGroupsViewDefinition columnGroupsView = this.radGridViewDocuments.MasterTemplate.ViewDefinition = columnGroupsView;

        }

        private void RadButtonSearch_Click(object sender, EventArgs e)

        {

            this.GetDocList();

        }

        private void RadButtonMapping_Click(object sender, EventArgs e)

        {

        }

        #endregion

        #region grid event

        private void RadGridViewDocuments_CommandCellClick(object sender, GridViewCellEventArgs e)

        {

            if (e.Row is GridViewNewRowInfo)

            {

            }

            else

            {

                switch (e.Column.Name)

                {

                    case "AutoCADLink":

                        Controls.AutoCADViewer viewer = null;

                        foreach (var control in this.tableLayoutPanelRight.Controls)

                        {

                            if (control is Controls.AutoCADViewer _viewer)

                            {

                                viewer = _viewer;

                                break;

                            }

                        }

                        if (viewer == null)

                        {

                            viewer = new Controls.AutoCADViewer() { Dock = DockStyle.Fill };

                            this.tableLayoutPanelRight.Controls.Add(viewer);

                        }

                        else

                        {

                            viewer.Visible = true;

                        }

                        break;

                    case "PDFLink":

                        MessageBox.Show($"{e.Column.Name} 실행");

                        break;

                    case "MarkupLink":

                        MessageBox.Show($"{e.Column.Name} 실행");

                        break;

                    case "AVEVALink":

                    case "AVEVAConnection":

                        MessageBox.Show($"{e.Column.Name} 실행");

                        break;

                    case "ReviewFileName"://일단주석

                        MessageBox.Show($"{e.Column.Name} 실행");

                        break;

                    case "SystemLink":

                        MessageBox.Show($"{e.Column.Name} 실행");

                        break;

                    case "ToCapturePath":

                    case "FrCapturePath":

                        break;

                    case "ID2Connection":

                        MessageBox.Show($"{e.Column.Name} 실행");

                        break;

                }

            }

        }

        private void RadGridViewDocuments_CellBeginEdit(object sender, GridViewCellCancelEventArgs e)

        {

            if (e.ActiveEditor is RadDropDownListEditor)

            {

                switch (e.Column.Name)

                {

                    case "JobLevel":

                        GridViewComboBoxColumn ColJobLevel = this.radGridViewDocuments.Columns[e.Column.Name] as GridViewComboBoxColumn;

                        ColJobLevel.DataSource = informations.JobLevel;

                        break;

                    case "IsTypical":

                    case "ToIsDiscussion":

                    case "ToIsMarkup":

                    case "FrIsMarkup":

                    case "IsID2Work":

                    case "DTIsGateWay":

                    case "DTIsImport":

                    case "DTIsRegSystem":

                        GridViewComboBoxColumn ColYesNo = this.radGridViewDocuments.Columns[e.Column.Name] as GridViewComboBoxColumn;

                        ColYesNo.DataSource = (new string[] { string.Empty }).Union<string>(informations.IsYesNo);

                        break;

                    case "ID2Status":

                    case "AVEVAStatus":

                        GridViewComboBoxColumn ColJobStatus = this.radGridViewDocuments.Columns[e.Column.Name] as GridViewComboBoxColumn;

                        ColJobStatus.DataSource = (new string[] { string.Empty }).Union<string>(informations.JobStatus);

                        break;

                    case "FrReviewStatus"://삼성의견status

                        GridViewComboBoxColumn ColClientStatus = this.radGridViewDocuments.Columns[e.Column.Name] as GridViewComboBoxColumn;

                        ColClientStatus.DataSource = (new string[] { string.Empty }).Union<string>(informations.ClientStatus);

                        break;

                    case "ProdIsResult":

                    case "ClientIsResult":

                        GridViewComboBoxColumn ColResult = this.radGridViewDocuments.Columns[e.Column.Name] as GridViewComboBoxColumn;

                        ColResult.DataSource = (new string[] { string.Empty }).Union<string>(informations.ValidationResult);

                        break;

                }

            }

        }

        private void RadGridViewDocuments_ViewCellFormatting(object sender, CellFormattingEventArgs e)

        {

            if (e.Row is GridViewDataRowInfo)

            {

                if (e.CellElement is GridRowHeaderCellElement)

                {

                    if (e.CellElement.RowIndex > -1)

                        e.CellElement.Text = (e.CellElement.RowIndex + 1).ToString();

                }

                else

                {

                    var result = e.Row.DataBoundItem as Documents;

                    if (result != null || e.Row is GridViewNewRowInfo)

                    {

                        switch (e.CellElement.ColumnInfo.Name)

                        {

                            case "AutoCADLink":

                            case "PDFLink":

                            case "MarkupLink":

                            case "AVEVALink":

                            case "AVEVAConnection":

                            case "ReviewFileName"://일단주석

                            case "SystemLink":

                            case "ToCapturePath":

                            case "FrCapturePath":

                            case "ID2Connection":

                                this.GetCommandColBtnElement(e.CellElement.Children[0], e.CellElement.ColumnInfo.Name);

                                break;

                        }

                    }

                    else

                    {

                    }

                }

            }

            else if (e.Row is GridViewSummaryRowInfo)

            {

                if (e.CellElement is GridRowHeaderCellElement)

                {

                    e.CellElement.Text = "Count";

                }

                else if (e.CellElement is GridSummaryCellElement)

                {

                    e.CellElement.ForeColor = this._SummaryColor;

                    e.CellElement.TextAlignment = ContentAlignment.BottomRight;

                    e.CellElement.Font = new Font(e.CellElement.Font, FontStyle.Bold);

                }

                else

                {

                }

            }

            else

            {

            }

        }

        private RadButtonElement GetCommandColBtnElement(RadElement elem, string colName)

        {

            RadButtonElement btnElem = null;

            Bitmap bitmap = null; ;

            switch (colName)

            {

                case "AutoCADLink":

                    bitmap = new Bitmap(Properties.Resources.cad18);

                    break;

                case "PDFLink":

                    bitmap = new Bitmap(Properties.Resources.pdf18);

                    break;

                case "MarkupLink":

                    bitmap = new Bitmap(Properties.Resources.link18_green);

                    break;

                case "AVEVALink":

                case "AVEVAConnection":

                    bitmap = new Bitmap(Properties.Resources.link18_blue);

                    break;

                case "ReviewFileName"://일단주석

                    bitmap = new Bitmap(Properties.Resources.pdf18);

                    break;

                case "SystemLink":

                    bitmap = new Bitmap(Properties.Resources.link18_yellow);

                    break;

                case "ToCapturePath":

                case "FrCapturePath":

                    bitmap = new Bitmap(Properties.Resources.files18);

                    break;

                case "ID2Connection":

                    bitmap = new Bitmap(Properties.Resources.link18_purple);

                    break;

            }

            switch (colName)

            {

                case "AutoCADLink":

                case "PDFLink":

                case "MarkupLink":

                case "AVEVALink":

                case "AVEVAConnection":

                case "ReviewFileName"://일단주석

                case "SystemLink":

                case "ToCapturePath":

                case "FrCapturePath":

                case "ID2Connection":

                    btnElem = (RadButtonElement)elem;

                    btnElem.Margin = new Padding(0);

                    btnElem.Padding = new Padding(0);

                    btnElem.BorderElement.Opacity = 0;

                    btnElem.Alignment = ContentAlignment.MiddleCenter;

                    btnElem.DisplayStyle = DisplayStyle.Image;

                    btnElem.Image = bitmap;

                    btnElem.ImageAlignment = ContentAlignment.MiddleCenter;

                    btnElem.MaxSize = bitmap.Size;

                    break;

            }

            return btnElem;

        }

        #endregion

        #region Excel

        private void RadButtonElementExcelImport_Click(object sender, EventArgs e)

        {

            using (OpenFileDialog ofd = new OpenFileDialog()

            {

                Filter = "Excel files (*.xlsx)|*.xlsx",

                Title = "Open an Excel File",

                RestoreDirectory = true

            })

            {

                if (ofd.ShowDialog() == DialogResult.OK)

                {

                    //Error Message

                    StringBuilder sbErrMsg = new StringBuilder();

                    var exFile = ExcelFile.Load(ofd.FileName);

                    var ws = exFile.Worksheets[0];

                    int rowCount = ws.Rows.Count;

                    int columnCount = ws.CalculateMaxUsedColumns();

                    int exRow = 8;

                    #region Excel 유효성검사

                    //Excel 포멧체크

                    if (rowCount <= 10 || columnCount != 45)

                    {

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

                        return;

                    }

                    #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));

                    if (sbErrMsg.Length > 0)

                    {

                        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);

                        return;

                    }

                    #endregion

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

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

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

                                                 .GroupBy(g => g.Row.Index)

                                                 .Select(p => new {

                                                     rowIndex = p.Key,

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

                                                 })

                                                 .GroupBy(g => g.docNo)

                                                 .Where(p => p.Count() > 1)

                                                 .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()));

                    if (sbErrMsg.Length > 0)

                    {

                        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);

                        return;

                    }

                    #endregion

                    #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()

                           }));

                    this.documents.AddRange(appendDocuments);

                    this.radGridViewDocuments.DataSource = this.documents;

                    //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);

                    //            }

                    //        }

                    //    }

                    //}

                }

            }

        }

        private void RadButtonElementExcelExport_Click(object sender, EventArgs e)

        {

            string sPrefixName = "Samsung Elec Task Management";

            string extension = ".xlsx";

            using (SaveFileDialog sfd = new SaveFileDialog()

            {

                FileName = $"{sPrefixName}_{DateTime.Now:yyyyMMddhhmmss}{extension}",

                Filter = "Excel|*.xlsx",

                Title = "Save an Excel File",

                CheckFileExists = false,

                CheckPathExists = true,

                OverwritePrompt = true

            })

            {

                if (sfd.ShowDialog() == DialogResult.OK)

                {

                    string fileName = $"{sPrefixName}{extension}";

                    string templateFolder = Path.Combine(Path.GetDirectoryName(Application.ExecutablePath), "Template");

                    string templateFilePath = Path.Combine(templateFolder, fileName);

                    if (!File.Exists(templateFilePath))

                    {

                        RadMessageBox.Show(this, $"There is no {fileName} in {templateFolder}", "Error", MessageBoxButtons.OK, RadMessageIcon.Error);

                        return;

                    }

                    if (this.radGridViewDocuments.Rows.Count > 0)

                    {

                        var templateExcelFile = ExcelFile.Load(templateFilePath);

                        var templateWorksheets = templateExcelFile.Worksheets;

                        var templateWorksheet = templateWorksheets[0];

                        int rowIndex = 9;

                        //int colIndex = 1;

                        foreach (var row in this.radGridViewDocuments.Rows)

                        {

                            var doc = row.DataBoundItem as Documents;

                            templateWorksheet.Cells[rowIndex, 0].Value = doc.Seq;

                            //templateWorksheet.Cells[rowIndex, 1].Value = doc.DocumentNo;

                            //templateWorksheet.Cells[rowIndex, 2].Value = doc.DocumentNo;

                            //templateWorksheet.Cells[rowIndex, 3].Value = doc.DocumentNo;

                            //templateWorksheet.Cells[rowIndex, 4].Value = doc.DocumentNo;

                            templateWorksheet.Cells[rowIndex, 5].Value = doc.Place;

                            templateWorksheet.Cells[rowIndex, 6].Value = doc.DocumentNo;

                            templateWorksheet.Cells[rowIndex, 7].Value = doc.PersonInCharge;

                            templateWorksheet.Cells[rowIndex, 8].Value = doc.JobLevel;

                            templateWorksheet.Cells[rowIndex, 9].Value = doc.IsTypical;

                            templateWorksheet.Cells[rowIndex, 10].Value = doc.RevisonNo;

                            templateWorksheet.Cells[rowIndex, 11].Value = doc.ToIsDiscussion;

                            templateWorksheet.Cells[rowIndex, 12].Value = doc.ToRemarks;

                            templateWorksheet.Cells[rowIndex, 13].Value = doc.ToCreator;

                            templateWorksheet.Cells[rowIndex, 14].Value = doc.ToCapturePath;

                            templateWorksheet.Cells[rowIndex, 15].Value = doc.ToIsMarkup;

                            templateWorksheet.Cells[rowIndex, 16].Value = doc.FrReviewStatus;

                            templateWorksheet.Cells[rowIndex, 17].Value = doc.FrRemarks;

                            templateWorksheet.Cells[rowIndex, 18].Value = doc.FrCreator;

                            templateWorksheet.Cells[rowIndex, 19].Value = doc.FrCapturePath;

                            templateWorksheet.Cells[rowIndex, 20].Value = doc.FrIsMarkup;

                            templateWorksheet.Cells[rowIndex, 21].Value = doc.IsID2Work;

                            templateWorksheet.Cells[rowIndex, 22].Value = doc.ID2Connection;

                            templateWorksheet.Cells[rowIndex, 23].Value = doc.ID2StartDate;

                            templateWorksheet.Cells[rowIndex, 24].Value = doc.ID2EndDate;

                            templateWorksheet.Cells[rowIndex, 25].Value = doc.ID2JobTime;

                            templateWorksheet.Cells[rowIndex, 26].Value = doc.ID2Status;

                            templateWorksheet.Cells[rowIndex, 27].Value = doc.ID2Issues;

                            templateWorksheet.Cells[rowIndex, 28].Value = doc.AVEVAConnection;

                            templateWorksheet.Cells[rowIndex, 29].Value = doc.AVEVAConvertDate;

                            templateWorksheet.Cells[rowIndex, 30].Value = doc.AVEVAReviewDate;

                            templateWorksheet.Cells[rowIndex, 31].Value = doc.AVEVAStatus;

                            templateWorksheet.Cells[rowIndex, 32].Value = doc.AVEVAIssues;

                            //templateWorksheet.Cells[rowIndex, 33].Value = doc.DocumentNo;

                            //templateWorksheet.Cells[rowIndex, 34].Value = doc.DocumentNo;

                            templateWorksheet.Cells[rowIndex, 35].Value = doc.ProdReviewer;

                            templateWorksheet.Cells[rowIndex, 36].Value = doc.ProdIsResult;

                            templateWorksheet.Cells[rowIndex, 37].Value = doc.ProdRemarks;

                            templateWorksheet.Cells[rowIndex, 38].Value = doc.ClientReviewer;

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

                            templateWorksheet.Cells[rowIndex, 40].Value = doc.ClientRemarks;

                            templateWorksheet.Cells[rowIndex, 41].Value = doc.DTIsGateWay;

                            templateWorksheet.Cells[rowIndex, 42].Value = doc.DTIsImport;

                            templateWorksheet.Cells[rowIndex, 43].Value = doc.DTIsRegSystem;

                            templateWorksheet.Cells[rowIndex, 44].Value = doc.DTRemarks;

                            rowIndex++;

                        }

                        templateExcelFile.Save(sfd.FileName);

                        RadMessageBox.Show("Exporting 'ID2 Document List' is complete", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Info);

                    }

                }

            }

        }

        #endregion

        #region save event

        private void RadButtonElementSave_Click(object sender, EventArgs e)

        {

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

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

            var worker = new DocumentsWorker(this.documents, this.orgDocuments, setDocuments, delDocuments, this.radGridViewDocuments);

            worker.OnWorkCompletedHandler += () =>

            {

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

                if (result)

                {

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

                    this.GetDocList();

                }

                else

                {

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

                }

            };

            worker.StartWork();

        }

        #endregion

        #region ColumnGroup

        private void InitColumnGroupsViewDefinition(RadGridView gridView)

        {

            ColumnGroupsViewDefinition columnGroupsView = new ColumnGroupsViewDefinition();

            List<string> docLinkColNames = new List<string>() { "AutoCADLink", "PDFLink", "MarkupLink", "AVEVALink" };

            List<string> docInfoColNames = new List<string>() { "Place", "DocumentNo", "PersonInCharge", "JobLevel", "IsTypical", "RevisonNo" };

            List<string> rvToColNames = new List<string>() { "ToIsDiscussion", "ToRemarks", "ToModifier", "ToCapturePath", "ToIsMarkup" };

            List<string> rvFrColNames = new List<string>() { "FrReviewStatus", "FrRemarks", "FrModifier", "FrCapturePath", "FrIsMarkup" };

            List<string> rvEtcColNames = new List<string>() { "IsID2Work" };

            List<string> wkID2ColNames = new List<string>() { "ID2Connection", "ID2StartDate", "ID2EndDate", "ID2JobTime", "ID2Status", "ID2Issues" };

            List<string> wkAVEVAColNames = new List<string>() { "AVEVAConnection", "AVEVAConvertDate", "AVEVAReviewDate", "AVEVAStatus", "AVEVAIssues" };

            List<string> valLinkColNames = new List<string>() { "ReviewFileName", "SystemLink" };

            List<string> valProdColNames = new List<string>() { "ProdReviewer", "ProdIsResult", "ProdRemarks" };

            List<string> valCntColNames = new List<string>() { "ClientReviewer", "ClientIsResult", "ClientRemarks" };

            List<string> dtColNames = new List<string>() { "DTIsGateWay", "DTIsImport", "DTIsRegSystem", "DTRemarks" };

            //도면

            GridViewColumnGroup docColGrp = new GridViewColumnGroup("도면 ");

            GridViewColumnGroup docLinkColGrp = new GridViewColumnGroup("파일링크");

            GridViewColumnGroup docInfoColGrp = new GridViewColumnGroup("도면정보");

            GridViewColumnGroupRow docLinkColGrpRow = new GridViewColumnGroupRow();

            docLinkColGrpRow.ColumnNames.AddRange(docLinkColNames);

            GridViewColumnGroupRow docInfoColGrpRow = new GridViewColumnGroupRow();

            docInfoColGrpRow.ColumnNames.AddRange(docInfoColNames);

            docLinkColGrp.Rows.Add(docLinkColGrpRow);

            docColGrp.Groups.Add(docLinkColGrp);

            docInfoColGrp.Rows.Add(docInfoColGrpRow);

            docColGrp.Groups.Add(docInfoColGrp);

            //검토

            GridViewColumnGroup rvColGrp = new GridViewColumnGroup("검토", "review");

            GridViewColumnGroup rvToColGrp = new GridViewColumnGroup("도프텍");

            GridViewColumnGroup rvFrColGrp = new GridViewColumnGroup("삼성");

            GridViewColumnGroup rvEtcColGrp = new GridViewColumnGroup("기타");

            GridViewColumnGroupRow rvToColGrpRow = new GridViewColumnGroupRow();

            rvToColGrpRow.ColumnNames.AddRange(rvToColNames);

            GridViewColumnGroupRow rvFrColGrpRow = new GridViewColumnGroupRow();

            rvFrColGrpRow.ColumnNames.AddRange(rvFrColNames);

            GridViewColumnGroupRow rvEtcColGrpRow = new GridViewColumnGroupRow();

            rvEtcColGrpRow.ColumnNames.AddRange(rvEtcColNames);

            rvToColGrp.Rows.Add(rvToColGrpRow);

            rvFrColGrp.Rows.Add(rvFrColGrpRow);

            rvEtcColGrp.Rows.Add(rvEtcColGrpRow);

            rvColGrp.Groups.Add(rvToColGrp);

            rvColGrp.Groups.Add(rvFrColGrp);

            rvColGrp.Groups.Add(rvEtcColGrp);

            //작업

            GridViewColumnGroup wkColGrp = new GridViewColumnGroup("작업", "work");

            GridViewColumnGroup wkID2ColGrp = new GridViewColumnGroup("ID2");

            GridViewColumnGroup wkAVEVAColGrp = new GridViewColumnGroup("AVEVA");

            GridViewColumnGroupRow wkID2ColGrpRow = new GridViewColumnGroupRow();

            wkID2ColGrpRow.ColumnNames.AddRange(wkID2ColNames);

            GridViewColumnGroupRow wkAVEVAColGrpRow = new GridViewColumnGroupRow();

            wkAVEVAColGrpRow.ColumnNames.AddRange(wkAVEVAColNames);

            wkID2ColGrp.Rows.Add(wkID2ColGrpRow);

            wkAVEVAColGrp.Rows.Add(wkAVEVAColGrpRow);

            wkColGrp.Groups.Add(wkID2ColGrp);

            wkColGrp.Groups.Add(wkAVEVAColGrp);

            //Validation

            GridViewColumnGroup valColGrp = new GridViewColumnGroup("Validation", "validation");

            GridViewColumnGroup valLinkColGrp = new GridViewColumnGroup("파일링크");

            GridViewColumnGroup valProdColGrp = new GridViewColumnGroup("도프텍");

            GridViewColumnGroup valCntColGrp = new GridViewColumnGroup("삼성전자");

            GridViewColumnGroupRow valLinkColGrpRow = new GridViewColumnGroupRow();

            valLinkColGrpRow.ColumnNames.AddRange(valLinkColNames);

            GridViewColumnGroupRow valProdColGrpRow = new GridViewColumnGroupRow();

            valProdColGrpRow.ColumnNames.AddRange(valProdColNames);

            GridViewColumnGroupRow valCntColGrpRow = new GridViewColumnGroupRow();

            valCntColGrpRow.ColumnNames.AddRange(valCntColNames);

            valLinkColGrp.Rows.Add(valLinkColGrpRow);

            valProdColGrp.Rows.Add(valProdColGrpRow);

            valCntColGrp.Rows.Add(valCntColGrpRow);

            valColGrp.Groups.Add(valLinkColGrp);

            valColGrp.Groups.Add(valProdColGrp);

            valColGrp.Groups.Add(valCntColGrp);

            //AVEVA Net

            GridViewColumnGroup dtColGrp = new GridViewColumnGroup("AVEVA Net\n(Digital Twin)", "avevanet");

            GridViewColumnGroupRow dtColGrpRow = new GridViewColumnGroupRow();

            dtColGrpRow.ColumnNames.AddRange(dtColNames);

            dtColGrp.Rows.Add(dtColGrpRow);

            //Group 추가

            columnGroupsView.ColumnGroups.Add(docColGrp);

            columnGroupsView.ColumnGroups.Add(rvColGrp);

            columnGroupsView.ColumnGroups.Add(wkColGrp);

            columnGroupsView.ColumnGroups.Add(valColGrp);

            columnGroupsView.ColumnGroups.Add(dtColGrp);

            gridView.MasterTemplate.ViewDefinition = columnGroupsView;

        }

        #endregion

        class DocumentsWorker : BaseWorker

        {

            public delegate void OnWorkCompleted();

            public OnWorkCompleted OnWorkCompletedHandler;

            List<Documents> docList { get; set; }

            List<Documents> orgList { get; set; }

            List<Documents> setList { get; set; }

            List<Documents> delList { get; set; }

            public DocumentsWorker(List<Documents> docList, List<Documents> orgDocList, List<Documents> setDocList, List<Documents> delDocList, Control parent = null) : base(parent)

            {

                this.docList = docList;

                this.orgList = orgDocList;

                this.setList = setDocList;

                this.delList = delDocList;

            }

            protected override void DoWork(BackgroundWorker worker)

            {

                //수정리스트

                this.docList.Where(x => !this.orgList.Any(y => y.Equals(x)))

                              .ToList().ForEach(x => this.setList.Add(x));

                //삭제리스트

                this.delList.AddRange(this.orgList.Except(this.docList, new DocumentsKeyComparer()));

            }

            protected override void WorkCompleted()

            {

                if (this.OnWorkCompletedHandler != null) this.OnWorkCompletedHandler();

            }

        }

    }

}