private void LoadIngredients()
{
Ingrediens ingrediens = new Ingrediens();
cbIngrediens.DisplayMember = "IngrediensNamn";
cbIngrediens.ValueMember = "IngrediensID";
cbIngrediens.DataSource = ingrediens.GetAllIngredients();
}
private void LoadRecipeIngredients(int id)
{
Ingrediens ingrediens = new Ingrediens();
lstSelectedRecipeIngredienser.DisplayMember = "IngrediensNamn";
lstSelectedRecipeIngredienser.ValueMember = "IngrediensID";
lstSelectedRecipeIngredienser.DataSource = ingrediens.GetIngredients(myReceipe.ReceptID);
}
private void cmdAdd_Click_1(object sender, EventArgs e)
{
Ingrediens ingrediens = new Ingrediens();
ingrediens.IngrediensID = (int)cbIngrediens.SelectedValue;
List <string> ingrediensNamn = ingrediens.GetIngredientName();
lstSelectedIngredients.Items.Add(new ListBoxItem(ingrediensNamn[0].ToString(),
ingrediens.IngrediensID));
myReceipe.Ingredienser.Add(ingrediens);
}
public List <Ingrediens> GetAllIngredients()
{
List <Ingrediens> allaIngredienser = new List <Ingrediens>();
DbManager dbManager = new DbManager("SELECT IngrediensID, IngrediensNamn FROM Ingrediens");
DataTable table = dbManager.ExecuteSQL();
foreach (DataRow row in table.Rows)
{
Ingrediens ingrediens = new Ingrediens();
ingrediens.IngrediensID = (int)row.ItemArray[0];
ingrediens.IngrediensNamn = row.ItemArray[1].ToString();
allaIngredienser.Add(ingrediens);
}
return(allaIngredienser);
}
public List <Ingrediens> GetIngredients(int id)
{
List <Ingrediens> ingrediensLista = new List <Ingrediens>();
DbManager dbManager = new DbManager("SELECT i.IngrediensNamn " +
"FROM ReceptIngrediens ri " +
"Inner join Ingrediens i ON i.IngrediensID = ri.IngrediensID " +
"WHERE ri.ReceptID = '" + id + "'");
DataTable table = dbManager.ExecuteSQL();
foreach (DataRow row in table.Rows)
{
Ingrediens ingrediens = new Ingrediens();
ingrediens.IngrediensNamn = row.ItemArray[0].ToString();
ingrediensLista.Add(ingrediens);
}
return(ingrediensLista);
}
