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); }