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 Microsoft.VisualBasic;

using Converter.BaseModel;

using DevExpress.XtraEditors.Repository;

using DevExpress.XtraEditors.Controls;

using DevExpress.XtraEditors;

using System.Globalization;

using System.Threading;

using System.IO;

using Converter.SPPID.Properties;

using Converter.SPPID.DB;

using Converter.SPPID.Util;

using Converter.SPPID.Form;

using Converter.SPPID.Model;

namespace Converter.SPPID

{

    public partial class ConverterForm : DevExpress.XtraBars.Ribbon.RibbonForm

    {

        private Dictionary<string, SPPID_Document> _DicDocuments = new Dictionary<string, SPPID_Document>();

        private List<SPPID_Document> _Documents = new List<SPPID_Document>();

        public List<SPPID_Document> Documents { get { return _Documents; } }

        private DataTable _ConverterDT = new DataTable();

        private DataTable _SPPIDSymbolPathDT = new DataTable();

        private DataTable _SPPIDUnitDT = new DataTable();

        private RepositoryItemComboBox templateComboBox;

        private DataTable _ID2SymbolDT = new DataTable();

        private DataTable _ID2LineDT = new DataTable();

        private DataTable _ID2AssociationDT = new DataTable();

        private DataTable _ID2LinePropertyDT = new DataTable();

        private List<SymbolMapping> symbolMappings = new List<SymbolMapping>();

        private List<LineMapping> lineMappings = new List<LineMapping>();

        private List<LineNumberMapping> lineNumberMappings = new List<LineNumberMapping>();

        private List<AssociationMapping> associationMappings = new List<AssociationMapping>();

        public ConverterForm()

        {

            InitializeComponent();

            CultureInfo culture = CultureInfo.GetCultureInfo("ko");

            Msg.Culture = culture;

            InitUsedDataTable();

            InitGridControl();

            InitID2Project();

        }

        private void InitUsedDataTable()

        {

            // Converter Table

            DataColumn col = _ConverterDT.Columns.Add("colDrawingFileName");

            col.Caption = "Drawing File Name";

            col = _ConverterDT.Columns.Add("colDrawingFilePath");

            col.Caption = "DrawingFilePath";

            col = _ConverterDT.Columns.Add("colUnit");

            col.Caption = "Unit";

            col = _ConverterDT.Columns.Add("colTemplate");

            col.Caption = "Template";

            col = _ConverterDT.Columns.Add("colDrawingNumber");

            col.Caption = "Drawing Number";

            col = _ConverterDT.Columns.Add("colDrawingName");

            col.Caption = "Drawing Name";

            col = _ConverterDT.Columns.Add("colStatus");

            col.Caption = "Status";

            col = _ConverterDT.Columns.Add("colUID");

            col = _ID2LineDT.Columns.Add("UID");

            col = _ID2LineDT.Columns.Add("Name");

            col.Caption = "Name";

            col = _ID2LineDT.Columns.Add("Type");

            col.Caption = "Type";

            col = _ID2LineDT.Columns.Add("SPPID_SYMBOL_PATH");

            col.Caption = "SPPID Symbol Path";

            col = _ID2LineDT.Columns.Add("Clear");

            col.Caption = "";

        }

        private void InitGridControl()

        {

            #region Converter Page

            gridViewConverter.OptionsSelection.MultiSelect = true;

            gridViewConverter.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect;

            gridControlConverter.DataSource = _ConverterDT;

            templateComboBox = new RepositoryItemComboBox();

            templateComboBox.TextEditStyle = TextEditStyles.DisableTextEditor;

            templateComboBox.EditValueChanged += templateComboBox_EditValueChanged;

            gridControlConverter.RepositoryItems.Add(templateComboBox);

            gridViewConverter.Columns["colTemplate"].ColumnEdit = templateComboBox;

            gridViewConverter.Columns["colUnit"].OptionsColumn.AllowEdit = false;

            gridViewConverter.Columns["colDrawingFileName"].OptionsColumn.AllowEdit = false;

            gridViewConverter.Columns["colUnit"].OptionsColumn.ReadOnly = true;

            gridViewConverter.Columns["colStatus"].OptionsColumn.AllowEdit = false;

            gridViewConverter.Columns["colDrawingFilePath"].Visible = false;

            gridViewConverter.Columns["colUID"].Visible = false;

            gridViewConverter.BestFitColumns();

            #endregion

        }

        private void templateComboBox_EditValueChanged(object sender, EventArgs e)

        {

            gridViewConverter.CloseEditor();

            gridViewConverter.UpdateCurrentRow();

        }

        private void gridViewConverter_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)

        {

            if (e.Column.Name == "colcolTemplate")

            {

                gridViewConverter.ShowEditor();

                (gridViewConverter.ActiveEditor as ComboBoxEdit).ShowPopup();

            }

            else if (e.Column.Name == "colcolUnit")

            {

                UnitForm unitForm = new UnitForm(_SPPIDUnitDT);

                if (unitForm.ShowDialog() == DialogResult.OK)

                {

                    gridViewConverter.SetRowCellValue(e.RowHandle, e.Column, unitForm.SelectedUnit);

                    gridViewConverter.CloseEditor();

                    gridViewConverter.UpdateCurrentRow();

                }

            }

        }

        private void btnID2Project_ButtonClick(object sender, ButtonPressedEventArgs e)

        {

            xtraFolderBrowserDialog.SelectedPath = btnID2Project.Text;

            if (xtraFolderBrowserDialog.ShowDialog() == DialogResult.OK)

            {

                if (xtraFolderBrowserDialog.SelectedPath[xtraFolderBrowserDialog.SelectedPath.Length - 1] == '\\')

                    xtraFolderBrowserDialog.SelectedPath = xtraFolderBrowserDialog.SelectedPath.Remove(xtraFolderBrowserDialog.SelectedPath.Length - 1);

                Settings.Default.LatestProjectPath = xtraFolderBrowserDialog.SelectedPath;

                Settings.Default.Save();

                if (InitID2Project())

                {

                    MessageBox.Show(Msg.SuccessProjectSelect, Msg.Information, MessageBoxButtons.OK, MessageBoxIcon.Information);

                }

                else

                    MessageBox.Show(Msg.FailProjectSelect, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);

            }

        }

        private bool InitID2Project()

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            _ProjectInfo.DefaultPath = Settings.Default.LatestProjectPath;

            if (Project_DB.ConnTestAndCreateTable())

            {

                _ProjectInfo.Enable = true;

                btnID2Project.Text = _ProjectInfo.DefaultPath;

                labelID2ProjectName.Text = _ProjectInfo.Name;

                labelID2ProjectName.AppearanceItemCaption.ForeColor = Color.Blue;

                labelID2ProjectStatus.Text = Msg.ConnectionSuccessful;

                labelID2ProjectStatus.AppearanceItemCaption.ForeColor = Color.Blue;

                layoutControlGroupSPPIDDB.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;

                layoutControlGroupItemMapping.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;

            }

            else

            {

                _ProjectInfo.Enable = false;

                btnID2Project.Text = "";

                labelID2ProjectName.Text = " ";

                labelID2ProjectName.AppearanceItemCaption.ForeColor = Color.Red;

                labelID2ProjectStatus.Text = Msg.ConnectionFail;

                labelID2ProjectStatus.AppearanceItemCaption.ForeColor = Color.Red;

                layoutControlGroupSPPIDDB.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;

                layoutControlGroupItemMapping.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;

            }

            InitMapping();

            InitSPPIDDB();

            return _ProjectInfo.Enable;

        }

        private void InitMapping()

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            if (_ProjectInfo.Enable)

            {

                InitID2Symbol();

                InitID2Line();

                InitID2LineNumber();

                InitID2Association();

                InitETCSetting();

            }

        }

        private void InitETCSetting()

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            if (_ProjectInfo.Enable)

            {

                DataTable dt = Project_DB.SelectETCSetting();

                if (dt.Columns.Count > 0 && dt.Rows.Count > 0)

                    SPPIDUtil.ConvertToETCSetting(dt.Rows[0][0].ToString());

                else

                    SPPID_DBInfo.Clear();

            }

        }

        private void InitID2Symbol()

        {

            using (DataTable symbolDT = Project_DB.SelectProjectSymbol())

            {

                symbolMappings.Clear();

                _ID2SymbolDT = symbolDT;

                _ID2SymbolDT.Columns.Add("Clear");

                _ID2SymbolDT.Columns["Clear"].Caption = "";

                foreach (DataRow row in symbolDT.Rows)

                {

                    symbolMappings.Add(new SymbolMapping()

                    {

                        UID = row["UID"] == null ? "" : row["UID"].ToString(),

                        SYMBOLNAME = row["Name"] == null ? "" : row["Name"].ToString(),

                        SPPIDSYMBOLNAME = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString(),

                    });

                }

            }

        }

        private void InitID2Line()

        {

            using (DataTable lineTypes = Project_DB.SelectProjectLine())

            {

                lineMappings.Clear();

                _ID2LineDT.Rows.Clear();

                foreach (DataRow row in lineTypes.Rows)

                {

                    DataRow newRow = _ID2LineDT.NewRow();

                    newRow["UID"] = row["UID"] == null ? "" : row["UID"].ToString();

                    newRow["Name"] = row["Name"] == null ? "" : row["Name"].ToString();

                    newRow["Type"] = "Line";

                    newRow["SPPID_SYMBOL_PATH"] = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString();

                    _ID2LineDT.Rows.Add(newRow);

                    lineMappings.Add(new LineMapping()

                    {

                        UID = row["UID"] == null ? "" : row["UID"].ToString(),

                        LINENAME = row["Name"] == null ? "" : row["Name"].ToString(),

                        SPPIDSYMBOLNAME = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString(),

                    });

                }

            }

        }

        private void InitID2LineNumber()

        {

            using (DataTable linePropertiesDT = Project_DB.SelectProjectLineProperties())

            {

                lineNumberMappings.Clear();

                _ID2LinePropertyDT = linePropertiesDT;

                _ID2LinePropertyDT.Columns.Add("Type");

                foreach (DataRow row in linePropertiesDT.Rows)

                {

                    row["Type"] = "Line Property";

                    lineNumberMappings.Add(new LineNumberMapping()

                    {

                        UID = row["UID"] == null ? "" : row["UID"].ToString(),

                        DisplayName = row["DisplayName"] == null ? "" : row["DisplayName"].ToString(),

                        SPPIDATTRIBUTENAME = row["SPPID_ATTRIBUTE"] == null ? "" : row["SPPID_ATTRIBUTE"].ToString(),

                        SPPIDSYMBOLNAME = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString()

                    });

                }

            }

        }

        private void InitID2Association()

        {

            using (DataTable associationDT = Project_DB.SelectProjectAssociation())

            {

                associationMappings.Clear();

                _ID2AssociationDT = associationDT;

                _ID2AssociationDT.Columns.Add("Clear");

                _ID2AssociationDT.Columns["Clear"].Caption = "";

                foreach (DataRow row in associationDT.Rows)

                {

                    associationMappings.Add(new AssociationMapping()

                    {

                        UID = row["UID"] == null ? "" : row["UID"].ToString(),

                        DisplayAttribute = row["DisplayAttribute"] == null ? "" : row["DisplayAttribute"].ToString(),

                        Type = row["Type"] == null ? "" : row["Type"].ToString(),

                        SPPIDATTRIBUTENAME = row["SPPID_ATTRIBUTE"] == null ? "" : row["SPPID_ATTRIBUTE"].ToString(),

                        SPPIDSYMBOLNAME = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString()

                    });

                }

            }

        }

        private void InitSPPIDDB()

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            if (_ProjectInfo.Enable)

            {

                DataTable dt = Project_DB.SelectSPPID_DB_INFO();

                if (dt.Columns.Count > 0 && dt.Rows.Count > 0)

                    SPPIDUtil.ConvertToSPPIDInfo(dt.Rows[0][0].ToString());

                else

                    SPPID_DBInfo.Clear();

            }

            templateComboBox.Items.Clear();

            SPPID_DBInfo _SPPIDInfo = SPPID_DBInfo.GetInstance();

            if (_SPPIDInfo.Enable)

            {

                labelSPPIDPlantName.Text = _SPPIDInfo.SelectedPlant;

                labelSPPIDPlantName.AppearanceItemCaption.ForeColor = Color.Blue;

                labelSPPIDDBStatus.Text = Msg.ConnectionSuccessful;

                labelSPPIDDBStatus.AppearanceItemCaption.ForeColor = Color.Blue;

                string TemplatePath = SPPID_DB.GetPlantPID_T_OPTIONSETTING_Value("PID Template Path");

                if (!string.IsNullOrEmpty(TemplatePath))

                    templateComboBox.Items.AddRange(Directory.GetFiles(TemplatePath, "*.pid").ToList().Select(filePath => Path.GetFileName(filePath)).ToList());

                _SPPIDUnitDT = SPPID_DB.GetUnitTree();

                layoutControlGroupAutoConverter.Enabled = true;

            }

            else

            {

                labelSPPIDPlantName.Text = " ";

                labelSPPIDPlantName.AppearanceItemCaption.ForeColor = Color.Red;

                labelSPPIDDBStatus.Text = Msg.ConnectionFail;

                labelSPPIDDBStatus.AppearanceItemCaption.ForeColor = Color.Red;

                layoutControlGroupAutoConverter.Enabled = false;

            }

            _DicDocuments.Clear();

            _ConverterDT.Rows.Clear();

            InitSPPIDSymbolTreeTable();

        }

        private void InitSPPIDSymbolTreeTable()

        {

            SPPID_DBInfo _SPPIDInfo = SPPID_DBInfo.GetInstance();

            _SPPIDSymbolPathDT = new DataTable();

            _SPPIDSymbolPathDT.Columns.Add("ID");

            _SPPIDSymbolPathDT.Columns.Add("Parent");

            _SPPIDSymbolPathDT.Columns.Add("Name");

            _SPPIDSymbolPathDT.Columns.Add("FullPath");

            if (_SPPIDInfo.Enable)

            {

                string symbolPath = SPPID_DB.GetPlantPID_T_OPTIONSETTING_Value("Catalog Explorer root path");

                DirectoryInfo info = new DirectoryInfo(symbolPath);

                _SPPIDSymbolPathDT.Rows.Add(new object[] { "0", "-1", info.Name });

                loop(info, "0", symbolPath);

            }

        }

        private void loop(DirectoryInfo parentInfo, string parentUID, string defaultPath)

        {

            DirectoryInfo[] infos = parentInfo.GetDirectories();

            foreach (DirectoryInfo info in infos)

            {

                string uid = Guid.NewGuid().ToString();

                _SPPIDSymbolPathDT.Rows.Add(new object[] { uid, parentUID, info.Name });

                loop(info, uid, defaultPath);

                FileInfo[] files = info.GetFiles("*.sym");

                foreach (FileInfo fileInfo in files)

                {

                    _SPPIDSymbolPathDT.Rows.Add(new object[] { Guid.NewGuid().ToString(), uid, fileInfo.Name, fileInfo.FullName.Replace(defaultPath, "") });

                }

            }

        }

        private void btnLoadFile_Click(object sender, EventArgs e)

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            if (!_ProjectInfo.Enable)

            {

                MessageBox.Show(Msg.PleaseSetID2ProjectInfo, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);

                return;

            }

            xtraOpenFileDialog.InitialDirectory = _ProjectInfo.TempDirPath;

            if (xtraOpenFileDialog.ShowDialog() == DialogResult.OK)

            {

                foreach (string fileName in xtraOpenFileDialog.FileNames)

                {

                    SPPID_Document document = new SPPID_Document(fileName);

                    document.SymbolMappings = symbolMappings;

                    document.LineMappings = lineMappings;

                    document.LineNumberMappings = lineNumberMappings;

                    document.AssociationMappings = associationMappings;

                    DataRow[] rows = _ConverterDT.Select(string.Format("colDrawingFilePath = '{0}'", fileName));

                    DataRow row;

                    if (rows.Length == 0)

                    {

                        row = _ConverterDT.NewRow();

                        row["colDrawingFileName"] = Path.GetFileNameWithoutExtension(fileName);

                        row["colDrawingFilePath"] = fileName;

                        row["colDrawingNumber"] = document.DWGNAME;

                        row["colDrawingName"] = document.DWGNAME;

                        if (document.Enable)

                            row["colStatus"] = "Ready";

                        else

                            row["colStatus"] = "Error";

                        row["colUID"] = "";

                        _ConverterDT.Rows.Add(row);

                    }

                    if (!_DicDocuments.ContainsKey(fileName))

                        _DicDocuments.Add(fileName, null);

                    _DicDocuments[fileName] = document;

                }

            }

        } 

        private void btnRun_Click(object sender, EventArgs e)

        {

            _Documents.Clear();

            foreach (int rowHandle in gridViewConverter.GetSelectedRows())

            {

                string _FilePath = gridViewConverter.GetRowCellDisplayText(rowHandle, "colDrawingFilePath");

                string _Unit = gridViewConverter.GetRowCellDisplayText(rowHandle, "colUnit");

                string _Template = gridViewConverter.GetRowCellDisplayText(rowHandle, "colTemplate");

                string _DrawingNumber = gridViewConverter.GetRowCellDisplayText(rowHandle, "colDrawingNumber");

                string _DrawingName = gridViewConverter.GetRowCellDisplayText(rowHandle, "colDrawingName");

                SPPID_Document document = _DicDocuments[_FilePath];

                document.Unit = _Unit;

                document.Template = _Template;

                document.DrawingNumber = _DrawingNumber;

                document.DrawingName = _DrawingName;

                _Documents.Add(document);

            }

            DialogResult = DialogResult.OK;

        }

        private void btnSPPIDDB_Click(object sender, EventArgs e)

        {

            SPPID_DB_SettingForm form = new SPPID_DB_SettingForm();

            if (form.ShowDialog() == DialogResult.OK)

                InitSPPIDDB();

        }

        private void btnItemMapping_Click(object sender, EventArgs e)

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            if (!_ProjectInfo.Enable)

            {

                MessageBox.Show(Msg.PleaseSetID2ProjectInfo, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);

                return;

            }

            MappingForm form = new MappingForm(_ID2SymbolDT,_SPPIDSymbolPathDT, _ID2LineDT, _ID2LinePropertyDT, _ID2AssociationDT);

            form.ShowDialog();

            InitMapping();

        }

        private List<int> prevSelectedList = new List<int>();

        private void gridViewConverter_SelectionChanged(object sender, DevExpress.Data.SelectionChangedEventArgs e)

        {

            if (e.Action == CollectionChangeAction.Add)

            {

                string _Unit = gridViewConverter.GetRowCellDisplayText(e.ControllerRow, "colUnit");

                string _Template = gridViewConverter.GetRowCellDisplayText(e.ControllerRow, "colTemplate");

                if (string.IsNullOrEmpty(_Unit) || string.IsNullOrEmpty(_Template))

                    gridViewConverter.UnselectRow(e.ControllerRow);

            }

            else if (e.Action == CollectionChangeAction.Refresh)

            {

                foreach (int rowHandle in gridViewConverter.GetSelectedRows())

                {

                    string _Unit = gridViewConverter.GetRowCellDisplayText(rowHandle, "colUnit");

                    string _Template = gridViewConverter.GetRowCellDisplayText(rowHandle, "colTemplate");

                    if (string.IsNullOrEmpty(_Unit) || string.IsNullOrEmpty(_Template))

                        gridViewConverter.UnselectRow(rowHandle);

                }

                List<int> selectedRowHandleList = gridViewConverter.GetSelectedRows().ToList();

                var firstNotSecond = prevSelectedList.Except(selectedRowHandleList).ToList();

                var secondNotFirst = selectedRowHandleList.Except(prevSelectedList).ToList();

                if (!firstNotSecond.Any() && !secondNotFirst.Any())

                {

                    this.gridViewConverter.SelectionChanged -= new DevExpress.Data.SelectionChangedEventHandler(this.gridViewConverter_SelectionChanged);

                    gridViewConverter.ClearSelection();

                    this.gridViewConverter.SelectionChanged += new DevExpress.Data.SelectionChangedEventHandler(this.gridViewConverter_SelectionChanged);

                }

            }

            prevSelectedList = gridViewConverter.GetSelectedRows().ToList();

        }

    }

}