HYTOS

                    matched = names.FirstOrDefault(param => param == PSN_PIPESYSTEMNETWORK);

                    dicColCheck.Clear();

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

                    dicColCheck.Add("TopologySet_OID_Key", "NVARCHAR(125)");

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

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

                    dicColCheck.Add("PSNAccuracy", "REAL");

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

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

            return dt;

        }

        public static DataTable SelectInsulationPurpose()

        {

            DataTable dt = null;

            {

                try

                {

                    var query = "SELECT DISTINCT Attribute FROM SymbolAttribute;";

                    using (var ds = connection.ExecuteDataSet(connection.GetSqlStringCommand(query)))

                    {

            return dt;

        }

        public static DataTable SelectEquipmentNoPocketSetting()

        {

            DataTable dt = null;

                }

            }

        }

        public static bool SaveHeaderSetting(List<HeaderInfo> headerInfos)

                        }

                        txn.Commit();

                    }

                }

                catch (Exception ex)

                {

                    {

                        var query = $"DELETE FROM {PSN_TRANSFORMKEYWORD_SETTING}";

                        connection.ExecuteNonQuery(connection.GetSqlStringCommand(query), txn);

                        foreach (KeywordItem item in keywordItems)

                        {

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

                            var cmd = connection.GetSqlStringCommand(query);

                            AddWithValue(cmd, "@INDEX", item.Index);

                            AddWithValue(cmd, "@NAME", item.Name);

                            connection.ExecuteNonQuery(cmd, txn);

                        }

                        txn.Commit();

                    }

                    catch (Exception ex)

                {

                    if (names.Count == 0)

                    {

                        var query = $"CREATE TABLE ARS_COMMON.dbo.PSNRevision ([OID] [uniqueidentifier] ,[Project_OID] [uniqueidentifier] ," +

                            $"[ProjectCode] nvarchar(255), [RevNumber] int ,[UserName] nvarchar(255) ,[TimeData] nvarchar(255) ," +

                            $"[PSNDatabasePath] nvarchar(255) ,	[PsnByPBSFilter] varchar(20) ,[PsnByNPDFilter] varchar(20) ,[PidDrawings] int ,	" +

                                $", @PsnByPBSFilter, @PsnByNPDFilter, @PidDrawings, @PipeSystems, @PipeLines, @Topologies, @PipeSystemNetworks, @InValidPSNs, " +

                                $"@E2E, @E2B, @B2E, @HDE, @HD2, @HDB, @B2B, @LastModificationdate, @ID2_PSN)";

                            var cmd = connection.GetSqlStringCommand(query);

                            AddWithValue(cmd, "@ProjectCode", ProjectCode);

                            AddWithValue(cmd, "@RevNumber", RevNumber);

                            AddWithValue(cmd, "@UserName", UserName);

                    using (var txn = connection.BeginTransaction())

                    {

                        try

                            var query = $"INSERT INTO ARS_COMMON.dbo.PSNRevision (OID, Project_OID, ProjectCode, RevNumber, UserName, TimeData, PSNDatabasePath, " +

                                $"PsnByPBSFilter, PsnByNPDFilter, PidDrawings, PipeSystems, PipeLines, Topologies, PipeSystemNetworks, InValidPSNs, E2E, E2B, B2E, HDE, " +

                                $"HD2, HDB, B2B, LastModificationdate, ID2_PSN) VALUES (NEWID(), NEWID(), @ProjectCode, @RevNumber, @UserName, @TimeData, @PSNDatabasePath" +

                            // AddWithValue(cmd, "@LastModificationdate", oDateTime.ToString(ci));

                            AddWithValue(cmd, "@LastModificationdate", "");

                            AddWithValue(cmd, "@ID2_PSN", "Y");

                            connection.ExecuteNonQuery(cmd, txn);

                            txn.Commit();

                        }

                        catch (Exception ex)

        {

            ID2Info id2Info = ID2Info.GetInstance();

            using (IAbstractDatabase connection = id2Info.CreateConnection())

            {

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

                                connection.ExecuteNonQuery(cmd, txn);

                            }

                                connection.ExecuteNonQuery(cmd, txn);

                            }

                            {

                                query = $"If(db_id(N'" + PSN_COMMON + "') IS NULL) CREATE DATABASE [" + PSN_COMMON + "]";

                                connection.ExecuteNonQuery(connection.GetSqlStringCommand(query), txn);

                            }

                            txn.Commit();

                        }

                    }

                    void AddColumn(string TableName, Dictionary<string, string> dicCol, List<string> colnames)

                        bool check = false;

                        if (colnames != null)

                        {

                                    param.Value = row["UID"].ToString();

                                    cmd.Parameters.Add(param);

                                }

                                {

                                    var param = cmd.CreateParameter();

                                    param.ParameterName = "@Code";

                                    param.Value = row["Description"].ToString();

                                    cmd.Parameters.Add(param);

                                }

                                {

                                    var param = cmd.CreateParameter();

                                    param.ParameterName = "@Remarks";

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

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

                            result.PipeSystemNetwork.Rows.Add(newRow);

                        }

                    }

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

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

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

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

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

                            dt.Rows.Add(newRow);

                        }

                    }

            return dt;

        }

        //Anohter DB

        public static bool ConnTestAndCreateAnotherTable()

        {

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

                    dicColCheck.Add("PSNAccuracy", "REAL");

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

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

                    {

                        AddColumn(PSN_AIRFINCOOLERSETTING, dicColCheck);

                    }

                    var query2 = $"If(db_id(N'" + PSN_COMMON + "') IS NULL) CREATE DATABASE [" + PSN_COMMON + "]";

                    if (id2Info.ID2DBType == AnotherID2DB_Type.MSSQL)

                            AddWithValue(cmd, "@UserName", UserName);

                            System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("en-US");

                            AddWithValue(cmd, "@TimeData", oDateTime.ToString(ci)); //String.Format("{0:G}", dt) // DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")

                            AddWithValue(cmd, "@PSNDatabasePath", PSNDatabasePath);

                            AddWithValue(cmd, "@PsnByPBSFilter", PsnByPBSFilter);

                            AddWithValue(cmd, "@LastModificationdate", oDateTime.ToString(ci));

                            AddWithValue(cmd, "@ID2_PSN", "Y");

                            connection.ExecuteNonQuery(cmd, txn);

                            txn.Commit();

                            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, "@PSNAccuracy", row["PSNAccuracy"].ToString().Replace("%", ""));

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

                                connection.ExecuteNonQuery(cmd, txn);

                            }

                                AddWithValue(cmd, "@NAME", row["NAME"].ToString());

                                connection.ExecuteNonQuery(cmd, txn);

                            }

                            txn.Commit();

                        }

                    {

                        try

                        {

                            var query = $"If(db_id(N'" + PSN_COMMON + "') IS NULL) CREATE DATABASE [" + PSN_COMMON + "]";

                            if (id2Info.ID2DBType == AnotherID2DB_Type.MSSQL)

                                connection.ExecuteNonQuery(connection.GetSqlStringCommand(query), 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(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";

            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.OptionsView.UseDefaultDragAndDropRendering = false;

            this.layoutControl1.Root = this.Root;

            this.layoutControl1.TabIndex = 1;

            this.layoutControl1.Text = "layoutControl1";

            // 

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

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

            this.xtraTabControlSetting.Name = "xtraTabControlSetting";

            this.xtraTabControlSetting.SelectedTabPage = this.xtraTabPageNoPocket;

            this.xtraTabControlSetting.TabIndex = 4;

            this.xtraTabControlSetting.TabPages.AddRange(new DevExpress.XtraTab.XtraTabPage[] {

            this.xtraTabPageNoPocket,

            // 

            this.xtraTabPageNoPocket.Controls.Add(this.tableLayoutPanel1);

            this.xtraTabPageNoPocket.Name = "xtraTabPageNoPocket";

            this.xtraTabPageNoPocket.Text = "Equipment for No pocket";

            // 

            // tableLayoutPanel1

            this.tableLayoutPanel1.RowCount = 2;

            this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 50F));

            this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 556F));

            this.tableLayoutPanel1.TabIndex = 1;

            // 

            // gridEquipment

            // 

            this.gridEquipment.Dock = System.Windows.Forms.DockStyle.Fill;

            this.gridEquipment.MainView = this.gridViewEquipment;

            this.gridEquipment.MenuManager = this.ribbonControl;

            this.gridEquipment.Name = "gridEquipment";

            this.gridEquipment.TabIndex = 5;

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

            this.gridViewEquipment});

            // simpleButton1

            // 

            this.simpleButton1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));

            this.simpleButton1.Name = "simpleButton1";

            this.simpleButton1.Size = new System.Drawing.Size(110, 22);

            this.simpleButton1.StyleController = this.layoutControl1;

            // 

            this.xtraTabPageAirPinCooler.Controls.Add(this.tableLayoutPanel2);

            this.xtraTabPageAirPinCooler.Name = "xtraTabPageAirPinCooler";

            this.xtraTabPageAirPinCooler.Text = "Equipment Grouping Tag";

            // 

            // tableLayoutPanel2

            this.tableLayoutPanel2.RowCount = 2;

            this.tableLayoutPanel2.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 4.965754F));

            this.tableLayoutPanel2.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 95.03425F));

            this.tableLayoutPanel2.TabIndex = 1;

            // 

            // gridControlAirFinCooler

            this.gridControlAirFinCooler.MainView = this.gridViewAirFinCooler;

            this.gridControlAirFinCooler.MenuManager = this.ribbonControl;

            this.gridControlAirFinCooler.Name = "gridControlAirFinCooler";

            this.gridControlAirFinCooler.TabIndex = 0;

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

            this.gridViewAirFinCooler});

            // btnAddValveGroup

            // 

            this.btnAddValveGroup.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));

            this.btnAddValveGroup.Name = "btnAddValveGroup";

            this.btnAddValveGroup.Size = new System.Drawing.Size(110, 22);

            this.btnAddValveGroup.StyleController = this.layoutControl1;

            this.emptySpaceItem1,

            this.emptySpaceItem2});

            this.Root.Name = "Root";

            this.Root.TextVisible = false;

            // 

            // layoutControlItem1

            this.layoutControlItem1.Control = this.xtraTabControlSetting;

            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;

            // 

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

            // 

            // EquipmentSetting

            // 

            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 = "EquipmentSetting";

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

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

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

                        {

                            bCheck = true;

                        }

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

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

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

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

                newRow["PSNAccuracy"] = String.Format("{0:0.00}", Convert.ToDouble(row["PSNAccuracy"])) + "%";

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

                PSNPageDT.Rows.Add(newRow);

            }

    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>

  </resheader>

  <metadata name="defaultLookAndFeel.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">

  </metadata>

  <assembly alias="DevExpress.Data.v19.1" name="DevExpress.Data.v19.1, Version=19.1.2.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" />

  <data name="btnExportPSN.ImageOptions.SvgImage" type="DevExpress.Utils.Svg.SvgImage, DevExpress.Data.v19.1" mimetype="application/x-microsoft.net.object.bytearray.base64">

</value>

  </data>

  <metadata name="contextMenuPSN.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">

  </metadata>

  <metadata name="sqLiteCommandBuilder1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">

  </metadata>

  <metadata name="$this.TrayHeight" type="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

    <value>48</value>

            try

            {

                int afcTagNum = 0;

                #region EquipmentAirFinCooler Info

                EquipmentAirFinCoolerInfo EquipmentAirFinCooler = new EquipmentAirFinCoolerInfo();

                DataTable dtEquipmentAirFinCooler = DB.SelectAirFinCoolerSetting();

                foreach (DataRow row in dtEquipmentAirFinCooler.Rows)

                {

                    EquipmentAirFinCooler.EquipmentAirFinCoolerItem.Add(new EquipmentAirFinCoolerItem()

                    {

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

                #endregion

                DataRow[] airFinCoolerRows = PipeSystemNetwork.Select("AFC = 'P1'");

                foreach (DataRow dataRow in airFinCoolerRows)

                {

                    afcTagNum++;

                        }

                    }

                }

            }

            catch (Exception ex)

            {

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

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

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

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

                DataTable topologySetDT = new DataTable();

                topologySetDT.Columns.Add("OID", typeof(string));

                                        string AFC = "P2";

                                        if(PSNItem.StartType == PSNType.Equipment && From_item.Equipment != null)

                                        {

                                                AFC = "P1";

                                        }

                                        if (PSNItem.EndType == PSNType.Equipment && To_item.Equipment != null)

                                        {

                                                AFC = "P1";

                                        }

                                        newRow["AFC"] = AFC;

                                        pipeSystemNetworkDT.Rows.Add(newRow);

                                    }

                                }

                            }

                            else

                            {

                                bCount = 3;

                            }

                            else

                            {

                                PathItems.Rows.InsertAt(createTerminatorRow(pathItemRows.Last(), TO_DATA), insertIndex);

                            }

                            PSNItem.EndType = PSNType.Equipment;

                        }

                        catch (Exception ex)