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);
}
