public void UpdateButton(List <Button> buttons)
{
foreach (var button in buttons)
{
string text_button = button.Name;
var info = text_button.Split('_');
string name = info[0];
string size = info[1];
var res = roffeeShop2Context.Set <Drink>().Where(u => u.Name == name && u.GlassSize == size).ToList();
if (res.Count == 1)
{
button.Content = res[0].Price;
}
else
{
button.Visibility = Visibility.Hidden;
}
}
}
private void result_Click(object sender, RoutedEventArgs e)
{
var r = roffeeShop2Context.Set <Drink>().ToList();
List <Order> orders = new List <Order> {
};
foreach (var item in r)
{
var res_item = roffeeShop2Context.Set <Order>().Where(u => u.DrinkId == item.Id && u.Date == data.SelectedDate).ToList();
int suma_count = 0;
float suma_price = 0;
foreach (var item1 in res_item)
{
suma_count = item1.Count;
suma_price = item1.Price;
}
Order order = new Order();
order.DrinkId = item.Id;
order.Price = suma_price;
order.Count = suma_count;
order.Date = new DateTime();
orders.Add(order);
}
var res = orders.Join
(roffeeShop2Context.Set <Drink>(),
drinkId1 => drinkId1.DrinkId,
drinkId2 => drinkId2.Id,
(drinkId1, drinkId2) => new
{
Name = drinkId2.Name,
GlassSize = drinkId2.GlassSize,
Count = drinkId1.Count,
Price = drinkId1.Price,
}
).ToList();
Report_DataGrid.ItemsSource = res;
}
