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