public static VWACommon.MyListBoxItem TypeCatalog(string termID)
{
VWACommon.MyListBoxItem res;
DataTable catalogDataTable = new DataTable();
string sql =
@"SELECT TypeCatalogs.ID, TypeCatalogs.TypeCatalogName " +
"FROM TypeCatalogs " +
"WHERE TypeCatalogs.ID IN (SELECT Sites.TypeCatalogID " +
"FROM Sites " +
"WHERE Sites.ID IN (SELECT Terminals.SiteID " +
"FROM Terminals " +
"WHERE Terminals.TermID = '" + termID.Trim() + "'));";
catalogDataTable = VWA4Common.DB.Retrieve(sql);
if (catalogDataTable.Rows.Count > 0)
{
res = new VWACommon.MyListBoxItem(catalogDataTable.Rows[0]["TypeCatalogName"].ToString(), catalogDataTable.Rows[0]["ID"].ToString());
}
else
{
res = new VWACommon.MyListBoxItem("Master", "0");
}
return(res);
}
public static VWACommon.MyListBoxItem[] GetSites()
{
DataTable siteDataTable = new DataTable();
string sql = @"SELECT ID, LicensedSite FROM Sites WHERE Active = true;";
siteDataTable = VWA4Common.DB.Retrieve(sql);
VWACommon.MyListBoxItem[] res = new VWACommon.MyListBoxItem[siteDataTable.Rows.Count];
int i = 0;
foreach (DataRow row in siteDataTable.Rows)
{
res[i++] = new VWACommon.MyListBoxItem(row.ItemArray[1].ToString(), row.ItemArray[0].ToString());
}
return(res);
}
public static VWACommon.MyListBoxItem[] GetTypeCatalogs()
{
DataTable siteDataTable = new DataTable();
string sql = @"SELECT ID, TypeCatalogName FROM TypeCatalogs;";
siteDataTable = VWA4Common.DB.Retrieve(sql);
VWACommon.MyListBoxItem[] res = new VWACommon.MyListBoxItem[siteDataTable.Rows.Count + 1];
int i = 1;
res[0] = new VWACommon.MyListBoxItem("Master", "0");
foreach (DataRow row in siteDataTable.Rows)
{
res[i++] = new VWACommon.MyListBoxItem(row.ItemArray[0].ToString(), row.ItemArray[1].ToString());
}
return(res);
}
