public static Waiter[] GetAll() { using (var db = new RestaurantDatabase()) { return(db.Waiter.ToArray()); } }
public Account[] GetAll() { using (var db = new RestaurantDatabase()) { return(db.Account.ToArray()); } }
public async Task <Account[]> GetAllAsync() { using (var db = new RestaurantDatabase()) { return(await db.Account.ToArrayAsync()); } }
public static async Task <Waiter[]> GetAllAsync() { using (var db = new RestaurantDatabase()) { return(await db.Waiter.ToArrayAsync()); } }
public static Table[] GetAll() { using (var db = new RestaurantDatabase()) { return(db.Table.ToArray()); } }
public static async Task <Table[]> GetTableList(int waiterid) { using (var db = new RestaurantDatabase()) { return(await db.Table .Where(x => x.Waiter.Id == waiterid) .ToArrayAsync()); } }
public async Task <Account[]> GetByDateAsync(DateTime from, DateTime to) { using (var db = new RestaurantDatabase()) { return(await db.Account .Where(x => x.Timestamp >= from && x.Timestamp <= to) .ToArrayAsync()); } }
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 async void OnScanResult() { Page connectPage = Navigation.NavigationStack.LastOrDefault(); await RestaurantDatabase.Connect(QrCodeResultText); MenuList = RestaurantDatabase.GetMenu(); await Navigation.PushAsync(new MenuPage(MenuList)); Navigation.RemovePage(connectPage); }
public async Task <List <MenuItemDTO> > GetItemsInCategory(Guid categoryId) { using (var db = new RestaurantDatabase()) { var cat = await db.Categories.Where(x => x.CategoryID == categoryId).FirstOrDefaultAsync(); if (cat == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } return(cat.Items.Select(x => new MenuItemDTO(x)).ToList()); } }
//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 static async Task <List <Account> > GetAccountList(int waiterid) { using (var db = new RestaurantDatabase()) { List <Account> accounts = await db.Account.Where(x => x.WaiterId == waiterid).ToListAsync(); if (accounts == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } return(accounts.ToList()); } }
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 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 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 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 void OnScanResult() { if (App.Current.MainPage.Navigation.ModalStack.Count > 0) { await Navigation.PopModalAsync(); await RestaurantDatabase.Connect(QrCodeResultText); homePageViewModel.Menu = RestaurantDatabase.GetMenu(); MessagingCenter.Send(this, Constants.RestaurantConnectedEventName); OnConnectViewUpdate(); } }
private void Button_CommitClicked(object sender, EventArgs e) { List <TableOrder> tableOrders = new List <TableOrder>(); foreach (OrderListItem item in ordersPageViewModel.OrderListItems) { item.CommitStatus = true; tableOrders.Add(item.Order); } RestaurantDatabase.SaveOrders(tableOrders); //ordersPageViewModel.MultifunctionButtonName = "PAY WITH CARD"; //PopupNavigation.Instance.PushAsync(new PaymentView()); }
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)); } }
private async void SaveRestaurant() { Restaurant restaurant = new Restaurant(); restaurant.Name = "Dinar"; restaurant.Menu = new List <MenuOrder>() { new MenuOrder() { Title = "Ciorba de burta", Price = 20, Ingredients = "", PhotoLink = "https://firebasestorage.googleapis.com/v0/b/waiterdatabase.appspot.com/o/Images%2Fciorba_burta.jpg?alt=media&token=1dd5337e-237b-48be-9112-f0ff0b0ae98d" }, new MenuOrder() { Title = "Ciolan de porc", Price = 30, Ingredients = "", PhotoLink = "https://firebasestorage.googleapis.com/v0/b/waiterdatabase.appspot.com/o/Images%2Fciolan_porc.jpg?alt=media&token=a9f87b18-a042-4015-a93f-99641e1ffb49" }, new MenuOrder() { Title = "Papanasi", Price = 15, Ingredients = "", PhotoLink = "https://firebasestorage.googleapis.com/v0/b/waiterdatabase.appspot.com/o/Images%2Fpapanasi.jpg?alt=media&token=e91580d8-ec7b-4cd0-be2a-b767286f2f4f" }, }; restaurant.Tables = new List <Table>() { new Table() { Number = 1, OccupiedStatus = false }, new Table() { Number = 2, OccupiedStatus = false }, new Table() { Number = 3, OccupiedStatus = false }, }; await RestaurantDatabase.SaveRestaurant(restaurant); }