private void createChart2() { var today = DateTime.Today; var month = new DateTime(today.Year, today.Month, 1); var lastMonth = month.AddMonths(-4); var invoices = new double[4]; var receipts = new double[4]; var expenses = new double[4]; Labels2 = new string[4]; for (var i = 0; i < 4; i++) { receipts[i] = ReceiptViewModel.getTotalReceiptsMonthYear(lastMonth.Month, lastMonth.Year) + InvoiceViewModel.getPaidInvoicesbyMonthYear(lastMonth.Month, lastMonth.Year);; invoices[i] = InvoiceViewModel.getTotalSalesMonthYear(lastMonth.Month, lastMonth.Year); expenses[i] = ExpensesViewModel.getTotalExpensesMonthYear(lastMonth.Month, lastMonth.Year); Labels2[i] = lastMonth.Month.ToString(); lastMonth = lastMonth.AddMonths(1); } var totalReceipt = new ChartValues <double>(); totalReceipt.AddRange(receipts); var total = new ChartValues <double>(); total.AddRange(invoices); var totalExpenses = new ChartValues <double>(); totalExpenses.AddRange(expenses); SeriesCollection2 = new SeriesCollection { new ColumnSeries { Title = "Sales", Values = total }, new ColumnSeries { Title = "Receipts", Values = totalReceipt }, new ColumnSeries { Title = "Expenses", Values = totalExpenses } }; Formatter = value => value.ToString("N"); DataContext = this; }
private void createChart1() { float totalYearlySales = 0; double totalYearlyReceipts = 0; var receipts = new double[12]; for (var i = 0; i < 12; i++) { double temp1 = ReceiptViewModel.getTotalReceiptsMonthYear(i + 1, DateTime.Now.Year) + InvoiceViewModel.getPaidInvoicesbyMonthYear(i + 1, DateTime.Now.Year); receipts[i] = temp1; totalYearlyReceipts += temp1; } var totalReceipt = new ChartValues <double>(); totalReceipt.AddRange(receipts); var invoices = new double[12]; for (var i = 0; i < 12; i++) { invoices[i] = InvoiceViewModel.getTotalSalesMonthYear(i + 1, DateTime.Now.Year); totalYearlySales += InvoiceViewModel.getTotalSalesMonthYear(i + 1, DateTime.Now.Year); } var total = new ChartValues <double>(); total.AddRange(invoices); SeriesCollection = new SeriesCollection { new LineSeries { Title = "Sales", Values = total }, new LineSeries { Title = "Receipts", Values = totalReceipt, PointGeometry = null } }; salesCountYearly.Text = totalYearlySales.ToString(); receiptsCountYearly.Text = totalYearlyReceipts.ToString("C"); YFormatter = value => value.ToString("C"); DataContext = this; }
private void BtnSelectProduct_Click(object sender, RoutedEventArgs e) { totalReceipts.Clear(); totalReceiptsLastYear.Clear(); totalPaidInvoices.Clear(); totalPaidInvoicesLastYear.Clear(); total.Clear(); totalLastYear.Clear(); invoices.Clear(); invoicesLastYear.Clear(); var moment = DateTime.Now; if (cmbBoxLast.Text == "Numbers") { for (var i = 1; i <= 12; i++) { var temp1 = ReceiptViewModel.getTotalReceiptsMonthYear(i, moment.Year); totalReceipts.Add(temp1); var temp2 = ReceiptViewModel.getTotalReceiptsMonthYear(i, moment.Year - 1); totalReceiptsLastYear.Add(temp2); var temp3 = InvoiceViewModel.getPaidInvoicesbyMonthYear(i, moment.Year); totalPaidInvoices.Add(temp3); var temp4 = InvoiceViewModel.getPaidInvoicesbyMonthYear(i, moment.Year - 1); totalPaidInvoicesLastYear.Add(temp4); total.Add(temp1 + temp3); totalLastYear.Add(temp2 + temp4); invoices.Add(InvoiceViewModel.getTotalSalesMonthYear(i, moment.Year)); invoicesLastYear.Add(InvoiceViewModel.getTotalSalesMonthYear(i, moment.Year - 1)); } SeriesCollection = new SeriesCollection { new LineSeries { Title = "Total Receipts", Values = totalReceipts }, new LineSeries { Title = "Last Year Receipts", Values = totalReceiptsLastYear } }; SeriesCollection2 = new SeriesCollection { new LineSeries { Title = "Total Paid Invoices", Values = totalPaidInvoices }, new LineSeries { Title = "Last Year Paid Invoices", Values = totalPaidInvoicesLastYear }, }; SeriesCollection3 = new SeriesCollection { new LineSeries { Title = "Total Paid Invoices", Values = total }, new LineSeries { Title = "Total Last Year Paid Invoices", Values = totalLastYear }, new ColumnSeries { Title = "Invoices", Values = invoices }, new ColumnSeries { Title = "Invoices Last Year", Values = invoicesLastYear } }; YFormatter = value => value.ToString("c"); } if (cmbBoxLast.Text == "Percentage") { for (var i = 1; i <= 12; i++) { var totalSales = InvoiceViewModel.getTotalSalesMonthYear(i, moment.Year); var totalSalesLY = InvoiceViewModel.getTotalSalesMonthYear(i, moment.Year - 1); var temp1 = ReceiptViewModel.getTotalReceiptsMonthYear(i, moment.Year) / totalSales; totalReceipts.Add(temp1); var temp2 = ReceiptViewModel.getTotalReceiptsMonthYear(i, moment.Year - 1) / totalSalesLY; totalReceiptsLastYear.Add(temp2); var temp3 = InvoiceViewModel.getPaidInvoicesbyMonthYear(i, moment.Year) / totalSales; totalPaidInvoices.Add(temp3); var temp4 = InvoiceViewModel.getPaidInvoicesbyMonthYear(i, moment.Year - 1) / totalSalesLY; totalPaidInvoicesLastYear.Add(temp4); total.Add(temp1 + temp3); totalLastYear.Add(temp2 + temp4); } SeriesCollection = new SeriesCollection { new LineSeries { Title = "Total Receipts", Values = totalReceipts }, new LineSeries { Title = "Last Year Receipts", Values = totalReceiptsLastYear } }; SeriesCollection2 = new SeriesCollection { new LineSeries { Title = "Total Paid Invoices", Values = totalPaidInvoices }, new LineSeries { Title = "Last Year Paid Invoices", Values = totalPaidInvoicesLastYear }, }; SeriesCollection3 = new SeriesCollection { new LineSeries { Title = "Total Paid Invoices", Values = total }, new LineSeries { Title = "Total Last Year Paid Invoices", Values = totalLastYear }, }; YFormatter = value => value.ToString("P"); } DataContext = this; }