} // END DeletePage
public void UpdatePage(int pageid, HTTP_Page new_page)
{
// SRC: CRUD Essentials, Christine Bittle
// PURPOSE: HOW TO EDIT PAGE
// STRING FORMATTING:
string query = "UPDATE pages set page_title='{0}', page_body='{1}', page_published={2} WHERE page_id={3}";
query = String.Format(query, new_page.Get_http_title(), new_page.Get_http_body(), new_page.Get_http_publish(), pageid);
MySqlConnection Connect = new MySqlConnection(ConnectionString);
MySqlCommand cmd = new MySqlCommand(query, Connect);
try
{
Connect.Open();
cmd.ExecuteNonQuery();
Debug.WriteLine("Executed query " + query);
} // END TRY
catch (Exception ex)
{
Debug.WriteLine("Something went wrong in the UpdatePage method.");
Debug.WriteLine(ex.ToString());
} // END CATCH
Connect.Close();
} // END UpdatePage
} // END UpdatePage
public void AddPage(HTTP_Page new_page)
{
string query = "INSERT INTO pages (page_title, page_body, page_published) VALUES ('{0}', '{1}', {2})";
query = String.Format(query, new_page.Get_http_title(), new_page.Get_http_body(), new_page.Get_http_publish());
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();
} // END AddPage
