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.AutoModeling.SPPID.Properties;

using Converter.AutoModeling.SPPID.DB;

using Converter.AutoModeling.SPPID.Util;

using Converter.AutoModeling.SPPID.Form;

namespace Converter.AutoModeling.SPPID

{

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

    {

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

        private DataTable converterDT = new DataTable();

        private RepositoryItemComboBox templateComboBox;

        public ConverterForm()

        {

            InitializeComponent();

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

            Msg.Culture = culture;

            InitGridControl();

            InitID2Project();

        }

        private void InitGridControl()

        {

            #region Converter Page

            gridViewConverter.OptionsSelection.MultiSelect = true;

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

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

            gridControlConverter.DataSource = converterDT;

            templateComboBox = new RepositoryItemComboBox();

            templateComboBox.TextEditStyle = TextEditStyles.DisableTextEditor;

            gridControlConverter.RepositoryItems.Add(templateComboBox);

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

            RepositoryItemButtonEdit unitButton = new RepositoryItemButtonEdit();

            unitButton.ButtonClick += UnitButton_ButtonClick;

            unitButton.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;

            gridControlConverter.RepositoryItems.Add(unitButton);

            gridViewConverter.Columns["colUnit"].ColumnEdit = unitButton;

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

                InitSPPIDDB();

                return true;

            }

            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;

                InitSPPIDDB();

                return false;

            }

        }

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

            }

            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;

            }

            else

            {

                labelSPPIDPlantName.Text = " ";

                labelSPPIDPlantName.AppearanceItemCaption.ForeColor = Color.Red;

                labelSPPIDDBStatus.Text = Msg.ConnectionFail;

                labelSPPIDDBStatus.AppearanceItemCaption.ForeColor = Color.Red;

            }

        }

        private bool IsID2Project(string path)

        {

            bool result = false;

            string[] directories = Directory.GetDirectories(path, "*", SearchOption.TopDirectoryOnly);

            for (int i = 0; i < directories.Length; i++)

                directories[i] = Path.GetFileName(directories[i]);

            List<string> dirList = directories.ToList();

            if (dirList.Contains("db") &&

                dirList.Contains("Temp") &&

                dirList.Contains("image"))

            {

                result = true;

            }

            return result;

        }

        private void UnitButton_ButtonClick(object sender, ButtonPressedEventArgs e)

        {

            //UnitForm unitForm = new UnitForm(dUnit);

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

            //{

            //    ButtonEdit button = sender as ButtonEdit;

            //    button.EditValue = unitForm.SelectedUnit;

            //    gridViewConverter.CloseEditor();

            //    gridViewConverter.UpdateCurrentRow();

            //    gridViewConverter.BestFitColumns();

            //}

        }

        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)

                {

                    Document document = new Document(fileName);

                    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)

        {

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

            form.ShowDialog();

        }

    }

}