public IHttpActionResult Puttbl_table(Guid id, tbl_table tbl_table) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_table.id) { return(BadRequest()); } db.Entry(tbl_table).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tbl_tableExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public int DeleteTable(int tableid) { tbl_table td = _db.tbl_table.Where(c => c.Id == tableid).FirstOrDefault(); _db.tbl_table.Remove(td); return(_db.SaveChanges()); }
public IHttpActionResult Posttbl_table(tbl_table tbl_table) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tbl_table.Add(tbl_table); try { db.SaveChanges(); } catch (DbUpdateException) { if (tbl_tableExists(tbl_table.id)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = tbl_table.id }, tbl_table)); }
public int UpdateTable(TableDetails td) { tbl_table tt = _db.tbl_table.Where(c => c.Id == td.Id).FirstOrDefault(); tt.TableNumber = td.TableNumber; tt.AddedDate = td.AddedDate; return(_db.SaveChanges()); }
public ActionResult DeleteConfirmed(Guid id) { tbl_table tbl_table = db.tbl_table.Find(id); db.tbl_table.Remove(tbl_table); db.SaveChanges(); return(RedirectToAction("Index")); }
public int AddNewTable(TableDetails td) { tbl_table tt = new tbl_table(); tt.TableNumber = td.TableNumber; tt.AddedDate = td.AddedDate; _db.tbl_table.Add(tt); return(_db.SaveChanges()); }
public IHttpActionResult Gettbl_table(Guid id) { tbl_table tbl_table = db.tbl_table.Find(id); if (tbl_table == null) { return(NotFound()); } return(Ok(tbl_table)); }
public ActionResult Edit([Bind(Include = "id,code,name,type_id,floor_id")] tbl_table tbl_table) { if (ModelState.IsValid) { db.Entry(tbl_table).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.floor_id = new SelectList(db.tbl_floor, "id", "code", tbl_table.floor_id); ViewBag.type_id = new SelectList(db.tbl_tableType, "id", "code", tbl_table.type_id); return(View(tbl_table)); }
public IHttpActionResult Deletetbl_table(Guid id) { tbl_table tbl_table = db.tbl_table.Find(id); if (tbl_table == null) { return(NotFound()); } db.tbl_table.Remove(tbl_table); db.SaveChanges(); return(Ok(tbl_table)); }
public ActionResult Create([Bind(Include = "id,code,name,type_id,floor_id")] tbl_table tbl_table) { if (ModelState.IsValid) { tbl_table.id = Guid.NewGuid(); db.tbl_table.Add(tbl_table); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.floor_id = new SelectList(db.tbl_floor, "id", "code", tbl_table.floor_id); ViewBag.type_id = new SelectList(db.tbl_tableType, "id", "code", tbl_table.type_id); return(View(tbl_table)); }
// GET: Table/Details/5 public ActionResult Details(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_table tbl_table = db.tbl_table.Find(id); if (tbl_table == null) { return(HttpNotFound()); } return(View(tbl_table)); }
// GET: Table/Edit/5 public ActionResult Edit(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_table tbl_table = db.tbl_table.Find(id); if (tbl_table == null) { return(HttpNotFound()); } ViewBag.floor_id = new SelectList(db.tbl_floor, "id", "code", tbl_table.floor_id); ViewBag.type_id = new SelectList(db.tbl_tableType, "id", "code", tbl_table.type_id); return(View(tbl_table)); }