public IList <string> QueryTransferShops()
{
var queryResult = fDB.Query <QString>("select distinct Shop as element from Transfer");
return(ALData.GetStringList(queryResult));
}
public IList <string> QueryBrandCountries()
{
var queryResult = fDB.Query <QString>("select distinct Country as element from Brand");
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 List <MeasureValue> CollectData(Aquarium aquarium)
{
List <MeasureValue> measures = new List <MeasureValue>();
PrepareValue(aquarium, measures, "Temperature", "T", "°C", null);
double NO3 = PrepareValue(aquarium, measures, "NO3", "NO3", "mg/l", ALData.NO3Ranges);
PrepareValue(aquarium, measures, "NO2", "NO2", "mg/l", ALData.NO2Ranges);
PrepareValue(aquarium, measures, "Cl2", "Cl2", "mg/l", ALData.Cl2Ranges);
PrepareValue(aquarium, measures, "GH", "GH", "°d", ALData.GHRanges);
PrepareValue(aquarium, measures, "KH", "KH", "°d", ALData.KHRanges);
PrepareValue(aquarium, measures, "pH", "pH", "", ALData.pHRanges);
PrepareValue(aquarium, measures, "CO2", "CO2", "", ALData.CO2Ranges);
PrepareValue(aquarium, measures, "NH", "NHtot", "", null);
PrepareValue(aquarium, measures, "NH3", "NH3", "", ALData.NH3Ranges);
PrepareValue(aquarium, measures, "NH4", "NH4", "", null);
double PO4 = PrepareValue(aquarium, measures, "PO4", "PO4", "", ALData.PO4Ranges);
double redfield = (!double.IsNaN(PO4) && !DoubleHelper.Equals(PO4, 0.0001, 0.0001)) ? ALData.CalcRedfield(NO3, PO4) : double.NaN;
PrepareValue(measures, redfield, "Redfield", "", ALData.RedfieldRanges);
return(measures);
}
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));
}