public ActionResult deleteTrash(int id) { order morder = db.orders.Find(id); var orderDetail = db.ordersdetails.Where(m => m.orderid == morder.ID).ToList(); foreach (var item in orderDetail) { var idd = int.Parse(item.ticketId.ToString()); ticket ticket = db.tickets.Find(idd); ticket.sold = ticket.sold - item.quantity; db.Entry(ticket).State = EntityState.Modified; db.SaveChanges(); } foreach (var orItem in orderDetail) { ordersdetail or = db.ordersdetails.Find(orItem.ID); db.ordersdetails.Remove(or); db.SaveChanges(); } db.orders.Remove(morder); db.SaveChanges(); Message.set_flash("Đã xóa vĩnh viễn 1 Đơn hàng", "success"); return(RedirectToAction("trash")); }
public ActionResult canelOrder(int OrderId) { order morder = db.orders.Find(OrderId); var orderDetail = db.ordersdetails.Where(m => m.orderid == morder.ID).ToList(); foreach (var item in orderDetail) { var id = int.Parse(item.ticketId.ToString()); ticket ticket = db.tickets.Find(id); ticket.sold = ticket.sold - item.quantity; db.Entry(ticket).State = EntityState.Modified; db.SaveChanges(); } var orderdetail = db.ordersdetails.Where(m => m.orderid == morder.ID); foreach (var orItem in orderDetail) { ordersdetail or = db.ordersdetails.Find(orItem.ID); db.ordersdetails.Remove(or); db.SaveChanges(); } db.orders.Remove(morder); db.SaveChanges(); Message.set_flash("Đã hủy 1 đơn hàng", "success"); return(Redirect("~/tai-khoan")); }
public ActionResult AddSDet(ordersdetail ordersdetailmodel, int id) { ordersdetailmodel.OrderId = id; using (QWDBEntities db = new QWDBEntities()) { var GetServicePrice = db.services.Find(ordersdetailmodel.ServiceId).Price; ordersdetailmodel.Price = GetServicePrice; } DetailsLists.ordsd.Add(ordersdetailmodel); return(PartialView("_AddedDet", detailsLists())); }
public ActionResult checkOut(order order, FormCollection fc) { var iddd = 0; user sessionUser = (user)Session[Common.CommonConstants.CUSTOMER_SESSION]; if (sessionUser != null) { iddd = sessionUser.ID; } float total = float.Parse(fc["total"]); order.created_ate = DateTime.Now; order.status = 1; order.total = total; order.CusId = iddd; db.orders.Add(order); db.SaveChanges(); int lastOrderID = order.ID; ordersdetail orderDetail = new ordersdetail(); int id1 = int.Parse(fc["veOnvay"]); orderDetail.ticketId = id1; orderDetail.quantity = order.guestTotal; orderDetail.orderid = lastOrderID; db.ordersdetails.Add(orderDetail); // tru so luong nghe var ticket = db.tickets.Find(id1); ticket.sold = ticket.sold + order.guestTotal; db.Entry(ticket).State = EntityState.Modified; //neu ton tai ve 2 chieu if (!string.IsNullOrEmpty(fc["veReturn"])) { int id2 = int.Parse(fc["veReturn"]); ordersdetail orderDetail2 = new ordersdetail(); orderDetail2.ticketId = id2; orderDetail2.orderid = lastOrderID; orderDetail2.quantity = order.guestTotal; db.ordersdetails.Add(orderDetail2); // tru so luong nghe var ticket2 = db.tickets.Find(id2); ticket2.sold = ticket2.sold + order.guestTotal; db.Entry(ticket2).State = EntityState.Modified; } db.SaveChanges(); return(View("checkOutComfin", order)); }