public async Task <ActionResult> GetTemperature([FromQuery] DateTime?filterDate, [FromQuery] Guid?location = null) { var query = new GetTemperatureQuery() { FilterDate = filterDate, Location = location, }; var results = await _mediator.Send(query); return(Ok(results)); }
public Task <List <TemperatureVm> > Handle(GetTemperatureQuery request, CancellationToken cancellationToken) { var currentDate = _dateTimeProvider.GetUtcNow(); request.WithDefaultValues(currentDate.AddDays(-2), currentDate); int granulation = (int)(request.Granulation ?? default); Debug.Assert(request.From != null, "request.From != null"); var fromDate = request.From.Value; return(_applicationDbContext.WeatherStationAirParameters .AsNoTracking() .Where(x => x.MeasurementStartTime >= request.From && x.MeasurementEndTime <= request.To) .Select(x => new { TimestampGroup = granulation == (int)DateRangeGranulation.Year ? EF.Functions.DateDiffYear(fromDate, x.MeasurementEndTime) : granulation == (int)DateRangeGranulation.Month ? EF.Functions.DateDiffMonth(fromDate, x.MeasurementEndTime) : EF.Functions.DateDiffSecond(fromDate, x.MeasurementEndTime) / granulation, x.Temperature }) .GroupBy(x => x.TimestampGroup) .OrderBy(x => x.Key) .Select(g => new TemperatureVm { Timestamp = DateTime.SpecifyKind( granulation == (int)DateRangeGranulation.Year ? fromDate.AddYears(g.Key) : granulation == (int)DateRangeGranulation.Month ? fromDate.AddMonths(g.Key) : fromDate.AddSeconds(g.Key * granulation), DateTimeKind.Utc), Temperature = Math.Round(g.Average(x => x.Temperature), 2), MaxTemperature = Math.Round(g.Max(x => x.Temperature), 2), MinTemperature = Math.Round(g.Min(x => x.Temperature), 2) }) .ToListAsync(cancellationToken)); }
public Task <IEnumerable <TemperatureVm> > GetTemperature(GetTemperatureQuery query) { return(_apiClient.Get <GetTemperatureQuery, IEnumerable <TemperatureVm> >("GreenhouseData/temperature", query)); }
public async Task <IActionResult> GetTemperature([FromQuery] GetTemperatureQuery query) { return(Ok(await _mediator.Send(query))); }