public IHttpActionResult Posttbl_orderDetail(tbl_orderDetail tbl_orderDetail) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } tbl_orderDetail.tbl_order = null; db.tbl_orderDetail.Add(tbl_orderDetail); try { db.SaveChanges(); } catch (DbUpdateException) { if (tbl_orderDetailExists(tbl_orderDetail.order_id, tbl_orderDetail.name)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = tbl_orderDetail.order_id }, tbl_orderDetail)); }
public ActionResult DeleteConfirmed(Guid id) { tbl_orderDetail tbl_orderDetail = db.tbl_orderDetail.Find(id); db.tbl_orderDetail.Remove(tbl_orderDetail); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "order_id,name,amout,price")] tbl_orderDetail tbl_orderDetail) { if (ModelState.IsValid) { db.Entry(tbl_orderDetail).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.order_id = new SelectList(db.tbl_order, "id", "create_date", tbl_orderDetail.order_id); return(View(tbl_orderDetail)); }
// GET: OrderDetail/Details/5 public ActionResult Details(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_orderDetail tbl_orderDetail = db.tbl_orderDetail.Find(id); if (tbl_orderDetail == null) { return(HttpNotFound()); } return(View(tbl_orderDetail)); }
// GET: OrderDetail/Edit/5 public ActionResult Edit(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_orderDetail tbl_orderDetail = db.tbl_orderDetail.Find(id); if (tbl_orderDetail == null) { return(HttpNotFound()); } ViewBag.order_id = new SelectList(db.tbl_order, "id", "create_date", tbl_orderDetail.order_id); return(View(tbl_orderDetail)); }
public IHttpActionResult Deletetbl_orderDetail(Guid id, string name) { tbl_orderDetail tbl_orderDetail = db.tbl_orderDetail.FirstOrDefault(e => e.order_id == id && e.name.Equals(name)); if (tbl_orderDetail == null) { return(NotFound()); } tbl_orderDetail.tbl_order = null; db.tbl_orderDetail.Remove(tbl_orderDetail); db.SaveChanges(); return(Ok(tbl_orderDetail)); }
public IHttpActionResult Puttbl_orderDetail(Guid id, string name, tbl_orderDetail tbl_orderDetail) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_orderDetail.order_id) { return(BadRequest()); } tbl_orderDetail temp = db.tbl_orderDetail.FirstOrDefault(e => e.order_id == id && e.name.Equals(name)); if (temp == null) { return(NotFound()); } temp.name = tbl_orderDetail.name; temp.price = tbl_orderDetail.price; temp.amout = tbl_orderDetail.amout; temp.tbl_order = null; db.Entry(temp).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tbl_orderDetailExists(id, tbl_orderDetail.name)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult Puttbl_order(Guid id, tbl_order tbl_order) { tbl_order cache = tbl_order; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_order.id) { return(BadRequest()); } tbl_order.tbl_table = null; ICollection <tbl_orderDetail> newDetails = tbl_order.tbl_orderDetail; tbl_order.tbl_orderDetail = null; db.Entry(tbl_order).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tbl_orderExists(id)) { return(NotFound()); } else { throw; } } if (newDetails != null) { ICollection <tbl_orderDetail> oldDetails = db.tbl_orderDetail.Where(e => e.order_id == id).ToList(); foreach (var oldDetail in oldDetails) { if (!(newDetails.Count(e => e.order_id == oldDetail.order_id && e.name.Equals(oldDetail.name)) > 0)) { if (oldDetail != null) { oldDetail.tbl_order = null; db.tbl_orderDetail.Remove(oldDetail); db.SaveChanges(); } } } foreach (var item in newDetails) { tbl_orderDetail temp = db.tbl_orderDetail.FirstOrDefault(e => e.order_id == item.order_id && e.name.Equals(item.name)); if (temp == null) { item.tbl_order = null; db.tbl_orderDetail.Add(item); } else { temp.name = item.name; temp.price = item.price; temp.amout = item.amout; temp.tbl_order = null; db.Entry(temp).State = EntityState.Modified; } try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!(db.tbl_orderDetail.Count(e => e.order_id == item.order_id && e.name.Equals(item.name)) > 0)) { return(NotFound()); } else { throw; } } } } return(StatusCode(HttpStatusCode.OK)); }