public IActionResult GetTychoLevel2ChartDataDeath([FromBody] TychoLevel2 data)
{
string disease = data.disease;
string state = data.state;
var GetTychoLevel2ChartDataDeath = (from t in context.TychoLevel2
where t.state == state &&
t.disease == disease &&
t.event_type == "DEATHS"
group t by t.year into ww
select new
{
Disease = ww.Select(di => di.disease),
NumberPerYear = (ww.Select(n => n.number)).Sum(),
Year = ww.Select(t => t.year),
});
var orderedData = GetTychoLevel2ChartDataDeath.OrderBy(y => y.Year); //"Year MUST be capitolized!//
return(Json(GetTychoLevel2ChartDataDeath)); //Object RETURNED!
}
public IActionResult GetTychoLevel2ChartData([FromBody] TychoLevel2 data)
{
string year = data.year;
string disease = data.disease;
string state = data.state;
var GetTychoLevel2ChartData = (from t in context.TychoLevel2
where t.year == year &&
t.state == state &&
t.disease == disease &&
t.event_type == "CASES"
group t by t.week into ww
select new
{
Disease = ww.Select(di => di.disease),
NumberPerWeek = (ww.Select(n => n.number)).Sum(),
Week = ww.Select(w => w.week),
});
var orderedData = GetTychoLevel2ChartData.OrderBy(w => w.Week);
return(Json(GetTychoLevel2ChartData)); //this dataset resides in the browser in memory, because the call came from the browser originally!
}
