protected void btnManagePage_Click(object sender, EventArgs e) { try { string pageModID = "0"; SqlServer sqlServer = new SqlServer(Util.SqlConnectionString()); ; DataSet dsPageMod = new DataSet(); int rowNumber = 0; rowNumber = GetSelectedRow(); if (rowNumber >= 0) { string pageID = dgPages.Items[rowNumber].Cells[0].Text; string pageName = dgPages.Items[rowNumber].Cells[1].Text; dsPageMod = sqlServer.JMD_LOAD_MODS(lblSiteName.Text, pageName); if (dsPageMod.Tables[0].Rows.Count > 0) { DataRow[] dr = dsPageMod.Tables[0].Select("ID='" + pageID + "'"); if (dr.Length > 0) pageModID = dr[0]["PAGE_MOD_ID"].ToString(); //pageModID = dsPageMod.Tables[0].Rows[0]["PAGE_MOD_ID"].ToString(); } Response.Redirect("../CMS/HTMLEdit.aspx?PageModId=" + pageModID + "&PageName=" + pageName + "&companyName=" + lblCompanyName.Text + "&siteName=" + lblSiteName.Text + "&outlineName=" + lblOutlineName.Text + "&siteID=" + hdnSiteID.Value + "&pageID=" + hdnPageID.Value); } } catch (Exception ex) { } }
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; } }