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