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 System.Diagnostics;

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 ID2.Manager.Common.Helpers;

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

using Telerik.WinControls;

using Telerik.WinControls.UI;

using Telerik.WinControls.Enumerations;

using GemBox.Spreadsheet;

using Newtonsoft.Json;

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;

        int SearchCount = 0;

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

        IssueImagesAndAnswer issueImagesAndAnswerWork = new IssueImagesAndAnswer { 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();

            var verification = new Controls.Classify(this.radProgressBarElement) { Dock = DockStyle.Fill };

            this.LayoutValidation.Controls.Add(verification);

            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.radButtonElementFilterClear.Click += RadButtonElementFilterClear_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.radButtonElementDelete.Click += RadButtonElementDelete_Click;

            this.radButtonElementLevel.Click += RadButtonElementLevel_Click;

            this.radButtonElementConvert.Click += RadButtonElementConvert_Click;

            this.radButtonDateClear.Click += RadButtonDateClear_Click;

            this.radDropDownListTeam.SelectedIndexChanged += RadDropDownList_SelectedIndexChanged;

            this.radDropDownListProject.SelectedIndexChanged += RadDropDownList_SelectedIndexChanged;

            this.radDropDownListPersonInCharge.SelectedIndexChanged += RadDropDownList_SelectedIndexChanged;

            this.radDropDownListJobLevel.SelectedIndexChanged += RadDropDownList_SelectedIndexChanged;

            this.radDropDownListToIsDiscussion.SelectedIndexChanged += RadDropDownList_SelectedIndexChanged;

            this.radDropDownListFrReviewStatus.SelectedIndexChanged += RadDropDownList_SelectedIndexChanged;

            this.radDropDownListID2Status.SelectedIndexChanged += RadDropDownList_SelectedIndexChanged;

            this.radDropDownListID2Issues.SelectedIndexChanged += RadDropDownList_SelectedIndexChanged;

            this.radDropDownListAVEVAStatus.SelectedIndexChanged += RadDropDownList_SelectedIndexChanged;

            this.radDropDownListAVEVAIssues.SelectedIndexChanged += RadDropDownList_SelectedIndexChanged;

            this.radDropDownListProdIsResult.SelectedIndexChanged += RadDropDownList_SelectedIndexChanged;

            this.radDropDownListClientIsResult.SelectedIndexChanged += RadDropDownList_SelectedIndexChanged;

            this.radDropDownListGateway.SelectedIndexChanged += RadDropDownList_SelectedIndexChanged;

            this.radDropDownListRegistration.SelectedIndexChanged += RadDropDownList_SelectedIndexChanged;

            this.radCollapsiblePanelCondition.Collapsed += RadCollapsiblePanelCondition_Collapsed;

            this.radCollapsiblePanelCondition.Expanded += RadCollapsiblePanelCondition_Expanded;

            this.radCheckBoxLink.CheckStateChanged += RadCheckBoxFreezed_CheckStateChanged;

            this.radCheckBoxDocInfo.CheckStateChanged += RadCheckBoxFreezed_CheckStateChanged;

            this.radCheckBoxReview.CheckStateChanged += RadCheckBox_CheckStateChanged;

            this.radCheckBoxWork.CheckStateChanged += RadCheckBox_CheckStateChanged;

            this.radCheckBoxVaildation.CheckStateChanged += RadCheckBox_CheckStateChanged;

            this.radCheckBoxAVEVANet.CheckStateChanged += RadCheckBox_CheckStateChanged;

            this.radTextBoxDocumentNo.KeyDown += RadTextBoxDocumentNo_KeyDown;

            this.radTextBoxDocumentNo.KeyUp += RadTextBoxDocumentNo_KeyUp;

            this.radButtonSearch.Click += RadButtonSearch_Click;

            #region 테마 설정

            this.radMenuItemControlDefault.Click += RadMenuItemTheme_Click;

            this.radMenuItemOffice2013Dark.Click += RadMenuItemTheme_Click;

            this.radMenuItemTelerikMetro.Click += RadMenuItemTheme_Click;

            this.radMenuItemVisualStudio2012Dark.Click += RadMenuItemTheme_Click;

            this.radMenuItemVisualStudio2012Light.Click += RadMenuItemTheme_Click;

            this.radMenuItemWindows8.Click += RadMenuItemTheme_Click;

            #endregion

            //this.radGridViewDocuments.DefaultValuesNeeded += RadGridViewDocuments_DefaultValuesNeeded;

            this.radGridViewDocuments.UserAddedRow += RadGridViewDocuments_UserAddedRow;

            this.radGridViewDocuments.SelectionChanged += RadGridViewDocuments_SelectionChanged;

            this.radGridViewDocuments.ViewCellFormatting += RadGridViewDocuments_ViewCellFormatting;

            this.radGridViewDocuments.CreateRowInfo += RadGridViewDocuments_CreateRowInfo;

            this.radGridViewDocuments.CellBeginEdit += RadGridViewDocuments_CellBeginEdit;

            this.radGridViewDocuments.CellEndEdit += RadGridViewDocuments_CellEndEdit;

            this.radGridViewDocuments.CommandCellClick += RadGridViewDocuments_CommandCellClick;

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

            //this.radGridViewDocuments.FilterChanging += RadGridViewDocuments_FilterChanging;

            this.radGridViewDocuments.FilterChanged += RadGridViewDocuments_FilterChanged;

            //this.radGridViewDocuments.CellValidated += RadGridViewDocuments_CellValidated;

            this.radGridViewDocuments.HeaderCellToggleStateChanged += RadGridViewDocuments_HeaderCellToggleStateChanged;

            this.radGridViewDocuments.ValueChanging += RadGridViewDocuments_ValueChanging;

            this.radGridViewDocuments.ValueChanged += RadGridViewDocuments_ValueChanged;

            this.radGridViewDocuments.MultiSelect = true;

            this.radGridViewDocuments.EnableHotTracking = true;

            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.radPageViewPageWork.Controls.Add(issueImagesAndAnswerWork);

            briefAndImagesReview.RemoveImage += BriefAndImages_RemoveImage;

            issueImagesAndAnswerWork.RemoveImage += IssueImagesAndAnswer_RemoveImage;

            this.Initialize();

        }

        /// <summary>

        /// 사용자가 선택한 테마를 적용한다.

        /// </summary>

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

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

        private void RadMenuItemTheme_Click(object sender, EventArgs e)

        {

            string theme = (sender as RadMenuItem).Text;

            if(theme != this.radDropDownButtonElementTheme.Text)

            {

                this.radDropDownButtonElementTheme.Text = theme;

                Classes.ID2Helper.IniWriteValue(Program.IniFilePath, "App", "Theme", theme);

                if (!string.IsNullOrEmpty(theme))

                {

                    Telerik.WinControls.ThemeResolutionService.ApplicationThemeName = theme;

                    Program.ThemeName = theme;

                }

            }

        }

        private void BtnDockLayoutReset_Click(object sender, EventArgs e)

        {

            this.LoadDockingLayout(true);

        }

        private void BriefAndImages_RemoveImage(object sender, AttImageInfo e)

        {

            try

            {

                if (e is AttImageInfo)

                {

                    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)

                        {

                            switch (e.Category)

                            {

                                case "toreview":

                                    doc.ToCapture -= reslut;

                                    break;

                                case "frreview":

                                    doc.FrCapture -= reslut;

                                    break;

                            }

                        }

                        else

                        {

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

                        }

                    }

                }

            }

            catch (Exception ex)

            {

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

            }

        }

        private void IssueImagesAndAnswer_RemoveImage(object sender, AttImageInfo e)

        {

            try

            {

                if (e is AttImageInfo)

                {

                    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)

                        {

                            switch (e.Category)

                            {

                                case "id2work":

                                    doc.ID2Capture -= reslut;

                                    break;

                            }

                        }

                        else

                        {

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

                        }

                    }

                }

            }

            catch (Exception ex)

            {

                Program.logger.Error("IssueImagesAndAnswer_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 == DockClassify.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

                        {

                            category = "id2work";

                        }

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

                                ++doc.ToCapture;

                                break;

                            case "frreview":

                                briefAndImagesReview.AddFrImage(imageInfo, true);

                                ++doc.FrCapture;

                                break;

                            case "id2work":

                                issueImagesAndAnswerWork.AddImage(imageInfo, true);

                                ++doc.ID2Capture;

                                break;

                        }

                    }

                }

            }

            return base.ProcessCmdKey(ref msg, keyData);

        }

        private void RadGridViewDocuments_CreateRowInfo(object sender, GridViewCreateRowInfoEventArgs e)

        {

            if (e.RowInfo is GridViewSearchRowInfo)

            {

                var row = new SearchRow(e.ViewInfo);

                e.RowInfo = row;

            }

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

        }

        private void TableSearchRow_SearchProgressChanged(object sender, SearchProgressChangedEventArgs e)

        {

            if (e.SearchFinished)

            {

            }

        }

        /// <summary>

        /// 선택한 Document와 상세 편집 창을 연동시킨다.

        /// </summary>

        /// <param name="doc"></param>

        public void BindingDocumentToDetailEditor(Documents doc)

        {

            briefAndImagesReview.Clear();

            issueImagesAndAnswerWork.Clear();

            //FrRemarks 추가

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

            briefAndImagesReview.DataBindings.Add(new Binding("BriefSec", doc, "FrRemarks", false, DataSourceUpdateMode.OnPropertyChanged, null));

            issueImagesAndAnswerWork.DataBindings.Add(new Binding("IssueText", doc, "ID2Issues", false, DataSourceUpdateMode.OnPropertyChanged, null));

            issueImagesAndAnswerWork.DataBindings.Add(new Binding("ReplyModificationText", doc, "ReplyModifications", false, DataSourceUpdateMode.OnPropertyChanged, null));

            if (doc.AttFiles != null)

            {

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

                {

                    var images = doc.AttFiles.Where(x => x.Category == "toreview").Select(x => new AttImageInfo { ID = x.FileID, Category = x.Category, Data = x.FileData });

                    briefAndImagesReview.SetToImages(images.ToList());

                }

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

                {

                    var images = doc.AttFiles.Where(x => x.Category == "frreview").Select(x => new AttImageInfo { ID = x.FileID, Category = x.Category, Data = x.FileData });

                    briefAndImagesReview.SetFrImages(images.ToList());

                }

                if (doc.AttFiles.Any(x => x.Category == "id2work"))

                {

                    var images = doc.AttFiles.Where(x => x.Category == "id2work").Select(x => new AttImageInfo { ID = x.FileID, Category = x.Category, Data = x.FileData });

                    issueImagesAndAnswerWork.SetImages(images.ToList());

                }

            }

        }

        private void RadGridViewDocuments_DefaultValuesNeeded(object sender, GridViewRowEventArgs e)

        {

            //if (e.Row is GridViewNewRowInfo)

            //{

            //    e.Row.Cells["RefProjectCode"].ReadOnly = false;

            //    e.Row.Cells["DocumentNo"].ReadOnly = false;

            //}

            //BindingDocumentToDetailEditor(new Documents());

        }

        private void RadGridViewDocuments_UserAddedRow(object sender, GridViewRowEventArgs e)

        {

            if (e.Row.DataBoundItem is Documents doc)

            {

                this.lbSelectAndTotal.Text = $"{this.radGridViewDocuments.MasterTemplate.DataView.Count} / {this.SearchCount} / {this.TotalCount} (Filter / Search / Total)";

            }

        }

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

                //    }

                //}

                BindingDocumentToDetailEditor(doc);

            }

        }

        #region Init, Load

        private void Initialize()

        {

            this.Text = $"{Globals.Name} (Ver : {Application.ProductVersion})";

            this.ID2ManagerRadRibbonBar.Expanded = false;

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

        }

        protected override void OnLoad(EventArgs e)

        {

            try

            {

                LoadDockingLayout();

                this.radDropDownButtonElementTheme.Text = Program.ThemeName;

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

                InitializeGrid();

                bool isID2DB = this.IsID2Connection();

                this.SetMenus(isID2DB);

                if (isID2DB)

                {

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

                    }

                    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;

            try

            {

                isSuccess = Globals.IsProjectDBConnstr();

                if (isSuccess)

                {

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

                }

            }

            catch (Exception ex)

            {

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

                isSuccess = false;

            }

            return isSuccess;

        }

        private void SetMenus(bool isid2)

        {

            if (isid2)

            {

                if (this.IsID2Manager)

                {

                    this.radButtonElementNoticeUpload.Enabled = true;

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

                    this.backstageTabItemOpenProject.Visibility = ElementVisibility.Visible;

                    this.backstageButtonItemUserRegistration.Visibility = ElementVisibility.Visible;

                    this.ribbonTabProjMgt.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;

                    this.ribbonTabProjMgt.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;

                this.ribbonTabProjMgt.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()

        {

            InitializeColumns();

            InitializeSearch();

            InitializeGridViewDetail();

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

        }

        private void InitializeColumns()

        {

            bool isClient = !string.IsNullOrEmpty(informations.ActiveUser.RefProjectID);

            GridViewColumnCollection cols = this.radGridViewDocuments.Columns;

            cols.ForAll(x =>

            {

                if (!x.ReadOnly)

                {

                    switch (x.Name)

                    {

                        case "FrReviewStatus":

                        case "FrRemarks":

                        case "FrCreator":

                        case "ClientReviewer":

                        case "ClientIsResult":

                        case "ClientRemarks":

                            x.ReadOnly = !isClient;

                            break;

                        default:

                            x.ReadOnly = isClient;

                            break;

                    }

                }

            });

        }

        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

                                 }).ToList();

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

            columns.Add(new FilterColumn { FieldName = "CREATE_USER", Name = "Markus User", IsSelect = true });

            columns.Add(new FilterColumn { FieldName = "TEXT", Name = "Markus Text", IsSelect = true });

            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;

                    }

                    foreach (var template in radGridViewDocuments.Templates)

                    {

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

                        {

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

                        }

                    }

                }

            };

            btnFilters.HostedItem = btnComboColumns;

        }

        private void InitializeGridViewDetail()

        {

            DetailGridViewTemplate markupList = new DetailGridViewTemplate();

            GridViewTextBoxColumn userColumn = new GridViewTextBoxColumn("CREATE_USER");

            GridViewTextBoxColumn textColumn = new GridViewTextBoxColumn("TEXT");

            userColumn.MinWidth = 110;

            userColumn.AutoSizeMode = BestFitColumnMode.AllCells;

            userColumn.AllowSearching = true;

            textColumn.AutoSizeMode = BestFitColumnMode.AllCells;

            textColumn.AllowSearching = true;

            markupList.Columns.AddRange(userColumn, textColumn);

            markupList.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;

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

                    }

                }

            }

        }

        private void RadGridViewDocuments_ChildViewExpanded(object sender, ChildViewExpandedEventArgs e)

        {

            if (e.IsExpanded)

            {

            }

        }

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

                }

            }

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

        {

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

            try

            {

                #region Date

                //Date Type

                if (this.radCheckedDropDownListDateType.DataSource != null)

                    this.radCheckedDropDownListDateType.DataSource = null;

                this.radCheckedDropDownListDateType.DataSource = informations.DateType;

                this.radCheckedDropDownListDateType.DisplayMember = "Value";

                this.radCheckedDropDownListDateType.ValueMember = "Key";

                //FromDate

                this.radDateTimePickerFr.NullableValue = null;

                this.radDateTimePickerFr.SetToNullValue();

                //ToDate

                this.radDateTimePickerTo.NullableValue = null;

                this.radDateTimePickerTo.SetToNullValue();

                #endregion

                #region 도면

                //Team List

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

                    this.radDropDownListTeam.Items.Clear();

                informations.ProjectList.Where(x => x.GroupID.Equals(informations.ActiveProject.ProjectID) && !string.IsNullOrEmpty(x.Team))

                                        .GroupBy(g => g.Team)

                                        .OrderBy(o => o.Key)

                                        .Select(x => x.Key)

                                        .ForAll(x =>

                                        {

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

                                        });

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

                this.radDropDownListTeam.Items.Insert(0, allTeam);

                allTeam.Selected = true;

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

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

                }

                //ID2 Issues

                {

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

                        this.radDropDownListID2Issues.Items.Clear();

                    informations.IsYesNo.ForEach(x =>

                    {

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

                    });

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

                    this.radDropDownListID2Issues.Items.Insert(0, allID2Issues);

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

                }

                //AVEVA Issues

                {

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

                        this.radDropDownListAVEVAIssues.Items.Clear();

                    informations.IsYesNo.ForEach(x =>

                    {

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

                    });

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

                    this.radDropDownListAVEVAIssues.Items.Insert(0, allAVEVAIssues);

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

            }

            catch (Exception ex)

            {

                throw ex;

            }

            finally

            {

                this.Cursor = Cursors.Default;

            }

        }

        #region Document List 조회

        public void GetDocList(bool isFilterClear)

        {

            try

            {

                if (this.radDropDownListProject.SelectedValue != null)

                {

                    string team = this.radDropDownListTeam.SelectedValue.ToString();

                    List<string> dateTypes = this.radCheckedDropDownListDateType.CheckedItems.Select(x => x.Value.ToString()).ToList();

                    DateTime? frDate = this.radDateTimePickerFr.Value.Equals(this.radDateTimePickerFr.NullDate) ? (DateTime?)null : this.radDateTimePickerFr.Value;

                    DateTime? toDate = this.radDateTimePickerTo.Value.Equals(this.radDateTimePickerTo.NullDate) ? (DateTime?)null : this.radDateTimePickerTo.Value;

                    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 id2Status = this.radDropDownListID2Status.SelectedValue.ToString();

                    string id2Issues = this.radDropDownListID2Issues.SelectedValue.ToString();

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

                    string avevaIssues = this.radDropDownListAVEVAIssues.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(dateTypes, frDate, toDate, team, projectCode, personIncharge, jobLevel, documentNo, isToIsDiscussion, isFrReviewStatus, id2Status, id2Issues, avevaStatus, avevaIssues, 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;

                        this.SearchCount = docData.Dwgs.Count;

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

                        if (!string.IsNullOrWhiteSpace(projectCode))

                        {

                            projectCodes.Add(projectCode);

                        }

                        else

                        {

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

                        }

                        this.DocumentListBinding(isFilterClear);

                    };

                    (btnShowAllDetail.HostedItem as RadCheckBoxElement).Checked = false;

                    worker.StartWork();

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        public void DocumentListBinding(bool isFilterClear)

        {

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

                var emptyUser = new UserInfo() { ID = null, Name = null };

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

                ColPersonInCharge.DataSource = workUsers.Prepend(emptyUser);

                ColPersonInCharge.DisplayMember = "Name";

                ColPersonInCharge.ValueMember = "ID";

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

                ColWorker.DataSource = workUsers.Prepend(emptyUser);

                ColWorker.DisplayMember = "Name";

                ColWorker.ValueMember = "ID";

                GridViewComboBoxColumn ColAVEVAPersonInCharge = this.radGridViewDocuments.Columns["AVEVAPersonInCharge"] as GridViewComboBoxColumn;

                ColAVEVAPersonInCharge.DataSource = workUsers.Prepend(emptyUser);

                ColAVEVAPersonInCharge.DisplayMember = "Name";

                ColAVEVAPersonInCharge.ValueMember = "ID";

                GridViewComboBoxColumn ColAVEVAWorker = this.radGridViewDocuments.Columns["AVEVAWorker"] as GridViewComboBoxColumn;

                ColAVEVAWorker.DataSource = workUsers.Prepend(emptyUser);

                ColAVEVAWorker.DisplayMember = "Name";

                ColAVEVAWorker.ValueMember = "ID";

                GridViewComboBoxColumn ColReplyRequester = this.radGridViewDocuments.Columns["ReplyRequester"] as GridViewComboBoxColumn;

                ColReplyRequester.DataSource = workUsers;

                ColReplyRequester.DisplayMember = "Name";

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

                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

                           };

                */

                if (isFilterClear)

                    this.radGridViewDocuments.FilterDescriptors.Clear();

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

                this.lbSelectAndTotal.Text = $"{this.radGridViewDocuments.MasterTemplate.DataView.Count} / {this.SearchCount} / {this.TotalCount} (Filter / Search / Total)";

                var classify = this.LayoutValidation.Controls[0] as Classify;

                classify.DocumentListBinding(this.documents);

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        #endregion

        #region 조회조건, filter Event

        private void RadButtonDateClear_Click(object sender, EventArgs e)

        {

            //DateType

            this.radCheckedDropDownListDateType.CheckedItems.Clear();

            //FromDate

            this.radDateTimePickerFr.SetToNullValue();

            //ToDate

            this.radDateTimePickerTo.SetToNullValue();

        }

        private void RadDropDownList_SelectedIndexChanged(object sender, Telerik.WinControls.UI.Data.PositionChangedEventArgs e)

        {

            if (sender is RadDropDownList ddl)

            {

                if (ddl.SelectedValue != null)

                {

                    if (string.IsNullOrEmpty(ddl.SelectedValue.ToString()))

                    {

                        ddl.BackColor = Color.White;

                        ddl.ForeColor = Color.Black;

                        ddl.Font = new Font("Segoe UI", 8.25F, FontStyle.Regular);

                    }

                    else

                    {

                        ddl.BackColor = Color.DarkSlateBlue;

                        ddl.ForeColor = Color.Yellow;

                        ddl.Font = new Font("Segoe UI", 8.25F, FontStyle.Bold);

                    }

                }

            }

        }

        private void RadCollapsiblePanelCondition_Collapsed(object sender, EventArgs e)

        {

            this.radCollapsiblePanelCondition.HeaderText = "Show";

            this.LayoutMain.RowStyles[0] = new RowStyle() { SizeType = SizeType.Absolute, Height = 30F };

        }

        private void RadCollapsiblePanelCondition_Expanded(object sender, EventArgs e)

        {

            this.radCollapsiblePanelCondition.HeaderText = "Hide";

            this.LayoutMain.RowStyles[0] = new RowStyle() { SizeType = SizeType.Absolute, Height = 210F };

        }

        private void RadCheckBoxFreezed_CheckStateChanged(object sender, EventArgs e)

        {

            if (sender is RadCheckBox checkBox)

            {

                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.IsPinned = checkBox.Checked;

                }

            }

        }

        private void RadCheckBox_CheckStateChanged(object sender, EventArgs e)

        {

            if (sender is RadCheckBox checkBox)

            {

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

        {

            if (sender is RadTextBox txtBox)

            {

                if (txtBox.Text.Length > 0)

                {

                    txtBox.BackColor = Color.DarkSlateBlue;

                    txtBox.ForeColor = Color.Yellow;

                    txtBox.Font = new Font("Segoe UI", 8.25F, FontStyle.Bold);

                }

                else

                {

                    txtBox.BackColor = Color.White;

                    txtBox.ForeColor = Color.Black;

                    txtBox.Font = new Font("Segoe UI", 8.25F, FontStyle.Regular);

                }

            }

        }

        private void RadButtonSearch_Click(object sender, EventArgs e)

        {

            try

            {

                BeginInvoke(new Action(() =>

                {

                    this.radCollapsiblePanelCondition.Collapse();

                }));

                this.GetDocList(false);

            }

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

            }

        }

        #endregion

        #region Backstage Button Event

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

                    }

                    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 dwgExtension = ".dwg";

                switch (e.Column.Name)

                {

                    case "AutoCADLink":

                        {

                            if (e.Row.DataBoundItem is Documents doc)

                            {

                                string ID2DrawingFolder = System.IO.Path.Combine(informations.FindID2LocalPath(doc.RefProjectCode), "drawings", "Native");

                                string dwgFilePath = System.IO.Path.Combine(ID2DrawingFolder, $"{doc.DocumentNo}{dwgExtension}");

                                System.Diagnostics.Process.Start(dwgFilePath);

                            }

                        }

                        break;

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

                        RadMessageBox.Show($"{e.Column.Name} 실행", Globals.Name, MessageBoxButtons.OK, RadMessageIcon.Info);

                        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;

                                    }

                                }

                                catch { }

                            }

                        }

                        catch (Exception ex)

                        {

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

                        }

                        break;

                }

            }

        }

        private void RadGridViewDocuments_CellBeginEdit(object sender, GridViewCellCancelEventArgs e)

        {