protected void Add_Page(object sender, EventArgs e)
{
//create connection
Dbconnection db = new Dbconnection();
//create a new particular student
HttpPage new_HttpPage = new HttpPage();
//set that student data
new_HttpPage.SetPageTitle(pagetitle.Text);
new_HttpPage.SetPageContent(pagecontent.Text);
new_HttpPage.SetPageAuthor(pageauthor.Text);
DateTime dateTimeVariable = DateTime.Now;
string date = dateTimeVariable.ToString("yyyy-MM-dd H:mm:ss");
new_HttpPage.SetPagePublish_Date(date);
//add the student to the database
db.AddPage(new_HttpPage);
Response.Redirect("ListPages.aspx");
}
protected void Update_Page(object sender, EventArgs e)
{
//this connection instance is for editing data
Dbconnection db = new Dbconnection();
bool valid = true;
string Pageid = Request.QueryString["pageid"];
if (!String.IsNullOrEmpty(Pageid))
{
HttpPage new_HttpPage = new HttpPage();
//set that Page data
new_HttpPage.SetPageTitle(pagetitle.Text);
new_HttpPage.SetPageContent(pagecontent.Text);
new_HttpPage.SetPageAuthor(pageauthor.Text);
//add the Page data to the database
try
{
db.UpdatePage(Int32.Parse(Pageid), new_HttpPage);
Response.Redirect("ViewPage.aspx?pageid=" + Pageid);
}
catch
{
valid = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//this connection instance is for showing data
Dbconnection db = new Dbconnection();
bool valid = true;
string pageid = Request.QueryString["pageid"];
Debug.WriteLine("PageID:" + pageid);
if (String.IsNullOrEmpty(pageid))
{
valid = false;
}
//We will attempt to get the record we need
if (valid)
{
HttpPage page_record = db.FindHttpPage(Int32.Parse(pageid));
pagetitle.Text = page_record.GetPageTitle();
pagecontent.Text = page_record.GetPageContent();
pageauthor.Text = page_record.GetPageAuthor();
}
}
}
//function to delete the page on button click
public void Delete_Page(object sender, EventArgs e)
{
string pageid = Request.QueryString["pageid"];
Dbconnection db = new Dbconnection();
db.DeletePage(pageid);
Response.Redirect("ListPages.aspx");
}
void searchpage(Dbconnection db)
{
string query = "select * from pages order by pageid";
List <Dictionary <string, string> > rs = db.List_Query(query);
Dynamic_Menu.InnerHtml = "<ul class=\"nav navbar-nav\">";
foreach (Dictionary <string, string> row in rs)
{
string pageid = row["pageid"];
string pagetitle = row["pagetitle"];
Dynamic_Menu.InnerHtml += "<li><a href=\"ViewPage.aspx?pageid=" + pageid + "\">" + pagetitle + "</a></li>";
}
Dynamic_Menu.InnerHtml += "</ul>";
}
public void ShowPageInfo(Dbconnection db)
{
bool valid = true;
string pageid = Request.QueryString["pageid"];
if (String.IsNullOrEmpty(pageid))
{
valid = false;
}
if (valid)
{
//finding the page we requested by refering the function FindHttpPage in Dbconnection.cs and gets the records to display on html page
HttpPage page_record = db.FindHttpPage(Int32.Parse(pageid));
heading.InnerHtml = page_record.GetPageTitle();
pagecontent.InnerHtml = page_record.GetPageContent();
author.InnerHtml = "Author:" + " " + page_record.GetPageAuthor();
Publishdate.InnerHtml = "Published on" + " " + page_record.GetPagePublish_Date();
}
else
{
valid = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Dbconnection db = new Dbconnection();
ShowPageInfo(db);
}
protected void Page_Load(object sender, EventArgs e)
{ //empty string to store search key
string Search_Key = "";
//empty string to store query
string query = "";
if (Page.IsPostBack)
{
Search_Key = Search_txt.Text.ToString();
//on post back we store keyword entered in textbox to Search_Key
}
//cheking if string is empty we display all records in th table
if (Search_Key == "")
{
query = "select * from pages";
}
//if string is not empty we search for the records which matches that string
else
{
query = "select * from pages where pagetitle like '%" + Search_Key + "%' order by pageid";
}
var db = new Dbconnection();
//printing all records one by one in a table row
List <Dictionary <String, String> > rs = db.List_Query(query);
foreach (Dictionary <String, String> row in rs)
{
string pageid = row["pageid"];
string pagetitle = row["pagetitle"];
string pagecontent = row["pagebody"];
string pageauthor = row["author"];
string publish_date_time = row["Publish_Date"];
HtmlTableRow trow = new HtmlTableRow();
//1st column
HtmlTableCell Cell1 = new HtmlTableCell();
Cell1.InnerText = pageid;
trow.Controls.Add(Cell1);
//2nd column
HtmlTableCell Cell2 = new HtmlTableCell();
Cell2.InnerHtml = "<a href=\"ViewPage.aspx?pageid=" + pageid + "\">" + pagetitle + "</a>";
trow.Controls.Add(Cell2);
//3nd column
HtmlTableCell Cell3 = new HtmlTableCell();
Cell3.InnerText = pagecontent;
trow.Controls.Add(Cell3);
//4th column
HtmlTableCell Cell4 = new HtmlTableCell();
Cell4.InnerText = pageauthor;
trow.Controls.Add(Cell4);
//5th column
LinkButton EditButton = new LinkButton();
EditButton.Text = "EDIT";
EditButton.ID = "Edit_btn";
EditButton.PostBackUrl = "EditPage.aspx?pageid=" + pageid;
HtmlTableCell cell5 = new HtmlTableCell();
cell5.Controls.Add(EditButton);
trow.Cells.Add(cell5);
////6th column
//LinkButton DeleteButton = new LinkButton();
//DeleteButton.Text = "DELETE";
//DeleteButton.Click += new EventHandler(D);
//HtmlTableCell cell6 = new HtmlTableCell();
//cell6.Controls.Add(DeleteButton);
//trow.Cells.Add(cell6);
Table1.Rows.Add(trow);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Dbconnection db = new Dbconnection();
searchpage(db);
}