/** * Get all ingredients of a recipe with given id * */ public static ObservableCollection <Ingredient> GetAll(int recipeid) { //form query ObservableCollection <Ingredient> r = new ObservableCollection <Ingredient>(); String query = @"SELECT * FROM ingredients WHERE recipes_idrecipes = " + recipeid; DBConnector.initAsync(); MySqlCommand cmd = new MySqlCommand(query, DBConnector.conn); MySqlDataReader reader = cmd.ExecuteReader(); //fix ingredients units and add them to the collection while (reader.Read()) { Ingredient i = new Ingredient(); i.Name = reader["name"] + ""; i.Amount = int.Parse(reader["amount"] + ""); String units = reader["unit"] + ""; switch (units) { case "Liter": i.Unit = new Units() { Name = "Liter", Short = "L", Unit = EUnit.Liter }; r.Add(i); break; case "Pieces": i.Unit = new Units() { Name = "Pieces", Short = "P.", Unit = EUnit.Pieces }; r.Add(i); break; case "Spoons": i.Unit = new Units() { Name = "Spoons", Short = "Spns.", Unit = EUnit.Spoons }; r.Add(i); break; case "Mililiter": i.Unit = new Units() { Name = "Mililiter", Short = "ml", Unit = EUnit.Spoons }; r.Add(i); break; case "Kilogramm": i.Unit = new Units() { Name = "Kilogramm", Short = "kg", Unit = EUnit.Kilogramm }; r.Add(i); break; case "Gram": i.Unit = new Units() { Name = "Gramm", Short = "G", Unit = EUnit.Gramm }; r.Add(i); break; case "Miligram": i.Unit = new Units() { Name = "Miligram", Short = "mg", Unit = EUnit.Milligramm }; r.Add(i); break; default: break; } } return(r); }
public void AddIngredient(Ingredient ingredient) { ingredients.Add(ingredient); }