public async Task <IEnumerable <SalesRecord> > FindByDate(DateTime?initial, DateTime?final) { IQueryable <SalesRecord> query = _context.Set <SalesRecord>().AsQueryable().AsNoTracking(); if (initial.HasValue && initial.Value != DateTime.MinValue) { query = query.Where(x => x.Date >= initial.Value); } if (final.HasValue && initial.Value != DateTime.MinValue && initial.Value != DateTime.MaxValue) { query = query.Where(x => x.Date <= final.Value); } return(await query.Include(x => x.Seller) .ThenInclude(x => x.Department) .ToListAsync()); }
public async Task <Department> FindById(int id) => await _context.Set <Department>().AsQueryable().AsNoTracking().FirstOrDefaultAsync(x => x.Id == id);
public async Task <IEnumerable <Seller> > FindAll() => await _dbContext.Set <Seller>().Include(x => x.Department).ToListAsync();