|
static private GetLatestBlogListDateRange ( CarrotCMSDataContext ctx, Guid siteID, DateTime dateBegin, DateTime dateEnd, bool bActiveOnly ) : IQueryable |
||
| ctx | CarrotCMSDataContext | |
| siteID | Guid | |
| dateBegin | DateTime | |
| dateEnd | DateTime | |
| bActiveOnly | bool | |
| Résultat | 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 <ContentDateLinks> GetSingleMonthBlogUpdateList(SiteData currentSite, DateTime monthDate, bool bActiveOnly)
{
List <ContentDateLinks> lstContent = new List <ContentDateLinks>();
DateTime dateBegin = monthDate.AddDays(0 - monthDate.Day).AddDays(1);
DateTime dateEnd = dateBegin.AddMonths(1).AddMilliseconds(-1);
if (currentSite != null)
{
dateBegin = currentSite.ConvertSiteTimeToUTC(dateBegin);
dateEnd = currentSite.ConvertSiteTimeToUTC(dateEnd);
}
IQueryable <vw_carrot_Content> query1 = CannedQueries.GetLatestBlogListDateRange(db, currentSite.SiteID, dateBegin, dateEnd, bActiveOnly);
lstContent = (from p in query1
group p by p.GoLiveDateLocal.Date into g
select new ContentDateLinks {
PostDate = g.Key, UseCount = g.Count()
}).ToList();
lstContent.ToList().ForEach(q => q.TheSite = currentSite);
return(lstContent);
}