public async Task <Paginated <ConsumeReading> > Get(Domain.ConsumeFilter filter)
{
var query = _database.Consume.AsQueryable()
.Filter(filter)
.AsNoTracking();
return(new Paginated <ConsumeReading>
{
Total = await query.CountAsync(),
Result = (await query.ToListAsync()).Select(c => new ConsumeReading
{
Id = c.Id,
Barcode = c.Barcode,
Product = GetBrand(c),
TimeStamp = c.TimeStamp
}).ToList()
});
}
public static IQueryable <Domain.Models.Consume> Filter(this IQueryable <Domain.Models.Consume> q, Domain.ConsumeFilter filter)
{
if (filter.From.HasValue)
{
q = q.Where(c => c.TimeStamp >= filter.From.Value);
}
return(q);
}