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