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"); }
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."; } }