public IActionResult OnGet()
{
if (HttpContext.Session.GetString("email") == null)
{
return(RedirectToPage("Login"));
}
Costs = CostsRepository.GetCostsByEmail(HttpContext.Session.GetString("email"));
Vehicles = VehiclesRepository.GetVehiclesByEmail(HttpContext.Session.GetString("email"));
//Calculates all overdue fixedCosts
foreach (var item in Vehicles)
{
CostsRepository.FixedCostsMontly(item.License);
}
//Chart settings
Chart chart = new Chart();
chart.Type = Enums.ChartType.Line;
ChartJSCore.Models.Data data = new ChartJSCore.Models.Data();
data.Labels = new List <string>()
{
"Januari", "Februari", "Maart", "April", "Mei", "Juni", "Juli", "Augustus", "September", "Oktober", "November", "December"
};
data.Datasets = new List <Dataset>();
Random random = new Random();
var year = HttpContext.Request.Query["Year"];
if (!string.IsNullOrWhiteSpace(year))
{
Year = Convert.ToInt32(year);
}
else
{
Year = DateTime.Now.Year;
}
//Foreach to loop through every vehicle to get AnnualCosts and set it in the chart
foreach (var vehicle in Vehicles)
{
int[,] randomColor = new int[3, 1] {
{ random.Next(0, 255) }, { random.Next(0, 255) }, { random.Next(0, 255) }
};
IList <double?> annualCosts = CostsRepository.GetAnnualCosts(vehicle.License, Year);
LineDataset dataset = new LineDataset()
{
Label = vehicle.Brand_Name + ' ' + vehicle.Model_Name,
Data = annualCosts,
Fill = "false",
LineTension = 0.1,
BackgroundColor = ChartColor.FromRgba((byte)randomColor[0, 0], (byte)randomColor[1, 0], (byte)randomColor[2, 0], 0.4),
BorderColor = ChartColor.FromRgb((byte)randomColor[0, 0], (byte)randomColor[1, 0], (byte)randomColor[2, 0]),
BorderCapStyle = "butt",
BorderDash = new List <int> {
},
BorderDashOffset = 0.0,
BorderJoinStyle = "miter",
PointBorderColor = new List <ChartColor> {
ChartColor.FromRgb(75, 192, 192)
},
PointBackgroundColor = new List <ChartColor> {
ChartColor.FromHexString("#ffffff")
},
PointBorderWidth = new List <int> {
1
},
PointHoverRadius = new List <int> {
5
},
PointHoverBackgroundColor = new List <ChartColor> {
ChartColor.FromRgb(75, 192, 192)
},
PointHoverBorderColor = new List <ChartColor> {
ChartColor.FromRgb(220, 220, 220)
},
PointHoverBorderWidth = new List <int> {
2
},
PointRadius = new List <int> {
1
},
PointHitRadius = new List <int> {
10
},
SpanGaps = false
};
data.Datasets.Add(dataset);
}
chart.Data = data;
ViewData["chart"] = chart;
return(Page());
}
