} // 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