public ActionResult Updateorder(WarehouseOrderJoin warehouseOrderJoin) { int x = Int32.Parse(Request.Form["WOsNo"]); int y = Int32.Parse(Request.Form["WODsNo"]); var orders = _context.WarehouseOrders.SingleOrDefault(o => o.SNo == x); var orderdetail = _context.WarehouseOrderDetails.SingleOrDefault(o => o.SNo == y); var productPrice = _context.WarehouseProducts.SingleOrDefault(p => p.PId == warehouseOrderJoin.WarehouseOrderj.PId); var tprice = warehouseOrderJoin.WarehouseOrderj.PQuantity * productPrice.Price; orders.OId = warehouseOrderJoin.WarehouseOrderDetailj.OrderID; orderdetail.OrderID = warehouseOrderJoin.WarehouseOrderDetailj.OrderID; orders.PId = warehouseOrderJoin.WarehouseOrderj.PId; orders.Notification = 2; orders.PQuantity = warehouseOrderJoin.WarehouseOrderj.PQuantity; orders.TotalPrice = tprice; orderdetail.Sender = Request.Form["OrderSender"]; orderdetail.Receiver = Request.Form["OrderReciever"]; _context.SaveChanges(); return(Redirect("~/Warehouse/Orders")); }
public ActionResult EditOrder(string id, string WOsNo, String WODsNo) { int x = Int32.Parse(WOsNo); int y = Int32.Parse(WODsNo); var orders = _context.WarehouseOrders.SingleOrDefault(o => o.SNo == x); var orderdetail = _context.WarehouseOrderDetails.SingleOrDefault(o => o.SNo == y); var ordertype = _context.WarehouseOrderTypes.SingleOrDefault(o => o.OId == id); if (orders == null) { return(HttpNotFound()); } var Warehouseorderjoin = new WarehouseOrderJoin(); Warehouseorderjoin.WarehouseOrderj = orders; Warehouseorderjoin.WarehouseOrderDetailj = orderdetail; Warehouseorderjoin.WarehouseOrderTypej = ordertype; return(View(Warehouseorderjoin)); }
public ActionResult AddOrder(WarehouseOrderJoin warehouseOrderJoin) { var OrderId = Request.Form["OrderID"]; var date = Request.Form["date"]; var orderType = Int32.Parse(Request.Form["OrderType"]); var orderSender = Request.Form["OrderSender"]; var OrderReciever = Request.Form["OrderReciever"]; bool condition = false; int NoOfProducts = Int32.Parse(Request.Form["length"]); double price = 0; for (int i = 0; i <= NoOfProducts; i++) { var product = Request.Form["PID[" + i + "]"]; var quatity = Int32.Parse(Request.Form["PQ[" + i + "]"]); var stockInDb = _context.WarehouseStocks.SingleOrDefault(p => p.ProductID == product); var productInDb = _context.WarehouseProducts.SingleOrDefault(p => p.PId == product); if (stockInDb != null) { if (stockInDb.Quantity >= quatity) { condition = true; } else { condition = false; break; } } else if (productInDb != null) { condition = false; break; } else { condition = false; break; } } if (condition == true) { for (int i = 0; i <= NoOfProducts; i++) { var product = Request.Form["PID[" + i + "]"]; var quatity = Int32.Parse(Request.Form["PQ[" + i + "]"]); if (product == null || product == "") { } else { var Order = new WarehouseOrder(); var OrderDetail = new WarehouseOrderDetail(); var OrderType = new WarehouseOrderType(); var stockInDb = _context.WarehouseStocks.SingleOrDefault(p => p.ProductID == product); try { //Calculating price for each product w.r.t to quantity var productPrice = _context.WarehouseProducts.SingleOrDefault(p => p.PId == product); var tprice = quatity * productPrice.Price; Order.TotalPrice = tprice; } catch (Exception e) { continue; } //Setting Id to all of them Order.OId = OrderId; Order.Notification = 0; OrderDetail.OrderID = OrderId; OrderType.OId = OrderId; //Setting remaining instances Order.PId = Request.Form["PID[" + i + "]"]; Order.PQuantity = Int32.Parse(Request.Form["PQ[" + i + "]"]); Order.Date = DateTime.Parse(date); OrderDetail.Receiver = OrderReciever; OrderDetail.Sender = orderSender; if (i == 0) { OrderType.type = orderType; _context.WarehouseOrderDetails.Add(OrderDetail); _context.WarehouseOrderTypes.Add(OrderType); } try { _context.WarehouseOrders.Add(Order); _context.SaveChanges(); } catch (Exception e) { Debug.WriteLine(e.ToString()); } } } } else { return(Redirect("~/Warehouse/OrderError")); } return(Redirect("~/Warehouse/Orders")); }