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.Controls;

using ID2.Manager.Common;

using ID2.Manager.Classes;

using ID2.Manager.Data.Models;

using ID2.Manager.Forms;

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;

using System.Diagnostics;

namespace ID2.Manager

{

    public partial class Main : RadRibbonForm

    {

        readonly Informations informations = Informations.Instance;

        bool IsID2Manager = false;

        List<MarkupText> Markups = new List<MarkupText>();

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

        List<Documents> orgDocuments = null;

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

        public Main()

        {

            InitializeComponent();

            Telerik.WinControls.RadControlSpy.RadControlSpyForm radControlSpyForm = new Telerik.WinControls.RadControlSpy.RadControlSpyForm();

            radControlSpyForm.Show();

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

            this.Load += Main_Load;

            this.radButtonElementRefreshCommand.Click += RadButtonElementRefreshCommand_Click;

            this.radButtonElementSaveCommand.Click += RadButtonElementSaveCommand_Click;

            this.radButtonElementSave.Click += RadButtonElementSave_Click;

            this.radButtonElementSync.Click += RadButtonElementSync_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.radTextBoxDocumentNo.KeyDown += RadTextBoxDocumentNo_KeyDown;

            this.radButtonSearch.Click += RadButtonSearch_Click;

            this.radGridViewDocuments.SelectionChanged += RadGridViewDocuments_SelectionChanged;

            this.radGridViewDocuments.ViewCellFormatting += RadGridViewDocuments_ViewCellFormatting;

            this.radGridViewDocuments.CreateRow += RadGridViewDocuments_CreateRow;

            this.radGridViewDocuments.CreateRowInfo += RadGridViewDocuments_CreateRowInfo;

            this.radGridViewDocuments.CreateCell += RadGridViewDocuments_CreateCell1;

            this.radGridViewDocuments.CellBeginEdit += RadGridViewDocuments_CellBeginEdit;

            this.radGridViewDocuments.CommandCellClick += RadGridViewDocuments_CommandCellClick;

            this.radGridViewDocuments.MasterView.TableSearchRow.SearchProgressChanged += TableSearchRow_SearchProgressChanged;

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

            this.radGridViewDocuments.TableElement.RowHeaderColumnWidth = 36;

            //this.radGridViewDocuments.MasterView.TableSearchRow.InitialSearchResultsTreshold = ;

            this.radGridViewDocuments.MasterView.TableSearchRow.IsVisible = false;

            var detailGridview = new DetailGridViewTemplate();

            detailGridview.DataSource = Markups;

            this.radGridViewDocuments.MasterTemplate.Templates.Add(detailGridview);

            GridViewRelation relation = new GridViewRelation(this.radGridViewDocuments.MasterTemplate);

            relation.ChildTemplate = detailGridview;

            relation.RelationName = "MarkupTextRelation";

            relation.ParentColumnNames.Add("DocumentNo");

            relation.ChildColumnNames.Add("DOCUMENT_ID");

            this.radGridViewDocuments.Relations.Add(relation);

            var openProjectView = new OpenProjectView()

            {

                Dock = DockStyle.Fill

            };

            this.backstageViewPageOpenProject.Controls.Add(openProjectView);

            openProjectView.OpenProjectClick += OpenProjectView_OpenProjectClick;

            openProjectView.CloseProjectClick += OpenProjectView_OpenProjectClick;

            this.backstageButtonItemUserRegistration.Click += BackstageButtonItemUserRegistration_Click;

            this.backstageButtonItemExit.Click += BackstageButtonItemExit_Click;

            this.radRibbonBarBackstageViewID2Manager.BackstageViewOpened += RadRibbonBarBackstageViewID2Manager_BackstageViewOpened;

            this.radRibbonBarBackstageViewID2Manager.BackstageViewClosed += RadRibbonBarBackstageViewID2Manager_BackstageViewClosed;

            this.InitColumnGroupsViewDefinition(this.radGridViewDocuments);

            this.Initialize();

        }

        private void RadGridViewDocuments_CreateRowInfo(object sender, GridViewCreateRowInfoEventArgs e)

        {

            if (e.RowInfo is GridViewSearchRowInfo)

            {

                e.RowInfo = new SearchRow(e.ViewInfo);

            }

        }

        private void TableSearchRow_SearchProgressChanged(object sender, SearchProgressChangedEventArgs e)

        {

            if (e.SearchFinished)

            {

            }

        }

        /// <summary>

        /// 선택된 행의 AutoCAD와 PDF 파일을 보여준다.

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void RadGridViewDocuments_SelectionChanged(object sender, EventArgs e)

        {

            void ShowAutoCADFile(string FilePath)

            {

                Controls.AutoCADViewer viewer = null;

                foreach (var control in this.radPageViewPageAutoCAD.Controls)

                {

                    if (control is Controls.AutoCADViewer _viewer)

                    {

                        viewer = _viewer;

                        break;

                    }

                }

                if (viewer == null)

                {

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

                    this.radPageViewPageAutoCAD.Controls.Add(viewer);

                }

                else

                {

                    viewer.Visible = true;

                }

                if (File.Exists(FilePath) && viewer != null) viewer.ReadDWG(FilePath);

            }

            void ShowPDFFile(string FilePath)

            {

                Controls.PDFViewer viewer = null;

                foreach (var control in this.radPageViewPagePDF.Controls)

                {

                    if (control is Controls.PDFViewer _viewer)

                    {

                        viewer = _viewer;

                        break;

                    }

                }

                if (viewer == null)

                {

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

                    this.radPageViewPagePDF.Controls.Add(viewer);

                }

                else

                {

                    viewer.Visible = true;

                }

                if (File.Exists(FilePath) && viewer != null) viewer.ReadPDF(FilePath);

            }

            if (this.radGridViewDocuments.SelectedRows.Count() > 0 && this.radGridViewDocuments.SelectedRows.First().DataBoundItem is Documents doc)

            {

                string dwgExtension = ".dwg";

                string dwgFilePath = Path.Combine(informations.FindID2LocalPath(doc.RefProjectCode), "drawings", "Native", $"{doc.DocumentNo}{dwgExtension}");

                ShowAutoCADFile(dwgFilePath);

                string pdfExtension = ".pdf";

                string pdfFilePath = Path.Combine(informations.FindID2LocalPath(doc.RefProjectCode), "drawings", $"{doc.DocumentNo}{pdfExtension}");

                ShowPDFFile(pdfFilePath);

                //if (informations.ActiveUser.ID != doc.PersonInCharge)

                //{

                //    var row = this.radGridViewDocuments.SelectedRows.First();

                //    foreach(var cell in row.Cells)

                //    {

                //        cell.ReadOnly = true;

                //    }

                //}

            }

        }

        #region Init, Load

        private void Initialize()

        {

            this.Text = Globals.Name;

            this.ID2ManagerRadRibbonBar.Expanded = false;

            this.radLabelElementUser.Text = $"{informations.ActiveUser.ID} {informations.ActiveUser.Name}";

            this.IsID2Manager = (new string[] { "Admin", "Manager" }).Contains(informations.ActiveUser.Role) && string.IsNullOrEmpty(informations.ActiveUser.RefProjectID);

            if (this.IsID2Manager)

            {

                this.backstageViewPageOpenProject.Controls[0].Visible = true;

                this.backstageTabItemOpenProject.Visibility = ElementVisibility.Visible;

                this.backstageButtonItemUserRegistration.Visibility = ElementVisibility.Visible;

            }

            else

            {

                if (string.IsNullOrEmpty(informations.ActiveUser.RefProjectID))

                {

                    this.backstageViewPageOpenProject.Controls[0].Visible = true;

                }

                else

                {

                    foreach (Control ctrl in this.backstageViewPageOpenProject.Controls)

                    {

                        ctrl.Visible = false;

                    }

                }

                this.backstageTabItemOpenProject.Visibility = ElementVisibility.Collapsed;

                this.backstageButtonItemUserRegistration.Visibility = ElementVisibility.Collapsed;

            }

        }

        protected override void OnLoad(EventArgs e)

        {

            if (informations.ActiveUser != null && !string.IsNullOrEmpty(informations.ActiveUser.RefProjectID))

            {

                informations.ActiveProject = new ProjectController().GetProjectInfo(informations.ActiveUser.RefProjectID);

                informations.ProjectList = new ProjectController().GetAllProjectList().ToList();

                this.LoadProject();

            }

            else

            {

                this.radRibbonBarBackstageViewID2Manager.ShowPopup(this.GetBackstageLocation(), this.ID2ManagerRadRibbonBar.RibbonBarElement);

            }

            base.OnLoad(e);

        }

        public Point GetBackstageLocation()

        {

            Point location = this.ID2ManagerRadRibbonBar.RibbonBarElement.ApplicationButtonElement.ControlBoundingRectangle.Location;

            location.Offset(new Point(0, this.ID2ManagerRadRibbonBar.RibbonBarElement.ApplicationButtonElement.ControlBoundingRectangle.Height));

            location.Offset(this.ID2ManagerRadRibbonBar.Location);

            return location;

        }

        private void Main_Load(object sender, EventArgs e)

        {

            InitializeSearch();

            InitializeGridViewDetail();

            this.radGridViewDocuments.DataSource = new BindingList<Documents>(this.documents);

        }

        private void InitializeSearch()

        {

            var font1 = ThemeResolutionService.GetCustomFont("TelerikWebUI");

            lbSearch.Text = "\ue13E";

            btnSearchNext.Text = "\ue006";

            btnSearchPrevious.Text = "\ue004";

            var chkbox = new RadCheckBoxElement();

            chkbox.Text = "Match Case";

            chkbox.CheckStateChanged += (snd, evt) => { radGridViewDocuments.MasterView.TableSearchRow.CaseSensitive = chkbox.Checked; };

            btnMatchCase.HostedItem = chkbox;

            var chkbox1 = new RadCheckBoxElement();

            chkbox1.Text = "Show All Detail";

            chkbox1.CheckStateChanged += (snd, evt) => 

            { 

                radGridViewDocuments.MasterView.ChildRows.ForAll(x=>x.IsExpanded = chkbox1.Checked); 

            };

            btnShowAllDetail.HostedItem = chkbox1;

            var chkbox2 = new RadCheckBoxElement();

            chkbox2.Text = "Search from current position";

            chkbox2.CheckStateChanged += (snd, evt) => { radGridViewDocuments.MasterView.TableSearchRow.SearchFromCurrentPosition = chkbox.Checked; };

            btnSearchFormCurrent.HostedItem = chkbox2;

            var columns = radGridViewDocuments.Columns.Where(x => x.AllowSearching).Select(x =>

                                 new FilterColumn

                                 {

                                     Name = x.HeaderText,

                                     FieldName = x.FieldName,

                                     IsSelect = x.AllowSearching

                                 });

            var panel = new StackLayoutElement();

            panel.Orientation = Orientation.Vertical;

            var btnComboColumns = new RadCheckedDropDownListElement();

            btnComboColumns.ShowCheckAllItems = true;

            btnComboColumns.CheckAllItem.Checked = true;

            btnComboColumns.AutoCompleteEditableAreaElement.NullText = "Search in Columns";

            btnComboColumns.AutoCompleteEditableAreaElement.AutoCompleteTextBox.IsReadOnly = true;

            btnComboColumns.DropDownMinSize = new Size(200, 200);

            btnComboColumns.DropDownSizingMode = SizingMode.UpDownAndRightBottom;

            btnComboColumns.DisplayMember = "Name";

            btnComboColumns.CheckedMember = "IsSelect";

            btnComboColumns.ValueMember = "FieldName";

            btnComboColumns.TextBox.CustomFont = font1.Name;

            btnComboColumns.TextBox.Text = "\ue13A";

            btnComboColumns.DataSource = columns;

            txtFullSearch.TextBoxElement.ClearButton.Click += (snd, evt) =>

            {

                radGridViewDocuments.MasterTemplate.Refresh(null);

            };

            btnComboColumns.PopupOpening += (snd, evt) =>

            {

                (snd as RadCheckedDropDownListElement).CheckAllItem.Checked = (snd as RadCheckedDropDownListElement).Items.All(x => (x.DataBoundItem as FilterColumn).IsSelect);

            };

            btnComboColumns.PopupClosed += (snd, evt) =>

            {

                foreach (RadCheckedListDataItem item in btnComboColumns.Items)

                {

                    radGridViewDocuments.Columns[item.Value.ToString()].AllowSearching = item.Checked;

                }

            };

            btnFilters.HostedItem = btnComboColumns;

        }

        private void InitializeGridViewDetail()

        {

            this.radGridViewDocuments.ChildViewExpanded += RadGridViewDocuments_ChildViewExpanded;

        }

        private void RadGridViewDocuments_ChildViewExpanded(object sender, ChildViewExpandedEventArgs e)

        {

            //e.ChildRow.ChildViewInfos[0].ChildRows[0].Height = 152;

            //e.ChildRow.ChildViewInfos[2].ChildRows[0].Height = 152;

            e.ChildRow.Height = 224;

        }

        #endregion

        private void OpenProjectView_OpenProjectClick(object sender, EventArgs e)

        {

            this.radRibbonBarBackstageViewID2Manager.Tag = e;

            this.radRibbonBarBackstageViewID2Manager.HidePopup();

        }

        private void RadRibbonBarBackstageViewID2Manager_BackstageViewOpened(object sender, EventArgs e)

        {

            this.radRibbonBarBackstageViewID2Manager.SelectedItem = this.backstageTabItemOpenProject;

            foreach ( Control ctrl in this.backstageViewPageOpenProject.Controls)

            {

                if (ctrl is OpenProjectView)

                {

                    var openProjectView = ctrl as OpenProjectView;

                    openProjectView.GetProjectGroups();

                    break;

                }

            }

        }

        private void RadRibbonBarBackstageViewID2Manager_BackstageViewClosed(object sender, EventArgs e)

        {

            if (this.radRibbonBarBackstageViewID2Manager.Tag is ProjectEventArgs)

            {

                var prjArgs = this.radRibbonBarBackstageViewID2Manager.Tag as ProjectEventArgs;

                informations.ActiveProject = prjArgs.ProjectInfo;

                this.radRibbonBarBackstageViewID2Manager.Tag = null;

                this.LoadProject();

            }

        }

        private void LoadProject()

        {

            #region 도면

            //Project List

            if (this.radDropDownListProject.Items.Count > 0)

                this.radDropDownListProject.Items.Clear();

            informations.ProjectList.Where(x => x.GroupID.Equals(informations.ActiveProject.ProjectID)).ToList()

                                    .ForEach(x =>

                                    {

                                        this.radDropDownListProject.Items.Add(new RadListDataItem(x.Name, x.Code));

                                    });

            var allProject = new RadListDataItem("== 전체 ==", string.Empty);

            this.radDropDownListProject.Items.Insert(0, allProject);

            allProject.Selected = true;

            //담당자 List

            if (this.radDropDownListPersonInCharge.Items.Count > 0)

                this.radDropDownListPersonInCharge.Items.Clear();

            informations.UserList.ForEach(x =>

            {

                if ((new string[] { "Manager", "User" }).Contains(x.Role) && string.IsNullOrEmpty(x.RefProjectID))

                    this.radDropDownListPersonInCharge.Items.Add(new RadListDataItem(x.Name, x.ID));

            });

            var allUser = new RadListDataItem("== 전체 ==", string.Empty);

            this.radDropDownListPersonInCharge.Items.Insert(0, allUser);

            allUser.Selected = true;

            //난이도

            if (this.radDropDownListJobLevel.Items.Count > 0)

                this.radDropDownListJobLevel.Items.Clear();

            informations.JobLevel.ForEach(x =>

            {

                this.radDropDownListJobLevel.Items.Add(new RadListDataItem(x, x));

            });

            var allJobLevel = new RadListDataItem("== 전체 ==", string.Empty);

            this.radDropDownListJobLevel.Items.Insert(0, allJobLevel);

            allJobLevel.Selected = true;

            //도면번호 조회조건

            this.radTextBoxDocumentNo.Text = string.Empty;

            #endregion

            #region 검토

            //문의(DOF)

            if (this.radDropDownListToIsDiscussion.Items.Count > 0)

                this.radDropDownListToIsDiscussion.Items.Clear();

            informations. IsYesNo.ForEach(x =>

            {

                this.radDropDownListToIsDiscussion.Items.Add(new RadListDataItem(x, x));

            });

            var allToIsDiscussion = new RadListDataItem("== 전체 ==", string.Empty);

            this.radDropDownListToIsDiscussion.Items.Insert(0, allToIsDiscussion);

            allToIsDiscussion.Selected = true;

            //회신(DS)

            if (this.radDropDownListFrReviewStatus.Items.Count > 0)

                this.radDropDownListFrReviewStatus.Items.Clear();

            informations.ClientStatus.ForEach(x =>

            {

                this.radDropDownListFrReviewStatus.Items.Add(new RadListDataItem(x, x));

            });

            var allFrReviewStatus = new RadListDataItem("== 전체 ==", string.Empty);

            this.radDropDownListFrReviewStatus.Items.Insert(0, allFrReviewStatus);

            allFrReviewStatus.Selected = true;

            //ID2 작업가능

            if (this.radDropDownListIsID2Work.Items.Count > 0)

                this.radDropDownListIsID2Work.Items.Clear();

            informations.IsYesNo.ForEach(x =>

            {

                var item = new RadListDataItem(x, x);

                if (x.Equals("Yes"))

                    item.Selected = true;

                this.radDropDownListIsID2Work.Items.Add(item);

            });

            var allIsID2Work = new RadListDataItem("== 전체 ==", string.Empty);

            this.radDropDownListIsID2Work.Items.Insert(0, allIsID2Work);

            #endregion

            #region 작업

            //ID2 Status

            if (this.radDropDownListID2Status.Items.Count > 0)

                this.radDropDownListID2Status.Items.Clear();

            informations.JobStatus.ForEach(x =>

            {

                this.radDropDownListID2Status.Items.Add(new RadListDataItem(x, x));

            });

            var allID2Status = new RadListDataItem("== 전체 ==", string.Empty);

            this.radDropDownListID2Status.Items.Insert(0, allID2Status);

            allID2Status.Selected = true;

            //AVEVA Status

            if (this.radDropDownListAVEVAStatus.Items.Count > 0)

                this.radDropDownListAVEVAStatus.Items.Clear();

            informations.JobStatus.ForEach(x =>

            {

                this.radDropDownListAVEVAStatus.Items.Add(new RadListDataItem(x, x));

            });

            var allAVEVAStatus = new RadListDataItem("== 전체 ==", string.Empty);

            this.radDropDownListAVEVAStatus.Items.Insert(0, allAVEVAStatus);

            allAVEVAStatus.Selected = true;

            #endregion

            #region 확인

            //도프텍 결과

            if (this.radDropDownListProdIsResult.Items.Count > 0)

                this.radDropDownListProdIsResult.Items.Clear();

            informations.ValidationResult.ForEach(x =>

            {

                this.radDropDownListProdIsResult.Items.Add(new RadListDataItem(x, x));

            });

            var allProdIsResult = new RadListDataItem("== 전체 ==", string.Empty);

            this.radDropDownListProdIsResult.Items.Insert(0, allProdIsResult);

            allProdIsResult.Selected = true;

            //삼성 결과

            if (this.radDropDownListClientIsResult.Items.Count > 0)

                this.radDropDownListClientIsResult.Items.Clear();

            informations.ValidationResult.ForEach(x =>

            {

                this.radDropDownListClientIsResult.Items.Add(new RadListDataItem(x, x));

            });

            var allClientIsResult = new RadListDataItem("== 전체 ==", string.Empty);

            this.radDropDownListClientIsResult.Items.Insert(0, allClientIsResult);

            allClientIsResult.Selected = true;

            #endregion

            this.GetDocList();

            this.DocumentListBinding();

        }

        #region Document List 조회

        public void GetDocList()

        {

            if (this.radDropDownListProject.SelectedValue != null)

            {

                string projectCode = this.radDropDownListProject.SelectedValue.ToString();

                string personIncharge = this.radDropDownListPersonInCharge.SelectedValue.ToString();

                string jobLevel = this.radDropDownListJobLevel.SelectedValue.ToString();//

                string documentNo = this.radTextBoxDocumentNo.Text.Trim();

                string isToIsDiscussion = this.radDropDownListToIsDiscussion.SelectedValue.ToString();

                string isFrReviewStatus = this.radDropDownListFrReviewStatus.SelectedValue.ToString();

                string isID2Work = this.radDropDownListIsID2Work.SelectedValue.ToString();//

                string id2Status = this.radDropDownListID2Status.SelectedValue.ToString();//

                string avevaStatus = this.radDropDownListAVEVAStatus.SelectedValue.ToString();//

                string prodIsResult = this.radDropDownListProdIsResult.SelectedValue.ToString();//

                string clientIsResult = this.radDropDownListClientIsResult.SelectedValue.ToString();//

                var (dwgs, totalCnt) = new DocumentController().GetDocuments(projectCode, personIncharge, jobLevel, documentNo, isToIsDiscussion, isFrReviewStatus, isID2Work, id2Status, avevaStatus, prodIsResult, clientIsResult);

                this.documents = dwgs.ToList();

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

                this.lbSelectAndTotal.Text = totalCnt.ToString();

                List<string> projectCodes = new List<string>();

                if(!string.IsNullOrWhiteSpace(projectCode))

                {

                    projectCodes.Add(projectCode);

                }

                else

                {

                    projectCodes = informations.ProjectList.Select(x => x.Code).ToList();

                }

                this.Markups = new List<MarkupText>(new MarkusInfoController().GetMarkupData(projectCodes, this.documents.Select(x => x.DocumentNo)));

            }

        }

        public void GetDocListbyID2()

        {

            if (this.radDropDownListProject.SelectedValue != null)

            {

                string projectCode = this.radDropDownListProject.SelectedValue.ToString();

                string personIncharge = this.radDropDownListPersonInCharge.SelectedValue.ToString();

                string jobLevel = this.radDropDownListJobLevel.SelectedValue.ToString();

                string documentNo = this.radTextBoxDocumentNo.Text.Trim();

                string isToIsDiscussion = this.radDropDownListToIsDiscussion.SelectedValue.ToString();

                string isFrReviewStatus = this.radDropDownListFrReviewStatus.SelectedValue.ToString();

                string isID2Work = this.radDropDownListIsID2Work.SelectedValue.ToString();

                string id2Status = this.radDropDownListID2Status.SelectedValue.ToString();

                string avevaStatus = this.radDropDownListAVEVAStatus.SelectedValue.ToString();

                string prodIsResult = this.radDropDownListProdIsResult.SelectedValue.ToString();

                string clientIsResult = this.radDropDownListClientIsResult.SelectedValue.ToString();

                var id2Prjs = informations.ProjectList.Where(x => x.GroupID.Equals(informations.ActiveProject.ProjectID)).Select(x => x.ID2Info).ToList();

                var(dwgs, totalCnt) = new DocumentController().GetDocuments(id2Prjs, projectCode, personIncharge, jobLevel, documentNo, isToIsDiscussion, isFrReviewStatus, isID2Work, id2Status, avevaStatus, prodIsResult, clientIsResult);

                this.documents = dwgs.ToList();

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

                this.lbSelectAndTotal.Text = totalCnt.ToString();

            }

        }

        public void DocumentListBinding()

        {

            GridViewComboBoxColumn ColProjects = this.radGridViewDocuments.Columns["RefProjectCode"] as GridViewComboBoxColumn;

            ColProjects.DataSource = informations.ProjectList.Where(x => x.GroupID.Equals(informations.ActiveProject.ProjectID)).ToList();

            ColProjects.DisplayMember = "Name";

            ColProjects.ValueMember = "Code";

            var workUsers = informations.UserList.Where(x => (new string[] { "Manager", "User" }).Contains(x.Role) && string.IsNullOrEmpty(x.RefProjectID));

            var clientUsers = informations.UserList.Where(x => !string.IsNullOrEmpty(x.RefProjectID));

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

            ColPersonInCharge.DataSource = workUsers;

            ColPersonInCharge.DisplayMember = "Name";

            ColPersonInCharge.ValueMember = "ID";

            GridViewComboBoxColumn ColWorker = this.radGridViewDocuments.Columns["Worker"] as GridViewComboBoxColumn;

            ColWorker.DataSource = workUsers;

            ColWorker.DisplayMember = "Name";

            ColWorker.ValueMember = "ID";

            GridViewComboBoxColumn ColToCreator = this.radGridViewDocuments.Columns["ToCreator"] as GridViewComboBoxColumn;

            ColToCreator.DataSource = workUsers;

            ColToCreator.DisplayMember = "Name";

            ColToCreator.ValueMember = "ID";

            GridViewComboBoxColumn ColFrCreator = this.radGridViewDocuments.Columns["FrCreator"] as GridViewComboBoxColumn;

            ColFrCreator.DataSource = clientUsers;

            ColFrCreator.DisplayMember = "Name";

            ColFrCreator.ValueMember = "ID";

            GridViewComboBoxColumn ColProdReviewer = this.radGridViewDocuments.Columns["ProdReviewer"] as GridViewComboBoxColumn;

            ColProdReviewer.DataSource = workUsers;

            ColProdReviewer.DisplayMember = "Name";

            ColProdReviewer.ValueMember = "ID";

            GridViewComboBoxColumn ColClientReviewer = this.radGridViewDocuments.Columns["ClientReviewer"] as GridViewComboBoxColumn;

            ColClientReviewer.DataSource = clientUsers;

            ColClientReviewer.DisplayMember = "Name";

            ColClientReviewer.ValueMember = "ID";

            //Data

            if (this.radGridViewDocuments.DataSource != null)

                this.radGridViewDocuments.DataSource = null;

            /*

            var info = informations.ProjectList.Where(x => x.Name.Equals("APAO")).FirstOrDefault().ID2Info;

            var id2Datas = new DocumentController(info).GetID2DrawingsByProject(info);

            var test = from doc in this.documents

                       join id2 in id2Datas on doc.DocumentNo equals id2.DOCNAME into gj

                       from docs in gj.DefaultIfEmpty()

                       select new Documents()

                       {

                           DocumentNo = doc.DocumentNo,

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

                           //ProdRemarks = docs.DATETIME ?? null

                       };

            */

            this.radGridViewDocuments.DataSource = new BindingList<Documents>(this.documents);

            if (this.radGridViewDocuments.SummaryRowsBottom != null)

                this.radGridViewDocuments.SummaryRowsBottom.Clear();

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

            //Summary

            GridViewSummaryRowItem summaryRowItem = new GridViewSummaryRowItem()

            {

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

            };

            this.radGridViewDocuments.SummaryRowsBottom.Add(summaryRowItem);

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

            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 RadTextBoxDocumentNo_KeyDown(object sender, KeyEventArgs e)

        {

            if (e.KeyCode == Keys.Enter)

            {

                this.radButtonSearch.Focus();

                this.radButtonSearch.PerformClick();

            }

        }

        private void RadButtonSearch_Click(object sender, EventArgs e)

        {

            this.GetDocList();

            this.DocumentListBinding();

        }

        private void BackstageButtonItemUserRegistration_Click(object sender, EventArgs e)

        {

            using (var frm = new SetupUser())

            {

                if (frm.ShowDialog(this) == DialogResult.OK)

                {

                }

            }

        }

        private void BackstageButtonItemExit_Click(object sender, EventArgs e)

        {

            Application.Exit();

        }

        #endregion

        #region Grid event

        private void RadGridViewDocuments_CommandCellClick(object sender, GridViewCellEventArgs e)

        {

            if (e.Row is GridViewNewRowInfo)

            {

            }

            else

            {

                string extension = string.Empty;

                switch (e.Column.Name)

                {

                    case "MarkupLink":

                        {

                            if (e.Row.DataBoundItem is Documents doc)

                            {

                                if (!string.IsNullOrWhiteSpace(doc.RefProjectCode) && !string.IsNullOrWhiteSpace(doc.DocumentNo) && !string.IsNullOrWhiteSpace(informations.ActiveUser.ID))

                                {

                                    bool result = MarkusHelper.Start(doc.RefProjectCode, doc.DocumentNo, informations.ActiveUser.ID);

                                }

                            }

                        }

                        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 "ToCapture":

                    case "FrCapture":

                        if (e.Row.DataBoundItem is Documents dd)

                        {

                            using (var frm = new ImageView(dd.DocID))

                            {

                                frm.ShowDialog(this);

                            }

                        }

                        break;

                    case "ID2Connection":

                        try

                        {

                            if (e.Row.DataBoundItem is Documents doc)

                            {

                                ID2Helper.OpenPID(doc.DocumentNo, string.Empty, Properties.Settings.Default.ID2Port);

                                try

                                {

                                    var returnDoc = new DocumentController().SetID2Worker(new Documents()

                                    {

                                        DocID = doc.DocID,

                                        ID2StartDate = DateTime.Now,

                                        Worker = informations.ActiveUser.ID

                                    }, informations.ActiveUser.ID);

                                    if (returnDoc != null)

                                    {

                                        doc.ID2StartDate = returnDoc.ID2StartDate;

                                        doc.Worker = returnDoc.Worker;

                                        doc.ID2JobTime = returnDoc.ID2JobTime;

                                    }

                                }

                                catch { }

                            }

                        }

                        catch (Exception ex)

                        {

                            if (e.Row.DataBoundItem is Documents doc)

                            {

                                try

                                {

                                    var returnDoc = new DocumentController().SetID2Worker(new Documents()

                                    {

                                        DocID = doc.DocID,

                                        ID2StartDate = DateTime.Now,

                                        Worker = informations.ActiveUser.ID

                                    }, informations.ActiveUser.ID);

                                    if (returnDoc != null)

                                    {

                                        doc.ID2StartDate = returnDoc.ID2StartDate;

                                        doc.Worker = returnDoc.Worker;

                                        doc.ID2JobTime = returnDoc.ID2JobTime;

                                    }

                                }

                                catch { }

                            }

                            RadMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, RadMessageIcon.Error);

                        }

                        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 "DTIsImport":

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

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

                        break;

                    case "DTIsGateWay":

                    case "DTIsRegSystem":

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

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

                        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_CreateRow(object sender, GridViewCreateRowEventArgs e)

        {

            if (e.RowType == typeof(GridDetailViewRowElement))

            {

                //if (e.RowInfo.ChildRows.Count() > 0)

                //{

                    e.RowElement = new RowDetailViewRowElement();

                //}

                //else

                //{

                //    e.RowElement = null;

                //}

            }

        }

        private void RadGridViewDocuments_CreateCell1(object sender, GridViewCreateCellEventArgs e)

        {

            if (e.CellType == typeof(GridDetailViewCellElement))

            {

                //if (e.Row.RowInfo.ChildRows.Count() > 0)

                //{

                e.CellElement = new MarkupDetailCellElement(e.Column, e.Row);

                //}

            }

        }

        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 "ToCapture":

                            case "FrCapture":

                            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 if(e.Row is GridViewDetailsRowInfo)

            {

                if(e.CellElement is MarkupDetailCellElement element)

                {

                    //element.UpdateInfo();

                }

            }

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

                    break;

                case "AVEVALink":

                case "AVEVAConnection":

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

                    break;

                case "ReviewFileName"://일단주석

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

                    break;

                case "SystemLink":

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

                    break;

                case "ToCapture":

                case "FrCapture":

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

                    break;

                case "ID2Connection":

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

                    break;

            }

            switch (colName)

            {

                case "AutoCADLink":

                case "PDFLink":

                case "MarkupLink":

                case "AVEVALink":

                case "AVEVAConnection":

                case "ReviewFileName"://일단주석

                case "SystemLink":

                case "ToCapture":

                case "FrCapture":

                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 UserInfo GetUser(string user)

        {

            UserInfo userInfo = informations.UserList.Where(x => x.ID.Equals(user)).FirstOrDefault();

            if (userInfo != null) return userInfo;

            userInfo = informations.UserList.Where(x => x.Name.Equals(user)).FirstOrDefault();

            if (userInfo != null) return userInfo;

            return userInfo ?? new UserInfo();

        }

        private ProjectInfo GetProject(string project)

        {

            ProjectInfo prjInfo = informations.ProjectList.Where(x => x.ProjectID.Equals(project)).FirstOrDefault();

            if (prjInfo != null) return prjInfo;

            prjInfo = informations.ProjectList.FirstOrDefault(x => x.Name.Equals(project));

            if (prjInfo != null) return prjInfo;

            return prjInfo ?? new ProjectInfo();

        }

        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)

                               RefProjectCode = 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 : this.GetUser(ws.Rows[p.Index].Cells[7].Value.ToString()).ID,

                               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 : this.GetUser(ws.Rows[p.Index].Cells[13].Value.ToString()).ID,

                               //ToCapture = 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 : this.GetUser(ws.Rows[p.Index].Cells[18].Value.ToString()).ID,

                               //FrCapture = 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[23].Value == null ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[23].Value?.ToString()),

                               ID2EndDate = ws.Rows[p.Index].Cells[24].Value == null ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[24].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[29].Value == null ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[29].Value.ToString()),

                               AVEVAReviewDate = ws.Rows[p.Index].Cells[30].Value == null ? (DateTime?)null : Convert.ToDateTime(ws.Rows[p.Index].Cells[30].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 : this.GetUser(ws.Rows[p.Index].Cells[35].Value.ToString()).ID,

                               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 : this.GetUser(ws.Rows[p.Index].Cells[38].Value.ToString()).ID,

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

                    if (this.orgDocuments == null) this.orgDocuments = new List<Documents>();

                    this.DocumentListBinding();

                    //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.RefProjectCode;

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

                            templateWorksheet.Cells[rowIndex, 7].Value = this.GetUser(doc.PersonInCharge).Name;

                            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 = this.GetUser(doc.ToCreator).Name;

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

                            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 = this.GetUser(doc.FrCreator).Name;

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

                            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:yyyy/MM/dd hh:mm:ss}";

                            templateWorksheet.Cells[rowIndex, 24].Value = $"{doc.ID2EndDate:yyyy/MM/dd hh:mm:ss}";

                            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:yyyy/MM/dd}";

                            templateWorksheet.Cells[rowIndex, 30].Value = $"{doc.AVEVAReviewDate:yyyy/MM/dd}";

                            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 = this.GetUser(doc.ProdReviewer).Name;

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

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

                            templateWorksheet.Cells[rowIndex, 38].Value = this.GetUser(doc.ClientReviewer).Name;

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

        {

            if (RadMessageBox.Show("Do you want to Save?", Globals.Name, MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes)

            {

                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, informations.ActiveUser.ID);

                    bool markusResult = new MarkusInfoController().SetMarkusInfo(this.documents);

                    var users = new UserController().GetAllUserInfo();

                    bool markusMembersResult = new MarkusInfoController().SetMembers(users);

                    if (result && markusResult && markusMembersResult)

                    {

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

                        this.GetDocList();

                    }

                    else if (!result)

                    {

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

                    }

                    else if (!markusResult)

                    {

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

                    }

                    else if (!markusMembersResult)

                    {

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

                    }

                };

                worker.StartWork();

            }

        }

        private void RadButtonElementSaveCommand_Click(object sender, EventArgs e)

        {

            try

            {

                this.SetSaved();

            }

            catch (Exception ex)

            {

                Program.logger.Error(ex);

            }

        }

        private void RadButtonElementSave_Click(object sender, EventArgs e)

        {

            try

            {

                this.SetSaved();

            }

            catch (Exception ex)

            {

                Program.logger.Error(ex);

            }

        }

        private void RadButtonElementSync_Click(object sender, EventArgs e)

        {

            if (RadMessageBox.Show("Do you want to ID2 Sync?", Globals.Name, MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes)

            {

                var id2Prjs = informations.ProjectList.Where(x => x.GroupID.Equals(informations.ActiveProject.ProjectID)).Select(x => x.ID2Info).ToList();

                bool result = new DocumentController().SetID2Sync(id2Prjs, informations.ActiveUser.ID);

                if (result)

                {

                    this.GetDocListbyID2();

                    this.DocumentListBinding();

                }

            }

        }

        private void RadButtonElementRefreshCommand_Click(object sender, EventArgs e)

        {

            RadMessageBox.Show("Refresh click!!", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Info);

        }

        #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>() { "RefProjectCode", "DocumentNo", "PersonInCharge", "Worker", "JobLevel", "IsTypical", "RevisonNo" };

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

            List<string> rvFrColNames = new List<string>() { "FrReviewStatus", "FrRemarks", "FrCreator", "FrCapture", "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();

            }

        }

        private void txtFullSearch_TextChanged(object sender, EventArgs e)

        {

            if(string.IsNullOrWhiteSpace(txtFullSearch.Text))

                radGridViewDocuments.MasterTemplate.Refresh(null);

            txtFullSearch.TextBoxElement.ShowClearButton = !string.IsNullOrWhiteSpace(txtFullSearch.Text);

            radGridViewDocuments.MasterView.TableSearchRow.Search(txtFullSearch.Text);

        }

        private void btnSearchPrevious_Click(object sender, EventArgs e)

        {

            radGridViewDocuments.MasterView.TableSearchRow.SelectPreviousSearchResult();

        }

        private void btnSearchNext_Click(object sender, EventArgs e)

        {

            radGridViewDocuments.MasterView.TableSearchRow.SelectNextSearchResult();

        }

        private void txtFullSearch_KeyDown(object sender, KeyEventArgs e)

        {

            if(e.KeyCode == Keys.Enter)

            {

                radGridViewDocuments.MasterView.TableSearchRow.SelectNextSearchResult();

            }

        }

    }

}

public class FilterColumn

{

    public string Name { get; set; }

    public string FieldName { get; set; }

    public bool IsSelect { get; set; }

}