public void AdjustSlider(SliderGallery sliderGallery) { if (sliderGallery.HasSlides) { CoverImagePath = sliderGallery.CoverImageFileName; PromoClipLink.NavigateUrl = sliderGallery.PromoClipUri; ShowSlider(sliderGallery.Slides); } }
protected void Page_Load(object sender, EventArgs e) { string sql = ""; //Set Domain if (HttpContext.Current.Request.ServerVariables["SERVER_NAME"].ToString() != "localhost") basedomain = "http://" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"]; //Show slider since we are on the global home page SliderGallery sliderGallery = new SliderGallery(); ((ER_BestPickReports_Dev.SiteMaster)Master).AdjustSlider(sliderGallery); //Set masterpage variable for footer city rel attribute ((ER_BestPickReports_Dev.SiteMaster)Master).setnofollow = false; //Hide form errors on load NewsletterErrorPanel.Visible = false; GuideErrorPanel.Visible = false; if (!IsPostBack) { //Redirect if cookie and qs redirect is not false if (Request.QueryString["redirect"] == null) { if ( !String.IsNullOrEmpty(bprPreferences.CityUrlName) && !String.IsNullOrEmpty(bprPreferences.AreaUrlName)) { Response.Redirect(basedomain + "/" + bprPreferences.CityUrlName + "/" + bprPreferences.AreaUrlName); } else { bprPreferences.RemoveAll(); } } } RibbonImage.ImageUrl = "/images/" + DateTime.Today.Year.ToString() + "_ribbon_global_metro.png"; if (!String.IsNullOrEmpty(bprPreferences.CityUrlName) && !String.IsNullOrEmpty(bprPreferences.AreaUrlName)) { pagecityid = bprPreferences.CityId; pageareaid = bprPreferences.AreaId; } //Add meta info HtmlMeta meta1; //HtmlMeta meta2; //meta2 = new HtmlMeta(); //meta2.Name = "keywords"; //meta2.Content = ""; //Page.Header.Controls.Add(meta2); //Page.Header.Controls.Add(new LiteralControl("\n")); meta1 = new HtmlMeta(); meta1.Name = "description"; meta1.Content = "Best Pick Reports and Home Reports are annual publications produced by EBSCO Research, an independent research firm founded in 1997."; Page.Header.Controls.Add(meta1); Page.Header.Controls.Add(new LiteralControl("\n")); //Get homeowner testimonials sql = "SELECT TOP 20 * FROM HomeownerTestimonial WHERE (PublishDate <= @DATE) ORDER BY NEWID()"; DataTable allitems = DataAccessHelper.Data.ExecuteDataset(sql, new SqlParameter("@DATE", DateTime.Now)).Tables[0]; TList.DataSource = allitems; TList.DataBind(); //// A stackSize of 0 will guarantee that you have 'numLists' lists and //// that the items are distributed equally from left to right. //List<DataTable> lists = GetListData(allitems, 0, numLists); //// How many lists actually have data //for (int i = 1; i <= lists.Count; i++) //{ // if (lists[i - 1].Rows.Count > 0) // dataCount++; //} //// Bind to the lists. There could be fewer populated lists based on your settings. //for (int i = 1; i <= lists.Count; i++) //{ // currentList = i; // ListView listView = FindUIControl(i); // listView.DataSource = lists[i - 1]; // listView.DataBind(); //} }
protected void Page_Load(object sender, EventArgs e) { //Get value from route handler cityID = BWSession.tempCityID; areaID = BWSession.tempAreaID; strcity = (HttpContext.Current.Items["city"].ToString() == "" || HttpContext.Current.Items["city"].ToString() == null) ? "" : HttpContext.Current.Items["city"].ToString(); strarea = (HttpContext.Current.Items["area"].ToString() == "" || HttpContext.Current.Items["area"].ToString() == null) ? "" : HttpContext.Current.Items["area"].ToString(); //Set cityid and areaid on master page ((ER_BestPickReports_Dev.SiteMaster)Master).cityID = cityID; ((ER_BestPickReports_Dev.SiteMaster)Master).areaID = areaID; SliderGallery sliderGallery = new SliderGallery(cityID, areaID); ((ER_BestPickReports_Dev.SiteMaster)Master).AdjustSlider(sliderGallery); //Hide form errors on load NewsletterErrorPanel.Visible = false; GuideErrorPanel.Visible = false; //Set Domain if (HttpContext.Current.Request.ServerVariables["SERVER_NAME"].ToString() != "localhost") basedomain = "http://" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"]; //Hide items for Boston and Philly markets if (DataAccessHelper.GetCityUrlFromID(cityID.ToString()) == "philadelphia" || DataAccessHelper.GetCityUrlFromID(cityID.ToString()) == "boston") { RequestPanel.Visible = false; } string sql = ""; using (SqlConnection conn = new SqlConnection(DataAccessHelper.ConnString)) { conn.Open(); //Show page content sql = "SELECT Area.AreaID, Area.CityID, CityInfo.MetaTitle AS CityMetaTitle, CityInfo.MetaDesc AS CityMetaDesc, CityInfo.MetaKey AS CityMetaKey, " + "CityInfo.ShortDesc AS CityRibbonText, CityInfo.LongDesc AS CityBlogText, CityInfo.MobileYear AS DataYear, AreaInfo.MetaTitle AS AreaMetaTitle, AreaInfo.MetaDesc AS AreaMetaDesc, AreaInfo.MetaKey AS AreaMetaKey, " + "AreaInfo.ShortDesc AS AreaRibbonText, AreaInfo.LongDesc AS AreaBlogText, AreaInfo.UrlName AS AreaUrlName, AreaInfo.DisplayName AS AreaDisplayName, CityInfo.UrlName AS CityUrlName, " + "CityInfo.DisplayName AS CityDisplayName FROM Area INNER JOIN CityInfo ON Area.CityID = CityInfo.CityID INNER JOIN AreaInfo ON Area.AreaID = AreaInfo.AreaID " + "WHERE (AreaInfo.AreaID = @AREAID) AND (CityInfo.CityID = @CITYID)"; SqlDataReader rdr = DataAccessHelper.Data.ExecuteDatareader(conn, sql, new SqlParameter("@AREAID", areaID), new SqlParameter("@CITYID", cityID)); if (rdr.Read()) { string ryear = DateTime.Today.Year.ToString(); if (rdr["DataYear"].ToString() != "0") ryear = rdr["DataYear"].ToString(); RibbonImage.ImageUrl = "/images/" + ryear + "_ribbon_global_metro.png"; RibbonImage.AlternateText = ryear + " EBSCO Research Best Pick"; RibbonImage.ToolTip = ryear + " EBSCO Research Best Pick"; if (rdr["AreaRibbonText"].ToString() != "") RibbonText.Text = rdr["AreaRibbonText"].ToString(); else RibbonText.Text = rdr["CityRibbonText"].ToString(); //BlogCityLink.NavigateUrl = basedomain + "/blog/" + rdr["CityURLName"].ToString(); if (rdr["AreaBlogText"].ToString() != "") BlogText.Text = rdr["AreaBlogText"].ToString(); else BlogText.Text = rdr["CityBlogText"].ToString(); FeedCityLink.NavigateUrl = basedomain + "/blog/" + rdr["CityURLName"].ToString(); FeedCityName.Text = rdr["CityDisplayName"].ToString(); //Check for info at the area level - if empty, use city level info string strMetaTitle = ""; string strMetaKey = ""; string strMetaDesc = ""; if (rdr["AreaMetaTitle"].ToString() != "") strMetaTitle = rdr["AreaMetaTitle"].ToString(); else strMetaTitle = rdr["CityMetaTitle"].ToString(); if (rdr["AreaMetaKey"].ToString() != "") strMetaKey = rdr["AreaMetaKey"].ToString(); else strMetaKey = rdr["CityMetaKey"].ToString(); if (rdr["AreaMetaDesc"].ToString() != "") strMetaDesc = rdr["AreaMetaDesc"].ToString(); else strMetaDesc = rdr["CityMetaDesc"].ToString(); //Add meta info HtmlMeta meta1; HtmlMeta meta2; meta2 = new HtmlMeta(); meta2.Name = "keywords"; meta2.Content = strMetaKey; Page.Header.Controls.Add(meta2); Page.Header.Controls.Add(new LiteralControl("\n")); meta1 = new HtmlMeta(); meta1.Name = "description"; meta1.Content = strMetaDesc; Page.Header.Controls.Add(meta1); Page.Header.Controls.Add(new LiteralControl("\n")); Page.Title = strMetaTitle; //Set cookie for city/area preference bprPreferences.CityId = int.Parse(cityID.ToString()); bprPreferences.CityName = rdr["CityDisplayName"].ToString(); bprPreferences.CityUrlName = rdr["CityURLName"].ToString(); bprPreferences.AreaId = int.Parse(areaID.ToString()); bprPreferences.AreaName = rdr["AreaDisplayName"].ToString(); bprPreferences.AreaUrlName = rdr["AreaURLName"].ToString(); bprPreferences.SetExpiration(DateTime.Now.AddDays(365)); } rdr.Close(); conn.Close(); } //Get homeowner testimonials sql = "SELECT TOP 20 * FROM HomeownerTestimonial WHERE (CityID = @CITYID) AND (PublishDate <= @DATE) ORDER BY NEWID()"; DataTable allitems = DataAccessHelper.Data.ExecuteDataset(sql, new SqlParameter("@CITYID", cityID), new SqlParameter("@DATE", DateTime.Now)).Tables[0]; TList.DataSource = allitems; TList.DataBind(); //// A stackSize of 0 will guarantee that you have 'numLists' lists and //// that the items are distributed equally from left to right. //List<DataTable> lists = GetListData(allitems, 0, numLists); //// How many lists actually have data //for (int i = 1; i <= lists.Count; i++) //{ // if (lists[i - 1].Rows.Count > 0) // dataCount++; //} //// Bind to the lists. There could be fewer populated lists based on your settings. //for (int i = 1; i <= lists.Count; i++) //{ // currentList = i; // ListView listView = FindUIControl(i); // listView.DataSource = lists[i - 1]; // listView.DataBind(); //} }