private int getPageId(string url, int siteId, int langId) { tblSites site = new tblSites(); site.LoadByPrimaryKey(siteId); tblPagesXLanguage page = new tblPagesXLanguage(); int start = url.ToLower().IndexOf(epicSiteURL.ToLower()) + epicSiteURL.Length + 7; if (getQA(url)) { start += 3; } string pageName = url.Substring(start); if (url.Contains(".aspx")) { pageName = url.Substring(start, url.IndexOf(".aspx") + 5 - start); } page.Where.PageTitle.Value = pageName; page.Where.LanguageId.Value = langId; page.Query.Load(); if (page.RowCount > 0) { page.Rewind(); return(page.PageId); } else { return(-1); } }
private void GetCMSManual() { HyperLink hl = new HyperLink(); tblSites site = new tblSites(); site.LoadByPrimaryKey((int)Session["siteid"]); hl.Text = "CMS Manual For " + site.SiteTitle; hl.NavigateUrl = "/admin/CMS_Manual.pdf"; hl.Target = "_blank"; StringBuilder sb = new StringBuilder(); sb.Append("<strong>CMS MANUAL:</strong>"); PlaceHolder1.Controls.Add(new LiteralControl(sb.ToString())); PlaceHolder1.Controls.Add(new LiteralControl("<br/>")); PlaceHolder1.Controls.Add(hl); PlaceHolder1.Controls.Add(new LiteralControl("<br/>")); }
protected void Page_Init(object sender, EventArgs e) { if (UserContext.GetContextItemAsInt("userlevel") == null && UserContext.GetContextItemAsInt("userid") == null) { Response.Redirect("login.aspx"); } else { // record the site if (Request["siteid"] != null) { Session["siteid"] = int.Parse(Request["siteid"]); } tblSites site = new tblSites(); site.LoadByPrimaryKey((int)Session["siteid"]); Page.Title = site.SiteTitle + " CMS"; // find the nav ContentPlaceHolder phMain = (ContentPlaceHolder)Master.FindControl("MainContent"); ContentPlaceHolder phNav = (ContentPlaceHolder)Master.FindControl("NavContent"); HtmlTableCell tcMain = (HtmlTableCell)Master.FindControl("contentcell"); if (Request["pg"] == "user") { phMain.Controls.Add(Page.LoadControl("controls/users/ctlUserAdmin.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } else { if (Request["pg"] == "audio") { phMain.Controls.Add(Page.LoadControl("controls/file.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } else { if (Request["pg"] == "image") { phMain.Controls.Add(Page.LoadControl("controls/file.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } else { if (Request["pg"] == "docs") { //phMain.Controls.Add(Page.LoadControl("controls/Docs/ctlDocManager.ascx")); phMain.Controls.Add(Page.LoadControl("controls/file.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } else { if (Request["pg"] == "movie") { //phMain.Controls.Add(Page.LoadControl("controls/Movies/ctlMovieManager.ascx")); phMain.Controls.Add(Page.LoadControl("controls/file.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } else { if (Request["pg"] == "podcasts") { phMain.Controls.Add(Page.LoadControl("controls/file.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } else { if (Request["pg"] == "welcome") { phMain.Controls.Add(Page.LoadControl("controls/ctl_Welcome.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } else { phMain.Controls.Add(Page.LoadControl("controls/ctlPageControls.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } } } } } } } } }
private int getLangId(string url, int siteId) { int langId = -1; try { Regex exp = new Regex(@"/\w\w-\w\w/"); MatchCollection MatchList = exp.Matches(url); Match FirstMatch = MatchList[0]; tblLanguages lang = new tblLanguages(); lang.Where.CultureTag.Value = FirstMatch.Value.Replace("/", ""); lang.Where.SiteId.Value = siteId; lang.Query.Load(); langId = lang.LanguageId; } catch (Exception e3) { if (HttpContext.Current.Request.Url.OriginalString.Contains("admin/login.aspx")) { if (HttpContext.Current.Request.RawUrl.Contains("www")) { // no language specified tblLanguages lang = new tblLanguages(); lang.Where.DefaultLanguage.Value = true; lang.Where.SiteId.Value = siteId; lang.Query.Load(); tblSites site = new tblSites(); site.LoadByPrimaryKey(siteId); Response.Redirect("http://" + epicSiteURL + "/admin/login.aspx"); } else { // no language specified tblLanguages lang = new tblLanguages(); lang.Where.DefaultLanguage.Value = true; lang.Where.SiteId.Value = siteId; lang.Query.Load(); tblSites site = new tblSites(); site.LoadByPrimaryKey(siteId); Response.Redirect("http://" + epicSiteURL + "/admin/login.aspx"); } } else { if (HttpContext.Current.Request.RawUrl.Contains("www")) { // no language specified tblLanguages lang = new tblLanguages(); lang.Where.DefaultLanguage.Value = true; lang.Where.SiteId.Value = siteId; lang.Query.Load(); tblSites site = new tblSites(); site.LoadByPrimaryKey(siteId); Response.Redirect("http://" + epicSiteURL + "/" + lang.CultureTag + "/default.aspx"); } else { // no language specified tblLanguages lang = new tblLanguages(); lang.Where.DefaultLanguage.Value = true; lang.Where.SiteId.Value = siteId; lang.Query.Load(); tblSites site = new tblSites(); site.LoadByPrimaryKey(siteId); Response.Redirect("http://" + epicSiteURL + "/" + lang.CultureTag + "/default.aspx"); } } } return(langId); }
protected void Page_Init(object sender, EventArgs e) { if (UserContext.GetContextItemAsInt("userlevel") == null && UserContext.GetContextItemAsInt("userid") == null) { Response.Redirect("login.aspx"); } else { // record the site if (Request["siteid"] != null) Session["siteid"] = int.Parse(Request["siteid"]); tblSites site = new tblSites(); site.LoadByPrimaryKey((int)Session["siteid"]); Page.Title = site.SiteTitle + " CMS"; // find the nav ContentPlaceHolder phMain = (ContentPlaceHolder)Master.FindControl("MainContent"); ContentPlaceHolder phNav = (ContentPlaceHolder)Master.FindControl("NavContent"); HtmlTableCell tcMain = (HtmlTableCell)Master.FindControl("contentcell"); if (Request["pg"] == "user") { phMain.Controls.Add(Page.LoadControl("controls/users/ctlUserAdmin.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } else { if (Request["pg"] == "audio") { phMain.Controls.Add(Page.LoadControl("controls/file.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } else { if (Request["pg"] == "image") { phMain.Controls.Add(Page.LoadControl("controls/file.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } else { if (Request["pg"] == "docs") { //phMain.Controls.Add(Page.LoadControl("controls/Docs/ctlDocManager.ascx")); phMain.Controls.Add(Page.LoadControl("controls/file.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } else { if (Request["pg"] == "movie") { //phMain.Controls.Add(Page.LoadControl("controls/Movies/ctlMovieManager.ascx")); phMain.Controls.Add(Page.LoadControl("controls/file.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } else { if (Request["pg"] == "podcasts") { phMain.Controls.Add(Page.LoadControl("controls/file.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } else { if (Request["pg"] == "welcome") { phMain.Controls.Add(Page.LoadControl("controls/ctl_Welcome.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } else { phMain.Controls.Add(Page.LoadControl("controls/ctlPageControls.ascx")); phNav.Controls.Add(Page.LoadControl("controls/ctlSiteMap.ascx")); } } } } } } } } }
private int getPageId(string url, int siteId, int langId) { tblSites site = new tblSites(); site.LoadByPrimaryKey(siteId); tblPagesXLanguage page = new tblPagesXLanguage(); int start = url.ToLower().IndexOf(epicSiteURL.ToLower()) + epicSiteURL.Length + 7; if (getQA(url)) start += 3; string pageName = url.Substring(start); if (url.Contains(".aspx")) { pageName = url.Substring(start, url.IndexOf(".aspx") + 5 - start); } page.Where.PageTitle.Value = pageName; page.Where.LanguageId.Value = langId; page.Query.Load(); if (page.RowCount > 0) { page.Rewind(); return page.PageId; } else { return -1; } }
private int getLangId(string url, int siteId) { int langId = -1; try { Regex exp = new Regex(@"/\w\w-\w\w/"); MatchCollection MatchList = exp.Matches(url); Match FirstMatch = MatchList[0]; tblLanguages lang = new tblLanguages(); lang.Where.CultureTag.Value = FirstMatch.Value.Replace("/", ""); lang.Where.SiteId.Value = siteId; lang.Query.Load(); langId = lang.LanguageId; } catch (Exception e3) { if (HttpContext.Current.Request.Url.OriginalString.Contains("admin/login.aspx")) { if (HttpContext.Current.Request.RawUrl.Contains("www")) { // no language specified tblLanguages lang = new tblLanguages(); lang.Where.DefaultLanguage.Value = true; lang.Where.SiteId.Value = siteId; lang.Query.Load(); tblSites site = new tblSites(); site.LoadByPrimaryKey(siteId); Response.Redirect("http://" + epicSiteURL + "/admin/login.aspx"); } else { // no language specified tblLanguages lang = new tblLanguages(); lang.Where.DefaultLanguage.Value = true; lang.Where.SiteId.Value = siteId; lang.Query.Load(); tblSites site = new tblSites(); site.LoadByPrimaryKey(siteId); Response.Redirect("http://" + epicSiteURL + "/admin/login.aspx"); } } else { if (HttpContext.Current.Request.RawUrl.Contains("www")) { // no language specified tblLanguages lang = new tblLanguages(); lang.Where.DefaultLanguage.Value = true; lang.Where.SiteId.Value = siteId; lang.Query.Load(); tblSites site = new tblSites(); site.LoadByPrimaryKey(siteId); Response.Redirect("http://" + epicSiteURL + "/" + lang.CultureTag + "/default.aspx"); } else { // no language specified tblLanguages lang = new tblLanguages(); lang.Where.DefaultLanguage.Value = true; lang.Where.SiteId.Value = siteId; lang.Query.Load(); tblSites site = new tblSites(); site.LoadByPrimaryKey(siteId); Response.Redirect("http://" + epicSiteURL + "/" + lang.CultureTag + "/default.aspx"); } } } return langId; }
protected void Page_PreInit(object sender, EventArgs e) { if (Request["pg"] != null) { if (int.Parse(Request["pg"]) > -1) { // first, grab the pageID int page = Int32.Parse(Request["pg"]); // then site id int site = Int32.Parse(Request["siteId"]); tblPages pages = new tblPages(); pages.Where.PageId.Value = page; pages.Query.Load(); tblMasterPages master = new tblMasterPages(); master.LoadByPrimaryKey(pages.MasterPageId); Page.MasterPageFile = "~/App_MasterPages/" + master.MasterPageTitle; // find the place holders tblContentPanes panes = new tblContentPanes(); panes.Where.MasterPageId.Value = pages.MasterPageId; panes.Query.Load(); do { tblPageXControl pgx = new tblPageXControl(); pgx.Where.PageId.Value = page; pgx.Where.ContentPaneId.Value = panes.ContentPaneId; pgx.Query.Load(); if (pgx.RowCount > 0) { pgx.Rewind(); do { ContentPlaceHolder ph1 = (ContentPlaceHolder)Master.FindControl(panes.ContentPaneTitle); tblControls control = new tblControls(); control.LoadByPrimaryKey(pgx.ControlId); ph1.Controls.Add(Page.LoadControl("~/App_Controls/" + control.ControlLocation)); } while (pgx.MoveNext()); } } while (panes.MoveNext()); tblSites ts = new tblSites(); ts.LoadByPrimaryKey(site); tblPagesXLanguage pg = new tblPagesXLanguage(); pg.Where.PageId.Value = page; pg.Where.LanguageId.Value = Convert.ToInt32(Request["langid"]); pg.Query.Load(); Page.Title = ts.SiteTitle + " - " + pg.PageFriendlyName; } } }