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