private PagedResultSet<ICoolingProject> FindProjectsQuery(ISession session, ResultOptions options)
{
var countQuery = ProjectsQuery(session)
.Select(Projections.RowCount())
.FutureValue<int>();
var result = ProjectsQuery(session)
.LimitResultSet(options)
.Future<ICoolingProject>();
return new PagedResultSet<ICoolingProject>(result.ToList(), countQuery.Value);
}
private PagedResultSet<ICustomer> FindCustomersQuery(ISession session, string searchString, ResultOptions options)
{
var countQuery = CustomersQuery(session, searchString)
.Select(Projections.RowCount())
.FutureValue<int>();
var result = CustomersQuery(session, searchString)
.LimitResultSet(options)
.Future<ICustomer>();
return new PagedResultSet<ICustomer>(result.ToList(), countQuery.Value);
}
public ActionResult Index(int page = 0, int pageSize = 20)
{
var options = new ResultOptions {Page = page, PageSize = pageSize};
var projects = _repository.WrapQueryInTransaction(s => FindProjectsQuery(s, options));
return View(new PagedViewModel<ICoolingProject>(projects, options));
}
public ActionResult Index(int page = 0, int pageSize = 20)
{
var options = new ResultOptions { Page = page, PageSize = pageSize };
var customers = _repository.WrapQueryInTransaction(s => FindCustomersQuery(s, string.Empty, options));
return View(new PagedViewModel<ICustomer>(customers, options));
}
