public void Build() { using (var context = new DinnerManagerContext("DinnerManager")) { // clear database foreach (var m in context.Meals) { context.Meals.Remove(m); } foreach (var d in context.Dishes) { context.Dishes.Remove(d); } var spaghetti = new DishBuilder().WithDescription("Annick's befaamde spaghetti") .WithName("Spaghetti bolognaise") .WithRating(5) .Build(); context.Dishes.Add(spaghetti); var visVidee = new DishBuilder().WithName("Vis videe") .Build(); context.Dishes.Add(visVidee); var vispannetje = new DishBuilder().WithName("Vispannetje") .Build(); context.Dishes.Add(vispannetje); var couscous = new DishBuilder().WithName("Couscous met scampi's") .Build(); context.Dishes.Add(couscous); var today = new MealBuilder().WithDate(DateTime.Now) .WithDish(visVidee) .Build(); context.Meals.Add(today); var tomorrow = new MealBuilder().WithDate(DateTime.Now.AddDays(1)) .WithDish(spaghetti) .Build(); context.Meals.Add(tomorrow); var dayAfterTomorrow = new MealBuilder().WithDate(DateTime.Now.AddDays(2)) .WithDish(vispannetje) .Build(); context.Meals.Add(dayAfterTomorrow); var sameDayNextWeek = new MealBuilder().WithDate(DateTime.Now.AddDays(7)) .WithDish(couscous) .Build(); context.Meals.Add(sameDayNextWeek); var nextWeek = new MealBuilder().WithDate(DateTime.Now.AddDays(10)) .Build(); context.Meals.Add(nextWeek); context.SaveChanges(); } }
public ActionResult Create(CreateMealViewModel m) { using (var context = new DinnerManagerContext()) { context.Meals.Add(new Meal { Date = m.Date, Dish = context.Dishes.Single(d => d.Id == m.SelectedDishId) }); context.SaveChanges(); } return RedirectToAction("Index", "Home"); }
public JsonResult UpdateMeal(int id, DateTime start) { using (var context = new DinnerManagerContext()) { try { var meal = context.Meals.Single(m => m.Id == id); meal.Date = start; context.SaveChanges(); return Json(new { success = true }); } catch (Exception) { return Json(new { success = false, message = "Er liep iets mis bij het opslaan van de nieuwe datum" }); } } }