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