public IList <string> QueryBrandCountries()
{
var queryResult = fDB.Query <QString>("select distinct Country as element from Brand");
return(ALData.GetStringList(queryResult));
}
public IList <string> QueryTransferShops()
{
var queryResult = fDB.Query <QString>("select distinct Shop as element from Transfer");
return(ALData.GetStringList(queryResult));
}
public IList <string> QueryNutritionBrands()
{
var queryResult = fDB.Query <QString>("select distinct Brand as element from Nutrition");
return(ALData.GetStringList(queryResult));
}
public IList <string> QueryInventoryBrands()
{
var queryResult = fDB.Query <QString>("select distinct Brand as element from Inventory");
return(ALData.GetStringList(queryResult));
}
public IList <string> QuerySpeciesHabitats()
{
var queryResult = fDB.Query <QString>("select distinct Habitat as element from Species");
return(ALData.GetStringList(queryResult));
}
public IList <string> QueryAquariumBrands()
{
var queryResult = fDB.Query <QString>("select distinct Brand as element from Aquarium");
return(ALData.GetStringList(queryResult));
}