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 Telerik.WinControls;

using Telerik.WinControls.UI;

using Telerik.WinControls.Data;

using GemBox.Spreadsheet;

using Newtonsoft.Json;

using System.Diagnostics;

using ID2.Manager.Common.Helpers;

namespace ID2.Manager

{

    public partial class Main : RadRibbonForm

    {

        readonly Informations informations = Informations.Instance;

        bool IsID2Manager = false;

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

        List<System.Drawing.Image> importImages = new List<System.Drawing.Image>();

        List<Documents> orgDocuments = null;

        int TotalCount = 0;

        BriefAndImages briefAndImagesReview = new BriefAndImages { Dock = DockStyle.Fill };

        BriefAndImages briefAndImagesValidation = new BriefAndImages { Dock = DockStyle.Fill };

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

        public Main()

        {

            InitializeComponent();

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

            radControlSpyForm.Show();

            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.radButtonElementNotice.Click += RadButtonElementNotice_Click;

            this.radButtonElementNoticeUpload.Click += RadButtonElementNoticeUpload_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.FilterChanged += RadGridViewDocuments_FilterChanged;

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

            this.radGridViewDocuments.TableElement.RowHeaderColumnWidth = 36;

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

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

            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.radPageViewPageReview.Controls.Add(briefAndImagesReview);

            this.radPageViewPageValidation.Controls.Add(briefAndImagesValidation);

            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;

                //    }

                //}

                briefAndImagesReview.Clear();

                briefAndImagesValidation.Clear();

                //FrRemarks 추가

                briefAndImagesReview.DataBindings.Add(new Binding("Brief", doc, "ToRemarks", false, DataSourceUpdateMode.OnValidation, null));

                briefAndImagesValidation.DataBindings.Add(new Binding("Brief",doc, "ClientRemarks", false,DataSourceUpdateMode.OnValidation,null));

                if (doc.AttFiles != null)

                {

                    if (doc.AttFiles.Count(x => x.Category == "toreview") > 0)

                    {

                        var images = doc.AttFiles.Where(x => x.Category == "toreview").Select(x => x.FileData);

                        briefAndImagesReview.SetToImages(images.ToList());

                    }

                    if (doc.AttFiles.Count(x => x.Category == "frreview") > 0)

                    {

                        var images = doc.AttFiles.Where(x => x.Category == "frreview").Select(x => x.FileData);

                        briefAndImagesReview.SetFrImages(images.ToList());

                    }

                    if (doc.AttFiles.Count(x => x.Category == "prodvalidation") > 0)

                    {

                        var images = doc.AttFiles.Where(x => x.Category == "prodvalidation").Select(x => x.FileData);

                        briefAndImagesValidation.SetToImages(images.ToList());

                    }

                    if (doc.AttFiles.Count(x => x.Category == "clientvalidation") > 0)

                    {

                        var images = doc.AttFiles.Where(x => x.Category == "clientvalidation").Select(x => x.FileData);

                        briefAndImagesValidation.SetFrImages(images.ToList());

                    }

                }

            }

        }

        #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.radButtonElementNoticeUpload.Enabled = true;

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

                this.backstageTabItemOpenProject.Visibility = ElementVisibility.Visible;

                this.backstageButtonItemUserRegistration.Visibility = ElementVisibility.Visible;

            }

            else

            {

                this.radButtonElementNoticeUpload.Enabled = false;

                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)

        {

            try

            {

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

                }

            }

            catch (Exception ex)

            {

                Program.logger.Error($"An exception occurred from {MethodBase.GetCurrentMethod().Name}", ex);

                RadMessageBox.Show("Failed to load project.", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Error);

            }

            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)

        {

            InitializeGrid();

        }

        private void InitializeGrid()

        {

            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)

                {

                    if (radGridViewDocuments.Columns[item.Value.ToString()] != null)

                    {

                        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)

        {

            try

            {

                if (this.radRibbonBarBackstageViewID2Manager.Tag is ProjectEventArgs)

                {

                    var prjArgs = this.radRibbonBarBackstageViewID2Manager.Tag as ProjectEventArgs;

                    informations.ActiveProject = prjArgs.ProjectInfo;

                    this.radRibbonBarBackstageViewID2Manager.Tag = null;

                    this.LoadProject();

                }

            }

            catch (Exception ex)

            {

                Program.logger.Error($"An exception occurred from {MethodBase.GetCurrentMethod().Name}", ex);

                RadMessageBox.Show("Failed to load project.", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Error);

            }

        }

        private void LoadProject()

        {

            try

            {

                #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

                #region AVEVA

                //Gateway

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

                    this.radDropDownListGateway.Items.Clear();

                informations.IsSuccess.ForEach(x =>

                {

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

                });

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

                this.radDropDownListGateway.Items.Insert(0, allDTIsGateWay);

                allDTIsGateWay.Selected = true;

                //Registration

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

                    this.radDropDownListRegistration.Items.Clear();

                informations.IsSuccess.ForEach(x =>

                {

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

                });

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

                this.radDropDownListRegistration.Items.Insert(0, allDTIsRegSystem);

                allDTIsRegSystem.Selected = true;

                #endregion

                this.GetDocList();

            }

            catch (Exception ex)

            {

                throw ex;

            }

            finally

            {

                this.Cursor = Cursors.Default;

            }

        }

        #region Document List 조회

        public void GetDocList()

        {

            try

            {

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

                    string isGateWay = this.radDropDownListGateway.SelectedValue.ToString();

                    string isRegSystem = this.radDropDownListRegistration.SelectedValue.ToString();

                    var worker = new LoadDocumentsWorker(projectCode, personIncharge, jobLevel, documentNo, isToIsDiscussion, isFrReviewStatus, isID2Work, id2Status, avevaStatus, prodIsResult, clientIsResult, isGateWay, isRegSystem, this.radGridViewDocuments);

                    worker.OnWorkCompletedHandler += (e) =>

                    {

                        var docData = e.Result as DocumentsResult;

                        this.documents = docData.Dwgs;

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

                        this.TotalCount = docData.TotalCount;

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

                        if (!string.IsNullOrWhiteSpace(projectCode))

                        {

                            projectCodes.Add(projectCode);

                        }

                        else

                        {

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

                        }

                        this.DocumentListBinding();

                    };

                    worker.StartWork();

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        public void DocumentListBinding()

        {

            try

            {

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

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

                this.lbSelectAndTotal.Text = $"{this.documents.Count} / {this.TotalCount} (Selected / Total)";

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

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

        {

            try

            {

                this.GetDocList();

            }

            catch (Exception ex)

            {

                Program.logger.Error($"An exception occurred from {MethodBase.GetCurrentMethod().Name}", ex);

                RadMessageBox.Show("DWG search failed.", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Error);

            }

        }

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

                        {

                            if (e.Row.DataBoundItem is Documents dd)

                            {

                                using (var frm = new ImageView(dd.DocID, "toreview"))

                                {

                                    frm.ShowDialog(this);

                                }

                            }

                        }

                        break;

                    case "FrCapture":

                        {

                            if (e.Row.DataBoundItem is Documents dd)

                            {

                                using (var frm = new ImageView(dd.DocID, "frreview"))

                                {

                                    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)

                        {

                            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;

        }

        private void RadGridViewDocuments_FilterChanged(object sender, GridViewCollectionChangedEventArgs e)

        {

            this.lbSelectAndTotal.Text = $"{e.GridViewTemplate.DataView.Count} / {this.TotalCount} (Selected / Total)";

        }

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

        {

            var form =  new Forms.SelectExcelData();

            var dialogResult = form.ShowDialog();

            if (dialogResult == DialogResult.OK)

            {

                using (ID2Excel excel = new ID2Excel())

                {

                    var result = excel.ExcelDataImport(form.SelectItems);

                    if (result.Error != null)

                    {

                        RadMessageBox.Show(result.Error, "Information", MessageBoxButtons.OK, RadMessageIcon.Info);

                    }

                    else

                    {

                        this.importImages = result.Images;

                        this.documents.AddRange(result.documents);

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

                        this.DocumentListBinding();

                        //briefAndImagesReview.SetImages(this.importImages);

                    }

                }

            }

        }

        private void RadButtonElementExcelImport_Click_gembox(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();

                    using(ID2Excel excel = new ID2Excel())

                    {

                       var result = excel.GemboxImport(ofd.FileName);

                        if(result.Error != null)

                        {

                            RadMessageBox.Show(result.Error, "Information", MessageBoxButtons.OK, RadMessageIcon.Info);

                        }

                        else

                        {

                            this.documents.AddRange(result.documents);

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

        {

            try

            {

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

                {

                    var worker = new SetDocumentsWorker(this.documents, this.orgDocuments, this.radGridViewDocuments);

                    worker.OnWorkCompletedHandler += (e) =>

                    {

                        bool result = (bool)e.Result;

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

                        bool markusMembersResult = new MarkusInfoController().SetMembers(informations.UserList);

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

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        private void RadButtonElementSaveCommand_Click(object sender, EventArgs e)

        {

            try

            {

                this.SetSaved();

            }

            catch (Exception ex)

            {

                Program.logger.Error($"An exception occurred from {MethodBase.GetCurrentMethod().Name}", ex);

                RadMessageBox.Show("DWG save failed.", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Error);

            }

        }

        private void RadButtonElementSave_Click(object sender, EventArgs e)

        {

            try

            {

                this.SetSaved();

            }

            catch (Exception ex)

            {

                Program.logger.Error($"An exception occurred from {MethodBase.GetCurrentMethod().Name}", ex);

                RadMessageBox.Show("DWG save failed.", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Error);

            }

        }

        private void RadButtonElementSync_Click(object sender, EventArgs e)

        {

            try

            {

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

                {

                    var worker = new SyncDocumentsWorker(this.radGridViewDocuments);

                    worker.OnWorkCompletedHandler += (arg) =>

                    {

                        if ((bool)arg.Result)

                        {

                            this.GetDocList();

                            RadMessageBox.Show("Sync with ID2 completed.", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Info);

                        }

                    };

                    worker.StartWork();

                }

            }

            catch (Exception ex)

            {

                Program.logger.Error($"An exception occurred from {MethodBase.GetCurrentMethod().Name}", ex);

                RadMessageBox.Show("Failed to sync with id2.", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Error);

            }

        }

        private void RadButtonElementNotice_Click(object sender, EventArgs e)

        {

            try

            {

                AttFileInfo notiFileInfo = new AttFileController().GetAttFileInfo(informations.ActiveProject.ProjectID, "notice");

                if (notiFileInfo == null)

                {

                    RadMessageBox.Show("No notice.", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Info);

                }

                else

                {

                    string noticePath = Path.Combine(Globals.ProgramDataFolder, "NoticeFiles");

                    string noticeFileFullName = Path.Combine(noticePath, $"{notiFileInfo.FileID}{notiFileInfo.FileExtension}");