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