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;

        int ROW_HEADER_COLUMN_WIDTH { get; } = 48;

        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 classify = new Controls.Classify(this.radProgressBarElement) { Dock = DockStyle.Fill };

            classify.UpdateDocumentsEvent += Classify_UpdateDocumentsEvent;

            classify.OnClassifyCompleted += Classify_OnClassifyCompleted;

            this.LayoutValidation.Controls.Add(classify);

            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.TextChanged += RadTextBoxDocumentNo_TextChanged;

            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.TableSearchRow.InitialSearchResultsTreshold = ;

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

            this.radGridViewDocuments.GroupSummaryEvaluate += RadGridViewDocuments_GroupSummaryEvaluate;

            this.radGridViewID2Symbols.GroupSummaryEvaluate += RadGridViewDocuments_GroupSummaryEvaluate;

            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.radButtonSearchSymbol.ButtonElement.CustomFont = "TelerikWebUI";

            this.radButtonSearchSymbol.ButtonElement.Text = "\ue13E";

            this.designSymbol.ActiveViewport.CoordinateSystemIcon.Visible = false;

            this.radCheckBoxElementID2SymbolSearch.CheckStateChanged += RadCheckBoxElementID2SymbolSearch_CheckStateChanged;

            this.Initialize();

        }

        private void RadCheckBoxElementID2SymbolSearch_CheckStateChanged(object sender, EventArgs e)

        {

            this.toolWindowSymbol.DockState = (sender as Telerik.WinControls.UI.RadCheckBoxElement).IsChecked ? 

                Telerik.WinControls.UI.Docking.DockState.Docked : Telerik.WinControls.UI.Docking.DockState.Hidden;

        }

        /// <summary>

        /// 그룹에 속한 항목의 개수를 표시한다.

        /// </summary>

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

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

        private void RadGridViewDocuments_GroupSummaryEvaluate(object sender, GroupSummaryEvaluationEventArgs e)

        {

            if (e.Parent != this.radGridViewDocuments.MasterTemplate)

            {

                e.FormatString = $"{e.Value} - ({e.Group.ItemCount})";

            }

        }

        /// <summary>

        /// 유사도 분류 작업이 완료되면 유사도 수행 버튼을 활성화 시킨다.

        /// </summary>

        private void Classify_OnClassifyCompleted()

        {

            this.radButtonElementClassify.Visibility = ElementVisibility.Visible;

            this.radButtonElementStopWorking.Visibility = ElementVisibility.Collapsed;

        }

        /// <summary>

        /// 현재 보이는 Document를 Classify 화면에 표시한다.

        /// </summary>

        private void Classify_UpdateDocumentsEvent()

        {

            var docs = ((GridDataView)radGridViewDocuments.MasterTemplate.DataView).Indexer.Items.Select(x => x.DataBoundItem as Documents).ToList();

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

            classify.DocumentListBinding(docs);

        }

        /// <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.ActiveProjects = new List<ProjectInfo>() { new ProjectController().GetProjectInfo(informations.ActiveUser.RefProjectID) };

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

                        this.LoadProject(true);

                    }

                    else

                    {

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

                        /*

                        foreach (Control ctrl in this.backstageViewPageOpenProject.Controls)

                        {

                            if (ctrl is OpenProjectView)

                            {

                                var openProjectView = ctrl as OpenProjectView;

                                openProjectView.GetProjectGroups();

                                break;

                            }

                        }

                        */

                    };

                }

                else

                {

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

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

                }

                this.radButtonSearchSymbol.Click += RadButtonSearchSymbol_Click;

                this.radTextBoxSymbolName.KeyDown += RadTextBoxSymbolName_KeyDown;

                this.radGridViewID2Symbols.DataBindingComplete += RadGridViewID2Symbols_DataBindingComplete;

                this.radGridViewID2Symbols.SelectionChanged += RadGridViewID2Symbols_SelectionChanged;

                this.radButtonElementStopWorking.Visibility = ElementVisibility.Collapsed;

                this.radButtonElementClassify.Click += RadButtonElementClassify_Click;

                this.radButtonElementStopWorking.Click += RadButtonElementStopWorking_Click;

                this.radButtonElementExtractText.Click += RadButtonElementExtractText_Click;

                this.radCheckBoxElementID2SymbolSearch.Checked = this.toolWindowSymbol.DockState != Telerik.WinControls.UI.Docking.DockState.Hidden;

            }

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

        }

        /// <summary>

        /// 도면에서 텍스트를 추출한다.

        /// </summary>

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

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

        private void RadButtonElementExtractText_Click(object sender, EventArgs e)

        {

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

            classify.ExtractText();

        }

        private void RadButtonElementStopWorking_Click(object sender, EventArgs e)

        {

            this.radButtonElementClassify.Visibility = ElementVisibility.Visible;

            this.radButtonElementStopWorking.Visibility = ElementVisibility.Collapsed;

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

            classify.StopWorking();

        }

        private void RadButtonElementClassify_Click(object sender, EventArgs e)

        {

            this.radButtonElementClassify.Visibility = ElementVisibility.Collapsed;

            this.radButtonElementStopWorking.Visibility = ElementVisibility.Visible;

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

            classify.DoClassifyDrawing();

        }

        /// <summary>

        /// 주어진 SymbolName을 포함하는 심볼들(실제로 프로젝트에 사용된)을 찾는다.

        /// </summary>

        /// <param name="SymbolName"></param>

        private void SearchSymbols(string SymbolName)

        {

            var AllSymbols = new List<ID2Symbol>();

            List<string> actPrjIDs = informations.ActiveProjects.Select(x => x.ProjectID).ToList();

            var id2prjs = informations.FindID2ProjectList(actPrjIDs).Where(x =>

            !string.IsNullOrEmpty(x.Host) && !string.IsNullOrEmpty(x.User) && !string.IsNullOrEmpty(x.Password)).ToList();

            foreach (var id2prj in id2prjs)

            {

                try

                {

                    var controller = new DocumentController(id2prj);

                    var configs = controller.GetID2Configurations();

                    var config = configs.FirstOrDefault(x => x.Section.Equals("Data Save") && x.Key.Equals("Drawing Xml Only"));

                    id2prj.XmlOnly = config != null && config.Value.Equals("1");

                    var symbols = controller.FindID2Symbols(SymbolName, id2prj.XmlOnly);

                    symbols.ForAll(x =>

                    {

                        x.PrjName = id2prj.Name;

                        x.PrjPath = id2prj.Path;

                    });

                    AllSymbols.AddRange(symbols);

                }

                catch (Exception ex)

                {

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

                }

            }

            var worker = new ID2SymbolWorker(id2prjs, AllSymbols, this.radGridViewID2Symbols);

            worker.OnWorkCompletedHandler += (_e) =>

            {

                this.radGridViewID2Symbols.DataSource = worker.Used;

            };

            worker.StartWork();

        }

        private void RadButtonSearchSymbol_Click(object sender, EventArgs e)

        {

            string SymbolName = this.radTextBoxSymbolName.Text;

            SearchSymbols(SymbolName);

        }

        /// <summary>

        /// 선택 항목의 심볼을 화면에 표시한다.

        /// </summary>

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

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

        private void RadGridViewID2Symbols_SelectionChanged(object sender, EventArgs e)

        {

            if (this.radGridViewID2Symbols.SelectedRows.Any() && !this.designSymbol.IsBusy)

            {

                var symbol = this.radGridViewID2Symbols.SelectedRows.First().DataBoundItem as ID2Symbol;

                string DxfFilePath = Path.Combine(symbol.PrjPath, "image", symbol.Type, symbol.Name + ".dxf");

                devDept.Eyeshot.Translators.ReadAutodesk ra = new devDept.Eyeshot.Translators.ReadAutodesk(DxfFilePath);

                this.designSymbol.WorkCompleted += (_sender, _e) =>

                {

                    if (_e.WorkUnit is devDept.Eyeshot.Translators.ReadAutodesk dxf)

                    {

                        this.designSymbol.Clear();

                        dxf.AddToScene(this.designSymbol);

                        #region 원점과 연결점들을 표시한다.

                        var tokens = symbol.OriginalPoint.Split(',');

                        if (tokens.Length == 2)

                        {

                            double x = Convert.ToDouble(tokens[0]);

                            double y = symbol.Height - Convert.ToDouble(tokens[1]);

                            var pt = new devDept.Eyeshot.Entities.Point(new devDept.Geometry.Point2D(x, y), 6)

                            {

                                Color = Color.Red,

                                ColorMethod = devDept.Eyeshot.Entities.colorMethodType.byEntity

                            };

                            this.designSymbol.Entities.Add(pt);

                        }

                        int index = 1;

                        tokens = symbol.ConnectionPoint.Split('/');

                        foreach(var token in tokens)

                        {

                            var _tokens = token.Split(',');

                            double x = Convert.ToDouble(_tokens[1]);

                            double y = symbol.Height - Convert.ToDouble(_tokens[2]);

                            var pt = new devDept.Eyeshot.Entities.Point(new devDept.Geometry.Point2D(x, y), 6)

                            {

                                Color = Color.Blue,

                                ColorMethod = devDept.Eyeshot.Entities.colorMethodType.byEntity

                            };

                            this.designSymbol.Entities.Add(pt);

                            #region 연결점 번호 표시

                            var text = new devDept.Eyeshot.Entities.Text(new devDept.Geometry.Point3D(x, y), index.ToString(), 6)

                            {

                                Color = Color.Blue,

                                ColorMethod = devDept.Eyeshot.Entities.colorMethodType.byEntity

                            };

                            this.designSymbol.Entities.Add(text);

                            index++;

                            #endregion

                        }

                        #endregion

                        this.designSymbol.ZoomFit();

                    }

                };

                this.designSymbol.StartWork(ra);

            }

        }

        private void RadGridViewID2Symbols_DataBindingComplete(object sender, GridViewBindingCompleteEventArgs e)

        {

            this.radGridViewID2Symbols.BestFitColumns();

        }

        /// <summary>

        /// 입력한 이름을 가진 ID2 심볼을 조회합니다.

        /// </summary>

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

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

        private void RadTextBoxSymbolName_KeyDown(object sender, KeyEventArgs e)

        {

            var informations = Informations.Instance;

            if(e.KeyCode == Keys.Enter)

            {

                string SymbolName = this.radTextBoxSymbolName.Text;

                SearchSymbols(SymbolName);

            }

        }

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

        {

            InitializeProp();

            InitializeColumns();

            InitializeSearch();

            InitializeGridViewDetail();

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

        }

        private void InitializeProp()

        {

            this.radGridViewDocuments.AllowAddNewRow = this.IsID2Manager;

        }

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

                        case "AVEVAPersonInCharge":

                            x.ReadOnly = !this.IsID2Manager;

                            break;

                        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.ActiveProjects = prjArgs.ProjectInfos;

                    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

            {

                //Project Group Name

                //this.radLabelProjectGroupNm.Text = informations.ActiveProject.Name;

                this.radLabelProjectGroupNm.Text = string.Join(", ", informations.ActiveProjects.Select(x => x.Name));

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

                //                        });

                (from allPrj in informations.ProjectList

                 join actPrj in informations.ActiveProjects on allPrj.GroupID equals actPrj.ProjectID

                 where !string.IsNullOrEmpty(allPrj.Team)

                 select allPrj).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));

                //                        });

                (from allPrj in informations.ProjectList

                 join actPrj in informations.ActiveProjects on allPrj.GroupID equals actPrj.ProjectID

                 select allPrj).ForAll(x =>

                 {

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

                 });

                this.radDropDownListProject.Items.Add(new RadListDataItem("== ID2 Project 미등록 ==", null));//ID2 Project 미등록

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

                    {

                        var userItem = new RadListDataItem(x.Name, x.ID);

                        this.radDropDownListPersonInCharge.Items.Add(userItem);

                        if (!this.IsID2Manager)

                            if (x.ID.Equals(informations.ActiveUser.ID))

                                userItem.Selected = true;

                    }

                });

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

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

                if (this.IsID2Manager)

                    allUser.Selected = true;

                else

                    this.radDropDownListPersonInCharge.Enabled = false;

                //난이도

                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

            {

                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)).Select(x => x.Code).ToList();

                ColProjects.DataSource = (from allPrj in informations.ProjectList

                                         join actPrj in informations.ActiveProjects on allPrj.GroupID equals actPrj.ProjectID

                                         select allPrj).Select(x => x.Code).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()