private string ReplacePageSortOrder(string sql, PageResultSetOrder pageOrder)
{
string dir, field;
switch (pageOrder)
{
case PageResultSetOrder.PublishDateAscending:
field = "r.RevisionDate";
dir = "ASC";
break;
case PageResultSetOrder.PublishDateDescending:
field = "r.RevisionDate";
dir = "DESC";
break;
case PageResultSetOrder.Random:
field = "random(*)";
dir = "ASC";
break;
default:
throw new Exception("Unexpected value for PageResultSetOrder (" + pageOrder + ")");
}
return(sql.Replace("$FIELD", field).Replace("$DIRECTION", dir));
}
public PageResultSet(List <Page> list, long total, long pageSize, long pageNumber, PageResultSetOrder pageOrder)
{
pages = list;
totalResults = total;
this.pageSize = pageSize;
this.pageNumber = pageNumber;
pageCount = pageSize == 0 ? 1 : total / pageSize + (total % pageSize == 0 ? 0 : 1);
this.pageOrder = pageOrder;
if (total > 0)
{
firstResultIndex = Math.Max((pageNumber - 1) * pageSize, 0);
lastResultIndex = firstResultIndex + Math.Max(list.Count - 1, 0);
}
}
public PageResultSet(List<Page> list, long total, long pageSize, long pageNumber, PageResultSetOrder pageOrder)
{
pages = list;
totalResults = total;
this.pageSize = pageSize;
this.pageNumber = pageNumber;
pageCount = pageSize == 0 ? 1 : total / pageSize + (total % pageSize == 0 ? 0 : 1);
this.pageOrder = pageOrder;
if (total > 0)
{
firstResultIndex = Math.Max((pageNumber - 1) * pageSize, 0);
lastResultIndex = firstResultIndex + Math.Max(list.Count - 1, 0);
}
}
private string ReplacePageSortOrder(string sql, PageResultSetOrder pageOrder)
{
string dir, field;
switch (pageOrder)
{
case PageResultSetOrder.PublishDateAscending:
field = "r.RevisionDate";
dir = "ASC";
break;
case PageResultSetOrder.PublishDateDescending:
field = "r.RevisionDate";
dir = "DESC";
break;
case PageResultSetOrder.Random:
field = "random(*)";
dir = "ASC";
break;
default:
throw new Exception("Unexpected value for PageResultSetOrder (" + pageOrder + ")");
}
return sql.Replace("$FIELD", field).Replace("$DIRECTION", dir);
}
