//this is show order list //Orders public ActionResult Orders(int?id) { if (id != null) { //add prtoduct list var ovs = new List <oPtbl>(); var oproduct = db.order_product_tbl.Where(a => a.order_id == id).ToList(); //add product in list foreach (var o in oproduct) { var ov = new oPtbl(); ov.order_product_id = o.order_product_id; ov.product_id = o.product_id; ov.price = o.price; ov.total = o.total; //check pvv null if (o.varints != null && o.varints != "null") { //decode json List <int> v = JsonConvert.DeserializeObject <List <int> >(o.varints); //initail list List <pvriantS> pv = new List <pvriantS>(); foreach (var i in v) { //get varint valu var value = db.product_variant_value.Find(i); pv.Add(new pvriantS { price = Convert.ToDecimal(value.price), variantName = value.variant_name, varintUnit = value.variant_unit_name, pvvID = value.pvvID, }); } //add in list ov.pvriant = pv; } else { ov.varints = null; } ov.name = o.name; ov.quantity = o.quantity; ovs.Add(ov); } return(View(ovs)); } else { return(RedirectToAction("Index")); } }
//View Order Detiels public ActionResult View(int?id) { if (id != null) { //initila order vm model order_vm ovm = new order_vm(); //get all order detials var order = db.order_tbl.Find(id); if (order != null) { //add data in order_vm ovm.customer_id = order.customer_id; ovm.payment_address_1 = order.payment_address_1; ovm.payment_address_2 = order.payment_address_2; ovm.firstname = order.firstname; ovm.lastname = order.lastname; ovm.payment_method = order.payment_method; ovm.payment_telephone = order.payment_telephone; ovm.telephone = order.telephone; ovm.date_added = order.date_added; ovm.shipping_method = order.shipping_method; //this is total price ovm.total = order.total; ovm.invoice_no = order.invoice_no; ovm.invoice_prefix = order.invoice_prefix; //add shipping detials ovm.shipping_firstname = order.shipping_firstname; ovm.shipping_lastname = order.shipping_lastname; ovm.shipping_telephone = order.shipping_telephone; ovm.order_id = order.order_id; ovm.shipping_address_1 = order.shipping_address_1; ovm.shipping_address_2 = order.shipping_address_2; //add adition data ovm.comment = order.comment; ovm.status_name = order.order_status; ovm.sAmount = Convert.ToDecimal(order.amont); //add prtoduct list var ovs = new List <oPtbl>(); var oproduct = db.order_product_tbl.Where(a => a.order_id == id).ToList(); //add product in list foreach (var o in oproduct) { var ov = new oPtbl(); ov.order_product_id = o.order_product_id; ov.product_id = o.product_id; ov.price = o.price; ov.total = o.total; ov.discount = Convert.ToDecimal(o.dicount); //check pvv null if (o.varints != null && o.varints != "null") { //decode json List <int> v = JsonConvert.DeserializeObject <List <int> >(o.varints); //initail list List <pvriant> pv = new List <pvriant>(); foreach (var i in v) { //get varint valu var value = db.product_variant_value.Find(i); pv.Add(new pvriant { price = Convert.ToDecimal(value.price), variantName = value.variant_name, varintUnit = value.variant_unit_name, pvvID = value.pvvID, }); //if (ovm.status_name == "Shipped") //{ // //upddate the quantity // value.quentity -= o.quantity; // db.Entry(value).State = EntityState.Modified; // db.SaveChanges(); //} } //add in list ov.varints = pv; } else { ov.varints = null; } ov.name = o.name; ov.quantity = o.quantity; //if (ovm.status_name == "Shipped ") //{ // //update quantity form product table // var p = db.product_tbl.Find(ov.product_id); // p.quantity -= o.quantity; // db.Entry(p).State = EntityState.Modified; // db.SaveChanges(); //} ov.reward = o.reward; ovs.Add(ov); } ovm.orderProductList = ovs; //show all order history ViewBag.ToolList = new SelectList(db.order_history_tbl.ToList(), "order_status_id", "name"); ViewBag.WareHouse = new SelectList(db.Warehouse_tbl.ToList(), "warehouse_id", "w_name"); return(View(ovm)); } return(RedirectToAction("Index")); } else { return(RedirectToAction("Index")); } }
public ActionResult orderEdit(int?id) { //first order table update if (id != null) { //initila order vm model order_vm ovm = new order_vm(); //get all order detials var order = db.order_tbl.Find(id); if (order != null) { //add data in order_vm ovm.customer_id = order.customer_id; ovm.payment_address_1 = order.payment_address_1; ovm.payment_address_2 = order.payment_address_2; ovm.firstname = order.firstname; ovm.lastname = order.lastname; ovm.payment_method = order.payment_method; ovm.payment_telephone = order.payment_telephone; ovm.telephone = order.telephone; ovm.date_added = order.date_added; ovm.order_status = order.order_status; //this is total price ovm.total = order.total; ovm.invoice_prefix = order.invoice_prefix; ovm.invoice_no = order.invoice_no; //add shipping detials ovm.shipping_firstname = order.shipping_firstname; ovm.shipping_lastname = order.shipping_lastname; ovm.shipping_telephone = order.shipping_telephone; ovm.order_id = order.order_id; ovm.shipping_address_1 = order.shipping_address_1; ovm.shipping_address_2 = order.shipping_address_2; ovm.email = order.email; ovm.comment = order.comment; //add adition data ovm.status_name = order.order_status; //add prtoduct list var ovs = new List <oPtbl>(); var oproduct = db.order_product_tbl.Where(a => a.order_id == id).ToList(); //add product in list foreach (var o in oproduct) { var ov = new oPtbl(); ov.product_id = o.product_id; ov.price = o.price; ov.total = o.total; ov.order_product_id = o.order_product_id; //check pvv null if (o.varints != null && o.varints != "null") { //decode json List <int> v = JsonConvert.DeserializeObject <List <int> >(o.varints); //initail list List <pvriant> pv = new List <pvriant>(); foreach (var i in v) { //get varint valu var value = db.product_variant_value.Find(i); pv.Add(new pvriant { price = Convert.ToDecimal(value.price), variantName = value.variant_name, varintUnit = value.variant_unit_name, pvvID = value.pvvID, }); } //add in list ov.varints = pv; } else { ov.varints = null; } ov.name = o.name; ov.quantity = o.quantity; ov.reward = o.reward; ovs.Add(ov); } ovm.orderProductList = ovs; //show all order history return(View(ovm)); } ViewBag.Message = TempData["Message"]; ViewBag.Status = TempData["Status"]; return(RedirectToAction("index")); } else { return(RedirectToAction("index")); } }