protected void Page_Load(object sender, EventArgs e) { try { if (Session["User"] == null) { if (!IsPostBack) { HttpCookie cookie = Request.Cookies["BrowserDate"]; Response.Cache.SetCacheability(HttpCacheability.NoCache); DateTime isn = DateTime.Now; DateTime.TryParse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"), out isn); Data dat = new Data(isn); if (Session["LocCity"] == null || Session["LocState"] == null || Session["LocCountry"] == null) { LocationLabel.Text = dat.IP2Location().Trim(); } else { LocationLabel.Text = Session["LocCity"].ToString().Trim() + ", " + Session["LocState"].ToString().Trim(); } } } else { NotLoggedIn.Visible = false; } } catch (Exception ex) { LocationLabel.Text = ex.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { ////Page.Trace.IsEnabled = true; ////Page.Trace.TraceMode = TraceMode.SortByTime; Page.Trace.Write("Started Page Load"); //if (Request.QueryString["page"] == null) // Response.Redirect("event-search?page=1"); Session["Searching"] = "Events"; MessageLabel.Text = ""; DataSet ds; BottomScriptLiteral.Text = "<script type=\"text/javascript\">initialize1();</script>"; HttpCookie cookie = Request.Cookies["BrowserDate"]; if (cookie == null) { cookie = new HttpCookie("BrowserDate"); cookie.Value = DateTime.Now.ToString(); cookie.Expires = DateTime.Now.AddDays(22); Response.Cookies.Add(cookie); } DateTime isn = DateTime.Now; DateTime.TryParse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"), out isn); Data dat = new Data(isn); HtmlHead head = (HtmlHead)Page.Header; Literal lit = new Literal(); lit.Text = "<script src=\"http://maps.google.com/maps?file=api&v=2&sensor=false&key=ABQIAAAAjjoxQtYNtdn3Tc17U5-jbBR2Kk_H7gXZZZniNQ8L14X1BLzkNhQjgZq1k-Pxm8FxVhUy3rfc6L9O4g\" type=\"text/javascript\"></script>"; head.Controls.Add(lit); Page.Trace.Write("Before Buttons"); #region Take Care of Buttons SearchButton.BUTTON_TEXT += "<img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/search.png\"/>"; //SearchButton.BUTTON_TEXT = "<div class=\"NavyLink12UD\">Search</div>"; SearchButton.SERVER_CLICK += SearchButton_Click; //TodayButton.BUTTON_TEXT = "<div><img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/TodayText.png\"/></div>"; //TodayButton.BUTTON_TEXT = "Today"; //TodayButton.ADD_STYLE = "width: 74%; "; //TomorrowButton.BUTTON_TEXT = "<div><img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/TomorrowText.png\"/></div>"; //TomorrowButton.BUTTON_TEXT = "Tomorrow"; //TomorrowButton.ADD_STYLE = "width: 81%; "; //ThisWeekButton.BUTTON_TEXT = "<div><img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/ThisWeekText.png\"/></div>"; //ThisWeekButton.BUTTON_TEXT = "This Week"; //ThisWeekButton.ADD_STYLE = "width: 74%; "; //ThisWeekendButton.BUTTON_TEXT = "<div><img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/ThisWeekendText.png\"/></div>"; //ThisWeekendButton.BUTTON_TEXT = "This Weekend"; //ThisWeekendButton.ADD_STYLE = "width: 81%; "; //ThisMonthButton.BUTTON_TEXT = "<div><img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/ThisMonth.png\"/></div>"; //ThisMonthButton.BUTTON_TEXT = "This Month"; //ThisMonthButton.ADD_STYLE = "width: 74%; "; //TodayButton.SERVER_CLICK += SetToday; //TomorrowButton.SERVER_CLICK += SetTomorrow; //ThisWeekButton.SERVER_CLICK += SetThisWeek; //ThisWeekendButton.SERVER_CLICK += SetThisWeekend; //ThisMonthButton.SERVER_CLICK += SetThisMonth; FilterButton.SERVER_CLICK += FilterResults; SmallButton1.BUTTON_TEXT += "<img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/search.png\"/>"; SmallButton1.SERVER_CLICK += SearchButton_Click; #endregion Page.Trace.Write("After Buttons"); ////Page.Trace.Write("Finished Initialization"); if (!IsPostBack) { HttpCookie timeCookie = Request.Cookies["SetTime"]; if (timeCookie != null) { timeCookie = new HttpCookie("BrowserDate"); timeCookie.Value = "All%20Future%20Events"; Response.Cookies.Add(timeCookie); TimeFrameDiv.InnerText = "All Future Events"; } Session["HighestPrice"] = null; Session.Remove("HighestPrice"); Session["SetVenue"] = null; Session.Remove("SetVenue"); Session["SearchDS"] = null; Session.Remove("SearchDS"); NumsLabel.Text = ""; NoResultsPanel.Visible = true; MapPanel.Visible = false; TopLiteral.Text = "<script type=\"text/javascript\">function initialize1(){map = null;}</script>"; ScriptLiteral.Text = ""; HtmlLink lk = new HtmlLink(); lk.Attributes.Add("rel", "canonical"); lk.Href = "http://hippohappenings.com/event-search"; head.Controls.AddAt(0, lk); //Create keyword and description meta tags HtmlMeta hm = new HtmlMeta(); HtmlMeta kw = new HtmlMeta(); kw.Name = "keywords"; kw.Content = "local events happenings going on neighborhood local find search"; head.Controls.AddAt(0, kw); hm.Name = "Description"; hm.Content = "Find local events, happenings, going on in your neighborhood on HippoHappenings, the site which fosters communities."; head.Controls.AddAt(0, hm); lk = new HtmlLink(); lk.Href = "http://" + Request.Url.Authority + "/event-search"; lk.Attributes.Add("rel", "bookmark"); head.Controls.AddAt(0, lk); EventTitle.Text = "<a style=\"text-decoration: none;\" href=\"" + lk.Href + "\"><h1>Search Events</h1></a>"; //Button button = (Button)dat.FindControlRecursive(this, "EventLink"); //button.CssClass = "NavBarImageEventSelected"; ////Page.Trace.Write("Finished not Postback"); } else { if (Session["SetVenue"] != null) { char[] delim = { ';' }; VenueDiv.InnerHtml = Session["SetVenue"].ToString().Split(delim)[1]; } //if (Session["SetTime"] != null) //{ // TimeFrameDiv.InnerHtml = Session["SetTime"].ToString(); //} } if (!IsPostBack) { ////Page.Trace.Write("Started not postback 2"); Page.Trace.Write("Before State Country Load"); CountryDropDown.SelectedValue = "223"; DataSet ds3 = dat.GetData("SELECT * FROM State WHERE country_id=" + CountryDropDown.SelectedValue); StateDropDownPanel.Visible = true; StateTextBoxPanel.Visible = false; StateDropDown.DataSource = ds3; StateDropDown.DataTextField = "state_2_code"; StateDropDown.DataValueField = "state_id"; StateDropDown.DataBind(); StateDropDown.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("State", "-1")); StateDropDownPanel.Visible = true; StateTextBoxPanel.Visible = false; Page.Trace.Write("After State Country Load"); DataSet ds4 = dat.GetData("SELECT CASE WHEN SUBSTRING(Name, 1, 4) = 'The' THEN SUBSTRING(Name, 5, "+ "LEN(Name)-4) ELSE Name END AS Name1, * FROM Venues WHERE Country=" + CountryDropDown.SelectedValue + " AND State='" + StateDropDown.SelectedItem.Text + "' ORDER BY Name1 ASC"); if (ds4.Tables.Count > 0) if (ds4.Tables[0].Rows.Count > 0) { Session["LocationVenues"] = ds4; fillVenues(ds4); } Page.Trace.Write("After Venues Load"); ////Page.Trace.Write("Started Try"); try { if (Session["User"] != null) { ////Page.Trace.Write("Location"); Page.Trace.Write("Before Location Load"); DataView dvUser = dat.GetDataDV("SELECT CatCity, CatState, CatCountry, CatZip, Radius FROM UserPreferences WHERE UserID=" + Session["User"].ToString()); CountryDropDown.SelectedValue = dvUser[0]["CatCountry"].ToString(); ChangeState(CountryDropDown, new EventArgs()); if (StateTextBoxPanel.Visible) StateTextBox.Text = dvUser[0]["CatState"].ToString(); else StateDropDown.Items.FindItemByText(dvUser[0]["CatState"].ToString()).Selected = true; CityTextBox.Text = dvUser[0]["CatCity"].ToString(); StateChanged(StateDropDown, new EventArgs()); Page.Trace.Write("After Location Load"); ////Page.Trace.Write("before zip"); if (dvUser[0]["CatZip"] != null) { if (dvUser[0]["CatZip"].ToString().Trim() != "") { char[] delim = { ';' }; string[] tokens = dvUser[0]["CatZip"].ToString().Split(delim); if (tokens.Length > 1) { ZipTextBox.Text = tokens[1].Trim(); if (dvUser[0]["Radius"] != null) { if (dvUser[0]["Radius"].ToString().Trim() != "") { RadiusDropDown.SelectedValue = dvUser[0]["Radius"].ToString(); } } } } } ////Page.Trace.Write("after zip"); Page.Trace.Write("AFter zip"); } else { Page.Trace.Write("before get ip"); if (Session["LocCountry"] == null || Session["LocState"] == null || Session["LocCity"] == null) { dat.IP2Location(); } Page.Trace.Write("after get ip"); CountryDropDown.SelectedValue = Session["LocCountry"].ToString().Trim(); ChangeState(CountryDropDown, new EventArgs()); if (StateTextBoxPanel.Visible) StateTextBox.Text = Session["LocState"].ToString().Trim(); else StateDropDown.Items.FindItemByText(Session["LocState"].ToString().Trim()).Selected = true; CityTextBox.Text = Session["LocCity"].ToString(); StateChanged(StateDropDown, new EventArgs()); Page.Trace.Write("after"); } Page.Trace.Write("before search"); Search(); Page.Trace.Write("after search"); } catch (Exception ex) { ErrorLabel.Text = ex.ToString(); } ////Page.Trace.Write("Ended try"); } else { if (Session["LocationVenues"] != null) fillVenues((DataSet)Session["LocationVenues"]); } Page.Trace.Write("Ended Page Load"); }
protected DataSet GetEvents(TimeFrame theEnum) { string message = ""; try { DateTime StartDate = new DateTime(); DateTime EndDate = new DateTime(); HttpCookie cookie = Request.Cookies["BrowserDate"]; if (cookie == null) { cookie = new HttpCookie("BrowserDate"); cookie.Value = DateTime.Now.Date.ToString(); cookie.Expires = DateTime.Now.AddDays(22); Response.Cookies.Add(cookie); } int totalCount = 20; bool fillUserData = false; string timeframe = ""; DateTime isn = DateTime.Now; if (!DateTime.TryParse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"), out isn)) isn = DateTime.Now; DateTime itBeNow = isn; Data dat = new Data(isn); #region Get Events int subtraction = 0; string startDate = ""; string endDate = ""; string highestPrice = ""; string highestText = ""; if (theEnum == TimeFrame.HighestPrice) { highestText = " and <span class='HomeTitle'>H</span>ighest <span class='HomeTitle'>P</span>rice of $" + HighestPriceInput.Value.Replace("$", ""); highestPrice = " AND (E.MinPrice <= " + HighestPriceInput.Value + " OR E.MinPrice is Null) "; theEnum = (TimeFrame)Session["HomeTimeFrame"]; } #region TimeFrame switch (theEnum) { case TimeFrame.Beginning: timeframe = " AND EO.DateTimeStart > '" + isn.Date + "' "; TimeFrameLabel.Text = "<span class='HomeTitle'>F</span>eatured <span class='HomeTitle'>E</span>vents "+ highestText; Session["HomeTimeFrame"] = TimeFrame.Beginning; break; case TimeFrame.Today: timeframe = " AND CONVERT(NVARCHAR,Month(EO.DateTimeStart)) + '/' + CONVERT(NVARCHAR, DAY(EO.DateTimeStart)) + " + "'/' + CONVERT(NVARCHAR, YEAR(EO.DateTimeStart)) = '" + itBeNow.Month.ToString() + "/" + itBeNow.Day.ToString() + "/" + itBeNow.Year.ToString() + "' AND EO.DateTimeStart > '" + isn.Date + "' "; TimeFrameLabel.Text = "<span class='HomeTitle'>F</span>eatured <span class='HomeTitle'>E</span>vents <span class='HomeTitle'>T</span>oday" + highestText; Session["HomeTimeFrame"] = TimeFrame.Today; break; case TimeFrame.Tomorrow: itBeNow = itBeNow.AddDays(1.00); timeframe = " AND CONVERT(NVARCHAR,Month(EO.DateTimeStart)) + '/' + CONVERT(NVARCHAR, DAY(EO.DateTimeStart)) + " + "'/' + CONVERT(NVARCHAR, YEAR(EO.DateTimeStart)) = '" + itBeNow.Month.ToString() + "/" + itBeNow.Day.ToString() + "/" + itBeNow.Year.ToString() + "' AND EO.DateTimeStart > '" + isn.Date + "' "; TimeFrameLabel.Text = "<span class='HomeTitle'>F</span>eatured <span class='HomeTitle'>E</span>vents <span class='HomeTitle'>T</span>omorrow" + highestText; Session["HomeTimeFrame"] = TimeFrame.Tomorrow; break; case TimeFrame.ThisWeek: switch (itBeNow.DayOfWeek) { case DayOfWeek.Friday: subtraction = 5; break; case DayOfWeek.Monday: subtraction = 1; break; case DayOfWeek.Saturday: subtraction = 6; break; case DayOfWeek.Sunday: subtraction = 0; break; case DayOfWeek.Thursday: subtraction = 4; break; case DayOfWeek.Tuesday: subtraction = 2; break; case DayOfWeek.Wednesday: subtraction = 3; break; default: break; } startDate = itBeNow.Subtract(TimeSpan.FromDays(subtraction)).ToShortDateString(); endDate = itBeNow.AddDays(7.00 - subtraction).ToShortDateString(); timeframe = " AND (CONVERT(NVARCHAR,MONTH(EO.DateTimeStart)) + '/' + CONVERT(NVARCHAR,DAY(EO.DateTimeStart)) + '/' + CONVERT(NVARCHAR,YEAR(EO.DateTimeStart)) " + " >= CONVERT(DATETIME, '" + startDate + "') AND CONVERT(NVARCHAR,MONTH(EO.DateTimeStart)) + '/' + " + "CONVERT(NVARCHAR,DAY(EO.DateTimeStart)) + '/' + CONVERT(NVARCHAR,YEAR(EO.DateTimeStart)) <= CONVERT(DATETIME, '" + endDate + "')OR " + "(CONVERT(NVARCHAR,MONTH(EO.DateTimeStart)) + '/' + " + "CONVERT(NVARCHAR,DAY(EO.DateTimeStart)) + '/' + CONVERT(NVARCHAR,YEAR(EO.DateTimeStart)) < " + "CONVERT(DATETIME, '" + startDate + "') AND CONVERT(NVARCHAR,MONTH(EO.DateTimeEnd)) + '/' + " + "CONVERT(NVARCHAR,DAY(EO.DateTimeEnd)) + '/' + CONVERT(NVARCHAR,YEAR(EO.DateTimeEnd)) > CONVERT(DATETIME, '" + startDate + "'))) AND EO.DateTimeStart > '" + isn.Date + "' "; TimeFrameLabel.Text = "<span class='HomeTitle'>F</span>eatured <span class='HomeTitle'>E</span>vents <span class='HomeTitle'>T</span>his <span class='HomeTitle'>W</span>eek" + highestText; Session["HomeTimeFrame"] = TimeFrame.ThisWeek; break; case TimeFrame.ThisWeekend: switch (itBeNow.DayOfWeek) { case DayOfWeek.Friday: subtraction = 0; break; case DayOfWeek.Monday: subtraction = -4; break; case DayOfWeek.Saturday: subtraction = 1; break; case DayOfWeek.Sunday: subtraction = 2; break; case DayOfWeek.Thursday: subtraction = -1; break; case DayOfWeek.Tuesday: subtraction = -3; break; case DayOfWeek.Wednesday: subtraction = -2; break; default: break; } startDate = itBeNow.Subtract(TimeSpan.FromDays(subtraction)).ToShortDateString(); endDate = itBeNow.AddDays(2 - subtraction).ToShortDateString(); timeframe = " AND (CONVERT(NVARCHAR,MONTH(EO.DateTimeStart)) + '/' + CONVERT(NVARCHAR,DAY(EO.DateTimeStart)) " + "+ '/' + CONVERT(NVARCHAR,YEAR(EO.DateTimeStart)) " + " >= CONVERT(DATETIME, '" + startDate + "') AND CONVERT(NVARCHAR,MONTH(EO.DateTimeStart)) + " + "'/' + CONVERT(NVARCHAR,DAY(EO.DateTimeStart)) + '/' + CONVERT(NVARCHAR,YEAR(EO.DateTimeStart)) " + "<= CONVERT(DATETIME, '" + endDate + "') OR " + "(CONVERT(NVARCHAR,MONTH(EO.DateTimeStart)) + '/' + " + "CONVERT(NVARCHAR,DAY(EO.DateTimeStart)) + '/' + CONVERT(NVARCHAR,YEAR(EO.DateTimeStart)) < " + "CONVERT(DATETIME, '" + startDate + "') AND CONVERT(NVARCHAR,MONTH(EO.DateTimeEnd)) + '/' + " + "CONVERT(NVARCHAR,DAY(EO.DateTimeEnd)) + '/' + CONVERT(NVARCHAR,YEAR(EO.DateTimeEnd)) > CONVERT(DATETIME, '" + startDate + "'))) AND EO.DateTimeStart > '" + isn.Date + "' "; TimeFrameLabel.Text = "<span class='HomeTitle'>F</span>eatured <span class='HomeTitle'>E</span>vents <span class='HomeTitle'>T</span>his <span class='HomeTitle'>W</span>eekend" + highestText; Session["HomeTimeFrame"] = TimeFrame.ThisWeekend; break; case TimeFrame.ThisMonth: timeframe = " AND (MONTH(EO.DateTimeStart) = '" + itBeNow.Month + "' OR (EO.DateTimeStart < CONVERT(DATETIME,'" + itBeNow.Month + "/"+DateTime.DaysInMonth(itBeNow.Year, itBeNow.Month).ToString()+"/" + itBeNow.Year + " 23:59:59') AND EO.DateTimeEnd > CONVERT(DATETIME,'" + itBeNow.Month + "/1/" + itBeNow.Year + " 00:00:00'))) AND EO.DateTimeStart > '" + isn.Date + "' "; TimeFrameLabel.Text = "<span class='HomeTitle'>F</span>eatured <span class='HomeTitle'>E</span>vents <span class='HomeTitle'>T</span>his <span class='HomeTitle'>M</span>onth" + highestText; Session["HomeTimeFrame"] = TimeFrame.ThisMonth; break; case TimeFrame.NextDays: StartDate = itBeNow; decimal theDub = 0.00M; if (decimal.TryParse(NextDaysInput.Value, out theDub)) { EndDate = itBeNow.AddDays(int.Parse(NextDaysInput.Value)); timeframe = " AND (CONVERT(NVARCHAR,MONTH(EO.DateTimeStart)) + '/' + CONVERT(NVARCHAR,DAY(EO.DateTimeStart)) + '/' + CONVERT(NVARCHAR,YEAR(EO.DateTimeStart)) " + " <= CONVERT(DATETIME, '" + EndDate.Month.ToString() + "/" + EndDate.Day.ToString() + "/" + EndDate.Year.ToString() + " 23:59:59') " + " AND CONVERT(NVARCHAR,MONTH(EO.DateTimeEnd)) + '/' + CONVERT(NVARCHAR,DAY(EO.DateTimeEnd)) + '/' + CONVERT(NVARCHAR,YEAR(EO.DateTimeEnd)) >= " + " CONVERT(DATETIME, '" + StartDate.Month.ToString() + "/" + StartDate.Day.ToString() + "/" + StartDate.Year.ToString() + " 00:00:00')) AND EO.DateTimeStart > '" + isn.Date + "' "; TimeFrameLabel.Text = "<span class='HomeTitle'>F</span>eatured <span class='HomeTitle'>E</span>vents <span class='HomeTitle'>N</span>ext " + NextDaysInput.Value + " <span class='HomeTitle'>D</span>ays" + highestText; Session["HomeTimeFrame"] = TimeFrame.NextDays; } else { TimeFrameLabel.Text = "<span class='HomeTitle'>F</span>eatured <span class='HomeTitle'>E</span>vents "+highestText; timeframe = " AND EO.DateTimeStart > '" + itBeNow.Date.ToString() + "' "; } break; default: break; } #endregion string country = ""; string state = ""; string city = ""; string countryID = ""; string stateID = ""; string cityID = ""; try { if (Session["User"] != null) { if (Session["LocCountry"] == null || Session["LocState"] == null || Session["LocCity"] == null) { DataSet ds1 = dat.GetData("SELECT * FROM Users U, UserPreferences UP WHERE U.User_ID=" + Session["User"].ToString() + " AND U.User_ID=UP.UserID "); country = ds1.Tables[0].Rows[0]["CatCountry"].ToString(); countryID = country; state = ds1.Tables[0].Rows[0]["CatState"].ToString(); city = ds1.Tables[0].Rows[0]["CatCity"].ToString(); stateID = state; cityID = city; } else { country = Session["LocCountry"].ToString().Trim(); state = Session["LocState"].ToString().Trim(); city = Session["LocCity"].ToString(); stateID = state; cityID = city; } fillUserData = true; } else { if (Session["LocCountry"] == null || Session["LocState"] == null || Session["LocCity"] == null) { dat.IP2Location(); } country = Session["LocCountry"].ToString().Trim(); state = Session["LocState"].ToString().Trim(); city = Session["LocCity"].ToString(); stateID = state; cityID = city; } } catch (Exception ex) { ErrorLabel.Text += ex.ToString(); } DataSet ds; string realCountry = country; string tripCountry = ""; if (country != "") { country = " AND E.Country = " + realCountry; tripCountry = " AND TDir.Country = " + realCountry; } string zips = ""; if (realCountry == "223") { GetAllZipsInProximity(out zips); char[] delim = { ';' }; string[] zipArray = zips.Split(delim, StringSplitOptions.RemoveEmptyEntries); zips = ""; foreach (string token in zipArray) { if (zips == "") zips = " AND ("; else zips += " OR "; zips += " Zip = " + token; } zips += ")"; //TimeFrameLabel.Text = "SELECT DISTINCT TOP " + totalCount.ToString() + " " + //"E.Header, EO.DateTimeStart AS StartTime, EO.DateTimeEnd AS EndTime, E.Featured, E.DaysFeatured, E.Content, E.PostedOn, EO.EventID, 'E' AS Type FROM Events E, Event_Occurance EO WHERE " + //"E.LIVE='True' AND E.ID=EO.EventID " + country + zips + timeframe + highestPrice + //" ORDER BY E.Featured, E.PostedOn "; ds = dat.GetData("SELECT DISTINCT TOP " + totalCount.ToString() + " " + "E.Header, EO.DateTimeStart AS StartTime, EO.DateTimeEnd AS EndTime, E.Featured, E.DaysFeatured, E.Content, E.PostedOn, EO.EventID, 'E' AS Type FROM Events E, Event_Occurance EO WHERE " + "E.LIVE='True' AND E.ID=EO.EventID " + country + zips + timeframe + highestPrice + " ORDER BY E.Featured, E.PostedOn "); } else { int c = 0; if (state != "") { c++; } if (city != "") { c++; } SqlDbType[] types = new SqlDbType[c]; object[] data = new object[c]; if (state != "") { types[0] = SqlDbType.NVarChar; data[0] = state; state = " AND E.State=@p0 "; if (city != "") { types[1] = SqlDbType.NVarChar; data[1] = city; city = " AND E.City=@p1 "; } } else { if (city != "") { types[0] = SqlDbType.NVarChar; data[0] = city; city = " AND E.City=@p0 "; } } ds = dat.GetDataWithParemeters("SELECT DISTINCT TOP " + totalCount.ToString() + " " + "E.Header, E.Featured, EO.DateTimeStart AS StartTime, EO.DateTimeEnd AS EndTime, E.DaysFeatured, E.PostedOn, E.Content, EO.EventID, 'E' AS Type FROM Events E, Event_Occurance EO WHERE " + "E.LIVE='True' AND E.ID=EO.EventID " + country + state + city + timeframe + highestPrice + " ORDER BY E.Featured, E.PostedOn, EO.DateTimeStart", types, data); } //totalCount = totalCount - ds.Tables[0].Rows.Count; #endregion if (totalCount > 0) { #region Get Trips string theDate = ""; subtraction = 0; startDate = ""; endDate = ""; string dayToday = itBeNow.Day.ToString(); string monthTody = itBeNow.Month.ToString(); string yearToday = itBeNow.Year.ToString(); string dateToday = monthTody + "/" + dayToday + "/" + yearToday; string dayOfWeek = dat.getDayOfWeek(itBeNow.DayOfWeek); string timeNow = itBeNow.TimeOfDay.ToString(); string dayStart = ""; string dayEnd = ""; string startMonth = ""; string endMonth = ""; string startYear = ""; string endYear = ""; string dateStart = ""; string dateEnd = ""; string startDayOfWeek = ""; string endDayOfWeek = ""; string resultsStr = ""; string date = ""; string highestP = ""; if (theEnum == TimeFrame.HighestPrice) { highestP = " AND ((E.MaxPrice <= " + HighestPriceInput.Value.Replace("$", "") + ") OR (E.MaxPrice >= " + HighestPriceInput.Value.Replace("$", "") + " AND E.MinPrice <= " + HighestPriceInput.Value.Replace("$", "") + ")" + "OR (E.MaxPrice IS NULL AND E.MinPrice IS NULL)) "; } switch (theEnum) { case TimeFrame.Beginning: StartDate = itBeNow; EndDate = itBeNow; date = " AND (CONVERT(DATETIME,CONVERT(NVARCHAR,TM.MonthStart)+'/'+CONVERT(NVARCHAR,TM.DayStart)" + "+'/'+'" + EndDate.Year.ToString() + "') <= CONVERT(DATETIME, '" + EndDate.Month.ToString() + "/" + EndDate.Day.ToString() + "/" + EndDate.Year.ToString() + " 00:00:00') "+ " AND CONVERT(DATETIME,CONVERT(NVARCHAR,TM.MonthEnd)+'/'+CONVERT(NVARCHAR,TM.DayEnd)" + "+'/'+'" + EndDate.Year.ToString() + "') >= CONVERT(DATETIME, '" + EndDate.Month.ToString() + "/" + EndDate.Day.ToString() + "/" + EndDate.Year.ToString() + " 00:00:00') ) "; break; case TimeFrame.Today: resultsStr += " Today "; date = " AND (CONVERT(DATETIME,CONVERT(NVARCHAR,TM.MonthStart)+'/'+CONVERT(NVARCHAR,TM.DayStart)+'/'+'" + yearToday + "') <= CONVERT(DATETIME, '" + dateToday + "') AND CONVERT(DATETIME,CONVERT(NVARCHAR,TM.MonthEnd) +" + "'/'+CONVERT(NVARCHAR,TM.DayEnd)+'/'+'" + yearToday + "') >= CONVERT(DATETIME, '" + dateToday + "') AND TDS.Days LIKE '%" + dayOfWeek + "%' AND CONVERT(DATETIME, TDS.StartTime) <= CONVERT(DATETIME, '" + timeNow + "') AND CONVERT(DATETIME, TDS.EndTime) >= CONVERT(DATETIME, '" + timeNow + "') )"; break; case TimeFrame.Tomorrow: itBeNow = itBeNow.AddDays(1); dayToday = itBeNow.Day.ToString(); monthTody = itBeNow.Month.ToString(); yearToday = itBeNow.Year.ToString(); dateToday = monthTody + "/" + dayToday + "/" + yearToday; dayOfWeek = dat.getDayOfWeek(itBeNow.DayOfWeek); timeNow = itBeNow.TimeOfDay.ToString(); resultsStr += " Tomorrow "; date = " AND (CONVERT(DATETIME,CONVERT(NVARCHAR,TM.MonthStart)+'/'+CONVERT(NVARCHAR,TM.DayStart)+'/'+'" + yearToday + "') <= CONVERT(DATETIME, '" + dateToday + "') AND CONVERT(DATETIME,CONVERT(NVARCHAR,TM.MonthEnd) +" + "'/'+CONVERT(NVARCHAR,TM.DayEnd)+'/'+'" + yearToday + "') >= CONVERT(DATETIME, '" + dateToday + "')) AND TDS.Days LIKE '%" + dayOfWeek + "%'"; break; case TimeFrame.ThisWeekend: resultsStr += " This Weekend "; switch (DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).DayOfWeek) { case DayOfWeek.Friday: subtraction = 0; break; case DayOfWeek.Monday: subtraction = -4; break; case DayOfWeek.Saturday: subtraction = 1; break; case DayOfWeek.Sunday: subtraction = 2; break; case DayOfWeek.Thursday: subtraction = -1; break; case DayOfWeek.Tuesday: subtraction = -3; break; case DayOfWeek.Wednesday: subtraction = -2; break; default: break; } StartDate = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction)); EndDate = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).AddDays(2 - subtraction); dayStart = StartDate.Day.ToString(); dayEnd = EndDate.Day.ToString(); startMonth = StartDate.Month.ToString(); endMonth = EndDate.Month.ToString(); startYear = StartDate.Year.ToString(); endYear = EndDate.Year.ToString(); dateStart = startMonth + "/" + dayStart + "/" + startYear; dateEnd = endMonth + "/" + dayEnd + "/" + endYear; startDayOfWeek = dat.getDayOfWeek(StartDate.DayOfWeek); endDayOfWeek = dat.getDayOfWeek(EndDate.DayOfWeek); date = " AND (CONVERT(DATETIME,CONVERT(NVARCHAR,TM.MonthStart)+'/'+CONVERT(NVARCHAR,TM.DayStart)+'/'+'" + startYear + "') <= CONVERT(DATETIME, '" + dateStart + "') AND CONVERT(DATETIME,CONVERT(NVARCHAR,TM.MonthEnd) +" + "'/'+CONVERT(NVARCHAR,TM.DayEnd)+'/'+'" + endYear + "') >= CONVERT(DATETIME, '" + dateEnd + "')) AND (TDS.Days LIKE '%5%' OR TDS.Days LIKE '%6%' OR TDS.Days LIKE '%7%')"; break; case TimeFrame.ThisWeek: resultsStr += " This Week "; switch (DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).DayOfWeek) { case DayOfWeek.Friday: subtraction = 5; break; case DayOfWeek.Monday: subtraction = 1; break; case DayOfWeek.Saturday: subtraction = 6; break; case DayOfWeek.Sunday: subtraction = 0; break; case DayOfWeek.Thursday: subtraction = 4; break; case DayOfWeek.Tuesday: subtraction = 2; break; case DayOfWeek.Wednesday: subtraction = 3; break; default: break; } StartDate = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Subtract(TimeSpan.FromDays(subtraction)); EndDate = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).AddDays(7.00 - subtraction); dayStart = StartDate.Day.ToString(); dayEnd = EndDate.Day.ToString(); startMonth = StartDate.Month.ToString(); endMonth = EndDate.Month.ToString(); startYear = StartDate.Year.ToString(); endYear = EndDate.Year.ToString(); dateStart = startMonth + "/" + dayStart + "/" + startYear; dateEnd = endMonth + "/" + dayEnd + "/" + endYear; startDayOfWeek = dat.getDayOfWeek(StartDate.DayOfWeek); endDayOfWeek = dat.getDayOfWeek(EndDate.DayOfWeek); date = " AND (CONVERT(DATETIME,CONVERT(NVARCHAR,TM.MonthStart)+'/'+CONVERT(NVARCHAR,TM.DayStart)+'/'+'" + startYear + "') <= CONVERT(DATETIME, '" + dateStart + "') AND CONVERT(DATETIME,CONVERT(NVARCHAR,TM.MonthEnd) +" + "'/'+CONVERT(NVARCHAR,TM.DayEnd)+'/'+'" + endYear + "') >= CONVERT(DATETIME, '" + dateEnd + "')) AND (TDS.Days LIKE '%1%' OR TDS.Days LIKE '%2%' OR TDS.Days LIKE '%3%' OR TDS.Days LIKE '%4%')"; break; case TimeFrame.ThisMonth: resultsStr += " This Month "; dateToday = monthTody + "/" + DateTime.DaysInMonth(int.Parse(yearToday), int.Parse(monthTody)).ToString() + "/" + yearToday; date = " AND (CONVERT(DATETIME,CONVERT(NVARCHAR,TM.MonthStart)+'/'+CONVERT(NVARCHAR,TM.DayStart)+'/'+'" + yearToday + "') <= CONVERT(DATETIME, '" + dateToday + "') AND CONVERT(DATETIME,CONVERT(NVARCHAR,TM.MonthEnd) +" + "'/'+CONVERT(NVARCHAR,TM.DayEnd)+'/" + yearToday + "') >= CONVERT(DATETIME, '" + monthTody + "/1/" + yearToday + "'))"; break; case TimeFrame.NextDays: decimal theDub = 0.00M; if (decimal.TryParse(NextDaysInput.Value, out theDub)) { resultsStr += " Next " + NextDaysInput.Value + " Days "; StartDate = itBeNow; EndDate = itBeNow.AddDays(int.Parse(NextDaysInput.Value)); dayStart = StartDate.Day.ToString(); dayEnd = EndDate.Day.ToString(); startMonth = StartDate.Month.ToString(); endMonth = EndDate.Month.ToString(); startYear = StartDate.Year.ToString(); endYear = EndDate.Year.ToString(); dateStart = startMonth + "/" + dayStart + "/" + startYear; dateEnd = endMonth + "/" + dayEnd + "/" + endYear; startDayOfWeek = dat.getDayOfWeek(StartDate.DayOfWeek); endDayOfWeek = dat.getDayOfWeek(EndDate.DayOfWeek); date = " AND (CONVERT(DATETIME,CONVERT(NVARCHAR,TM.MonthStart)+'/'+CONVERT(NVARCHAR,TM.DayStart)" + "+'/'+'" + endYear + "') <= CONVERT(DATETIME, '" + EndDate.Month.ToString() + "/" + EndDate.Day.ToString() + "/" + EndDate.Year.ToString() + " 23:59:59') AND CONVERT(DATETIME,CONVERT" + "(NVARCHAR,TM.MonthEnd) +" + "'/'+CONVERT(NVARCHAR,TM.DayEnd)+'/'+'" + startYear + "') >= CONVERT(DATETIME, '" + StartDate.Month.ToString() + "/" + StartDate.Day.ToString() + "/" + StartDate.Year.ToString() + " 00:00:00'))"; } else { StartDate = itBeNow; EndDate = itBeNow; date = " AND (CONVERT(DATETIME,CONVERT(NVARCHAR,TM.MonthStart)+'/'+CONVERT(NVARCHAR,TM.DayStart)" + "+'/'+'" + EndDate.Year.ToString() + "') >= CONVERT(DATETIME, '" + EndDate.Month.ToString() + "/" + EndDate.Day.ToString() + "/" + EndDate.Year.ToString() + " 00:00:00')) "; } break; default: break; } string searchStr = "SELECT DISTINCT TOP " + totalCount.ToString() + " E.ID AS EventID, E.DaysFeatured, E.PostedOn, '$'+CONVERT(NVARCHAR,E.MinPrice)+' - $'+" + "CONVERT(NVARCHAR, E.MaxPrice)" + "AS PriceRange, E.Featured, E.MinPrice AS Price, E.Content, E.Means, dbo.GetDuration(E.Duration, 0) AS " + "TimeFrame, dbo.GetDuration(E.Duration, 1) AS Duration, E.Header, " + " E.Featured, E.DaysFeatured, 'T' AS Type, TDS.StartTime, TDS.EndTime FROM TripDirections TDir, Trips E, TripMonths TM, TripDays TDS " + "WHERE TDir.TripID=E.ID AND TM.TripID=TDS.TripID AND TM.TripID=E.ID AND E.Live='True' " + tripCountry + zips + date + highestP + " ORDER BY E.Featured, E.PostedOn"; //TimeFrameLabel.Text += searchStr; DataSet dsTrips = dat.GetData(searchStr); //totalCount = totalCount - dsTrips.Tables[0].Rows.Count; #endregion if (ds.Tables[0].Rows.Count > 0) ds = MergeEvents(ds, dsTrips); else ds = dsTrips; if (totalCount > 0) { #region Get Locale Happenings date = ""; dayOfWeek = dat.getDayOfWeek(itBeNow.DayOfWeek); int dayOfWeekInt = int.Parse(dayOfWeek); switch (theEnum) { case TimeFrame.Today: date = " AND Days LIKE '%" + dayOfWeek + "%'"; break; case TimeFrame.Tomorrow: dayOfWeekInt++; if (dayOfWeekInt > 7) dayOfWeekInt = 1; date = " AND Days LIKE '%" + dayOfWeekInt.ToString() + "%'"; break; case TimeFrame.ThisWeekend: date = " AND (Days LIKE '%5%' OR Days LIKE '%6%' OR Days LIKE '%7%') "; break; case TimeFrame.ThisWeek: date = ""; break; case TimeFrame.ThisMonth: date = ""; break; case TimeFrame.Beginning: date = ""; break; case TimeFrame.NextDays: decimal theDub = 0.00M; if (decimal.TryParse(NextDaysInput.Value, out theDub)) { if (int.Parse(NextDaysInput.Value) >= 7) { date = ""; } else { date += " AND (Days LIKE '%" + dayOfWeekInt.ToString() + "%' "; for (int i = 0; i < int.Parse(NextDaysInput.Value); i++) { date += " OR Days LIKE '%" + (++dayOfWeekInt).ToString() + "%' "; } date += " ) "; } } else { date = " AND Days LIKE '%" + dayOfWeek + "%'"; } break; default: break; } DataSet dsVenues = dat.GetData("SELECT TOP " + totalCount.ToString() + " V.Featured, V.DaysFeatured, V.PostedOn, VE.EventName + ' at '+V.Name AS Header, V.ID AS EventID, " + "V.Content, 'H' AS Type, HourStart AS StartTime, HourEnd AS EndTime FROM Venues V, VenueEvents VE WHERE VE.VenueID=V.ID " + zips + date + " ORDER BY V.Featured, V.PostedOn"); //TimeFrameLabel.Text += "SELECT V.Featured, V.DaysFeatured, V.PostedOn, VE.EventName + ' at '+V.Name AS Header, V.ID AS EventID, " + // "V.Content, 'V' AS Type FROM Venues V, VenueEvents VE WHERE VE.VenueID=V.ID " + // zips + date + " ORDER BY V.Featured, V.PostedOn"; //totalCount = totalCount - dsVenues.Tables[0].Rows.Count; #endregion if (ds.Tables[0].Rows.Count > 0) ds = MergeEvents(ds, dsVenues); else ds = dsVenues; if (totalCount > 0) { #region Get Locales date = ""; dayOfWeek = dat.getDayOfWeek(itBeNow.DayOfWeek); dayOfWeekInt = int.Parse(dayOfWeek); switch (theEnum) { case TimeFrame.Today: date = " AND Days LIKE '%" + dayOfWeek + "%'"; break; case TimeFrame.Tomorrow: dayOfWeekInt++; if (dayOfWeekInt > 7) dayOfWeekInt = 1; date = " AND Days LIKE '%" + dayOfWeekInt.ToString() + "%'"; break; case TimeFrame.ThisWeekend: date = " AND (Days LIKE '%5%' OR Days LIKE '%6%' OR Days LIKE '%7%') "; break; case TimeFrame.ThisWeek: date = ""; break; case TimeFrame.ThisMonth: date = ""; break; case TimeFrame.Beginning: date = ""; break; case TimeFrame.NextDays: decimal theDub = 0.00M; if (decimal.TryParse(NextDaysInput.Value, out theDub)) { resultsStr += " Next " + NextDaysInput.Value + " Days "; if (int.Parse(NextDaysInput.Value) >= 7) { date = ""; } else { date += " AND (Days LIKE '%" + dayOfWeekInt.ToString() + "%' "; for (int i = 0; i < int.Parse(NextDaysInput.Value); i++) { date += " OR Days LIKE '%" + (++dayOfWeekInt).ToString() + "%' "; } date += " ) "; } } else { date = " AND Days LIKE '%" + dayOfWeek + "%'"; } break; default: break; } DataSet dsLocales = dat.GetData("SELECT DISTINCT TOP " + totalCount.ToString() + " V.Featured, HourStart AS StartTime, HourEnd AS EndTime, V.DaysFeatured, V.PostedOn, 'Check Out ' + V.Name AS Header, V.ID AS EventID, " + "V.Content, 'V' AS Type FROM Venues V, VenueHours VE WHERE VE.VenueID=V.ID " + zips + date + " ORDER BY V.Featured, V.PostedOn"); //totalCount = totalCount - dsLocales.Tables[0].Rows.Count; #endregion if (ds.Tables[0].Rows.Count > 0) ds = MergeEvents(ds, dsLocales); else ds = dsLocales; } } } return ds; } catch (Exception ex) { TimeFrameLabel.Text += ex.ToString() + "<br/>" + message; } return new DataSet(); }
protected void Page_Load(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; if (cookie == null) { cookie = new HttpCookie("BrowserDate"); cookie.Value = DateTime.Now.ToString(); cookie.Expires = DateTime.Now.AddDays(22); Response.Cookies.Add(cookie); } DateTime today = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")); Data dat = new Data(today); DataSet ds; if (Request.QueryString["ID"] != null) { string catID = Request.QueryString["ID"].ToString(); string location = ""; //Get the location if (Session["User"] != null) { DataView dvPrefs = dat.GetDataDV("SELECT * FROM UserPreferences WHERE UserID=" + Session["User"].ToString()); location = " AND A.CatState='" + dvPrefs[0]["CatState"].ToString() + "' AND A.CatCity='" + dvPrefs[0]["CatCity"].ToString() + "' AND A.CatCountry=" + dvPrefs[0]["CatCountry"].ToString(); } else { if (Session["LocCountry"] == null || Session["LocState"] == null || Session["LocCity"] == null) { dat.IP2Location(); } string country = Session["LocCountry"].ToString().Trim(); string state = Session["LocState"].ToString().Trim(); string city = Session["LocCity"].ToString(); location = " AND A.CatState='" + state + "' AND A.CatCity='" + city + "' AND A.CatCountry=" + country; } string sqlToday = "CONVERT(DATETIME, '" + today.Month.ToString() + "/" + today.Day.ToString() + "/" + today.Year.ToString() + "')"; string timeline = " AND (A.Featured='False' AND AC.DateTimeEnd >= " + sqlToday + ")"; ds = dat.GetData("SELECT ACM.AdID AS VID, A.Featured, C.ID, A.Header, C.Name AS CategoryName, " + "ACM.tagSize FROM Ad_Category_Mapping ACM, AdCategories C, Ads A, Ad_Calendar AC WHERE " + "ACM.AdID=A.Ad_ID AND AC.AdID=A.Ad_ID AND ACM.CategoryID=C.ID AND A.LIVE = 'True' AND ACM.CategoryID=" + catID + location + timeline); SearchElements.AD_DS = ds; SearchElements.DataBind2(); NumResultsLabel.Text = "(" + ds.Tables[0].Rows.Count + " Records Found)"; HtmlHead head = (HtmlHead)Page.Header; string theLink = ""; if (ds.Tables[0].Rows.Count > 0) { theLink = "http://" + Request.Url.Authority + "/" + dat.MakeNiceName(ds.Tables[0].Rows[0]["CategoryName"].ToString()) + "_Ad_Category"; } else { theLink = "http://" + Request.Url.Authority + "/AdCategorySearch.aspx?ID=" + catID; } HtmlLink lk = new HtmlLink(); lk.Href = theLink; lk.Attributes.Add("rel", "bookmark"); head.Controls.AddAt(0, lk); HtmlMeta hm = new HtmlMeta(); HtmlMeta kw = new HtmlMeta(); HtmlMeta dc = new HtmlMeta(); kw.Name = "keywords"; if (ds.Tables[0].Rows.Count > 0) { kw.Content = ds.Tables[0].Rows[0]["CategoryName"].ToString() + " Ad Category"; } else { kw.Content = "No Ad Category"; } head.Controls.AddAt(0, kw); dc.Name = "description"; if (ds.Tables[0].Rows.Count > 0) { dc.Content = "Results for ad category: " + ds.Tables[0].Rows[0]["CategoryName"].ToString(); } else { dc.Content = "Results for ad category: None"; } head.Controls.AddAt(0, dc); if(ds.Tables.Count > 0) if (ds.Tables[0].Rows.Count > 0) { SearchResultsTitleLabel.Text = "<a href=\"" + theLink + "\" style=\"text-decoration: none; color: white;\" ><h1>Ads in '" + ds.Tables[0].Rows[0]["CategoryName"].ToString() + "' Category</h1></a>"; } else { SearchResultsTitleLabel.Text = "No Ads Found"; } else { SearchResultsTitleLabel.Text = "No Ads Found"; } }else { Response.Redirect("home"); } }
protected void Page_Load(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; if (cookie == null) { cookie = new HttpCookie("BrowserDate"); cookie.Value = DateTime.Now.ToString(); cookie.Expires = DateTime.Now.AddDays(22); Response.Cookies.Add(cookie); } Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); DataSet ds; HtmlHead head = (HtmlHead)Page.Header; if (Request.QueryString["ID"] != null) { string catID = Request.QueryString["ID"].ToString(); string location = ""; //Get the location if (Session["User"] != null) { DataView dvPrefs = dat.GetDataDV("SELECT * FROM UserPreferences WHERE UserID=" + Session["User"].ToString()); location = " AND V.State='" + dvPrefs[0]["CatState"].ToString() + "' AND V.City='" + dvPrefs[0]["CatCity"].ToString() + "'"; } else { if (Session["LocCountry"] == null || Session["LocState"] == null || Session["LocCity"] == null) { dat.IP2Location(); } string country = Session["LocCountry"].ToString().Trim(); string state = Session["LocState"].ToString().Trim(); string city = Session["LocCity"].ToString(); location = " AND V.State='" + state + "' AND V.City='" + city + "' AND V.Country=" + country; } ds = dat.GetData("SELECT V.Name, V.ID AS VID, V.City, V.State, C.ID, C.Name AS " + "CategoryName, VC.tagSize, V.Featured, V.DaysFeatured FROM Venue_Category VC, VenueCategories C, Venues V " + "WHERE V.ID=VC.VENUE_ID AND VC.CATEGORY_ID=C.ID AND VC.CATEGORY_ID=" + catID + location); SearchElements.VENUE_DS = ds; SearchElements.DataBind2(); NumResultsLabel.Text = "(" + ds.Tables[0].Rows.Count + " Records Found)"; DataView dvName = dat.GetDataDV("SELECT * FROM VenueCategories WHERE ID=" + catID); string theLink = "http://" + Request.Url.Authority + "/" + dat.MakeNiceName(dvName[0]["Name"].ToString()) + "_Venue_Category"; HtmlLink lk = new HtmlLink(); lk.Href = theLink; lk.Attributes.Add("rel", "bookmark"); head.Controls.AddAt(0, lk); HtmlMeta hm = new HtmlMeta(); HtmlMeta kw = new HtmlMeta(); HtmlMeta dc = new HtmlMeta(); kw.Name = "keywords"; kw.Content = dvName[0]["Name"].ToString() + " Venue Category"; head.Controls.AddAt(0, kw); dc.Name = "description"; dc.Content = "Results for venue category: " + dvName[0]["Name"].ToString(); head.Controls.AddAt(0, dc); SearchResultsTitleLabel.Text = "<a href=\"" + theLink + "\" style=\"text-decoration: none; color: white;\" ><h1>Venues in '" + dvName[0]["Name"].ToString() + "' Category</h1></a>"; } else { Response.Redirect("home"); } }
protected void Page_Load(object sender, EventArgs e) { MessageLabel.Text = ""; DataSet ds; HttpCookie cookie = Request.Cookies["BrowserDate"]; if (cookie == null) { cookie = new HttpCookie("BrowserDate"); cookie.Value = DateTime.Now.ToString(); cookie.Expires = DateTime.Now.AddDays(22); Response.Cookies.Add(cookie); } DateTime isn = DateTime.Now; if (!DateTime.TryParse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"), out isn)) isn = DateTime.Now; DateTime isNow = isn; Data dat = new Data(isn); HtmlHead head = (HtmlHead)Page.Header; Literal lit = new Literal(); lit.Text = "<script src=\"http://maps.google.com/maps?file=api&v=2&sensor=false&key=ABQIAAAAjjoxQtYNtdn3Tc17U5-jbBR2Kk_H7gXZZZniNQ8L14X1BLzkNhQjgZq1k-Pxm8FxVhUy3rfc6L9O4g\" type=\"text/javascript\"></script>"; head.Controls.Add(lit); #region Take Care of Buttons SearchButton.BUTTON_TEXT += "<img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/search.png\"/>"; SearchButton.SERVER_CLICK += SearchButton_Click; //TodayButton.BUTTON_TEXT = "<img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/TodayText.png\"/>"; //TomorrowButton.BUTTON_TEXT = "<img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/TomorrowText.png\"/>"; //ThisWeekButton.BUTTON_TEXT = "<img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/ThisWeekText.png\"/>"; //ThisWeekendButton.BUTTON_TEXT = "<img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/ThisWeekendText.png\"/>"; //ThisMonthButton.BUTTON_TEXT = "<img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/ThisMonth.png\"/>"; //TodayButton.SERVER_CLICK += SetToday; //TomorrowButton.SERVER_CLICK += SetTomorrow; //ThisWeekButton.SERVER_CLICK += SetThisWeek; //ThisWeekendButton.SERVER_CLICK += SetThisWeekend; //ThisMonthButton.SERVER_CLICK += SetThisMonth; FilterButton.SERVER_CLICK += FilterResults; SmallButton1.BUTTON_TEXT += "<img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/search.png\"/>"; SmallButton1.SERVER_CLICK += SearchButton_Click; SmallButton2.SERVER_CLICK += SearchButton_Click; SmallButton2.BUTTON_TEXT += "<img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/search.png\"/>"; #endregion if (!IsPostBack) { HttpCookie timeCookie = Request.Cookies["SetTime"]; if (timeCookie != null) { timeCookie = new HttpCookie("BrowserDate"); timeCookie.Value = "All%20Future%20Events"; Response.Cookies.Add(timeCookie); TimeFrameDiv.InnerText = "All Future Trips"; } Session["HighestPrice"] = null; Session.Remove("HighestPrice"); Session["SearchDS"] = null; Session.Remove("SearchDS"); NumsLabel.Text = ""; NoResultsPanel.Visible = true; MapPanel.Visible = false; TopLiteral.Text = "<script type=\"text/javascript\">function initialize1(){map = null;}</script>"; BottomScriptLiteral.Text = ""; ScriptLiteral.Text = ""; HtmlLink lk = new HtmlLink(); lk.Attributes.Add("rel", "canonical"); lk.Href = "http://hippohappenings.com/trip-search"; head.Controls.AddAt(0, lk); //Create keyword and description meta tags HtmlMeta hm = new HtmlMeta(); HtmlMeta kw = new HtmlMeta(); kw.Name = "keywords"; kw.Content = "local trips sights sightseeing landmarks adventures monuments"; head.Controls.AddAt(0, kw); hm.Name = "Description"; hm.Content = "Find local trips and adventures posted by your peers and experience more out of your city."; head.Controls.AddAt(0, hm); lk = new HtmlLink(); lk.Href = "http://" + Request.Url.Authority + "/trip-search"; lk.Attributes.Add("rel", "bookmark"); head.Controls.AddAt(0, lk); EventTitle.Text = "<a style=\"text-decoration: none;\" href=\"" + lk.Href + "\"><h1>Search Adventures</h1></a>"; //Button button = (Button)dat.FindControlRecursive(this, "EventLink"); //button.CssClass = "NavBarImageEventSelected"; } if (!IsPostBack) { CountryDropDown.SelectedValue = "223"; DataSet ds3 = dat.GetData("SELECT * FROM State WHERE country_id=" + CountryDropDown.SelectedValue); StateDropDownPanel.Visible = true; StateTextBoxPanel.Visible = false; StateDropDown.DataSource = ds3; StateDropDown.DataTextField = "state_2_code"; StateDropDown.DataValueField = "state_id"; StateDropDown.DataBind(); StateDropDown.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("State", "-1")); StateDropDownPanel.Visible = true; StateTextBoxPanel.Visible = false; try { if (Session["User"] != null) { DataView dvUser = dat.GetDataDV("SELECT CatCity, CatState, CatCountry, CatZip, Radius FROM UserPreferences WHERE UserID=" + Session["User"].ToString()); CountryDropDown.SelectedValue = dvUser[0]["CatCountry"].ToString(); ChangeState(CountryDropDown, new EventArgs()); if (StateTextBoxPanel.Visible) StateTextBox.Text = dvUser[0]["CatState"].ToString(); else StateDropDown.Items.FindItemByText(dvUser[0]["CatState"].ToString()).Selected = true; CityTextBox.Text = dvUser[0]["CatCity"].ToString(); if (dvUser[0]["CatZip"] != null) { if (dvUser[0]["CatZip"].ToString().Trim() != "") { char[] delim = { ';' }; string[] tokens = dvUser[0]["CatZip"].ToString().Split(delim); if (tokens.Length > 1) { ZipTextBox.Text = tokens[1].Trim(); if (dvUser[0]["Radius"] != null) { if (dvUser[0]["Radius"].ToString().Trim() != "") { RadiusDropDown.SelectedValue = dvUser[0]["Radius"].ToString(); } } } } } } else { if (Session["LocCountry"] == null || Session["LocState"] == null || Session["LocCity"] == null) { dat.IP2Location(); } CountryDropDown.SelectedValue = Session["LocCountry"].ToString().Trim(); ChangeState(CountryDropDown, new EventArgs()); if (StateTextBoxPanel.Visible) StateTextBox.Text = Session["LocState"].ToString().Trim(); else StateDropDown.Items.FindItemByText(Session["LocState"].ToString().Trim()).Selected = true; CityTextBox.Text = Session["LocCity"].ToString(); } Search(); } catch (Exception ex) { ErrorLabel.Text = ex.ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; if (cookie == null) { cookie = new HttpCookie("BrowserDate"); cookie.Value = DateTime.Now.Date.ToString(); cookie.Expires = DateTime.Now.AddDays(22); Response.Cookies.Add(cookie); } bool fillUserData = false; DateTime isn = DateTime.Now; if (!DateTime.TryParse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"), out isn)) isn = DateTime.Now; DateTime isNow = isn; Data dat = new Data(isn); if (Session["LocCountry"] == null || Session["LocState"] == null || Session["LocCity"] == null) dat.IP2Location(); DoAds(); HtmlControl body = (HtmlControl)dat.FindControlRecursive(this.Page, "bodytag"); //body.Attributes["onload"] = "\r\nif\r\n(\r\ntypeof(window.myFunction) == 'function')\r\n{\r\nStartRotator2();}" + body.Attributes["onload"]; body.Attributes["onload"] = "StartRotator2();" + body.Attributes["onload"]; }
protected void Page_Load(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; if (cookie == null) { cookie = new HttpCookie("BrowserDate"); cookie.Value = DateTime.Now.ToString(); cookie.Expires = DateTime.Now.AddDays(22); Response.Cookies.Add(cookie); } DateTime today = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")); Data dat = new Data(today); DataSet ds; if (Request.QueryString["ID"] != null) { string catID = Request.QueryString["ID"].ToString(); string location = ""; //Get the location if (Session["User"] != null) { DataView dvPrefs = dat.GetDataDV("SELECT * FROM UserPreferences WHERE UserID=" + Session["User"].ToString()); location = " AND TD.State='" + dvPrefs[0]["CatState"].ToString() + "' AND TD.City='" + dvPrefs[0]["CatCity"].ToString() + "' AND TD.Country=" + dvPrefs[0]["CatCountry"].ToString(); } else { if (Session["LocCountry"] == null || Session["LocState"] == null || Session["LocCity"] == null) { dat.IP2Location(); } string country = Session["LocCountry"].ToString().Trim(); string state = Session["LocState"].ToString().Trim(); string city = Session["LocCity"].ToString(); location = " AND TD.State='" + state + "' AND TD.City='" + city + "' AND TD.Country=" + country; } string command = "SELECT DISTINCT E.ID AS EID, '$'+CONVERT(NVARCHAR,E.MinPrice)+' - $'+CONVERT(NVARCHAR, E.MaxPrice)" + "AS PriceRange, E.MinPrice AS Price, E.Means, dbo.GetDuration(E.Duration, 0) AS " + "TimeFrame, dbo.GetDuration(E.Duration, 1) AS Duration, E.Header, " + " E.Featured, E.DaysFeatured " + "FROM Trip_Category ECM, Trips E, TripDirections TD, TripCategories C " + "WHERE C.ID=ECM.CategoryID AND TD.TripID=E.ID AND ECM.TripID=E.ID AND " + "ECM.CategoryID=" + catID + location; ds = dat.GetData(command); SearchElements.EVENTS_DS = ds; SearchElements.DataBind2(); NumResultsLabel.Text = "(" + ds.Tables[0].Rows.Count + " Records Found)"; DataView dvName = dat.GetDataDV("SELECT * FROM TripCategories WHERE ID=" + catID); HtmlHead head = (HtmlHead)Page.Header; string theLink = "http://" + Request.Url.Authority + "/" + dat.MakeNiceName(dvName[0]["Name"].ToString()) + "_Trip_Category"; HtmlLink lk = new HtmlLink(); lk.Href = theLink; lk.Attributes.Add("rel", "bookmark"); head.Controls.AddAt(0, lk); HtmlMeta hm = new HtmlMeta(); HtmlMeta kw = new HtmlMeta(); HtmlMeta dc = new HtmlMeta(); kw.Name = "keywords"; kw.Content = dvName[0]["Name"].ToString() + " trip Category"; head.Controls.AddAt(0, kw); dc.Name = "description"; dc.Content = "Results for trip category: " + dvName[0]["Name"].ToString(); head.Controls.AddAt(0, dc); SearchResultsTitleLabel.Text = "<a href=\"" + theLink + "\" style=\"text-decoration: none;\" ><h1>Trips in '" + dvName[0]["Name"].ToString() + "' Category</h1></a>"; } else { Response.Redirect("home"); } }
protected void Page_Load(object sender, EventArgs e) { Session["Searching"] = "Ads"; MessageLabel.Text = ""; DataSet ds; HttpCookie cookie = Request.Cookies["BrowserDate"]; if (cookie == null) { cookie = new HttpCookie("BrowserDate"); cookie.Value = DateTime.Now.ToString(); cookie.Expires = DateTime.Now.AddDays(22); Response.Cookies.Add(cookie); } DateTime isn = DateTime.Now; if (!DateTime.TryParse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"), out isn)) isn = DateTime.Now; DateTime isNow = isn; Data dat = new Data(isn); HtmlHead head = (HtmlHead)Page.Header; #region Take Care of Buttons SearchButton.BUTTON_TEXT += "<img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/search.png\"/>"; SearchButton.SERVER_CLICK += SearchButton_Click; FilterButton.SERVER_CLICK += FilterResults; SmallButton1.BUTTON_TEXT += "<img style=\"border: 0; padding-top: 3px;\" src=\"NewImages/search.png\"/>"; SmallButton1.SERVER_CLICK += SearchButton_Click; SaveSearchButton.SERVER_CLICK += SaveSearch; #endregion if (!IsPostBack) { Session["SearchDS"] = null; Session.Remove("SearchDS"); NumsLabel.Text = ""; NoResultsPanel.Visible = true; TopLiteral.Text = ""; BottomScriptLiteral.Text = ""; ScriptLiteral.Text = ""; HtmlLink lk = new HtmlLink(); lk.Attributes.Add("rel", "canonical"); lk.Href = "http://hippohappenings.com/ad-search"; head.Controls.AddAt(0, lk); //Create keyword and description meta tags HtmlMeta hm = new HtmlMeta(); HtmlMeta kw = new HtmlMeta(); kw.Name = "keywords"; kw.Content = "local bulletin ad classified"; head.Controls.AddAt(0, kw); hm.Name = "Description"; hm.Content = "Find local bulletins, ads and classifieds."; head.Controls.AddAt(0, hm); lk = new HtmlLink(); lk.Href = "http://" + Request.Url.Authority + "/ad-search"; lk.Attributes.Add("rel", "bookmark"); head.Controls.AddAt(0, lk); EventTitle.Text = "<a style=\"text-decoration: none;\" href=\"" + lk.Href + "\"><h1>Search Bulletins</h1></a>"; //Button button = (Button)dat.FindControlRecursive(this, "EventLink"); //button.CssClass = "NavBarImageEventSelected"; } Session["s"] = "asfsd"; if (!IsPostBack) { Session["SavedClicked"] = null; Session.Remove("SavedClicked"); } Session["RedirectTo"] = "ad-search"; if (!IsPostBack) { CountryDropDown.SelectedValue = "223"; DataSet ds3 = dat.GetData("SELECT * FROM State WHERE country_id=" + CountryDropDown.SelectedValue); StateDropDownPanel.Visible = true; StateTextBoxPanel.Visible = false; StateDropDown.DataSource = ds3; StateDropDown.DataTextField = "state_2_code"; StateDropDown.DataValueField = "state_id"; StateDropDown.DataBind(); StateDropDownPanel.Visible = true; StateTextBoxPanel.Visible = false; ChangeCity(StateDropDown, new EventArgs()); try { if (Session["User"] != null) { DataView dvUser = dat.GetDataDV("SELECT CatCity, CatState, CatCountry, CatZip, MajorCity FROM UserPreferences WHERE UserID=" + Session["User"].ToString()); CountryDropDown.ClearSelection(); CountryDropDown.SelectedValue = dvUser[0]["CatCountry"].ToString(); ChangeState(CountryDropDown, new EventArgs()); if (StateTextBoxPanel.Visible) StateTextBox.Text = dvUser[0]["CatState"].ToString(); else { StateDropDown.ClearSelection(); StateDropDown.Items.FindItemByText(dvUser[0]["CatState"].ToString()).Selected = true; ChangeCity(StateDropDown, new EventArgs()); } if (dvUser[0]["CatCountry"].ToString() == "223") { if (dvUser[0]["CatCity"] != null) { MajorCityDrop.ClearSelection(); MajorCityDrop.Items.FindByValue(dvUser[0]["MajorCity"].ToString()).Selected = true; } } else { if (dvUser[0]["CatCity"] != null) { CityTextBox.Text = dvUser[0]["CatCity"].ToString(); } } //if (dvUser[0]["CatZip"] != null) //{ // if (dvUser[0]["CatZip"].ToString().Trim() != "") // { // char[] delim = { ';' }; // string[] tokens = dvUser[0]["CatZip"].ToString().Split(delim); // if (tokens.Length > 1) // { // ZipTextBox.Text = tokens[1].Trim(); // if (dvUser[0]["Radius"] != null) // { // if (dvUser[0]["Radius"].ToString().Trim() != "") // { // RadiusDropDown.SelectedValue = dvUser[0]["Radius"].ToString(); // } // } // } // } //} } else { if (Session["LocCountry"] == null || Session["LocState"] == null || Session["LocCity"] == null) { dat.IP2Location(); } CountryDropDown.SelectedValue = Session["LocCountry"].ToString().Trim(); ChangeState(CountryDropDown, new EventArgs()); if (StateTextBoxPanel.Visible) StateTextBox.Text = Session["LocState"].ToString().Trim(); else { StateDropDown.ClearSelection(); StateDropDown.Items.FindItemByText(Session["LocState"].ToString().Trim()).Selected = true; } ChangeCity(StateDropDown, new EventArgs()); } } catch (Exception ex) { ErrorLabel.Text = ex.ToString(); } } try { if (!IsPostBack) { if (Request.QueryString["search"] != null) { FillSavedSearch(); } else { Search(); } } } catch (Exception ex) { ErrorLabel.Text = ex.ToString(); } MessageRadWindowManager.VisibleOnPageLoad = false; }
protected void Page_Load(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; if (cookie == null) { cookie = new HttpCookie("BrowserDate"); cookie.Value = DateTime.Now.ToString(); cookie.Expires = DateTime.Now.AddDays(22); Response.Cookies.Add(cookie); } DateTime today = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")); Data dat = new Data(today); DataSet ds; HtmlHead head = (HtmlHead)Page.Header; if (Request.QueryString["ID"] != null) { string catID = Request.QueryString["ID"].ToString(); string location = ""; //Get the location if (Session["User"] != null) { DataView dvPrefs = dat.GetDataDV("SELECT * FROM UserPreferences WHERE UserID=" + Session["User"].ToString()); location = " AND V.State='" + dvPrefs[0]["CatState"].ToString() + "' AND V.City='" + dvPrefs[0]["CatCity"].ToString() + "' AND V.Country = " + dvPrefs[0]["CatCountry"].ToString(); } else { if (Session["LocCountry"] == null || Session["LocState"] == null || Session["LocCity"] == null) { dat.IP2Location(); } string country = Session["LocCountry"].ToString().Trim(); string state = Session["LocState"].ToString().Trim(); string city = Session["LocCity"].ToString(); location = " AND V.State='" + state + "' AND V.City='" + city + "' AND V.Country=" + country; } //get only events after today, since showing all events might be too much string timeline = " AND EO.DateTimeStart >= CONVERT(DATETIME, '" + today.Month.ToString() + "/" + today.Day.ToString() + "/" + today.Year.ToString() + "')"; string command = "SELECT DISTINCT E.ID " + "FROM Event_Occurance EO, Event_Category_Mapping ECM, Events E, Venues V, EventCategories C " + "WHERE EO.EventID=E.ID AND C.ID=ECM.CategoryID AND ECM.EventID=E.ID AND " + "ECM.CategoryID=" + catID + location + timeline; DataView dvE = dat.GetDataDV(command); ds = new DataSet(); DataTable dt = new DataTable(); DataColumn dc = new DataColumn("EID"); dt.Columns.Add(dc); dc = new DataColumn("ReoccurrID"); dt.Columns.Add(dc); dc = new DataColumn("DateTimeStart"); dt.Columns.Add(dc); dc = new DataColumn("VID"); dt.Columns.Add(dc); dc = new DataColumn("Header"); dt.Columns.Add(dc); dc = new DataColumn("Name"); dt.Columns.Add(dc); DataView dv; DataRow dr; foreach (DataRowView row in dvE) { dv = dat.GetDataDV("SELECT E.ID AS EID, EO.ID AS ReoccurrID, EO.DateTimeStart, E.Header, "+ "V.ID AS VID, V.Name " + "FROM Event_Occurance EO, Events E, Venues V " + "WHERE EO.EventID=E.ID AND E.Venue=V.ID AND E.ID=" + row["ID"].ToString()); dr = dt.NewRow(); dr["EID"] = dv[0]["EID"]; dr["ReoccurrID"] = dv[0]["ReoccurrID"]; dr["DateTimeStart"] = dv[0]["DateTimeStart"]; dr["VID"] = dv[0]["VID"]; dr["Header"] = dv[0]["Header"]; dr["Name"] = dv[0]["Name"]; dt.Rows.Add(dr); } ds.Tables.Add(dt); SearchElements.EVENTS_DS = ds; SearchElements.DataBind2(); NumResultsLabel.Text = "(" + ds.Tables[0].Rows.Count + " Records Found)"; DataView dvName = dat.GetDataDV("SELECT * FROM EventCategories WHERE ID=" + catID); string theLink = "http://" + Request.Url.Authority + "/" + dat.MakeNiceName(dvName[0]["Name"].ToString()) + "_Event_Category"; HtmlLink lk = new HtmlLink(); lk.Href = theLink; lk.Attributes.Add("rel", "bookmark"); head.Controls.AddAt(0, lk); HtmlMeta hm = new HtmlMeta(); HtmlMeta kw = new HtmlMeta(); HtmlMeta dc2 = new HtmlMeta(); kw.Name = "keywords"; kw.Content = dvName[0]["Name"].ToString() + " event Category"; head.Controls.AddAt(0, kw); dc2.Name = "description"; dc2.Content = "Results for event category: " + dvName[0]["Name"].ToString(); head.Controls.AddAt(0, dc2); SearchResultsTitleLabel.Text = "<a href=\"" + theLink + "\" style=\"text-decoration: none; \" ><h1>Events in '" + dvName[0]["Name"].ToString() + "' Category</h1></a>"; }else { Response.Redirect("home"); } }