protected void ShowPageInfo(PagesCMSDB db)
{
bool valid = true;
string pagecmsid = Request.QueryString["pagecmsid"];
if (String.IsNullOrEmpty(pagecmsid))
{
valid = false;
}
if (valid)
{
PageCMS pagecms_record = db.FindPageCMS(Int32.Parse(pagecmsid));
pagecms_title.Text = pagecms_record.GetCMStitle();
pagecms_body.Text = pagecms_record.GetCMSbody();
}
//if not valid
if (!valid)
{
PageUpdateCMS.InnerHtml = "There was an error finding that page.";
}
}
protected void ShowPageInfo(PagesCMSDB db)
{ //Debug.WriteLine allows to check for errors in the Debug Output window easier
Debug.WriteLine("I am trying to show a page");
bool valid = true;
string pagecmsid = Request.QueryString["pagecmsid"];
if (String.IsNullOrEmpty(pagecmsid))
{
valid = false;
}
if (valid)
{
//finds page title and body info and displays it
PageCMS page_record = db.FindPageCMS(Int32.Parse(pagecmsid));
Debug.WriteLine("the page is " + page_record.GetCMStitle());
page_title.InnerHtml = page_record.GetCMStitle();
page_body.InnerHtml = page_record.GetCMSbody();
}
else
{
valid = false;
}
if (!valid)
{ //displays if the user goes to the page directly and not from
//the list page
pagecms.InnerHtml = "There was an error finding that page.";
}
}
protected void Update_PageCMS(object sender, EventArgs e)
{
PagesCMSDB db = new PagesCMSDB();
bool valid = true;
string pagecmsid = Request.QueryString["pagecmsid"];
if (String.IsNullOrEmpty(pagecmsid))
{
valid = false;
}
if (valid)
{
PageCMS new_pagecms = new PageCMS();
//sets page data
new_pagecms.SetCMStitle(pagecms_title.Text);
new_pagecms.SetCMSbody(pagecms_body.Text);
//updates page in the database
try
{
db.UpdatePageCMS(Int32.Parse(pagecmsid), new_pagecms);
Response.Redirect("ShowPageCMS.aspx?pagecmsid=" + pagecmsid);
}
catch
{
valid = false;
}
}
if (!valid)
{ //if not valid
PageUpdateCMS.InnerHtml = "There was an error updating that page.";
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Only show the data when the user visits the page for the first time
//HAVE TO MAKE SURE WE PUT
if (!Page.IsPostBack)
{
//this connection instance is for showing data
PagesCMSDB db = new PagesCMSDB();
ShowPageInfo(db);
}
}
protected void ListFeaturedPageCMS(PagesCMSDB db)
{
//query to select all of pages from table
string query = " SELECT * from pagecmsinfo ";
List <Dictionary <String, String> > rs = db.List_Query(query);
foreach (Dictionary <String, String> row in rs)
{ //displays the page titles using user control
//string stores pagecmsid to be used later
string pagecmsid = row["pagecmsid"];
//show all pages on page
//grab page using pagecmsid url, then grab the pagecmsid from the string we did above then show the page title - seperated by |
featured_pagecms.InnerHtml += "<a href=\"ShowPageCMS.aspx?pagecmsid=" + pagecmsid + "\">" + row["pagecmstitle"] + " | " + "</a>";
}
}
protected void Add_PageCMS(object sender, EventArgs e)
{
//creates a connection
PagesCMSDB db = new PagesCMSDB();
//creates a new page
PageCMS new_pagecms = new PageCMS();
//sets the page data
new_pagecms.SetCMStitle(page_title.Text);
new_pagecms.SetCMSbody(page_body.Text);
//adds the page to the database
db.AddPageCMS(new_pagecms);
Response.Redirect("ListPageCMS.aspx");
}
protected void Delete_PageCMS(object sender, EventArgs e)
{
bool valid = true;
string pagecmsid = Request.QueryString["pagecmsid"];
if (String.IsNullOrEmpty(pagecmsid))
{
valid = false;
}
PagesCMSDB db = new PagesCMSDB();
//deleting the page from the system
if (valid)
{
db.DeletePageCMS(Int32.Parse(pagecmsid));
Response.Redirect("ListPageCMS.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
pagecms_result.InnerHtml = "";
string searchkey = "";
if (Page.IsPostBack)
{
searchkey = pagecms_search.Text;
}
// query for MySQL to search for page title from database
string query = "select * from pagecmsinfo";
if (searchkey != "")
{ //annying little space between the " and WHERE was making it not work.
//ahhhh so annoying. I have to remember that c# is very case sensitive and
//a strongly typed language. Have to really be careful.
query += " where pagecmstitle like '%" + searchkey + "%' ";
}
//displays query result
sql_searcher.InnerHtml = query;
//lists pages populated from database
var db = new PagesCMSDB();
List <Dictionary <String, String> > rs = db.List_Query(query);
foreach (Dictionary <String, String> row in rs)
{
pagecms_result.InnerHtml += "<div class=\"listitem\">";
string pagecmsid = row["pagecmsid"];
string pagecmstitle = row["pagecmstitle"];
pagecms_result.InnerHtml += "<div class=\"col2\"><a href=\"ShowPageCMS.aspx?pagecmsid=" + pagecmsid + "\">" + pagecmstitle + "</a></div>";
string pagecmsbody = row["pagecmsbody"];
pagecms_result.InnerHtml += "<div class=\"col2last\">" + pagecmsbody + "</div>";
pagecms_result.InnerHtml += "</div>";
}
}
protected void Page_Load(object sender, EventArgs e)
{
PagesCMSDB db = new PagesCMSDB();
ListFeaturedPageCMS(db);
}
protected void Page_Load(object sender, EventArgs e)
{
PagesCMSDB db = new PagesCMSDB();
ShowPageInfo(db);
}