/// <summary> /// Обновление listview с Корзиной заказа. Содержит элементы корзины выделенного заказа. /// </summary> /// <returns></returns> private async Task Update_ListView_Carts() { List <Carts_Bouquets> lCarts_Bouquets = new List <Carts_Bouquets>(); List <Carts> lCarts = await oCartsRepository.Select_Carts_Async("select * from carts where carts.orders_id = " + oClients_Orders.order.orders_id); foreach (var c in lCarts) { Carts_Bouquets carts_bouquets = new Carts_Bouquets(); carts_bouquets.cart = c; carts_bouquets.bouquet = await conn.GetAsync <Bouquets>(c.bouquets_id); lCarts_Bouquets.Add(carts_bouquets); } listview_Carts.ItemsSource = lCarts_Bouquets; }
/// <summary> /// построение графика - отчет за день /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private async void button_build_Click(object sender, RoutedEventArgs e) { for (int i = 0; i < day_chart.Series.Count; i++) { day_chart.Series.Remove(day_chart.Series[i]); } values = new List <KeyValuePair <string, int> >(); List <Orders> list_orders = await oOrdersRepository.Select_All_Orders_Async(); List <Data> list_data = new List <Data>(); for (int i = 0; i < list_orders.Count; i++) { Data d = new Data(); if (list_orders[i].datetime.Date == datepicker.SelectedDate) { List <Carts> list_carts = await oCartsRepository.Select_Carts_Async("select count,bouquets_id from Carts where orders_id=" + list_orders[i].orders_id); d.time = list_orders[i].datetime.TimeOfDay.ToString(); foreach (var c in list_carts) { d.count = (int)c.count; d.bouqet_id = c.bouquets_id; list_data.Add(d); } } } list_day_data = list_data; List <Bouquets> list_bouq = await oBouquetsRepository.Select_All_Bouquets_Async(); for (int i = 0; i < list_bouq.Count; i++) { values = new List <KeyValuePair <string, int> >(); for (int j = 0; j < list_data.Count; j++) { if (list_data[j].bouqet_id == list_bouq[i].bouquets_id) { values.Add(new KeyValuePair <string, int>(list_data[j].time, list_data[j].count)); } } createLineSeries_Day(values, list_bouq[i].name); button_createExcel.IsEnabled = true; } }