private void SilenceCreateNewElement(int pageSectionID, string ElementName) { Boolean flag = true; var sql = new Sql(); var dataset = new DataSetAutoTest(); var adapterGuimap = new GuiMapTableAdapter(); if (pageSectionID > 0) { adapterGuimap.Fill(dataset.GuiMap); DataTableReader dtElementReader = dataset.GuiMap.CreateDataReader(); while (dtElementReader.Read()) { //GuiMapID 0 var col1 = dtElementReader.GetValue(1).ToString().Trim(); //GuiMapObjectName var col2 = dtElementReader.GetValue(2).ToString().Trim(); //TagTypeID === 2 var col3 = dtElementReader.GetValue(3).ToString().Trim(); //TagTypeValue var col4 = Convert.ToInt32(dtElementReader.GetValue(4).ToString().Trim()); //GuiProjectID == PageSection if (col4 == pageSectionID && col3 == ElementName) { flag = false; break; } } if (flag) { string guiMapObjectName = _pprefix + ElementName; adapterGuimap.Insert(guiMapObjectName, 2, ElementName, pageSectionID); string GuiMapId = adapterGuimap.GetLastGuiMapId().ToString(); sql.UpdateVersion("GuiMap", "GuiMapID", GuiMapId, this._VersionName, 1); } } }
private int SilenceCreateNewPageSection(string pageSectionName, int pageID) { int pageSectionID = 0; if (pageSectionName == string.Empty) { return(pageSectionID); } var sql = new Sql(); var dataset = new DataSetAutoTest(); var adapterPageSection = new GuiPageSectionTableAdapter(); Boolean flag = true; adapterPageSection.Fill(dataset.GuiPageSection); DataTableReader dtReader = dataset.GuiPageSection.CreateDataReader(); while (dtReader.Read()) { var pID = dtReader.GetValue(1).ToString().Trim(); var pName = dtReader.GetValue(2).ToString().Trim(); if (pName == pageSectionName && Convert.ToInt32(pID) == pageID) { flag = false; // get existing page section ID pageSectionID = Convert.ToInt32(dtReader.GetValue(0).ToString().Trim()); break; } } dtReader.Close(); if (!flag) { return(pageSectionID); } // create new page section adapterPageSection.Insert(pageID, pageSectionName); // Get new Page Section's ID adapterPageSection.Fill(dataset.GuiPageSection); dtReader = dataset.GuiPageSection.CreateDataReader(); while (dtReader.Read()) { var pID = dtReader.GetValue(1).ToString().Trim(); var pName = dtReader.GetValue(2).ToString().Trim(); if (pName == pageSectionName && Convert.ToInt32(pID) == pageID) { pageSectionID = Convert.ToInt32(dtReader.GetValue(0).ToString().Trim()); break; } } dtReader.Close(); return(pageSectionID); }