private void SubmitOrder(object sender, RoutedEventArgs e)
{
OnMyWayDatabase OnMyWayDb = new OnMyWayDatabase();
var TableSelectedQuery = (from t in OnMyWayDb.TableSelecteds
where t.Id == 1
select t).FirstOrDefault();
if (TableSelectedQuery.TableId != 0)
{
Dishe Adishe = new Dishe();
string OrderedDishes = "";
for (int i = 0; i < AvailableDishesListView.SelectedItems.Count; i++)
{
Adishe = (Dishe)AvailableDishesListView.SelectedItems[i];
OrderedDishes += Adishe.DisheId + ",";
}
var GetSelectedTableQuery = (from t in OnMyWayDb.Tables
where t.TableId == TableSelectedQuery.TableId
select t).FirstOrDefault();
GetSelectedTableQuery.TableStatus = "Eating";
GetSelectedTableQuery.DisheList = OrderedDishes;
OnMyWayDb.SaveChanges();
PushMsg("Ordered Dishes", "Selected dishes have been set for table: " + TableSelectedQuery.TableId);
}
else
{
PushMsg("No Table Selected", "Please select a table for the order.");
}
}
private void EventDeleteDishes(object sender, RoutedEventArgs e)
{
OnMyWayDatabase OnMyWayDb = new OnMyWayDatabase();
Dishe Adishe = new Dishe();
bool CanCommit = false;
for (int i = 0; i < DishesDataGrid.SelectedItems.Count; i++)
{
if (CanCommit == false)
{
CanCommit = true;
}
Adishe = (Dishe)DishesDataGrid.SelectedItems[i];
var GetDishesQuery = from d in OnMyWayDb.Dishes
where d.DisheId == Adishe.DisheId
select d;
foreach (Dishe dishe in GetDishesQuery)
{
OnMyWayDb.Dishes.Remove(dishe);
}
}
if (CanCommit == true)
{
OnMyWayDb.SaveChanges();
PushMsg("Dishe Deleted", "Selected dishes was successfully Deleted.");
ShowDishes();
}
}
private void EventUpdateDishes(object sender, RoutedEventArgs e)
{
OnMyWayDatabase OnMyWayDb = new OnMyWayDatabase();
Dishe Adishe = new Dishe();
bool CanCommit = false;
for (int i = 0; i < DishesDataGrid.Items.Count; i++)
{
if (CanCommit == false)
{
CanCommit = true;
}
Adishe = (Dishe)DishesDataGrid.Items[i];
var GetDishesQuery = (from d in OnMyWayDb.Dishes
where d.DisheId == Adishe.DisheId
select d).FirstOrDefault();
GetDishesQuery.DisheName = Adishe.DisheName;
GetDishesQuery.DisheDescription = Adishe.DisheDescription;
GetDishesQuery.DishePrice = Adishe.DishePrice;
}
if (CanCommit == true)
{
OnMyWayDb.SaveChanges();
PushMsg("Dishes Saved", "All changes to dishes have been saved.");
ShowDishes();
}
}
private void AddDishe(object sender, RoutedEventArgs e)
{
Dishe NewDishe = new Dishe();
bool CanCommit = false;
if (DisheNameTextBox.Text.Length != 0)
{
NewDishe.DisheName = DisheNameTextBox.Text;
if (DisheDescriptionTextBox.Text.Length != 0)
{
NewDishe.DisheDescription = DisheDescriptionTextBox.Text;
if (DishePriceTextBox.Text.Length != 0)
{
try
{
NewDishe.DishePrice = double.Parse(DishePriceTextBox.Text);
CanCommit = true;
}
catch
{
PushMsg("Price Error", "Invalid price input!");
}
}
else
{
PushMsg("Price Error", "Dishe needs a price!");
}
}
else
{
PushMsg("Description Error", "Dishe needs a description!");
}
}
else
{
PushMsg("Name Error", "Dishe needs a name!");
}
if (CanCommit == true)
{
OnMyWayDatabase OnMyWayDb = new OnMyWayDatabase();
OnMyWayDb.Dishes.Add(NewDishe);
OnMyWayDb.SaveChanges();
PushMsg("Dishe Added", "Dishe was successfully added.\n\nPlease refresh Admin Panel to view changes.");
}
}