protected void Update_Page(object sender, EventArgs e) { htmldb db = new htmldb(); bool valid = true; string html_id = Request.QueryString["html_id"]; if (String.IsNullOrEmpty(html_id)) { valid = false; } if (valid) { HTTP_Page new_page = new HTTP_Page(); new_page.SetPageTitle(html_tag.Text); new_page.SetPageBody(html_body.Text); try { db.UpdatePage(Int32.Parse(html_id), new_page); Response.Redirect("view_Page.aspx?html_id=" + html_id); } catch { valid = false; } } if (!valid) { update_element.InnerHtml = "There was an error updating the page."; } }
public HTTP_Page Find_Page(int html_id) { MySqlConnection Connect = new MySqlConnection(ConnectionString); HTTP_Page result_page = new HTTP_Page(); try { string query = "select * from html where html_tags_id = " + html_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 "html_tags_title": currentpage.SetPageTitle(value); break; case "html_tags_body": 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) { htmldb db = new htmldb(); HTTP_Page new_page = new HTTP_Page(); new_page.SetPageTitle(html_title.Text); new_page.SetPageBody(html_body.Text); db.Add_Page(new_page); Response.Redirect("list_pages.aspx"); }