public async Task <IHttpActionResult> GetCountByDate(DateRegionDto dto)
{
if (dto.To <= dto.From)
{
return(BadRequest());
}
return(await Task.Run <IHttpActionResult>(() =>
{
var reports = _failureRepo.GetAll();
dto.From = dto.From.Date;
dto.To = dto.To.Date;
var count = (dto.To - dto.From).Days;
var result = Enumerable.Range(0, count)
.Select(n => dto.From.Date.AddDays(n))
.Select(d => reports.Select(r => r.Time).Count(t => SqlFunctions.DateDiff("dd", d, t) == 0));
return Ok(result);
}));
}
public IQueryable <FailureReportDto> Get()
{
return(_failureRepo.GetAll().ToDto());
}
