public int DeleteWaiter(int Waiterid)
{
tbl_waiter td = _db.tbl_waiter.Where(c => c.WaiterID == Waiterid).FirstOrDefault();
_db.tbl_waiter.Remove(td);
return(_db.SaveChanges());
}
public int UpdateWaiter(WaiterDetails wd)
{
tbl_waiter td = _db.tbl_waiter.Where(c => c.WaiterID == wd.WaiterID).FirstOrDefault();
td.WaiterName = wd.WaiterName;
td.WaiterContact = wd.WaiterContact;
td.WaiterAddress = wd.WaiterAddress;
return(_db.SaveChanges());
}
public int AddNewWaiter(WaiterDetails wd)
{
tbl_waiter tw = new tbl_waiter();
tw.WaiterName = wd.WaiterName;
tw.WaiterContact = wd.WaiterContact;
tw.WaiterAddress = wd.WaiterAddress;
_db.tbl_waiter.Add(tw);
return(_db.SaveChanges());
}
