public ActionResult DeleteConfirmed(int id) { try { Order_line_item order_line_item = db.Order_line_item.Find(id); Order order = db.Orders .Where(a => a.ID == order_line_item.OrderId) .SingleOrDefault(); order.Total_GST = order.Total_GST - order_line_item.GST; order.Total_order_price = order.Total_order_price - order_line_item.Total_price; db.Order_line_item.Remove(order_line_item); db.SaveChanges(); return(RedirectToAction("Index")); } catch (System.Data.Entity.Infrastructure.DbUpdateException ue) { Console.WriteLine(ue.InnerException); // return View("~/Views/Shared/Error.cshtml"); return(View("ActiveRecordException")); // throw; } catch (Exception e) { Console.WriteLine(e.InnerException); // ViewBag.Message = "Foreign key violation"; return(View("Error")); // throw; } }
public ActionResult Edit([Bind(Include = "ID,OrderId,ProductID,Quantity,Price,GST,Total_price")] Order_line_item order_line_item) { try { if (ModelState.IsValid) { // business logic for adding order total Order order = db.Orders .Where(a => a.ID == order_line_item.OrderId) .SingleOrDefault(); // prachi decimal GSTDifference = order_line_item.GSTPrev - order_line_item.GST; if (order.Total_GST == null) { order.Total_GST = 0; } order.Total_GST = order.Total_GST - GSTDifference; if (order.Total_order_price == null) { order.Total_order_price = 0; } decimal TotalPriceDifference = order_line_item.Total_pricePrev - order_line_item.Total_price; order.Total_order_price = order.Total_order_price - TotalPriceDifference; // business logic for adding order total end db.Entry(order_line_item).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ProductID = new SelectList(db.Product_Master, "Id", "Id", order_line_item.ProductID); return(View(order_line_item)); } catch (Exception e) { Console.WriteLine(e.InnerException); return(View("Error")); // throw; } }
public ActionResult Create([Bind(Include = "ID,OrderId,ProductID,Quantity,Price,GST,Total_price")] Order_line_item order_line_item) { try { if (ModelState.IsValid) { db.Order_line_item.Add(order_line_item); db.SaveChanges(); //Business logic for total order price and total gst Order order = db.Orders .Where(a => a.ID == order_line_item.OrderId) .SingleOrDefault(); if (order.Total_GST == null) { order.Total_GST = 0; } order.Total_GST = order_line_item.GST + order.Total_GST; if (order.Total_order_price == null) { order.Total_order_price = 0; } order.Total_order_price = (order_line_item.Total_price) + order.Total_order_price; // total price is nullable db.Entry(order_line_item).State = EntityState.Modified; db.SaveChanges(); //Business logic end return(RedirectToAction("Index")); } ViewBag.ProductID = new SelectList(db.Product_Master, "Id", "Id", order_line_item.ProductID); return(View(order_line_item)); } catch (Exception e) { Console.WriteLine(e.InnerException); return(View("Error")); // throw; } }
// GET: Order_line_item/Details/5 public ActionResult Details(int?id) { try { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Order_line_item order_line_item = db.Order_line_item.Find(id); if (order_line_item == null) { return(HttpNotFound()); } return(View(order_line_item)); } catch (Exception e) { Console.WriteLine(e.InnerException); return(View("Error")); // throw; } }
// GET: Order_line_item/Edit/5 public ActionResult Edit(int?id) { try { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Order_line_item order_line_item = db.Order_line_item.Find(id); if (order_line_item == null) { return(HttpNotFound()); } ViewBag.ProductID = new SelectList(db.Product_Master, "Id", "Id", order_line_item.ProductID); return(View(order_line_item)); } catch (Exception e) { Console.WriteLine(e.InnerException); return(View("Error")); // throw; } }