internal static IQueryable<vw_carrot_Content> GetAllBlogList(CarrotCMSDataContext ctx, Guid siteID) {
return (from ct in ctx.vw_carrot_Contents
orderby ct.NavOrder, ct.NavMenuText
where ct.SiteID == siteID
&& ct.IsLatestVersion == true
&& ct.ContentTypeID == ContentPageType.GetIDByType(ContentPageType.PageType.BlogEntry)
select ct);
}
internal static IQueryable<vw_carrot_Content> FindPageByTitleAndDate(CarrotCMSDataContext ctx, Guid siteID, string sTitle, string sFileNameFrag, DateTime dateCreate) {
return (from ct in ctx.vw_carrot_Contents
orderby ct.NavOrder, ct.NavMenuText
where ct.SiteID == siteID
&& ct.IsLatestVersion == true
&& (ct.PageHead.ToLower() == sTitle.ToLower() || ct.TitleBar.ToLower() == sTitle.ToLower())
&& ct.FileName.ToLower().Contains(sFileNameFrag.ToLower())
&& ct.CreateDate.Date == dateCreate.Date
select ct);
}
internal static IQueryable<vw_carrot_Content> GetLatestContentList(CarrotCMSDataContext ctx, Guid siteID, bool bActiveOnly) {
return (from ct in ctx.vw_carrot_Contents
orderby ct.NavOrder, ct.NavMenuText
where ct.SiteID == siteID
&& ct.IsLatestVersion == true
&& ct.ContentTypeID == ContentPageType.GetIDByType(ContentPageType.PageType.ContentEntry)
&& (ct.PageActive == true || bActiveOnly == false)
&& (ct.GoLiveDate < DateTime.UtcNow || bActiveOnly == false)
&& (ct.RetireDate > DateTime.UtcNow || bActiveOnly == false)
select ct);
}
internal static IQueryable<vw_carrot_Content> TopLevelPages(CarrotCMSDataContext ctx, Guid siteID, bool bActiveOnly) {
SearchParameterObject sp = new SearchParameterObject {
SiteID = siteID,
DateCompare = DateTime.UtcNow,
ContentTypeID = ContentPageType.GetIDByType(ContentPageType.PageType.ContentEntry),
ContentType = ContentPageType.PageType.ContentEntry,
ActiveOnly = bActiveOnly
};
return cqTopLevelPages(ctx, sp);
}
internal static IQueryable<vw_carrot_ContentSnippet> GetSnippets(CarrotCMSDataContext ctx, Guid siteID, bool bActiveOnly) {
return (from ct in ctx.vw_carrot_ContentSnippets
orderby ct.ContentSnippetName
where ct.SiteID == siteID
&& ct.IsLatestVersion == true
&& (ct.ContentSnippetActive == true || bActiveOnly == false)
&& (ct.GoLiveDate < DateTime.UtcNow || bActiveOnly == false)
&& (ct.RetireDate > DateTime.UtcNow || bActiveOnly == false)
&& ct.IsLatestVersion == true
select ct);
}
internal static IQueryable<vw_carrot_Comment> FindCommentsByDate(CarrotCMSDataContext ctx, Guid siteID, Guid rootContentID, DateTime postDate, string postIP, string sCommentText)
{
return (from r in ctx.vw_carrot_Comments
orderby r.CreateDate descending
where r.SiteID == siteID
&& r.Root_ContentID == rootContentID
&& r.CreateDate.Date == postDate.Date
&& r.CommenterIP == postIP
&& r.PostComment.Trim() == sCommentText.Trim()
select r);
}
public static CarrotCMSDataContext Create(IDbConnection connection) {
#if DEBUG
CarrotCMSDataContext _db = new CarrotCMSDataContext(connection);
DataDiagnostic dd = new DataDiagnostic(_db, iDBConnCounter);
iDBConnCounter++;
if (iDBConnCounter > 4096) {
iDBConnCounter = 0;
}
return _db;
#endif
return new CarrotCMSDataContext(connection);
}
public static CarrotCMSDataContext Create(IDbConnection connection)
{
#if DEBUG
CarrotCMSDataContext _db = new CarrotCMSDataContext(connection);
DataDiagnostic dd = new DataDiagnostic(_db, iDBConnCounter);
iDBConnCounter++;
if (iDBConnCounter > 4096)
{
iDBConnCounter = 0;
}
return(_db);
#endif
return(new CarrotCMSDataContext(connection));
}
internal static IQueryable<vw_carrot_Content> GetLatestContentByParent(CarrotCMSDataContext ctx, Guid siteID, Guid? parentContentID, bool bActiveOnly) {
SearchParameterObject sp = new SearchParameterObject {
SiteID = siteID,
ParentContentID = parentContentID,
DateCompare = DateTime.UtcNow,
ActiveOnly = bActiveOnly
};
return cqGetLatestContentByParent1(ctx, sp);
}
internal static IQueryable<vw_carrot_Content> GetLatestContentBySibling(CarrotCMSDataContext ctx, Guid siteID, string sPage, bool bActiveOnly) {
SearchParameterObject sp = new SearchParameterObject {
SiteID = siteID,
FileName = sPage,
DateCompare = DateTime.UtcNow,
ActiveOnly = bActiveOnly
};
return cqGetLatestContentBySibling2(ctx, sp);
}
internal static vw_carrot_ContentSnippet GetLatestContentSnippetByID(CarrotCMSDataContext ctx, Guid siteID, bool bActiveOnly, Guid itemID) {
SearchParameterObject sp = new SearchParameterObject {
SiteID = siteID,
DateCompare = DateTime.UtcNow,
ActiveOnly = bActiveOnly,
ItemSlugID = itemID
};
return cqGetLatestContentSnippetByID(ctx, sp);
}
internal static vw_carrot_Content GetLatestContentByURL(CarrotCMSDataContext ctx, Guid siteID, bool bActiveOnly, string sPage) {
SearchParameterObject sp = new SearchParameterObject {
SiteID = siteID,
DateCompare = DateTime.UtcNow,
ActiveOnly = bActiveOnly,
FileName = sPage
};
return cqGetLatestContentByURL(ctx, sp);
}
internal static IQueryable<vw_carrot_Comment> GetSiteContentComments(CarrotCMSDataContext ctx, Guid siteID)
{
return (from r in ctx.vw_carrot_Comments
orderby r.CreateDate descending
where r.SiteID == siteID
select r);
}
private void SaveKeywordsAndTags(CarrotCMSDataContext _db)
{
IQueryable<carrot_TagContentMapping> oldContentTags = CannedQueries.GetContentTagMapByContentID(_db, this.Root_ContentID);
IQueryable<carrot_CategoryContentMapping> oldContentCategories = CannedQueries.GetContentCategoryMapByContentID(_db, this.Root_ContentID);
if (this.ContentType == ContentPageType.PageType.BlogEntry) {
List<carrot_TagContentMapping> newContentTags = (from x in this.ContentTags
select new carrot_TagContentMapping {
ContentTagID = x.ContentTagID,
Root_ContentID = this.Root_ContentID,
TagContentMappingID = Guid.NewGuid()
}).ToList();
List<carrot_CategoryContentMapping> newContentCategories = (from x in this.ContentCategories
select new carrot_CategoryContentMapping {
ContentCategoryID = x.ContentCategoryID,
Root_ContentID = this.Root_ContentID,
CategoryContentMappingID = Guid.NewGuid()
}).ToList();
foreach (carrot_TagContentMapping s in newContentTags) {
_db.carrot_TagContentMappings.InsertOnSubmit(s);
}
foreach (carrot_CategoryContentMapping s in newContentCategories) {
_db.carrot_CategoryContentMappings.InsertOnSubmit(s);
}
}
_db.carrot_TagContentMappings.BatchDelete(oldContentTags);
_db.carrot_CategoryContentMappings.BatchDelete(oldContentCategories);
}
internal static IQueryable<vw_carrot_Content> PostsByDateRange(CarrotCMSDataContext ctx, Guid siteID, DateTime dateBegin, DateTime dateEnd, bool bActiveOnly) {
SearchParameterObject sp = new SearchParameterObject {
SiteID = siteID,
DateCompare = DateTime.UtcNow,
ContentTypeID = ContentPageType.GetIDByType(ContentPageType.PageType.BlogEntry),
ContentType = ContentPageType.PageType.BlogEntry,
DateBegin = dateBegin,
DateEnd = dateEnd,
ActiveOnly = bActiveOnly
};
return cqPostsByDateRange(ctx, sp);
}
internal static vw_carrot_Content FindHome(CarrotCMSDataContext ctx, Guid siteID, bool bActiveOnly) {
SearchParameterObject sp = new SearchParameterObject {
SiteID = siteID,
DateCompare = DateTime.UtcNow,
ActiveOnly = bActiveOnly
};
return cqFindHome(ctx, sp);
}
internal static Dictionary<string, float> GetTemplateCounts(CarrotCMSDataContext ctx, Guid siteID, ContentPageType.PageType pageType)
{
Guid contentTypeID = ContentPageType.GetIDByType(pageType);
return (from ct in ctx.vw_carrot_Contents.Where(c => c.SiteID == siteID && c.ContentTypeID == contentTypeID && c.IsLatestVersion == true)
group ct by ct.TemplateFile into grp
orderby grp.Count() descending
select new KeyValuePair<string, float>(grp.Key, (float)grp.Count()))
.ToDictionary(t => t.Key, t => t.Value);
}
internal static IQueryable<vw_carrot_Content> GetContentByCategoryURL(CarrotCMSDataContext ctx, Guid siteID, bool bActiveOnly, string sCatURL) {
SearchParameterObject sp = new SearchParameterObject {
SiteID = siteID,
DateCompare = DateTime.UtcNow,
FileName = sCatURL,
ActiveOnly = bActiveOnly
};
return cqGetContentByCategoryURL(ctx, sp);
}
internal static IQueryable<vw_carrot_TagURL> GetTagURLs(CarrotCMSDataContext ctx, Guid siteID)
{
return (from ct in ctx.vw_carrot_TagURLs
where ct.SiteID == siteID
select ct);
}
internal static IQueryable<vw_carrot_Comment> GetSiteContentCommentsByPostType(CarrotCMSDataContext ctx, Guid siteID, ContentPageType.PageType contentEntry, bool? approved, bool? spam)
{
return (from r in ctx.vw_carrot_Comments
orderby r.CreateDate descending
where r.SiteID == siteID
&& (spam == null || r.IsSpam == spam)
&& (approved == null || r.IsApproved == approved)
&& r.ContentTypeID == ContentPageType.GetIDByType(contentEntry)
select r);
}
internal static IQueryable<vw_carrot_Comment> GetSiteContentCommentsByPostType(CarrotCMSDataContext ctx, Guid siteID, ContentPageType.PageType contentEntry)
{
return (from r in ctx.vw_carrot_Comments
orderby r.CreateDate descending
where r.SiteID == siteID
&& r.ContentTypeID == ContentPageType.GetIDByType(contentEntry)
select r);
}
internal static int GetContentCountByParent(CarrotCMSDataContext ctx, Guid siteID, string parentPage, bool bActiveOnly) {
SearchParameterObject sp = new SearchParameterObject {
SiteID = siteID,
ParentFileName = parentPage,
DateCompare = DateTime.UtcNow,
ActiveOnly = bActiveOnly
};
return cqGetContentCountByParent2(ctx, sp);
}
internal static carrot_SerialCache SearchSeriaCache(CarrotCMSDataContext ctx, Guid itemID, string keyType) {
return SearchSeriaCache(ctx, SiteData.CurrentSiteID, SecurityData.CurrentUserGuid, itemID, keyType);
}
internal static IQueryable<vw_carrot_Content> GetLatestContentWithParent(CarrotCMSDataContext ctx, Guid siteID, Guid? parentContentID, bool bActiveOnly) {
SearchParameterObject sp = new SearchParameterObject {
SiteID = siteID,
ParentContentID = parentContentID,
ContentTypeID = ContentPageType.GetIDByType(ContentPageType.PageType.ContentEntry),
ContentType = ContentPageType.PageType.ContentEntry,
DateCompare = DateTime.UtcNow,
ActiveOnly = bActiveOnly
};
return cqGetLatestContentWithParent(ctx, sp);
}
public DataDiagnostic(CarrotCMSDataContext db)
{
db.Connection.StateChange += DBContextChange;
db.Log = new DebugTextWriter();
}
internal static carrot_SerialCache SearchSeriaCache(CarrotCMSDataContext ctx, Guid siteID, Guid userID, Guid itemID, string keyType) {
SearchParameterObject searchParm = new SearchParameterObject {
SiteID = siteID,
DateCompare = DateTime.UtcNow,
UserId = userID,
ItemID = itemID,
KeyType = keyType
};
return cqGetSerialCacheTbl(ctx, searchParm);
}
public DataDiagnostic(CarrotCMSDataContext db, int iCtr)
{
iDBCounter = iCtr;
db.Connection.StateChange += DBContextChange;
db.Log = new DebugTextWriter();
}
internal static IQueryable<carrot_WidgetData> GetWidgetDataByRootAll(CarrotCMSDataContext ctx, Guid rootWidgetID)
{
return (from r in ctx.carrot_WidgetDatas
where r.Root_WidgetID == rootWidgetID
select r);
}
internal static IQueryable<carrot_Content> GetBlogAllContentTbl(CarrotCMSDataContext ctx, Guid siteID)
{
return (from ct in ctx.carrot_RootContents
join c in ctx.carrot_Contents on ct.Root_ContentID equals c.Root_ContentID
where ct.SiteID == siteID
where c.IsLatestVersion == true
&& ct.ContentTypeID == ContentPageType.GetIDByType(ContentPageType.PageType.BlogEntry)
select c);
}
//=====================
internal static IQueryable<vw_carrot_Content> GetOtherNotPage(CarrotCMSDataContext ctx, Guid siteID, Guid rootContentID, Guid? parentContentID) {
SearchParameterObject sp = new SearchParameterObject {
SiteID = siteID,
RootContentID = rootContentID,
ParentContentID = parentContentID,
ContentTypeID = ContentPageType.GetIDByType(ContentPageType.PageType.ContentEntry),
DateCompare = DateTime.UtcNow
};
return cqGetOtherNotPage(ctx, sp);
}
internal static IQueryable<carrot_Widget> GetWidgetsByRootContent(CarrotCMSDataContext ctx, Guid rootContentID)
{
return (from r in ctx.carrot_Widgets
where r.Root_ContentID == rootContentID
select r);
}
internal static vw_carrot_Content GetNextPost(CarrotCMSDataContext ctx, Guid siteID, bool bActiveOnly, Guid rootContentID) {
SearchParameterObject sp = new SearchParameterObject {
SiteID = siteID,
RootContentID = rootContentID,
DateCompare = DateTime.UtcNow,
ActiveOnly = bActiveOnly
};
return cqGetNextPost(ctx, sp);
}
internal static IQueryable<carrot_RootContent> GetAllRootTbl(CarrotCMSDataContext ctx, Guid siteID)
{
return (from ct in ctx.carrot_RootContents
where ct.SiteID == siteID
select ct);
}