protected void Page_Load(object sender, EventArgs e) { SignInButton.SERVER_CLICK += MakeItSo; HtmlLink lk = new HtmlLink(); HtmlHead head = (HtmlHead)Page.Header; lk.Attributes.Add("rel", "canonical"); lk.Href = "http://hippohappenings.com/ResetPassword.aspx"; head.Controls.AddAt(0, lk); HtmlMeta hm = new HtmlMeta(); hm.Name = "ROBOTS"; hm.Content = "NOINDEX, FOLLOW"; head.Controls.AddAt(0, hm); 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", ":"))); //Ads1.DATA_SET = dat.RetrieveAllAds(false); //Ads1.MAIN_AD_DATA_SET = dat.RetrieveAllAds(true); if (Request.QueryString["CODE"] == null || Request.QueryString["UserName"] == null) { Response.Redirect("home"); } else { SqlDbType[] types = { SqlDbType.NVarChar }; object[] parameters = { Request.QueryString["UserName"].ToString() }; DataSet ds = dat.GetDataWithParemeters("SELECT * FROM Users WHERE UserName=@p0", types, parameters); bool isNot = false; if (ds.Tables.Count > 0) if (ds.Tables[0].Rows.Count > 0) { string code = ds.Tables[0].Rows[0]["PasswordReset"].ToString(); if (code != Request.QueryString["CODE"].ToString()) Response.Redirect("home"); else { UserLabel.Text = Request.QueryString["UserName"].ToString(); } } else isNot = true; else isNot = true; } }
protected void SendIt(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); } if (EmailTextBox.Text != "") { Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); SqlDbType [] types = {SqlDbType.NVarChar}; EmailTextBox.Text = dat.stripHTML(EmailTextBox.Text.Trim()); object[] parameters = { EmailTextBox.Text }; DataSet ds = dat.GetDataWithParemeters("SELECT * FROM Users WHERE Email=@p0", types, parameters); bool isNot = false; if (ds.Tables.Count > 0) if (ds.Tables[0].Rows.Count > 0) { Encryption encrypt = new Encryption(); Random r = new Random(0); string code = encrypt.encrypt(ds.Tables[0].Rows[0]["UserName"].ToString() + r.Next().ToString()); dat.Execute("UPDATE Users SET PasswordReset='" + code + "' WHERE User_ID="+ds.Tables[0].Rows[0]["User_ID"].ToString()); string body = "You have requested to re-set your password with Hippo Happenings. <br/>" + "Please visit <a href=\"http://HippoHappenings.com/ResetPassword.aspx?CODE=" + code + "&UserName="******"UserName"].ToString() + "\">http://HippoHappenings.com/ResetPassword.aspx?CODE=" + code + "&UserName="******"UserName"].ToString() + "</a> to do so."; dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(), System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), ds.Tables[0].Rows[0]["Email"].ToString(), body, "Hippo Happenings Reset Password Request"); MessageLabel.Text = "An email with the instructions has been sent to your account."; } else isNot = true; else isNot = true; if (isNot) { MessageLabel.Text = "There is no user associated with this email address. Please make sure you have typed it correctly."; } } else { MessageLabel.Text = "Please include the Email"; } }
protected void GetThoseVenues() { try { HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); TimeFrameDiv.InnerHtml = "Select Venue >"; Session["NewVenue"] = null; Session.Remove("NewVenue"); string state = ""; if (VenueState.Visible) state = VenueState.SelectedItem.Text; else state = VenueStateTextBox.Text; SqlDbType[] types = { SqlDbType.NVarChar }; object[] data = { state }; DataSet ds = dat.GetDataWithParemeters("SELECT CASE WHEN SUBSTRING(Name, 1, 4) = 'The' THEN " + "SUBSTRING(Name, 5, LEN(Name)-4) ELSE Name END AS Name1, * FROM Venues WHERE Country=" + VenueCountry.SelectedValue + " AND State=@p0 ORDER BY Name1 ASC", types, data); Session["LocationVenues"] = ds; fillVenues(ds); } catch (Exception ex) { MessagePanel.Visible = true; YourMessagesLabel.Text += ex.ToString(); } }
private void GetMainEvents() { HttpCookie cookie = Request.Cookies["BrowserDate"]; Data d = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); int rowCount = 0; try { if (Session["User"] != null) { EventsPanel.Controls.Clear(); DataSet ds = d.GetEventsInLocation(true); if (ds.Tables.Count > 0) if (ds.Tables[0].Rows.Count > 0) { rowCount = ds.Tables[0].Rows.Count; if (rowCount > cutOff) rowCount = cutOff; for (int i = 0; i < rowCount; i++) { ASP.controls_otherevent_ascx anEvent = new ASP.controls_otherevent_ascx(); anEvent.EVENT_ID = ds.Tables[0].Rows[i]["ID"].ToString(); anEvent.TITLE = ds.Tables[0].Rows[i]["Header"].ToString(); anEvent.SUMMARY = ds.Tables[0].Rows[i]["ShortDescription"].ToString(); anEvent.PRESENTED_BY = d.GetDataDV("SELECT DateTimeStart FROM Event_Occurance WHERE EventID=" + ds.Tables[0].Rows[i]["ID"].ToString())[0]["DateTimeStart"].ToString(); EventsPanel.Controls.Add(anEvent); //goto NotMuchElse; d.Execute("INSERT INTO Events_Seen_By_User (eventID, userID, Date, SessionID) " + " VALUES(" + ds.Tables[0].Rows[i]["ID"].ToString() + ", " + Session["User"].ToString() + ", " + " '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString() + "', '" + Session["UserSession" + Session["User"].ToString()].ToString() + "')"); } } } else { DataView dvLocation = d.GetDataDV("SELECT * FROM Users WHERE IPs LIKE '&;" + d.GetIP() + ";%'"); if(dvLocation.Count == 0) dvLocation = d.GetDataDV("SELECT * FROM SearchIPs WHERE IP = '" + d.GetIP() + "'"); DataSet ds = new DataSet(); bool getUS = false; if (Session["GenericEventSession"] == null) { Random rand = new Random(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToUniversalTime().Millisecond); Session["GenericEventSession"] = rand.Next(); } if (dvLocation.Count > 0) { string country = ""; string state = ""; string city = ""; if (dvLocation[0]["Country"].ToString() != "") country = " AND E.Country = " + dvLocation[0]["Country"].ToString(); if (dvLocation[0]["State"].ToString() != "") state = " AND E.State = @p0 "; if (dvLocation[0]["City"].ToString() != "") city = " AND E.City = @p1 "; DataSet dsSeenAds = d.GetData("SELECT * FROM Events_Seen_Generic WHERE IP='" + d.GetIP() + "' AND SessionID='" + Session["GenericEventSession"].ToString() + "'"); string notTheseAds = ""; if (dsSeenAds.Tables.Count > 0) if (dsSeenAds.Tables[0].Rows.Count > 0) { for (int j = 0; j < dsSeenAds.Tables[0].Rows.Count; j++) { if (notTheseAds != "") notTheseAds += " AND "; notTheseAds += " E.ID <> " + dsSeenAds.Tables[0].Rows[j]["eventID"].ToString(); } } if (notTheseAds != "") notTheseAds = " AND ( " + notTheseAds + " ) "; bool couldGetMore = false; if (state != "") { if (city != "") { SqlDbType[] types = { SqlDbType.NVarChar, SqlDbType.NVarChar }; object[] data = { dvLocation[0]["State"].ToString(), dvLocation[0]["City"].ToString() }; ds = d.GetDataWithParemeters("SELECT DISTINCT EO.EventID, E.Header, E.Content, E.SponsorPresenter, EO.DateTimeStart FROM Events E, Event_Occurance EO WHERE EO.DateTimeStart >= GETDATE() AND E.ID=EO.EventID " + notTheseAds + country + state + city, types, data); } else { SqlDbType[] types = { SqlDbType.NVarChar }; object[] data = { dvLocation[0]["State"].ToString() }; ds = d.GetDataWithParemeters("SELECT DISTINCT EO.EventID, E.Header, E.Content, E.SponsorPresenter, EO.DateTimeStart FROM Events E, Event_Occurance EO WHERE EO.DateTimeStart >= GETDATE() AND E.ID=EO.EventID " + notTheseAds + country + state, types, data); } } else ds = d.GetData("SELECT DISTINCT EO.EventID, E.Header, E.Content, E.SponsorPresenter, EO.DateTimeStart FROM Events E, Event_Occurance EO WHERE EO.DateTimeStart >= GETDATE() AND E.ID=EO.EventID " + notTheseAds + country); EventsPanel.Controls.Clear(); if (ds.Tables.Count > 0) if (ds.Tables[0].Rows.Count > 0) { } else { couldGetMore = true; } else { couldGetMore = true; } if (couldGetMore) { Random rand = new Random(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToUniversalTime().Millisecond); d.Execute("DELETE FROM Events_Seen_Generic WHERE SessionID='" + Session["GenericEventSession"].ToString() + "' AND IP='" + d.GetIP() + "'"); Session["GenericEventSession"] = rand.Next(); if (state != "") { if (city != "") { SqlDbType[] types = { SqlDbType.NVarChar, SqlDbType.NVarChar }; object[] data = { dvLocation[0]["State"].ToString(), dvLocation[0]["City"].ToString() }; ds = d.GetDataWithParemeters("SELECT DISTINCT EO.EventID, E.Header, E.Content, E.SponsorPresenter, EO.DateTimeStart FROM Events E, Event_Occurance EO WHERE EO.DateTimeStart >= GETDATE() AND E.ID=EO.EventID " + country + state + city, types, data); } else { SqlDbType[] types = { SqlDbType.NVarChar }; object[] data = { dvLocation[0]["State"].ToString() }; ds = d.GetDataWithParemeters("SELECT DISTINCT EO.EventID, E.Header, E.Content, E.SponsorPresenter, EO.DateTimeStart FROM Events E, Event_Occurance EO WHERE EO.DateTimeStart >= GETDATE() AND E.ID=EO.EventID " + country + state, types, data); } } else ds = d.GetData("SELECT DISTINCT EO.EventID, E.Header, E.Content, E.SponsorPresenter, EO.DateTimeStart FROM Events E, Event_Occurance EO WHERE EO.DateTimeStart >= GETDATE() AND E.ID=EO.EventID " + country); if (ds.Tables.Count > 0) if (ds.Tables[0].Rows.Count > 0) { } else getUS = true; else getUS = true; } } else { getUS = true; } if (getUS) { ds = d.GetData("SELECT DISTINCT EO.EventID, E.Header, E.Content, E.SponsorPresenter, EO.DateTimeStart FROM Events E, Event_Occurance EO WHERE EO.DateTimeStart >= GETDATE() AND E.ID=EO.EventID AND E.Country=223"); } if (ds.Tables.Count > 0) if (ds.Tables[0].Rows.Count > 0) { rowCount = ds.Tables[0].Rows.Count; if (rowCount > cutOff) rowCount = cutOff; for (int i = 0; i < rowCount; i++) { ASP.controls_otherevent_ascx anEvent = new ASP.controls_otherevent_ascx(); anEvent.EVENT_ID = ds.Tables[0].Rows[i]["EventID"].ToString(); anEvent.TITLE = ds.Tables[0].Rows[i]["Header"].ToString(); anEvent.SUMMARY = ds.Tables[0].Rows[i]["Content"].ToString(); anEvent.PRESENTED_BY = ds.Tables[0].Rows[i]["DateTimeStart"].ToString(); EventsPanel.Controls.Add(anEvent); //goto NotMuchElse; d.Execute("INSERT INTO Events_Seen_Generic (eventID, IP, Date, SessionID) " + " VALUES(" + ds.Tables[0].Rows[i]["EventID"].ToString() + ", '" + d.GetIP() + "', " + " '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Date.ToString() + "', '" + Session["GenericEventSession"].ToString() + "')"); } } } } catch (Exception ex) { } }
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) { //Page.Trace.IsEnabled = true; //Page.Trace.TraceMode = TraceMode.SortByTime; try { HtmlMeta hm = new HtmlMeta(); HtmlMeta kw = new HtmlMeta(); HtmlHead head = (HtmlHead)Page.Header; hm.Name = "Description"; hm.Content = "Find your local events, venues and classifieds all while " + "ads from your peers, neighborhood, and community are displayed to you purely based on your interests." + "Large corporations are not welcome!"; head.Controls.AddAt(0, hm); HtmlMeta nMT = new HtmlMeta(); nMT.Name = "google-site-verification"; nMT.Content = "tw8rmOWW-DlZa-H4DZdGr201J5kC7NVLXUmk5oN8vFM"; head.Controls.Add(nMT); HtmlLink lkl = new HtmlLink(); lkl.Href = "ror.xml"; lkl.Attributes.Add("rel", "alternate"); lkl.Attributes.Add("type", "application/xml"); lkl.Attributes.Add("title", "ROR"); head.Controls.Add(lkl); 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; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":").Replace("%28", "(").Replace("%29", ")"))); kw.Name = "keywords"; kw.Content = "events, ads, venues, post, search, find, local events, concerts, festivals, world, theatre, technology, " + "family, peers, neighborhood, classifieds"; DataView dvCats = dat.GetDataDV("SELECT * FROM AdCategories"); for (int i = 0; i < dvCats.Count; i++) { kw.Content += ", " + dvCats[i]["Name"].ToString(); } dvCats = dat.GetDataDV("SELECT * FROM EventCategories"); for (int i = 0; i < dvCats.Count; i++) { kw.Content += ", " + dvCats[i]["Name"].ToString(); } dvCats = dat.GetDataDV("SELECT * FROM VenueCategories"); for (int i = 0; i < dvCats.Count; i++) { kw.Content += ", " + dvCats[i]["Name"].ToString(); } head.Controls.AddAt(0, kw); string cookieName = FormsAuthentication.FormsCookieName; HttpCookie authCookie = Context.Request.Cookies[cookieName]; //logInPanel.Visible = Session["User"] == null; //loggedInPanel.Visible = Session["User"] != null; string country = ""; string state = ""; string city = ""; string countryID = ""; string stateID = ""; string cityID = ""; FormsAuthenticationTicket authTicket = null; try { string group = ""; if (authCookie != null) { authTicket = FormsAuthentication.Decrypt(authCookie.Value); group = authTicket.UserData.ToString(); } if (group.Contains("User")) { Session["User"] = authTicket.Name; DataSet ds1 = dat.GetData("SELECT * FROM Users U, UserPreferences UP WHERE U.User_ID=" + authTicket.Name + " AND U.User_ID=UP.UserID "); Session["UserName"] = ds1.Tables[0].Rows[0]["UserName"].ToString(); 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; //DataSet ds2 = dat.RetrieveAds(Session["User"].ToString(), false); //DataSet dsMain = dat.RetrieveMainAds(Session["User"].ToString()); //Ads1.DATA_SET = ds2; //Ads1.MAIN_AD_DATA_SET = dsMain; fillUserData = true; } else { DataSet ds1 = dat.GetData("SELECT * FROM SearchIPs WHERE IP='" + dat.GetIP() + "'"); bool getAnotherDs1 = false; if (ds1.Tables.Count > 0) if (ds1.Tables[0].Rows.Count > 0) { country = ds1.Tables[0].Rows[0]["Country"].ToString(); countryID = country; state = ds1.Tables[0].Rows[0]["State"].ToString(); city = ds1.Tables[0].Rows[0]["City"].ToString(); stateID = state; cityID = city; } else { getAnotherDs1 = true; } else { getAnotherDs1 = true; } if (getAnotherDs1) { ds1 = dat.GetData("SELECT * FROM Users U, UserPreferences UP WHERE " + " U.User_ID=UP.UserID AND U.IPs LIKE '%" + dat.GetIP() + "%'"); if (ds1.Tables.Count > 0) if (ds1.Tables[0].Rows.Count > 0) { 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; } } //if (!IsPostBack) //{ // Ads1.DATA_SET = dat.RetrieveAllAds(false); // Ads1.MAIN_AD_DATA_SET = dat.RetrieveAllAds(true); //} Button calendarLink = (Button)dat.FindControlRecursive(this, "CalendarLink"); calendarLink.Visible = false; } } catch (Exception ex) { } DataSet ds; if (!IsPostBack) { LocationLabel.Text = ""; if (country != "") country = " AND E.Country = " + country; 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 10 EO.DateTimeStart, E.Header, E.Content, EO.EventID FROM Events E, Event_Occurance EO WHERE E.ID=EO.EventID " + country + state + city + " AND EO.DateTimeStart > '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Date + "'", types, data); Session["HomeEvents"] = ds; LocationLabel.Text = ""; if (country == "" && state == "" && city == "") { LocationLabel.Text = " The World "; } else { if (city != "") { LocationLabel.Text += cityID; if (state != "") LocationLabel.Text += ", " + stateID; } else { if (state != "") LocationLabel.Text += stateID; } } if (LocationLabel.Text == "") { DataSet dsCountry = dat.GetData("SELECT * FROM Countries WHERE country_id=" + countryID); LocationLabel.Text = dsCountry.Tables[0].Rows[0]["country_name"].ToString(); } } else { EventPanel.Controls.Clear(); LocationLabel.Text = ""; ds = (DataSet)Session["HomeEvents"]; if (countryID == "" && stateID == "" && cityID == "") { LocationLabel.Text = " The World "; } else { if (cityID != "") { LocationLabel.Text += cityID; if (state != "") LocationLabel.Text += ", " + stateID; } else { if (state != "") LocationLabel.Text += stateID; } } if (RadCalendar1.SelectedDate.ToShortDateString() != "1/1/0001") LocationLabel.Text += " on " + RadCalendar1.SelectedDate.ToShortDateString(); } ds = (DataSet)Session["HomeEvents"]; if (ds != null) { if (ds.Tables.Count > 0) if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DateTime date = DateTime.Parse(ds.Tables[0].Rows[i]["DateTimeStart"].ToString()); ASP.controls_homeevent_ascx eventH = new ASP.controls_homeevent_ascx(); eventH.DAY = date.DayOfWeek.ToString().Substring(0, 3); eventH.DAY_NUMBER = date.Day.ToString(); eventH.MONTH = dat.GetMonth(date.Month.ToString()).Substring(0, 3); eventH.EVENT_NAME = ds.Tables[0].Rows[i]["Header"].ToString(); if (ds.Tables[0].Rows[i]["Content"].ToString().Length > 150) eventH.SUMMARY = dat.BreakUpString(ds.Tables[0].Rows[i]["Content"].ToString().Substring(0, 150), 67) + "..."; else eventH.SUMMARY = dat.BreakUpString(ds.Tables[0].Rows[i]["Content"].ToString(), 67) + "..."; eventH.EVENT_ID = int.Parse(ds.Tables[0].Rows[i]["EventID"].ToString()); EventPanel.Controls.Add(eventH); } } else { Label label = new Label(); label.CssClass = "EventBody"; label.Text = "No events are listed for this date. Sorry. But perhaps you could enter one... <a class=\"AddLink\" href=\"BlogEvent.aspx\">Enter Events</a>."; EventPanel.Controls.Add(label); } else { Label label = new Label(); label.CssClass = "EventBody"; label.Text = "No events are listed for this date. Sorry. But perhaps you could enter one... <a class=\"AddLink\" href=\"BlogEvent.aspx\">Enter Events</a>."; EventPanel.Controls.Add(label); } } else { Label label = new Label(); label.CssClass = "EventBody"; label.Text = "No events are listed for this date. Sorry. But perhaps you could enter one... <a class=\"AddLink\" href=\"BlogEvent.aspx\">Enter Events</a>."; EventPanel.Controls.Add(label); } #region Original Home page code //if (ds.Tables.Count > 0) //{ // if (ds.Tables[0].Rows.Count > 0) // { // ASP.controls_footer_ascx thefooter = (ASP.controls_footer_ascx)dat.FindControlRecursive(this, "TheFooter"); // thefooter.EVENT_ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); // string ID = ds.Tables[0].Rows[0]["ID"].ToString(); // DataSet dsDate = dat.GetData("SELECT * FROM Event_Occurance WHERE EventID=" + ID); // DataSet dsVenue = dat.GetData("SELECT * FROM Venues WHERE ID=" + ds.Tables[0].Rows[0]["Venue"]); // TagCloud.THE_ID = int.Parse(ID); // DataSet dsComments = dat.GetData("SELECT C.BlogDate AS theDate, * FROM Comments C, Users U WHERE U.User_ID=C.UserID AND C.BlogID=" + ID +" ORDER BY C.BlogDate"); // TheComments.DATA_SET = dsComments; // TheComments.DataBind2(true); // if (bool.Parse(ds.Tables[0].Rows[0]["hasSongs"].ToString())) // { // DataSet dsSongs = dat.GetData("SELECT * FROM Event_Song_Mapping WHERE EventID=" + ID); // ASP.controls_songplayer_ascx songs = new ASP.controls_songplayer_ascx(); // int songCount = dsSongs.Tables[0].Rows.Count; // if (songCount > 2) // { // songs.SONG1 = dsSongs.Tables[0].Rows[0]["SongName"].ToString(); // songs.SONG2 = dsSongs.Tables[0].Rows[1]["SongName"].ToString(); // songs.SONG3 = dsSongs.Tables[0].Rows[2]["SongName"].ToString(); // } // else if (songCount > 1) // { // songs.SONG1 = dsSongs.Tables[0].Rows[0]["SongName"].ToString(); // songs.SONG2 = dsSongs.Tables[0].Rows[1]["SongName"].ToString(); // } // else // songs.SONG1 = dsSongs.Tables[0].Rows[0]["SongName"].ToString(); // songs.USER_NAME = ds.Tables[0].Rows[0]["UserName"].ToString(); // SongPanel.Controls.Add(songs); // } // EventName.Text = ds.Tables[0].Rows[0]["Header"].ToString(); // Session["Subject"] = "Re: "+ds.Tables[0].Rows[0]["Header"].ToString(); // Session["CommentSubject"] = "Re: " + ds.Tables[0].Rows[0]["Header"].ToString(); // EventName.NavigateUrl = "~/Event.aspx?EventID=" + ID; // Session["EventID"] = ID; // VenueName.Text = dsVenue.Tables[0].Rows[0]["Name"].ToString(); // VenueName.NavigateUrl = "Venue.aspx?ID="+dsVenue.Tables[0].Rows[0]["ID"].ToString(); // DateTime date = (DateTime)dsDate.Tables[0].Rows[0]["DateTimeStart"]; // DateAndTimeLabel.Text = date.DayOfWeek.ToString() + ", " + GetMonth(date.Month.ToString()) + " " + date.Day + " " + date.Hour + ":" + date.Minute; // string content = ds.Tables[0].Rows[0]["Content"].ToString(); // SendTxtID.MESSAGE = EventName.Text + " occurs at " + VenueName.Text + " on " + DateAndTimeLabel.Text; // string href = Request.Url.AbsoluteUri; // SendEmailID.MESSAGE = "EventName: <a class=\"AddLink\" href=\"" + href + // "\">" + EventName.Text + "</a> \n\r Venue: " + VenueName.Text + // " \n\r Date: " + DateAndTimeLabel.Text + " \n\r " + content; // //if (fillUserData) // //{ // // DataSet ds2 = dat.GetData("SELECT EEL.ExcitmentLevel AS Level FROM User_Calendar UC, Event_ExcitmentLevel EEL WHERE UC.UserID=" // // + Session["User"].ToString() + " AND UC.EventID = " + ID + " AND UC.ExcitmentID=EEL.ID "); // // bool addEvent = false; // // if (ds2.Tables.Count > 0) // // if (ds2.Tables[0].Rows.Count > 0) // // { // // Label label = new Label(); // // label.CssClass = "AddLinkGoing"; // // label.Text = "Guess What?!: you're going to this event and you are " + ds2.Tables[0].Rows[0]["Level"].ToString(); // // CalendarPanel.Controls.Add(label); // // } // // else // // addEvent = true; // // else // // addEvent = true; // // if (addEvent) // // { // // ASP.controls_addtocalendar_ascx AddTo1 = new ASP.controls_addtocalendar_ascx(); // // AddTo1.ID = "AddTo1"; // // AddTo1.TEXT = "Add this event to calendar"; // // AddTo1.EVENT_ID = int.Parse(ID); // // CalendarPanel.Controls.Add(AddTo1); // // } // //} // if (content.Length > 500) // { // ShowDescriptionBegining.Text = content.Substring(0, 500); // int j = 500; // if (content[500] != ' ') // { // while (content[j] != ' ') // { // ShowDescriptionBegining.Text += content[j]; // j++; // } // } // ShowDescriptionBegining.Text = dat.BreakUpString(ShowDescriptionBegining.Text, 65); // ShowRestOfDescription.Text = dat.BreakUpString(content.Substring(j), 65); // } // else // { // ShowDescriptionBegining.Text = dat.BreakUpString(content, 65); // ShowRestOfDescription.Text = ""; // } // //Media Categories: NONE: 0, Picture: 1, Video: 2, YouTubeVideo: 3, Slider: 4 // int mediaCategory = int.Parse(ds.Tables[0].Rows[0]["mediaCategory"].ToString()); // switch (mediaCategory) // { // case 0: // break; // case 1: // ShowVideoPictureLiteral.Text = "<img style=\"float: left; padding-right: 10px; padding-top: 9px;\" height=\"250px\" width=\"440px\" src=\"UserFiles/" + ds.Tables[0].Rows[0]["Picture"].ToString() + "\" />"; // break; // case 2: // ShowVideoPictureLiteral.Text = "<div style=\"float:left; padding-top: 9px; padding-right: 10px;\"><embed height=\"250px\" width=\"440px\" src=\"UserFiles/" + ds.Tables[0].Rows[0]["Video"].ToString() + "\" /></div>"; // break; // case 3: // ShowVideoPictureLiteral.Text = "<div style=\"float:left; padding-top: 9px; padding-right: 10px;\"><object width=\"440\" height=\"250\"><param name=\"movie\" value=\"http://www.youtube.com/v/" + ds.Tables[0].Rows[0]["YouTubeVideo"].ToString() + "\"></param><param name=\"allowFullScreen\" value=\"true\"></param><embed src=\"http://www.youtube.com/v/" + ds.Tables[0].Rows[0]["YouTubeVideo"].ToString() + "\" type=\"application/x-shockwave-flash\" allowfullscreen=\"true\" width=\"440\" height=\"250\"></embed></object></div>"; // break; // case 4: // ShowVideoPictureLiteral.Text = ""; // DataSet dsSlider = dat.GetData("SELECT * FROM Event_Slider_Mapping WHERE EventID=" + ID); // if (dsSlider.Tables.Count > 0) // if (dsSlider.Tables[0].Rows.Count > 0) // { // char[] delim = { '\\' }; // string[] fileArray = System.IO.Directory.GetFiles(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\Slider\\"); // string[] finalFileArray = new string[fileArray.Length]; // for (int i = 0; i < fileArray.Length; i++) // { // int length = fileArray[i].Split(delim).Length; // finalFileArray[i] = "http://" + Request.Url.Authority + "/HippoHappenings/UserFiles/" + Session["UserName"].ToString() + "/Slider/" + fileArray[i].Split(delim)[length - 1]; // } // Rotator1.DataSource = finalFileArray; // Rotator1.DataBind(); // RotatorPanel.Visible = true; // } // break; // default: break; // } // this.Title = EventName.Text; // } //} #endregion } catch (Exception ex) { ErrorLabel.Text = ex.ToString(); } }
protected void GoToSearch(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); string cookieName = FormsAuthentication.FormsCookieName; HttpCookie authCookie = Context.Request.Cookies[cookieName]; string country = ""; string state = ""; string city = ""; FormsAuthenticationTicket authTicket = null; string group = ""; if (authCookie != null) { authTicket = FormsAuthentication.Decrypt(authCookie.Value); group = authTicket.UserData.ToString(); } if (group.Contains("User")) { DataSet ds1 = dat.GetData("SELECT * FROM Users U, UserPreferences UP WHERE U.User_ID=" + authTicket.Name + " AND U.User_ID=UP.UserID "); if(ds1.Tables.Count > 0) if (ds1.Tables[0].Rows.Count > 0) { country = ds1.Tables[0].Rows[0]["CatCountry"].ToString(); state = ds1.Tables[0].Rows[0]["CatState"].ToString(); city = ds1.Tables[0].Rows[0]["CatCity"].ToString(); } } else { DataSet ds1 = dat.GetData("SELECT * FROM SearchIPs WHERE IP='" + dat.GetIP() + "'"); if(ds1.Tables.Count > 0) if (ds1.Tables[0].Rows.Count > 0) { country = ds1.Tables[0].Rows[0]["Country"].ToString(); state = ds1.Tables[0].Rows[0]["State"].ToString(); city = ds1.Tables[0].Rows[0]["City"].ToString(); } } if (country != "") country = " AND E.Country = " + country; 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 "; } } DataSet ds = dat.GetDataWithParemeters("SELECT DISTINCT TOP 10 EO.DateTimeStart, E.Header, E.Content, EO.EventID FROM Events E, Event_Occurance EO WHERE E.ID=EO.EventID " + country + state + city + " AND CONVERT(NVARCHAR, MONTH(EO.DateTimeStart)) + '/' + CONVERT(NVARCHAR, DAY(EO.DateTimeStart)) + '/' + CONVERT(NVARCHAR, YEAR(EO.DateTimeStart)) = '" + RadCalendar1.SelectedDate.ToShortDateString() + "'", types, data); EventPanel.Controls.Clear(); if (ds.Tables.Count > 0) if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DateTime date = DateTime.Parse(ds.Tables[0].Rows[i]["DateTimeStart"].ToString()); ASP.controls_homeevent_ascx eventH = new ASP.controls_homeevent_ascx(); eventH.DAY = date.DayOfWeek.ToString().Substring(0, 3); eventH.DAY_NUMBER = date.Day.ToString(); eventH.MONTH = dat.GetMonth(date.Month.ToString()).Substring(0, 3); eventH.EVENT_NAME = ds.Tables[0].Rows[i]["Header"].ToString(); if (ds.Tables[0].Rows[i]["Content"].ToString().Length > 150) eventH.SUMMARY = dat.BreakUpString(ds.Tables[0].Rows[i]["Content"].ToString().Substring(0, 150), 67) + "..."; else eventH.SUMMARY = dat.BreakUpString(ds.Tables[0].Rows[i]["Content"].ToString(), 67) + "..."; eventH.EVENT_ID = int.Parse(ds.Tables[0].Rows[i]["EventID"].ToString()); EventPanel.Controls.Add(eventH); } } else { Label label = new Label(); label.CssClass = "EventBody"; label.Text = "No events are listed for this date. Sorry. But perhaps you could enter one... <a class=\"AddLink\" href=\"EnterEvent.aspx\">Enter Events</a>."; EventPanel.Controls.Add(label); } else { Label label = new Label(); label.CssClass = "EventBody"; label.Text = "No events are listed for this date. Sorry. But perhaps you could enter one... <a class=\"AddLink\" href=\"EnterEvent.aspx\">Enter Events</a>."; EventPanel.Controls.Add(label); } Session["HomeEvents"] = ds; }
//[Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.ReadWrite)] //public string SendIt(string friendID) //{ // Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); // try // { // SqlConnection conn = dat.GET_CONNECTED; // SqlCommand cmd = new SqlCommand("INSERT INTO UserMessages (MessageContent, MessageSubject, From_UserID, To_UserID, Date, [Read], Mode)" // + " VALUES(@content, @subject, @fromID, @toID, @date, 'False', 2)", conn); // cmd.Parameters.Add("@content", SqlDbType.Text).Value = Session["UserName"].ToString() +" would like to extend a Hippo Happ friend invitation to you. You can find out about this user <a target=\"_blank\" class=\"AddLink\" href=\"Friend.aspx?ID="+Session["User"].ToString()+"\">here</a>. To accept this Hippo user as a friend, click on the link below."; // cmd.Parameters.Add("@subject", SqlDbType.NVarChar).Value = "Hippo Happs Friend Request!"; // cmd.Parameters.Add("@toID", SqlDbType.Int).Value = friendID; // cmd.Parameters.Add("@fromID", SqlDbType.Int).Value = Session["User"].ToString(); // cmd.Parameters.Add("@date", SqlDbType.DateTime).Value = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")); // cmd.ExecuteNonQuery(); // conn.Close(); // return "stuff success"; // } // catch (Exception ex) // { // return ex.ToString(); // } //} //protected void SendIt(object sender, EventArgs e) //{ // Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); // try // { // SqlConnection conn = dat.GET_CONNECTED; // SqlCommand cmd = new SqlCommand("INSERT INTO UserMessages (MessageContent, MessageSubject, From_UserID, To_UserID, Date, [Read], Mode)" // + " VALUES(@content, @subject, @fromID, @toID, @date, 'False', 2)", conn); // cmd.Parameters.Add("@content", SqlDbType.Text).Value = Session["UserName"].ToString() + // " would like to extend a Hippo Happ friend invitation to you. You can find out about this user <a target=\"_blank\" class=\"AddLink\" href=\"Friend.aspx?ID=" + Session["User"].ToString() + "\">here</a>. To accept this Hippo user as a friend, click on the link below."; // cmd.Parameters.Add("@subject", SqlDbType.NVarChar).Value = "Hippo Happs Friend Request!"; // cmd.Parameters.Add("@toID", SqlDbType.Int).Value = friendID; // cmd.Parameters.Add("@fromID", SqlDbType.Int).Value = Session["User"].ToString(); // cmd.Parameters.Add("@date", SqlDbType.DateTime).Value = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")); // cmd.ExecuteNonQuery(); // conn.Close(); // } // catch (Exception ex) // { // } //} protected void Search(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); char[] delim = { ' ' }; string[] tokens = SearchTextBox.Text.Split(delim); string query = "SELECT DISTINCT UserName, ProfilePicture, FirstName, LastName, User_ID FROM USERS WHERE User_ID <> " + Session["User"].ToString() + " AND "; SqlDbType[] types = new SqlDbType[tokens.Length]; for (int i = 0; i < tokens.Length; i++) { types[i] = SqlDbType.NVarChar; if (i != 0) query += " OR "; query += " ( FirstName LIKE '%'+@p" + i.ToString() + "+'%' OR LastName LIKE '%'+@p" + i.ToString() + "+'%' OR UserName LIKE '%'+@p" + i.ToString() + "+'%' OR Email LIKE '%'+@p" + i.ToString() + "+'%' ) "; } DataSet ds = dat.GetDataWithParemeters(query, types, tokens); Session["SearchDS"] = ds; FillFriends(ds); }
private void GetMainEvents() { HttpCookie cookie = Request.Cookies["BrowserDate"]; Data d = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); int rowCount = 0; try { if (Session["User"] != null) { EventsPanel.Controls.Clear(); if (Session["UserSessionEvents"] == null) { DataSet dsT = d.GetEventsInLocation(true); Session["UserSessionEvents"] = dsT; } DataSet ds = (DataSet)Session["UserSessionEvents"]; if (Session["UserSessionLastSeenEvent"] == null) Session["UserSessionLastSeenEvent"] = "-1"; if (ds.Tables.Count > 0) if (ds.Tables[0].Rows.Count > 0) { rowCount = ds.Tables[0].Rows.Count; if (rowCount > cutOff) rowCount = cutOff; int startIndex = 0; if (Session["UserSessionLastSeenEvent"].ToString() != "-1") startIndex = int.Parse(Session["UserSessionLastSeenEvent"].ToString()); int endIndex = startIndex + cutOff; Session["UserSessionLastSeenEvent"] = endIndex - 1; if (endIndex > ds.Tables[0].Rows.Count) { endIndex = ds.Tables[0].Rows.Count; Session["UserSessionLastSeenEvent"] = "-1"; } for (int i = startIndex; i < endIndex; i++) { ASP.controls_otherevent_ascx anEvent = new ASP.controls_otherevent_ascx(); anEvent.EVENT_ID = ds.Tables[0].Rows[i]["ID"].ToString(); anEvent.TITLE = ds.Tables[0].Rows[i]["Header"].ToString(); anEvent.SUMMARY = ds.Tables[0].Rows[i]["Content"].ToString(); anEvent.PRESENTED_BY = d.GetDataDV("SELECT DateTimeStart FROM Event_Occurance WHERE EventID=" + ds.Tables[0].Rows[i]["ID"].ToString())[0]["DateTimeStart"].ToString(); EventsPanel.Controls.Add(anEvent); } } } else { if (Session["GenericEventSession"] == null) { DataView dvLocation = d.GetDataDV("SELECT * FROM Users WHERE IPs LIKE '&;" + d.GetIP() + ";%'"); if (dvLocation.Count == 0) dvLocation = d.GetDataDV("SELECT * FROM SearchIPs WHERE IP = '" + d.GetIP() + "'"); DataSet ds = new DataSet(); bool getUS = false; if (dvLocation.Count > 0) { string country = ""; string state = ""; string city = ""; if (dvLocation[0]["Country"].ToString() != "") country = " AND E.Country = " + dvLocation[0]["Country"].ToString(); if (dvLocation[0]["State"].ToString() != "") state = " AND E.State = @p0 "; if (dvLocation[0]["City"].ToString() != "") city = " AND E.City = @p1 "; bool couldGetMore = false; if (state != "") { if (city != "") { SqlDbType[] types = { SqlDbType.NVarChar, SqlDbType.NVarChar }; object[] data = { dvLocation[0]["State"].ToString(), dvLocation[0]["City"].ToString() }; ds = d.GetDataWithParemeters("SELECT DISTINCT EO.EventID, E.Header, E.Content, E.SponsorPresenter, EO.DateTimeStart FROM Events E, Event_Occurance EO WHERE EO.DateTimeStart >= GETDATE() AND E.ID=EO.EventID " + country + state + city, types, data); } else { SqlDbType[] types = { SqlDbType.NVarChar }; object[] data = { dvLocation[0]["State"].ToString() }; ds = d.GetDataWithParemeters("SELECT DISTINCT EO.EventID, E.Header, E.Content, E.SponsorPresenter, EO.DateTimeStart FROM Events E, Event_Occurance EO WHERE EO.DateTimeStart >= GETDATE() AND E.ID=EO.EventID " + country + state, types, data); } } else ds = d.GetData("SELECT DISTINCT EO.EventID, E.Header, E.Content, E.SponsorPresenter, EO.DateTimeStart FROM Events E, Event_Occurance EO WHERE EO.DateTimeStart >= GETDATE() AND E.ID=EO.EventID " + country); EventsPanel.Controls.Clear(); if (ds.Tables.Count > 0) if (ds.Tables[0].Rows.Count > 0) { } else { getUS = true; } else { getUS = true; } } else { getUS = true; } if (getUS) { ds = d.GetData("SELECT DISTINCT EO.EventID, E.Header, E.Content, E.SponsorPresenter, EO.DateTimeStart FROM Events E, Event_Occurance EO WHERE EO.DateTimeStart >= GETDATE() AND E.ID=EO.EventID AND E.Country=223"); } Session["GenericEventSession"] = ds; Session["GenericLastSeenEvent"] = "-1"; } if (Session["GenericLastSeenEvent"] == null) Session["GenericLastSeenEvent"] = "-1"; DataSet dsTotal = (DataSet)Session["GenericEventSession"]; if (dsTotal.Tables.Count > 0) if (dsTotal.Tables[0].Rows.Count > 0) { rowCount = dsTotal.Tables[0].Rows.Count; if (rowCount > cutOff) rowCount = cutOff; int startIndex = 0; if (Session["GenericLastSeenEvent"].ToString() != "-1") startIndex = int.Parse(Session["GenericLastSeenEvent"].ToString()); int endIndex = startIndex + cutOff; Session["GenericLastSeenEvent"] = endIndex - 1; if (endIndex > dsTotal.Tables[0].Rows.Count) { endIndex = dsTotal.Tables[0].Rows.Count; Session["GenericLastSeenEvent"] = "-1"; } for (int i = startIndex; i < endIndex; i++) { ASP.controls_otherevent_ascx anEvent = new ASP.controls_otherevent_ascx(); anEvent.EVENT_ID = dsTotal.Tables[0].Rows[i]["EventID"].ToString(); anEvent.TITLE = dsTotal.Tables[0].Rows[i]["Header"].ToString(); anEvent.SUMMARY = dsTotal.Tables[0].Rows[i]["Content"].ToString(); anEvent.PRESENTED_BY = dsTotal.Tables[0].Rows[i]["DateTimeStart"].ToString(); EventsPanel.Controls.Add(anEvent); } } } } catch (Exception ex) { Label l = new Label(); l.Text = ex.ToString(); EventsPanel.Controls.Add(l); } }
protected void Page_Load(object sender, EventArgs e) { //Page.Trace.IsEnabled = true; //Page.Trace.TraceMode = TraceMode.SortByTime; 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; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":").Replace("%28", "(").Replace("%29", ")"))); if (!IsPostBack) { try { HtmlMeta hm = new HtmlMeta(); HtmlMeta kw = new HtmlMeta(); HtmlHead head = (HtmlHead)Page.Header; hm.Name = "Description"; hm.Content = "Find your local events, venues and classifieds all while " + "ads from your peers, neighborhood, and community are displayed "+ "to you purely based on your interests." + "Large corporations are not welcome!"; head.Controls.AddAt(0, hm); HtmlMeta nMT = new HtmlMeta(); nMT.Name = "google-site-verification"; nMT.Content = "tw8rmOWW-DlZa-H4DZdGr201J5kC7NVLXUmk5oN8vFM"; head.Controls.Add(nMT); HtmlLink lkl = new HtmlLink(); lkl.Href = "ror.xml"; lkl.Attributes.Add("rel", "alternate"); lkl.Attributes.Add("type", "application/xml"); lkl.Attributes.Add("title", "ROR"); head.Controls.Add(lkl); kw.Name = "keywords"; kw.Content = "events, ads, venues, post, search, find, local events, concerts, festivals, world, theatre, technology, " + "family, peers, neighborhood, classifieds"; //DataView dvCats = dat.GetDataDV("SELECT * FROM AdCategories"); //for (int i = 0; i < dvCats.Count; i++) //{ // kw.Content += ", " + dvCats[i]["Name"].ToString(); //} //dvCats = dat.GetDataDV("SELECT * FROM EventCategories"); //for (int i = 0; i < dvCats.Count; i++) //{ // kw.Content += ", " + dvCats[i]["Name"].ToString(); //} //dvCats = dat.GetDataDV("SELECT * FROM VenueCategories"); //for (int i = 0; i < dvCats.Count; i++) //{ // kw.Content += ", " + dvCats[i]["Name"].ToString(); //} head.Controls.AddAt(0, kw); //logInPanel.Visible = Session["User"] == null; //loggedInPanel.Visible = Session["User"] != null; //Fill the home mission //if (!IsPostBack) //{ // ChangeMission(MissionTimer, new EventArgs()); //} string country = ""; string state = ""; string city = ""; string countryID = ""; string stateID = ""; string cityID = ""; try { if (Session["User"] != 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; //DataSet ds2 = dat.RetrieveAds(Session["User"].ToString(), false); //DataSet dsMain = dat.RetrieveMainAds(Session["User"].ToString()); //Ads1.DATA_SET = ds2; //Ads1.MAIN_AD_DATA_SET = dsMain; fillUserData = true; } else { DataSet ds1 = dat.GetData("SELECT * FROM Users U, UserPreferences UP WHERE " + " U.User_ID=UP.UserID AND U.IPs LIKE '%" + dat.GetIP() + "%'"); bool getAnotherDs1 = false; if (ds1.Tables.Count > 0) if (ds1.Tables[0].Rows.Count > 0) { 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 { getAnotherDs1 = true; } else { getAnotherDs1 = true; } if (getAnotherDs1) { ds1 = dat.GetData("SELECT * FROM SearchIPs WHERE IP='" + dat.GetIP() + "'"); if (ds1.Tables.Count > 0) { if (ds1.Tables[0].Rows.Count > 0) { country = ds1.Tables[0].Rows[0]["Country"].ToString(); countryID = country; state = ds1.Tables[0].Rows[0]["State"].ToString(); city = ds1.Tables[0].Rows[0]["City"].ToString(); stateID = state; cityID = city; } } } } } catch (Exception ex) { } #region Take care of group activity if (country != "" && state != "") { //Get Latest Group activity from Public groups //GroupEvents // -posted on // -last edited string thePlace = " AND G.Country=" + country + " AND G.State='" + state + "' "; if (city != "") thePlace += " AND G.City = '" + city.Replace("'", "''") + "'"; DataView dvTopGroupActivity = GetTheActivity(thePlace); //Find the top 5 most recent if (dvTopGroupActivity.Count > 0) { dvTopGroupActivity.Sort = "TheDate DESC"; } int countIndex = 5; if (dvTopGroupActivity.Count < 5) countIndex = dvTopGroupActivity.Count; string theType = ""; Literal theLit = new Literal(); GroupsPanel.Controls.Clear(); string userID = ""; string content = ""; DataView dvUser = new DataView(); DataView dv = new DataView(); DataView dvGroup = new DataView(); DataView dvG = new DataView(); if (dvTopGroupActivity.Count > 0) { for (int i = 0; i < countIndex; i++) { theType = dvTopGroupActivity[i]["Type"].ToString(); //<div style=\"width: 388px;background-repeat: repeat-y; background-image: url(images/ActCommentMiddle.png);\" class=\"topDiv\"> theLit.Text += "<div " + "class=\"topDiv\" style=\"width: 378px;height: 143px;padding-left: 10px;padding-top: 10px; background-image: "+ "url(images/ActCommentTopPurple10.png); background-repeat: no-repeat; \"><div style=\"float: left;\"><img src=\"images/QuoteTop.png\" /></div><div style=\"float: left; width: 350px; padding-bottom: 5px;\">"; DateTime theDate = DateTime.Parse(dvTopGroupActivity[i]["TheDate"].ToString()); string postedText = "<div style=\"clear: both;\"><div style=\"float: left;\"><span " + "style=\"font-size: 12px; font-style: italic; font-family: arial; color: #a5c13a;\">Posted " + dat.GetMonth(theDate.Month.ToString()) + " " + theDate.Day.ToString() + ", " + theDate.Year.ToString() + "</span><br/>"; switch (theType) { case "GEP": dv = dat.GetDataDV("SELECT *, GEO.ID AS GEOID FROM GroupEvents GE, " + "GroupEvent_Occurance GEO WHERE GE.ID=GEO.GroupEventID AND GE.ID=" + dvTopGroupActivity[i]["TheID"].ToString()); userID = dv[0]["UserID"].ToString(); dvGroup = dat.GetDataDV("SELECT * FROM Groups WHERE ID=" + dv[0]["GroupID"].ToString()); dvUser = dat.GetDataDV("SELECT * FROM UserPreferences UP, Users U " + "WHERE UP.UserID=U.User_ID AND UP.UserID=" + userID); theLit.Text += "<div style=\"float: left; padding-right: 10px; padding-left: " + "10px; padding-bottom: 5px; padding-top: 5px;\">" + getUserProfile(userID) + "</div>"; content = dat.stripHTML(dv[0]["Content"].ToString()); if (content.Length > 170) content = content.Substring(0, 170) + "..."; theLit.Text += "<div style=\"padding-top: 5px;font-family: Arial; font-size: 12px; color: " + "#cccccc; font-style: italic;\">" + content + " <a style=\"text-decoration: none;\" href=\"" + dat.MakeNiceName(dv[0]["Name"].ToString()) + "_" + dv[0]["GEOID"].ToString() + "_" + dvTopGroupActivity[i]["TheID"].ToString() + "_GroupEvent\"><span class=\"AddPurpleLink\">Read More</span></a></div>"; theLit.Text += postedText; theLit.Text += "<span style=\"font-size: 12px; font-family: arial; color: #cccccc;\">posted by <a href=\"" + dvUser[0]["UserName"].ToString() + "_Friend\" class=\"AddLink\">" + dvUser[0]["UserName"].ToString() + "</a></span> <br/>"; theLit.Text += "<a href=\"" + dat.MakeNiceName(dvGroup[0]["Header"].ToString()) + "_" + dvGroup[0]["ID"].ToString() + "_Group\" class=\"AddPurpleLink\">" + dvGroup[0]["Header"].ToString() + " Group</a></div><div style=\"float: right;\"><img src=\"images/QuoteBottom.png\" /></div></div>"; break; case "GEE": dv = dat.GetDataDV("SELECT *, GEO.ID AS GEOID FROM GroupEvents GE, " + "GroupEvent_Occurance GEO WHERE GE.ID=GEO.GroupEventID AND GE.ID=" + dvTopGroupActivity[i]["TheID"].ToString()); userID = dv[0]["UserID"].ToString(); dvGroup = dat.GetDataDV("SELECT * FROM Groups WHERE ID=" + dv[0]["GroupID"].ToString()); dvUser = dat.GetDataDV("SELECT * FROM UserPreferences UP, Users U " + "WHERE UP.UserID=U.User_ID AND UP.UserID=" + userID); theLit.Text += "<div style=\"float: left; padding-right: 10px; padding-left: " + "10px; padding-bottom: 5px; padding-top: 5px;\">" + getUserProfile(userID) + "</div>"; content = dat.stripHTML(dv[0]["Content"].ToString()); if (content.Length > 170) content = content.Substring(0, 170) + "..."; theLit.Text += "<div style=\"padding-top: 5px;font-family: Arial; font-size: 12px; color: " + "#cccccc; font-style: italic;\">" + content + " <a style=\"text-decoration: none;\" href=\"" + dat.MakeNiceName(dv[0]["Name"].ToString()) + "_" + dv[0]["GEOID"].ToString() + "_" + dvTopGroupActivity[i]["TheID"].ToString() + "_GroupEvent\"><span class=\"AddPurpleLink\">Read More</span></a></div>"; theLit.Text += postedText; theLit.Text += "<span style=\"font-size: 12px; font-family: arial; color: #cccccc;\">edited by <a href=\"" + dvUser[0]["UserName"].ToString() + "_Friend\" class=\"AddLink\">" + dvUser[0]["UserName"].ToString() + "</a></span> <br/>"; theLit.Text += "<a href=\"" + dat.MakeNiceName(dvGroup[0]["Header"].ToString()) + "_" + dvGroup[0]["ID"].ToString() + "_Group\" class=\"AddPurpleLink\">" + dvGroup[0]["Header"].ToString() + " Group</a></div><div style=\"float: right;\"><img src=\"images/QuoteBottom.png\" /></div></div>"; break; case "GEM": dv = dat.GetDataDV("SELECT *, GEM.UserID AS TheUser, GEO.ID AS GEOID, GE.ID AS EID, GEM.Content AS TheContent FROM GroupEvents GE, " + "GroupEvent_Occurance GEO, GroupEventMessages GEM WHERE GEM.GroupEventID=GE.ID AND " + "GE.ID=GEO.GroupEventID AND GEM.ID=" + dvTopGroupActivity[i]["TheID"].ToString()); userID = dv[0]["TheUser"].ToString(); dvGroup = dat.GetDataDV("SELECT * FROM Groups WHERE ID=" + dv[0]["GroupID"].ToString()); dvUser = dat.GetDataDV("SELECT * FROM UserPreferences UP, Users U " + "WHERE UP.UserID=U.User_ID AND UP.UserID=" + userID); theLit.Text += "<div style=\"float: left; padding-right: 10px; padding-left: " + "10px; padding-bottom: 5px; padding-top: 5px;\">" + getUserProfile(userID) + "</div>"; content = dat.stripHTML(dv[0]["TheContent"].ToString()); if (content.Length > 170) content = content.Substring(0, 170) + "..."; theLit.Text += "<div style=\"padding-top: 5px;font-family: Arial; font-size: 12px; color: " + "#cccccc; font-style: italic;\">" + content + " <a style=\"text-decoration: none;\" href=\"" + dat.MakeNiceName(dv[0]["Name"].ToString()) + "_" + dv[0]["GEOID"].ToString() + "_" + dv[0]["EID"].ToString() + "_GroupEvent\"><span class=\"AddPurpleLink\">Read More</span></a></div>"; theLit.Text += postedText; theLit.Text += "<span style=\"font-size: 12px; font-family: arial; color: #cccccc;\">posted by <a href=\"" + dvUser[0]["UserName"].ToString() + "_Friend\" class=\"AddLink\">" + dvUser[0]["UserName"].ToString() + "</a></span> <br/>"; theLit.Text += "<a href=\"" + dat.MakeNiceName(dvGroup[0]["Header"].ToString()) + "_" + dvGroup[0]["ID"].ToString() + "_Group\" class=\"AddPurpleLink\">" + dvGroup[0]["Header"].ToString() + " Group</a></div><div style=\"float: right;\"><img src=\"images/QuoteBottom.png\" /></div></div>"; break; case "GP": dvG = dat.GetDataDV("SELECT * FROM Groups G WHERE ID=" + dvTopGroupActivity[i]["TheID"].ToString()); userID = dvG[0]["Host"].ToString(); dvUser = dat.GetDataDV("SELECT * FROM UserPreferences UP, Users U " + "WHERE UP.UserID=U.User_ID AND UP.UserID=" + userID); theLit.Text += "<div style=\"float: left; padding-right: 10px; padding-left: " + "10px; padding-bottom: 5px; padding-top: 5px;\">" + getUserProfile(userID) + "</div>"; content = dat.stripHTML(dvG[0]["Content"].ToString()); if (content.Length > 170) content = content.Substring(0, 170) + "..."; theLit.Text += "<div style=\"padding-top: 5px;font-family: Arial; font-size: 12px; color: " + "#cccccc; font-style: italic;\">" + content + " <a style=\"text-decoration: none;\" href=\"" + dat.MakeNiceName(dvG[0]["Header"].ToString()) + "_" + dvTopGroupActivity[i]["TheID"].ToString() + "_Group\"><span class=\"AddPurpleLink\">Read More</span></a></div>"; theLit.Text += postedText; theLit.Text += "<span style=\"font-size: 12px; font-family: arial; color: #cccccc;\">posted by <a href=\"" + dvUser[0]["UserName"].ToString() + "_Friend\" class=\"AddLink\">" + dvUser[0]["UserName"].ToString() + "</a></span> <br/>"; theLit.Text += "<a href=\"" + dat.MakeNiceName(dvG[0]["Header"].ToString()) + "_" + dvG[0]["ID"].ToString() + "_Group\" class=\"AddPurpleLink\">" + dvG[0]["Header"].ToString() + " Group </a></div><div style=\"float: right;\"><img src=\"images/QuoteBottom.png\" /></div></div>"; break; case "GE": dvG = dat.GetDataDV("SELECT * FROM Groups G WHERE ID=" + dvTopGroupActivity[i]["TheID"].ToString()); userID = dvG[0]["Host"].ToString(); dvUser = dat.GetDataDV("SELECT * FROM UserPreferences UP, Users U " + "WHERE UP.UserID=U.User_ID AND UP.UserID=" + userID); theLit.Text += "<div style=\"float: left; padding-right: 10px; padding-left: " + "10px; padding-bottom: 5px; padding-top: 5px;\">" + getUserProfile(userID) + "</div>"; content = dat.stripHTML(dvG[0]["Content"].ToString()); if (content.Length > 170) content = content.Substring(0, 170) + "..."; theLit.Text += "<div style=\"padding-top: 5px;font-family: Arial; font-size: 12px; color: " + "#cccccc; font-style: italic;\">" + content + " <a style=\"text-decoration: none;\" href=\"" + dat.MakeNiceName(dvG[0]["Header"].ToString()) + "_" + dvTopGroupActivity[i]["TheID"].ToString() + "_Group\"><span class=\"AddPurpleLink\">Read More</span></a></div>"; theLit.Text += postedText; theLit.Text += "<span style=\"font-size: 12px; font-family: arial; color: #cccccc;\">edited by <a href=\"" + dvUser[0]["UserName"].ToString() + "_Friend\" class=\"AddLink\">" + dvUser[0]["UserName"].ToString() + "</a></span> <br/>"; theLit.Text += "<a href=\"" + dat.MakeNiceName(dvG[0]["Header"].ToString()) + "_" + dvG[0]["ID"].ToString() + "_Group\" class=\"AddPurpleLink\">" + dvG[0]["Header"].ToString() + " Group </a></div><div style=\"float: right;\"><img src=\"images/QuoteBottom.png\" /></div></div>"; break; case "GT": dvG = dat.GetDataDV("SELECT *, G.ID AS GID FROM Groups G, GroupThreads GT WHERE G.ID=GT.GroupID AND GT.ID=" + dvTopGroupActivity[i]["TheID"].ToString()); userID = dvG[0]["StartedBy"].ToString(); dvUser = dat.GetDataDV("SELECT * FROM UserPreferences UP, Users U " + "WHERE UP.UserID=U.User_ID AND UP.UserID=" + userID); theLit.Text += "<div style=\"float: left; padding-right: 10px; padding-left: " + "10px; padding-bottom: 5px; padding-top: 5px;\">" + getUserProfile(userID) + "</div>"; content = dat.stripHTML("Thread added to the group: " + dvG[0]["ThreadName"].ToString()); if (content.Length > 170) content = content.Substring(0, 170) + "..."; theLit.Text += "<div style=\"padding-top: 5px;font-family: Arial; font-size: 12px; color: " + "#cccccc; font-style: italic;\">" + content + " <a style=\"text-decoration: none;\" href=\"" + dat.MakeNiceName(dvG[0]["Header"].ToString()) + "_" + dvG[0]["GID"].ToString() + "_Group\"><span class=\"AddPurpleLink\">Read More</span></a></div>"; theLit.Text += postedText; theLit.Text += "<span style=\"font-size: 12px; font-family: arial; color: #cccccc;\">added by <a href=\"" + dvUser[0]["UserName"].ToString() + "_Friend\" class=\"AddLink\">" + dvUser[0]["UserName"].ToString() + "</a></span> <br/>"; theLit.Text += "<a href=\"" + dat.MakeNiceName(dvG[0]["Header"].ToString()) + "_" + dvG[0]["GID"].ToString() + "_Group\" class=\"AddPurpleLink\">" + dvG[0]["Header"].ToString() + " Group </a></div><div style=\"float: right;\"><img src=\"images/QuoteBottom.png\" /></div></div>"; break; case "GTC": dvG = dat.GetDataDV("SELECT *, GTC.Content AS TheContent, G.ID AS GID FROM Groups G, " + "GroupThreads GT, GroupThreads_Comments GTC " + "WHERE GTC.ThreadID=GT.ID AND G.ID=GT.GroupID AND GTC.ID=" + dvTopGroupActivity[i]["TheID"].ToString()); userID = dvG[0]["UserID"].ToString(); dvUser = dat.GetDataDV("SELECT * FROM UserPreferences UP, Users U " + "WHERE UP.UserID=U.User_ID AND UP.UserID=" + userID); theLit.Text += "<div style=\"float: left; padding-right: 10px; padding-left: " + "10px; padding-bottom: 5px; padding-top: 5px;\">" + getUserProfile(userID) + "</div>"; content = dat.stripHTML(dvG[0]["TheContent"].ToString()); if (content.Length > 170) content = content.Substring(0, 170) + "..."; theLit.Text += "<div style=\"padding-top: 5px;font-family: Arial; font-size: 12px; color: " + "#cccccc; font-style: italic;\">" + content + " <a style=\"text-decoration: none;\" href=\"" + dat.MakeNiceName(dvG[0]["Header"].ToString()) + "_" + dvG[0]["GID"].ToString() + "_Group\"><span class=\"AddPurpleLink\">Read More</span></a></div>"; theLit.Text += postedText; theLit.Text += "<span style=\"font-size: 12px; font-family: arial; color: #cccccc;\">comment by <a href=\"" + dvUser[0]["UserName"].ToString() + "_Friend\" class=\"AddLink\">" + dvUser[0]["UserName"].ToString() + "</a></span> <br/>"; theLit.Text += "<a href=\"" + dat.MakeNiceName(dvG[0]["Header"].ToString()) + "_" + dvG[0]["GID"].ToString() + "_Group\" class=\"AddPurpleLink\">" + dvG[0]["Header"].ToString() + " Group </a></div><div style=\"float: right;\"><img src=\"images/QuoteBottom.png\" /></div></div>"; break; case "GM": dvG = dat.GetDataDV("SELECT *, G.ID AS GID, GM.Content AS TheContent FROM GroupMessages GM, Groups G WHERE G.ID=GM.GroupID AND GM.ID=" + dvTopGroupActivity[i]["TheID"].ToString()); userID = dvG[0]["UserID"].ToString(); dvUser = dat.GetDataDV("SELECT * FROM UserPreferences UP, Users U " + "WHERE UP.UserID=U.User_ID AND UP.UserID=" + userID); theLit.Text += "<div style=\"float: left; padding-right: 10px; padding-left: " + "10px; padding-bottom: 5px; padding-top: 5px;\">" + getUserProfile(userID) + "</div>"; content = dat.stripHTML(dvG[0]["TheContent"].ToString()); if (content.Length > 170) content = content.Substring(0, 170) + "..."; theLit.Text += "<div style=\"padding-top: 5px;font-family: Arial; font-size: 12px; color: " + "#cccccc; font-style: italic;\">" + content + " <a style=\"text-decoration: none;\" href=\"" + dat.MakeNiceName(dvG[0]["Header"].ToString()) + "_" + dvG[0]["GID"].ToString() + "_Group\"><span class=\"AddPurpleLink\">Read More</span></a></div>"; theLit.Text += postedText; theLit.Text += "<span style=\"font-size: 12px; font-family: arial; color: #cccccc;\">message by <a href=\"" + dvUser[0]["UserName"].ToString() + "_Friend\" class=\"AddLink\">" + dvUser[0]["UserName"].ToString() + "</a></span> <br/>"; theLit.Text += "<a href=\"" + dat.MakeNiceName(dvG[0]["Header"].ToString()) + "_" + dvG[0]["GID"].ToString() + "_Group\" class=\"AddPurpleLink\">" + dvG[0]["Header"].ToString() + " Group </a></div><div style=\"float: right;\"><img src=\"images/QuoteBottom.png\" /></div></div>"; break; default: break; } theLit.Text += "</div></div>"; } GroupsPanel.Controls.Add(theLit); } else { Label lab = new Label(); lab.Text = "There are no groups in your area. To post some <a class=\"AddLink\" href=\"EnterGroup.aspx\">go here</a>"; GroupsLabel.Controls.Add(lab); } } #endregion DataSet ds; if (!IsPostBack) { LocationLabel.Text = ""; if (country != "") country = " AND E.Country = " + country; 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 10 EO.DateTimeStart, E.Header, E.Content, EO.EventID FROM Events E, Event_Occurance EO WHERE E.LIVE='True' AND E.ID=EO.EventID " + country + state + city + " AND EO.DateTimeStart > '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).Date + "' ORDER BY EO.DateTimeStart", types, data); Session["HomeEvents"] = ds; LocationLabel.Text = ""; if (country == "" && state == "" && city == "") { LocationLabel.Text = " The World "; } else { if (city != "") { LocationLabel.Text += cityID; if (state != "") LocationLabel.Text += ", " + stateID; } else { if (state != "") LocationLabel.Text += stateID; } } if (LocationLabel.Text == "") { DataSet dsCountry = dat.GetData("SELECT * FROM Countries WHERE country_id=" + countryID); LocationLabel.Text = dsCountry.Tables[0].Rows[0]["country_name"].ToString(); } } else { EventPanel.Controls.Clear(); LocationLabel.Text = ""; ds = (DataSet)Session["HomeEvents"]; if (countryID == "" && stateID == "" && cityID == "") { LocationLabel.Text = " The World "; } else { if (cityID != "") { LocationLabel.Text += cityID; if (state != "") LocationLabel.Text += ", " + stateID; } else { if (state != "") LocationLabel.Text += stateID; } } //if (RadCalendar1.SelectedDate.ToShortDateString() != "1/1/0001") // LocationLabel.Text += " on " + RadCalendar1.SelectedDate.ToShortDateString(); } ds = (DataSet)Session["HomeEvents"]; if (ds != null) { if (ds.Tables.Count > 0) if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DateTime date = DateTime.Parse(ds.Tables[0].Rows[i]["DateTimeStart"].ToString()); ASP.controls_homeevent_ascx eventH = new ASP.controls_homeevent_ascx(); eventH.DAY = date.DayOfWeek.ToString().Substring(0, 3); eventH.DAY_NUMBER = date.Day.ToString(); eventH.MONTH = dat.GetMonth(date.Month.ToString()).Substring(0, 3); eventH.EVENT_NAME = ds.Tables[0].Rows[i]["Header"].ToString(); if (ds.Tables[0].Rows[i]["Content"].ToString().Length > 150) eventH.SUMMARY = dat.BreakUpString(ds.Tables[0].Rows[i]["Content"].ToString().Substring(0, 150).Replace("<br/>", " "), 67) + "..."; else eventH.SUMMARY = dat.BreakUpString(ds.Tables[0].Rows[i]["Content"].ToString().Replace("<br/>", " "), 67) + "..."; eventH.EVENT_ID = int.Parse(ds.Tables[0].Rows[i]["EventID"].ToString()); EventPanel.Controls.Add(eventH); } } else { Label label = new Label(); label.CssClass = "EventBody"; label.Text = "No events are listed for this date. Sorry. But perhaps you could enter one... <a class=\"AddLink\" href=\"BlogEvent.aspx\">Enter Events</a>."; EventPanel.Controls.Add(label); } else { Label label = new Label(); label.CssClass = "EventBody"; label.Text = "No events are listed for this date. Sorry. But perhaps you could enter one... <a class=\"AddLink\" href=\"BlogEvent.aspx\">Enter Events</a>."; EventPanel.Controls.Add(label); } } else { Label label = new Label(); label.CssClass = "EventBody"; label.Text = "No events are listed for this date. Sorry. But perhaps you could enter one... <a class=\"AddLink\" href=\"BlogEvent.aspx\">Enter Events</a>."; EventPanel.Controls.Add(label); } #region Original Home page code //if (ds.Tables.Count > 0) //{ // if (ds.Tables[0].Rows.Count > 0) // { // ASP.controls_footer_ascx thefooter = (ASP.controls_footer_ascx)dat.FindControlRecursive(this, "TheFooter"); // thefooter.EVENT_ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); // string ID = ds.Tables[0].Rows[0]["ID"].ToString(); // DataSet dsDate = dat.GetData("SELECT * FROM Event_Occurance WHERE EventID=" + ID); // DataSet dsVenue = dat.GetData("SELECT * FROM Venues WHERE ID=" + ds.Tables[0].Rows[0]["Venue"]); // TagCloud.THE_ID = int.Parse(ID); // DataSet dsComments = dat.GetData("SELECT C.BlogDate AS theDate, * FROM Comments C, Users U WHERE U.User_ID=C.UserID AND C.BlogID=" + ID +" ORDER BY C.BlogDate"); // TheComments.DATA_SET = dsComments; // TheComments.DataBind2(true); // if (bool.Parse(ds.Tables[0].Rows[0]["hasSongs"].ToString())) // { // DataSet dsSongs = dat.GetData("SELECT * FROM Event_Song_Mapping WHERE EventID=" + ID); // ASP.controls_songplayer_ascx songs = new ASP.controls_songplayer_ascx(); // int songCount = dsSongs.Tables[0].Rows.Count; // if (songCount > 2) // { // songs.SONG1 = dsSongs.Tables[0].Rows[0]["SongName"].ToString(); // songs.SONG2 = dsSongs.Tables[0].Rows[1]["SongName"].ToString(); // songs.SONG3 = dsSongs.Tables[0].Rows[2]["SongName"].ToString(); // } // else if (songCount > 1) // { // songs.SONG1 = dsSongs.Tables[0].Rows[0]["SongName"].ToString(); // songs.SONG2 = dsSongs.Tables[0].Rows[1]["SongName"].ToString(); // } // else // songs.SONG1 = dsSongs.Tables[0].Rows[0]["SongName"].ToString(); // songs.USER_NAME = ds.Tables[0].Rows[0]["UserName"].ToString(); // SongPanel.Controls.Add(songs); // } // EventName.Text = ds.Tables[0].Rows[0]["Header"].ToString(); // Session["Subject"] = "Re: "+ds.Tables[0].Rows[0]["Header"].ToString(); // Session["CommentSubject"] = "Re: " + ds.Tables[0].Rows[0]["Header"].ToString(); // EventName.NavigateUrl = "~/Event.aspx?EventID=" + ID; // Session["EventID"] = ID; // VenueName.Text = dsVenue.Tables[0].Rows[0]["Name"].ToString(); // VenueName.NavigateUrl = "Venue.aspx?ID="+dsVenue.Tables[0].Rows[0]["ID"].ToString(); // DateTime date = (DateTime)dsDate.Tables[0].Rows[0]["DateTimeStart"]; // DateAndTimeLabel.Text = date.DayOfWeek.ToString() + ", " + GetMonth(date.Month.ToString()) + " " + date.Day + " " + date.Hour + ":" + date.Minute; // string content = ds.Tables[0].Rows[0]["Content"].ToString(); // SendTxtID.MESSAGE = EventName.Text + " occurs at " + VenueName.Text + " on " + DateAndTimeLabel.Text; // string href = Request.Url.AbsoluteUri; // SendEmailID.MESSAGE = "EventName: <a class=\"AddLink\" href=\"" + href + // "\">" + EventName.Text + "</a> \n\r Venue: " + VenueName.Text + // " \n\r Date: " + DateAndTimeLabel.Text + " \n\r " + content; // //if (fillUserData) // //{ // // DataSet ds2 = dat.GetData("SELECT EEL.ExcitmentLevel AS Level FROM User_Calendar UC, Event_ExcitmentLevel EEL WHERE UC.UserID=" // // + Session["User"].ToString() + " AND UC.EventID = " + ID + " AND UC.ExcitmentID=EEL.ID "); // // bool addEvent = false; // // if (ds2.Tables.Count > 0) // // if (ds2.Tables[0].Rows.Count > 0) // // { // // Label label = new Label(); // // label.CssClass = "AddLinkGoing"; // // label.Text = "Guess What?!: you're going to this event and you are " + ds2.Tables[0].Rows[0]["Level"].ToString(); // // CalendarPanel.Controls.Add(label); // // } // // else // // addEvent = true; // // else // // addEvent = true; // // if (addEvent) // // { // // ASP.controls_addtocalendar_ascx AddTo1 = new ASP.controls_addtocalendar_ascx(); // // AddTo1.ID = "AddTo1"; // // AddTo1.TEXT = "Add this event to calendar"; // // AddTo1.EVENT_ID = int.Parse(ID); // // CalendarPanel.Controls.Add(AddTo1); // // } // //} // if (content.Length > 500) // { // ShowDescriptionBegining.Text = content.Substring(0, 500); // int j = 500; // if (content[500] != ' ') // { // while (content[j] != ' ') // { // ShowDescriptionBegining.Text += content[j]; // j++; // } // } // ShowDescriptionBegining.Text = dat.BreakUpString(ShowDescriptionBegining.Text, 65); // ShowRestOfDescription.Text = dat.BreakUpString(content.Substring(j), 65); // } // else // { // ShowDescriptionBegining.Text = dat.BreakUpString(content, 65); // ShowRestOfDescription.Text = ""; // } // //Media Categories: NONE: 0, Picture: 1, Video: 2, YouTubeVideo: 3, Slider: 4 // int mediaCategory = int.Parse(ds.Tables[0].Rows[0]["mediaCategory"].ToString()); // switch (mediaCategory) // { // case 0: // break; // case 1: // ShowVideoPictureLiteral.Text = "<img style=\"float: left; padding-right: 10px; padding-top: 9px;\" height=\"250px\" width=\"440px\" src=\"UserFiles/" + ds.Tables[0].Rows[0]["Picture"].ToString() + "\" />"; // break; // case 2: // ShowVideoPictureLiteral.Text = "<div style=\"float:left; padding-top: 9px; padding-right: 10px;\"><embed height=\"250px\" width=\"440px\" src=\"UserFiles/" + ds.Tables[0].Rows[0]["Video"].ToString() + "\" /></div>"; // break; // case 3: // ShowVideoPictureLiteral.Text = "<div style=\"float:left; padding-top: 9px; padding-right: 10px;\"><object width=\"440\" height=\"250\"><param name=\"movie\" value=\"http://www.youtube.com/v/" + ds.Tables[0].Rows[0]["YouTubeVideo"].ToString() + "\"></param><param name=\"allowFullScreen\" value=\"true\"></param><embed src=\"http://www.youtube.com/v/" + ds.Tables[0].Rows[0]["YouTubeVideo"].ToString() + "\" type=\"application/x-shockwave-flash\" allowfullscreen=\"true\" width=\"440\" height=\"250\"></embed></object></div>"; // break; // case 4: // ShowVideoPictureLiteral.Text = ""; // DataSet dsSlider = dat.GetData("SELECT * FROM Event_Slider_Mapping WHERE EventID=" + ID); // if (dsSlider.Tables.Count > 0) // if (dsSlider.Tables[0].Rows.Count > 0) // { // char[] delim = { '\\' }; // string[] fileArray = System.IO.Directory.GetFiles(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\Slider\\"); // string[] finalFileArray = new string[fileArray.Length]; // for (int i = 0; i < fileArray.Length; i++) // { // int length = fileArray[i].Split(delim).Length; // finalFileArray[i] = "http://" + Request.Url.Authority + "/HippoHappenings/UserFiles/" + Session["UserName"].ToString() + "/Slider/" + fileArray[i].Split(delim)[length - 1]; // } // Rotator1.DataSource = finalFileArray; // Rotator1.DataBind(); // RotatorPanel.Visible = true; // } // break; // default: break; // } // this.Title = EventName.Text; // } //} #endregion } catch (Exception ex) { ErrorLabel.Text = ex.ToString(); } } }