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