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();
}
}
}
