protected void Page_Load(object sender, EventArgs e) { page_result.InnerHtml = ""; string searchkey = ""; string query = "select * from page"; if (searchkey != "") { query += " WHERE pageid like '%" + searchkey + "%' "; query += " or pagetitle like '%" + searchkey + "%' "; query += " or pagebody like '%" + searchkey + "%' "; } // sql_debugger.InnerHtml = query; var db = new pageDB(); List <Dictionary <String, String> > rs = db.List_Query(query); foreach (Dictionary <String, String> row in rs) { page_result.InnerHtml += "<div class=\"listitem\">"; string pageid = row["pageid"]; string pagetitle = row["pagetitle"]; page_result.InnerHtml += "<div class=\"col4\"><a href=\"ViewPage.aspx?pageid=" + pageid + "\">" + pagetitle + "</a></div>"; string pagebody = row["pagebody"]; page_result.InnerHtml += "<div class=\"col4\">" + pagebody + "</div>"; page_result.InnerHtml += "</div>"; /* page_list.InnerHtml += "<a href=\"ViewPage.aspx?pageid=" + pageid + "\">" + pagetitle + "</a>";*/ // i have commented this code because i have used usercontroller } }
protected void Page_Load(object sender, EventArgs e) { pageDB db = new pageDB(); bool valid = true; string pageid = Request.QueryString["pageid"]; Debug.WriteLine("Pageid" + pageid); if (String.IsNullOrEmpty(pageid)) { valid = false; } if (valid) { HTTP_Page page_record = db.FindPage(Int32.Parse(pageid)); page_title.InnerHtml = page_record.GetPageTitle(); page_body.InnerHtml = page_record.GetPageBody(); updatepage.InnerHtml += "<a href=\"UpdatePage.aspx?pageid=" + pageid + "\">" + "Update" + "</a>"; updatepage.InnerHtml += "<a href=\"DeletePage.aspx?pageid=" + pageid + "\">" + "Delete" + "</a>"; } else { valid = false; } if (!valid) { http_page.InnerHtml = "There was an error finding that page."; } }
protected void Delete_Page(object sender, EventArgs e) { pageDB db = new pageDB(); string pageid = Request.QueryString["pageid"]; db.DeletePage(Int32.Parse(pageid)); Response.Redirect("ListOfPages.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { pageDB db = new pageDB(); ShowPageInfo(db); } }
protected void Add_Page(object sender, EventArgs e) { pageDB db = new pageDB(); HTTP_Page new_page = new HTTP_Page(); new_page.SetPageTitle(page_title.Text); new_page.SetPageBody(page_body.Text); db.AddPage(new_page); Response.Redirect("ListOfPages.aspx"); }
protected void ListOfNavbarLinks(pageDB db) { //query the most popular classes (most students) string query = "select * from page"; List <Dictionary <String, String> > rs = db.List_Query(query); foreach (Dictionary <String, String> row in rs) { string pageid = row["pageid"]; string pagetitle = row["pagetitle"]; nav.InnerHtml += "</div>"; nav.InnerHtml += "<a href=\"ViewPage.aspx?pageid=" + pageid + "\">" + pagetitle + "</a>"; } }
protected void ShowPageInfo(pageDB db) { bool valid = true; string pageid = Request.QueryString["pageid"]; if (String.IsNullOrEmpty(pageid)) { valid = false; } if (valid) { HTTP_Page page_record = db.FindPage(Int32.Parse(pageid)); update_page.InnerHtml = page_record.GetPageTitle(); page_title.Text = page_record.GetPageTitle(); page_body.Text = page_record.GetPageBody(); } if (!valid) { update_page.InnerHtml = "There was an error finding that page."; } }
protected void Update_Page(object sender, EventArgs e) { pageDB db = new pageDB(); bool valid = true; string pageid = Request.QueryString["pageid"]; Debug.WriteLine("Pageid" + pageid); if (String.IsNullOrEmpty(pageid)) { valid = false; } if (valid) { HTTP_Page new_page = new HTTP_Page(); //set that student data new_page.SetPageTitle(page_title.Text); new_page.SetPageBody(page_body.Text); Debug.WriteLine("New Page Class" + new_page); //add the student to the database try { db.UpdatePage(Int32.Parse(pageid), new_page); Response.Redirect("ViewPage.aspx?pageid=" + pageid); } catch { valid = false; } } if (!valid) { update_page.InnerHtml = "There was an error updating that page."; } }
protected void Page_Load(object sender, EventArgs e) { pageDB db = new pageDB(); ListOfNavbarLinks(db); }