public static Chart GeneratePieChart(ChartJSDataset chartDataset, List <string> labels)
{
PieDataset dataset = new()
{
Label = chartDataset.Title,
BackgroundColor = chartDataset.Colors,
HoverBackgroundColor = chartDataset.Colors,
Data = chartDataset.Values
};
ChartJSCore.Models.Data data = new()
{
Labels = labels,
Datasets = new List <Dataset>()
};
data.Datasets.Add(dataset);
return(new Chart
{
Type = Enums.ChartType.Pie,
Data = data
});
}
[NonAction]
public async Task <IActionResult> Index(GetStatistic getStatistic = null)
{
if (getStatistic.Start == default || getStatistic.End == default)
{
getStatistic = new GetStatistic {
Start = DateTime.Now.AddYears(-1), End = DateTime.Now
};
}
else if (!ModelState.IsValid)
{
return(View(getStatistic));
}
var user = await userManager.GetUserAsync(User);
getStatistic.SumCosts = await costsRepository.GetSumCostsAsync(user, getStatistic.Start, getStatistic.End);
var groupCostsByProduct = await costsRepository.GroupCostsByProductAsync(user, getStatistic.Start, getStatistic.End, take : 20);
List <string> productLabels = new();
List <ChartJSDataset> productsDatasets = new();
foreach (var cbp in groupCostsByProduct)
{
productLabels.Add(cbp.GroupName);
ChartJSDataset dataset = new(cbp.GroupName);
dataset.Add(Convert.ToDouble(cbp.Sum), NextChartColor);
productsDatasets.Add(dataset);
}
var groupCostsByCategory = await costsRepository.GroupCostsByCategoryAsync(user, getStatistic.Start, getStatistic.End);
List <string> categoryLabels = new();
ChartJSDataset costsDataset = new("Расходы по категориям");
foreach (var cbc in groupCostsByCategory)
{
categoryLabels.Add(cbc.GroupName);
costsDataset.Add(Convert.ToDouble(cbc.Sum), NextChartColor);
}
List <string> monthLabels = new();
ChartJSDataset costsSumDataset = new("Расходы за месяц", NextChartColor);
List <string> top5ProductNames = new();
for (int i = 0; i < 5 && i < productLabels.Count; i++)
{
top5ProductNames.Add(productLabels[i]);
}
int countTopProducts = productLabels.Count >= 5 ? 5 : productLabels.Count;
var top5ProductsDataset = new ChartJSDataset[countTopProducts];
for (int i = 0; i < top5ProductsDataset.Length; i++)
{
top5ProductsDataset[i] = new ChartJSDataset(top5ProductNames[i], NextChartColor);
}
DateTime tempDate = getStatistic.Start;
while (tempDate < getStatistic.End)
{
monthLabels.Add(tempDate.ToString("MMMM") + $" {tempDate.Year}");
decimal sumCostsPerMonth = await costsRepository.GetSumCostsPerMonthAsync(user, tempDate);
costsSumDataset.AddValue(Convert.ToDouble(sumCostsPerMonth));
for (int i = 0; i < top5ProductsDataset.Length; i++)
{
decimal productSumPerMonth = await costsRepository.GetSumCostsPerMonthAsync(user, top5ProductNames[i], tempDate);
top5ProductsDataset[i].AddValue(Convert.ToDouble(productSumPerMonth));
}
tempDate = tempDate.AddMonths(1);
}
ViewData["productsBarChart"] = GenerateBarChart(productsDatasets);
ViewData["categoriesPieChart"] = GeneratePieChart(costsDataset, categoryLabels);
ViewData["costsLineChart"] = GenerateLineChart(costsSumDataset, monthLabels);
ViewData["topProductsLineChart"] = GenerateLineChart(top5ProductsDataset, monthLabels);
getStatistic.IsCompleteStatistic = true;
return(View(getStatistic));
}
public static Chart GenerateLineChart(ChartJSDataset chartDataset, List <string> labels)
{
return(GenerateLineChart(new[] { chartDataset }, labels));
}
