|
static private GetLatestBlogList ( CarrotCMSDataContext ctx, Guid siteID, bool bActiveOnly ) : IQueryable |
||
| ctx | CarrotCMSDataContext | |
| siteID | Guid | |
| bActiveOnly | bool | |
| return | IQueryable |
|
public List <SiteNav> GetFilteredContentPagedList(SiteData currentSite, string sFilterPath, bool bActiveOnly,
int pageSize, int pageNumber, string sortField, string sortDir)
{
IQueryable <vw_carrot_Content> query1 = null;
Guid siteID = currentSite.SiteID;
bool bFound = false;
if (currentSite.CheckIsBlogCategoryPath(sFilterPath))
{
query1 = CannedQueries.GetContentByCategoryURL(db, siteID, bActiveOnly, sFilterPath);
bFound = true;
}
if (currentSite.CheckIsBlogTagPath(sFilterPath))
{
query1 = CannedQueries.GetContentByTagURL(db, siteID, bActiveOnly, sFilterPath);
bFound = true;
}
if (currentSite.CheckIsBlogEditorFolderPath(sFilterPath))
{
query1 = CannedQueries.GetContentByUserURL(db, siteID, bActiveOnly, sFilterPath);
bFound = true;
}
if (currentSite.CheckIsBlogDateFolderPath(sFilterPath))
{
BlogDatePathParser p = new BlogDatePathParser(currentSite, sFilterPath);
query1 = CannedQueries.GetLatestBlogListDateRange(db, siteID, p.DateBeginUTC, p.DateEndUTC, bActiveOnly);
bFound = true;
}
if (!bFound)
{
query1 = CannedQueries.GetLatestBlogList(db, siteID, bActiveOnly);
}
return(PerformDataPagingQueryableContent(siteID, bActiveOnly, pageSize, pageNumber, sortField, sortDir, query1));
}
public int GetFilteredContentPagedCount(SiteData currentSite, string sFilterPath, bool bActiveOnly)
{
IQueryable <vw_carrot_Content> query1 = null;
Guid siteID = currentSite.SiteID;
bool bFound = false;
if (currentSite.CheckIsBlogCategoryPath(sFilterPath))
{
query1 = CannedQueries.GetContentByCategoryURL(db, siteID, bActiveOnly, sFilterPath);
bFound = true;
}
if (currentSite.CheckIsBlogTagPath(sFilterPath))
{
query1 = CannedQueries.GetContentByTagURL(db, siteID, bActiveOnly, sFilterPath);
bFound = true;
}
if (currentSite.CheckIsBlogEditorFolderPath(sFilterPath))
{
query1 = CannedQueries.GetContentByUserURL(db, siteID, bActiveOnly, sFilterPath);
bFound = true;
}
if (currentSite.CheckIsBlogDateFolderPath(sFilterPath))
{
BlogDatePathParser p = new BlogDatePathParser(currentSite, sFilterPath);
query1 = CannedQueries.GetLatestBlogListDateRange(db, siteID, p.DateBeginUTC, p.DateEndUTC, bActiveOnly);
bFound = true;
}
if (!bFound)
{
query1 = CannedQueries.GetLatestBlogList(db, siteID, bActiveOnly);
}
return(query1.Count());
}
public List <SiteNav> GetLatestPostUpdates(Guid siteID, int iUpdates, bool bActiveOnly)
{
List <SiteNav> lstContent = (from ct in CannedQueries.GetLatestBlogList(db, siteID, bActiveOnly)
orderby ct.EditDate descending
select new SiteNav(ct)).Take(iUpdates).ToList();
return(lstContent);
}
public List <SiteNav> GetLatestContentPagedList(Guid siteID, ContentPageType.PageType postType, bool bActiveOnly,
int pageSize, int pageNumber, string sortField, string sortDir)
{
IQueryable <vw_carrot_Content> query1 = null;
if (postType == ContentPageType.PageType.ContentEntry)
{
query1 = CannedQueries.GetLatestContentList(db, siteID, bActiveOnly);
}
else
{
query1 = CannedQueries.GetLatestBlogList(db, siteID, bActiveOnly);
}
return(PerformDataPagingQueryableContent(siteID, bActiveOnly, pageSize, pageNumber, sortField, sortDir, query1));
}
