/// <summary>
///
/// </summary>
/// <returns></returns>
private async Task Update_ListView_SpecialDeals()
{
List <SpecialDeals> query = await oSpecialDealsRepository.Select_All_SpecialDeals_Async();
List <Bouquets_SpecialDeals> result = new List <Bouquets_SpecialDeals>();
foreach (var s in query)
{
Bouquets_SpecialDeals bouquet_specialdeal = new Bouquets_SpecialDeals();
bouquet_specialdeal.specialdeal = s;
bouquet_specialdeal.bouquet = await conn.GetAsync <Bouquets>(s.bouquets_id);
result.Add(bouquet_specialdeal);
}
listview_SpecialDealDiscount.ItemsSource = result;
}
/// <summary>
/// Обновление listview с Клиентами. Каждому клиенту ставится в соответствие его бонусная карта
/// </summary>
/// <returns></returns>
private async Task Update_ListView_Clients()
{
List <Client_Card> lClient_Card = new List <Client_Card>();
List <Clients> lClients = await oClientsRepository.Select_All_Clients_Async();
foreach (var c in lClients)
{
Client_Card client_card = new Client_Card();
client_card.client = c;
client_card.card = await conn.GetAsync <Cards>(c.cards_id);
lClient_Card.Add(client_card);
}
listview_Clients.ItemsSource = lClient_Card;
}
/// <summary>
/// Обновление списка с Компонентами. В список загружаются только компоненты выбранного букета.
/// </summary>
/// <returns></returns>
private async Task Update_ListView_Contents()
{
List <Accessories_Flowers> acc_flo = new List <Accessories_Flowers>();
List <Contents> result = await oContentsRepository.Select_Contents_Async("select * from contents where bouquets_id = " + bouquet.bouquets_id);
foreach (var c in result)
{
Accessories_Flowers af = new Accessories_Flowers();
af.contents = c; // Необходимо для реализации обновления и удаления
//af.count = c.count; // Необходима для корректного отображения количества.
if (c.accessories_id != -1)
{
af.component = await conn.GetAsync <Accessories>(c.accessories_id);
af.type = "Аксессуар";
af.type_index = 0;
af.component_index = await Get_Component_Index(true, (af.component as Accessories).accessories_id);
}
else
{
af.component = conn.GetAsync <Flowers>(c.flowers_id).Result;
af.type = "Цветок";
af.type_index = 1;
af.component_index = await Get_Component_Index(false, (af.component as Flowers).flowers_id);
}
acc_flo.Add(af);
}
listview_Content.ItemsSource = acc_flo;
}
private async Task Update_ListBox_View()
{
List <ClientCard> clientcard = new List <ClientCard>();
List <Clients> result = await oClientsRepository.Select_All_Clients_Async();
SQLite.SQLiteAsyncConnection conn = oDBConnection.GetAsyncConnection();
foreach (Clients client in result)
{
ClientCard cc = new ClientCard();
cc.client = client;
cc.card = await conn.GetAsync <Cards>(client.cards_id);
clientcard.Add(cc);
}
listview.ItemsSource = clientcard;
}
/// <summary>
/// Обновление listview с Заказами. Ставим в соответствие каждому заказу его клиента.
/// </summary>
/// <returns></returns>
private async Task Update_ListView_Orders()
{
List <Clients_Orders> lClients_Orders = new List <Clients_Orders>();
List <Orders> lOrders = new List <Orders>();
lOrders = await oOrdersRepository.Select_All_Orders_Async();
foreach (var o in lOrders)
{
Clients_Orders clients_orders = new Clients_Orders();
clients_orders.order = o;
clients_orders.client = await conn.GetAsync <Clients>(o.clients_id);
lClients_Orders.Add(clients_orders);
}
listview_Orders.ItemsSource = lClients_Orders;
}
/// <summary>
/// создание Excel отчета за день/неделю/месяц/квартал
/// </summary>
/// <param name="values"></param>
/// <param name="win"></param>
/// <param name="conn"></param>
/// <param name="list_day_data"></param>
/// <param name="list_week_data"></param>
/// <param name="list_month_data"></param>
/// <param name="list_quater_data"></param>
public async void Create_Excel_Doc(List <Flovers_WPF.Reply_Window.Data> values, Reply_Window win, SQLite.SQLiteAsyncConnection conn, List <Flovers_WPF.Reply_Window.Data> list_day_data,
List <Flovers_WPF.Reply_Window.Data> list_week_data, List <Flovers_WPF.Reply_Window.Data> list_month_data, List <Flovers_WPF.Reply_Window.Data> list_quater_data)
{
Excel.Application exapp = new Excel.Application();
exapp.SheetsInNewWorkbook = 1;
exapp.Workbooks.Add(Type.Missing);
exapp.DisplayAlerts = true;
exapp.Visible = true;
Excel.Workbooks exappworkbooks = exapp.Workbooks;
Excel.Workbook exappworkbook = exappworkbooks[1];
exappworkbook.Saved = false;
Excel.Sheets excellsheets = exappworkbook.Worksheets;
Excel.Worksheet excellworksheet = (Excel.Worksheet)excellsheets.get_Item(1);
excellworksheet.Activate();
Excel.Range excelcells;
for (int j = 1; j < 4; j++)
{
if (j == 1)
{
excelcells = (Excel.Range)excellworksheet.Cells[1, j];
excelcells.Value2 = "время/дата";
excelcells.Font.Size = 12;
excelcells.Font.Italic = true;
excelcells.Font.Bold = true;
excelcells.HorizontalAlignment = Excel.Constants.xlCenter;
excelcells.VerticalAlignment = Excel.Constants.xlCenter;
}
if (j == 2)
{
excelcells = (Excel.Range)excellworksheet.Cells[1, j];
excelcells.Value2 = "Количество";
excelcells.Font.Size = 12;
excelcells.Font.Italic = true;
excelcells.Font.Bold = true;
excelcells.HorizontalAlignment = Excel.Constants.xlCenter;
excelcells.VerticalAlignment = Excel.Constants.xlCenter;
}
if (j == 3)
{
excelcells = (Excel.Range)excellworksheet.Cells[1, j];
excelcells.Value2 = "Букет";
excelcells.Font.Size = 12;
excelcells.Font.Italic = true;
excelcells.Font.Bold = true;
excelcells.HorizontalAlignment = Excel.Constants.xlCenter;
excelcells.VerticalAlignment = Excel.Constants.xlCenter;
}
}
if (values != null)
{
for (int m = 2; m < values.Count + 2; m++)
{
for (int n = 1; n < 4; n++)
{
if (n == 1)
{
excelcells = (Excel.Range)excellworksheet.Cells[m, n];
excelcells.Value2 = values[m - 2].time.ToString();
excelcells.Font.Size = 12;
excelcells.Font.Italic = true;
excelcells.Font.Bold = false;
excelcells.HorizontalAlignment = Excel.Constants.xlCenter;
excelcells.VerticalAlignment = Excel.Constants.xlCenter;
}
if (n == 2)
{
excelcells = (Excel.Range)excellworksheet.Cells[m, n];
excelcells.Value2 = values[m - 2].count.ToString();
excelcells.Font.Size = 12;
excelcells.Font.Italic = true;
excelcells.Font.Bold = false;
excelcells.HorizontalAlignment = Excel.Constants.xlCenter;
excelcells.VerticalAlignment = Excel.Constants.xlCenter;
}
if (n == 3)
{
Bouquets b = await conn.GetAsync <Bouquets>(values[m - 2].bouqet_id);
excelcells = (Excel.Range)excellworksheet.Cells[m, n];
excelcells.Value2 = b.name.ToString();
excelcells.Font.Size = 12;
excelcells.Font.Italic = true;
excelcells.Font.Bold = false;
excelcells.HorizontalAlignment = Excel.Constants.xlCenter;
excelcells.VerticalAlignment = Excel.Constants.xlCenter;
}
}
}
Excel.ChartObjects chartsobjrcts = (Excel.ChartObjects)excellworksheet.ChartObjects(Type.Missing);
Excel.ChartObject chartsobj = chartsobjrcts.Add(10, 200, 500, 300);
Excel.Chart excelchart = chartsobj.Chart;
excelcells = excellworksheet.get_Range("A1", "B" + (values.Count + 1).ToString());
excelchart.SetSourceData(excelcells, Type.Missing);
excelchart.ChartType = Excel.XlChartType.xlLine;
excelchart.HasTitle = true;
if (values == list_day_data)
{
excelchart.ChartTitle.Text = "Продажи за день";
}
if (values == list_week_data)
{
excelchart.ChartTitle.Text = "Продажи за неделю";
}
if (values == list_month_data)
{
excelchart.ChartTitle.Text = "Продажи за месяц";
}
if (values == list_quater_data)
{
excelchart.ChartTitle.Text = "Продажи за квартал";
}
excelchart.ChartTitle.Font.Size = 14;
excelchart.ChartTitle.Font.Color = 255;
excelchart.ChartTitle.Shadow = true;
}
else
{
System.Windows.MessageBox.Show("нет данных для отчета");
exapp.Quit();
}
}
