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