protected void Add_Page(object sender, EventArgs e) { //the above add_page is related to our onclick funcion //firstly access from db PageDB db = new PageDB(); //create a new page //here this page class is to refer the class which we created; Page_Class new_http_page = new Page_Class(); //set that student data now new_http_page.SetTitle(page_title.Text); new_http_page.SetBody(page_body.Text); new_http_page.SetAuthorNumber(author_number.Text); new_http_page.SetCreatedDate(DateTime.Now); //now this new page created to our database db.AddPage(new_http_page); //this add page is related to our db add page. Response.Redirect("HTTP_Page.aspx"); }
//here because we define the class thats why we mention here //otherwise we have to use dictionary method. public Page_Class FindPage(int pageid) { MySqlConnection Connect = new MySqlConnection(ConnectionString); Page_Class page_result = new Page_Class(); try { string query = "select PAGE_ID,TITLE, BODY, concat(first_name, ' ', last_name) as AUTHOR_NAME, CREATED_DATE from HTTP_PAGE join AUTHOR ON HTTP_PAGE.AUTHOR_ID = AUTHOR.AUTHOR_ID where PAGE_ID =" + pageid; Debug.WriteLine("connection initialized!!! i am trying to find a page with id " + pageid); Connect.Open(); MySqlCommand cmd = new MySqlCommand(query, Connect); MySqlDataReader resultset = cmd.ExecuteReader(); List <Page_Class> HTTP_Page = new List <Page_Class>(); while (resultset.Read()) { //info we stored for single vlaue Page_Class currenthttp_page = new Page_Class(); for (int i = 0; i < resultset.FieldCount; i++) { string name = resultset.GetName(i); string value = resultset.GetString(i); Debug.WriteLine("Attempting to transfer " + name + "data of" + value); switch (name) { case "TITLE": currenthttp_page.SetTitle(value); break; case "BODY": currenthttp_page.SetBody(value); break; case "AUTHOR_NAME": currenthttp_page.SetAuthorNumber(value); break; case "CREATED_DATE": currenthttp_page.SetCreatedDate(DateTime.Parse(value)); break; } } HTTP_Page.Add(currenthttp_page); } page_result = HTTP_Page[0]; } catch (Exception ex) { Debug.WriteLine("something went wrong for this page"); Debug.WriteLine(ex.ToString()); } Connect.Close(); Debug.WriteLine("Database terminated!!!"); return(page_result); }