public void GetData_FilterByLogDate_ReturnFilteredResult(string from, string to, int result)
{
SetupForGetData();
var filterData = new FilteringParams.Data {
UserId = null, From = DateTime.Parse(from), To = DateTime.Parse(to)
};
var res = _service.GetData(Guid.Parse("00000000-0000-0000-0000-0000000000A1"), filterData);
Assert.Equal(result, res.Length);
}
public void GetData_FilterByUserId_ReturnFilteredResult(string userId, int result)
{
SetupForGetData();
var filterData = new FilteringParams.Data {
UserId = Guid.Parse(userId)
};
var res = _service.GetData(Guid.Parse("00000000-0000-0000-0000-0000000000A1"), filterData);
Assert.Equal(result, res.Length);
}
public async Task <IActionResult> GetData(Guid serviceId, [FromQuery] FilteringParams.Data filter)
{
var userId = Utility.GetCurrentUserId(User);
var service = await _servicesService.GetById(serviceId, userId);
if (service == null)
{
return(Forbid());
}
return(Ok(_mapper.Map <ServiceLogDTO[]>(_service.GetData(serviceId, filter))));
}
public ServiceLogs[] GetData(Guid serviceId, FilteringParams.Data filters)
{
var query = _serviceLogStorage.JoinWithServiceDataAndProperty();
query = GetQueryOrder(query, filters.Sort);
return(query.Where(
x => x.ServiceId == serviceId &&
(filters.UserId == null || x.UserId == filters.UserId) &&
(filters.From == null || x.LogDate >= filters.From) &&
(filters.To == null || x.LogDate <= filters.To)
).Skip(filters.Offset).Take(filters.Limit).ToArray());
}
