protected void AddButton_Click(object sender, EventArgs e) { WebsiteDB db = new WebsiteDB(); Webpage webpage = new Webpage(); //set the title, body and author from the textbox to the webpage class webpage.set_W_title(txtpage_title.Text); webpage.set_W_body(txtpage_body.InnerText); webpage.set_W_author(ddpage_author.SelectedValue); //if user checks the publish checkbox set the state to published and publish date to the current date and time if (chkpublish.Checked == true) { webpage.set_W_publish_state("Published"); //convert date and time to ex.(Saturday, 15 July 2019 5:00 AM) webpage.set_W_publish_date(DateTime.Now.ToString("dddd, dd MMMM yyyy h:mm tt")); } //if user doesnt check the checkbox set the state to not published else { webpage.set_W_publish_state("Not Published"); } //use the webpage class to pass the variables to the addwebpage method in the database class db.AddWebpage(webpage); Response.Redirect("ListWebpages.aspx"); }
protected void Page_Load(object sender, EventArgs e) { bool flag = true; int pageid = Convert.ToInt32(Request.QueryString["pageid"]); if (pageid.Equals(null)) { flag = false; } if (flag == true) { var db = new WebsiteDB(); string query = "select * from pages join author on publish_author = author_id where page_id = " + pageid; List <Dictionary <string, string> > page = db.List_Query(query); if (page.Count > 0) { foreach (Dictionary <String, String> pagedata in page) { Webpage webpage = new Webpage(); string pagetitle = pagedata["page_title"]; string pagebody = pagedata["page_body"]; string pageauthor = pagedata["author_name"]; string publishstate = pagedata["publish_state"]; string publishdate = pagedata["publish_date"]; title.InnerHtml = pagetitle; webpage.set_W_title(pagetitle); date.InnerHtml = publishdate; body.InnerHtml = pagebody; webpage.set_W_body(pagebody); author.InnerHtml = pageauthor; webpage.set_W_author(pageauthor); state.InnerHtml = publishstate; webpage.set_W_publish_state(publishstate); } } } }
protected void UpdateButton_Click(object sender, EventArgs e) { WebsiteDB dB = new WebsiteDB(); Webpage webpage = new Webpage(); Boolean flag = true; //get the pageid from the request and convert the string to int int pageid = Convert.ToInt32(Request.QueryString["pageid"]); //if the id that requested is null or is 0 set the flag to false if (pageid.Equals(null) || pageid.Equals(0)) { flag = false; } //if the flag is true continue with the logic if (flag) { //save the changes to the webpage in the webpage class webpage.set_W_title(txtpage_title.Text); webpage.set_W_body(txtpage_body.InnerText); webpage.set_W_author(ddpage_author.SelectedValue); //pass the new changes to the updatewebpages method in the websitedb class dB.UpdateWebpage(pageid, webpage); //once updated show the newly updated page Response.Redirect("SinglePage.aspx?pageid=" + pageid); } //if false show the alert of the error else { alert.Visible = true; alert.Attributes.Add("class", "alert alert-danger"); output.InnerHtml = "Error cannot add"; } }
public Webpage FindWebPage(int id) { MySqlConnection sqlCon = new MySqlConnection(ConnectionString); Webpage result_page = new Webpage(); try { string query = "select * from PAGES where page_id = " + id; sqlCon.Open(); MySqlCommand cmd = new MySqlCommand(query, sqlCon); MySqlDataReader resultset = cmd.ExecuteReader(); List <Webpage> page = new List <Webpage>(); while (resultset.Read()) { Webpage currentpage = new Webpage(); 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 "page_title": currentpage.set_W_title(value); break; case "page_body": currentpage.set_W_body(value); break; case "publish_author": currentpage.set_W_author(value); break; case "publish_state": currentpage.set_W_publish_state(value); break; case "publish_date": currentpage.set_W_publish_date(value); break; } } page.Add(currentpage); } result_page = page[0]; } catch (Exception ex) { Debug.WriteLine("Check the findWebpage()"); Debug.WriteLine(ex.ToString()); } sqlCon.Close(); Debug.WriteLine("Database Connection Terminated."); return(result_page); }