protected void Recover_Click(object sender, EventArgs e)
{
// get pageid
string pageid = Request.QueryString["pageid"];
bool isPublished = true;
// execute update query
//UPDATE pages SET pagetitle = "123", pagebody = "321", isPublished = true WHERE pageid = 1
string query = "UPDATE pages SET isPublished = " + isPublished +
" WHERE pageid = " + pageid;
// db instance
WEBSITEDB db = new WEBSITEDB();
// execute crud query
db.CRUD_Query(query);
Response.Redirect("DetailPage.aspx?pageid=" + pageid);
}
protected void Edit_Click(object sender, EventArgs e)
{
string pagetitle = PageTitle.Text;
string pagebody = PageBody.Text;
// get pageid
string pageid = Request.QueryString["pageid"];
// execute update query
//UPDATE pages SET pagetitle = "123", pagebody = "321", isPublished = true WHERE pageid = 1
string query = "UPDATE pages SET pagetitle = \"" + pagetitle + "\"" +
", pagebody = \"" + pagebody + "\"" +
" WHERE pageid = " + pageid;
// db instance
WEBSITEDB db = new WEBSITEDB();
// execute crud query
db.CRUD_Query(query);
Response.Redirect("DetailPage.aspx?pageid=" + pageid);
}
