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));
}
