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
}
}
