Beispiel #1
0
        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);
        }
Beispiel #2
0
 public async Task <IEnumerable <HoursEntity> > GetAsync(HoursFilters filter)
 {
     return(await _hoursQueries.GetAsync(filter));
 }