public void ToggleSort()
{
SortParm srt = this.ParseSort();
if (!String.IsNullOrEmpty(this.SortByNew))
{
if (srt.SortField.ToLowerInvariant() == this.SortByNew.ToLowerInvariant())
{
if (srt.SortDirection.EndsWith("ASC"))
{
this.OrderBy = String.Format("{0} DESC", this.SortByNew);
}
else
{
this.OrderBy = String.Format("{0} ASC", this.SortByNew);
}
}
else
{
this.OrderBy = String.Format("{0} ASC", this.SortByNew);
this.PageNumber = 1;
}
}
this.SortByNew = String.Empty;
}
public SortParm ParseSort()
{
SortParm sort = new SortParm(this.OrderBy);
if (this.DefaultMax && this.TotalPages > 0)
{
this.PageNumber = this.TotalPages;
}
return(sort);
}
public SortParm ParseSort()
{
SortParm sort = new SortParm(this.OrderBy);
if (this.DefaultMax && this.TotalPages > 0) {
this.PageNumber = this.TotalPages;
}
return sort;
}
public List<ContentPage> GetPagedSortedContent(Guid siteID, ContentPageType.PageType entryType, bool bActiveOnly, int pageSize, int pageNumber, string sSortParm) {
SortParm srt = new SortParm(sSortParm);
IQueryable<vw_carrot_Content> query1 = CannedQueries.GetAllByTypeList(db, siteID, bActiveOnly, entryType);
return PerformDataPagingQueryableContent(siteID, bActiveOnly, pageSize, pageNumber, srt.SortField, srt.SortDirection, query1);
}
public static List<EditHistory> GetHistoryList(string orderBy, int pageNumber, int pageSize,
Guid siteID, bool showLatestOnly, DateTime? editDate, Guid? editUserID)
{
SortParm srt = new SortParm(orderBy);
if (String.IsNullOrEmpty(srt.SortField)) {
srt.SortField = "EditDate";
}
if (String.IsNullOrEmpty(srt.SortDirection)) {
srt.SortDirection = "DESC";
}
Guid userID = Guid.Empty;
if (editUserID.HasValue) {
userID = editUserID.Value;
}
DateTime dateStart = DateTime.UtcNow.Date.AddDays(-2);
DateTime dateEnd = DateTime.UtcNow.Date.AddDays(1);
if (editDate.HasValue) {
dateStart = editDate.Value.Date.AddDays(-8);
dateEnd = editDate.Value.Date.AddDays(1);
}
int startRec = pageNumber * pageSize;
if (pageSize < 0 || pageSize > 200) {
pageSize = 25;
}
if (pageNumber < 0 || pageNumber > 10000) {
pageNumber = 0;
}
bool IsContentProp = false;
srt.SortField = (from p in ReflectionUtilities.GetPropertyStrings(typeof(vw_carrot_EditHistory))
where p.ToLowerInvariant().Trim() == srt.SortField.ToLowerInvariant().Trim()
select p).FirstOrDefault();
if (!String.IsNullOrEmpty(srt.SortField)) {
IsContentProp = ReflectionUtilities.DoesPropertyExist(typeof(vw_carrot_EditHistory), srt.SortField);
}
using (CarrotCMSDataContext _db = CarrotCMSDataContext.Create()) {
List<EditHistory> _history = null;
IQueryable<vw_carrot_EditHistory> QueryInput = (from h in _db.vw_carrot_EditHistories
where h.SiteID == siteID
&& (!showLatestOnly || h.IsLatestVersion == true)
&& (!editDate.HasValue
|| (h.EditDate.Date >= dateStart.Date && h.EditDate.Date <= dateEnd.Date))
&& (!editUserID.HasValue || h.EditUserId == userID)
select h);
if (IsContentProp) {
QueryInput = ReflectionUtilities.SortByParm<vw_carrot_EditHistory>(QueryInput, srt.SortField, srt.SortDirection);
} else {
QueryInput = (from c in QueryInput
orderby c.EditDate descending
where c.SiteID == siteID
select c).AsQueryable();
}
_history = (from h in QueryInput.Skip(startRec).Take(pageSize) select new EditHistory(h)).ToList();
return _history;
}
}
public static List<PostComment> PaginateComments(IQueryable<vw_carrot_Comment> lstComments, int iPageNbr, int iPageSize, string SortBy) {
int startRec = iPageNbr * iPageSize;
SortParm srt = new SortParm(SortBy);
if (String.IsNullOrEmpty(srt.SortField)) {
srt.SortField = "CreateDate";
}
if (String.IsNullOrEmpty(srt.SortDirection)) {
srt.SortDirection = "DESC";
}
lstComments = ReflectionUtilities.SortByParm<vw_carrot_Comment>(lstComments, srt.SortField, srt.SortDirection);
return lstComments.Skip(startRec).Take(iPageSize).ToList().Select(v => new PostComment(v)).ToList();
}
