public static async Task <int> Create(Waiter waiter) { using (var db = new RestaurantDatabase()) { db.Waiter.Add(waiter); await db.SaveChangesAsync(); return(waiter.Id); } }
public static async Task <int> Create(Table table) { using (var db = new RestaurantDatabase()) { table.Waiter = await db.Waiter.FirstAsync(x => x.Id == table.Waiter.Id); db.Table.Add(table); await db.SaveChangesAsync(); return(table.Id); } }
//public static async Task<int> Create(Table table) //{ // using (var db = new RestaurantDatabase()) // { // db.Table.Add(table); // await db.SaveChangesAsync(); // return table.Id; // } //} public static async Task <int> Create(Account account) { using (var db = new RestaurantDatabase()) { account.Table = await db.Table.FirstAsync(x => x.Id == account.Table.Id); db.Table.Add(account.Table); await db.SaveChangesAsync(); return(account.Id); } }
public async Task Delete(Account account) { using (var db = new RestaurantDatabase()) { Account existing = await db.Account.FirstOrDefaultAsync(x => x.Id == account.Id); if (existing == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } db.Account.Remove(existing); await db.SaveChangesAsync(); } }
public static async Task Delete(Waiter waiter) { using (var db = new RestaurantDatabase()) { Waiter existing = await db.Waiter.FirstOrDefaultAsync(x => x.Id == waiter.Id); if (existing == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } db.Waiter.Remove(existing); await db.SaveChangesAsync(); } }
public static async Task Update(Table table) { using (var db = new RestaurantDatabase()) { Waiter existing = await db.Waiter.FirstOrDefaultAsync(x => x.Id == table.Id); if (existing == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } existing.Waitername = table.Tablename; await db.SaveChangesAsync(); } }
public async Task <CategoryDTO> AddCategory(string CategoryName) { using (var db = new RestaurantDatabase()) { var cat = new Category() { CategoryName = CategoryName, CategoryID = Guid.NewGuid(), Items = new List <MenuItem>(), }; db.Categories.Add(cat); await db.SaveChangesAsync(); return(new CategoryDTO(cat)); } }
public async Task <MenuItemDTO> AddItem(string categoryId, [FromBody] MenuItemDTO item) { using (var db = new RestaurantDatabase()) { var menuItem = new MenuItem() { ItemDescription = item.ItemDescription, ItemName = item.ItemName, ItemPrice = item.ItemPrice, ItemID = Guid.NewGuid(), SpecialInstructions = item.SpecialInstructions, InStock = true, }; db.MenuItems.Add(menuItem); await db.SaveChangesAsync(); return(new MenuItemDTO(menuItem)); } }