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