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 HTTP_Page FindPage(int id) { MySqlConnection Connect = new MySqlConnection(ConnectionString); HTTP_Page result_page = new HTTP_Page(); try { string query = "select * from page where pageid = " + id; Debug.WriteLine("Connection Initialized..."); Connect.Open(); MySqlCommand cmd = new MySqlCommand(query, Connect); MySqlDataReader resultset = cmd.ExecuteReader(); List <HTTP_Page> pages = new List <HTTP_Page>(); while (resultset.Read()) { HTTP_Page currentpage = new HTTP_Page(); for (int i = 0; i < resultset.FieldCount; i++) { string key = resultset.GetName(i); string value = resultset.GetString(i); Debug.WriteLine("Attempting to transfer " + key + " data of " + value); switch (key) { case "pagetitle": currentpage.SetPageTitle(value); break; case "pagebody": currentpage.SetPageBody(value); break; } } pages.Add(currentpage); } result_page = pages[0]; } catch (Exception ex) { Debug.WriteLine("Something went wrong in the find page method!"); Debug.WriteLine(ex.ToString()); } Connect.Close(); Debug.WriteLine("Database Connection Terminated."); return(result_page); }
protected void Add_Page(object sender, EventArgs e) { pageDB db = new pageDB(); HTTP_Page new_page = new HTTP_Page(); new_page.SetPageTitle(page_title.Text); new_page.SetPageBody(page_body.Text); db.AddPage(new_page); Response.Redirect("ListOfPages.aspx"); }
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."; } }
protected void Update_Page(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 new_page = new HTTP_Page(); //set that student data new_page.SetPageTitle(page_title.Text); new_page.SetPageBody(page_body.Text); Debug.WriteLine("New Page Class" + new_page); //add the student to the database try { db.UpdatePage(Int32.Parse(pageid), new_page); Response.Redirect("ViewPage.aspx?pageid=" + pageid); } catch { valid = false; } } if (!valid) { update_page.InnerHtml = "There was an error updating that page."; } }