private void PerformCommonSaveRoot(SiteData pageSite, carrot_RootContent rc) { rc.Root_ContentID = this.Root_ContentID; rc.PageActive = true; rc.BlockIndex = false; rc.ShowInSiteMap = true; rc.SiteID = this.SiteID; rc.ContentTypeID = ContentPageType.GetIDByType(this.ContentType); rc.CreateDate = DateTime.UtcNow; if (this.CreateUserId != Guid.Empty) { rc.CreateUserId = this.CreateUserId; } else { rc.CreateUserId = SecurityData.CurrentUserGuid; } rc.GoLiveDate = pageSite.ConvertSiteTimeToUTC(this.GoLiveDate); rc.RetireDate = pageSite.ConvertSiteTimeToUTC(this.RetireDate); if (this.CreateDate.Year > 1950) { rc.CreateDate = pageSite.ConvertSiteTimeToUTC(this.CreateDate); } }
private void PerformCommonSave(SiteData pageSite, carrot_RootContent rc, carrot_Content c) { c.NavOrder = this.NavOrder; if (this.ContentType == ContentPageType.PageType.BlogEntry) { this.PageSlug = ContentPageHelper.ScrubFilename(this.Root_ContentID, this.PageSlug); this.FileName = ContentPageHelper.CreateFileNameFromSlug(this.SiteID, this.GoLiveDate, this.PageSlug); c.NavOrder = SiteData.BlogSortOrderNumber; } rc.GoLiveDate = pageSite.ConvertSiteTimeToUTC(this.GoLiveDate); rc.RetireDate = pageSite.ConvertSiteTimeToUTC(this.RetireDate); rc.GoLiveDateLocal = pageSite.ConvertUTCToSiteTime(rc.GoLiveDate); rc.PageSlug = this.PageSlug; rc.PageThumbnail = this.Thumbnail; c.Root_ContentID = this.Root_ContentID; rc.Heartbeat_UserId = this.Heartbeat_UserId; rc.EditHeartbeat = this.EditHeartbeat; rc.FileName = this.FileName; rc.PageActive = this.PageActive; rc.ShowInSiteNav = this.ShowInSiteNav; rc.BlockIndex = this.BlockIndex; rc.ShowInSiteMap = this.ShowInSiteMap; rc.FileName = ContentPageHelper.ScrubFilename(this.Root_ContentID, rc.FileName); c.Parent_ContentID = this.Parent_ContentID; c.IsLatestVersion = true; c.TitleBar = this.TitleBar; c.NavMenuText = this.NavMenuText; c.PageHead = this.PageHead; c.PageText = this.PageText; c.LeftPageText = this.LeftPageText; c.RightPageText = this.RightPageText; c.EditUserId = this.EditUserId; c.CreditUserId = this.CreditUserId; c.EditDate = DateTime.UtcNow; c.TemplateFile = this.TemplateFile; FixMeta(); c.MetaKeyword = this.MetaKeyword.Replace("\r\n", " ").Replace("\n", " ").Replace("\r", " ").Replace(" ", " "); c.MetaDescription = this.MetaDescription.Replace("\r\n", " ").Replace("\n", " ").Replace("\r", " ").Replace(" ", " "); this.Root_ContentID = rc.Root_ContentID; this.ContentID = c.ContentID; this.FileName = rc.FileName; this.EditDate = pageSite.ConvertUTCToSiteTime(c.EditDate); this.CreateDate = pageSite.ConvertUTCToSiteTime(rc.CreateDate); this.GoLiveDate = pageSite.ConvertUTCToSiteTime(rc.GoLiveDate); this.RetireDate = pageSite.ConvertUTCToSiteTime(rc.RetireDate); }
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); }
public void Save() { if (!this.IsWidgetPendingDelete) { SiteData site = new SiteData(CompiledQueries.cqGetSiteFromRootContentID(db, this.Root_ContentID)); carrot_Widget w = CompiledQueries.cqGetRootWidget(db, this.Root_WidgetID); bool bAdd = false; if (w == null) { bAdd = true; w = new carrot_Widget(); } if (this.Root_WidgetID == Guid.Empty) { this.Root_WidgetID = Guid.NewGuid(); } if (this.GoLiveDate.Year < 1900) { this.GoLiveDate = site.Now.AddMinutes(-5); } if (this.RetireDate.Year < 1900) { this.RetireDate = site.Now.AddYears(200); } w.Root_WidgetID = this.Root_WidgetID; w.WidgetOrder = this.WidgetOrder; w.Root_ContentID = this.Root_ContentID; w.PlaceholderName = this.PlaceholderName; w.ControlPath = this.ControlPath.Replace("~~/", "~/"); w.WidgetActive = this.IsWidgetActive; w.GoLiveDate = site.ConvertSiteTimeToUTC(this.GoLiveDate); w.RetireDate = site.ConvertSiteTimeToUTC(this.RetireDate); carrot_WidgetData wd = new carrot_WidgetData(); wd.Root_WidgetID = w.Root_WidgetID; wd.WidgetDataID = Guid.NewGuid(); wd.IsLatestVersion = true; wd.ControlProperties = this.ControlProperties; wd.EditDate = DateTime.UtcNow; carrot_WidgetData oldWD = CompiledQueries.cqGetWidgetDataByRootID(db, this.Root_WidgetID); //only add a new entry if the widget has some sort of change in the data stored. if (oldWD != null) { if (oldWD.ControlProperties != wd.ControlProperties) { oldWD.IsLatestVersion = false; db.carrot_WidgetDatas.InsertOnSubmit(wd); } } else { db.carrot_WidgetDatas.InsertOnSubmit(wd); } if (bAdd) { db.carrot_Widgets.InsertOnSubmit(w); } db.SubmitChanges(); } else { DeleteAll(); } }
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; }
public void Save() { using (CarrotCMSDataContext _db = CarrotCMSDataContext.GetDataContext()) { SiteData site = SiteData.GetSiteFromCache(this.SiteID); carrot_RootContentSnippet rc = CompiledQueries.cqGetSnippetDataTbl(_db, this.SiteID, this.Root_ContentSnippetID); carrot_ContentSnippet oldC = CompiledQueries.cqGetLatestSnippetContentTbl(_db, this.SiteID, this.Root_ContentSnippetID); bool bNew = false; if (rc == null) { rc = new carrot_RootContentSnippet(); rc.Root_ContentSnippetID = Guid.NewGuid(); rc.SiteID = site.SiteID; rc.CreateDate = DateTime.UtcNow; if (this.CreateUserId != Guid.Empty) { rc.CreateUserId = this.CreateUserId; } else { rc.CreateUserId = SecurityData.CurrentUserGuid; } _db.carrot_RootContentSnippets.InsertOnSubmit(rc); bNew = true; } this.ContentSnippetSlug = ContentPageHelper.ScrubSlug(this.ContentSnippetSlug); rc.ContentSnippetActive = this.ContentSnippetActive; rc.ContentSnippetName = this.ContentSnippetName; rc.ContentSnippetSlug = this.ContentSnippetSlug; rc.GoLiveDate = site.ConvertSiteTimeToUTC(this.GoLiveDate); rc.RetireDate = site.ConvertSiteTimeToUTC(this.RetireDate); carrot_ContentSnippet c = new carrot_ContentSnippet(); c.ContentSnippetID = Guid.NewGuid(); c.Root_ContentSnippetID = rc.Root_ContentSnippetID; c.IsLatestVersion = true; if (!bNew) { oldC.IsLatestVersion = false; } c.EditDate = DateTime.UtcNow; if (this.EditUserId != Guid.Empty) { c.EditUserId = this.EditUserId; } else { c.EditUserId = SecurityData.CurrentUserGuid; } c.ContentBody = this.ContentBody; rc.Heartbeat_UserId = c.EditUserId; rc.EditHeartbeat = DateTime.UtcNow; _db.carrot_ContentSnippets.InsertOnSubmit(c); _db.SubmitChanges(); this.ContentSnippetID = c.ContentSnippetID; this.Root_ContentSnippetID = rc.Root_ContentSnippetID; } }