protected void ShowContentPageDetail()
{
bool valid = true;
string ContentPage_Id = Request.QueryString["id"];
if (String.IsNullOrEmpty(ContentPage_Id))
{
valid = false;
}
//We will attempt to get the record we need
if (valid)
{
CMSDB db = new CMSDB();
ContentPage ContentPage_Record = db.GetContentPageById(Int32.Parse(ContentPage_Id));
contentpage_title.InnerHtml = ContentPage_Record.Title;
contentpage_body.Text = ContentPage_Record.Body;
contentpage_publishdate.InnerText = ContentPage_Record.PublishDate.ToString("D");
}
else
{
valid = false;
}
if (!valid)
{
contentpage_body_panel.InnerHtml = "There was an error finding that Content Page.";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CMSDB db = new CMSDB();
//Connection to db and fetch all content pages
ListNavigationContentPages(db);
}
}
protected void search_btn_Click(object sender, EventArgs e)
{
//Create connection to database
CMSDB db = new CMSDB();
//store the search keyword in variable
string Search_Keywords = search_keyword.Text.Trim();
//Bind Gridview after searching
contentpages_list_gridview.DataSource = db.SearchContentPagesByPageTitle(Search_Keywords);
contentpages_list_gridview.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//Create connection to database
CMSDB db = new CMSDB();
//Bind Gridview with data
contentpages_list_gridview.DataSource = db.ListContentPages();
contentpages_list_gridview.DataBind();
}
}
private void ListNavigationContentPages(CMSDB db)
{
List <ContentPage> ContentPage_List = new List <ContentPage>();
ContentPage_List = db.GetNavigationMenuData();
foreach (ContentPage page in ContentPage_List)
{
//Set the Main navigation to all content pages page title
string url = "<li><a href='ViewContentPage.aspx?id={0}'>{1}</a></li>";
url = string.Format(url, page.Id, page.Title);
header_nav.InnerHtml += url;
}
}
protected void delete_contentpage_Click(object sender, EventArgs e)
{
bool valid = true;
string ContentPage_Id = Request.QueryString["id"];
if (String.IsNullOrEmpty(ContentPage_Id))
{
valid = false;
}
//We will attempt to get the record we need
if (valid)
{
CMSDB db = new CMSDB();
db.DeleteContentPage(Int32.Parse(ContentPage_Id));
Response.Redirect("ListContentPages.aspx");
}
}
protected void btn_submit_Click(object sender, EventArgs e)
{
//create connection to cms database
CMSDB db = new CMSDB();
//create a new content page
ContentPage ContentPage = new ContentPage();
//set content page data
ContentPage.Title = contentpage_title.Text.Trim();
ContentPage.Body = contentpage_body.Text.Trim();
ContentPage.PublishDate = DateTime.Now;
//add the content page to the database
db.AddContentPage(ContentPage);
Response.Redirect("ListContentPages.aspx");
}
protected void btn_submit_Click(object sender, EventArgs e)
{
bool valid = true;
string ContentPage_Id = Request.QueryString["id"];
if (String.IsNullOrEmpty(ContentPage_Id))
{
valid = false;
}
//We will attempt to update the record we need
if (valid)
{
//create connection to cms database
CMSDB db = new CMSDB();
//create a new content page
ContentPage ContentPage = new ContentPage();
//set that content page data
ContentPage.Title = contentpage_title.Text.Trim();
ContentPage.Body = contentpage_body.Text.Trim();
ContentPage.PublishDate = DateTime.Now;
//update the content page to the database
db.UpdateContentPage(Convert.ToInt32(ContentPage_Id), ContentPage);
Response.Redirect("ListContentPages.aspx");
}
else
{
valid = false;
}
if (!valid)
{
contentpage_body_panel.InnerHtml = "There was an error finding that Content Page.";
}
}
protected void contentpages_list_gridview_RowCommand(object sender, GridViewCommandEventArgs e)
{
//Redirect to content page detail
if (e.CommandName == "view_contentpage")
{
Response.Redirect("ViewContentPage.aspx?id=" + e.CommandArgument.ToString());
}
//Redirect to content page editing
else if (e.CommandName == "edit_contentpage")
{
Response.Redirect("EditContentPage.aspx?id=" + e.CommandArgument.ToString());
}
else if (e.CommandName == "publish_unpublish_contentpage")
{
string[] commandArgs = e.CommandArgument.ToString().Split(new char[] { ',' });
int Content_Id = Convert.ToInt32(commandArgs[0]);
bool Is_Published = Convert.ToBoolean(commandArgs[1]);
//Change the opposite status
CMSDB db = new CMSDB();
db.PublishUnpublishContentPage(Content_Id, !Is_Published);
Response.Redirect("ListContentPages.aspx");
}
}
