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