HYTOS

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

                    dicColCheck.Clear();

                    if (matched == null)

                    {

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

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

                    dicColCheck.Clear();

                    if (matched == null)

                    {

                        var query = $"CREATE TABLE {PSN_NOPOCKETSETTING} ([INDEX] INTEGER, [TYPE] TEXT, [NAME] TEXT)";

                    }

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

                    dicColCheck.Clear();

                    if (matched == null)

                    {

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

                        {

                            cmd.ExecuteNonQuery();

            {

                try

                {

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

                    {

                        dt = ds.Tables[0].Copy();

                        foreach (EquipmentAirFinCoolerItem item in keywordItems)

                        {

                            var cmd = connection.GetSqlStringCommand(query);

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

                            AddWithValue(cmd, "@TYPE", item.Type);

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

                            connection.ExecuteNonQuery(cmd, txn);

                        }

                        txn.Commit();

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

                    dicColCheck.Clear();

                    if (matched == null)

                    {

                        var query = $"CREATE TABLE {PSN_NOPOCKETSETTING} ([INDEX] INTEGER, [TYPE] TEXT, [NAME] TEXT)";

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

                    dicColCheck.Clear();

                    if (matched == null)

                    {

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

                        {

                            cmd.ExecuteNonQuery();

        }

        public static bool SaveAnotherPSNData(PSN item, List<HeaderInfo> headerInfos, List<VentDrainInfo> ventDrainInfos,

        {

            AnotherID2Info id2Info = AnotherID2Info.GetInstance();

                            //air fin cooler Setting

                            query = $"DELETE FROM {PSN_AIRFINCOOLERSETTING}";

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

                            {

                                var cmd = connection.GetSqlStringCommand(query);

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

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

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

                                connection.ExecuteNonQuery(cmd, txn);

                            }

                DataTable PSNVALVALVEGROUPINGDT = DB.SelectValveGroupItemsSetting();

                DataTable PSNNOPOCKETDT = DB.SelectEquipmentNoPocketSetting();

                //DB check

                DB.ConnTestAndCreateAnotherTable();

                //Save

                {

                    if (rgDbSetting.SelectedIndex == 1)

                    {

        EquipmentAirFinCoolerInfo currentEquipmentAirFinCoolerInfo = null;

        private RepositoryItemComboBox repositoryGroupType2 = new RepositoryItemComboBox();

        public EquipmentSetting()

        {

            InitializeComponent();

            InitGridEquipmentNoPocket();

            InitGridEquipmentAirFinCooler();

            EquipmentNoPocketInfos = new List<EquipmentNoPocketInfo>();

            currentEquipmentNoPocketInfo = new EquipmentNoPocketInfo();

            InitAirFinCoolerData();

        }

        public void InitGridEquipmentNoPocket()

        {

            RepositoryItemButtonEdit btnRemove = new RepositoryItemButtonEdit();

            DataTable dtType = new DataTable();

            dtType.Columns.Add("Index");

            dtType.Columns.Add("Type");

            dtType.Columns.Add("SppidSymbolName");

            dtType.Columns.Add(" ");

            gridControlAirFinCooler.DataSource = dtType;

            GridColumn gridColumn = gridViewAirFinCooler.Columns[0];

            gridColumn.Name = "Index";

            gridColumn.Caption = "Index";

            gridColumn.OptionsColumn.AllowEdit = false;

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

            gridColumn = gridViewAirFinCooler.Columns[2];

            gridColumn.Name = "SppidSymbolName";

            gridColumn.Caption = "ID2 Symbol Name";

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

            RepositoryItemTreeListLookUpEdit treeListLookUpEdit = new RepositoryItemTreeListLookUpEdit();

            gridControlAirFinCooler.RepositoryItems.Add(treeListLookUpEdit);

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

            gridColumn.Name = "Remove";

            gridColumn.Caption = "";

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

            gridColumn.MaxWidth = 16;

            gridColumn.ColumnEdit = btnRemove;

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

        }

        private void GridViewKeyword_CustomDrawColumnHeader(object sender, ColumnHeaderCustomDrawEventArgs e)

            {

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

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

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

            }

        }

            }

            DataTable dt = gridControlAirFinCooler.DataSource as DataTable;

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

        }

                {

                    Index = i + 1,

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

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

                });

            }

                return;

            }

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

                DB.SaveAirFinCoolerSetting(currentEquipmentAirFinCoolerInfo.EquipmentAirFinCoolerItem))

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

            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.gridHistory.MainView = this.gridViewHistory;

            this.gridHistory.MenuManager = this.ribbonControl;

            this.gridHistory.Name = "gridHistory";

            this.gridHistory.TabIndex = 6;

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

            this.gridViewHistory});

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

            this.layoutControlItem5,

            this.layoutControlItem1});

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

            // 

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

            this.layoutControlItem1.Control = this.gridHistory;

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

    <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="System.Drawing" name="System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

  <data name="btnSaveAs.ImageOptions.Image" type="System.Drawing.Bitmap, System.Drawing" 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>25</value>

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

            // 

            new DevExpress.XtraEditors.Controls.RadioGroupItem("Drawing No", "Drawing No"),

            new DevExpress.XtraEditors.Controls.RadioGroupItem("Unit Area", "Unit Area"),

            new DevExpress.XtraEditors.Controls.RadioGroupItem("No selection (Empty PBS)", "No selection (Empty PBS)")});

            this.radioGroupPBS1.StyleController = this.layoutControl1;

            this.radioGroupPBS1.TabIndex = 19;

            this.radioGroupPBS1.SelectedIndexChanged += new System.EventHandler(this.radioGroupPBS_SelectedIndexChanged);

            // 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.comboBoxEditPBSAttr.Name = "comboBoxEditPBSAttr";

            this.comboBoxEditPBSAttr.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {

            new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});

            this.comboBoxEditPBSAttr.StyleController = this.layoutControl1;

            this.comboBoxEditPBSAttr.TabIndex = 14;

            // 

            0,

            0,

            0});

            this.spinEditStart.StyleController = this.layoutControl1;

            this.spinEditStart.TabIndex = 17;

            // 

            0,

            0,

            0});

            this.spinEditEnd.Name = "spinEditEnd";

            this.spinEditEnd.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {

            new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});

            0,

            0,

            0});

            this.spinEditEnd.StyleController = this.layoutControl1;

            this.spinEditEnd.TabIndex = 18;

            // 

            this.emptySpaceItem2,

            this.layoutControlGroup2});

            this.Root.Name = "Root";

            this.Root.TextVisible = false;

            // 

            // emptySpaceItem3

            this.emptySpaceItem3.AllowHotTrack = false;

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

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

            this.layoutControlItem4.SizeConstraintsType = DevExpress.XtraLayout.SizeConstraintsType.Custom;

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

            this.layoutControlItem4.TextVisible = false;

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

            this.layoutControlItem5.SizeConstraintsType = DevExpress.XtraLayout.SizeConstraintsType.Custom;

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

            this.layoutControlItem5.TextVisible = false;

            // 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.emptySpaceItem2.SizeConstraintsType = DevExpress.XtraLayout.SizeConstraintsType.Custom;

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

            // 

            this.layoutControlItem1});

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

            this.layoutControlGroup2.Name = "layoutControlGroup2";

            this.layoutControlGroup2.Text = "PBS ";

            // 

            // layoutControlItemPBSAttribute

            this.layoutControlItemPBSAttribute.CustomizationFormText = "Attr Name";

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

            this.layoutControlItemPBSAttribute.Name = "layoutControlItemPBSAttribute";

            this.layoutControlItemPBSAttribute.Text = "Attr Name";

            this.layoutControlItemPBSAttribute.TextSize = new System.Drawing.Size(57, 14);

            // 

            this.layoutControlItemStart.CustomizationFormText = "From";

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

            this.layoutControlItemStart.Name = "layoutControlItemStart";

            this.layoutControlItemStart.Text = "From";

            this.layoutControlItemStart.TextSize = new System.Drawing.Size(57, 14);

            // 

            // 

            this.layoutControlItemEnd.Control = this.spinEditEnd;

            this.layoutControlItemEnd.CustomizationFormText = "To";

            this.layoutControlItemEnd.Name = "layoutControlItemEnd";

            this.layoutControlItemEnd.Text = "To";

            this.layoutControlItemEnd.TextSize = new System.Drawing.Size(57, 14);

            // 

            this.layoutControlItem1.Control = this.radioGroupPBS1;

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

            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.gridValveGroup.MainView = this.gridViewValveGroup;

            this.gridValveGroup.MenuManager = this.ribbonControl;

            this.gridValveGroup.Name = "gridValveGroup";

            this.gridValveGroup.TabIndex = 4;

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

            this.gridViewValveGroup});

            // 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 Valve Group";

            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 = "Valve Group Items";

            // 

            // layoutControlItem6

            this.layoutControlItem6.Control = this.gridValveGroup;

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

            // 

            // ValveGroupingSetting

            // 

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

            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.Location = new System.Drawing.Point(0, 32);

            this.layoutControl1.Name = "layoutControl1";

            this.layoutControl1.Root = this.Root;

            this.layoutControl1.TabIndex = 1;

            this.layoutControl1.Text = "layoutControl1";

            // 

            this.labelControlToolTip.ImageAlignToText = DevExpress.XtraEditors.ImageAlignToText.RightCenter;

            this.labelControlToolTip.ImageOptions.Alignment = System.Drawing.ContentAlignment.MiddleLeft;

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

            this.labelControlToolTip.Name = "labelControlToolTip";

            this.labelControlToolTip.Size = new System.Drawing.Size(70, 16);

            this.labelControlToolTip.StyleController = this.layoutControl1;

            // 

            // btnAddType

            // 

            this.btnAddType.Name = "btnAddType";

            this.btnAddType.StyleController = this.layoutControl1;

            this.btnAddType.TabIndex = 0;

            this.btnAddType.Text = "Add Type";

            // 

            // gridControlSymbol

            // 

            this.gridControlSymbol.MainView = this.gridViewSymbol;

            this.gridControlSymbol.MenuManager = this.ribbonControl;

            this.gridControlSymbol.Name = "gridControlSymbol";

            this.gridControlSymbol.TabIndex = 4;

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

            this.gridViewSymbol});

            this.gridControlType.MainView = this.gridViewType;

            this.gridControlType.MenuManager = this.ribbonControl;

            this.gridControlType.Name = "gridControlType";

            this.gridControlType.TabIndex = 3;

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

            this.gridViewType});

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

            // 

            // btnAddSymbol

            // 

            this.btnAddSymbol.Name = "btnAddSymbol";

            this.btnAddSymbol.StyleController = this.layoutControl1;

            this.btnAddSymbol.TabIndex = 2;

            this.btnAddSymbol.Text = " Add Symbol";

            this.layoutControlItem7,

            this.emptySpaceItem5});

            this.Root.Name = "Root";

            this.Root.TextVisible = false;

            // 

            // splitterItem1

            // 

            this.splitterItem1.AllowHotTrack = true;

            this.splitterItem1.Name = "splitterItem1";

            // 

            // 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.emptySpaceItem4});

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

            this.layoutControlGroup1.Name = "layoutControlGroup1";

            this.layoutControlGroup1.Text = "Vent/Drain Type";

            // 

            // layoutControlItem2

            this.layoutControlItem2.Control = this.gridControlType;

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

            this.layoutControlItem2.Name = "layoutControlItem2";

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

            this.layoutControlItem2.TextVisible = false;

            // 

            // layoutControlItem1

            // 

            this.layoutControlItem1.Control = this.btnAddType;

            this.layoutControlItem1.Name = "layoutControlItem1";

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

            this.layoutControlItem1.TextVisible = false;

            // 

            this.emptySpaceItem4.AllowHotTrack = false;

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

            this.emptySpaceItem4.Name = "emptySpaceItem4";

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

            // 

            // layoutControlGroup2

            this.layoutControlItem6,

            this.layoutControlItem3,

            this.emptySpaceItem1});

            this.layoutControlGroup2.Name = "layoutControlGroup2";

            this.layoutControlGroup2.Text = "Type Items";

            // 

            // layoutControlItem6

            this.layoutControlItem6.Control = this.gridControlSymbol;

            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.btnAddSymbol;

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

            // 

            // layoutControlItem7

            // 

            this.layoutControlItem7.Control = this.labelControlToolTip;

            this.layoutControlItem7.MaxSize = new System.Drawing.Size(74, 20);

            this.layoutControlItem7.MinSize = new System.Drawing.Size(74, 20);

            this.layoutControlItem7.Name = "layoutControlItem7";

            this.emptySpaceItem5.AllowHotTrack = false;

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

            this.emptySpaceItem5.Name = "emptySpaceItem5";

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

            // 

            // VentDrainSettingForm

            // 

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

    {

        public int Index { get; set; }

        public string Type { get; set; }

        public string Name { get; set; }

    }

}

                }

                int afcTagNum = 0;

                foreach (DataRow dataRow in airFinCoolerRows)

                {

                }

                foreach (DataRow dataRow in airFinCoolerRows)

                    }

                    else if (dataRow["Type"].ToString() == "E2B" || dataRow["Type"].ToString() == "B2E")

                    {

                        foreach (string viewOID in lstViewPipeSystemNetwork_OID)

                        {

                            if (viewOID == dataRow["OID"].ToString())

                                continue;

                            DataRow dr = PipeSystemNetwork.Select(string.Format("OID = '{0}'", viewOID)).First();

                            {

                                if (lstViewPipeSystemNetwork_OID.Where(x => x.Equals(viewOID)).Count() == 1)

                                {

                                    DataRow[] viewpathItemRows = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", viewOID));

                                    foreach (DataRow viewdr in viewpathItemRows)

                                    {

                                        viewdr["MainLineTag"] = "M";

                                    }

                                }

                        dr["EGFlowDirection"] = EGFlowDirection; 

                    }

                }

                foreach (DataRow dataRow in airFinCoolerRows)

                {

                    DataRow[] pathItemRows = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}' AND MainLineTag = ''", dataRow["OID"].ToString()));

                    if (pathItemRows.Count() > 0)

                    {

                        List<string> lstViewPipeSystemNetwork_OID = pathItemRows.Select(x => x.Field<string>("ViewPipeSystemNetwork_OID")).Distinct().ToList();

                        foreach (string viewOID in lstViewPipeSystemNetwork_OID)

                        {

                            if (dataRow["OID"].ToString() == viewOID)

                                continue;

                            DataRow viewPSN = null;

                            if (PipeSystemNetwork.Select(string.Format("OID = '{0}' AND AFC = 'P3'", viewOID)).Count() > 0)

                                viewPSN = PipeSystemNetwork.Select(string.Format("OID = '{0}' AND AFC = 'P3'", viewOID)).First();

                            if (viewPSN != null)

                            {

                                EqpGroupTag = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", viewOID)).First().Field<string>("EqpGroupTag");

                                foreach (DataRow dr in pathItemRows)

                                {

                                    dr["EqpGroupTag"] = EqpGroupTag;

                                    if (!string.IsNullOrEmpty(dr.Field<string>("ViewPipeSystemNetwork_OID")) && !lstpsn.Contains(dr.Field<string>("ViewPipeSystemNetwork_OID")))

                                    {

                                        lstpsn.Add(dr.Field<string>("ViewPipeSystemNetwork_OID"));

                            int lstCount = lstpsn.Count;

                            for (int i = 0; i < lstpsn.Count(); i++) //string psn in lstpsn

                            {

                                DataRow[] rule4pathItems = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", lstpsn[i]));

                                foreach (DataRow dr in rule4pathItems)

                                {

                                    if (!string.IsNullOrEmpty(dr.Field<string>("ViewPipeSystemNetwork_OID")) && !lstAll.Contains(dr.Field<string>("ViewPipeSystemNetwork_OID")))

                                    {

                                    }

                                    if (dr["EqpGroupTag"].Equals(EqpGroupTag))

                                        continue;

                                }

                                lstpsn.Remove(lstpsn[i]);

                        }

                    }

                }

                foreach(DataRow dr in PipeSystemNetwork.Rows)

                {

                    DataRow[] pathItemRows = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}' AND MainLineTag = 'M'", dr["OID"].ToString()));

                                if (viewpsn == dr["OID"].ToString())

                                    continue;

                                    continue;

                                if(rows != null)

                                {

                                    lastP1 = viewpsn;

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

                                        {

                                            if (EquipmentAirFinCooler.EquipmentAirFinCoolerItem.Where(x => x.Type != "Pump" && x.Name.Equals(From_item.Equipment.Name)).Count() > 0)

                                            else if (EquipmentAirFinCooler.EquipmentAirFinCoolerItem.Where(x => x.Type == "Pump" && x.Name.Equals(From_item.Equipment.Name)).Count() > 0)

                                                newRow["PUMP"] = "PUMP";

                                        }

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

                                        {

                                            if (EquipmentAirFinCooler.EquipmentAirFinCoolerItem.Where(x => x.Type != "Pump" && x.Name.Equals(To_item.Equipment.Name)).Count() > 0)

                                            else if (EquipmentAirFinCooler.EquipmentAirFinCoolerItem.Where(x => x.Type == "Pump" && x.Name.Equals(To_item.Equipment.Name)).Count() > 0)

                                                newRow["PUMP"] = "PUMP";

                                        }