public ActionResult DeleteConfirmed(int id) { Orde orde = db.Ordes.Find(id); db.Ordes.Remove(orde); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "orderID,orderOff,date,userID,addressID,orderStateID")] Orde orde) { if (ModelState.IsValid) { db.Entry(orde).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.addressID = new SelectList(db.Addresses, "addressID", "addressDetail", orde.addressID); ViewBag.orderStateID = new SelectList(db.OrderStates, "orderStateID", "state", orde.orderStateID); ViewBag.userID = new SelectList(db.Users, "userID", "username", orde.userID); return(View(orde)); }
// GET: Orde/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Orde orde = db.Ordes.Find(id); if (orde == null) { return(HttpNotFound()); } return(View(orde)); }
// GET: Orde/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Orde orde = db.Ordes.Find(id); if (orde == null) { return(HttpNotFound()); } ViewBag.addressID = new SelectList(db.Addresses, "addressID", "addressDetail", orde.addressID); ViewBag.orderStateID = new SelectList(db.OrderStates, "orderStateID", "state", orde.orderStateID); ViewBag.userID = new SelectList(db.Users, "userID", "username", orde.userID); return(View(orde)); }
private void saveOrder(User user, Address address, byte paymentTypeID, string paymentCode, DateTime paymentDate, List <Cart> carts) { //dargah if (paymentTypeID == 1) { Orde order = new Orde { orderOff = 0, userID = user.userID, addressID = address.addressID, orderStateID = 4, date = DateTime.Now, paymentTypeID = paymentTypeID, description = "", shippingCost = 0, paymentCode = paymentCode, paymentDate = paymentDate }; db.Ordes.Add(order); db.SaveChanges(); List <OrderProduct> orderProducts = new List <OrderProduct>(); foreach (var item in carts) { if (item.productColorID != null) { var color = db.ProductColors.FirstOrDefault(c => c.productColorID == item.productColorID); OrderProduct orderProduct = new OrderProduct { count = item.count, productID = item.productID, productColorID = color.productColorID, orderID = order.orderID }; orderProducts.Add(orderProduct); } else { OrderProduct orderProduct = new OrderProduct { count = item.count, productID = item.productID, orderID = order.orderID }; orderProducts.Add(orderProduct); } } db.OrderProducts.AddRange(orderProducts); db.SaveChanges(); foreach (var item in orderProducts) { var product = db.Products.Find(item.productID); product.existingCount = product.existingCount - item.count; if (product.existingCount < 1) { product.productStateID = 2; } db.Entry(product).State = EntityState.Modified; } db.SaveChanges(); } else { Orde order = new Orde { orderOff = 0, userID = user.userID, addressID = address.addressID, orderStateID = 4, date = DateTime.Now, paymentTypeID = paymentTypeID, description = "", shippingCost = 0 }; db.Ordes.Add(order); db.SaveChanges(); List <OrderProduct> orderProducts = new List <OrderProduct>(); foreach (var item in carts) { if (item.productColorID != null) { var color = db.ProductColors.FirstOrDefault(c => c.productColorID == item.productColorID); OrderProduct orderProduct = new OrderProduct { count = item.count, productID = item.productID, productColorID = color.productColorID, orderID = order.orderID }; orderProducts.Add(orderProduct); } else { OrderProduct orderProduct = new OrderProduct { count = item.count, productID = item.productID, orderID = order.orderID }; orderProducts.Add(orderProduct); } } db.OrderProducts.AddRange(orderProducts); db.SaveChanges(); foreach (var item in orderProducts) { var product = db.Products.Find(item.productID); product.existingCount = product.existingCount - item.count; if (product.existingCount < 1) { product.productStateID = 2; } db.Entry(product).State = EntityState.Modified; } db.SaveChanges(); } }