public ActionResult Create([Bind(Include = "COURIER,ADDRESS,CUSTOMER_ID")] ORDER Order) { if (ModelState.IsValid) { List <Item> cart = (List <Item>)Session["cart"]; ORDER_DETAILS od; Order.CUSTOMER_ID = User.Identity.GetUserId(); Order.DATE_ORDERED = DateTime.Now; db.ORDERS.Add(Order); foreach (Item item in cart) { od = new ORDER_DETAILS(); od.ORDER_ID = db.ORDERS.Find(Order.ID).ID; od.PRODUCT_ID = item.Product.ID; od.QUANTITY = item.Quantity; db.ORDER_DETAILS.Add(od); } db.SaveChanges(); Session["cart"] = null; return(RedirectToAction("Index", "Success")); } ViewBag.CUSTOMER_ID = new SelectList(db.AspNetUsers, "Id", "Email", Order.CUSTOMER_ID); return(View(Order)); }
public decimal UpdateQuantity(int id, int id_product, int quantity) { try { ORDER_DETAILS _ORDER_DETAIL = db.ORDER_DETAILS.Where(n => n.ORDER_ID == id && n.PRODUCT_ID == id_product).SingleOrDefault(); ORDER _ORDER = db.ORDERS.Find(id); _ORDER_DETAIL.QUANTITY = quantity; decimal _Total_Before = _ORDER_DETAIL.EXTENDED_PRICE; _ORDER_DETAIL.EXTENDED_PRICE = _ORDER_DETAIL.UNIT_PRICE * quantity; _ORDER.SUBTOTAL += (_ORDER_DETAIL.EXTENDED_PRICE - _Total_Before); db.SaveChanges(); return(_ORDER.SUBTOTAL); } catch (Exception ex) { return(0); // 404 } }
public int DeleteProductFromOrder(int order_id, int product_id) { try { ORDER_DETAILS ORDER_DETAILS = db.ORDER_DETAILS.Where(n => n.ORDER_ID == order_id && n.PRODUCT_ID == product_id).SingleOrDefault(); ORDER ORDER = db.ORDERS.Find(order_id); ORDER.SUBTOTAL = ORDER.SUBTOTAL - ORDER_DETAILS.EXTENDED_PRICE; db.ORDER_DETAILS.Remove(ORDER_DETAILS); db.SaveChanges(); int numProducts = db.ORDER_DETAILS.Where(n => n.ORDER_ID == order_id).ToList().Count; if (numProducts == 0) { ORDER.ORDER_STATUS_ID = 4; } db.SaveChanges(); return(numProducts); } catch (Exception ex) { return(0); } }
private bool CreateOrder(ORDER order, SubmitOrderModel data) { MobileStoreServiceEntities db = new MobileStoreServiceEntities(); double orderTotal = 0; try { // Iterate over the items in the cart, // adding the order details for each foreach (var item in data.order_info) { PRODUCT product = db.PRODUCTs.First(x => x.PRODUCT_ID == item.product_id); product.QUANTITY -= item.quantity; var orderDetail = new ORDER_DETAILS { PRODUCT_ID = item.product_id, ORDER_ID = order.ORDER_ID, UNIT_PRICE = item.unit_price, QUANTITY = item.quantity }; // Set the order total of the shopping cart orderTotal += (item.quantity * item.unit_price); db.ORDER_DETAILS.Add(orderDetail); } // Set the order's total to the orderTotal count ORDER nOrder = db.ORDERS.First(o => o.ORDER_ID == order.ORDER_ID); nOrder.TOTAL = orderTotal; // Save the order db.SaveChanges(); } catch { return(false); } // Return the OrderId as the confirmation number return(true); }
public ActionResult OrderNow(OrderModel orderModel) { ORDER_DETAILS order = new ORDER_DETAILS(); try { order.ORDER_ID = orderModel.ORDER_ID; order.SPECS_ID = orderModel.SPECS_ID; order.SPECS_NAME = orderModel.SPECS_NAME; order.FRAME_TYPE = orderModel.FRAME_TYPE; order.LEFT_EYEPOWER = orderModel.LEFT_EYEPOWER; order.RIGHT_EYEPOWER = orderModel.RIGHT_EYEPOWER; order.SPECS_PRICE = orderModel.SPECS_PRICE; order.EMAILID = orderModel.EMAILID; specsDetailsEntities.ORDER_DETAILS.Add(order); specsDetailsEntities.SaveChanges(); ViewBag.Message = "Placed Your order Sucessfully"; } catch (Exception) { ViewBag.message = "Error"; } return(RedirectToAction("ViewOrderedDetails")); }
public ActionResult Create(FormCollection f) { try { string _Name = f.Get("Name").ToString(); string _Address = f.Get("Address").ToString(); string _Note = f.Get("Note").ToString(); string _Email = f.Get("Email").ToString(); string _Mobile = f.Get("Mobile").ToString(); int _ShipVia = int.Parse(f.Get("ListShipper").ToString()); if (Session["Order_Id"] == null) { ORDER _ORDER = new ORDER(); ORDER_DETAILS _ORDER_DETAILS = null; USER _USER = (USER)Session["SS_USER"]; if (_USER != null) { _ORDER.USER_ID = _USER.USER_ID; } else { _ORDER.USER_ID = 0; } _ORDER.ORDER_CODE = m_STRING_RAMDOM.RandomString(); _ORDER.ORDER_DATE = DateTime.Now; _ORDER.SHIP_NAME = _Name; _ORDER.SHIP_ADDRESS = _Address; _ORDER.SHIP_PHONE = _Mobile; _ORDER.SHIP_EMAIL = _Email; _ORDER.NOTE = _Note; _ORDER.ORDER_STATUS_ID = 3; _ORDER.SHIP_VIA_ID = _ShipVia; _ORDER.FREIGHT = (decimal)db.SHIPPERS.Single(n => n.SHIPPER_ID == _ORDER.SHIP_VIA_ID).FREIGHT; _ORDER.SUBTOTAL = decimal.Parse(Session["TOTAL_PRICE"].ToString()); db.ORDERS.Add(_ORDER); db.SaveChanges(); List <ProductCart> _lstProductCart = (List <ProductCart>)Session["ShoppingCart"]; foreach (var product in _lstProductCart) { _ORDER_DETAILS = new ORDER_DETAILS(); _ORDER_DETAILS.ORDER_ID = _ORDER.ORDER_ID; _ORDER_DETAILS.PRODUCT_ID = product.PRODUCT_ID; _ORDER_DETAILS.UNIT_PRICE = product.UNIT_PRICE; _ORDER_DETAILS.UNIT = product.UNIT; _ORDER_DETAILS.QUANTITY = product.QUANTITY; _ORDER_DETAILS.EXTENDED_PRICE = product.TOTAL_PRICE; db.ORDER_DETAILS.Add(_ORDER_DETAILS); } db.SaveChanges(); Session["Order_Id"] = _ORDER.ORDER_ID; } else { int _Order_Id = (int)Session["Order_Id"]; ORDER _ORDER = db.ORDERS.Find(_Order_Id); USER _USER = (USER)Session["SS_USER"]; if (_USER != null) { _ORDER.USER_ID = _USER.USER_ID; } else { _ORDER.USER_ID = 0; } _ORDER.ORDER_CODE = m_STRING_RAMDOM.RandomString(); _ORDER.ORDER_DATE = DateTime.Now; _ORDER.SHIP_NAME = _Name; _ORDER.SHIP_ADDRESS = _Address; _ORDER.SHIP_PHONE = _Mobile; _ORDER.SHIP_EMAIL = _Email; _ORDER.NOTE = _Note; _ORDER.ORDER_STATUS_ID = 3; _ORDER.SHIP_VIA_ID = _ShipVia; _ORDER.FREIGHT = (decimal)db.SHIPPERS.Single(n => n.SHIPPER_ID == _ORDER.SHIP_VIA_ID).FREIGHT; _ORDER.SUBTOTAL = decimal.Parse(Session["TOTAL_PRICE"].ToString()); db.SaveChanges(); Session["Order_Id"] = _ORDER.ORDER_ID; } return(RedirectToAction("Payment", "Payment")); } catch (Exception ex) { return(RedirectToAction("Http404", "Error")); // 404 } }