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