public Waiter GetWaiter(int waiterID)
{
using (RestrauntContext context = new RestrauntContext())
{
return(context.Waiters.Find(waiterID));
}
}
public List <Waiter> ListAllWaiters()
{
using (RestrauntContext context = new RestrauntContext())
{
return(context.Waiters.ToList());
}
}
public void DeleteWaiter(Waiter item)
{
using (RestrauntContext context = new RestrauntContext())
{
var existing = context.Waiters.Find(item.WaiterID);
context.Waiters.Remove(existing);
context.SaveChanges();
}
}
public int AddWaiter(Waiter item)
{
using (RestrauntContext context = new RestrauntContext())
{
// TODO: Validation of waiter data...
var added = context.Waiters.Add(item);
context.SaveChanges();
return(added.WaiterID);
}
}
public void UpdateWaiter(Waiter item)
{
using (RestrauntContext context = new RestrauntContext())
{
// TODO: Validation
var attatched = context.Waiters.Attach(item);
var matchingWithExistingValues = context.Entry <Waiter>(attatched);
matchingWithExistingValues.State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
