public Task <int> Count(EmissionPointPagination pagination)
{
var query = from e in context.EmissionPoints select e;
if (pagination.IsActive != "-")
{
query = query.Where(e => e.IsActive == Boolean.Parse(pagination.IsActive));
}
return(query.CountAsync());
}
public async Task <IActionResult> Count([FromQuery] EmissionPointPagination query)
{
var count = await repository.Count(query);
return(Json(new StandardResponse
{
Status = 200,
Data = count
}));
}
public Task <List <EmissionPoint> > Get(EmissionPointPagination pagination)
{
var query = from e in context.EmissionPoints select e;
if (pagination.IsActive != "-")
{
query = query.Where(e => e.IsActive == Boolean.Parse(pagination.IsActive));
}
query = query.Take(pagination.Page * pagination.Quantity);
query = query.Skip(pagination.Page * pagination.Quantity - pagination.Quantity);
query = query.OrderBy(e => e.Name);
//return (
// from e in context.EmissionPoints
// select new EmissionPoint
// {
// Id = e.Id,
// Name = e.Name,
// IsActive = e.IsActive
// }
//).ToListAsync();
return(query.ToListAsync());
}