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; }