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()); }