protected void Page_Load(object sender, EventArgs e) { pages_result.InnerHtml = ""; string searchkey = ""; string query = "select * from html"; if (searchkey != "") { query += " WHERE html_tags_id like '%" + searchkey + "%' "; query += " or html_tags_title like '%" + searchkey + "%' "; query += " or html_tags_body like '%" + searchkey + "%' "; } var db = new htmldb(); List <Dictionary <String, String> > rs = db.List_Query(query); foreach (Dictionary <String, String> row in rs) { pages_result.InnerHtml += "<div class=\"listitem\">"; string html_id = row["html_tags_id"]; pages_result.InnerHtml += "<div class=\"col\">" + html_id + "</div>"; string html_title = row["html_tags_title"]; pages_result.InnerHtml += "<div class=\"col\"><a href=\"view_Page.aspx?html_id=" + html_id + "\">" + html_title + "</a></div>"; string html_body = row["html_tags_body"]; pages_result.InnerHtml += "<div class=\"col_last\">" + html_body + "</div>"; pages_result.InnerHtml += "</div>"; } }
protected void ShowPageInfo(htmldb db) { bool valid = true; string html_id = Request.QueryString["html_id"]; if (String.IsNullOrEmpty(html_id)) { valid = false; } if (valid) { HTTP_Page page_record = db.Find_Page(Int32.Parse(html_id)); html_tag_title.InnerHtml = page_record.GetPageTitle(); html_tag_desc.InnerHtml = page_record.GetPageBody(); } else { valid = false; } if (!valid) { html_element.InnerHtml = "There is an error finding a page."; } }
protected void Update_Page(object sender, EventArgs e) { htmldb db = new htmldb(); bool valid = true; string html_id = Request.QueryString["html_id"]; if (String.IsNullOrEmpty(html_id)) { valid = false; } if (valid) { HTTP_Page new_page = new HTTP_Page(); new_page.SetPageTitle(html_tag.Text); new_page.SetPageBody(html_body.Text); try { db.UpdatePage(Int32.Parse(html_id), new_page); Response.Redirect("view_Page.aspx?html_id=" + html_id); } catch { valid = false; } } if (!valid) { update_element.InnerHtml = "There was an error updating the page."; } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { htmldb db = new htmldb(); ShowPageInfo(db); } }
protected void Add_Page(object sender, EventArgs e) { htmldb db = new htmldb(); HTTP_Page new_page = new HTTP_Page(); new_page.SetPageTitle(html_title.Text); new_page.SetPageBody(html_body.Text); db.Add_Page(new_page); Response.Redirect("list_pages.aspx"); }
protected void Delete_Page(object sender, EventArgs e) { bool valid = true; string html_id = Request.QueryString["html_id"]; if (String.IsNullOrEmpty(html_id)) { valid = false; } htmldb db = new htmldb(); if (valid) { db.Delete_Page(Int32.Parse(html_id)); Response.Redirect("list_pages.aspx"); } }
protected void ShowPageInfo(htmldb db) { bool valid = true; string html_id = Request.QueryString["html_id"]; if (String.IsNullOrEmpty(html_id)) { valid = false; } if (valid) { HTTP_Page page_record = db.Find_Page(Int32.Parse(html_id)); html_tag.Text = page_record.GetPageTitle(); html_body.Text = page_record.GetPageBody(); } if (!valid) { update_element.InnerHtml = html_id; } }
protected void Page_Load(object sender, EventArgs e) { htmldb db = new htmldb(); ShowPageInfo(db); }