public int AddTable(Table item) { using (RestaurantContext context = new RestaurantContext()) { var added = context.Tables.Add(item); context.SaveChanges(); return added.TableID; } }
public int AddTable(Table item) { using (RestaurantContext context = new RestaurantContext()) { //TODO: Validation of waiter data var added = context.Tables.Add(item); context.SaveChanges(); return added.TableID; } }
public void UpdateTable(Table item) { using (RestaurantContext context = new RestaurantContext()) { //TODO: Validation var attached = context.Tables.Attach(item); var matchingWithExistingValues = context.Entry<Table>(attached); matchingWithExistingValues.State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void DeleteWaiter(Table item) { using (RestaurantContext context = new RestaurantContext()) { var existing = context.Tables.Find(item.TableID); context.Tables.Remove(existing); context.SaveChanges(); } }
public void UpdateTable(Table item) { //TODO: Validation rules... using (RestaurantContext context = new RestaurantContext()) { var attached = context.Tables.Attach(item); var existing = context.Entry<Table>(attached); existing.State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }