HYTOS

                    dicColCheck.Add("Pocket", "NVARCHAR(10)");

                    dicColCheck.Add("EGTag", "NVARCHAR(255)");

                    dicColCheck.Add("HasMLTags", "NVARCHAR(50)");

                    if (matched == null)

                    {

                        var query = $"CREATE TABLE {PSN_PIPESYSTEMNETWORK} (OID NVARCHAR(255), Type NVARCHAR(255), OrderNumber NVARCHAR(255), Pipeline_OID NVARCHAR(255), From_Data NVARCHAR(255), " +

                            "To_Data NVARCHAR(255), TopologySet_OID_Key NVARCHAR(125), PSNRevisionNumber NVARCHAR(255), IsValid INTEGER, Status NVARCHAR(255), PBS NVARCHAR(255), Drawings NVARCHAR(255), " +

                        using (var cmd = connection.GetSqlStringCommand(query))

                        {

                            cmd.ExecuteNonQuery();

                            foreach (DataRow row in item.PipeSystemNetwork.Rows)

                            {

                                query = $"INSERT INTO {PSN_PIPESYSTEMNETWORK} " +

                                var cmd = connection.GetSqlStringCommand(query);

                                AddWithValue(cmd, "@OID", string.IsNullOrEmpty(row["OID"].ToString()) ? "" : row["OID"].ToString());

                                AddWithValue(cmd, "@Type", string.IsNullOrEmpty(row["Type"].ToString()) ? "" : row["Type"].ToString());

                                AddWithValue(cmd, "@EGTag", string.IsNullOrEmpty(row["EGTag"].ToString()) ? "" : row["EGTag"].ToString());

                                AddWithValue(cmd, "@HasMLTags", string.IsNullOrEmpty(row["HasMLTags"].ToString()) ? "False" : row["HasMLTags"].ToString());

                                connection.ExecuteNonQuery(cmd, txn);

                            }

                            newRow["EGTag"] = row["EGTag"].ToString();

                            newRow["HasMLTags"] = row["HasMLTags"].ToString();

                            result.PipeSystemNetwork.Rows.Add(newRow);

                        }

                    }

                            newRow["Pocket"] = row["Pocket"].ToString();

                            newRow["EGTag"] = row["EGTag"].ToString();

                            newRow["HasMLTags"] = row["HasMLTags"].ToString();

                            dt.Rows.Add(newRow);

                        }

                    }

                    dicColCheck.Add("Pocket", "NVARCHAR(10)");

                    dicColCheck.Add("EGTag", "NVARCHAR(255)");

                    dicColCheck.Add("HasMLTags", "NVARCHAR(50)");

                    if (matched == null)

                    {

                        var query = $"CREATE TABLE {PSN_PIPESYSTEMNETWORK} (OID NVARCHAR(255), Type NVARCHAR(255), OrderNumber NVARCHAR(255), Pipeline_OID NVARCHAR(255), From_Data NVARCHAR(255), " +

                            "To_Data NVARCHAR(255), TopologySet_OID_Key NVARCHAR(125), PSNRevisionNumber NVARCHAR(255), IsValid INTEGER, Status NVARCHAR(255), PBS NVARCHAR(255), Drawings NVARCHAR(255), " +

                        using (var cmd = connection.GetSqlStringCommand(query))

                        {

                            cmd.ExecuteNonQuery();

                            foreach (DataRow row in item.PipeSystemNetwork.Rows)

                            {

                                query = $"INSERT INTO {PSN_PIPESYSTEMNETWORK} " +

                                var cmd = connection.GetSqlStringCommand(query);

                                AddWithValue(cmd, "@OID", string.IsNullOrEmpty(row["OID"].ToString()) ? "" : row["OID"].ToString());

                                AddWithValue(cmd, "@Type", string.IsNullOrEmpty(row["Type"].ToString()) ? "" : row["Type"].ToString());

                                AddWithValue(cmd, "@Pocket", string.IsNullOrEmpty(row["Pocket"].ToString()) ? "Yes" : row["Pocket"].ToString());

                                AddWithValue(cmd, "@EGTag", string.IsNullOrEmpty(row["EGTag"].ToString()) ? "" : row["EGTag"].ToString());

                                AddWithValue(cmd, "@HasMLTags", string.IsNullOrEmpty(row["HasMLTags"].ToString()) ? "False" : row["HasMLTags"].ToString());

                                connection.ExecuteNonQuery(cmd, txn);

                            }

            this.ribbonControl.ShowDisplayOptionsMenuButton = DevExpress.Utils.DefaultBoolean.False;

            this.ribbonControl.ShowPageHeadersMode = DevExpress.XtraBars.Ribbon.ShowPageHeadersMode.ShowOnMultiplePages;

            this.ribbonControl.ShowToolbarCustomizeItem = false;

            this.ribbonControl.Toolbar.ShowCustomizeItem = false;

            // 

            // layoutControl1

            this.layoutControl1.Name = "layoutControl1";

            this.layoutControl1.OptionsCustomizationForm.DesignTimeCustomizationFormPositionAndSize = new System.Drawing.Rectangle(963, 307, 650, 400);

            this.layoutControl1.Root = this.Root;

            this.layoutControl1.TabIndex = 1;

            this.layoutControl1.Text = "layoutControl1";

            // 

            // 

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

            this.lbDrawingList.Name = "lbDrawingList";

            this.lbDrawingList.StyleController = this.layoutControl1;

            this.lbDrawingList.TabIndex = 7;

            this.lbDrawingList.MouseDoubleClick += new System.Windows.Forms.MouseEventHandler(this.lbDrawingList_MouseDoubleClick);

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

            this.layoutControlItem1});

            this.Root.Name = "Root";

            this.Root.TextVisible = false;

            // 

            // layoutControlItem1

            this.layoutControlItem1.Control = this.lbDrawingList;

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

            this.layoutControlItem1.Name = "layoutControlItem1";

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

            this.layoutControlItem1.TextVisible = false;

            // 

            // 

            this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 14F);

            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

            this.Controls.Add(this.layoutControl1);

            this.Controls.Add(this.ribbonControl);

            this.Name = "DrawingList";

            this.ribbonControl.ShowDisplayOptionsMenuButton = DevExpress.Utils.DefaultBoolean.False;

            this.ribbonControl.ShowPageHeadersMode = DevExpress.XtraBars.Ribbon.ShowPageHeadersMode.ShowOnMultiplePages;

            this.ribbonControl.ShowToolbarCustomizeItem = false;

            this.ribbonControl.Toolbar.ShowCustomizeItem = false;

            // 

            // layoutControl1

            this.layoutControl1.Name = "layoutControl1";

            this.layoutControl1.OptionsCustomizationForm.DesignTimeCustomizationFormPositionAndSize = new System.Drawing.Rectangle(488, 408, 650, 400);

            this.layoutControl1.Root = this.Root;

            this.layoutControl1.TabIndex = 1;

            this.layoutControl1.Text = "layoutControl1";

            // 

            this.gridEquipment.MainView = this.gridViewEquipment;

            this.gridEquipment.MenuManager = this.ribbonControl;

            this.gridEquipment.Name = "gridEquipment";

            this.gridEquipment.TabIndex = 4;

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

            this.gridViewEquipment});

            // btnClose

            // 

            this.btnClose.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("btnClose.ImageOptions.Image")));

            this.btnClose.Name = "btnClose";

            this.btnClose.Size = new System.Drawing.Size(70, 36);

            this.btnClose.StyleController = this.layoutControl1;

            // btnSave

            // 

            this.btnSave.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("btnSave.ImageOptions.Image")));

            this.btnSave.Name = "btnSave";

            this.btnSave.Size = new System.Drawing.Size(68, 36);

            this.btnSave.StyleController = this.layoutControl1;

            // 

            // btnAddValveGroup

            // 

            this.btnAddValveGroup.Name = "btnAddValveGroup";

            this.btnAddValveGroup.StyleController = this.layoutControl1;

            this.btnAddValveGroup.TabIndex = 2;

            this.btnAddValveGroup.Text = " Add Equipment";

            this.emptySpaceItem2,

            this.layoutControlGroup2});

            this.Root.Name = "Root";

            this.Root.TextVisible = false;

            // 

            // emptySpaceItem3

            // 

            this.emptySpaceItem3.AllowHotTrack = false;

            this.emptySpaceItem3.Name = "emptySpaceItem3";

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

            // 

            // layoutControlItem4

            // 

            this.layoutControlItem4.Control = this.btnSave;

            this.layoutControlItem4.MaxSize = new System.Drawing.Size(72, 40);

            this.layoutControlItem4.MinSize = new System.Drawing.Size(72, 40);

            this.layoutControlItem4.Name = "layoutControlItem4";

            // layoutControlItem5

            // 

            this.layoutControlItem5.Control = this.btnClose;

            this.layoutControlItem5.MaxSize = new System.Drawing.Size(74, 40);

            this.layoutControlItem5.MinSize = new System.Drawing.Size(74, 40);

            this.layoutControlItem5.Name = "layoutControlItem5";

            // emptySpaceItem2

            // 

            this.emptySpaceItem2.AllowHotTrack = false;

            this.emptySpaceItem2.MaxSize = new System.Drawing.Size(20, 40);

            this.emptySpaceItem2.MinSize = new System.Drawing.Size(20, 40);

            this.emptySpaceItem2.Name = "emptySpaceItem2";

            this.emptySpaceItem1});

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

            this.layoutControlGroup2.Name = "layoutControlGroup2";

            this.layoutControlGroup2.Text = "Equipment No Pocket Items";

            // 

            // layoutControlItem6

            this.layoutControlItem6.Control = this.gridEquipment;

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

            this.layoutControlItem6.Name = "layoutControlItem6";

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

            this.layoutControlItem6.TextVisible = false;

            // 

            // layoutControlItem3

            // 

            this.layoutControlItem3.Control = this.btnAddValveGroup;

            this.layoutControlItem3.Name = "layoutControlItem3";

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

            this.layoutControlItem3.TextVisible = false;

            // 

            this.emptySpaceItem1.AllowHotTrack = false;

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

            this.emptySpaceItem1.Name = "emptySpaceItem1";

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

            // 

            // EquipmentNoPocketSetting

            // 

            this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 14F);

            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

            this.Controls.Add(this.layoutControl1);

            this.Controls.Add(this.ribbonControl);

            this.Name = "EquipmentNoPocketSetting";

                            || Convert.ToDouble(selectRow["PSNAccuracy"].ToString().Replace("%", "")) != Convert.ToDouble(row["PSNAccuracy"].ToString().Replace("%", ""))

                            || selectRow["Pocket"].ToString() != row["Pocket"].ToString()

                            || selectRow["EGTag"].ToString() != row["EGTag"].ToString()

                        {

                            bCheck = true;

                        }

            PSNPageDT.Columns.Add("EGTag", typeof(string));

            PSNPageDT.Columns.Add("HasMLTags", typeof(string));

            PSNPageDT.Columns.Add("Pocket", typeof(string));

            PSNPageDT.Columns.Add("IsValid", typeof(string));

            PSNPageDT.Columns.Add("Status", typeof(string));

            PSNPageDT.Columns.Add("IncludingVirtualData", typeof(string));

            PSNPageDT.Columns.Add("PSNAccuracy", typeof(string));

            PSNPageDT.Columns.Add("Show", typeof(string));

            gridViewPSN.Columns["FROM_DATA"].Caption = "From";

            gridViewPSN.Columns["TO_DATA"].Caption = "To";

            gridViewPSN.Columns["TopologySet_OID_Key"].Caption = "SeqData ID";

            repositoryGroupType2 = new RepositoryItemComboBox();

            repositoryGroupType2.Items.AddRange(new string[] { "Yes", "No" });

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

                newRow["Pocket"] = row["Pocket"].ToString();

                newRow["EGTag"] = row["EGTag"].ToString();

                newRow["HasMLTags"] = row["HasMLTags"].ToString();

                //if(row.Table.Columns["AFC"] != null)

                //    newRow["AFC"] = row["AFC"].ToString();

                PSNPageDT.Rows.Add(newRow);

            }

            this.ribbonControl.ShowDisplayOptionsMenuButton = DevExpress.Utils.DefaultBoolean.False;

            this.ribbonControl.ShowPageHeadersMode = DevExpress.XtraBars.Ribbon.ShowPageHeadersMode.ShowOnMultiplePages;

            this.ribbonControl.ShowToolbarCustomizeItem = false;

            this.ribbonControl.Toolbar.ShowCustomizeItem = false;

            // 

            // layoutControl1

            this.layoutControl1.OptionsCustomizationForm.DesignTimeCustomizationFormPositionAndSize = new System.Drawing.Rectangle(642, 278, 650, 400);

            this.layoutControl1.OptionsView.UseDefaultDragAndDropRendering = false;

            this.layoutControl1.Root = this.Root;

            this.layoutControl1.TabIndex = 1;

            this.layoutControl1.Text = "layoutControl1";

            // 

            this.gridControlRule.MainView = this.gridViewRule;

            this.gridControlRule.MenuManager = this.ribbonControl;

            this.gridControlRule.Name = "gridControlRule";

            this.gridControlRule.TabIndex = 2;

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

            this.gridViewRule});

            // btnClose

            // 

            this.btnClose.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("btnClose.ImageOptions.Image")));

            this.btnClose.Name = "btnClose";

            this.btnClose.Size = new System.Drawing.Size(70, 36);

            this.btnClose.StyleController = this.layoutControl1;

            // btnSave

            // 

            this.btnSave.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("btnSave.ImageOptions.Image")));

            this.btnSave.Name = "btnSave";

            this.btnSave.Size = new System.Drawing.Size(68, 36);

            this.btnSave.StyleController = this.layoutControl1;

            // Upbtn

            // 

            this.Upbtn.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("Upbtn.ImageOptions.Image")));

            this.Upbtn.Name = "Upbtn";

            this.Upbtn.Size = new System.Drawing.Size(24, 22);

            this.Upbtn.StyleController = this.layoutControl1;

            // DownBtn

            // 

            this.DownBtn.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("DownBtn.ImageOptions.Image")));

            this.DownBtn.Name = "DownBtn";

            this.DownBtn.StyleController = this.layoutControl1;

            this.DownBtn.TabIndex = 6;

            this.DownBtn.Click += new System.EventHandler(this.DownBtn_Click);

            // DelBtn

            // 

            this.DelBtn.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("DelBtn.ImageOptions.Image")));

            this.DelBtn.Name = "DelBtn";

            this.DelBtn.StyleController = this.layoutControl1;

            this.DelBtn.TabIndex = 7;

            this.DelBtn.Click += new System.EventHandler(this.DelBtn_Click);

            this.emptySpaceItem5,

            this.layoutControlItem6});

            this.Root.Name = "Root";

            this.Root.TextVisible = false;

            // 

            // layoutControlItem1

            this.layoutControlItem1.Control = this.gridControlRule;

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

            this.layoutControlItem1.Name = "layoutControlItem1";

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

            this.layoutControlItem1.TextVisible = false;

            // 

            // layoutControlItem2

            // 

            this.layoutControlItem2.Control = this.btnSave;

            this.layoutControlItem2.MaxSize = new System.Drawing.Size(72, 40);

            this.layoutControlItem2.MinSize = new System.Drawing.Size(72, 40);

            this.layoutControlItem2.Name = "layoutControlItem2";

            // layoutControlItem3

            // 

            this.layoutControlItem3.Control = this.btnClose;

            this.layoutControlItem3.MaxSize = new System.Drawing.Size(74, 40);

            this.layoutControlItem3.MinSize = new System.Drawing.Size(74, 40);

            this.layoutControlItem3.Name = "layoutControlItem3";

            // emptySpaceItem1

            // 

            this.emptySpaceItem1.AllowHotTrack = false;

            this.emptySpaceItem1.MaxSize = new System.Drawing.Size(20, 40);

            this.emptySpaceItem1.MinSize = new System.Drawing.Size(20, 40);

            this.emptySpaceItem1.Name = "emptySpaceItem1";

            // emptySpaceItem2

            // 

            this.emptySpaceItem2.AllowHotTrack = false;

            this.emptySpaceItem2.Name = "emptySpaceItem2";

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

            // 

            // emptySpaceItem3

            this.emptySpaceItem3.AllowHotTrack = false;

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

            this.emptySpaceItem3.Name = "emptySpaceItem3";

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

            // 

            // layoutControlItem4

            // 

            this.layoutControlItem4.Control = this.Upbtn;

            this.layoutControlItem4.Name = "layoutControlItem4";

            this.layoutControlItem4.Size = new System.Drawing.Size(28, 26);

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

            // layoutControlItem5

            // 

            this.layoutControlItem5.Control = this.DownBtn;

            this.layoutControlItem5.Name = "layoutControlItem5";

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

            this.layoutControlItem5.TextVisible = false;

            // 

            // emptySpaceItem4

            // 

            this.emptySpaceItem4.AllowHotTrack = false;

            this.emptySpaceItem4.Name = "emptySpaceItem4";

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

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

            // emptySpaceItem5

            // 

            this.emptySpaceItem5.AllowHotTrack = false;

            this.emptySpaceItem5.Name = "emptySpaceItem5";

            this.emptySpaceItem5.Size = new System.Drawing.Size(14, 26);

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

            // layoutControlItem6

            // 

            this.layoutControlItem6.Control = this.DelBtn;

            this.layoutControlItem6.Name = "layoutControlItem6";

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

            this.layoutControlItem6.TextVisible = false;

            // 

            // 

            this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 14F);

            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

            this.Controls.Add(this.layoutControl1);

            this.Controls.Add(this.ribbonControl);

            this.Name = "TopologyRuleForm";

                pipeSystemNetworkDT.Columns.Add("Pocket", typeof(string));

                pipeSystemNetworkDT.Columns.Add("EGTag", typeof(string));

                pipeSystemNetworkDT.Columns.Add("HasMLTags", typeof(string));

                pipeSystemNetworkDT.Columns.Add("AFC", typeof(string));

                pipeSystemNetworkDT.Columns.Add("PUMP", typeof(string));

                                    {

                                        LineNumber lineNumber = item.Document.LineNumbers.Find(x => x.UID == item.Owner);

                                        string FluidCode = string.Empty;

                                        if (lineNumber != null)

                                        {

                                            List<Attribute> att = lineNumber.Attributes;

                                                    newPipesystemRow["FLUID"] = FluidCode;

                                                    newPipesystemRow["PMC"] = PMC;

                                                    newPipesystemRow["PipeLineQty"] = string.Empty;

                                                    if (!string.IsNullOrEmpty(FluidCode) && !string.IsNullOrEmpty(PMC))

                                                    {

                                                        FluidCodeGL = PSNFluidDT.Select(string.Format("Code = '{0}'", FluidCode)).FirstOrDefault().Field<string>("GroundLevel");

                                                    newPipesystemRow["GroundLevel"] = GroundLevel;

                                                    pipesystemDT.Rows.Add(newPipesystemRow);

                                                }

                                            }

                                        }

                                        newRow["EGTag"] = string.Empty;

                                        newRow["HasMLTags"] = "False";

                                        pipeSystemNetworkDT.Rows.Add(newRow);

                                    }

                                }