public EditHistory(vw_carrot_EditHistory p)
{
if (p != null)
{
SiteData site = SiteData.GetSiteFromCache(p.SiteID);
this.SiteID = p.SiteID;
this.ContentID = p.ContentID;
this.Root_ContentID = p.Root_ContentID;
this.IsLatestVersion = p.IsLatestVersion;
this.TitleBar = p.TitleBar;
this.NavMenuText = p.NavMenuText;
this.PageHead = p.PageHead;
this.EditUserId = p.EditUserId;
this.EditDate = site.ConvertUTCToSiteTime(p.EditDate);
this.FileName = p.FileName;
this.ContentTypeID = p.ContentTypeID;
this.ContentTypeValue = p.ContentTypeValue;
this.PageActive = p.PageActive;
this.GoLiveDate = site.ConvertUTCToSiteTime(p.GoLiveDate);
this.RetireDate = site.ConvertUTCToSiteTime(p.RetireDate);
this.CreateDate = site.ConvertUTCToSiteTime(p.CreateDate);
this.EditUserName = p.EditUserName;
this.EditEmail = p.EditEmail;
this.CreateUserName = p.CreateUserName;
this.CreateEmail = p.CreateEmail;
}
}
internal ContentSnippet(vw_carrot_ContentSnippet c)
{
if (c != null)
{
SiteData site = SiteData.GetSiteFromCache(c.SiteID);
this.Root_ContentSnippetID = c.Root_ContentSnippetID;
this.SiteID = c.SiteID;
this.ContentSnippetID = c.ContentSnippetID;
this.ContentSnippetName = c.ContentSnippetName;
this.ContentSnippetSlug = c.ContentSnippetSlug;
this.ContentSnippetActive = c.ContentSnippetActive;
this.IsLatestVersion = c.IsLatestVersion;
this.ContentBody = c.ContentBody;
this.CreateUserId = c.CreateUserId;
this.CreateDate = site.ConvertUTCToSiteTime(c.CreateDate);
this.EditUserId = c.EditUserId;
this.EditDate = site.ConvertUTCToSiteTime(c.EditDate);
this.GoLiveDate = site.ConvertUTCToSiteTime(c.GoLiveDate);
this.RetireDate = site.ConvertUTCToSiteTime(c.RetireDate);
this.Heartbeat_UserId = c.Heartbeat_UserId;
this.EditHeartbeat = c.EditHeartbeat;
this.VersionCount = c.VersionCount;
}
}
internal SiteNav(vw_carrot_Content c)
{
if (c != null)
{
SiteData site = SiteData.GetSiteFromCache(c.SiteID);
this.Root_ContentID = c.Root_ContentID;
this.SiteID = c.SiteID;
this.FileName = c.FileName;
this.Thumbnail = c.PageThumbnail;
this.ShowInSiteMap = c.ShowInSiteMap;
this.BlockIndex = c.BlockIndex;
this.PageActive = c.PageActive;
this.CreateDate = site.ConvertUTCToSiteTime(c.CreateDate);
this.GoLiveDate = site.ConvertUTCToSiteTime(c.GoLiveDate);
this.RetireDate = site.ConvertUTCToSiteTime(c.RetireDate);
this.EditDate = site.ConvertUTCToSiteTime(c.EditDate);
this.EditUserId = c.EditUserId;
this.CreditUserId = c.CreditUserId;
this.ShowInSiteNav = c.ShowInSiteNav;
this.CreateUserId = c.CreateUserId;
this.ContentType = ContentPageType.GetTypeByID(c.ContentTypeID);
this.ContentID = c.ContentID;
this.Parent_ContentID = c.Parent_ContentID;
this.TitleBar = c.TitleBar;
this.NavMenuText = c.NavMenuText;
this.PageHead = c.PageHead;
this.PageText = c.PageText;
this.NavOrder = c.NavOrder;
this.TemplateFile = c.TemplateFile;
}
}
private void SetVals(vw_carrot_Widget ww)
{
if (ww != null)
{
SiteData site = SiteData.GetSiteFromCache(ww.SiteID);
this.IsWidgetPendingDelete = false;
this.IsPendingChange = false;
this.WidgetDataID = ww.WidgetDataID;
this.EditDate = site.ConvertUTCToSiteTime(ww.EditDate);
this.GoLiveDate = site.ConvertUTCToSiteTime(ww.GoLiveDate);
this.RetireDate = site.ConvertUTCToSiteTime(ww.RetireDate);
this.IsLatestVersion = ww.IsLatestVersion;
this.ControlProperties = ww.ControlProperties;
this.Root_WidgetID = ww.Root_WidgetID;
this.Root_ContentID = ww.Root_ContentID;
this.WidgetOrder = ww.WidgetOrder;
this.ControlPath = ww.ControlPath;
this.PlaceholderName = ww.PlaceholderName;
this.IsWidgetActive = ww.WidgetActive;
}
}
internal SiteMapOrder(vw_carrot_Content c)
{
if (c != null)
{
SiteData site = SiteData.GetSiteFromCache(c.SiteID);
this.SiteID = c.SiteID;
this.Root_ContentID = c.Root_ContentID;
this.PageActive = c.PageActive;
this.Parent_ContentID = c.Parent_ContentID;
this.NavMenuText = c.NavMenuText;
this.FileName = c.FileName;
this.NavOrder = c.NavOrder;
if (this.Parent_ContentID.HasValue)
{
this.NavLevel = 0;
}
else
{
this.NavLevel = 10;
}
this.ContentType = ContentPageType.GetTypeByID(c.ContentTypeID);
this.CreateDate = site.ConvertUTCToSiteTime(c.CreateDate);
this.GoLiveDate = site.ConvertUTCToSiteTime(c.GoLiveDate);
this.RetireDate = site.ConvertUTCToSiteTime(c.RetireDate);
}
}
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);
}
internal ContentPage(vw_carrot_Content c)
{
if (c != null)
{
SiteData site = SiteData.GetSiteFromCache(c.SiteID);
this.Root_ContentID = c.Root_ContentID;
this.SiteID = c.SiteID;
this.Heartbeat_UserId = c.Heartbeat_UserId;
this.EditHeartbeat = c.EditHeartbeat;
this.FileName = c.FileName;
this.CreateUserId = c.CreateUserId;
this.CreateDate = site.ConvertUTCToSiteTime(c.CreateDate);
this.GoLiveDate = site.ConvertUTCToSiteTime(c.GoLiveDate);
this.RetireDate = site.ConvertUTCToSiteTime(c.RetireDate);
this.EditDate = site.ConvertUTCToSiteTime(c.EditDate);
this.ShowInSiteMap = c.ShowInSiteMap;
this.BlockIndex = c.BlockIndex;
this.PageActive = c.PageActive;
this.ShowInSiteNav = c.ShowInSiteNav;
this.PageSlug = c.PageSlug;
this.ContentType = ContentPageType.GetTypeByID(c.ContentTypeID);
this.ContentID = c.ContentID;
this.Parent_ContentID = c.Parent_ContentID;
this.IsLatestVersion = c.IsLatestVersion;
this.TitleBar = c.TitleBar;
this.NavMenuText = c.NavMenuText;
this.PageHead = c.PageHead;
this.PageText = c.PageText;
this.LeftPageText = c.LeftPageText;
this.RightPageText = c.RightPageText;
this.NavOrder = c.NavOrder;
this.EditUserId = c.EditUserId;
this.CreditUserId = c.CreditUserId;
this.TemplateFile = c.TemplateFile;
this.Thumbnail = c.PageThumbnail;
if (String.IsNullOrEmpty(this.PageSlug) && this.ContentType == ContentPageType.PageType.BlogEntry)
{
this.PageSlug = c.FileName;
}
this.MetaDescription = c.MetaDescription;
this.MetaKeyword = c.MetaKeyword;
this.VersionCount = c.VersionCount.HasValue ? c.VersionCount.Value : 0;
}
}
internal TrackBackEntry(vw_carrot_TrackbackQueue c)
{
if (c != null)
{
SiteData site = SiteData.GetSiteFromCache(c.SiteID);
this.TrackbackQueueID = c.TrackbackQueueID;
this.Root_ContentID = c.Root_ContentID;
this.TrackBackURL = c.TrackBackURL;
this.TrackBackResponse = c.TrackBackResponse;
this.CreateDate = site.ConvertUTCToSiteTime(c.CreateDate);
this.ModifiedDate = site.ConvertUTCToSiteTime(c.ModifiedDate);
this.TrackedBack = c.TrackedBack;
}
}
public static void AssignWPExportNewIDs(SiteData sd, WordPressSite wps)
{
wps.NewSiteID = Guid.NewGuid();
wps.Content.Where(p => p.PostType == WordPressPost.WPPostType.BlogPost).ToList()
.ForEach(q => q.ImportFileName = ContentPageHelper.ScrubPath("/" + sd.ConvertUTCToSiteTime(q.PostDateUTC).ToString(sd.Blog_DatePattern) + "/" + q.ImportFileSlug));
wps.Content.ToList().ForEach(r => r.ImportFileName = ContentPageHelper.ScrubPath(r.ImportFileName.Replace("//", "/")));
}
internal BasicContentData(vw_carrot_Content c)
{
if (c != null)
{
SiteData site = SiteData.GetSiteFromCache(c.SiteID);
this.SiteID = c.SiteID;
this.Root_ContentID = c.Root_ContentID;
this.PageActive = c.PageActive;
this.Parent_ContentID = c.Parent_ContentID;
this.FileName = c.FileName;
this.TemplateFile = c.TemplateFile;
this.NavOrder = c.NavOrder;
this.ContentType = ContentPageType.GetTypeByID(c.ContentTypeID);
this.CreateDate = site.ConvertUTCToSiteTime(c.CreateDate);
this.GoLiveDate = site.ConvertUTCToSiteTime(c.GoLiveDate);
this.RetireDate = site.ConvertUTCToSiteTime(c.RetireDate);
}
}
internal ContentCategory(vw_carrot_CategoryURL c) {
if (c != null) {
SiteData site = SiteData.GetSiteFromCache(c.SiteID);
this.ContentCategoryID = c.ContentCategoryID;
this.SiteID = c.SiteID;
this.CategoryURL = ContentPageHelper.ScrubFilename(c.ContentCategoryID, c.CategoryUrl);
this.CategoryText = c.CategoryText;
this.UseCount = c.UseCount;
this.PublicUseCount = c.PublicUseCount;
this.IsPublic = c.IsPublic;
if (c.EditDate.HasValue) {
this.EditDate = site.ConvertUTCToSiteTime(c.EditDate.Value);
}
}
}
internal ContentEditor(vw_carrot_EditorURL c)
{
if (c != null)
{
SiteData site = SiteData.GetSiteFromCache(c.SiteID);
this.UserId = c.UserId;
this.SiteID = c.SiteID;
this.UserUrl = c.UserUrl;
this.LoweredEmail = c.LoweredEmail;
this.UseCount = c.UseCount;
this.PublicUseCount = c.PublicUseCount;
this.IsPublic = true;
if (c.EditDate.HasValue)
{
this.EditDate = site.ConvertUTCToSiteTime(c.EditDate.Value);
}
}
}
internal ContentTag(vw_carrot_TagURL c)
{
if (c != null)
{
SiteData site = SiteData.GetSiteFromCache(c.SiteID);
this.ContentTagID = c.ContentTagID;
this.SiteID = c.SiteID;
this.TagURL = c.TagUrl;
this.TagText = c.TagText;
this.UseCount = c.UseCount;
this.PublicUseCount = c.PublicUseCount;
this.IsPublic = c.IsPublic;
if (c.EditDate.HasValue)
{
this.EditDate = site.ConvertUTCToSiteTime(c.EditDate.Value);
}
}
}
public TimeZoneContent(Guid siteID)
{
// use C# libraries for timezones rather than pass in offset as some dates are +/- an hour off because of DST
this.SiteID = siteID;
this.ContentLocalDates = new List <ContentLocalTime>();
this.BlogPostUrls = new List <BlogPostPageUrl>();
SiteData site = SiteData.GetSiteFromCache(siteID);
List <carrot_RootContent> queryAllContent = null;
using (CarrotCMSDataContext db = CarrotCMSDataContext.GetDataContext()) {
queryAllContent = CannedQueries.GetAllRootTbl(db, siteID).ToList();
}
var allContentDates = (from p in queryAllContent
select p.GoLiveDate).Distinct().ToList();
var blogDateList = (from p in queryAllContent
where p.ContentTypeID == ContentPageType.GetIDByType(ContentPageType.PageType.BlogEntry)
select p.GoLiveDate).Distinct().ToList();
this.ContentLocalDates = (from d in allContentDates
select new ContentLocalTime()
{
GoLiveDate = d,
GoLiveDateLocal = site.ConvertUTCToSiteTime(d)
}).ToList();
this.BlogPostUrls = (from bd in blogDateList
join ld in this.ContentLocalDates on bd equals ld.GoLiveDate
select new BlogPostPageUrl()
{
GoLiveDate = ld.GoLiveDate,
PostPrefix = CleanPostPrefix(ContentPageHelper.CreateFileNameFromSlug(siteID, ld.GoLiveDateLocal, string.Empty)),
GoLiveDateLocal = ld.GoLiveDateLocal
}).ToList();
}
public TimeZoneContent(Guid siteID)
{
// use C# libraries for timezones rather than pass in offset as some dates are +/- an hour off because of DST
this.SiteID = siteID;
this.ContentLocalDates = new List <ContentLocalTime>();
this.BlogPostUrls = new List <BlogPostPageUrl>();
SiteData site = SiteData.GetSiteFromCache(siteID);
List <carrot_RootContent> queryAllContent = null;
using (CarrotCMSDataContext db = CarrotCMSDataContext.Create()) {
queryAllContent = CannedQueries.GetAllRootTbl(db, siteID).ToList();
}
this.ContentLocalDates = (from p in queryAllContent
select new ContentLocalTime {
Root_ContentID = p.Root_ContentID,
ContentTypeID = p.ContentTypeID,
GoLiveDate = p.GoLiveDate,
PageSlug = p.PageSlug,
FileName = p.FileName,
GoLiveDateLocal = site.ConvertUTCToSiteTime(p.GoLiveDate)
}).ToList();
IEnumerable <ContentLocalTime> queryBlog = (from c in this.ContentLocalDates
where c.ContentTypeID == ContentPageType.GetIDByType(ContentPageType.PageType.BlogEntry)
select c);
this.BlogPostUrls = (from p in queryBlog
select new BlogPostPageUrl {
Root_ContentID = p.Root_ContentID,
GoLiveDateLocal = p.GoLiveDateLocal,
FileName = ContentPageHelper.CreateFileNameFromSlug(siteID, p.GoLiveDateLocal, p.PageSlug)
}).ToList();
}
public static void AssignWPExportNewIDs(SiteData sd, WordPressSite wps)
{
wps.NewSiteID = Guid.NewGuid();
wps.Content.Where(p => p.PostType == WordPressPost.WPPostType.BlogPost).ToList()
.ForEach(q => q.ImportFileName = ContentPageHelper.ScrubFilename(q.ImportRootID, String.Format("/{0}/{1}", sd.ConvertUTCToSiteTime(q.PostDateUTC).ToString(sd.Blog_DatePattern), q.ImportFileSlug)));
wps.Content.ToList().ForEach(r => r.ImportFileName = ContentPageHelper.ScrubFilename(r.ImportRootID, r.ImportFileName));
}
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 static ContentPage CreateWPContentPage(WordPressSite wps, WordPressPost c, SiteData site)
{
ContentPage cont = null;
ContentPageType.PageType contType = ContentPageType.PageType.Unknown;
switch (c.PostType)
{
case WordPressPost.WPPostType.BlogPost:
contType = ContentPageType.PageType.BlogEntry;
break;
case WordPressPost.WPPostType.Page:
contType = ContentPageType.PageType.ContentEntry;
break;
}
if (c != null)
{
cont = new ContentPage(site.SiteID, contType);
cont.ContentID = Guid.NewGuid();
cont.CreateUserId = SecurityData.CurrentUserGuid;
cont.EditUserId = SecurityData.CurrentUserGuid;
if (!String.IsNullOrEmpty(c.PostAuthor))
{
WordPressUser wpu = wps.Authors.Where(x => x.Login.ToLower() == c.PostAuthor.ToLower()).FirstOrDefault();
if (wpu != null && wpu.ImportUserID != Guid.Empty)
{
ApplicationUser usr = SecurityData.GetUserByID(wpu.ImportUserID.ToString());
if (usr != null)
{
cont.CreateUserId = wpu.ImportUserID;
cont.EditUserId = wpu.ImportUserID;
}
}
}
cont.Root_ContentID = c.ImportRootID;
cont.FileName = c.ImportFileName.Replace("//", "/");
cont.PageSlug = null;
cont.NavOrder = c.PostOrder;
cont.Parent_ContentID = null;
cont.CreateDate = site.ConvertUTCToSiteTime(c.PostDateUTC);
cont.PageActive = c.IsPublished;
cont.ContentType = ContentPageType.PageType.Unknown;
if (c.PostType == WordPressPost.WPPostType.BlogPost)
{
cont.ContentType = ContentPageType.PageType.BlogEntry;
cont.PageSlug = c.ImportFileSlug.Replace("//", "/");
cont.NavOrder = SiteData.BlogSortOrderNumber;
cont.Parent_ContentID = null;
}
if (c.PostType == WordPressPost.WPPostType.Page)
{
cont.ContentType = ContentPageType.PageType.ContentEntry;
}
if (cont.ContentType == ContentPageType.PageType.ContentEntry)
{
cont.ShowInSiteMap = true;
cont.ShowInSiteNav = true;
}
else
{
cont.ShowInSiteMap = false;
cont.ShowInSiteNav = false;
}
cont.IsLatestVersion = true;
cont.IsLatestVersion = true;
cont.TitleBar = c.PostTitle;
cont.NavMenuText = c.PostTitle;
cont.PageHead = c.PostTitle;
cont.PageText = c.PostContent;
cont.LeftPageText = String.Empty;
cont.RightPageText = String.Empty;
cont.MetaDescription = String.Empty;
cont.MetaKeyword = String.Empty;
cont.ContentCategories = new List <ContentCategory>();
cont.ContentTags = new List <ContentTag>();
List <ContentTag> lstTags = site.GetTagList();
List <ContentCategory> lstCategories = site.GetCategoryList();
cont.ContentCategories = (from l in lstCategories
join o in c.Categories on l.CategorySlug.ToLower() equals o.ToLower()
select l).Distinct().ToList();
cont.ContentTags = (from l in lstTags
join o in c.Tags on l.TagSlug.ToLower() equals o.ToLower()
select l).Distinct().ToList();
}
return(cont);
}
