/// <summary>
/// Gets the entities sorted and paged.
/// </summary>
/// <param name="parameters">The parameters.</param>
/// <param name="sql">The SQL.</param>
/// <param name="defaultOrderBy">The default order by.</param>
/// <returns></returns>
protected PagedList <TEntity> GetSortedAndPaged(SortAndPagingParameters parameters, Sql sql, string defaultOrderBy)
{
string orderBy;
string sortColumnName;
if (!string.IsNullOrEmpty(parameters.Sort) && EntityToColumnMap.TryGetValue(parameters.Sort, out sortColumnName))
{
orderBy = sortColumnName + " " + parameters.SortDir;
}
else
{
orderBy = defaultOrderBy;
}
if (!string.IsNullOrEmpty(orderBy))
{
sql.OrderBy(orderBy);
}
return(GetPaged <TEntity>(parameters.Page, parameters.PageSize, sql));
}
/// <summary>
/// Gets the paged list with calculation views.
/// </summary>
/// <param name="parameters">The parameters.</param>
/// <returns></returns>
public PagedList <CalculationView> GetForGrid(SortAndPagingParameters parameters)
{
return(calculationViewDepot.GetForGrid(parameters));
}
/// <summary>
/// Gets view for grid.
/// </summary>
/// <param name="parameters">The parameters.</param>
/// <returns></returns>
public PagedList<CalculationView> GetForGrid(SortAndPagingParameters parameters)
{
Sql sql = GetViewSql();
return GetSortedAndPaged(parameters, sql, nameof(CalculationView.Id));
}
