public ActionResult OrderCancelCheck(int orderid) { using (var db = new Database1Entities1()) { ViewBag.OrderId = orderid; var ItemList = db.OrderMixes.ToList(); var dlist = new List <OrderMixViewModel>(); foreach (var item in ItemList) { if (orderid == item.OrderId) { var e = new OrderMixViewModel(item); dlist.Add(e); } } return(View(dlist)); } }
public ActionResult OrderConfirm() { var salmons = new List <ConfirmViewModel>(); using (var db = new Database1Entities1()) { //注文番号 var order = db.Orders.ToList(); ViewBag.order = order; //明細の情報を入れる var ItemList = db.OrderMixes.ToList(); var dlist = new List <OrderMixViewModel>(); foreach (var item in ItemList) { var e = new OrderMixViewModel(item); dlist.Add(e); } //ボタンの表示 int num1 = 1; foreach (var i in order) { int num2 = 0; for (int n = 0; n < dlist.Count(); n++) { if (i.OrderId == dlist[n].OrderId) { if (dlist[n].Status != "未出荷") { num2 += 1; } } } salmons.Add(new ConfirmViewModel { No = num1, Check = num2 }); num1 += 1; } ViewBag.Button = salmons; return(View(dlist)); }; }
public ActionResult OrderCancel(int orderid) { using (var db = new Database1Entities1()) { var ItemList = db.OrderMixes.ToList(); var dlist = new List <OrderMixViewModel>(); foreach (var item in ItemList) { if (orderid == item.OrderId) { var e = new OrderMixViewModel(item); var ul = db.OrderMixes.Find(item.OrderMixId); ul.Status = "キャンセル"; db.SaveChanges(); } } } return(Redirect("OrderConfirm")); }
// GET: Order public ActionResult OrderAdd() { Session["customerid"] = 1; int subPrice = 0; int tax = 0; int totalPrice = 0; using (var db = new Database1Entities1()) { var carts = db.Carts.ToList(); foreach (var i in carts) { subPrice += i.Price; } tax = (int)Math.Truncate(subPrice * 0.08); totalPrice = subPrice + tax; var order = new Order { CustomerId = (int)Session["customerid"], SubPrice = subPrice, Tax = tax, TotalPrice = totalPrice, OrderDate = DateTime.Now }; db.Orders.Add(order); db.SaveChanges(); int lastOrderId = db.Orders.Max(model => model.OrderId); int num = 1; foreach (var i in carts) { var orderdetail = new OrderMix { OrderId = lastOrderId, OrderDetailId = num, ItemId = i.ItemId, ItemName = i.ItemName, UnitPrice = i.UnitPrice, Quantity = i.Quantity, Price = i.Price, DeliveryDate = DateTime.Parse(i.DeliveryDate), Status = "未出荷", CustomerId = (int)Session["customerid"], SubPrice = order.SubPrice, Tax = order.Tax, TotalPrice = order.TotalPrice, OrderDate = order.OrderDate }; db.OrderMixes.Add(orderdetail); var u = db.Carts.Find(i.CartId); db.Carts.Remove(u); db.SaveChanges(); num += 1; } var orderList = db.Orders.Find(lastOrderId); ViewBag.Order = orderList; var ItemList = db.OrderMixes.ToList(); var dlist = new List <OrderMixViewModel>(); foreach (var item in ItemList) { if (orderList.OrderId == item.OrderId) { var e = new OrderMixViewModel(item); dlist.Add(e); } } return(View(dlist)); } }