private void loadPurchaseAndIncomeChart() { var purchaseChartValue = new ChartValues <decimal>(); var IncomeChartValue = new ChartValues <decimal>(); var BillAmountChartValue = new ChartValues <decimal>(); purchaseChartValue.AddRange(StatisticDataList.OrderBy(x => x.Statistic.ID).Select(x => x.Statistic.Price_purchase_total).ToList()); IncomeChartValue.AddRange(StatisticDataList.OrderBy(x => x.Statistic.ID).Select(x => x.Statistic.Income).ToList()); BillAmountChartValue.AddRange(StatisticDataList.OrderBy(x => x.Statistic.ID).Select(x => x.Statistic.Total_tax_included).ToList()); PurchaseAndIncomeSeriesCollection = new SeriesCollection { new LineSeries { Title = "Sale", Values = BillAmountChartValue }, new LineSeries { Title = "Purchase", Values = purchaseChartValue }, new LineSeries { Title = "Income", Values = IncomeChartValue } }; PurchaseAndIncomeLabels = StatisticDataList.OrderBy(x => x.Statistic.ID).Select(x => x.Statistic.Bill_datetime.ToString("MMMM")).ToArray(); //Labels = new[] { "Jan", "Feb", "Mar", "Apr", "May" }; }
private void loadStatisticPayReceived() { _chartValueList = new ChartValues <DateTimePoint>(); var statistics = StatisticDataList.OrderBy(x => x.Statistic.Date_limit).ToList(); foreach (var statisticModel in statistics) { _chartValueList.Add(new DateTimePoint(statisticModel.Statistic.Pay_date, (double)statisticModel.Statistic.Pay_received)); } }
private void salesChart() { var payReceivedChartValue = new ChartValues <decimal>(); var invoiceAmountChartValue = new ChartValues <decimal>(); payReceivedChartValue.AddRange(StatisticDataList.OrderBy(x => x.Statistic.ID).Select(x => x.Statistic.Total).ToList()); CreditSeriesCollection = new SeriesCollection { new LineSeries { Title = "Pay received", Values = payReceivedChartValue } }; PayReceivedAndBillLabels = new[] { "Jan", "Feb", "Mar", "Apr", "May" };; // StatisticDataList.OrderBy(x => x.Statistic.ID).Select(x => x.Statistic.InvoiceDate.ToString("MMM")).ToArray(); }