protected void Page_Load(object sender, EventArgs e)
{
string query = "select * from AUTHOR";
var db = new PageDB();
List <Dictionary <String, String> > rs = db.List_Query(query);
foreach (Dictionary <String, String> row in rs)
{
author_result.InnerHtml += "<div class=\"listitem\">";
string authorId = row["AUTHOR_ID"];
string Fname = row["FIRST_NAME"];
author_result.InnerHtml += "<div class=\"col5\">" + Fname + "</div>";
string Lname = row["LAST_NAME"];
author_result.InnerHtml += "<div class=\"col5\">" + Lname + "</div>";
string Anumber = row["AUTHOR_NUMBER"];
author_result.InnerHtml += "<div class=\"col5\">" + Anumber + "</div>";
string Email = row["EMAIL"];
author_result.InnerHtml += "<div class=\"col5\">" + Email + "</div>";
author_result.InnerHtml += "</div>";
}
}
protected void List_Current_Pages(PageDB db)
{
string query = "select PAGE_ID,AUTHOR_NUMBER, 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";
List <Dictionary <String, String> > rs = db.List_Query(query);
foreach (Dictionary <String, String> row in rs)
{
string pageid = row["PAGE_ID"];
string title = row["TITLE"];
page_list1.InnerHtml += "<a href=\"Details_of_page.aspx?pageid=" + pageid + "\">" + title + "............" + "</a>";
}
}
protected void FillPage(PageDB db)
{
//create a query to run our dropdown.
string query = "select * from HTTP_PAGE";
List <Dictionary <String, String> > rs = db.List_Query(query);
foreach (Dictionary <String, String> row in rs)
{
//create stirng to get the values from database;
string pgeTitle = row["TITLE"];
string pgeid = row["PAGE_ID"];
//define thsoe string into our listitem;
ListItem pageoption = new ListItem(pgeTitle, pgeid);
//now add these items into our dropdown list with its id;
//page_list.Items.Add(pageoption);
}
}
protected void HTTP_PageInfo(PageDB db)
{
page_result.InnerHtml = "";
string query2 = "Select * from HTTP_PAGE";
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";
string searchkey = search_box.Text;
if (searchkey != "")
{
query += "where TITLE LIKE '%" + searchkey + "%'";
}
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["PAGE_ID"];
string pageTitle = row["TITLE"];
page_result.InnerHtml += "<div class=\"col5\"><a href=\"Details_of_page.aspx?pageid=" + pageid + "\">" + pageTitle + "</a></div>";
string pageBody = row["BODY"];
page_result.InnerHtml += "<div class=\"col5\">" + pageBody + "</div>";
string authorName = row["AUTHOR_NAME"];
page_result.InnerHtml += "<div class=\"col5\">" + authorName + "</div>";
string Created_date = row["CREATED_DATE"];
page_result.InnerHtml += "<div class=\"col5\">" + Created_date + "</div>";
var Edit = "<a href=\"UpdatePage.aspx?pageid=" + pageid + "\">" + "Edit" + "</a>";
page_result.InnerHtml += "<div class=\"col5last\">" + Edit + "</div>";
page_result.InnerHtml += "</div>";
}
}
