public ActionResult Create(tbl_Orders tbl_orders)
{
if (ModelState.IsValid)
{
db.tbl_Orders.Add(tbl_orders);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.CustomerID = new SelectList(db.tbl_Customers, "CustomerID", "CustomerName", tbl_orders.CustomerID);
return View(tbl_orders);
}
public ActionResult OrderComplete(string name, string address, string email, string phone, string cardid)
{
tbl_Customers cus = db.tbl_Customers.Where(a => a.Email == email || a.Phone == phone).FirstOrDefault();
if (cus == null)
{
cus = new tbl_Customers();
cus.CustomerName = name;
cus.Address = address;
cus.Email = email;
cus.Phone = phone;
cus.CardID = cardid;
db.tbl_Customers.Add(cus);
db.SaveChanges();
}
tbl_Orders order = new tbl_Orders();
order.CustomerID = cus.CustomerID;
order.CreateDate = DateTime.Now;
order.Status = laca.Models.OrderStatus.Order;
db.tbl_Orders.Add(order);
db.SaveChanges();
List<tbl_OrderDetail> list = Session[Session.SessionID] as List<tbl_OrderDetail>;
foreach (var item in list)
{
item.tbl_Items = null;
item.OrderID = order.OrderID;
db.tbl_OrderDetail.Add(item);
db.SaveChanges();
}
return Json(new { url = Url.Action("ThankYou", new { id = order.OrderID }) });
//return View();
}
public ActionResult Edit(tbl_Orders tbl_orders, OrderStatus currStatus)
{
var date = DateTime.Now;
tbl_orders.DeliveryDate = null;
string[] s = (Request.Form["datepicker"] + "").Split('/');
try
{
date = new DateTime(Convert.ToInt16(s[2]), Convert.ToInt16(s[1]), Convert.ToInt16(s[0]));
tbl_orders.DeliveryDate = date;
}
catch (Exception e) { if (tbl_orders.Status == OrderStatus.Delivery)ModelState.AddModelError("DeliveryDate", "Ngày giao hàng chưa đúng"); }
if (ModelState.IsValid)
{
//tbl_Orders currOrder = db.tbl_Orders.Find(tbl_orders.OrderID);
if (tbl_orders.Status == OrderStatus.Delivery && currStatus == OrderStatus.Order)
{
foreach (var item in db.tbl_OrderDetail.Where(a=>a.OrderID == tbl_orders.OrderID))
{
tbl_Items sp = db.tbl_Items.Find(item.ItemID);
sp.ItemCount -= item.Qty.Value;
db.Entry(sp).State = EntityState.Modified;
}
}
if (tbl_orders.Status != OrderStatus.Delivery && currStatus == OrderStatus.Delivery)
{
foreach (var item in db.tbl_OrderDetail.Where(a => a.OrderID == tbl_orders.OrderID))
{
tbl_Items sp = db.tbl_Items.Find(item.ItemID);
sp.ItemCount += item.Qty.Value;
db.Entry(sp).State = EntityState.Modified;
}
}
db.Entry(tbl_orders).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
tbl_orders = db.tbl_Orders.Find(tbl_orders.OrderID);
ViewBag.Customer = db.tbl_Customers.Find(tbl_orders.CustomerID).CustomerName;
ViewBag.DeliveryDate = tbl_orders.DeliveryDate == null ? "" : tbl_orders.DeliveryDate.Value.ToString("dd/MM/yyyy");
ViewBag.Amount = tbl_orders.tbl_OrderDetail.Sum(a => a.Amount).Value.ToString("#,###");
return View(tbl_orders);
}
