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;

using Telerik.WinControls.UI.Docking;

namespace ID2.Manager

{

    public partial class Main : RadRibbonForm

    {

        protected override CreateParams CreateParams

        {

            get

            {

                CreateParams cp = base.CreateParams;

                cp.ExStyle |= 0x02000000;

                return cp;

            }

        }

        private string dockLayoutPath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), Application.ProductName,

         "dock.xml");

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

#if DEBUG

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

#endif

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

        public Main()

        {

            InitializeComponent();

            this.LayoutValidation.Controls.Add(new Controls.Verification() { Dock = DockStyle.Fill });

            this.DockMainTabStrip.Select();

            var appDataPath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), Application.ProductName);

            if(!Directory.Exists(appDataPath))

            {

                Directory.CreateDirectory(appDataPath);

            }

            ID2.Manager.Common.Helpers.TableLayoutPanelHelper.SetDoubleBuffered(this);

            this.FormClosing += Main_FormClosing;

            this.radButtonElementRefreshCommand.Click += RadButtonElementRefreshCommand_Click;

            this.radButtonElementSaveCommand.Click += RadButtonElementSaveCommand_Click;

            this.btnDockLayoutReset.Click += BtnDockLayoutReset_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.CreateRowInfo += RadGridViewDocuments_CreateRowInfo;

            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.backstageButtonItemSelectDB.Click += BackstageButtonItemSelectDB_Click;

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

            briefAndImagesReview.RemoveImage += BriefAndImages_RemoveImage;

            briefAndImagesValidation.RemoveImage += BriefAndImages_RemoveImage;

            this.Initialize();

        }

        private void BtnDockLayoutReset_Click(object sender, EventArgs e)

        {

            this.LoadDockingLayout(true);

        }

        private void BriefAndImages_RemoveImage(object sender, AttImageInfo e)

        {

            try

            {

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

                {

                    var reslut = doc.AttFiles.RemoveAll(x => x.FileID == e.ID);

                    if (reslut > 0)

                    {

                    }

                    else

                    {

                        MessageBox.Show("삭제오류");

                    }

                }

            }

            catch (Exception ex)

            {

                Program.logger.Error("BriefAndImages_RemoveImage",ex);

            }

        }

        private void SaveDockingLayout()

        {

            try

            {

                this.DockMain.SaveToXml(dockLayoutPath);

            }

            catch (Exception ex)

            {

                System.Diagnostics.Debug.WriteLine("SaveDockingLayout Error.", ex);

            }

        }

        private void LoadDockingLayout(bool IsDefaultLayoutLoad = false)

        {

            try

            {

                bool IsUseLayoutLoad = false;

                try

                {

                    var dockLayoutFile = new FileInfo(dockLayoutPath);

                    if (!IsDefaultLayoutLoad && dockLayoutFile.Exists)

                    {

                        this.DockMain.LoadFromXml(dockLayoutPath);

                        IsUseLayoutLoad = true;

                    }

                }

                catch (Exception ex)

                {

                    Program.logger.Error($"dock Layout File load Error. File Path : {dockLayoutPath}", ex);

                }

                if(!IsUseLayoutLoad)

                {

                    var layout = Properties.Resources.DefalutDockLayout;

                    using (MemoryStream stream = new MemoryStream(Encoding.UTF8.GetBytes(layout)))

                    {

                        this.DockMain.LoadFromXml(stream);

                    }

                }

                this.DockMain.DocumentTabsVisible = true;

                this.DockMain.DockWindows.ForAll(x =>

                {

                    x.DockManager.ShowDocumentPinButton = false;

                    x.DockManager.ShowDocumentCloseButton = false;

                });

                this.DockMain.AutoHideWindowDisplaying += DockMain_AutoHideWindowDisplaying;

                this.DockMain.DockStateChanged+=(snd,evt)=>

                {

                    if (evt.DockWindow.Name == DockWindowMain.Name || evt.DockWindow.Name == DockValidation.Name)

                    {

                    }

                };

                this.DockMain.DockWindowClosed += (snd, evt) =>

                {

                     evt.DockWindow.DockState = Telerik.WinControls.UI.Docking.DockState.AutoHide;

                    //Telerik.WinControls.UI.Docking.AutoHidePosition tabPosition = Telerik.WinControls.UI.Docking.AutoHidePosition.Right;

                    //List<DockWindow> dockWindows = new List<DockWindow>();

                    //var autoHideWindows = this.DockMain.DockWindows.Where(x => x.DockState == Telerik.WinControls.UI.Docking.DockState.AutoHide).ToList();

                    //if (evt.DockWindow.AccessibleName == DockWindowMain.AccessibleName || evt.DockWindow.Name == DockValidation.AccessibleName)

                    //{

                    //    dockWindows.AddRange(autoHideWindows.Where(x => x.AccessibleName == DockWindowMain.AccessibleName && evt.DockWindow.Name == DockValidation.AccessibleName));

                    //    tabPosition = Telerik.WinControls.UI.Docking.AutoHidePosition.Bottom;

                    //    dockWindows.Add(evt.DockWindow);

                    //}

                    //else

                    //{

                    //    dockWindows.AddRange(autoHideWindows.Where(x => x.AccessibleName != DockWindowMain.AccessibleName || evt.DockWindow.Name != DockValidation.AccessibleName));

                    //    dockWindows.Add(evt.DockWindow);

                    //}

                    //this.DockMain.AutoHideWindows(dockWindows, tabPosition);

                };

            }

            catch (Exception ex)

            {

                Program.logger.Error($"dock Layout load Error. File Path : {dockLayoutPath}", ex);

            }

        }

        private void DockMain_AutoHideWindowDisplaying(object sender, Telerik.WinControls.UI.Docking.AutoHideWindowDisplayingEventArgs e)

        {

        }

        private void Main_FormClosing(object sender, FormClosingEventArgs e)

        {

            SaveDockingLayout();

        }

        protected override bool ProcessCmdKey(ref Message msg, Keys keyData)

        {

            if (keyData == (Keys.F10 | Keys.Control))

            {

#if DEBUG

                radControlSpyForm.Show();

#endif

            }

            if (keyData == (Keys.V | Keys.Control))

            {

                System.Diagnostics.Debug.WriteLine("KeyDown CTRL + V");

                if(Clipboard.ContainsImage())

                {

                    var IsDoftech = true;

                    var selectReview = true;

                    string category = "";

                    byte[] imageBytes = null;

                    Image clipboardImage = Clipboard.GetImage();

                    using (MemoryStream stream = new MemoryStream())

                    {

                        clipboardImage.Save(stream, System.Drawing.Imaging.ImageFormat.Png);

                        imageBytes = stream.ToArray();

                    }

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

                    {

                        /// 도프텍 or 삼성

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

                        {

                            IsDoftech = false;

                        }

                        /// 검토 or 검증

                        if (radPageViewComment.SelectedPage != radPageViewPageReview)

                        {

                            selectReview = false;

                        }

                        if (IsDoftech && selectReview)

                        {

                            category = "toreview";

                        }

                        else if (!IsDoftech && selectReview)

                        {

                            category = "frreview";

                        }

                        else if (IsDoftech && !selectReview)

                        {

                            category = "prodvalidation";

                        }

                        else 

                        {

                            category = "clientvalidation";

                        }

                        AttFileInfo newFile = new AttFileInfo

                        {

                            FileID = Guid.NewGuid().ToString(),

                            Category = category,

                            FileType = "image/png",

                            FileName = "ClipBoard",

                            FilePath = "ClipBoard",

                            FileExtension = ".png",

                            CreatedDate = DateTime.Now,

                            Creator = informations.ActiveUser.ID,

                            FileData = imageBytes

                        };

                        if (doc.AttFiles == null)

                        {

                            doc.AttFiles = new List<AttFileInfo>();

                        }

                        doc.AttFiles.Add(newFile);

                        var imageInfo = new AttImageInfo { ID = newFile.FileID, Data = newFile.FileData };

                        switch (category)

                        {

                            case "toreview":

                                briefAndImagesReview.AddToImage(imageInfo, true);

                                break;

                            case "frreview":

                                briefAndImagesReview.AddFrImage(imageInfo, true);

                                break;

                            case "prodvalidation":

                                briefAndImagesValidation.AddToImage(imageInfo, true);

                                break;

                            case "clientvalidation":

                                briefAndImagesValidation.AddFrImage(imageInfo, true);

                                break;

                        }

                    }

                }

            }

            return base.ProcessCmdKey(ref msg, keyData);

        }

        private void RadGridViewDocuments_CreateRowInfo(object sender, GridViewCreateRowInfoEventArgs e)

        {

            if (e.RowInfo is GridViewSearchRowInfo)

            {

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

            }

            System.Diagnostics.Debug.WriteLine(e.RowInfo.GetType().Name);

        }

        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)

        {

            if (this.radGridViewDocuments.SelectedRows.Any() && this.radGridViewDocuments.SelectedRows.First().DataBoundItem is Documents doc)

            {

                //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("BriefDoftech", doc, "ToRemarks", false, DataSourceUpdateMode.OnValidation, null));

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

                briefAndImagesValidation.DataBindings.Add(new Binding("BriefDoftech", 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 =>new AttImageInfo { ID = x.FileID, Data = 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 => new AttImageInfo { ID = x.FileID, Data = 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 => new AttImageInfo { ID = x.FileID, Data = 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 => new AttImageInfo { ID = x.FileID, Data = 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}";

        }

        protected override void OnLoad(EventArgs e)

        {

            try

            {

                LoadDockingLayout();

                InitializeGrid();

                bool isID2 = this.IsID2Connection();

                this.SetMenus(isID2);

                if (isID2)

                {

                    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

                    {

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

                        foreach (Control ctrl in this.backstageViewPageOpenProject.Controls)

                        {

                            if (ctrl is OpenProjectView)

                            {

                                var openProjectView = ctrl as OpenProjectView;

                                openProjectView.GetProjectGroups();

                                break;

                            }

                        }

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

                    }

                }

                else

                {

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

                    RadMessageBox.Show(this, $"Please select db file.", "Error", MessageBoxButtons.OK, RadMessageIcon.Info);

                }

            }

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

        }

        private bool IsID2Connection()

        {

            bool isSuccess = false;

            isSuccess = Globals.IsProjectDBConnstr();

            try

            {

                var id2Project = new ID2Controller().GetID2ProjectList();

            }

            catch

            {

                isSuccess = false;

            }

            return isSuccess;

        }

        private void SetMenus(bool isid2)

        {

            if (isid2)

            {

                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;

                }

            }

            else

            {

                this.radButtonElementNoticeUpload.Enabled = false;

                this.backstageButtonItemSelectDB.Visibility = ElementVisibility.Visible;

                foreach (Control ctrl in this.backstageViewPageOpenProject.Controls)

                {

                    ctrl.Visible = false;

                }

                this.backstageTabItemOpenProject.Visibility = ElementVisibility.Collapsed;

                this.backstageButtonItemUserRegistration.Visibility = ElementVisibility.Collapsed;

            }

        }

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

        {

            DetailGridViewTemplate markupList = new DetailGridViewTemplate();

            markupList.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.None;

            GridViewTextBoxColumn userColumn = new GridViewTextBoxColumn("CREATE_USER");

            GridViewTextBoxColumn textColumn = new GridViewTextBoxColumn("TEXT");

            userColumn.AutoSizeMode = BestFitColumnMode.AllCells;

            textColumn.AutoSizeMode = BestFitColumnMode.AllCells;

            markupList.Columns.AddRange(userColumn, textColumn);

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

            markupList.HierarchyDataProvider = new GridViewEventDataProvider(markupList);

            this.radGridViewDocuments.ChildViewExpanded += RadGridViewDocuments_ChildViewExpanded;

            this.radGridViewDocuments.RowSourceNeeded += RadGridViewDocuments_RowSourceNeeded;

        }

        private void RadGridViewDocuments_RowSourceNeeded(object sender, GridViewRowSourceNeededEventArgs e)

        {

            if (e.Template.HierarchyLevel == 1)

            {

                if (e.ParentRow.DataBoundItem is Documents documents)

                {

                    if (documents.Markups != null)

                    {

                        foreach (var makrup in documents.Markups)

                        {

                            GridViewRowInfo row = e.Template.Rows.NewRow();

                            row.Cells["CREATE_USER"].Value = makrup.CREATE_USER;

                            row.Cells["TEXT"].Value = makrup.TEXT;

                            e.SourceCollection.Add(row);

                        }

                        e.Template.BestFitColumns();

                    }

                }

            }

        }

        private void RadGridViewDocuments_ChildViewExpanded(object sender, ChildViewExpandedEventArgs e)

        {

        }

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

                var verification = this.LayoutValidation.Controls[0] as Verification;

                verification.DocumentListBinding(this.documents);

            }

            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 BackstageButtonItemSelectDB_Click(object sender, EventArgs e)

        {

            using (var frm = new SetID2ProjectDB())

            {

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

                {

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

                    {

                        this.radRibbonBarBackstageViewID2Manager.HidePopup();

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

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

                        this.LoadProject();

                    }

                    else

                    {

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

                        bool isID2 = this.IsID2Connection();

                        this.SetMenus(isID2);

                        foreach (Control ctrl in this.backstageViewPageOpenProject.Controls)

                        {

                            if (ctrl is OpenProjectView)

                            {

                                var openProjectView = ctrl as OpenProjectView;

                                openProjectView.GetProjectGroups();

                                break;

                            }

                        }

                    }

                }

            }

        }

        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 "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_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 if (e.CellElement is GridGroupExpanderCellElement expanderCellElement)

                {

                    if((e.Row.DataBoundItem as Documents).Markups == null)

                    {

                        expanderCellElement.Enabled = false;

                    }

                }

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

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

                                break;

                            case "ToCapture":

                                if (result.ToCapture > 0)

                                {

                                    e.CellElement.Image = Properties.Resources.files18;

                                }

                                break;

                            case "FrCapture":

                                if (result.FrCapture > 0)

                                {

                                    e.CellElement.Image = Properties.Resources.files18;

                                }

                                break;

                            case "ProdCapture":

                                if (result.ProdCapture > 0)

                                {

                                    e.CellElement.Image = Properties.Resources.files18;

                                }

                                break;

                            case "ClientCapture":

                                if (result.ClientCapture > 0)

                                {

                                    e.CellElement.Image = Properties.Resources.files18;

                                }

                                break;

                        }

                    }

                    else

                    {

                    }

                }

            }

            else if(e.Row is GridViewDetailsRowInfo)

            {

                if (e.CellElement is GridDetailViewCellElement detailViewCellElement)

                {

                    detailViewCellElement.Padding = new Padding(2);

                }

            }

            //else if (e.Row is GridViewSummaryRowInfo)

            //{

            //    if (e.CellElement is GridRowHeaderCellElement)

            //    {

            //        e.CellElement.Text = "Count";

            //    }

            //    else if (e.CellElement is GridSummaryCellElement)

            //    {

            //        e.CellElement.ForeColor = this._SummaryColor;

            //        e.CellElement.TextAlignment = ContentAlignment.BottomRight;

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

            //    }

            //    else

            //    {

            //    }

            //}

            else

            {

            }

        }

        private RadButtonElement GetCommandColBtnElement(RadElement elem, string colName)

        {

            RadButtonElement btnElem = null;

            Bitmap bitmap = null; ;

            switch (colName)

            {

                case "AutoCADLink":

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

                    break;

                case "PDFLink":

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

                    break;

                case "MarkupLink":

                    bitmap = new Bitmap(Properties.Resources.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(informations.UserList.ToList()))

                {

                    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(informations.UserList.ToList()))

                    {

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