private void SavePage()
{
try
{
int returnNumber = -1;
int sortNumber = 0;
int childPageNumber = -1;
string pageModID = "0";
string pageName = txtPageName.Text.Replace("'", "''");
string pageCaption = txtPageCaption.Text.Replace("'", "''");
string metaTitle = txtMetaTitle.Text.Replace("'", "''");
string metaDesc = txtMetaDescription.Text.Replace("'", "''");
string metaKey = txtMetaKeywords.Text.Replace("'", "''");
CMSBL cmsBL = new CMSBL();
if (lblTitle.Text == "Add Page")
{
bool duplicatePage = cmsBL.DuplicatePageName(hdnSiteID.Value, pageName);
if (duplicatePage)
{
lblMessage.Text = "Duplicate Page Name";
lblMessage.ForeColor = System.Drawing.Color.Red;
return;
}
}
SqlServer sqlServer = new SqlServer(Util.SqlConnectionString()); ;
string isPublished = "";
if (rbYes.Checked)
isPublished = "1";
else if (rbNo.Checked)
isPublished = "0";
//sortNumber = cmsBL.GetDuplicatePageSort(hdnSiteID.Value, hdnPageID.Value, ddlSortNumber.SelectedValue);
if (sortNumber == 0)
{
childPageNumber = cmsBL.JMD_PAGE_SAVE(hdnChildPageID.Value, hdnSiteName.Value, pageName, pageCaption,
metaTitle, metaDesc, metaKey, "",
isPublished, "0", "0", "Admin", "Admin", "Admin", "Admin", "Admin", "Admin", "0", "0", "0", "1");
if (lblTitle.Text == "Update Page")
{
DataSet dsPageMod = new DataSet();
dsPageMod = sqlServer.JMD_LOAD_MODS(hdnSiteName.Value, pageName);
if (dsPageMod.Tables[0].Rows.Count > 0)
{
DataRow[] dr = dsPageMod.Tables[0].Select("PAGE_NAME='" + pageName + "'");
if (dr.Length > 0)
pageModID = dr[0]["PAGE_MOD_ID"].ToString();
}
returnNumber = cmsBL.UpdateTreeview(hdnSiteID.Value, hdnPageID.Value, childPageNumber.ToString(), ddlSortNumber.SelectedValue, _userName);
}
else
{
returnNumber = cmsBL.CreateTreeview(hdnSiteID.Value, hdnPageID.Value, childPageNumber.ToString(), ddlSortNumber.SelectedValue, _userName);
}
sqlServer.JMD_PAGE_MOD_SAVE(pageModID, hdnSiteName.Value, pageName, "7",
"Mod_" + pageName, "7", "1", "0", "Admin;Guests;Registered;",
"Admin;", "Admin;", "Admin;", "Admin;", "0");
if (lblTitle.Text == "Add Page")
{
lblMessage.Text = "Successfully added the new Page.";
}
else
{
lblMessage.Text = "Successfully updated the Page.";
}
lblMessage.ForeColor = System.Drawing.Color.Green;
}
else
{
lblMessage.Text = "Sort Number already exist.";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
catch (Exception ex)
{
lblMessage.Text = "Page Not Updated.";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
private void SavePage()
{
try
{
int returnNumber = -1;
int childPageNumber = -1;
string pageModID = "0";
string pageName = txtPageName.Text.Replace("'", "''");
string pageCaption = txtPageCaption.Text.Replace("'", "''");
string metaTitle = txtMetaTitle.Text.Replace("'", "''");
string metaDesc = txtMetaDescription.Text.Replace("'", "''");
string metaKey = txtMetaKeywords.Text.Replace("'", "''");
CMSBL cmsBL = new CMSBL();
if (lblTitle.Text == "Add Page")
{
bool duplicatePage = cmsBL.DuplicatePageName(hdnSiteID.Value, pageName);
if (duplicatePage)
{
lblMessage.Text = "Duplicate Page Name";
lblMessage.ForeColor = System.Drawing.Color.Red;
return;
}
}
SqlServer sqlServer = new SqlServer(Util.SqlConnectionString());
childPageNumber = cmsBL.JMD_PAGE_SAVE(hdnChildPageID.Value, hdnSiteName.Value, pageName, pageCaption,
metaTitle, metaDesc, metaKey, "",
"1", "0", "0", "Admin", "Admin", "Admin", "Admin", "Admin", "Admin", "0", "0", "0", "1");
if (lblTitle.Text == "Update Page")
{
DataSet dsPageMod = new DataSet();
dsPageMod = sqlServer.JMD_LOAD_MODS(hdnSiteName.Value, pageName);
if (dsPageMod.Tables[0].Rows.Count > 0)
{
DataRow[] dr = dsPageMod.Tables[0].Select("PAGE_NAME='" + pageName + "'");
if (dr.Length > 0)
pageModID = dr[0]["PAGE_MOD_ID"].ToString();
}
}
sqlServer.JMD_PAGE_MOD_SAVE(pageModID, hdnSiteName.Value, pageName, "7",
"Mod_" + pageName, "7", "1", "0", "Admin;Guests;Registered;",
"Admin;", "Admin;", "Admin;", "Admin;", "0");
lblMessage.Text = "Page Updated Successfully";
lblMessage.ForeColor = System.Drawing.Color.Green;
}
catch (Exception ex)
{
lblMessage.Text = "Page Not Updated";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}