private void PopulateFruitGrid() { using (var db = new MealGeneratorContext()) { gvFruit.DataSource = db.Fruits.ToList(); } }
private async void btnAddMeal_ClickAsync(object sender, EventArgs e) { if (tbMealName.Text == "") { return; } List <Ingredient> ingredients = new List <Ingredient>(); foreach (DataGridViewRow row in gvSelectIngredientsForMeal.Rows) { if (row.Cells[1].Value != null) { ingredients.Add(row.DataBoundItem as Ingredient); } } //move db to presenter Meal meal = new Meal() { Name = tbMealName.Text, IsActive = true, Ingredients = ingredients, }; Meals.Add(meal); using (var db = new MealGeneratorContext()) { db.Meals.Add(meal); await db.SaveChangesAsync(); } }
internal async void DeleteMeal(Meal meal) { using (var db = new MealGeneratorContext()) { db.Meals.Attach(meal); db.Meals.Remove(meal); await db.SaveChangesAsync(); } }
private void btnOpenAddMeal_Click_1(object sender, EventArgs e) { pnAddMeal.Visible = true; using (var db = new MealGeneratorContext()) { List <Ingredient> allIngredients = db.Ingredients.ToList(); gvSelectIngredientsForMeal.DataSource = allIngredients; } }
internal List <Ingredient> GetAllIngredients() { List <Ingredient> ingredients = new List <Ingredient>(); using (var db = new MealGeneratorContext()) { ingredients = db.Ingredients.ToList(); } return(ingredients); }
private void SetIngredientsForIngredientGrid() { List <Ingredient> ingredients = new List <Ingredient>(); using (var db = new MealGeneratorContext()) { ingredients = db.Ingredients.Include(i => i.Meals).ToList(); } gvIngredients.DataSource = ingredients; }
public void SetShoppingLists() { using (var db = new MealGeneratorContext()) { gvShoppingLists.DataSource = db.ShoppingLists .Include(s => s.Meals) .Include("Meals.Ingredients") .Include(s => s.Fruits) .Include(s => s.MiscItems) .ToList(); } }
private void btnRunGenerator_Click(object sender, EventArgs e) { //getActiveMeals; db = new MealGeneratorContext(); ShoppingList shoppingList = new ShoppingList { Meals = GetMeals(), Fruits = GetFruit(), Date = dtDateFrom.Value }; db.ShoppingLists.Add(shoppingList); db.SaveChanges(); }
private BindingList <Meal> GetAllMeals() { List <Meal> meals = new List <Meal>(); using (var db = new MealGeneratorContext()) { meals = db. Meals .Include(a => a.Ingredients) .ToList(); } BindingList <Meal> mealBinded = new BindingList <Meal>(meals); return(mealBinded); }
public RunGeneratorPanel() { InitializeComponent(); gvMeals.AutoGenerateColumns = false; gvFruit.AutoGenerateColumns = false; if (System.ComponentModel.LicenseManager.UsageMode != System.ComponentModel.LicenseUsageMode.Designtime) { using (var db = new MealGeneratorContext()) { gvFruit.DataSource = db.Fruits.ToList(); gvMeals.DataSource = db.Meals.ToList(); } cbNumberOfDays.Items.AddRange(Enumerable.Range(1, 7).Select(i => (object)i).ToArray()); cbNumberOfFruit.Items.AddRange(Enumerable.Range(1, 5).Select(i => (object)i).ToArray()); } }
private async void btnAddFruit_Click(object sender, EventArgs e) { if (tbFruitName.Text == "") { return; } using (var db = new MealGeneratorContext()) { Fruit fruit = new Fruit() { Name = tbFruitName.Text }; db.Fruits.Add(fruit); await db.SaveChangesAsync(); } PopulateFruitGrid(); }