public void SaveIngredient() { Ingredient i = (Ingredient)cmb_IngredientNames.SelectedItem; Measurement m = (Measurement)cmb_Measurement.SelectedItem; IngredientEntry iEntry = new IngredientEntry(i, m, txt_Amount.Text); _Ingredients.Add(iEntry); }
private void BuildRecipeListBox() { try { using (RecipeBook_DataModelDataContext db = new RecipeBook_DataModelDataContext()) { var r = from re in db.Recipes select re; foreach(Recipe re in r) { var i = from ing in db.Ingredients join ri in db.RecipeIngredients on ing.ing_ID equals ri.ing_ID where ri.rec_ID == re.rec_ID select ing; List<IngredientEntry> ingredients = new List<IngredientEntry>(); foreach(Ingredient ing in i) { var m = from mes in db.RecipeIngredients where mes.ing_ID == ing.ing_ID && mes.rec_ID == re.rec_ID select mes.Measurement; var a = from mes in db.RecipeIngredients where mes.ing_ID == ing.ing_ID && mes.rec_ID == re.rec_ID select mes.ri_Amount; IngredientEntry ingred = new IngredientEntry(ing, m.First(), (double)a.First()); ingredients.Add(ingred); } RecipeEntry rec = new RecipeEntry(re.rec_Name, re.rec_Source,(RecipeCategory)cmb_RecipeCategory.SelectedItem,re.rec_Description,re.rec_PreparationInstructions,re.rec_CookingInstructions, ingredients, re.rec_ID); _Recipes.Add(rec); } } lst_Recipes.ItemsSource = _Recipes; } catch (Exception e) { MessageBox.Show(e.Message); } }