public async Task <IEnumerable <HoursEntity> > GetAsync(HoursFilters filters) { var queryResponse = await(from h in _db.Hours select h).ToListAsync(); if (filters.Id.ValidField()) { queryResponse = queryResponse.Where(x => x.Id.Equals(filters.Id)).ToList(); } if (filters.Developer.ValidField()) { queryResponse = queryResponse.Where(x => x.Developer.Contains(filters.Developer)).ToList(); } if (filters.StartDate.ToString().ValidDate()) { var nDate = filters.StartDate.Value.AddMilliseconds(-1); queryResponse = queryResponse.Where(f => f.StartDate >= nDate).ToList(); } if (filters.EndDate.ToString().ValidDate()) { var nDate = filters.EndDate.Value.AddDays(1).AddSeconds(-1); queryResponse = queryResponse.Where(f => f.EndDate <= nDate).ToList(); } return(queryResponse); }
public async Task <IEnumerable <HoursEntity> > GetAsync(HoursFilters filter) { return(await _hoursQueries.GetAsync(filter)); }