protected void ShowPageInfo(HTTP_PAGEDB db)
{
//Our flag to know if the data can be shown or not
bool valid = true;
//Get the http_pageID from the query
string http_pageID = Request.QueryString["http_pageID"];
//if there is no id then user must have went to this page without a id
if (String.IsNullOrEmpty(http_pageID))
{
valid = false;
}
//if there is a id on the page then
if (valid)
{
//Get the HTTP_Page from the id we got
HTTP_Page pageRecord = db.FindPage(Int32.Parse(http_pageID));
//Show the data on the HTML
pageID.InnerHtml = pageRecord.GetID();
pageTitle.Text = pageRecord.GetTitle();
pageContent.Text = pageRecord.GetContent();
pageDatePublished.InnerHtml = pageRecord.GetDate().ToString("MM/dd/yyyy");
}
//No id was found
if (!valid)
{
http_page.InnerHtml = "There was an error finding that page.";
}
}
//if user clicks on the Delete button and confirm yes
protected void DeletePage(object sender, EventArgs e)
{
//Our flag to know if the data can be deleted or not
bool valid = true;
//Get the http_pageID from the query
string http_pageID = Request.QueryString["http_pageID"];
//if there is no id then user must have went to this page without a id
if (String.IsNullOrEmpty(http_pageID))
{
valid = false;
}
//Create our database object
HTTP_PAGEDB db = new HTTP_PAGEDB();
//if there is a id on the page then
if (valid)
{
//Deleting the HTTP_Page from the system
db.DeletePage(Int32.Parse(http_pageID));
//Go back to the list of HTTP_Pages
Response.Redirect("Manage_HTTP_Pages.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//this connection instance is for showing data
HTTP_PAGEDB db = new HTTP_PAGEDB();
ShowPageInfo(db);
}
}
protected void ShowPageInfo(HTTP_PAGEDB db)
{
string query = "SELECT * FROM http_pages";
string SearchText = "";
//if user submit then
if (Page.IsPostBack)
{
SearchText = searchText.Text;
}
//Add a filter in the query
if (SearchText != "")
{
query += " WHERE HTTPPAGETITLE LIKE \"%" + SearchText + "%\"";
query += " OR HTTPPAGEDATE LIKE \"%" + SearchText + "%\"";
}
//Order Method
query += " ORDER BY " + pageListOrder.SelectedValue.ToUpper();
query += " " + pageListOrderDirection.SelectedValue.ToUpper();
//Get the result of object (Result table from the query)
List <HTTP_Page> pages = db.List_Query(query);
//Clear the data right now
resultTable.InnerHtml = "";
//For each HTTP_Page in the result
foreach (HTTP_Page row in pages)
{
//Show the particular HTTP_Page data on the HTML
resultTable.InnerHtml += "<div class=\"flexContainer tableRow\">";
resultTable.InnerHtml += "<div><a href=\"ShowHTTP_Page.aspx?http_pageID=" + row.GetID() + "\">" + row.GetTitle() + "</a></div>";
resultTable.InnerHtml += "<div>" + row.GetDate().ToString("MM/dd/yyyy") + "</div>";
resultTable.InnerHtml += "<div><a href=\"UpdateHTTP_Page.aspx?http_pageID=" + row.GetID() + "\">Edit</a></div>";
//Attempts to make a delete button in the page
//resultTable.InnerHtml += "<div><a href=\"\">Delete</a></div>";
//resultTable.InnerHtml += "<div><asp:button ID=\"deleteButtonPage" + row.GetID() + "\" Text=\"Delete\" runat=\"server\" /></div>";
//resultTable.InnerHtml += "<div><input runat=\"server\" Value=\"Delete\" type=\"button\" onclick=\"if (confirm(\"Are you sure want to delete this\")) {window.location.href=\"Manage_HTTP_Pages.aspx?http_pageID=" + row.GetID() + ";\"callback(DeletePage);}\" /></div>";
//resultTable.InnerHtml += "<div><asp:Button runat=\"server\" Text=\"Delete\" OnClientClick = \"if(!confirm('Are you sure you want to delete this?')) return false;\" OnClick = \"DeletePage\" /></div>";
//End of particular HTTP_Page
resultTable.InnerHtml += "</div>";
}
}
//if the user clicks on the Update Page button
protected void UpdatePage(object sender, EventArgs e)
{
//Create our database object
HTTP_PAGEDB db = new HTTP_PAGEDB();
//Our flag to know if the data can be obtained or not
bool valid = true;
//Get the http_pageID from the query
string http_pageID = Request.QueryString["http_pageID"];
//if there is no id then user must have went to this page without a id
if (String.IsNullOrEmpty(http_pageID))
{
valid = false;
}
//if there is a id on the page then
if (valid)
{
//Create a new HTTP_Page object
HTTP_Page newPage = new HTTP_Page();
//Set the necessary value in the HTTP_Page object that will get updated
newPage.SetTitle(pageTitle.Text);
newPage.SetContent(pageContent.Text);
try
{
//Update the HTTP_Page to the database
db.UpdatePage(Int32.Parse(http_pageID), newPage);
//Go back to the show page of this particular HTTP_Page we are updating
Response.Redirect("ShowHTTP_Page.aspx?http_pageID=" + http_pageID);
}
catch
{
valid = false;
}
}
//No id was found or failed to update
if (!valid)
{
http_page.InnerHtml = "There was an error updating that page.";
}
}
//When user clicks on the Add Page button
protected void AddPage(object sender, EventArgs e)
{
//Create connection
HTTP_PAGEDB db = new HTTP_PAGEDB();
//Create a new particular HTTP_Page
HTTP_Page newPage = new HTTP_Page();
//Set that page data
newPage.SetTitle(pageTitle.Text);
newPage.SetContent(pageContent.Text);
newPage.SetDate(DateTime.Today);
//Add the page to the database
db.AddPage(newPage);
//Go back to the list of HTTP_Pages
Response.Redirect("Manage_HTTP_Pages.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
HTTP_PAGEDB db = new HTTP_PAGEDB();
ShowPageInfo(db);
}