private void LoadFromReader(IDataReader reader)
{
if (reader.Read())
{
this.pageID = int.Parse(reader["PageID"].ToString());
this.parentID = int.Parse(reader["ParentID"].ToString());
this.siteID = int.Parse(reader["SiteID"].ToString());
this.pageOrder = int.Parse(reader["PageOrder"].ToString());
this.pageName = reader["PageName"].ToString();
this.pageTitle = reader["PageTitle"].ToString();
this.menuImage = reader["MenuImage"].ToString();
this.skin = reader["Skin"].ToString();
this.authorizedRoles = reader["AuthorizedRoles"].ToString();
this.editRoles = reader["EditRoles"].ToString();
this.draftEditOnlyRoles = reader["DraftEditRoles"].ToString();
this.createChildPageRoles = reader["CreateChildPageRoles"].ToString();
this.createChildDraftRoles = reader["CreateChildDraftRoles"].ToString();
this.requireSSL = Convert.ToBoolean(reader["RequireSSL"]);
this.allowBrowserCache = Convert.ToBoolean(reader["AllowBrowserCache"]);
this.showBreadcrumbs = Convert.ToBoolean(reader["ShowBreadcrumbs"]);
this.showChildPageBreadcrumbs = Convert.ToBoolean(reader["ShowChildBreadCrumbs"]);
this.useUrl = Convert.ToBoolean(reader["UseUrl"]);
this.url = reader["Url"].ToString();
this.openInNewWindow = Convert.ToBoolean(reader["OpenInNewWindow"]);
this.showChildPageMenu = Convert.ToBoolean(reader["ShowChildPageMenu"]);
this.hideMainMenu = Convert.ToBoolean(reader["HideMainMenu"]);
this.pageMetaKeyWords = reader["PageKeyWords"].ToString();
this.pageMetaDescription = reader["PageDescription"].ToString();
this.pageMetaEncoding = reader["PageEncoding"].ToString();
this.pageMetaAdditional = reader["AdditionalMetaTags"].ToString();
this.includeInMenu = Convert.ToBoolean(reader["IncludeInMenu"]);
string cf = reader["ChangeFrequency"].ToString();
switch (cf)
{
case "Always":
this.changeFrequency = PageChangeFrequency.Always;
break;
case "Hourly":
this.changeFrequency = PageChangeFrequency.Hourly;
break;
case "Daily":
this.changeFrequency = PageChangeFrequency.Daily;
break;
case "Monthly":
this.changeFrequency = PageChangeFrequency.Monthly;
break;
case "Yearly":
this.changeFrequency = PageChangeFrequency.Yearly;
break;
case "Never":
this.changeFrequency = PageChangeFrequency.Never;
break;
case "Weekly":
default:
this.changeFrequency = PageChangeFrequency.Weekly;
break;
}
string smp = reader["SiteMapPriority"].ToString().Trim();
if (smp.Length > 0)
{
this.siteMapPriority = smp;
}
if (reader["LastModifiedUTC"] != DBNull.Value)
{
this.lastModifiedUTC = Convert.ToDateTime(reader["LastModifiedUTC"]);
}
this.pageGuid = new Guid(reader["PageGuid"].ToString());
this.parentGuid = new Guid(reader["ParentGuid"].ToString());
this.hideAfterLogin = Convert.ToBoolean(reader["HideAfterLogin"]);
this.siteGuid = new Guid(reader["SiteGuid"].ToString());
this.compiledMeta = reader["CompiledMeta"].ToString();
if (reader["CompiledMetaUtc"] != DBNull.Value)
{
this.compiledMetaUtc = Convert.ToDateTime(reader["CompiledMetaUtc"]);
}
this.includeInSiteMap = Convert.ToBoolean(reader["IncludeInSiteMap"]);
this.isClickable = Convert.ToBoolean(reader["IsClickable"]);
this.showHomeCrumb = Convert.ToBoolean(reader["ShowHomeCrumb"]);
this.isPending = Convert.ToBoolean(reader["IsPending"]);
this.includeInSearchMap = Convert.ToBoolean(reader["IncludeInSearchMap"]);
this.canonicalOverride = reader["CanonicalOverride"].ToString();
this.enableComments = Convert.ToBoolean(reader["EnableComments"]);
}
}
private void LoadFromReader(IDataReader reader)
{
if (reader.Read())
{
this.pageID = int.Parse(reader["PageID"].ToString());
this.parentID = int.Parse(reader["ParentID"].ToString());
this.siteID = int.Parse(reader["SiteID"].ToString());
this.pageOrder = int.Parse(reader["PageOrder"].ToString());
this.pageName = reader["PageName"].ToString();
this.pageTitle = reader["PageTitle"].ToString();
this.menuImage = reader["MenuImage"].ToString();
this.skin = reader["Skin"].ToString();
this.authorizedRoles = reader["AuthorizedRoles"].ToString();
this.editRoles = reader["EditRoles"].ToString();
this.draftEditOnlyRoles = reader["DraftEditRoles"].ToString();
this.draftApprovalRoles = reader["DraftApprovalRoles"].ToString();
this.createChildPageRoles = reader["CreateChildPageRoles"].ToString();
this.createChildDraftRoles = reader["CreateChildDraftRoles"].ToString();
this.requireSSL = Convert.ToBoolean(reader["RequireSSL"]);
this.allowBrowserCache = Convert.ToBoolean(reader["AllowBrowserCache"]);
this.showBreadcrumbs = Convert.ToBoolean(reader["ShowBreadcrumbs"]);
this.showChildPageBreadcrumbs = Convert.ToBoolean(reader["ShowChildBreadCrumbs"]);
this.useUrl = Convert.ToBoolean(reader["UseUrl"]);
this.url = reader["Url"].ToString();
if (useUrl)
{
unmodifiedUrl = reader["Url"].ToString();
}
else
{
unmodifiedUrl = "~/Default.aspx?pageid=" + pageID.ToString(CultureInfo.InvariantCulture);
}
this.openInNewWindow = Convert.ToBoolean(reader["OpenInNewWindow"]);
this.showChildPageMenu = Convert.ToBoolean(reader["ShowChildPageMenu"]);
this.hideMainMenu = Convert.ToBoolean(reader["HideMainMenu"]);
this.pageMetaKeyWords = reader["PageKeyWords"].ToString();
this.pageMetaDescription = reader["PageDescription"].ToString();
this.pageMetaEncoding = reader["PageEncoding"].ToString();
this.pageMetaAdditional = reader["AdditionalMetaTags"].ToString();
this.includeInMenu = Convert.ToBoolean(reader["IncludeInMenu"]);
string cf = reader["ChangeFrequency"].ToString();
switch (cf)
{
case "Always":
this.changeFrequency = PageChangeFrequency.Always;
break;
case "Hourly":
this.changeFrequency = PageChangeFrequency.Hourly;
break;
case "Daily":
this.changeFrequency = PageChangeFrequency.Daily;
break;
case "Monthly":
this.changeFrequency = PageChangeFrequency.Monthly;
break;
case "Yearly":
this.changeFrequency = PageChangeFrequency.Yearly;
break;
case "Never":
this.changeFrequency = PageChangeFrequency.Never;
break;
case "Weekly":
default:
this.changeFrequency = PageChangeFrequency.Weekly;
break;
}
string smp = reader["SiteMapPriority"].ToString().Trim();
if (smp.Length > 0) this.siteMapPriority = smp;
if (reader["LastModifiedUTC"] != DBNull.Value)
{
this.lastModifiedUTC = Convert.ToDateTime(reader["LastModifiedUTC"]);
}
this.pageGuid = new Guid(reader["PageGuid"].ToString());
this.parentGuid = new Guid(reader["ParentGuid"].ToString());
this.hideAfterLogin = Convert.ToBoolean(reader["HideAfterLogin"]);
this.siteGuid = new Guid(reader["SiteGuid"].ToString());
this.compiledMeta = reader["CompiledMeta"].ToString();
if (reader["CompiledMetaUtc"] != DBNull.Value)
{
this.compiledMetaUtc = Convert.ToDateTime(reader["CompiledMetaUtc"]);
}
this.includeInSiteMap = Convert.ToBoolean(reader["IncludeInSiteMap"]);
this.isClickable = Convert.ToBoolean(reader["IsClickable"]);
this.showHomeCrumb = Convert.ToBoolean(reader["ShowHomeCrumb"]);
this.isPending = Convert.ToBoolean(reader["IsPending"]);
this.includeInSearchMap = Convert.ToBoolean(reader["IncludeInSearchMap"]);
this.canonicalOverride = reader["CanonicalOverride"].ToString();
this.enableComments = Convert.ToBoolean(reader["EnableComments"]);
this.pubTeamId = new Guid(reader["PubTeamId"].ToString());
this.includeInChildSiteMap = Convert.ToBoolean(reader["IncludeInChildSiteMap"]);
this.expandOnSiteMap = Convert.ToBoolean(reader["ExpandOnSiteMap"]);
this.bodyCssClass = reader["BodyCssClass"].ToString();
this.menuCssClass = reader["MenuCssClass"].ToString();
this.publishMode = Convert.ToInt32(reader["PublishMode"].ToString());
if (reader["PCreatedUtc"] != DBNull.Value)
{
this.createdUtc = Convert.ToDateTime(reader["PCreatedUtc"]);
}
if (reader["PCreatedBy"] != DBNull.Value)
{
string pcg = reader["PCreatedBy"].ToString();
if (pcg.Length == 36)
{
this.createdBy = new Guid(pcg);
}
}
this.createdFromIp = reader["PCreatedFromIp"].ToString();
if (reader["PLastModUtc"] != DBNull.Value)
{
this.lastModUtc = Convert.ToDateTime(reader["PLastModUtc"]);
}
if (reader["PLastModBy"] != DBNull.Value)
{
string pcg = reader["PLastModBy"].ToString();
if (pcg.Length == 36)
{
this.lastModBy = new Guid(pcg);
}
}
this.lastModFromIp = reader["PLastModFromIp"].ToString();
this.createdByName = reader["CreatedByName"].ToString();
this.createdByEmail = reader["CreatedByEmail"].ToString();
this.createdByFirstName = reader["CreatedByFirstName"].ToString();
this.createdByLastName = reader["CreatedByLastName"].ToString();
this.lastModByName = reader["LastModByName"].ToString();
this.lastModByEmail = reader["LastModByEmail"].ToString();
this.lastModByFirstName = reader["LastModByFirstName"].ToString();
this.lastModByLastName = reader["LastModByLastName"].ToString();
this.menuDescription = reader["MenuDesc"].ToString();
if (reader["PubDateUtc"] != DBNull.Value)
{
this.pubDateUtc = Convert.ToDateTime(reader["PubDateUtc"]);
}
this.showPageHeading = Convert.ToBoolean(reader["ShowPageHeading"]);
this.linkRel = reader["LinkRel"].ToString();
this.pageHeading = reader["PageHeading"].ToString();
}
}
private void LoadFromReader(IDataReader reader)
{
if (reader.Read())
{
this.pageID = int.Parse(reader["PageID"].ToString());
this.parentID = int.Parse(reader["ParentID"].ToString());
this.siteID = int.Parse(reader["SiteID"].ToString());
this.pageOrder = int.Parse(reader["PageOrder"].ToString());
this.pageName = reader["PageName"].ToString();
this.pageTitle = reader["PageTitle"].ToString();
this.menuImage = reader["MenuImage"].ToString();
this.skin = reader["Skin"].ToString();
this.authorizedRoles = reader["AuthorizedRoles"].ToString();
this.editRoles = reader["EditRoles"].ToString();
this.draftEditOnlyRoles = reader["DraftEditRoles"].ToString();
this.draftApprovalRoles = reader["DraftApprovalRoles"].ToString();
this.createChildPageRoles = reader["CreateChildPageRoles"].ToString();
this.createChildDraftRoles = reader["CreateChildDraftRoles"].ToString();
this.requireSSL = Convert.ToBoolean(reader["RequireSSL"]);
this.allowBrowserCache = Convert.ToBoolean(reader["AllowBrowserCache"]);
this.showBreadcrumbs = Convert.ToBoolean(reader["ShowBreadcrumbs"]);
this.showChildPageBreadcrumbs = Convert.ToBoolean(reader["ShowChildBreadCrumbs"]);
this.useUrl = Convert.ToBoolean(reader["UseUrl"]);
this.url = reader["Url"].ToString();
if (useUrl)
{
unmodifiedUrl = reader["Url"].ToString();
}
else
{
unmodifiedUrl = "~/Default.aspx?pageid=" + pageID.ToString(CultureInfo.InvariantCulture);
}
this.openInNewWindow = Convert.ToBoolean(reader["OpenInNewWindow"]);
this.showChildPageMenu = Convert.ToBoolean(reader["ShowChildPageMenu"]);
this.hideMainMenu = Convert.ToBoolean(reader["HideMainMenu"]);
this.pageMetaKeyWords = reader["PageKeyWords"].ToString();
this.pageMetaDescription = reader["PageDescription"].ToString();
this.pageMetaEncoding = reader["PageEncoding"].ToString();
this.pageMetaAdditional = reader["AdditionalMetaTags"].ToString();
this.includeInMenu = Convert.ToBoolean(reader["IncludeInMenu"]);
string cf = reader["ChangeFrequency"].ToString();
switch (cf)
{
case "Always":
this.changeFrequency = PageChangeFrequency.Always;
break;
case "Hourly":
this.changeFrequency = PageChangeFrequency.Hourly;
break;
case "Daily":
this.changeFrequency = PageChangeFrequency.Daily;
break;
case "Monthly":
this.changeFrequency = PageChangeFrequency.Monthly;
break;
case "Yearly":
this.changeFrequency = PageChangeFrequency.Yearly;
break;
case "Never":
this.changeFrequency = PageChangeFrequency.Never;
break;
case "Weekly":
default:
this.changeFrequency = PageChangeFrequency.Weekly;
break;
}
string smp = reader["SiteMapPriority"].ToString().Trim();
if (smp.Length > 0)
{
this.siteMapPriority = smp;
}
if (reader["LastModifiedUTC"] != DBNull.Value)
{
this.lastModifiedUTC = Convert.ToDateTime(reader["LastModifiedUTC"]);
}
this.pageGuid = new Guid(reader["PageGuid"].ToString());
this.parentGuid = new Guid(reader["ParentGuid"].ToString());
this.hideAfterLogin = Convert.ToBoolean(reader["HideAfterLogin"]);
this.siteGuid = new Guid(reader["SiteGuid"].ToString());
this.compiledMeta = reader["CompiledMeta"].ToString();
if (reader["CompiledMetaUtc"] != DBNull.Value)
{
this.compiledMetaUtc = Convert.ToDateTime(reader["CompiledMetaUtc"]);
}
this.includeInSiteMap = Convert.ToBoolean(reader["IncludeInSiteMap"]);
this.isClickable = Convert.ToBoolean(reader["IsClickable"]);
this.showHomeCrumb = Convert.ToBoolean(reader["ShowHomeCrumb"]);
this.isPending = Convert.ToBoolean(reader["IsPending"]);
this.includeInSearchMap = Convert.ToBoolean(reader["IncludeInSearchMap"]);
this.canonicalOverride = reader["CanonicalOverride"].ToString();
this.enableComments = Convert.ToBoolean(reader["EnableComments"]);
this.pubTeamId = new Guid(reader["PubTeamId"].ToString());
this.includeInChildSiteMap = Convert.ToBoolean(reader["IncludeInChildSiteMap"]);
this.expandOnSiteMap = Convert.ToBoolean(reader["ExpandOnSiteMap"]);
this.bodyCssClass = reader["BodyCssClass"].ToString();
this.menuCssClass = reader["MenuCssClass"].ToString();
this.publishMode = Convert.ToInt32(reader["PublishMode"].ToString());
if (reader["PCreatedUtc"] != DBNull.Value)
{
this.createdUtc = Convert.ToDateTime(reader["PCreatedUtc"]);
}
if (reader["PCreatedBy"] != DBNull.Value)
{
string pcg = reader["PCreatedBy"].ToString();
if (pcg.Length == 36)
{
this.createdBy = new Guid(pcg);
}
}
this.createdFromIp = reader["PCreatedFromIp"].ToString();
if (reader["PLastModUtc"] != DBNull.Value)
{
this.lastModUtc = Convert.ToDateTime(reader["PLastModUtc"]);
}
if (reader["PLastModBy"] != DBNull.Value)
{
string pcg = reader["PLastModBy"].ToString();
if (pcg.Length == 36)
{
this.lastModBy = new Guid(pcg);
}
}
this.lastModFromIp = reader["PLastModFromIp"].ToString();
this.createdByName = reader["CreatedByName"].ToString();
this.createdByEmail = reader["CreatedByEmail"].ToString();
this.createdByFirstName = reader["CreatedByFirstName"].ToString();
this.createdByLastName = reader["CreatedByLastName"].ToString();
this.lastModByName = reader["LastModByName"].ToString();
this.lastModByEmail = reader["LastModByEmail"].ToString();
this.lastModByFirstName = reader["LastModByFirstName"].ToString();
this.lastModByLastName = reader["LastModByLastName"].ToString();
this.menuDescription = reader["MenuDesc"].ToString();
if (reader["PubDateUtc"] != DBNull.Value)
{
this.pubDateUtc = Convert.ToDateTime(reader["PubDateUtc"]);
}
this.showPageHeading = Convert.ToBoolean(reader["ShowPageHeading"]);
this.linkRel = reader["LinkRel"].ToString();
this.pageHeading = reader["PageHeading"].ToString();
}
}
