//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"));
}
}
