public IHttpActionResult PutC_Order(long id, C_Order c_Order) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != c_Order.OrderID) { return(BadRequest()); } db.Entry(c_Order).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!C_OrderExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult DeleteConfirmed(int id) { C_Order c_Order = db.C_Order.Find(id); db.C_Order.Remove(c_Order); db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <ActionResult> DeleteConfirmed(int id) { C_Order c_Order = await db.C_Order.FindAsync(id); db.C_Order.Remove(c_Order); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,User_Id,Order_date")] C_Order c_Order) { if (ModelState.IsValid) { db.Entry(c_Order).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.User_Id = new SelectList(db.AspNetUsers, "Id", "Email", c_Order.User_Id); return(View(c_Order)); }
public async Task <ActionResult> Edit([Bind(Include = "Id,OwerId,Available,CreateBy,EditBy,CreateDate,EditDate,TableNumber,Payed")] C_Order c_Order) { if (ModelState.IsValid) { db.Entry(c_Order).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.OwerId = new SelectList(db.AspNetUsers, "Id", "Email", c_Order.OwerId); return(View(c_Order)); }
public ActionResult Create([Bind(Include = "Id,User_Id,Order_date")] C_Order c_Order) { if (ModelState.IsValid) { db.C_Order.Add(c_Order); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.User_Id = new SelectList(db.AspNetUsers, "Id", "Email", c_Order.User_Id); return(View(c_Order)); }
// GET: DefaultOrder/Details/5 public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } C_Order c_Order = await db.C_Order.FindAsync(id); if (c_Order == null) { return(HttpNotFound()); } return(View(c_Order)); }
public async Task <IHttpActionResult> DeleteC_Order(int id) { C_Order c_Order = await db.C_Order.FindAsync(id); if (c_Order == null) { return(NotFound()); } db.C_Order.Remove(c_Order); await db.SaveChangesAsync(); return(Ok(c_Order)); }
// GET: C_Order/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } C_Order c_Order = db.C_Order.Find(id); if (c_Order == null) { return(HttpNotFound()); } return(View(c_Order)); }
// GET: DefaultOrder/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } C_Order c_Order = await db.C_Order.FindAsync(id); if (c_Order == null) { return(HttpNotFound()); } ViewBag.OwerId = new SelectList(db.AspNetUsers, "Id", "Email", c_Order.OwerId); return(View(c_Order)); }
// GET: C_Order/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } C_Order c_Order = db.C_Order.Find(id); if (c_Order == null) { return(HttpNotFound()); } ViewBag.User_Id = new SelectList(db.AspNetUsers, "Id", "Email", c_Order.User_Id); return(View(c_Order)); }
public IHttpActionResult DeleteC_Order(long id) { C_Order c_Order = db.C_Order.Include(y => y.OrderItems) .SingleOrDefault(x => x.OrderID == id); //delete from orderItem table foreach (var item in c_Order.OrderItems.ToList()) { db.OrderItems.Remove(item); } db.C_Order.Remove(c_Order); db.SaveChanges(); return(Ok(c_Order)); }
public async Task <ActionResult> Create([Bind(Include = "Id,OwerId,Available,CreateBy,EditBy,CreateDate,EditDate,TableNumber,Payed")] C_Order c_Order) { c_Order.CreateBy = User.Identity.Name; c_Order.EditBy = User.Identity.Name; c_Order.CreateDate = DateTime.Now; c_Order.EditDate = DateTime.Now; c_Order.Available = true; if (ModelState.IsValid) { db.C_Order.Add(c_Order); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.OwerId = new SelectList(db.AspNetUsers, "Id", "Email", c_Order.OwerId); return(View(c_Order)); }
public ActionResult Payment(FormCollection values) { var order = new C_Order(); TryUpdateModel(order); var user = db.AspNetUsers.Single( u => u.Id == User.Identity.GetUserId() && u.Credit_Card != null); try { if (user.Credit_Card != null) { order.User_Id = User.Identity.GetUserId(); order.Order_date = DateTime.Now; order.Cart_Id = Cart.GetCartId(this.HttpContext); db.C_Order.Add(order); db.SaveChanges(); var cart = Cart.GetCart(this.HttpContext); return(RedirectToAction(actionName: "Complete", routeValues: new { id = order.Id })); } else { return(RedirectToAction(actionName: "Create", controllerName: "Credit_Card", routeValues: null)); } } catch { //Invalid - redisplay with errors return(View(order)); } }
public async Task <IHttpActionResult> PostC_Order(C_Order c_Order) { c_Order.Available = true; c_Order.CreateBy = User.Identity.Name; c_Order.EditBy = User.Identity.Name; c_Order.CreateDate = DateTime.Now; c_Order.EditDate = DateTime.Now; c_Order.OwerId = User.Identity.GetUserId(); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.C_Order.Add(c_Order); try { await db.SaveChangesAsync(); } catch (DbUpdateException) { if (C_OrderExists(c_Order.Id)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = c_Order.Id }, c_Order)); }
public IHttpActionResult PostC_Order(C_Order c_Order) { #region post or save data without update //try //{ // //order table // db.C_Order.Add(c_Order); // //orderItem table // foreach (var item in c_Order.OrderItems) // { // db.OrderItems.Add(item); // } // db.SaveChanges(); // return Ok(); //} //catch (Exception ex) //{ // throw ex; //} #endregion //this code about save data and update data in database try { //order table //post if (c_Order.OrderID == 0) { db.C_Order.Add(c_Order); } //orderItem table (ICollection<OrderItem> orderItem) //update else { db.Entry(c_Order).State = EntityState.Modified; } //orderItem table foreach (var item in c_Order.OrderItems) { if (item.OrderItemID == 0) { db.OrderItems.Add(item); } else { db.Entry(item).State = EntityState.Modified; } } //delete rrecord from arr foreach (var id in c_Order.DeleteOrderItemIDs.Split(',').Where(x => x != "")) { OrderItem record = db.OrderItems.Find(Convert.ToInt64(id)); db.OrderItems.Remove(record); } db.SaveChanges(); return(Ok()); } catch (Exception ex) { throw ex; } }