public List <CMSPage> GetPages()
{
var pages = new List <CMSPage>();
var dt = GetDTFromStoredProc("page_select", new List <SqlParameter> {
});
foreach (DataRow dr in dt.Rows)
{
var page = new CMSPage();
page.PageId = Convert.ToInt32(dr["pageId"].ToString());
page.ContentKey = dr["ContentKey"].ToString();
page.Title = dr["Title"].ToString();
page.PageContent = dr["PageContent"].ToString();
page.HeadContent = dr["HeadContent"].ToString();
page.ScriptBlock = dr["ScriptBlock"].ToString();
page.ScriptBlock = dr["MetaContent"].ToString();
page.ScriptBlock = dr["PrimaryMenu"].ToString();
page.ScriptBlock = dr["AuxMenu"].ToString();
page.DateModified = Convert.ToDateTime(dr["DateModified"]);
pages.Add(page);
}
return(pages);
}
/// <summary>
/// Method determines whether "pageName" is a "real" view and controller entry, or a virtual page.
/// If it is a "real" view, the real view is called.
/// Else a page entry is searched for in the DB. If it isn't found, display a groovy 404 page.
/// </summary>
/// <param name="pageName"></param>
/// <param name="param1"></param>
/// <param name="param2"></param>
/// <returns></returns>
public ActionResult Router(string url)
{
if (string.IsNullOrEmpty(url))
{
return RedirectToAction("Index");
}
else
{
var firstSegment = GetFirstSegment(url, '/');
//this is a page that is included in our CMS (page viewable via the DB)
CMSPage cmsPage = new CMSPage();
cmsPage = cmsPage.GetPage(firstSegment);
if (cmsPage != null)
{
return View("CMSPage", cmsPage);
}
else
return View("NoJoy");
}
}
public List<CMSPage> GetPages()
{
var pages = new List<CMSPage>();
var dt = GetDTFromStoredProc("page_select", new List<SqlParameter> { });
foreach (DataRow dr in dt.Rows)
{
var page = new CMSPage();
page.PageId = Convert.ToInt32(dr["pageId"].ToString());
page.ContentKey = dr["ContentKey"].ToString();
page.Title = dr["Title"].ToString();
page.PageContent = dr["PageContent"].ToString();
page.HeadContent = dr["HeadContent"].ToString();
page.ScriptBlock = dr["ScriptBlock"].ToString();
page.ScriptBlock = dr["MetaContent"].ToString();
page.ScriptBlock = dr["PrimaryMenu"].ToString();
page.ScriptBlock = dr["AuxMenu"].ToString();
page.DateModified = Convert.ToDateTime(dr["DateModified"]);
pages.Add(page);
}
return pages;
}
