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 DevExpress.XtraEditors.Repository;

using DevExpress.XtraGrid.Columns;

using DevExpress.XtraGrid;

using DevExpress.XtraGrid.Views.Grid;

using DevExpress.Utils.StructuredStorage.Internal.Reader;

using DevExpress.XtraTreeList;

using DevExpress.XtraTreeList.Columns;

using DevExpress.XtraTreeList.Nodes;

using DevExpress.Utils.Extensions;

using DevExpress.Utils;

using DevExpress.Utils.Drawing;

namespace ID2PSN

{

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

    {

        ID2Info ID2Info = ID2Info.GetInstance();

        List<ValveGroupInfo> ValveGroupInfos = new List<ValveGroupInfo>();

        ValveGroupInfo currentValveGroupInfo = null;

        private RepositoryItemComboBox repositoryAttributeItem = new RepositoryItemComboBox();

        private RepositoryItemComboBox repositoryGroupType = new RepositoryItemComboBox();

        private DataTable SymbolList = new DataTable();

        public ValveGroupingSetting()

        {

            InitializeComponent();

            InitGridValveGroupItems();

           // gridViewValveGroup.CellValueChanged += new DevExpress.XtraGrid.Views.Base.CellValueChangedEventHandler(gridViewSymbol_CellValueChanged);

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

            ValveGroupInfos = new List<ValveGroupInfo>();

            currentValveGroupInfo = new ValveGroupInfo();

            InitData();            

        }

        public void InitGridValveGroupItems()

        {

            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;

            gridValveGroup.RepositoryItems.Add(btnRemove);

            DataTable dtType = new DataTable();

          //  dtType.Columns.Add("OID");

            dtType.Columns.Add("GroupType");

            dtType.Columns.Add("TagIdentifier");

            dtType.Columns.Add("AttributeName");

            dtType.Columns.Add("SppidSymbolName");

            dtType.Columns.Add(" ");

            gridValveGroup.DataSource = dtType;

            GridColumn gridColumn = gridViewValveGroup.Columns[0];

            //gridColumn.Name = "OID";

            //gridColumn.Caption = "OID";

            //gridColumn.OptionsColumn.AllowEdit = false;

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

            //gridColumn.Visible = true;

            //gridColumn.VisibleIndex = 0;

            repositoryGroupType = new RepositoryItemComboBox();

            repositoryGroupType.Items.AddRange(new string[] { "Valves (CV, PRV..)", "Traps (ST, DT..)", "Reliefs (PSV..)", "Pumps", "Scope Break" });

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

            //repositoryGroupType.EditValueChanging += RepositoryGroupType_EditValueChanging;

           // repositoryGroupType.SelectedIndexChanged += RepositoryGroupType_SelectedIndexChanged;

            gridValveGroup.RepositoryItems.Add(repositoryGroupType);

            //gridColumn = gridViewValveGroup.Columns[0];

            gridColumn.Name = "GroupType";

            gridColumn.Caption = "Group Type";

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

            gridColumn.VisibleIndex = 0;

            gridViewValveGroup.Columns["GroupType"].ColumnEdit = repositoryGroupType;

            //gridColumn.AppearanceHeader.BackColor = Color.Red;

            gridColumn = gridViewValveGroup.Columns[1];

            gridColumn.Name = "TagIdentifier";

            gridColumn.Caption = "Prefix";

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

            gridColumn.VisibleIndex = 1;

            SymbolList = DB.SelectAllSymbolAttribute();

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

            //repositoryAttributeItem.AppearanceDropDown.Font = Font;

            //repositoryAttributeItem.Items.Add("NoSelection");

            //foreach (DataRow dr in SymbolList.Rows)

            //{

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

            //}

            //repositoryAttributeItem.Items.Add("");

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

            repositoryAttributeItem.AppearanceDropDown.Font = Font;

            gridValveGroup.RepositoryItems.Add(repositoryAttributeItem);

            gridColumn = gridViewValveGroup.Columns[2];

            gridColumn.Name = "AttributeName";

            gridColumn.Caption = "ID2 Attribute Name";

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

            gridColumn.VisibleIndex = 2;

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

            gridColumn = gridViewValveGroup.Columns[3];

            gridColumn.Name = "SppidSymbolName";

            gridColumn.Caption = "ID2 Symbol Name";

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

            gridColumn.VisibleIndex = 3;

            RepositoryItemTreeListLookUpEdit treeListLookUpEdit = new RepositoryItemTreeListLookUpEdit();

            gridValveGroup.RepositoryItems.Add(treeListLookUpEdit);

            SetSymbol(treeListLookUpEdit);

           // gridColumn.ColumnEdit = treeListLookUpEdit;

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

            gridColumn = gridViewValveGroup.Columns[4];

            gridColumn.Name = "Remove";

            gridColumn.Caption = "";

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

            gridColumn.VisibleIndex = 4;

            gridColumn.MaxWidth = 16;

            gridColumn.ColumnEdit = btnRemove;

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

            gridViewValveGroup.CustomRowCellEditForEditing += gridView1_CustomRowCellEditForEditing;

            //gridViewKeyword.CustomDrawColumnHeader += GridViewKeyword_CustomDrawColumnHeader;

        }

        private void gridView1_CustomRowCellEditForEditing(object sender, DevExpress.XtraGrid.Views.Grid.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 = gridValveGroup.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("NoSelection");

                foreach (DataRow dr in SymbolList.Rows)

                {

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

                    {

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

                    }                    

                }

                //repositoryAttributeItem.Items.Add("");

            }

        }

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

            DataTable typeDT = gridValveGroup.DataSource as DataTable;

            foreach (DataRow row in dt.Rows)

            {

                //int index = row["OID"];

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

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

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

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

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

            }

        }

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

        {

            DataTable dt = gridValveGroup.DataSource as DataTable;

            DataRow rows = dt.Rows[gridViewValveGroup.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 (currentValveGroupInfo == null)

            {

                currentValveGroupInfo = new ValveGroupInfo();

            }

            DataTable dt = gridValveGroup.DataSource as DataTable;

            dt.Rows.Add(null, null, null, null, null);

            gridViewValveGroup.Columns["GroupType"].BestFit();

        }

        public void ReNumbering(ValveGroupInfo valveGroupInfo)

        {

            DataTable dt = gridValveGroup.DataSource as DataTable;

            valveGroupInfo.ValveGroupItems.Clear();

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

            {

                DataRow row = dt.Rows[i];

               // row["Index"] = i + 1;

                valveGroupInfo.ValveGroupItems.Add(new ValveGroupItem()

                {

                    OID = Guid.NewGuid().ToString(),

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

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

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

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

                });

            }

        }

        private void gridViewType_BeforeLeaveRow(object sender, DevExpress.XtraGrid.Views.Base.RowAllowEventArgs e)

        {

            ReNumbering(currentValveGroupInfo);

        }

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

        {

            //Valves (CV, PRV..)", "Traps (ST, DT..)", "Reliefs (PSV..)

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

            {

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

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

                {

                    string selectItem = e.Value.ToString();

                    DataTable dt = gridValveGroup.DataSource as DataTable;

                    if (selectItem.Contains("Valves"))

                    {

                        dt.Rows[columnView.FocusedRowHandle]["TagIdentifier"] = "CV";

                    }

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

                    {

                        dt.Rows[columnView.FocusedRowHandle]["TagIdentifier"] = "ST";

                    }

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

                    {

                        dt.Rows[columnView.FocusedRowHandle]["TagIdentifier"] = "PSV";

                    }

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

                    {

                        dt.Rows[columnView.FocusedRowHandle]["TagIdentifier"] = "Pump";

                    }

                }

            }

            //ReNumbering(currentValveGroupInfo);

        }

        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 (currentValveGroupInfo == null)

            {

                currentValveGroupInfo = new ValveGroupInfo();

            }

            ReNumbering(currentValveGroupInfo);

            if(currentValveGroupInfo.ValveGroupItems.Find(x => x.TagIdentifier == string.Empty || x.AttributeName == string.Empty || x.SppidSymbolName == string.Empty) != null)

            {

                IEnumerable<ValveGroupItem> lstvalue = currentValveGroupInfo.ValveGroupItems.Where(x => x.TagIdentifier == string.Empty || x.AttributeName == string.Empty || x.SppidSymbolName == string.Empty);

                //Scope Break

                foreach(ValveGroupItem vg in lstvalue)

                {

                    if(vg.GroupType != "Scope Break")

                    {

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

                        return;

                    }

                    else

                    {

                        if(vg.SppidSymbolName == string.Empty)

                        {

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

                            return;

                        }

                    }

                }

            }

            if (DB.SaveValveGroupItemsSetting(currentValveGroupInfo.ValveGroupItems))

                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;

        }

    }

}