public JsonResult GetCasesStatistics(CaseStatisticFilters filters)
{
var realCases = _virusCaseRepository.GetRealCases(filters);
var forecastCases = _virusCaseRepository.GetForecastCases(filters);
var totalCases = new TotalCaseStatisic
{
RealCases = realCases,
ForecastCases = forecastCases
};
return(Json(totalCases));
}
public List <CaseStatisic> GetForecastCases(CaseStatisticFilters filters)
{
if (filters.DateTo.HasValue && filters.DateTo <= DateTime.Now.Date)
{
return(new List <CaseStatisic>());
}
else
{
DateTime generateDateFrom;
DateTime generateDateTo;
if (!filters.DateFrom.HasValue || filters.DateFrom <= DateTime.Now.Date)
{
generateDateFrom = DateTime.Now.Date.AddDays(1);
}
else
{
generateDateFrom = filters.DateFrom.Value;
}
if (!filters.DateTo.HasValue)
{
generateDateTo = DateTime.Now.Date.AddDays(8);
}
else
{
generateDateTo = filters.DateTo.Value;
}
var statistic = new List <CaseStatisic>();
for (var startDate = generateDateFrom; startDate <= generateDateTo; startDate = startDate.AddDays(1))
{
Random rnd = new Random();
int caseNumber = rnd.Next(11);
statistic.Add(new CaseStatisic
{
CasesCount = caseNumber,
Date = startDate
});
}
return(statistic);
}
}
public List <CaseStatisic> GetRealCases(CaseStatisticFilters filters)
{
var cases = _context.VirusCases.Where(i => i.VirusPositive == true);
if (filters.DateFrom.HasValue)
{
cases = cases.Where(i => i.Date >= filters.DateFrom);
}
if (filters.DateTo.HasValue)
{
if (filters.DateTo > DateTime.Now.Date)
{
cases = cases.Where(i => i.Date <= DateTime.Now.Date);
}
else
{
cases = cases.Where(i => i.Date <= filters.DateTo);
}
}
if (filters.Gender.HasValue && filters.Gender != 'B')
{
cases = cases.Where(i => i.Gender == filters.Gender.Value);
}
if (!string.IsNullOrEmpty(filters.Region) && filters.Region != "-1")
{
cases = cases.Where(i => i.RegionId == filters.Region);
}
if (!string.IsNullOrEmpty(filters.WorkMode) && filters.WorkMode != "-1")
{
cases = cases.Where(i => i.WorkModeId == filters.WorkMode);
}
if (filters.ChildrenAmount.HasValue && filters.ChildrenAmount.Value >= 0)
{
cases = cases.Where(i => i.ChildrenAmount == filters.ChildrenAmount.Value);
}
if (filters.AgeFrom.HasValue && filters.AgeFrom.Value >= 0)
{
cases = cases.Where(i => i.Age >= filters.AgeFrom.Value);
}
if (filters.AgeTo.HasValue && filters.AgeTo.Value >= 0)
{
cases = cases.Where(i => i.Age <= filters.AgeTo.Value);
}
var statisics = cases.GroupBy(i => i.Date)
.Select(y => new CaseStatisic
{
CasesCount = y.Count(),
Date = y.Key
})
.OrderBy(i => i.Date)
.ToList();
List <CaseStatisic> caseStatisics = new List <CaseStatisic>();
//if (statisics.Count() > 0) {
DateTime dateFrom, dateTo;
if (!filters.DateFrom.HasValue)
{
dateFrom = statisics.First().Date;
}
else
{
dateFrom = filters.DateFrom.Value;
}
if (!filters.DateTo.HasValue)
{
dateTo = DateTime.Now.Date;
}
else if (filters.DateTo.Value > DateTime.Now.Date)
{
dateTo = DateTime.Now.Date;
}
else
{
dateTo = filters.DateTo.Value;
}
for (var startDate = dateFrom; startDate <= dateTo; startDate = startDate.AddDays(1))
{
var statObject = statisics.Where(x => x.Date == startDate).FirstOrDefault();
if (statObject == null)
{
caseStatisics.Add(new CaseStatisic()
{
Date = startDate, CasesCount = 0
});
}
else
{
caseStatisics.Add(statObject);
}
}
//}
return(caseStatisics);
}