protected void ShowPageInfo(PAGESDB db) { bool valid = true; string pageid = Request.QueryString["pageid"]; if (String.IsNullOrEmpty(pageid)) { valid = false; } if (valid) { Page page_record = db.FindPage(Int32.Parse(pageid)); show_page_title.InnerHtml = page_record.GetBusinessName(); page_tagline.InnerHtml = page_record.GetTagline(); page_title.InnerHtml = page_record.GetTitle(); page_subtitle.InnerHtml = page_record.GetSubtitle(); page_description.InnerHtml = page_record.GetDescription(); } else { valid = false; } if (!valid) { page_show.InnerHtml = "There was an error fining that page."; } }
//function used to display the list protected void ShowPageInfo(PAGESDB db) { bool valid = true; string pageid = Request.QueryString["pageid"]; if (String.IsNullOrEmpty(pageid)) { valid = false; } if (valid) { Page page_record = db.FindPage(Int32.Parse(pageid)); page_title.InnerHtml = page_record.GetBusinessName(); business_name.Text = page_record.GetBusinessName(); tag_line.Text = page_record.GetTagline(); title_page.Text = page_record.GetTitle(); subtitle_page.Text = page_record.GetSubtitle(); description_page.Text = page_record.GetDescription(); } else { valid = false; } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { PAGESDB db = new PAGESDB(); //it will call function ShowPageInfo ShowPageInfo(db); } }
protected void Page_Load(object sender, EventArgs e) { pages_home_result.InnerHtml = ""; //list is hidden home_listitem.Style.Add("display", "none"); string searchkey = ""; if (Page.IsPostBack) { //if the search button is clicked then and then only the list will be displayed home_listitem.Style.Add("display", "block"); searchkey = search_page.Text; // query to get all rows of table if user clicks search button without typing anything in searchbar string query = "select * from pages"; if (searchkey != "") { //if user types somthing in the search bar then it will search according to the typed text query += " WHERE BUSINESSNAME like '%" + searchkey + "%'"; query += " or TITLE like '%" + searchkey + "%'"; } var db = new PAGESDB(); List <Dictionary <String, String> > rs = db.List_Query(query); foreach (Dictionary <String, String> row in rs) { //for displaying in the list pages_home_result.InnerHtml += "<div class=\"listitem\">"; string pageid = row["PAGEID"]; string businessname = row["BUSINESSNAME"]; pages_home_result.InnerHtml += "<div class=\"col6\"><a href=\"Show_Page.aspx?pageid=" + pageid + "\">" + businessname + "</a></div>"; string tagline = row["TAGLINE"]; pages_home_result.InnerHtml += "<div class=\"col6\">" + tagline + "</div>"; string title = row["TITLE"]; pages_home_result.InnerHtml += "<div class=\"col6\">" + title + "</div>"; string subtitle = row["SUBTITLE"]; pages_home_result.InnerHtml += "<div class=\"col6\">" + subtitle + "</div>"; string description = row["DESCRIPTION"]; pages_home_result.InnerHtml += "<div class=\"col6\">" + description + "</div>"; pages_home_result.InnerHtml += "<div class=\"col6last\"><a href=\"Update_Page.aspx?pageid=" + pageid + "\"><img class=\"icons\" src=\"edit-regular.svg\"/></a></div>"; pages_home_result.InnerHtml += "</div>"; } } }
protected void Page_Load(object sender, EventArgs e) { pages_result.InnerHtml = ""; string searchkey = ""; if (Page.IsPostBack) { searchkey = page_search.Text; } string query = "select * from pages"; if (searchkey != "") { query += " WHERE BUSINESSNAME like '%" + searchkey + "%' "; query += " or TITLE like '%" + searchkey + "%' "; } sql_debugger_design.InnerHtml = query; var db = new PAGESDB(); List <Dictionary <String, String> > rs = db.List_Query(query); foreach (Dictionary <String, String> row in rs) { //displaying in the list pages_result.InnerHtml += "<div class=\"listitem\">"; string pageid = row["PAGEID"]; string businessname = row["BUSINESSNAME"]; pages_result.InnerHtml += "<div class=\"col6\"><a href=\"Show_Page.aspx?pageid=" + pageid + "\">" + businessname + "</a></div>"; string tagline = row["TAGLINE"]; pages_result.InnerHtml += "<div class=\"col6\">" + tagline + "</div>"; string title = row["TITLE"]; pages_result.InnerHtml += "<div class=\"col6\">" + title + "</div>"; string subtitle = row["SUBTITLE"]; pages_result.InnerHtml += "<div class=\"col6\">" + subtitle + "</div>"; string description = row["DESCRIPTION"]; pages_result.InnerHtml += "<div class=\"col6\">" + description + "</div>"; pages_result.InnerHtml += "<div class=\"col6last\"><a href=\"Update_Page.aspx?pageid=" + pageid + "\"><img class=\"icons\" src=\"edit-regular.svg\"/></a></div>"; pages_result.InnerHtml += "</div>"; } }
protected void Delete_Page(object sender, EventArgs e) { bool valid = true; string pageid = Request.QueryString["pageid"]; if (String.IsNullOrEmpty(pageid)) { valid = false; } PAGESDB db = new PAGESDB(); if (valid) { db.DeletePage(Int32.Parse(pageid)); Response.Redirect("Your_Designs.aspx"); } }
protected void Add_Page(object sender, EventArgs e) { //object of class PAGESDB is created PAGESDB db = new PAGESDB(); //object of class Page is created Page new_page = new Page(); //By using object new_page we are assigning the user input value to the database new_page.SetBusinessName(business_name.Text); new_page.SetTagline(tag_line.Text); new_page.SetTitle(page_title.Text); new_page.SetSubtitle(page_subtitle.Text); new_page.SetDescription(page_description.Text); //with the help of Page object we are inserting data into database by using function AddPage of class PAGESDB db.AddPage(new_page); //this will redirect the page to Your_Designs Response.Redirect("Your_Designs.aspx"); }
//function used to update the page content protected void UpdatePage(object sender, EventArgs e) { //object of PAGESDB PAGESDB db = new PAGESDB(); bool valid = true; string pageid = Request.QueryString["pageid"]; if (String.IsNullOrEmpty(pageid)) { valid = false; } if (valid) { //object of Page Page new_page = new Page(); new_page.SetBusinessName(business_name.Text); new_page.SetTagline(tag_line.Text); new_page.SetTitle(title_page.Text); new_page.SetSubtitle(subtitle_page.Text); new_page.SetDescription(description_page.Text); try { db.Update_Page(Int32.Parse(pageid), new_page); //redirect to Your_Designs.aspx Response.Redirect("Your_Designs.aspx?pageid=" + pageid); } catch { valid = false; } } if (!valid) { pages.InnerHtml = "There was an error updating that page."; } }
protected void Page_Load(object sender, EventArgs e) { PAGESDB db = new PAGESDB(); ShowPageInfo(db); }