protected void Page_Load(object sender, EventArgs e) { pageDB db = new pageDB(); bool valid = true; string pageid = Request.QueryString["pageid"]; Debug.WriteLine("Pageid" + pageid); if (String.IsNullOrEmpty(pageid)) { valid = false; } if (valid) { HTTP_Page page_record = db.FindPage(Int32.Parse(pageid)); page_title.InnerHtml = page_record.GetPageTitle(); page_body.InnerHtml = page_record.GetPageBody(); updatepage.InnerHtml += "<a href=\"UpdatePage.aspx?pageid=" + pageid + "\">" + "Update" + "</a>"; updatepage.InnerHtml += "<a href=\"DeletePage.aspx?pageid=" + pageid + "\">" + "Delete" + "</a>"; } else { valid = false; } if (!valid) { http_page.InnerHtml = "There was an error finding that page."; } }
public void AddPage(HTTP_Page new_page) { string query = "insert into page (PAGETITLE, PAGEBODY) values ('{0}','{1}')"; query = String.Format(query, new_page.GetPageTitle(), new_page.GetPageBody()); MySqlConnection Connect = new MySqlConnection(ConnectionString); MySqlCommand cmd = new MySqlCommand(query, Connect); try { Connect.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { Debug.WriteLine("Something went wrong in the AddPage Method!"); Debug.WriteLine(ex.ToString()); } Connect.Close(); }
public void UpdatePage(int pageid, HTTP_Page new_page) { string query = "update page set pagetitle='{0}', pagebody='{1}' where pageid='{2}'"; query = String.Format(query, new_page.GetPageTitle(), new_page.GetPageBody(), pageid); MySqlConnection Connect = new MySqlConnection(ConnectionString); MySqlCommand cmd = new MySqlCommand(query, Connect); try { Connect.Open(); cmd.ExecuteNonQuery(); Debug.WriteLine("Executed query " + query); } catch (Exception ex) { Debug.WriteLine("Something went wrong in the UpdatePage Method!"); Debug.WriteLine(ex.ToString()); } Connect.Close(); }
protected void ShowPageInfo(pageDB db) { bool valid = true; string pageid = Request.QueryString["pageid"]; if (String.IsNullOrEmpty(pageid)) { valid = false; } if (valid) { HTTP_Page page_record = db.FindPage(Int32.Parse(pageid)); update_page.InnerHtml = page_record.GetPageTitle(); page_title.Text = page_record.GetPageTitle(); page_body.Text = page_record.GetPageBody(); } if (!valid) { update_page.InnerHtml = "There was an error finding that page."; } }