private void BtnOrder_Click(object sender, RoutedEventArgs e)
{
using (MainModel context = new MainModel())
{
DBEntities.Order order = context.Orders.Create();
order.DateTime = DateTime.Now;
order.Status = context.OrderStatuses.Where(s => s.Name == "Готовится").ToArray()[0];
order.Dishes = context.OrderDishes.ToList();
order.Number = " ";
for (int i = 0; i < Cart.Count; i++)
{
DBEntities.OrderDish link = new DBEntities.OrderDish()
{
Dish = Cart[i].Dish,
Count = Cart[i].Count,
Order = order
};
order.Dishes.Add(link);
}
context.Orders.Add(order);
context.SaveChanges();
order.Number = Functions.GenerateOrderNumber(order.Id);
context.SaveChanges();
MessageBox.Show("Спасибо за заказ, мы уже начали его готовить. Номер заказа " + order.Number, "Заказ", MessageBoxButton.OK, MessageBoxImage.Information);
Functions.Navigate("back");
}
}
private void cmbOrder_SelectedIndexChanged(object sender, EventArgs e)
{
DBEntities.Order order = (DBEntities.Order)cmbOrder.SelectedItem;
string sHistoryText = GetHistory(order);
txtHistoryData.Text = sHistoryText;
}
private void SendToDatabase(out int?OrderId)
{
OrderId = null;
try
{
using (var db = new DBEntities.OrderDBContext())
{
var order = new DBEntities.Order();
order.TableNO = (ETable)cmbSelectTable.SelectedValue;
order.TotalPrice = double.Parse(txtTotalPrice.Text);
order.Description = txtDescription.Text;
order.Meals = new List <IMeal>();
foreach (DBEntities.Pizza pizza in pizzaList)
{
order.Meals.Add(pizza);
pizza.Order = order;
db.Pizzas.Add(pizza);
}
foreach (DBEntities.Dish dish in dishList)
{
order.Meals.Add(dish);
dish.Order = order;
db.Dishes.Add(dish);
}
foreach (DBEntities.Soup soup in soupList)
{
order.Meals.Add(soup);
soup.Order = order;
db.Soups.Add(soup);
}
foreach (DBEntities.Drink drink in drinkList)
{
order.Meals.Add(drink);
drink.Order = order;
db.Drinks.Add(drink);
}
db.Orders.Add(order);
db.SaveChanges();
OrderId = order.Id;
}
}
catch (Exception ex)
{
MessageBox.Show("Błąd zapisu do bazy danych", "Zapis do bazy danych", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private string GetHistory(DBEntities.Order order)
{
string sOutputText = string.Empty;
sOutputText += string.Format("Zamówienie nr {0}", order.Id);
sOutputText += Environment.NewLine;
sOutputText += Environment.NewLine;
sOutputText += "PIZZA";
sOutputText += Environment.NewLine;
sOutputText += Classes.Common.GetPizzaHistory(pizzas.Where(x => x.OrderId == order.Id).ToList());
sOutputText += Environment.NewLine;
sOutputText += "DANIE OBIADOWE";
sOutputText += Environment.NewLine;
sOutputText += Classes.Common.GetDishHistory(dishes.Where(x => x.OrderId == order.Id).ToList());
sOutputText += Environment.NewLine;
sOutputText += "ZUPA";
sOutputText += Environment.NewLine;
sOutputText += Classes.Common.GetSoupHistory(soups.Where(x => x.OrderId == order.Id).ToList());
sOutputText += Environment.NewLine;
sOutputText += "NAPOJE";
sOutputText += Environment.NewLine;
sOutputText += Classes.Common.GetDrinkHistory(drinks.Where(x => x.OrderId == order.Id).ToList());
sOutputText += Environment.NewLine;
sOutputText += string.Format("Koszt zamównienia: {0} zł.", order.TotalPrice);
return(sOutputText);
}
