public Yeast(string name, YeastCharacteristics characteristics, string notes, string laboratory, string productId) : base(name, notes) { m_characteristics = characteristics; m_laboratory = laboratory; m_productId = productId; }
public static IEnumerable <Yeast.Yeast> GetAvailableYeasts(SQLiteConnection connection) { var selectYeastCommand = connection.CreateCommand(); selectYeastCommand.CommandText = "SELECT name, type, form, laboratory, productId, minTemperature, maxTemperature, flocculation, attenuation, notes FROM Yeasts"; using var reader = selectYeastCommand.ExecuteReader(); while (reader.Read()) { string name = reader.GetString(0); string type = reader.GetString(1); string form = reader.GetString(2); string laboratory = reader.GetString(3); string productId = reader.GetString(4); float minTemperature = reader.GetFloat(5); float maxTemperature = reader.GetFloat(6); string flocculation = reader.GetString(7); float attenuation = reader.GetFloat(8); string notes = reader.GetString(9); var characteristics = new YeastCharacteristics(type, flocculation, form) { Attenuation = attenuation, MinTemperature = minTemperature, MaxTemperature = maxTemperature }; yield return(new Yeast.Yeast(name, characteristics, notes, laboratory, productId)); } }
internal static YeastIngredientDataModel GetYeastIngredientForRecipe(int recipeId, SQLiteConnection connection) { using var selectIngredientsCommand = connection.CreateCommand(); selectIngredientsCommand.CommandText = "SELECT YeastIngredients.id, YeastIngredients.weight, YeastIngredients.volume, Yeasts.id, Yeasts.name, Yeasts.type, Yeasts.form, Yeasts.laboratory, Yeasts.productId, Yeasts.minTemperature, Yeasts.maxTemperature, Yeasts.flocculation, Yeasts.attenuation, Yeasts.notes FROM YeastIngredients " + "JOIN Recipes ON Recipes.yeastIngredientInfo = YeastIngredients.id AND Recipes.id = @recipeId " + "JOIN Yeasts ON Yeasts.id = YeastIngredients.yeastInfo " + "LIMIT 1"; selectIngredientsCommand.Parameters.AddWithValue("recipeId", recipeId); using var reader = selectIngredientsCommand.ExecuteReader(); while (reader.Read()) { var characteristics = new YeastCharacteristics(reader.GetString(5), reader.GetString(11), reader.GetString(6)) { Attenuation = reader.GetFloat(12), MinTemperature = reader.GetFloat(9), MaxTemperature = reader.GetFloat(10) }; var yeastInfo = new Yeast.Yeast(reader.GetString(4), characteristics, reader.GetString(13), reader.GetString(7), reader.GetString(8)); return(new YeastIngredientDataModel(yeastInfo, reader.GetInt32(0)) { Volume = reader.GetFloat(2), Weight = reader.GetFloat(1) }); } return(null); }
public static IEnumerable<Yeast> GetAvailableYeasts(SQLiteConnection connection) { SQLiteCommand selectYeastCommand = connection.CreateCommand(); selectYeastCommand.CommandText = "SELECT name, type, form, laboratory, productId, minTemperature, maxTemperature, flocculation, attenuation, notes FROM Yeasts"; using (SQLiteDataReader reader = selectYeastCommand.ExecuteReader()) { while (reader.Read()) { string name = reader.GetString(0); string type = reader.GetString(1); string form = reader.GetString(2); string laboratory = reader.GetString(3); string productId = reader.GetString(4); float minTemperature = reader.GetFloat(5); float maxTemperature = reader.GetFloat(6); string flocculation = reader.GetString(7); float attenuation = reader.GetFloat(8); string notes = reader.GetString(9); YeastCharacteristics characteristics = new YeastCharacteristics(type, flocculation, form) { Attenuation = attenuation, MinTemperature = minTemperature, MaxTemperature = maxTemperature }; yield return new Yeast(name, characteristics, notes, laboratory, productId); } } }
public static Yeast.Yeast GetYeast(XElement yeastEntry) { var name = GetNameFromRecord(yeastEntry); var type = EnumConverter.Parse <YeastType>(yeastEntry.GetChildElementValue("TYPE")); var form = EnumConverter.Parse <YeastForm>(yeastEntry.GetChildElementValue("FORM")); var laboratory = yeastEntry.GetChildElementValue("LABORATORY"); var productId = yeastEntry.GetChildElementValue("PRODUCT_ID"); var minTemperature = Convert.ToSingle(yeastEntry.GetChildElementValue("MIN_TEMPERATURE")); var maxTemperature = Convert.ToSingle(yeastEntry.GetChildElementValue("MAX_TEMPERATURE")); var flocculation = EnumConverter.Parse <Flocculation>(yeastEntry.GetChildElementValue("FLOCCULATION")); var attenuation = Convert.ToSingle(yeastEntry.GetChildElementValue("ATTENUATION")); var notes = GetNotesFromRecord(yeastEntry); var characteristics = new YeastCharacteristics(type, flocculation, form, minTemperature, maxTemperature, attenuation); return(new Yeast.Yeast(name, characteristics, notes, laboratory, productId)); }
public static Yeast GetYeast(XElement yeastEntry) { string name = GetNameFromRecord(yeastEntry); string type = yeastEntry.Element("TYPE").Value; string form = yeastEntry.Element("FORM").Value; string laboratory = yeastEntry.Element("LABORATORY").Value; string productId = yeastEntry.Element("PRODUCT_ID").Value; float minTemperature = (float) Convert.ToDouble(yeastEntry.Element("MIN_TEMPERATURE").Value); float maxTemperature = (float) Convert.ToDouble(yeastEntry.Element("MAX_TEMPERATURE").Value); string flocculation = yeastEntry.Element("FLOCCULATION").Value; float attenuation = (float) Convert.ToDouble(yeastEntry.Element("ATTENUATION").Value); string notes = GetNotesFromRecord(yeastEntry); YeastCharacteristics characteristics = new YeastCharacteristics(type, flocculation, form) { Attenuation = attenuation, MinTemperature = minTemperature, MaxTemperature = maxTemperature }; return new Yeast(name, characteristics, notes, laboratory, productId); }
internal static YeastIngredientDataModel GetYeastIngredientForRecipe(int recipeId, SQLiteConnection connection) { using (SQLiteCommand selectIngredientsCommand = connection.CreateCommand()) { selectIngredientsCommand.CommandText = "SELECT YeastIngredients.id, YeastIngredients.weight, YeastIngredients.volume, Yeasts.id, Yeasts.name, Yeasts.type, Yeasts.form, Yeasts.laboratory, Yeasts.productId, Yeasts.minTemperature, Yeasts.maxTemperature, Yeasts.flocculation, Yeasts.attenuation, Yeasts.notes FROM YeastIngredients " + "JOIN Recipes ON Recipes.yeastIngredientInfo = YeastIngredients.id AND Recipes.id = @recipeId " + "JOIN Yeasts ON Yeasts.id = YeastIngredients.yeastInfo " + "LIMIT 1"; selectIngredientsCommand.Parameters.AddWithValue("recipeId", recipeId); using (SQLiteDataReader reader = selectIngredientsCommand.ExecuteReader()) { while (reader.Read()) { YeastCharacteristics characteristics = new YeastCharacteristics(reader.GetString(5), reader.GetString(11), reader.GetString(6)) { Attenuation = reader.GetFloat(12), MinTemperature = reader.GetFloat(9), MaxTemperature = reader.GetFloat(10) }; Yeast yeastInfo = new Yeast(reader.GetString(4), characteristics, reader.GetString(13), reader.GetString(7), reader.GetString(8)); return new YeastIngredientDataModel(yeastInfo, reader.GetInt32(0)) { Volume = reader.GetFloat(2), Weight = reader.GetFloat(1) }; } } } return null; }