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