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