public static string GetLanguageId()
{
string langId = "";
if (HttpContext.Current.Request["langId"] != null)
{
langId = HttpContext.Current.Request["langId"].ToString();
}
else
{
string siteId = "";
if ((HttpContext.Current.Request["siteId"] != null) && (HttpContext.Current.Request["siteId"].ToString() != "-1"))
{
siteId = HttpContext.Current.Request["siteId"].ToString();
}
else
{
tblSites s = new tblSites();
s.Where.SiteTitle.Value = epicShared.GetSiteIdURL();
s.Query.Load();
siteId = s.SiteId.ToString();
}
tblLanguages lang = new tblLanguages();
lang.Where.DefaultLanguage.Value = true;
lang.Where.SiteId.Value = Int32.Parse(siteId);
lang.Query.Load();
langId = lang.LanguageId.ToString();
}
return(langId);
}
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/>"));
}
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/>"));
}
private int getSiteId(string url)
{
tblSites sites = new tblSites();
sites.LoadAll();
do
{
if (url.ToLower().Contains(sites.SiteURL.ToLower()))
{
epicSiteURL = sites.SiteURL.ToLower();
return(sites.SiteId);
}
else if (url.ToLower().Contains(sites.SiteBetaURL.ToLower()))
{
epicSiteURL = sites.SiteBetaURL.ToLower();
return(sites.SiteId);
}
} while (sites.MoveNext());
return(-1);
}
protected void Page_Load(object sender, EventArgs e)
{
int langId = -1;
if (Request["langId"] != null)
{
langId = Int32.Parse(Request["langId"]);
}
else
{
string siteId = "";
if ((Request["siteId"] != null) && (Request["siteId"].ToString() != "-1"))
{
siteId = Request["siteId"].ToString();
}
else
{
tblSites s = new tblSites();
s.Where.SiteTitle.Value = epicShared.GetSiteIdURL();
s.Query.Load();
siteId = s.SiteId.ToString();
}
tblLanguages lang = new tblLanguages();
lang.Where.DefaultLanguage.Value = true;
lang.Where.SiteId.Value = Int32.Parse(siteId);
lang.Query.Load();
langId = lang.LanguageId;
}
//if (!Page.IsPostBack)
// CreateLanguages();
DisplayMap(langId);
}
protected void Page_Load(object sender, EventArgs e)
{
int langId=-1;
if (Request["langId"] != null)
{
langId = Int32.Parse(Request["langId"]);
}
else
{
string siteId = "";
if ((Request["siteId"] != null) && (Request["siteId"].ToString() != "-1"))
{
siteId = Request["siteId"].ToString();
}
else
{
tblSites s = new tblSites();
s.Where.SiteTitle.Value = epicShared.GetSiteIdURL();
s.Query.Load();
siteId = s.SiteId.ToString();
}
tblLanguages lang = new tblLanguages();
lang.Where.DefaultLanguage.Value = true;
lang.Where.SiteId.Value = Int32.Parse(siteId);
lang.Query.Load();
langId = lang.LanguageId;
}
//if (!Page.IsPostBack)
// CreateLanguages();
DisplayMap(langId);
}
public static string GetLanguageId()
{
string langId = "";
if (HttpContext.Current.Request["langId"] != null)
{
langId = HttpContext.Current.Request["langId"].ToString();
}
else
{
string siteId = "";
if ((HttpContext.Current.Request["siteId"] != null) && (HttpContext.Current.Request["siteId"].ToString() != "-1"))
{
siteId = HttpContext.Current.Request["siteId"].ToString();
}
else
{
tblSites s = new tblSites();
s.Where.SiteTitle.Value = epicShared.GetSiteIdURL();
s.Query.Load();
siteId = s.SiteId.ToString();
}
tblLanguages lang = new tblLanguages();
lang.Where.DefaultLanguage.Value = true;
lang.Where.SiteId.Value = Int32.Parse(siteId);
lang.Query.Load();
langId = lang.LanguageId.ToString();
}
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 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 getSiteId(string url)
{
tblSites sites = new tblSites();
sites.LoadAll();
do
{
if (url.ToLower().Contains(sites.SiteURL.ToLower()))
{
epicSiteURL = sites.SiteURL.ToLower();
return sites.SiteId;
}
else if (url.ToLower().Contains(sites.SiteBetaURL.ToLower()))
{
epicSiteURL = sites.SiteBetaURL.ToLower();
return sites.SiteId;
}
} while (sites.MoveNext());
return -1;
}
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;
}
}
}
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;
}
}
}
