static private GetLatestContentList ( CarrotCMSDataContext ctx, Guid siteID, bool bActiveOnly ) : IQueryable |
||
ctx | CarrotCMSDataContext | |
siteID | Guid | |
bActiveOnly | bool | |
return | IQueryable |
public List <SiteNav> GetMasterNavigation(Guid siteID, bool bActiveOnly) { List <SiteNav> lstContent = (from ct in CannedQueries.GetLatestContentList(db, siteID, bActiveOnly) select new SiteNav(ct)).ToList(); return(lstContent); }
public List <SiteNav> GetLatestUpdates(Guid siteID, int iUpdates, bool bActiveOnly) { List <SiteNav> lstContent = (from ct in CannedQueries.GetLatestContentList(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)); }
public List <SiteNav> GetLevelDepthNavigation(Guid siteID, int iDepth, bool bActiveOnly) { List <SiteNav> lstContent = null; List <Guid> lstSub = new List <Guid>(); if (iDepth < 1) { iDepth = 1; } if (iDepth > 10) { iDepth = 10; } List <Guid> lstTop = CompiledQueries.TopLevelPages(db, siteID, false).Select(z => z.Root_ContentID).ToList(); while (iDepth > 1) { lstSub = (from ct in CannedQueries.GetLatestContentList(db, siteID, bActiveOnly) where ct.SiteID == siteID && ct.ShowInSiteNav == true && (ct.PageActive == true || bActiveOnly == false) && ct.IsLatestVersion == true && (ct.GoLiveDate < DateTime.UtcNow || bActiveOnly == false) && (ct.RetireDate > DateTime.UtcNow || bActiveOnly == false) && (!lstTop.Contains(ct.Root_ContentID) && lstTop.Contains(ct.Parent_ContentID.Value)) select ct.Root_ContentID).Distinct().ToList(); lstTop = lstTop.Union(lstSub).ToList(); iDepth--; } lstContent = (from ct in CannedQueries.GetLatestContentList(db, siteID, bActiveOnly) orderby ct.NavOrder, ct.NavMenuText where ct.SiteID == siteID && ct.ShowInSiteNav == true && (ct.PageActive == true || bActiveOnly == false) && ct.IsLatestVersion == true && (ct.GoLiveDate < DateTime.UtcNow || bActiveOnly == false) && (ct.RetireDate > DateTime.UtcNow || bActiveOnly == false) && lstTop.Contains(ct.Root_ContentID) select new SiteNav(ct)).ToList(); return(lstContent); }
public List <SiteNav> GetTwoLevelNavigation(Guid siteID, bool bActiveOnly) { List <SiteNav> lstContent = null; List <Guid> lstTop = CompiledQueries.TopLevelPages(db, siteID, false).Select(z => z.Root_ContentID).ToList(); lstContent = (from ct in CannedQueries.GetLatestContentList(db, siteID, bActiveOnly) orderby ct.NavOrder, ct.NavMenuText where ct.SiteID == siteID && (ct.PageActive == true || bActiveOnly == false) && (ct.GoLiveDate < DateTime.UtcNow || bActiveOnly == false) && (ct.RetireDate > DateTime.UtcNow || bActiveOnly == false) && ct.IsLatestVersion == true && (lstTop.Contains(ct.Root_ContentID) || lstTop.Contains(ct.Parent_ContentID.Value)) select new SiteNav(ct)).ToList(); return(lstContent); }
public int GetSiteContentCount(Guid siteID) { int iCount = CannedQueries.GetLatestContentList(db, siteID, false).Count(); return(iCount); }