public ActionResult orderEdit(order_vm ovm)
{
//order table instans
order_tbl otb = new order_tbl();
otb.order_id = ovm.order_id;
otb.payment_address_1 = ovm.payment_address_1;
otb.lastname = ovm.lastname;
otb.firstname = ovm.firstname;
otb.total = ovm.total;
otb.customer_id = ovm.customer_id;
otb.order_status = ovm.order_status;
otb.comment = ovm.comment;
otb.date_added = ovm.date_added;
otb.invoice_no = ovm.invoice_no;
otb.invoice_prefix = ovm.invoice_prefix;
otb.email = ovm.email;
otb.payment_telephone = ovm.payment_telephone;
otb.payment_method = ovm.payment_method;
otb.shipping_address_1 = ovm.shipping_address_1;
otb.shipping_telephone = ovm.shipping_telephone;
otb.date_modified = DateTime.Now;
db.Entry(otb).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("View", new { id = ovm.order_id }));
}
public ActionResult orderStatus(order_vm ovm)
{
if (ovm.status_name != null && ovm.order_id != 0)
{
var order = db.order_tbl.Find(ovm.order_id);
order.order_status = ovm.status_name;
order.WareHouseID = ovm.warehouse_id;
order.comment = ovm.comment;
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
//save order history
order_history_tbl oh = new order_history_tbl();
oh.notify = ovm.notify;
oh.order_id = ovm.order_id;
oh.order_status = ovm.status_name;
oh.date_added = DateTime.Now;
oh.comment = ovm.comment;
oh.user_id = User.Identity.GetUserId();
db.order_history_tbl.Add(oh);
db.SaveChanges();
if (ovm.notify == true)
{
//get heare customer id
//send email in customer
}
var os = db.order_status_tbl.Find(71);
if (oh.order_status == os.name)
{
//change the status name;
var ord = db.order_tbl.Find(ovm.order_id);
ord.order_status = ord.order_status + ".";
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
}
else
{
}
message = "Order History created";
status = true;
}
else
{
message = "There Are some Problems history is no created";
}
TempData["Message"] = message;
TempData["Status"] = status;
return(RedirectToAction("View", new { id = ovm.order_id }));
}
//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"));
}
}
