protected void Update_PageCMS(object sender, EventArgs e) { PagesCMSDB db = new PagesCMSDB(); bool valid = true; string pagecmsid = Request.QueryString["pagecmsid"]; if (String.IsNullOrEmpty(pagecmsid)) { valid = false; } if (valid) { PageCMS new_pagecms = new PageCMS(); //sets page data new_pagecms.SetCMStitle(pagecms_title.Text); new_pagecms.SetCMSbody(pagecms_body.Text); //updates page in the database try { db.UpdatePageCMS(Int32.Parse(pagecmsid), new_pagecms); Response.Redirect("ShowPageCMS.aspx?pagecmsid=" + pagecmsid); } catch { valid = false; } } if (!valid) { //if not valid PageUpdateCMS.InnerHtml = "There was an error updating that page."; } }
public PageCMS FindPageCMS(int pagecmsid) { MySqlConnection Connect = new MySqlConnection(ConnectionString); PageCMS result_pagecms = new PageCMS(); try { string query = "select * from pagecmsinfo where pagecmsid = " + pagecmsid; Debug.WriteLine("Connection Initialized..."); Connect.Open(); MySqlCommand cmd = new MySqlCommand(query, Connect); MySqlDataReader resultset = cmd.ExecuteReader(); List <PageCMS> pagecms = new List <PageCMS>(); while (resultset.Read()) { PageCMS currentpagecms = new PageCMS(); 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 "pagecmstitle": currentpagecms.SetCMStitle(value); break; case "pagecmsbody": currentpagecms.SetCMSbody(value); break; } } pagecms.Add(currentpagecms); } result_pagecms = pagecms[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_pagecms); }
protected void Add_PageCMS(object sender, EventArgs e) { //creates a connection PagesCMSDB db = new PagesCMSDB(); //creates a new page PageCMS new_pagecms = new PageCMS(); //sets the page data new_pagecms.SetCMStitle(page_title.Text); new_pagecms.SetCMSbody(page_body.Text); //adds the page to the database db.AddPageCMS(new_pagecms); Response.Redirect("ListPageCMS.aspx"); }