HYTOS

                        var query = $"CREATE TABLE {PSN_TRANSFORMKEYWORD_SETTING} (GROUP_ID TEXT, DESCRIPTION TEXT, [INDEX] INTEGER, [NAME] TEXT, [KEYWORD] TEXT)";

                    var query = $@"SELECT GROUP_ID, DESCRIPTION, [INDEX], [NAME], [KEYWORD] FROM {PSN_TRANSFORMKEYWORD_SETTING};";

                                query = $"INSERT INTO {PSN_TRANSFORMKEYWORD_SETTING} VALUES (@GROUP_ID, @DESCRIPTION, @INDEX, @NAME, @KEYWORD)";

                                AddWithValue(cmd, "@GROUP_ID", keywordInfo.UID);

                                AddWithValue(cmd, "@DESCRIPTION", keywordInfo.Description);

            #region KeywordSetting

            List<KeywordInfo> KeywordInfos = new List<KeywordInfo>();

            DataTable dtKeyword = DB.SelectKeywordsSetting();

            foreach (DataRow row in dtKeyword.Rows)

            {

                string groupID = row["GROUP_ID"].ToString();

                string desc = row["DESCRIPTION"].ToString();

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

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

                string keyword = row["KEYWORD"].ToString();

                KeywordInfo keywordInfo = KeywordInfos.Find(x => x.UID.Equals(groupID));

                if (keywordInfo == null)

                {

                    keywordInfo = new KeywordInfo(groupID);

                    keywordInfo.Description = desc;

                    KeywordInfos.Add(keywordInfo);

                }

                keywordInfo.KeywordItems.Add(new KeywordItem()

                {

                    Index = index,

                    Name = name,

                    Keyword = keyword

                });

            }

            foreach (KeywordInfo keywordInfo in KeywordInfos)

                keywordInfo.KeywordItems = keywordInfo.KeywordItems.OrderBy(x => x.Index).ToList();

            foreach (Group group in Groups)

            {

                List<KeywordInfo> endInfos = new List<KeywordInfo>();

                bool bFind = false;

                for (int i = 0; i < group.Items.Count; i++)

                {

                    Item item = group.Items[i];

                    foreach (KeywordInfo keyword in KeywordInfos)

                    {

                        if (endInfos.Contains(keyword))

                            continue;

                        if (!keyword.KeywordItems[i].Name.Equals(item.Name))

                        {

                            endInfos.Add(keyword);

                            continue;

                        }

                        if (keyword.KeywordItems.Count.Equals(i + 1))

                        {

                            for (int j = 0; j < i + 1; j++)

                                group.Items[j].Keyword = keyword.KeywordItems[i].Keyword;

                            bFind = true;

                            break;

                        }

                    }

                    if (bFind || endInfos.Count.Equals(KeywordInfos.Count))

                        break;

                }

                endInfos = new List<KeywordInfo>();

                bFind = false;

                for (int i = 0; i < group.Items.Count; i++)

                {

                    Item item = group.Items[group.Items.Count - i - 1];

                    foreach (KeywordInfo keyword in KeywordInfos)

                    {

                        if (endInfos.Contains(keyword))

                            continue;

                        if (!keyword.KeywordItems[i].Name.Equals(item.Name))

                        {

                            endInfos.Add(keyword);

                            continue;

                        }

                        if (keyword.KeywordItems.Count.Equals(i + 1))

                        {

                            for (int j = 0; j < i + 1; j++)

                                group.Items[group.Items.Count - j - 1].Keyword = keyword.KeywordItems[i].Keyword; 

                            bFind = true;

                            break;

                        }

                    }

                    if (bFind || endInfos.Count.Equals(KeywordInfos.Count))

                        break;

                }

            }

            #endregion

            this.ribbonControl.Size = new System.Drawing.Size(411, 32);

            this.layoutControl1.Location = new System.Drawing.Point(0, 32);

            this.layoutControl1.Size = new System.Drawing.Size(411, 497);

            this.btnClose.Location = new System.Drawing.Point(329, 449);

            this.btnSave.Location = new System.Drawing.Point(237, 449);

            this.gridControlRule.Size = new System.Drawing.Size(387, 433);

            this.Root.Size = new System.Drawing.Size(411, 497);

            this.layoutControlItem1.Size = new System.Drawing.Size(391, 437);

            this.layoutControlItem2.Location = new System.Drawing.Point(225, 437);

            this.layoutControlItem3.Location = new System.Drawing.Point(317, 437);

            this.emptySpaceItem1.Location = new System.Drawing.Point(297, 437);

            this.emptySpaceItem2.Location = new System.Drawing.Point(0, 437);

            this.btnAddType = new DevExpress.XtraEditors.SimpleButton();

            this.gridControlType = new DevExpress.XtraGrid.GridControl();

            this.gridViewType = new DevExpress.XtraGrid.Views.Grid.GridView();

            this.layoutControlGroup1 = new DevExpress.XtraLayout.LayoutControlGroup();

            this.layoutControlItem2 = new DevExpress.XtraLayout.LayoutControlItem();

            this.layoutControlItem1 = new DevExpress.XtraLayout.LayoutControlItem();

            this.emptySpaceItem4 = new DevExpress.XtraLayout.EmptySpaceItem();

            ((System.ComponentModel.ISupportInitialize)(this.gridControlType)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.gridViewType)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup1)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem2)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem1)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem4)).BeginInit();

            this.ribbonControl.Size = new System.Drawing.Size(920, 32);

            this.layoutControl1.Controls.Add(this.btnAddType);

            this.layoutControl1.Controls.Add(this.gridControlType);

            this.layoutControl1.Location = new System.Drawing.Point(0, 32);

            this.layoutControl1.Size = new System.Drawing.Size(920, 631);

            this.labelControlToolTip.Location = new System.Drawing.Point(838, 12);

            // btnAddType

            // 

            this.btnAddType.Location = new System.Drawing.Point(360, 63);

            this.btnAddType.Name = "btnAddType";

            this.btnAddType.Size = new System.Drawing.Size(79, 22);

            this.btnAddType.StyleController = this.layoutControl1;

            this.btnAddType.TabIndex = 0;

            this.btnAddType.Text = "Add Type";

            this.btnAddType.Click += new System.EventHandler(this.btnAddType_Click);

            // 

            this.gridControlKeyword.Location = new System.Drawing.Point(479, 89);

            this.gridControlKeyword.Size = new System.Drawing.Size(417, 478);

            // gridControlType

            // 

            this.gridControlType.Location = new System.Drawing.Point(24, 89);

            this.gridControlType.MainView = this.gridViewType;

            this.gridControlType.MenuManager = this.ribbonControl;

            this.gridControlType.Name = "gridControlType";

            this.gridControlType.Size = new System.Drawing.Size(415, 478);

            this.gridControlType.TabIndex = 3;

            this.gridControlType.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {

            this.gridViewType});

            // 

            // gridViewType

            // 

            this.gridViewType.GridControl = this.gridControlType;

            this.gridViewType.Name = "gridViewType";

            this.gridViewType.OptionsView.ShowGroupPanel = false;

            this.gridViewType.CellValueChanged += new DevExpress.XtraGrid.Views.Base.CellValueChangedEventHandler(this.gridViewType_CellValueChanged);

            this.gridViewType.BeforeLeaveRow += new DevExpress.XtraGrid.Views.Base.RowAllowEventHandler(this.gridViewType_BeforeLeaveRow);

            // 

            this.btnClose.Location = new System.Drawing.Point(838, 583);

            this.btnSave.Location = new System.Drawing.Point(746, 583);

            this.btnAddSymbol.Location = new System.Drawing.Point(805, 63);

            this.btnAddSymbol.Size = new System.Drawing.Size(91, 22);

            this.layoutControlGroup1,

            this.Root.Size = new System.Drawing.Size(920, 631);

            this.splitterItem1.Location = new System.Drawing.Point(443, 20);

            this.splitterItem1.Size = new System.Drawing.Size(12, 551);

            this.emptySpaceItem3.Location = new System.Drawing.Point(0, 571);

            this.emptySpaceItem3.Size = new System.Drawing.Size(734, 40);

            this.layoutControlItem4.Location = new System.Drawing.Point(734, 571);

            this.layoutControlItem5.Location = new System.Drawing.Point(826, 571);

            this.emptySpaceItem2.Location = new System.Drawing.Point(806, 571);

            // layoutControlGroup1

            // 

            this.layoutControlGroup1.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {

            this.layoutControlItem2,

            this.layoutControlItem1,

            this.emptySpaceItem4});

            this.layoutControlGroup1.Location = new System.Drawing.Point(0, 20);

            this.layoutControlGroup1.Name = "layoutControlGroup1";

            this.layoutControlGroup1.Size = new System.Drawing.Size(443, 551);

            this.layoutControlGroup1.Text = "Keyword Type";

            // 

            // layoutControlItem2

            // 

            this.layoutControlItem2.Control = this.gridControlType;

            this.layoutControlItem2.Location = new System.Drawing.Point(0, 26);

            this.layoutControlItem2.Name = "layoutControlItem2";

            this.layoutControlItem2.Size = new System.Drawing.Size(419, 482);

            this.layoutControlItem2.TextSize = new System.Drawing.Size(0, 0);

            this.layoutControlItem2.TextVisible = false;

            // 

            // layoutControlItem1

            // 

            this.layoutControlItem1.Control = this.btnAddType;

            this.layoutControlItem1.Location = new System.Drawing.Point(336, 0);

            this.layoutControlItem1.Name = "layoutControlItem1";

            this.layoutControlItem1.Size = new System.Drawing.Size(83, 26);

            this.layoutControlItem1.TextSize = new System.Drawing.Size(0, 0);

            this.layoutControlItem1.TextVisible = false;

            // 

            // emptySpaceItem4

            // 

            this.emptySpaceItem4.AllowHotTrack = false;

            this.emptySpaceItem4.Location = new System.Drawing.Point(0, 0);

            this.emptySpaceItem4.Name = "emptySpaceItem4";

            this.emptySpaceItem4.Size = new System.Drawing.Size(336, 26);

            this.emptySpaceItem4.TextSize = new System.Drawing.Size(0, 0);

            // 

            this.layoutControlGroup2.Location = new System.Drawing.Point(455, 20);

            this.layoutControlGroup2.Size = new System.Drawing.Size(445, 551);

            this.layoutControlGroup2.Text = "Type Items";

            this.layoutControlItem6.Size = new System.Drawing.Size(421, 482);

            this.layoutControlItem3.Location = new System.Drawing.Point(326, 0);

            this.layoutControlItem3.Size = new System.Drawing.Size(95, 26);

            this.emptySpaceItem1.Size = new System.Drawing.Size(326, 26);

            this.layoutControlItem7.Location = new System.Drawing.Point(826, 0);

            this.emptySpaceItem5.Size = new System.Drawing.Size(826, 20);

            this.ClientSize = new System.Drawing.Size(920, 663);

            ((System.ComponentModel.ISupportInitialize)(this.gridControlType)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.gridViewType)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup1)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem2)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem1)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem4)).EndInit();

        private DevExpress.XtraGrid.GridControl gridControlType;

        private DevExpress.XtraGrid.Views.Grid.GridView gridViewType;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem2;

        private DevExpress.XtraEditors.SimpleButton btnAddType;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem1;

        private DevExpress.XtraLayout.EmptySpaceItem emptySpaceItem4;

        private DevExpress.XtraLayout.LayoutControlGroup layoutControlGroup1;

            InitGridType();

            gridViewType.FocusedRowChanged += new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventHandler(gridViewType_FocusedRowChanged);

            InitData();

        public void InitGridType()

        {

            RepositoryItemButtonEdit btnRemove = new RepositoryItemButtonEdit();

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

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

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

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

            //btnShow.Buttons[0].ImageOptions.Image = ((Image)Properties.Resources.ResourceManager.GetObject("ReviewImage", System.Globalization.CultureInfo.CurrentCulture));

            DataTable dtType = new DataTable();

            dtType.Columns.Add("UID");

            dtType.Columns.Add("Description");

            dtType.Columns.Add(" ");

            gridControlType.DataSource = dtType;

            GridColumn gridColumn = gridViewType.Columns[0];

            gridColumn.Name = "UID";

            gridColumn.Caption = "UID";

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

            gridColumn.VisibleIndex = -1;

            gridColumn = gridViewType.Columns[1];

            gridColumn.Name = "Description";

            gridColumn.Caption = "Description";

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

            gridColumn.VisibleIndex = 0;

            gridColumn = gridViewType.Columns[2];

            gridColumn.Name = "Remove";

            gridColumn.Caption = "";

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

            gridColumn.VisibleIndex = 1;

            gridColumn.MaxWidth = 16;

            gridControlType.RepositoryItems.Add(btnRemove);

            gridColumn.ColumnEdit = btnRemove;

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

        }

                string groupID = row["GROUP_ID"].ToString();

                string desc = row["DESCRIPTION"].ToString();

                KeywordInfo keywordInfo = KeywordInfos.Find(x => x.UID.Equals(groupID));

                if (keywordInfo == null)

                {

                    keywordInfo = new KeywordInfo(groupID);

                    keywordInfo.Description = desc;

                    KeywordInfos.Add(keywordInfo);

                }

                keywordInfo.KeywordItems.Add(new KeywordItem()

                {

                    Index = index,

                    Name = name,

                    Keyword = keyword

                });

            }

            DataTable typeDT = gridControlType.DataSource as DataTable;

            foreach (KeywordInfo keywordInfo in KeywordInfos)

            {

                keywordInfo.KeywordItems = keywordInfo.KeywordItems.OrderBy(x => x.Index).ToList();

                typeDT.Rows.Add(keywordInfo.UID, keywordInfo.Description, null);

            }

        }

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

        {

            string value = gridViewType.GetFocusedRowCellValue("UID").ToString();

            DataTable dt = gridControlType.DataSource as DataTable;

            DataRow[] rows = dt.Select(string.Format("UID = '{0}'", value));

            if (rows.Length.Equals(1))

                dt.Rows.Remove(rows.First());

            KeywordInfos.Remove(KeywordInfos.Find(x => x.UID.Equals(value)));

            int handle = gridViewType.FocusedRowHandle;

            if (handle >= 0)

            {

                KeywordInfo keywordInfo = KeywordInfos.Find(x => x.UID == gridViewType.GetRowCellDisplayText(handle, "UID"));

                if (keywordInfo != null)

                {

                    currentKeywordInfo = keywordInfo;

                    LoadGridSymbol(keywordInfo);

                }

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

        private void btnAddType_Click(object sender, EventArgs e)

        {

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

            KeywordInfos.Add(new KeywordInfo(uid));

            DataTable dt = gridControlType.DataSource as DataTable;

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

            gridViewType.FocusedRowHandle = dt.Rows.Count - 1;

        }

        private void gridViewType_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)

        {

            int handle = gridViewType.FocusedRowHandle;

            if (handle >= 0)

            {

                KeywordInfo keywordInfo = KeywordInfos.Find(x => x.UID == gridViewType.GetRowCellDisplayText(handle, "UID"));

                if (keywordInfo != null)

                {

                    currentKeywordInfo = keywordInfo;

                    LoadGridSymbol(keywordInfo);

                }

            }

        }

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

        {

            if (e.RowHandle >= 0)

            {

                string uid = gridViewType.GetRowCellDisplayText(e.RowHandle, "UID");

                KeywordInfos.Find(x => x.UID.Equals(uid)).Description = e.Value == null ? string.Empty : e.Value.ToString();

            }

        }

        private string _UID;

        public string UID { get { return _UID; } }

        public string Description { get; set; }

        public List<KeywordItem> KeywordItems { get { return _KeywordItems; } set { _KeywordItems = value; } }

        public KeywordInfo(string UID)

        {

            _UID = UID;

            Description = string.Empty;

        }

                    string groupID = row["GROUP_ID"].ToString();

                    string desc = row["DESCRIPTION"].ToString();

                    KeywordInfo keywordInfo = KeywordInfos.Find(x => x.UID.Equals(groupID));

                    if (keywordInfo == null)

                    {

                        keywordInfo = new KeywordInfo(groupID);

                        keywordInfo.Description = desc;

                        KeywordInfos.Add(keywordInfo);

                    }

                        networkStream.Write(message, 0, message.Length);

                        byte[] outbuf = new byte[1024];

                        int nbytes = networkStream.Read(outbuf, 0, outbuf.Length);

                        string output = Encoding.UTF8.GetString(outbuf, 4, nbytes - 5);

                        var result = JsonConvert.DeserializeObject<Dictionary<string, string>>(output);

                        if (result["db_type"] == "SQLite")

                        {

                            info.ID2DBType = ID2DB_Type.SQLite;

                            var parent = Directory.GetParent(Path.GetDirectoryName(result["db_name"]));

                            info.DefaultPath = parent.ToString();

                            ///DataRow dr = projectTable.Select(string.Format("DBTypes_UID = 2 AND Name = '{0}'", result["db_name"])).FirstOrDefault();

                            ///info.DefaultPath = dr.Field<string>("Path");

                        else if (result["db_type"] == "MSSQL")

                            info.ID2DBType = ID2DB_Type.MSSQL;

                            info.ServerIP = result["host"];

                            //info.Port = "3389"; 

                            info.DBUser = result["user"];

                            info.DBPassword = result["password"];

                            info.Database = result["db_name"];

                            info.DefaultPath = result["path"];

                            ///DataRow dr = projectTable.Select(string.Format("DBTypes_UID = 2 AND Name = '{0}'", result["db_name"])).FirstOrDefault();

                            ///info.DefaultPath = dr.Field<string>("Path");

                            ///

                        MessageBox.Show(info.ID2DBType + "\n" + info.ServerIP + "\n" + info.DBUser + "\n" + info.DBPassword + "\n" + info.Database + "\n" + info.DefaultPath, "ID2PSN", MessageBoxButtons.OK, MessageBoxIcon.Error);

                MessageBox.Show("Failed to open ID2 drawing.", "ID2PSN", MessageBoxButtons.OK, MessageBoxIcon.Error);