public static int AddStaticPage(StaticPage page)
{
var id = SQLDataAccess.ExecuteScalar<int>(@"INSERT INTO [CMS].[StaticPage] ([PageName],[PageText],[SortOrder],[AddDate],[ModifyDate],[IndexAtSiteMap],[ParentID],[Enabled],[UrlPath]) VALUES " +
" (@PageName,@PageText,@SortOrder,GETDATE(),GETDATE(),@IndexAtSiteMap,@ParentID,@Enabled, @UrlPath); SELECT scope_identity();",
CommandType.Text,
new[]
{
new SqlParameter("@PageName", page.PageName ?? ""),
new SqlParameter("@PageText", page.PageText ?? ""),
new SqlParameter("@SortOrder", page.SortOrder),
new SqlParameter("@IndexAtSiteMap", page.IndexAtSiteMap),
new SqlParameter("@Enabled", page.Enabled),
page.ParentId == 0 ? new SqlParameter("@ParentID", DBNull.Value ) : new SqlParameter("@ParentID", page.ParentId),
new SqlParameter("@UrlPath", page .UrlPath )
}
);
// ---- Meta
if (page.Meta != null)
{
if (!page.Meta.Title.IsNullOrEmpty() || !page.Meta.MetaKeywords.IsNullOrEmpty() || !page.Meta.MetaDescription.IsNullOrEmpty() || !page.Meta.H1.IsNullOrEmpty())
{
page.Meta.ObjId = id;
MetaInfoService.SetMeta(page.Meta);
}
}
return id;
}
public static void UpdateStaticPage(StaticPage page)
{
SQLDataAccess.ExecuteNonQuery(
@"UPDATE [CMS].[StaticPage] SET [PageName] = @PageName, [PageText] = @PageText, [SortOrder] = @SortOrder, [ModifyDate] = GETDATE(), [IndexAtSiteMap] = @IndexAtSiteMap,
[ParentID] = @ParentID, [Enabled] = @Enabled, UrlPath=@UrlPath WHERE [StaticPageID] = @StaticPageID",
CommandType.Text,
new[]
{
new SqlParameter("@PageName", page.PageName),
new SqlParameter("@PageText", page.PageText),
new SqlParameter("@SortOrder", page.SortOrder),
new SqlParameter("@IndexAtSiteMap", page.IndexAtSiteMap),
new SqlParameter("@ParentID", page.ParentId == 0 ? DBNull.Value : (object)page.ParentId),
new SqlParameter("@StaticPageID", page.StaticPageId),
new SqlParameter("@Enabled", page.Enabled),
new SqlParameter("@UrlPath", page.UrlPath)
});
// ---- Meta
if (page.Meta != null)
{
if (page.Meta.Title.IsNullOrEmpty() && page.Meta.MetaKeywords.IsNullOrEmpty() && page.Meta.MetaDescription.IsNullOrEmpty())
{
if (MetaInfoService.IsMetaExist(page.ID, MetaType.StaticPage))
{
MetaInfoService.DeleteMetaInfo(page.ID, MetaType.StaticPage);
}
}
else
{
MetaInfoService.SetMeta(page.Meta);
}
}
}
public static int AddStaticPage(StaticPage page)
{
var id = SQLDataAccess.ExecuteScalar <int>(@"INSERT INTO [CMS].[StaticPage] ([PageName],[PageText],[SortOrder],[AddDate],[ModifyDate],[IndexAtSiteMap],[ParentID],[Enabled],[UrlPath]) VALUES " +
" (@PageName,@PageText,@SortOrder,GETDATE(),GETDATE(),@IndexAtSiteMap,@ParentID,@Enabled, @UrlPath); SELECT scope_identity();",
CommandType.Text,
new[]
{
new SqlParameter("@PageName", page.PageName ?? ""),
new SqlParameter("@PageText", page.PageText ?? ""),
new SqlParameter("@SortOrder", page.SortOrder),
new SqlParameter("@IndexAtSiteMap", page.IndexAtSiteMap),
new SqlParameter("@Enabled", page.Enabled),
page.ParentId == 0 ? new SqlParameter("@ParentID", DBNull.Value) : new SqlParameter("@ParentID", page.ParentId),
new SqlParameter("@UrlPath", page.UrlPath)
}
);
// ---- Meta
if (page.Meta != null)
{
if (!page.Meta.Title.IsNullOrEmpty() || !page.Meta.MetaKeywords.IsNullOrEmpty() || !page.Meta.MetaDescription.IsNullOrEmpty())
{
page.Meta.ObjId = id;
MetaInfoService.SetMeta(page.Meta);
}
}
return(id);
}
protected void Page_Load(object sender, EventArgs e)
{
int pageId = Page.Request["staticpageid"].TryParseInt();
page = StaticPageService.GetStaticPage(pageId);
if (pageId == 0 || page == null || (page != null && !page.Enabled))
{
Error404();
return;
}
SetMeta(page.Meta, page.PageName);
}
protected void Page_Load(object sender, EventArgs e)
{
int pageId = Page.Request["staticpageid"].TryParseInt();
if (Request.UrlReferrer != null && Request.UrlReferrer.ToString().Contains("staticpageviewsocial"))
{
Response.Redirect("~/social/staticpageviewsocial.aspx?staticpageid=" + pageId);
}
page = StaticPageService.GetStaticPage(pageId);
if (pageId == 0 || page == null || (page != null && !page.Enabled))
{
Error404();
return;
}
SetMeta(page.Meta, page.PageName);
sbShareButtons.Visible = AdvantShop.Configuration.SettingsDesign.EnableSocialShareButtons;
}
public static void UpdateStaticPage(StaticPage page)
{
SQLDataAccess.ExecuteNonQuery(
@"UPDATE [CMS].[StaticPage] SET [PageName] = @PageName, [PageText] = @PageText, [SortOrder] = @SortOrder, [ModifyDate] = GETDATE(), [IndexAtSiteMap] = @IndexAtSiteMap,
[ParentID] = @ParentID, [Enabled] = @Enabled, UrlPath=@UrlPath WHERE [StaticPageID] = @StaticPageID",
CommandType.Text,
new[]
{
new SqlParameter("@PageName", page.PageName),
new SqlParameter("@PageText", page.PageText),
new SqlParameter("@SortOrder", page.SortOrder),
new SqlParameter("@IndexAtSiteMap", page.IndexAtSiteMap),
new SqlParameter("@ParentID", page.ParentId == 0 ? DBNull.Value : (object)page.ParentId),
new SqlParameter("@StaticPageID", page.StaticPageId),
new SqlParameter("@Enabled", page.Enabled),
new SqlParameter( "@UrlPath", page .UrlPath )
});
// ---- Meta
if (page.Meta != null)
{
if (page.Meta.Title.IsNullOrEmpty() && page.Meta.MetaKeywords.IsNullOrEmpty() && page.Meta.MetaDescription.IsNullOrEmpty() && page.Meta.H1.IsNullOrEmpty())
{
if (MetaInfoService.IsMetaExist(page.ID, MetaType.StaticPage))
MetaInfoService.DeleteMetaInfo(page.ID, MetaType.StaticPage);
}
else
MetaInfoService.SetMeta(page.Meta);
}
}
