HYTOS

using DevExpress.Utils.Drawing;

using DevExpress.XtraEditors.Controls;

using DevExpress.XtraEditors.Repository;

using DevExpress.XtraGrid.Columns;

using DevExpress.XtraGrid.Views.Grid;

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.IO;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace ID2PSN

{

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

    {

        ID2Info ID2Info = ID2Info.GetInstance();

        List<EquipmentNoPocketInfo> EquipmentNoPocketInfos = new List<EquipmentNoPocketInfo>();

        EquipmentNoPocketInfo currentEquipmentNoPocketInfo = null;

        private RepositoryItemComboBox repositoryGroupType = new RepositoryItemComboBox();

        List<EquipmentAirFinCoolerInfo> EquipmentAirFinCoolerInfos = new List<EquipmentAirFinCoolerInfo>();

        EquipmentAirFinCoolerInfo currentEquipmentAirFinCoolerInfo = null;

        private RepositoryItemComboBox repositoryGroupType2 = new RepositoryItemComboBox();

        private RepositoryItemComboBox repositoryAttributeItem = new RepositoryItemComboBox();

        private DataTable SymbolList = new DataTable();

        public EquipmentSetting()

        {

            InitializeComponent();

            InitGridEquipmentNoPocket();

            InitGridEquipmentAirFinCooler();

            gridViewAirFinCooler.CellValueChanging += new DevExpress.XtraGrid.Views.Base.CellValueChangedEventHandler(gridViewSymbol_CellValueChanged);

            EquipmentNoPocketInfos = new List<EquipmentNoPocketInfo>();

            currentEquipmentNoPocketInfo = new EquipmentNoPocketInfo();

            EquipmentAirFinCoolerInfos = new List<EquipmentAirFinCoolerInfo>();

            currentEquipmentAirFinCoolerInfo = new EquipmentAirFinCoolerInfo();

            InitData();

            InitAirFinCoolerData();

        }

        private void gridViewSymbol_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)

        {            

            if (e.Column.FieldName == "Type")

            {

                DevExpress.XtraGrid.Views.Base.ColumnView columnView = sender as DevExpress.XtraGrid.Views.Base.ColumnView;

                if (!string.IsNullOrEmpty(e.Value.ToString()))

                {

                    string selectItem = e.Value.ToString();

                    if (selectItem.Contains("Air Fin Cooler"))

                    {

                        gridViewAirFinCooler.SetRowCellValue(columnView.FocusedRowHandle, "TagIdentifier", "AFC");

                    }

                    else if (selectItem.Contains("Pump"))

                    {

                        gridViewAirFinCooler.SetRowCellValue(columnView.FocusedRowHandle, "TagIdentifier", "PUMP");

                    }                    

                }

            }

        }

        public void InitGridEquipmentNoPocket()

        {

            RepositoryItemButtonEdit btnRemove = new RepositoryItemButtonEdit();

            btnRemove.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.HideTextEditor;

            btnRemove.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(removeSymbolButton_Click);

            btnRemove.Buttons[0].Kind = DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph;

            btnRemove.Buttons[0].ImageOptions.Image = ID2PSN.Properties.Resources.cancel_16x16;

            gridEquipment.RepositoryItems.Add(btnRemove);

            DataTable dtType = new DataTable();

            dtType.Columns.Add("Index");

            dtType.Columns.Add("Type");

            dtType.Columns.Add("SppidSymbolName");

            dtType.Columns.Add(" ");

            gridEquipment.DataSource = dtType;

            GridColumn gridColumn = gridViewEquipment.Columns[0];

            gridColumn.Name = "Index";

            gridColumn.Caption = "Index";

            gridColumn.OptionsColumn.AllowEdit = false;

            gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;

            gridColumn.VisibleIndex = 0;

            repositoryGroupType = new RepositoryItemComboBox();

            repositoryGroupType.Items.AddRange(new string[] { "Pump", "Vertical Vessel" });

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

            gridEquipment.RepositoryItems.Add(repositoryGroupType);

            gridColumn = gridViewEquipment.Columns[1];

            gridColumn.Name = "Type";

            gridColumn.Caption = "Equipment Type";

            gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;

            gridColumn.VisibleIndex = 1;

            gridViewEquipment.Columns["Type"].ColumnEdit = repositoryGroupType;

            gridColumn = gridViewEquipment.Columns[2];

            gridColumn.Name = "SppidSymbolName";

            gridColumn.Caption = "ID2 Symbol Name";

            gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;

            gridColumn.VisibleIndex = 2;

            RepositoryItemTreeListLookUpEdit treeListLookUpEdit = new RepositoryItemTreeListLookUpEdit();

            gridEquipment.RepositoryItems.Add(treeListLookUpEdit);

            SetSymbol(treeListLookUpEdit);

            gridViewEquipment.Columns["SppidSymbolName"].ColumnEdit = treeListLookUpEdit;

            gridColumn = gridViewEquipment.Columns[3];

            gridColumn.Name = "Remove";

            gridColumn.Caption = "";

            gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;

            gridColumn.VisibleIndex = 3;

            gridColumn.MaxWidth = 16;

            gridColumn.ColumnEdit = btnRemove;

            gridColumn.ShowButtonMode = DevExpress.XtraGrid.Views.Base.ShowButtonModeEnum.ShowAlways;

        }

        public void InitGridEquipmentAirFinCooler()

        {

            RepositoryItemButtonEdit btnRemove = new RepositoryItemButtonEdit();

            btnRemove.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.HideTextEditor;

            btnRemove.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(removeAirSymbolButton_Click);

            btnRemove.Buttons[0].Kind = DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph;

            btnRemove.Buttons[0].ImageOptions.Image = ID2PSN.Properties.Resources.cancel_16x16;

            gridControlAirFinCooler.RepositoryItems.Add(btnRemove);

            DataTable dtType = new DataTable();

            dtType.Columns.Add("Index");

            dtType.Columns.Add("Type");

            dtType.Columns.Add("TagIdentifier");

            dtType.Columns.Add("AttributeName");

            dtType.Columns.Add("SppidSymbolName");

            dtType.Columns.Add(" ");

            gridControlAirFinCooler.DataSource = dtType;

            GridColumn gridColumn = gridViewAirFinCooler.Columns[0];

            gridColumn.Name = "Index";

            gridColumn.Caption = "Index";

            gridColumn.OptionsColumn.AllowEdit = false;

            gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;

            gridColumn.VisibleIndex = 0;

            repositoryGroupType2 = new RepositoryItemComboBox();

            repositoryGroupType2.Items.AddRange(new string[] { "Air Fin Cooler", "Pump" });

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

            gridControlAirFinCooler.RepositoryItems.Add(repositoryGroupType2);

            gridColumn = gridViewAirFinCooler.Columns[1];

            gridColumn.Name = "Type";

            gridColumn.Caption = "Equipment Type";

            gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;

            gridColumn.VisibleIndex = 1;

            gridViewAirFinCooler.Columns["Type"].ColumnEdit = repositoryGroupType2;

            gridColumn = gridViewAirFinCooler.Columns[2];

            gridColumn.Name = "TagIdentifier";

            gridColumn.Caption = "Prefix";

            gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;

            gridColumn.VisibleIndex = 2;

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

            repositoryAttributeItem.AppearanceDropDown.Font = Font;

            gridControlAirFinCooler.RepositoryItems.Add(repositoryAttributeItem);

            gridColumn = gridViewAirFinCooler.Columns[3];

            gridColumn.Name = "AttributeName";

            gridColumn.Caption = "ID2 Attribute Name";

            gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;

            gridColumn.VisibleIndex = 3;

            gridViewAirFinCooler.Columns["AttributeName"].ColumnEdit = repositoryAttributeItem;

            gridColumn = gridViewAirFinCooler.Columns[4];

            gridColumn.Name = "SppidSymbolName";

            gridColumn.Caption = "ID2 Symbol Name";

            gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;

            gridColumn.VisibleIndex = 4;

            SymbolList = DB.SelectAllSymbolAttribute();

            RepositoryItemTreeListLookUpEdit treeListLookUpEdit = new RepositoryItemTreeListLookUpEdit();

            gridControlAirFinCooler.RepositoryItems.Add(treeListLookUpEdit);

            SetSymbol(treeListLookUpEdit);

            gridViewAirFinCooler.Columns["SppidSymbolName"].ColumnEdit = treeListLookUpEdit;

            gridColumn = gridViewAirFinCooler.Columns[5];

            gridColumn.Name = "Remove";

            gridColumn.Caption = "";

            gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;

            gridColumn.VisibleIndex = 5;

            gridColumn.MaxWidth = 16;

            gridColumn.ColumnEdit = btnRemove;

            gridColumn.ShowButtonMode = DevExpress.XtraGrid.Views.Base.ShowButtonModeEnum.ShowAlways;

            gridViewAirFinCooler.CustomRowCellEditForEditing += GridViewAirFinCooler_CustomRowCellEditForEditing;

        }

        private void GridViewAirFinCooler_CustomRowCellEditForEditing(object sender, CustomRowCellEditEventArgs e)

        {

            if (e.Column == (sender as GridView).Columns["AttributeName"])

            {

                DevExpress.XtraGrid.Views.Base.ColumnView columnView = sender as DevExpress.XtraGrid.Views.Base.ColumnView;

                DataTable dt = gridControlAirFinCooler.DataSource as DataTable;

                string SppidSymbolName = dt.Rows[columnView.FocusedRowHandle]["SppidSymbolName"].ToString();

                if (string.IsNullOrEmpty(SppidSymbolName))

                {

                    MessageBox.Show("Choose a symbol !", "ID2 " + ID2Info.ProgramName, MessageBoxButtons.OK, MessageBoxIcon.Information);

                    return;

                }

                repositoryAttributeItem.Items.Clear();

                repositoryAttributeItem.Items.Add("");

                foreach (DataRow dr in SymbolList.Rows)

                {

                    if (dr["SymbolName"].ToString().ToUpper().Equals(SppidSymbolName.ToUpper()))

                    {

                        repositoryAttributeItem.Items.Add(dr["SymbolAttribute"].ToString());

                    }

                }

            }

        }

        private void GridViewKeyword_CustomDrawColumnHeader(object sender, ColumnHeaderCustomDrawEventArgs e)

        {

            if (e.Column == null || (e.Column.AppearanceHeader.BackColor == Color.Empty && !e.Column.AppearanceHeader.Options.UseBackColor))

                return;

            Rectangle rect = e.Bounds;

            rect.Inflate(-1, -1);

            // Fill the title color.

            e.Graphics.FillRectangle(new SolidBrush(e.Column.AppearanceHeader.BackColor), rect);

            e.Appearance.DrawString(e.Cache, e.Info.Caption, e.Info.CaptionRect);

            // Draw filter and sort buttons.

            foreach (DrawElementInfo info in e.Info.InnerElements)

            {

                if (!info.Visible) continue;

                ObjectPainter.DrawObject(e.Cache, info.ElementPainter, info.ElementInfo);

            }

            e.Handled = true;

        }

        public void InitData()

        {

            DataTable dt = DB.SelectEquipmentNoPocketSetting();

            DataTable typeDT = gridEquipment.DataSource as DataTable;

            foreach (DataRow row in dt.Rows)

            {

                int index = Convert.ToInt32(row["INDEX"]);

                string Type = row["TYPE"].ToString();

                string SppidSymbolName = row["NAME"].ToString();

                typeDT.Rows.Add(index, Type, SppidSymbolName, null);

            }

           // typeDT.DefaultView.Sort = "INDEX ASC";

        }

        public void InitAirFinCoolerData()

        {

            DataTable dt = DB.SelectAirFinCoolerSetting();

            DataTable typeDT = gridControlAirFinCooler.DataSource as DataTable;

            foreach (DataRow row in dt.Rows)

            {

                int index = Convert.ToInt32(row["INDEX"]);

                string Type = row["TYPE"].ToString();

                string TagIdentifier = row["TagIdentifier"].ToString();

                string AttributeName = row["AttributeName"].ToString();

                string SppidSymbolName = row["NAME"].ToString();

                typeDT.Rows.Add(index, Type, TagIdentifier, AttributeName, SppidSymbolName, null);

            }

           // typeDT.DefaultView.Sort = "INDEX ASC";

        }

        private void removeSymbolButton_Click(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)

        {

            DataTable dt = gridEquipment.DataSource as DataTable;

            DataRow rows = dt.Rows[gridViewEquipment.FocusedRowHandle];

            if (rows != null)

                dt.Rows.Remove(rows);

        }

        private void removeAirSymbolButton_Click(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)

        {

            DataTable dt = gridControlAirFinCooler.DataSource as DataTable;

            DataRow rows = dt.Rows[gridViewAirFinCooler.FocusedRowHandle];

            if (rows != null)

                dt.Rows.Remove(rows);

        }

        public void SetSymbol(RepositoryItemTreeListLookUpEdit treeListLookUpEdit)

        {

            string imgPath = ID2Info.ImageDirPath;

            string[] filesPath = Directory.GetFiles(imgPath, "*.png", SearchOption.AllDirectories);

            DataTable dt = new DataTable();

            dt.Columns.Add("ID", typeof(int));

            dt.Columns.Add("ParentID", typeof(int));

            dt.Columns.Add("Name", typeof(string));

            dt.Columns.Add("Level", typeof(int));

            dt.Columns.Add("Image", typeof(Image));

            dt.PrimaryKey = new DataColumn[] { dt.Columns["ID"] };

            treeListLookUpEdit.DataSource = dt;

            treeListLookUpEdit.ValueMember = "Name";

            treeListLookUpEdit.DisplayMember = "Name";

            treeListLookUpEdit.TreeList.Columns["Level"].Visible = false;

            treeListLookUpEdit.NullText = "";

            treeListLookUpEdit.EditValueChanging += new DevExpress.XtraEditors.Controls.ChangingEventHandler(TreeList_BeforeCheckNode);

            treeListLookUpEdit.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;

            bool bLine = true;

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

            foreach (var path in filesPath)

            {

                if (Path.GetFileNameWithoutExtension(path).Contains("_display"))

                    continue;

                string root = path.Remove(0, imgPath.Length);

                string[] split = root.Split(new string[] { @"\" }, StringSplitOptions.None);

                string level1 = split[0];

                if (!level1Index.Contains(level1))

                {

                    level1Index.Add(level1);

                    dt.Rows.Add(level1Index.IndexOf(level1) + 1, 0, level1, 0);

                }

                int parentId = level1Index.IndexOf(level1) + 1;

                string level2 = split[1];

                //combobox image size 변경

                Image image = Image.FromFile(Path.Combine(imgPath, root));

                Bitmap imgbitmap = new Bitmap(image);

                Image resizedImage = resizeImage(imgbitmap, new Size(200, 200));

                dt.Rows.Add(filesPath.ToList().IndexOf(path) + 10000, parentId, Path.GetFileNameWithoutExtension(path), 1, resizedImage);

                if (Path.GetFileNameWithoutExtension(path) == "Connect To Process" && bLine)

                {

                    bLine = false;

                    dt.Rows.Add(filesPath.ToList().IndexOf(path) + 20000, parentId, "Primary", 1, resizedImage);

                    dt.Rows.Add(filesPath.ToList().IndexOf(path) + 30000, parentId, "Secondary", 1, resizedImage);

                }

            }

        }

        public static Image resizeImage(Image imgToResize, Size size)

        {

            return (Image)(new Bitmap(imgToResize, size));

        }

        private void btnAddSymbol_Click(object sender, EventArgs e)

        {

            if (currentEquipmentNoPocketInfo == null)

            {

                currentEquipmentNoPocketInfo = new EquipmentNoPocketInfo();

            }

            DataTable dt = gridEquipment.DataSource as DataTable;

            dt.Rows.Add(dt.Rows.Count + 1, null, null, null);

            gridViewEquipment.Columns["Index"].BestFit();

        }

        private void btnAddAirSymbol_Click(object sender, EventArgs e)

        {

            if (currentEquipmentAirFinCoolerInfo == null)

            {

                currentEquipmentAirFinCoolerInfo = new EquipmentAirFinCoolerInfo();

            }

            DataTable dt = gridControlAirFinCooler.DataSource as DataTable;

            dt.Rows.Add(dt.Rows.Count + 1, null, null, null, null, null);

            gridViewAirFinCooler.Columns["Index"].BestFit();

        }

        public void ReNumbering(EquipmentNoPocketInfo equipmentNoPocketInfo)

        {

            DataTable dt = gridEquipment.DataSource as DataTable;

            equipmentNoPocketInfo.EquipmentNoPocketItem.Clear();

            for (int i = 0; i < dt.Rows.Count; i++)

            {

                DataRow row = dt.Rows[i];

                row["Index"] = i + 1;

                equipmentNoPocketInfo.EquipmentNoPocketItem.Add(new EquipmentNoPocketItem()

                {

                    Index = i + 1,

                    Type = row["Type"].ToString(),

                    Name = row["SppidSymbolName"].ToString()

                });

            }

        }

        public void ReNumberingAir(EquipmentAirFinCoolerInfo equipmentAirFinCoolerInfo)

        {

            DataTable dt = gridControlAirFinCooler.DataSource as DataTable;

            equipmentAirFinCoolerInfo.EquipmentAirFinCoolerItem.Clear();

            for (int i = 0; i < dt.Rows.Count; i++)

            {

                DataRow row = dt.Rows[i];

                row["Index"] = i + 1;

                equipmentAirFinCoolerInfo.EquipmentAirFinCoolerItem.Add(new EquipmentAirFinCoolerItem()

                {

                    Index = i + 1,

                    Type = row["Type"].ToString(),

                    TagIdentifier = row["TagIdentifier"].ToString(),

                    AttributeName = row["AttributeName"].ToString(),

                    Name = row["SppidSymbolName"].ToString()

                });

            }

        }

        private void TreeList_BeforeCheckNode(object sender, DevExpress.XtraEditors.Controls.ChangingEventArgs e)

        {

            DevExpress.XtraEditors.TreeListLookUpEdit treeListLookUpEdit = sender as DevExpress.XtraEditors.TreeListLookUpEdit;

            if (treeListLookUpEdit.Properties.TreeList.FocusedNode == null)

                return;

            if (treeListLookUpEdit.Properties.TreeList.FocusedNode.Level == 0)

                e.Cancel = true;

        }

        private void btnSave_Click(object sender, EventArgs e)

        {

            if (currentEquipmentNoPocketInfo == null)

            {

                currentEquipmentNoPocketInfo = new EquipmentNoPocketInfo();

            }

            if (currentEquipmentAirFinCoolerInfo == null)

            {

                currentEquipmentAirFinCoolerInfo = new EquipmentAirFinCoolerInfo();

            }

            ReNumbering(currentEquipmentNoPocketInfo);

            ReNumberingAir(currentEquipmentAirFinCoolerInfo);

            if (currentEquipmentNoPocketInfo.EquipmentNoPocketItem.Find(x => x.Type == string.Empty || x.Name == string.Empty) != null)

            {

                MessageBox.Show("Please save after entering data.", "ID2 " + ID2Info.ProgramName, MessageBoxButtons.OK, MessageBoxIcon.Warning);

                return;

            }

            if (currentEquipmentAirFinCoolerInfo.EquipmentAirFinCoolerItem.Find(x => x.TagIdentifier == string.Empty || x.AttributeName == string.Empty || x.Name == string.Empty) != null)

            {

                IEnumerable<EquipmentAirFinCoolerItem> lstafc = currentEquipmentAirFinCoolerInfo.EquipmentAirFinCoolerItem.Where(x => x.TagIdentifier == string.Empty || x.AttributeName == string.Empty || x.Name == string.Empty);

                //Scope Break

                foreach (EquipmentAirFinCoolerItem vg in lstafc)

                {

                    if(vg.Type == string.Empty || vg.Name == string.Empty)

                    {

                        MessageBox.Show("Please save after entering data.", "ID2 " + ID2Info.ProgramName, MessageBoxButtons.OK, MessageBoxIcon.Warning);

                        return;

                    }

                }

            }

            if (DB.SaveEquipmentNopocketSetting(currentEquipmentNoPocketInfo.EquipmentNoPocketItem) &&

                DB.SaveAirFinCoolerSetting(currentEquipmentAirFinCoolerInfo.EquipmentAirFinCoolerItem))

                MessageBox.Show("Save was successful", "ID2 " + ID2Info.ProgramName, MessageBoxButtons.OK, MessageBoxIcon.Information);

            else

                MessageBox.Show("Failed to save", "ID2 " + ID2Info.ProgramName, MessageBoxButtons.OK, MessageBoxIcon.Warning);

        }

        private void btnClose_Click(object sender, EventArgs e)

        {

            DialogResult = DialogResult.Cancel;

        }

    }

}