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