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