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