|
static private GetContentSiteSearch ( CarrotCMSDataContext ctx, Guid siteID, bool bActiveOnly, string searchTerm ) : IQueryable |
||
| ctx | CarrotCMSDataContext | |
| siteID | Guid | |
| bActiveOnly | bool | |
| searchTerm | string | |
| return | IQueryable |
|
internal static IQueryable<vw_carrot_Content> GetContentSiteSearch(CarrotCMSDataContext ctx, Guid siteID, bool bActiveOnly, string searchTerm)
{
return (from ct in ctx.vw_carrot_Contents
where ct.SiteID == siteID
&& (ct.PageText.Contains(searchTerm)
|| ct.LeftPageText.Contains(searchTerm)
|| ct.RightPageText.Contains(searchTerm)
|| ct.TitleBar.Contains(searchTerm)
|| ct.MetaDescription.Contains(searchTerm)
|| ct.MetaKeyword.Contains(searchTerm)
)
&& (ct.PageActive == true || bActiveOnly == false)
&& (ct.GoLiveDate < DateTime.UtcNow || bActiveOnly == false)
&& (ct.RetireDate > DateTime.UtcNow || bActiveOnly == false)
&& ct.IsLatestVersion == true
select ct);
}
public List <SiteNav> GetLatestContentSearchList(Guid siteID, string searchTerm, bool bActiveOnly, int pageSize, int pageNumber, string sortField, string sortDir)
{
IQueryable <vw_carrot_Content> query1 = CannedQueries.GetContentSiteSearch(db, siteID, bActiveOnly, searchTerm);
return(PerformDataPagingQueryableContent(siteID, bActiveOnly, pageSize, pageNumber, sortField, sortDir, query1));
}
