public ActionResult Create([Bind(Include = "Id,OrderId,MealId")] Order_Meal order_Meal) { if (ModelState.IsValid) { try { db.Order_Meal.Add(order_Meal); db.SaveChanges(); Meal meal = db.Meal.Find(order_Meal.MealId); db.Order.Find(order_Meal.OrderId).Price += meal.Price; db.SaveChanges(); } catch { ViewBag.Error = true; ViewBag.OrderId = order_Meal.OrderId; ViewBag.MealId = new SelectList(db.Meal, "Id", "Name"); return(View()); } ViewBag.Error = false; ViewBag.OrderId = order_Meal.OrderId; ViewBag.MealId = new SelectList(db.Meal, "Id", "Name"); return(View()); } ViewBag.MealId = new SelectList(db.Meal, "Id", "Name"); return(View(order_Meal)); }
// GET: Order_Meal/Edit/5 //public ActionResult Edit(int? id) //{ // if (id == null) // { // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); // } // Order_Meal order_Meal = db.Order_Meal.Find(id); // if (order_Meal == null) // { // return HttpNotFound(); // } // ViewBag.MealId = new SelectList(db.Meal, "Id", "Name", order_Meal.MealId); // ViewBag.OrderId = new SelectList(db.Order, "Id", "WaiterId", order_Meal.OrderId); // return View(order_Meal); //} // POST: Order_Meal/Edit/5 // Aby zapewnić ochronę przed atakami polegającymi na przesyłaniu dodatkowych danych, włącz określone właściwości, z którymi chcesz utworzyć powiązania. // Aby uzyskać więcej szczegółów, zobacz https://go.microsoft.com/fwlink/?LinkId=317598. //[HttpPost] //[ValidateAntiForgeryToken] //public ActionResult Edit([Bind(Include = "Id,OrderId,MealId")] Order_Meal order_Meal) //{ // if (ModelState.IsValid) // { // db.Entry(order_Meal).State = EntityState.Modified; // db.SaveChanges(); // return RedirectToAction("Index"); // } // ViewBag.MealId = new SelectList(db.Meal, "Id", "Name", order_Meal.MealId); // ViewBag.OrderId = new SelectList(db.Order, "Id", "WaiterId", order_Meal.OrderId); // return View(order_Meal); //} // GET: Order_Meal/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Order_Meal order_Meal = db.Order_Meal.Find(id); if (order_Meal == null) { return(HttpNotFound()); } return(View(order_Meal)); }
private void SeedOrder_Meal(RestaurantContext context) { for (int i = 1; i < 10; i++) { var omeal = new Order_Meal() { Id = i, OrderId = 10 - i, MealId = i / 2 + 1, }; context.Set <Order_Meal>().AddOrUpdate(omeal); } context.SaveChanges(); }
public ActionResult DeleteConfirmed(int id) { Order_Meal order_Meal = db.Order_Meal.Find(id); int orderId = order_Meal.OrderId; db.Order_Meal.Remove(order_Meal); db.SaveChanges(); Meal meal = db.Meal.Find(order_Meal.MealId); db.Order.Find(order_Meal.OrderId).Price -= meal.Price; db.SaveChanges(); return(RedirectToAction("Index", new { orderId })); }