protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
if (cookie == null)
{
cookie = new HttpCookie("BrowserDate");
cookie.Value = DateTime.Now.ToString();
cookie.Expires = DateTime.Now.AddDays(22);
Response.Cookies.Add(cookie);
}
DateTime dateNow = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"));
Data dat = new Data(dateNow);
Literal lit = new Literal();
lit.Text = "<script src=\"http://maps.google.com/maps?file=api&v=2&sensor=false&key=ABQIAAAAjjoxQtYNtdn3Tc17U5-jbBR2Kk_H7gXZZZniNQ8L14X1BLzkNhQjgZq1k-Pxm8FxVhUy3rfc6L9O4g\" type=\"text/javascript\"></script>";
Master.HEAD_TAG.Controls.Add(lit);
try
{
DataView dvGroup = dat.GetDataDV("SELECT * FROM Groups WHERE ID=" + Request.QueryString["ID"].ToString());
Page.Title = dvGroup[0]["Header"].ToString() + " | Hippo Group";
#region Take Care of Style
ColorAa_1.Style.Add("background-color", "#" + dvGroup[0]["ColorA"].ToString());
ColorAb_1.Style.Add("background-color", "#" + dvGroup[0]["ColorA"].ToString());
ColorAa_1.Style.Add("color", "#" + dvGroup[0]["TextA"].ToString());
ColorAa_2.Style.Add("background-color", "#" + dvGroup[0]["ColorA"].ToString());
ColorAb_2.Style.Add("background-color", "#" + dvGroup[0]["ColorA"].ToString());
ColorAa_2.Style.Add("color", "#" + dvGroup[0]["TextA"].ToString());
ColorAa_3.Style.Add("background-color", "#" + dvGroup[0]["ColorA"].ToString());
ColorAb_3.Style.Add("background-color", "#" + dvGroup[0]["ColorA"].ToString());
ColorAa_3.Style.Add("color", "#" + dvGroup[0]["TextA"].ToString());
ColorBa_1.Style.Add("background-color", "#" + dvGroup[0]["ColorB"].ToString());
ColorBb_1.Style.Add("background-color", "#" + dvGroup[0]["ColorB"].ToString());
ColorBa_1.Style.Add("color", "#" + dvGroup[0]["TextB"].ToString());
ColorBa_2.Style.Add("background-color", "#" + dvGroup[0]["ColorB"].ToString());
ColorBb_2.Style.Add("background-color", "#" + dvGroup[0]["ColorB"].ToString());
ColorBa_2.Style.Add("color", "#" + dvGroup[0]["TextB"].ToString());
RadScheduler1.BorderColor = System.Drawing.ColorTranslator.FromHtml("#" + dvGroup[0]["ColorB"].ToString());
ScriptLiteral.Text = "<style type=\"text/css\">.RadScheduler .rsTodayCell {border: solid 1px #" +
dvGroup[0]["ColorA"].ToString() + " !important;}</style>";
#endregion
if (!IsPostBack)
{
Session["RedirectTo"] = Request.Url.AbsoluteUri;
}
string country = dat.GetDataDV("SELECT * FROM Countries WHERE country_id=" + dvGroup[0]["Country"].ToString())[0]["country_name"].ToString();
Literal liter = new Literal();
liter.Text = "<link type=\"text/css\" href=\"Rads_Groups.css\" rel=\"stylesheet\" />"+
"<style type=\"text/css\">.RadTabStrip_Telerik{border-bottom:1px solid #666666;}</style>";
Page.Header.Controls.AddAt(0, liter);
bool isMember = false;
#region Take care of user types
if (Session["User"] != null)
{
//Take care of Share with friends and Share though email and Flag
LoggedInPanel.Visible = true;
ShareFriends.THE_TEXT = "Share this with a friend";
ShareFriends.RE_LABEL = "Re: " + Session["UserName"].ToString() +
" would like to share the group '\"" + dat.BreakUpString(dvGroup[0]["Header"].ToString(), 14) +
"\"' with you.";
ShareFriends.TYPE = "g";
ShareFriends.ID = int.Parse(Request.QueryString["ID"].ToString());
string descrip = dvGroup[0]["Content"].ToString();
if(descrip.Length > 200)
descrip = descrip.Substring(0, 200) + "...";
Session["messageEmail"] = "Group Name: <a href=\"http://hippohappenings.com/" +
dat.MakeNiceName(dat.BreakUpString(dvGroup[0]["Header"].ToString(), 14)) + "_" +
Request.QueryString["ID"].ToString() + "_Group\">" +
dat.BreakUpString(dvGroup[0]["Header"].ToString(), 14) + "</a> <br/><br/> " +
descrip;
Session["FlagID"] = Request.QueryString["ID"].ToString();
Session["FlagType"] = "G";
if (bool.Parse(dvGroup[0]["isPrivate"].ToString()))
PrivateLabel.Text = "Private Group";
else
PrivateLabel.Text = "Public Group";
DataView dvMember = dat.GetDataDV("SELECT * FROM Group_Members WHERE GroupID=" +
Request.QueryString["ID"].ToString() + " AND Accepted='True' AND MemberID=" + Session["User"].ToString());
PostMessageID.Attributes.Add("onclick", "OpenMess('" + Request.QueryString["ID"].ToString() + "')");
if (dvMember.Count > 0)
{
if (bool.Parse(dvMember[0]["SharedHosting"].ToString()))
{
isMember = true;
Session["isHost"] = true;
HostHeaderPanel.Visible = true;
AddEventButton2.Visible = true;
MemberHeaderPanel.Visible = false;
//if is host, take care of host options
LinkButton1.Attributes.Add("onclick", "OpenInvite('" + Request.QueryString["ID"].ToString() + "')");
LinkButton2.Attributes.Add("onclick", "OpenPrefs('" + Request.QueryString["ID"].ToString() + "')");
LinkButton3.PostBackUrl = "EnterGroup.aspx?ID=" + Request.QueryString["ID"].ToString();
LinkButton4.PostBackUrl = "EnterGroupEvent.aspx?GroupID=" + Request.QueryString["ID"].ToString();
AddEventButton2.PostBackUrl = "EnterGroupEvent.aspx?GroupID=" + Request.QueryString["ID"].ToString();
LinkButton8.Attributes.Add("onclick", "OpenThread('" + Request.QueryString["ID"].ToString() + "')");
Label1.Attributes.Add("onclick", "OpenSendMess('" + Request.QueryString["ID"].ToString() + "')");
}
else
{
isMember = true;
Session["isHost"] = false;
Session["isMember"] = true;
HostHeaderPanel.Visible = false;
AddEventButton2.Visible = false;
MemberHeaderPanel.Visible = true;
Label2.Attributes.Add("onclick", "OpenThread('" + Request.QueryString["ID"].ToString() + "')");
}
PostMessagePanel.Visible = true;
Button2.Visible = false;
}
else
{
Session["isHost"] = false;
Session["isMember"] = false;
HostHeaderPanel.Visible = false;
AddEventButton2.Visible = false;
MemberHeaderPanel.Visible = false;
PostMessagePanel.Visible = false;
Button2.Attributes.Add("onclick", "OpenJoin('" + Request.QueryString["ID"].ToString() + "')");
}
}
else
{
Session["isHost"] = false;
Session["isMember"] = false;
HostHeaderPanel.Visible = false;
AddEventButton2.Visible = false;
MemberHeaderPanel.Visible = false;
PostMessagePanel.Visible = false;
Button2.Attributes.Add("onclick", "OpenJoin('" + Request.QueryString["ID"].ToString() + "')");
}
#endregion
#region Contact Info
CityStateZipLabel.Text = dvGroup[0]["City"].ToString() + ", " + dvGroup[0]["State"].ToString() + " " + dvGroup[0]["Zip"].ToString();
if (dvGroup[0]["Phone"].ToString().Trim() != "")
{
PhoneLabel.Text = "Phone: " + dvGroup[0]["Phone"].ToString() + "<br/>";
GroupContactInfoLabel.Visible = true;
}
if (dvGroup[0]["Email"].ToString().Trim() != "")
{
EmailLabel.Text = "Email: " + dvGroup[0]["Email"].ToString() + "<br/>";
GroupContactInfoLabel.Visible = true;
}
if (dvGroup[0]["Web"].ToString().Trim() != "")
{
WebLabel.Text = "Web: " + dvGroup[0]["Web"].ToString();
GroupContactInfoLabel.Visible = true;
}
if (dvGroup[0]["HostInstructions"].ToString() != null)
{
if (dvGroup[0]["HostInstructions"].ToString().Trim() != "")
{
HostTitleInstructionsLabel.Visible = true;
HostInstructionsLabel.Text = dvGroup[0]["HostInstructions"].ToString().Trim();
}
}
#endregion
#region Members
DataView dvMainHost = dat.GetDataDV("SELECT * FROM Groups G, Group_Members GM, Users U "+
"WHERE GM.MemberID=U.User_ID AND GM.GroupID=G.ID AND G.ID=" +
Request.QueryString["ID"].ToString() + " AND G.Host=U.User_ID");
DataView dvHosts = dat.GetDataDV("SELECT * FROM Group_Members GM, Users U WHERE GM.GroupID=" +
Request.QueryString["ID"].ToString() + " AND GM.MemberID=U.User_ID AND GM.Accepted='True' " +
"AND GM.SharedHosting='True' AND GM.MemberID <> " + dvMainHost[0]["User_ID"].ToString());
DataView dvMembers = dat.GetDataDV("SELECT * FROM Group_Members GM, Users U WHERE GM.GroupID=" +
Request.QueryString["ID"].ToString() + " AND GM.MemberID=U.User_ID AND GM.Accepted='True' "+
"AND GM.SharedHosting='False' ORDER BY U.UserName");
string members = "";
string friendImg = "";
string strFill = "";
string title = "";
string description = "";
foreach (DataRowView row in dvMainHost)
{
GetMemberString(ref members, row, dvGroup);
}
foreach (DataRowView row in dvHosts)
{
GetMemberString(ref members, row, dvGroup);
}
foreach (DataRowView row in dvMembers)
{
GetMemberString(ref members, row, dvGroup);
}
if (dvMembers.Count + dvMainHost.Count + dvHosts.Count > 6)
{
lit = new Literal();
lit.Text = members;
MembersPanel.Controls.Add(lit);
MembersPanel.Visible = true;
}
else
{
MembersLiteral.Text = members;
}
#endregion
DataView dvUser = dat.GetDataDV("SELECT * FROM Users WHERE User_ID=" + dvGroup[0]["Host"].ToString());
EventName.Text = dvGroup[0]["Header"].ToString();
#region Group Message Board
DataView dvMessages = dat.GetDataDV("SELECT *, GM.ID AS MessageID FROM GroupMessages GM, Users U WHERE GM.GroupID=" +
Request.QueryString["ID"].ToString() + " AND GM.UserID=U.User_ID");
DataView dvSticky = dat.GetDataDV("SELECT *, GM.ID AS MessageID FROM GroupMessages GM, Group_Members M, Users U WHERE GM.GroupID=" +
Request.QueryString["ID"].ToString() + " AND GM.UserID=U.User_ID and M.GroupID=" +
Request.QueryString["ID"].ToString() + " AND M.MemberID=U.User_ID AND M.SharedHosting='True' AND GM.isSticky='True'");
members = "";
friendImg = "";
strFill = "";
description = "";
string stickyID = "";
if (dvSticky.Count > 0)
{
dvSticky.Sort = "DatePosted DESC";
stickyID = dvSticky[0]["MessageID"].ToString();
if (System.IO.File.Exists(Server.MapPath(".") + "\\UserFiles\\" + dvSticky[0]["UserName"].ToString() +
"\\Profile\\" + dvSticky[0]["ProfilePicture"].ToString()))
{
friendImg = "UserFiles/" + dvSticky[0]["UserName"].ToString() + "/Profile/" + dvSticky[0]["ProfilePicture"].ToString();
strFill = "";
}
else
{
friendImg = "image/noAvatar_50x50_small.png";
strFill = "onmouseover=\"this.src='NewImages/noAvatar_50x50_smallhover.png'\"" +
"onmouseout=\"this.src='image/noAvatar_50x50_small.png'\" ";
}
string imgLit = "";
if (Session["User"] != null)
{
if (Session["User"].ToString() == dvSticky[0]["User_ID"].ToString())
{
imgLit = "<div style=\"float: right;\"><img style=\"cursor: pointer;\" name=\"remove stickyness\" src=\"image/X.png\" onclick=\"OpenRemoveSticky('" + Request.QueryString["ID"].ToString() +
"');\" onmouseout=\"this.src = 'image/X.png';\" " +
"onmouseover=\"this.src = 'image/XSelected.png';\" /></div>";
}
}
members = "<div style=\"border-bottom: solid 1px #1b1b1b;float: left; clear: both; padding-left: 3px; padding-top: 5px;\">" + imgLit +
"<a target='_blank' href=\"" + dvSticky[0]["UserName"].ToString() + "_Friend\"><img " + strFill +
" style=\" border: 0;float: left;padding-right: 7px; padding-bottom: 2px;\" " +
"src=\"" + friendImg + "\" width=\"50px\" height=\"50px\" /></a>"+
"<div style=\"float: left;\"><div style=\"height: 19px; background-position: left; background-repeat: no-repeat; background-image: url(images/UserNameLeft.png); "+
"padding-left: 4px;\"><div style=\"height: 19px; background-repeat: no-repeat; background-position: right; "+
"background-image: url(images/UserNameRight.png); "+
"padding-right: 4px;\"><div style=\"height: 19px; background-repeat: repeat-x; " +
"background-image: url(images/UserNameMiddle.png);\"><a style=\"float: left;\" href=\"" +
dvSticky[0]["UserName"].ToString() + "_Friend\" " +
"class=\"MemberName\">" +
dvSticky[0]["UserName"].ToString() +
"</a></div></div></div></div><span class=\"MemberTitle\" style=\"color: #" + dvGroup[0]["TextB"].ToString() + " !important;\"> - Posted On: " +
dvSticky[0]["DatePosted"].ToString().Trim() +
"</span> - <span style=\"color: #ff6b09; font-size: 30px;font: bold;\">!</span>" +
"<span class=\"MemberDescription\" style=\"color: #" + dvGroup[0]["TextB"].ToString() + " !important;\"> " + dvSticky[0]["Content"].ToString() +
"</span><span style=\"font: bold;color: #ff6b09; font-size: 30px;\">!</span></div>";
StickyMessageLiteral.Text = members;
}
members = "";
if (stickyID != "")
{
dvMessages.RowFilter = "MessageID <> " + stickyID;
}
if (dvMessages.Count == 0)
{
lit = new Literal();
lit.Text = "<div class=\"MemberDescription\" style=\"color: #" + dvGroup[0]["TextB"].ToString() + " !important;\">No messages have been posted for this group.</div>";
MessagesPanel.Controls.Add(lit);
}
else
{
dvMessages.Sort = "DatePosted DESC";
foreach (DataRowView row in dvMessages)
{
if (System.IO.File.Exists(Server.MapPath(".") + "\\UserFiles\\" + row["UserName"].ToString() +
"\\Profile\\" + row["ProfilePicture"].ToString()))
{
friendImg = "UserFiles/" + row["UserName"].ToString() + "/Profile/" + row["ProfilePicture"].ToString();
strFill = "";
}
else
{
friendImg = "image/noAvatar_50x50_small.png";
strFill = "onmouseover=\"this.src='NewImages/noAvatar_50x50_smallhover.png'\"" +
"onmouseout=\"this.src='image/noAvatar_50x50_small.png'\" ";
}
description = "<span class=\"MemberDescription\" style=\"color: #" + dvGroup[0]["TextB"].ToString() + " !important;\"> " + row["Content"].ToString().Trim() + "</span>";
members += "<div style=\"float: left; clear: both; padding-left: 3px; padding-top: 5px;\"><a target='_blank' href=\"" + row["UserName"].ToString() + "_Friend\"><img " + strFill +
" style=\" border: 0;float: left;padding-right: 7px; padding-bottom: 2px;\" " +
"src=\"" + friendImg + "\" width=\"50px\" height=\"50px\" /></a>"+
"<div style=\"float: left;\"><div style=\"height: 19px; background-position: left; background-repeat: no-repeat; background-image: url(images/UserNameLeft.png); " +
"padding-left: 4px;\"><div style=\"height: 19px; background-repeat: no-repeat; background-position: right; " +
"background-image: url(images/UserNameRight.png); " +
"padding-right: 4px;\"><div style=\"height: 19px; background-repeat: repeat-x; " +
"background-image: url(images/UserNameMiddle.png);\"><a style=\"float: left;\" href=\"" + row["UserName"].ToString() + "_Friend\" class=\"MemberName\">" +
row["UserName"].ToString() + "</a></div></div></div></div><span class=\"MemberTitle\" style=\"color: #" + dvGroup[0]["TextB"].ToString() +
" !important;\"> - Posted On: " + row["DatePosted"].ToString().Trim() + "</span> - " + description + "</div>";
}
lit = new Literal();
lit.Text = members;
MessagesPanel.Controls.Add(lit);
}
#endregion
#region Take care of images and youtube
char[] delim4 = { ';' };
DataView dsSlider = dat.GetDataDV("SELECT * FROM Group_Slider_Mapping WHERE GroupID=" + Request.QueryString["ID"].ToString());
if (dsSlider.Count > 0)
{
char[] delim = { '\\' };
char[] delim3 = { '.' };
for (int i = 0; i < dsSlider.Count; i++)
{
string caption = "";
if (dsSlider[i]["Caption"] != null)
{
if (dsSlider[i]["Caption"].ToString().Trim() != "")
{
caption = "<div class=\"CaptionText\">" + dsSlider[i]["Caption"].ToString().Trim() + "</div>";
}
}
string[] tokens = dsSlider[i]["PictureName"].ToString().Split(delim3);
//dsSlider.RowFilter = "RealPictureName='" + tokens[0] + "." + tokens[1] + "'";
if (tokens.Length >= 2)
{
if (tokens[1].ToUpper() == "JPG" || tokens[1].ToUpper() == "JPEG" || tokens[1].ToUpper() == "GIF" || tokens[1].ToUpper() == "PNG")
{
System.Drawing.Image image = System.Drawing.Image.FromFile(MapPath(".") +
"\\GroupFiles\\" + Request.QueryString["ID"].ToString() + "\\Slider\\" + dsSlider[i]["PictureName"].ToString());
int width = 400;
int height = 250;
int newHeight = 0;
int newIntWidth = 0;
//if image height is less than resize height
if (height >= image.Height)
{
//leave the height as is
newHeight = image.Height;
if (width >= image.Width)
{
newIntWidth = image.Width;
}
else
{
newIntWidth = width;
double theDivider = double.Parse(image.Width.ToString()) / double.Parse(newIntWidth.ToString());
double newDoubleHeight = double.Parse(newHeight.ToString());
newDoubleHeight = double.Parse(height.ToString()) / theDivider;
newHeight = (int)newDoubleHeight;
}
}
//if image height is greater than resize height...resize it
else
{
//make height equal to the requested height.
newHeight = height;
//get the ratio of the new height/original height and apply that to the width
double theDivider = double.Parse(image.Height.ToString()) / double.Parse(newHeight.ToString());
double newDoubleWidth = double.Parse(newIntWidth.ToString());
newDoubleWidth = double.Parse(image.Width.ToString()) / theDivider;
newIntWidth = (int)newDoubleWidth;
//if the resized width is still to big
if (newIntWidth > width)
{
//make it equal to the requested width
newIntWidth = width;
//get the ratio of old/new width and apply it to the already resized height
theDivider = double.Parse(image.Width.ToString()) / double.Parse(newIntWidth.ToString());
double newDoubleHeight = double.Parse(newHeight.ToString());
newDoubleHeight = double.Parse(image.Height.ToString()) / theDivider;
newHeight = (int)newDoubleHeight;
}
}
Literal literal4 = new Literal();
literal4.Text = "<div style=\"width: 400px; height: 250px;background-color: black;\">" +
"<img align=\"middle\" style=\"cursor: pointer; margin-left: " +
((400 - newIntWidth) / 2).ToString() + "px; margin-top: " +
((250 - newHeight) / 2).ToString() + "px;\" height=\"" + newHeight +
"px\" width=\"" + newIntWidth + "px\" height=\"" + height.ToString() + "px\" width=\"" + width.ToString() +
"px\" src=\"" + "GroupFiles/" + Request.QueryString["ID"].ToString() + "/Slider/" + dsSlider[i]["PictureName"].ToString() +
"\" /></div>" + caption;
Telerik.Web.UI.RadRotatorItem r4 = new Telerik.Web.UI.RadRotatorItem();
r4.Controls.Add(literal4);
Rotator1.Items.Add(r4);
}
}
else
{
Literal literal3 = new Literal();
literal3.Text = "<div class=\"topDiv\"><div style=\"float:left;background-color: black;\"><object width=\"400\" height=\"250\"><param name=\"wmode\" value=\"opaque\" ></param><param name=\"movie\" value=\"http://www.youtube.com/v/" + dsSlider[i]["PictureName"].ToString() +
"\"></param><param name=\"allowFullScreen\" value=\"true\"></param><embed wmode=\"opaque\" src=\"http://www.youtube.com/v/" + dsSlider[i]["PictureName"].ToString() +
"\" type=\"application/x-shockwave-flash\" allowfullscreen=\"true\" width=\"400\" height=\"250\"></embed></object></div>" + caption + "</div>";
Telerik.Web.UI.RadRotatorItem r3 = new Telerik.Web.UI.RadRotatorItem();
r3.Controls.Add(literal3);
Rotator1.Items.Add(r3);
}
}
}
if (Rotator1.Items.Count == 0)
RotatorPanel.Visible = false;
else
{
RotatorPanel.Visible = true;
if (Rotator1.Items.Count == 1)
{
RotatorPanel.CssClass = "HiddeButtons";
}
}
#endregion
#region Take care of events
//RadScheduler1.DataSource = dat.GetData("SELECT GEO.DateTimeStart, SUBSTRING(GE.Name, 0, 8) + ' ...' AS Name , GEO.DateTimeEnd, CONVERT(NVARCHAR,GE.ID) + ';'+CONVERT(NVARCHAR,GEO.ID) AS ID FROM GroupEvent_Occurance GEO, GroupEvents GE WHERE GEO.GroupEventID=GE.ID AND GE.GroupID=" + Request.QueryString["ID"].ToString());
if (!IsPostBack)
{
if (isMember)
{
RadScheduler1.DataSource = dat.GetData("SELECT CONVERT(NVARCHAR,MONTH(GEO.DateTimeStart)) + '/' + " +
"CONVERT(NVARCHAR,DAY(GEO.DateTimeStart)) + '/' + " +
"CONVERT(NVARCHAR,YEAR(GEO.DateTimeStart)) + ' 12:00:00' AS DateStart, " +
"CONVERT(NVARCHAR,COUNT(CONVERT(NVARCHAR,MONTH(GEO.DateTimeStart)) + '/' + " +
"CONVERT(NVARCHAR,DAY(GEO.DateTimeStart)) + '/' +" +
"CONVERT(NVARCHAR,YEAR(GEO.DateTimeStart)))) + CASE WHEN COUNT(CONVERT(NVARCHAR,MONTH(GEO.DateTimeStart)) + '/' + " +
"CONVERT(NVARCHAR,DAY(GEO.DateTimeStart)) + '/' +" +
"CONVERT(NVARCHAR,YEAR(GEO.DateTimeStart))) > 1 THEN ' events' ELSE ' event' END AS Name FROM " +
"GroupEvent_Occurance GEO, GroupEvents GE WHERE GE.LIVE='True' AND GEO.GroupEventID=GE.ID " +
"AND GE.GroupID=" + Request.QueryString["ID"].ToString() +
" GROUP BY CONVERT(NVARCHAR,MONTH(GEO.DateTimeStart)) + '/' + " +
"CONVERT(NVARCHAR,DAY(GEO.DateTimeStart)) + '/' +" +
"CONVERT(NVARCHAR,YEAR(GEO.DateTimeStart))");
}
else
{
RadScheduler1.DataSource = dat.GetData("SELECT CONVERT(NVARCHAR,MONTH(GEO.DateTimeStart)) + '/' + " +
"CONVERT(NVARCHAR,DAY(GEO.DateTimeStart)) + '/' + " +
"CONVERT(NVARCHAR,YEAR(GEO.DateTimeStart)) + ' 12:00:00' AS DateStart, " +
"CONVERT(NVARCHAR,COUNT(CONVERT(NVARCHAR,MONTH(GEO.DateTimeStart)) + '/' + " +
"CONVERT(NVARCHAR,DAY(GEO.DateTimeStart)) + '/' +" +
"CONVERT(NVARCHAR,YEAR(GEO.DateTimeStart)))) + CASE WHEN COUNT(CONVERT(NVARCHAR,MONTH(GEO.DateTimeStart)) + '/' + " +
"CONVERT(NVARCHAR,DAY(GEO.DateTimeStart)) + '/' +" +
"CONVERT(NVARCHAR,YEAR(GEO.DateTimeStart))) > 1 THEN ' events' ELSE ' event' END AS Name FROM " +
"GroupEvent_Occurance GEO, GroupEvents GE WHERE GE.LIVE='True' AND GE.EventType=1 AND GEO.GroupEventID=GE.ID " +
"AND GE.GroupID=" + Request.QueryString["ID"].ToString() +
" GROUP BY CONVERT(NVARCHAR,MONTH(GEO.DateTimeStart)) + '/' + " +
"CONVERT(NVARCHAR,DAY(GEO.DateTimeStart)) + '/' +" +
"CONVERT(NVARCHAR,YEAR(GEO.DateTimeStart))");
}
RadScheduler1.DataBind();
RadScheduler1.SelectedDate = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"));
//RadScheduler1.SelectedDate = DateTime.Parse("8/9/2010 23:13:00");
MonthLabel.Text = dat.GetMonth(RadScheduler1.SelectedDate.Month.ToString());
//MonthLabel.Text += " "+RadScheduler1.SelectedDate.ToString();
}
#endregion
//Do this before unread threads are marked as read
if (Session["User"] != null)
{
DataView ThreadsRead = dat.GetDataDV("SELECT * FROM ThreadRead TH, GroupThreads GT WHERE TH.UserID=" +
Session["User"].ToString() + " AND TH.[Read] = 'False' AND GT.GroupID=" + Request.QueryString["ID"].ToString() +
" AND GT.ID=TH.ThreadID ");
if (ThreadsRead.Count > 0)
RadTabStrip1.Tabs[1].Text = "<div id=\"BiggerNewDiv\" style=\"float: left;display: block;font-weight: bold;color: #ff6b09;font-size: 12px;" +
"\"><div style=\"float: left;\">(</div><div style=\"float: left\" id=\"NewThreadDiv\">" +
ThreadsRead.Count.ToString() +
"</div> unread)</div> <span onclick='HideSocial()'>Stuff We Talk About</span>";
}
#region Take care of threads
SortDropDown.Items[1].Attributes.Add("onclick", "ShowLoading();");
SortDropDown.Items[2].Attributes.Add("onclick", "ShowLoading();");
SortDropDown.Items[3].Attributes.Add("onclick", "ShowLoading();");
SortThreads(SortDropDown, new EventArgs());
#endregion
//other details
//TagCloud.THE_ID = int.Parse(Request.QueryString["ID"].ToString());
GroupDescriptionLabel.Text = dvGroup[0]["Content"].ToString();
//Fix calendar timezone
RadScheduler1.TimeZoneOffset = -(DateTime.UtcNow.Subtract(dateNow));
HostLabel.Text = dvUser[0]["UserName"].ToString();
HostLabel.NavigateUrl = HostLabel.Text + "_Friend";
#region Take care of map
HttpCookie cookie2 = new HttpCookie("addressParameterName");
cookie2.Value = dvGroup[0]["Header"].ToString();
cookie2.Expires = DateTime.Now.AddDays(22);
Response.Cookies.Add(cookie2);
string address = "";
if (dvGroup[0]["Address"] != null)
{
if (dvGroup[0]["Address"].ToString() != "")
{
address = dat.GetAddress(dvGroup[0]["Address"].ToString(), dvGroup[0]["Country"].ToString() != "223");
}
}
cookie2 = new HttpCookie("addressParameter");
cookie2.Value = address + " " + dvGroup[0]["City"].ToString() + " " + dvGroup[0]["State"].ToString() +
" " + dvGroup[0]["Zip"].ToString() + " " + country;
cookie2.Expires = DateTime.Now.AddDays(22);
Response.Cookies.Add(cookie2);
Literal lit2 = new Literal();
lit2.Text = "<script src=\"http://maps.google.com/maps?file=api&v=2&sensor=false&key=ABQIAAAAjjoxQtYNtdn3Tc17U5-jbBR2Kk_H7gXZZZniNQ8L14X1BLzkNhQjgZq1k-Pxm8FxVhUy3rfc6L9O4g\" type=\"text/javascript\"></script>";
Page.Header.Controls.Add(lit2);
Master.BodyTag.Attributes.Add("onload", "initialize();");
Master.BodyTag.Attributes.Add("onunload", "GUnload()");
#endregion
#region Take care of main image
bool doVertical = false;
if (dvGroup[0]["MainPicture"] != null)
{
if (dvGroup[0]["MainPicture"].ToString().Trim() != "")
{
ImageLiteral.Text = "<div style=\"width: 200px;\"><div";
GroupMainImage.ImageUrl = "GroupFiles/" + dvGroup[0]["ID"].ToString() + "/Slider/" + dvGroup[0]["MainPicture"].ToString().Trim();
System.Drawing.Image img = System.Drawing.Image.FromFile(Server.MapPath("GroupFiles/" + dvGroup[0]["ID"].ToString() + "/Slider/" + dvGroup[0]["MainPicture"].ToString().Trim()));
if (img.Height < 200)
{
string toDivide = ((200 - img.Height) / 2).ToString();
ImageLiteral.Text += " style=\" padding-top: 10px; " + "\" ";
if (img.Width < 200)
{
string toDivide2 = ((200 - img.Width) / 2).ToString();
ImageLiteral.Text += " padding-left: " + toDivide2 + "px;" + "\" ";
}
}
else if (img.Width < 200)
{
string toDivide2 = ((200 - img.Width) / 2).ToString();
ImageLiteral.Text += " style=\" padding-left: " + toDivide2 + "px;" + "\" ";
}
ImageLiteral.Text += ">";
ImageLiteralBottom.Text = "</div></div>";
//Digg
DiggLiteral.Text = "<table style=\"padding-top: 5px;\">" +
" <tr> " +
" <td valign=\"bottom\" style=\"padding-right: 0px;\">" +
" <a name=\"fb_share\" type=\"button\" " +
"href=\"http://www.facebook.com/sharer.php\">Share</a>" +
"<script src=\"http://static.ak.fbcdn.net/connect.php/js/FB.Share\"" +
" type=\"text/javascript\"></script>" +
" </td> " +
" <td valign=\"bottom\" style=\"padding-right: 0px;\"> " +
" <a style=\"border: 0; padding: 0; margin: 0;\" " +
"id=\"TweeterA\" title=\"Click to send this page to Twitter!\" " +
"target=\"_blank\" rel=\"nofollow\"><img style=\"border: 0; " +
"padding: 0; margin: 0;\" " +
"src=\"http://twitter-badges.s3.amazonaws.com/twitter-a.png\" " +
"alt=\"Share on Twitter\"/></a> " +
"</td> " +
"<td valign=\"bottom\">" +
" <a href=\"javascript:void(window.open('http://www.myspace.com/Modules/PostTo/Pages/?u='+encodeURIComponent(document.location.toString()),'ptm','height=450,width=440').focus())\"> " +
" <img style=\"position: relative; top: 2px\" " +
"src=\"http://cms.myspacecdn.com/cms/ShareOnMySpace/small.png\" " +
"border=\"0\" alt=\"Share on MySpace\" /> " +
" </a> " +
"</td> " +
"</tr> " +
" <tr> " +
" <td valign=\"bottom\" colspan=\"3\" align=\"center\"> " +
" <table cellpadding=\"5px\"> " +
" <tr> " +
" <td><a alt=\"Digg it!\" class=\"DiggThisButton DiggIcon\" id=\"dibbButt\"" +
"href='http://digg.com/submit?phase=2&url=" + "http://" +
Request.Url.Authority + "/" +
dat.MakeNiceName(dvGroup[0]["Header"].ToString()) +
"_" + Request.QueryString["ID"].ToString() + "_Group" +
"' target=\"_blank\">Digg</a>" +
"</td>" +
"<td>" +
"<a href=\"http://delicious.com/save\" onclick=\"window.open('http://delicious.com/save?v=5&noui&jump=close&url='+encodeURIComponent(location.href)+'&title='+encodeURIComponent(document.title), 'delicious','toolbar=no,width=550,height=550'); return false;\"> " +
"<img border=\"0\" src=\"http://static.delicious.com/img/delicious.small.gif\" height=\"10\" width=\"10\" alt=\"Delicious\" /> " +
" </a> " +
" </td> " +
"<td> " +
"<script src=\"http://www.stumbleupon.com/hostedbadge.php?s=4\"></script>" +
"</td>" +
"</tr>" +
"</table>" +
"</td>" +
"<td></td>" +
" </tr>" +
" </table>";
SocialsVertical.Visible = false;
SocialsHorizontal.Visible = true;
}
else
{
doVertical = true;
GroupMainImage.Visible = false;
}
}
else
{
doVertical = true;
GroupMainImage.Visible = false;
}
if (doVertical)
{
//Digg
DiggLiteralVertical.Text = "<table style=\"padding-top: 50px; padding-left: 70px;\">" +
"<tr> " +
"<td valign=\"bottom\" style=\"padding-right: 0px;\">" +
" <a name=\"fb_share\" type=\"button\" href=\"http://www.facebook.com/sharer.php\">Share</a><script src=\"http://static.ak.fbcdn.net/connect.php/js/FB.Share\" type=\"text/javascript\"></script>" +
"</td>" +
"</tr>" +
" <tr>" +
" <td valign=\"bottom\" style=\"padding-right: 0px;\">" +
" <a style=\"border: 0; padding: 0; margin: 0;\" id=\"A1\" title=\"Click to send this page to Twitter!\" target=\"_blank\" rel=\"nofollow\"><img style=\"border: 0; padding: 0; margin: 0;\" src=\"http://twitter-badges.s3.amazonaws.com/twitter-a.png\" alt=\"Share on Twitter\"/></a>" +
" </td>" +
"</tr>" +
"<tr>" +
" <td valign=\"bottom\">" +
" <a href=\"javascript:void(window.open('http://www.myspace.com/Modules/PostTo/Pages/?u='+encodeURIComponent(document.location.toString()),'ptm','height=450,width=440').focus())\">" +
" <img src=\"http://cms.myspacecdn.com/cms/ShareOnMySpace/small.png\" border=\"0\" alt=\"Share on MySpace\" />" +
" </a>" +
" </td>" +
" </tr>" +
" <tr>" +
" <td valign=\"bottom\"> <a alt=\"Digg it!\" class=\"DiggThisButton DiggIcon\" id=\"dibbButt\"" +
"href='http://digg.com/submit?phase=2&url=" + "http://" +
Request.Url.Authority + "/" +
dat.MakeNiceName(dvGroup[0]["Header"].ToString()) +
"_" + Request.QueryString["ID"].ToString() + "_Group" +
"' target=\"_blank\">Digg</a> " +
" <a href=\"http://delicious.com/save\" onclick=\"window.open('http://delicious.com/save?v=5&noui&jump=close&url='+encodeURIComponent(location.href)+'&title='+encodeURIComponent(document.title), 'delicious','toolbar=no,width=550,height=550'); return false;\">" +
" <img border=\"0\" src=\"http://static.delicious.com/img/delicious.small.gif\" height=\"10\" width=\"10\" alt=\"Delicious\" />" +
"</a>" +
" <script src=\"http://www.stumbleupon.com/hostedbadge.php?s=4\"></script>" +
" </td>" +
" </tr>" +
" </table>";
SocialsHorizontal.Visible = false;
SocialsVertical.Visible = true;
}
#endregion
}
catch (Exception ex)
{
ErrorLabel.Text = ex.ToString();
}
}
protected string[] GetEventLiteral(DataView dvEvents, Data dat, int numOfRecordsPerPage)
{
string message = "";
int startIndex = 0;
//int pageNum = int.Parse(Request.QueryString["page"].ToString());
//int endIndex = numOfRecordsPerPage - 1;
//startIndex = numOfRecordsPerPage * pageNum;
//if (endIndex > dvEvents.Count - 1)
// endIndex = dvEvents.Count - 1;
//int thecount = numOfRecordsPerPage;
//if (endIndex != numOfRecordsPerPage - 1)
// thecount = endIndex - startIndex;
int numberInArray = dvEvents.Count / numOfRecordsPerPage;
if (dvEvents.Count % numOfRecordsPerPage != 0)
numberInArray++;
string oneStringRecord = "";
int normalRecordCount = 0;
int countInArray = 0;
string[] theArray = new string[numberInArray];
TopLiteral.Text = "";
string temp = "";
try
{
Hashtable normalEventHash = new Hashtable();
int i = 0;
string funcCount = "";
string theLiteral = "<script type=\"text/javascript\">function initialize" +
(countInArray + 1).ToString() + "(){ initMap(); " +
" if(map != null && map != undefined) " +
" { var address;";
string address = "";
string venue = "";
bool isFirstElement = true;
string country = "US";
Hashtable venueMapping = new Hashtable();
Hashtable venuesNumMapping = new Hashtable();
DataView dvRecords = new DataView();
DataTable dt = new DataTable();
DataColumn dc2 = new DataColumn("Address");
dt.Columns.Add(dc2);
dc2 = new DataColumn("Letter");
dt.Columns.Add(dc2);
int lastUsedCount = 0;
dvEvents.Sort = "colOrder ASC";
foreach(DataRowView row in dvEvents)
{
temp = "";
if (normalRecordCount % numOfRecordsPerPage == 0)
{
if (normalRecordCount != 0 && normalRecordCount != lastUsedCount)
{
lastUsedCount = normalRecordCount;
//ErrorLabel.Text += "on script insert normal rec count: " + normalRecordCount.ToString();
dvRecords = new DataView(dt, "", "Letter ASC", DataViewRowState.CurrentRows);
theLiteral = "<script type=\"text/javascript\">\n\rfunction initialize" +
(countInArray + 1).ToString() + "(){initMap(); if(map != null && map != undefined)\n\r " +
" { \n\rvar address;\n\r";
oneStringRecord = theLiteral;
int rowCount = 0;
foreach (DataRowView rowster in dvRecords)
{
if (rowCount == 0)
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', true);".Replace(" ",
" ").Replace(" ", " ");
if (rowCount == dvRecords.Count - 1)
{
oneStringRecord += " }}</script>".Replace(" ",
" ").Replace(" ", " ");
}
}
else if (rowCount == dvRecords.Count - 1)
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', false); }}</script>".Replace(" ",
" ").Replace(" ", " ");
}
else
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', false);".Replace(" ",
" ").Replace(" ", " ");
}
rowCount++;
}
TopLiteral.Text += oneStringRecord;
theArray[countInArray] = oneStringRecord;
dt.Rows.Clear();
countInArray++;
venueMapping.Clear();
venuesNumMapping.Clear();
}
venue = "";
isFirstElement = true;
i = 0;
}
address = "";
DataView dvV = new DataView();
if (row["VID"].ToString() != "NONE")
{
dvV = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + row["VID"].ToString());
}
else
{
dvV = dat.GetDataDV("SELECT * FROM Events WHERE ID=" + row["EID"].ToString());
}
DataView dvCountry = dat.GetDataDV("SELECT * FROM countries WHERE country_id=" + dvV[0]["Country"].ToString());
country = dvCountry[0]["country_2_code"].ToString();
if (country.ToLower() == "us")
{
try
{
if (row["VID"].ToString() != "NONE")
{
address = dat.GetAddress(dvV[0]["Address"].ToString(), false);
}
else
{
address = dvV[0]["Address"].ToString();
}
}
catch (Exception ex1)
{
address = "";
}
}
else
{
if (row["VID"].ToString() != "NONE")
{
address = dat.GetAddress(dvV[0]["Address"].ToString(), true);
}
else
{
address = dvV[0]["Address"].ToString();
}
}
if (!normalEventHash.Contains(row["EID"].ToString()))
{
normalEventHash.Add(row["EID"].ToString(), normalRecordCount.ToString());
if (dvV[0]["Country"].ToString().ToLower() == "222")
{
//VenueName.Text + "@&" +
if (venueMapping.ContainsKey(address))
{
row["SearchNum"] = venuesNumMapping[address].ToString();
if (row["Type"].ToString() == "E")
{
temp = row["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ");
if (temp.Length > 50)
temp = temp.Substring(0, 50) + "...";
venueMapping[address] += "<br/><div class=\\\"NavyLink12UD\\\" style=\\\" float: left; cursor: pointer;\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["EID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>";
}
else
{
temp = row["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ");
if (temp.Length > 50)
temp = temp.Substring(0, 50) + "...";
venueMapping[address] += "<br/><div class=\\\"NavyLink12UD\\\" style=\\\" float: left; cursor: pointer;\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["EID"].ToString() + "_Venue" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>";
}
}
else
{
if (!isFirstElement)
{
i++;
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
if (row["Type"].ToString() == "E")
{
temp = row["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ");
if (temp.Length > 50)
temp = temp.Substring(0, 50) + "...";
venueMapping.Add(address, "\n\raddress = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; " +
"\n\rshowAddressUS('<span class=\\\"Green12Link2UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>', 0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["EID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>");
}
else
{
temp = row["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ");
if (temp.Length > 50)
temp = temp.Substring(0, 50) + "...";
venueMapping.Add(address, "\n\raddress = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; " +
"\n\rshowAddressUS('<span class=\\\"Green12Link2UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>', 0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>");
}
row["SearchNum"] = dat.GetImage(i.ToString());
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
}
else
{
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
row["SearchNum"] = dat.GetImage(i.ToString());
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
temp = row["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ");
if (temp.Length > 50)
temp = temp.Substring(0, 50) + "...";
if (row["Type"].ToString() == "E")
{
venueMapping.Add(address, "\n\raddress = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; \n\rshowAddressUS('<span class=\\\"Green12LinkNFUD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["EID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>");
}
else
{
venueMapping.Add(address, "\n\raddress = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; \n\rshowAddressUS('<span class=\\\"Green12LinkNFUD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>");
}
}
}
}
else
{
//VenueName.Text + "@&" +
if (venueMapping.ContainsKey(address))
{
row["SearchNum"] = venuesNumMapping[address].ToString();
temp = row["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ");
if (temp.Length > 50)
temp = temp.Substring(0, 50) + "...";
if (row["Type"].ToString() == "E")
{
venueMapping[address] += "<br/><div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["EID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>";
}
else
{
venueMapping[address] += "<br/><div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>";
}
}
else
{
if (!isFirstElement)
{
i++;
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
temp = row["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ");
if (temp.Length > 50)
temp = temp.Substring(0, 50) + "...";
if (row["Type"].ToString() == "E")
{
string tmp = "\n\raddress = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ");
if (row["VID"].ToString() == "NONE")
{
tmp += "'; \n\rshowAddressUS('<span class=\\\"Green12LinkNFUD\\\">" +
dvV[0]["Address"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["EID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>";
}
else
{
tmp += "'; \n\rshowAddressUS('<span class=\\\"Green12LinkNFUD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["EID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>";
}
venueMapping.Add(address, tmp);
}
else
{
venueMapping.Add(address, "\n\raddress = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; \n\rshowAddressUS('<span class=\\\"Green12LinkNFUD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>");
}
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
row["SearchNum"] = dat.GetImage(i.ToString());
}
else
{
temp = row["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ");
if (temp.Length > 50)
temp = temp.Substring(0, 50) + "...";
row["SearchNum"] = dat.GetImage(i.ToString());
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
if (row["Type"].ToString() == "E")
{
string tmp = "\n\raddress = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'";
if (row["VID"].ToString() == "NONE")
{
tmp += " \n\rshowAddressUS('<span class=\\\"Green12LinkNFUD\\\" >" +
dvV[0]["Address"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["EID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>";
}
else
{
tmp += " \n\rshowAddressUS('<span class=\\\"Green12LinkNFUD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["EID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>";
}
venueMapping.Add(address, tmp);
}
else
{
venueMapping.Add(address, "\n\raddress = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; \n\rshowAddressUS('<span class=\\\"Green12LinkNFUD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>");
}
}
}
}
isFirstElement = false;
normalRecordCount++;
venue = address;
}
else
{
if (venueMapping.ContainsKey(address))
{
temp = row["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ");
if (temp.Length > 50)
temp = temp.Substring(0, 50) + "...";
row["SearchNum"] = venuesNumMapping[address].ToString();
if (row["Type"].ToString() == "E")
{
venueMapping[address] += "<br/><div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["EID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>";
}
else
{
venueMapping[address] += "<br/><div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>";
}
}
else
{
temp = row["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ");
if (temp.Length > 50)
temp = temp.Substring(0, 50) + "...";
if (!isFirstElement)
{
i++;
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
if (row["Type"].ToString() == "E")
{
string tmp = "\n\raddress = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ");
if (row["VID"].ToString() == "NONE")
{
tmp += "'; \n\rshowAddressUS('<span class=\\\"Green12LinkNFUD\\\">" +
dvV[0]["Address"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["EID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>";
}
else
{
tmp += "'; \n\rshowAddressUS('<span class=\\\"Green12LinkNFUD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["EID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>";
}
venueMapping.Add(address, tmp);
}
else
{
venueMapping.Add(address, "\n\raddress = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; \n\rshowAddressUS('<span class=\\\"Green12LinkNFUD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>");
}
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
row["SearchNum"] = dat.GetImage(i.ToString());
}
else
{
row["SearchNum"] = dat.GetImage(i.ToString());
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
if (row["Type"].ToString() == "E")
{
string tmp = "\n\raddress = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'";
if (row["VID"].ToString() == "NONE")
{
tmp += " \n\rshowAddressUS('<span class=\\\"Green12LinkNFUD\\\" >" +
dvV[0]["Address"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["EID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>";
}
else
{
tmp += " \n\rshowAddressUS('<span class=\\\"Green12LinkNFUD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["EID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>";
}
venueMapping.Add(address, tmp);
}
else
{
venueMapping.Add(address, "\n\raddress = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; \n\rshowAddressUS('<span class=\\\"Green12LinkNFUD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div class=\\\"NavyLink12UD\\\" onclick=\\\"GoToThis(\\'" + "../" +
dat.MakeNiceName(row["Header"].ToString()) + "_" +
row["VID"].ToString() + "_Venue" + "\\');\\\">" +
dat.CleanExcelString(temp) + "</div>");
}
}
}
isFirstElement = false;
normalRecordCount++;
venue = address;
}
}
//if (thecount % numOfRecordsPerPage != 0)
//{
dvRecords = new DataView(dt, "", "Letter ASC", DataViewRowState.CurrentRows);
theLiteral = "<script type=\"text/javascript\">\n\rfunction initialize" +
(countInArray + 1).ToString() + "(){initMap(); if(map != null && map != undefined) " +
" { \n\rvar address;";
oneStringRecord = theLiteral;
int theCount = 0;
foreach (DataRowView rowster in dvRecords)
{
if (theCount == 0)
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', true);".Replace(" ",
" ").Replace(" ", " ");
if (theCount == dvRecords.Count - 1)
{
oneStringRecord += " }}</script>".Replace(" ",
" ").Replace(" ", " ");
}
}
else if (theCount == dvRecords.Count - 1)
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', false); }}</script>".Replace(" ",
" ").Replace(" ", " ");
}
else
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', false);".Replace(" ",
" ").Replace(" ", " ");
}
theCount++;
}
TopLiteral.Text += oneStringRecord;
theArray[countInArray] = oneStringRecord;
//}
}
catch (Exception ex)
{
ErrorLabel.Text += ex.ToString() + message;
}
return theArray;
}
protected void InsertRevision(ref Telerik.Web.UI.RadPanelItem item2, DataSet dsChanges, int n,
string tempstr, ref int count, DataSet ds, int i)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
if (dsChanges.Tables[0].Rows[0][n + 3].ToString().Trim() != "")
{
Label theLab = new Label();
if (count != 1)
theLab.Text = tempstr;
string content = "";
string str = "venue";
if (ds.Tables[0].Rows[i]["Mode"].ToString() == "4")
str = "event";
bool isVenue = false;
if (str == "venue")
isVenue = true;
string colName = dsChanges.Tables[0].Columns[n + 3].ColumnName.ToLower();
if (!isVenue && (colName == "zip" || colName == "state" || colName == "city" || colName == "country"))
{
}
else
{
if (dsChanges.Tables[0].Columns[n + 3].ColumnName.ToLower() == "address")
{
DataView dvV = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" +
dsChanges.Tables[0].Rows[0]["VenueID"].ToString());
if (dvV[0]["Country"].ToString() == "223")
content = dat.GetAddress(dsChanges.Tables[0].Rows[0][n + 3].ToString(), false);
else
content = dat.GetAddress(dsChanges.Tables[0].Rows[0][n + 3].ToString(), true);
}
else if (dsChanges.Tables[0].Columns[n + 3].ColumnName.ToLower() == "venue")
{
DataView dvV = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + dsChanges.Tables[0].Rows[0][n + 3].ToString());
content = "<a class=\"AddLink\" target=\"_blank\" href=\"" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dsChanges.Tables[0].Rows[0][n + 3].ToString() +
"_Venue\">" + dvV[0]["Name"].ToString() + "</a>";
}
else
{
content = dsChanges.Tables[0].Rows[0][n + 3].ToString();
}
theLab.Text += count + ". " + dsChanges.Tables[0].Columns[n + 3].ColumnName + " Change Request To: <br/><br/>" +
dat.BreakUpString(content, 30) + "<br/>";
count++;
item2.Controls.Add(theLab);
bool notSeen = dat.isNotSeen(dsChanges, n);
bool isApproved = dat.isApproved(dsChanges, n);
bool changeHasBeenMade = true;
if (notSeen && changeHasBeenMade)
{
HtmlButton img = new HtmlButton();
img.Attributes.Add("commArg", str);
img.Attributes.Add("commandargument", dsChanges.Tables[0].Rows[0]["ID"].ToString() +
"accept" + (n + 3).ToString());
img.ID = dsChanges.Tables[0].Rows[0]["ID"].ToString() + "accept" + (n + 3).ToString();
img.Style.Value = "cursor: pointer;float: right;font-size: 11px;font-weight: bold;margin-top: 20px; padding-bottom: 4px;height: 30px; width: 112px;background-color: transparent; " +
"color: White; background-image: url('image/PostButtonNoPost.png'); background-repeat: " +
"no-repeat; border: 0;";
img.ServerClick += new EventHandler(ServerAcceptChange);
img.Attributes.Add("onmouseover", "this.style.backgroundImage = 'url(image/PostButtonNoPostHover.png)';");
img.Attributes.Add("onmouseout", "this.style.backgroundImage = 'url(image/PostButtonNoPost.png)';");
img.Attributes.Add("onclick", "this.innerHTML = 'Working...';this.disabled=true;this.style.backgroundImage = 'url(image/PostButtonNoPostHover.png)';");
img.InnerText = "Accept";
item2.Controls.Add(img);
img = new HtmlButton();
img.Attributes.Add("commArg", str);
img.Attributes.Add("commandargument", dsChanges.Tables[0].Rows[0]["ID"].ToString() + "reject" +
(n + 3).ToString());
img.ID = dsChanges.Tables[0].Rows[0]["ID"].ToString() + "reject" + (n + 3).ToString();
img.Style.Value = "cursor: pointer;float: right;font-size: 11px;font-weight: bold;margin-top: 20px; padding-bottom: 4px;height: 30px; width: 112px;background-color: transparent; " +
"color: White; background-image: url('image/PostButtonNoPost.png'); background-repeat: " +
"no-repeat; border: 0;";
img.ServerClick += new EventHandler(ServerRejectChange);
img.Attributes.Add("onmouseover", "this.style.backgroundImage = 'url(image/PostButtonNoPostHover.png)';");
img.Attributes.Add("onmouseout", "this.style.backgroundImage = 'url(image/PostButtonNoPost.png)';");
img.Attributes.Add("onclick", "this.innerHTML = 'Working...';this.disabled=true;this.style.backgroundImage = 'url(image/PostButtonNoPostHover.png)';");
img.InnerText = "Reject";
item2.Controls.Add(img);
}
else
{
theLab = new Label();
Label lab2 = new Label();
if (isApproved)
{
theLab.Text = "<br/><br/><span class=\"AddGreenLink FloatRight\">You have accepted this change.</span>";
}
else
{
theLab.Text = "<br/><br/><span class=\"AddGreenLink FloatRight\">You have rejected this change.</span>";
}
item2.Controls.Add(lab2);
item2.Controls.Add(theLab);
}
Literal theLit = new Literal();
theLit.Text = "</td></tr><tr><td>";
item2.Controls.Add(theLit);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
if (cookie == null)
{
cookie = new HttpCookie("BrowserDate");
cookie.Value = DateTime.Now.ToString();
cookie.Expires = DateTime.Now.AddDays(22);
Response.Cookies.Add(cookie);
}
try
{
Session["RedirectTo"] = Request.Url.AbsoluteUri;
bool fillUserData = false;
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
try
{
if (Session["User"] != null)
{
fillUserData = true;
}
}
catch (Exception ex)
{
}
GetOtherVenues();
DoHours(false);
DoHours(true);
if (Request.QueryString["ID"] == null)
Response.Redirect("~/home");
string ID = Request.QueryString["ID"].ToString();
TagCloud.THE_ID = int.Parse(ID);
if (Session["User"] != null)
{
LoggedInPanel.Visible = true;
LoggedOutPanel.Visible = false;
DataSet dsComments;
string commentPrefs = dat.GetData("SELECT * FROM UserPreferences WHERE UserID=" + Session["User"].ToString()).Tables[0].Rows[0]["CommentsPreferences"].ToString();
if (commentPrefs == "1")
{
dsComments = dat.GetData("SELECT VC.CommentDate AS theDate, * FROM Venue_Comments VC, Users U WHERE VC.UserID=U.User_ID AND VC.ID=" + ID + " ORDER BY VC.CommentDate ");
}
else
{
dsComments = dat.GetData("SELECT DISTINCT U.ProfilePicture, U.User_ID, U.UserName, VC.Comment, VC.CommentDate AS theDate FROM Venue_Comments VC, Users U, User_Friends UF WHERE ((UF.UserID=" + Session["User"].ToString() + " AND UF.FriendID=U.User_ID AND U.User_ID=VC.UserID) OR (U.User_ID=" +
Session["User"].ToString() + " AND U.User_ID=VC.UserID)) AND VC.ID=" + ID + " ORDER BY VC.CommentDate");
}
TheComments.DATA_SET = dsComments;
TheComments.DataBind2(true);
//Show edit link if use is logged in.
EditLink.Visible = true;
//Query whether current owner was delinquent on approve/reject changes
//if (dat.IsOwnerDelinquent(Request.QueryString["ID"].ToString(), Request.IsLocal, "V"))
//{
// //make the button visable
// OwnerPanel.Visible = true;
// Session["Message"] = "The ownership of this venue is <b>open</b>. <br/>The ownership became " +
// "open because the previous owner of this venue became un-responsive to rejecting/" +
// "approving user's changes to this venue.<br/>If you would like to become " +
// "the owner, click on the button below to go to the venue's edit page. <br/><br/> " +
// "Being the owner, you will have the privilage of having your <b>edits come though right " +
// "away.</b> Other participants' changes to this venue will have to be <b>approved by you.</b><br/><br/>" +
// "<div align=\"center\" style=\"padding-left: 110px;\"><div align=\"center\"><div style=\"cursor: pointer;cursor: pointer; float: left;padding-right: 10px;\">" +
// "<div class=\"topDiv\" style=\"float:left;\">" +
// "<img style=\"float: left;\" src=\"http://hippohappenings.com/NewImages/ButtonLeft.png\" height=\"27px\" />" +
// "<div style=\"font-size: 12px; text-decoration: none; padding-top: 5px;padding-left: 6px; padding-right: 6px;height: 27px;float: left;background: url('http://hippohappenings.com/NewImages/ButtonPixel.png'); background-repeat: repeat-x;\">" +
// "<a class=\"NavyLink\" onclick=\"Search('enter-locale?ID=" + Request.QueryString["ID"] +
// "');\">Edit</a></div>" +
// "<img style=\"float: left;\" src=\"http://hippohappenings.com/NewImages/ButtonRight.png\" height=\"27px\" />" +
// "</div>" +
// "</div>" +
// "</div>" +
// "<div align=\"center\"><div style=\"cursor: pointer;\">" +
// "<div class=\"topDiv\" style=\"float:left;\">" +
// "<img style=\"float: left;\" src=\"http://hippohappenings.com/NewImages/ButtonLeft.png\" height=\"27px\" />" +
// "<div style=\"font-size: 12px; text-decoration: none; padding-top: 5px;padding-left: 6px; padding-right: 6px;height: 27px;float: left;background: url('http://hippohappenings.com/NewImages/ButtonPixel.png'); background-repeat: repeat-x;\">" +
// "<a class=\"NavyLink\" onclick=\"Search();\">Close</a></div>" +
// "<img style=\"float: left;\" src=\"http://hippohappenings.com/NewImages/ButtonRight.png\" height=\"27px\" />" +
// "</div>" +
// "</div>" +
// "</div></div>";
//}
DataSet ds2 = dat.GetData("SELECT * FROM Venues WHERE ID=" + ID);
DataView dv = new DataView(ds2.Tables[0], "", "", DataViewRowState.CurrentRows);
if (Session["User"] != null)
{
if (dv[0]["Owner"].ToString() == Session["User"].ToString())
{
EditLink.Visible = true;
ContactOwnerLink.Visible = false;
}
else
{
if (dv[0]["Owner"] != null && dv[0]["Owner"].ToString() != "")
{
DataView dvU = dat.GetDataDV("SELECT * FROM Users WHERE User_ID=" + dv[0]["Owner"].ToString());
EditLink.Visible = false;
ContactOwnerLink.Visible = true;
ContactOwnerLink.HRef = dvU[0]["UserName"].ToString() + "_friend";
}
else
{
ContactOwnerLink.Visible = false;
EditLink.Visible = true;
}
}
}
else
{
EditLink.Visible = false;
ContactOwnerLink.Visible = false;
}
}
else
{
LoggedInPanel.Visible = false;
LoggedOutPanel.Visible = true;
DataSet dsComments = dat.GetData("SELECT VC.CommentDate AS theDate, * FROM Venue_Comments VC, Users U WHERE VC.UserID=U.User_ID AND VC.ID=" + ID + " ORDER BY VC.CommentDate ");
TheComments.DATA_SET = dsComments;
TheComments.DataBind2(false);
}
DataSet ds = dat.GetData("SELECT * FROM Venues WHERE ID=" + ID);
Session["FlagID"] = ID;
Session["FlagType"] = "V";
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
if (bool.Parse(ds.Tables[0].Rows[0]["Live"].ToString()))
{
//Get venue's categories
DataSet dscat = dat.GetData("SELECT DISTINCT VC.Name, VC.ID FROM Venue_Category V_C, VenueCategories VC WHERE " +
"V_C.Venue_ID=" + ID + " AND V_C.Category_ID=VC.ID ");
#region SEO
topTopLiteral.Text = "<a class=\"NavyLink12UD\" href=\"#" + dat.MakeNiceNameFull(ds.Tables[0].Rows[0]["Name"].ToString()) + "\">" +
dat.MakeNiceNameFull(ds.Tables[0].Rows[0]["Name"].ToString()).Replace("-", " ") + " From The Top</a>";
string theLink = "http://" + Request.Url.Authority + "/" +
dat.MakeNiceName(ds.Tables[0].Rows[0]["Name"].ToString()) +
"_" + ID.ToString() + "_Venue";
HtmlHead head = (HtmlHead)Page.Header;
HtmlLink lk = new HtmlLink();
lk.Href = theLink;
lk.Attributes.Add("rel", "bookmark");
head.Controls.AddAt(0, lk);
//Create keyword and description meta tags
HtmlMeta hm = new HtmlMeta();
HtmlMeta kw = new HtmlMeta();
HtmlMeta lg = new HtmlMeta();
HtmlLink cn = new HtmlLink();
cn.Attributes.Add("rel", "canonical");
cn.Href = theLink;
head.Controls.AddAt(0, cn);
kw.Name = "keywords";
hm.Name = "Description";
lg.Name = "language";
lg.Content = "English";
head.Controls.AddAt(0, lg);
char[] delimeter = { ' ' };
string[] keywords = dat.MakeNiceNameFull(ds.Tables[0].Rows[0]["Name"].ToString()).Replace("-", " ").Split(delimeter, StringSplitOptions.RemoveEmptyEntries);
int count = 0;
foreach (string token in keywords)
{
if (count < 16)
{
if (kw.Content != "")
kw.Content += " ";
kw.Content += token;
count++;
}
}
head.Controls.AddAt(0, kw);
hm.Content = dat.MakeNiceNameFull(dat.stripHTML(ds.Tables[0].Rows[0]["Content"].ToString()).Replace(" ", " ").Replace(" ", " ")).Replace("-", " ");
if (hm.Content.Length > 200)
hm.Content = hm.Content.Substring(0, 197) + "...";
head.Controls.AddAt(0, hm);
this.Title = kw.Content;
#endregion
VenueName.Text = "<a id=\"" + dat.MakeNiceNameFull(ds.Tables[0].Rows[0]["Name"].ToString()) + "\" class=\"aboutLink\" href=\"" +
theLink + "\"><h1>" + dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 50) + "</h1></a>";
Session["Subject"] = "Re: " + ds.Tables[0].Rows[0]["Name"].ToString();
Session["CommentSubject"] = "Re: " + ds.Tables[0].Rows[0]["Name"].ToString();
string Venue = dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14);
string url = ds.Tables[0].Rows[0]["Web"].ToString();
if (url.Length > 8)
{
if (url.ToLower().Substring(0, 7) != "http://" && url.ToLower().Substring(0, 8) != "https://")
url = "http://" + url;
}
PhoneLabel.Text = "Phone: " + dat.BreakUpString(ds.Tables[0].Rows[0]["Phone"].ToString(), 15) + "<br/>Email: " +
dat.BreakUpString(ds.Tables[0].Rows[0]["Email"].ToString(), 15) + "<br/>Web: <a class='AddLink' target='_blank' href='" + url + "'>" +
dat.BreakUpString(ds.Tables[0].Rows[0]["Web"].ToString(), 17) + "</a>";
DataSet dsCountry = new DataSet();
string country = "";
if (ds.Tables[0].Rows[0]["Country"] != null)
{
dsCountry = dat.GetData("SELECT country_2_code FROM Countries WHERE country_id=" + ds.Tables[0].Rows[0]["Country"].ToString());
if (dsCountry.Tables[0].Rows.Count > 0)
{
country = dsCountry.Tables[0].Rows[0]["country_2_code"].ToString();
}
}
if (country.ToLower() == "us")
{
try
{
AddressLabel.Text = dat.GetAddress(ds.Tables[0].Rows[0]["Address"].ToString(), false);
}
catch (Exception ex1)
{
AddressLabel.Text = "";
}
}
else
{
AddressLabel.Text = dat.GetAddress(ds.Tables[0].Rows[0]["Address"].ToString(), true);
}
//if (ds.Tables[0].Rows[0]["Country"].ToString() == "222")
//{
// CityState.Text = ds.Tables[0].Rows[0]["City"].ToString();
//}
//else
//{
CityState.Text = ds.Tables[0].Rows[0]["City"].ToString() + " " +
ds.Tables[0].Rows[0]["State"].ToString() + " " + ds.Tables[0].Rows[0]["Zip"].ToString();
//}
HttpCookie cookie2 = new HttpCookie("addressParameter");
HttpCookie cookiename = new HttpCookie("addressParameterName");
if (country.ToLower() == "uk")
{
//VenueName.Text + "@&" +
cookie2.Value = AddressLabel.Text + "@&" +
ds.Tables[0].Rows[0]["City"].ToString() + ", " +
ds.Tables[0].Rows[0]["Zip"].ToString() + ", " + country;
cookiename.Value = dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14);
}
else
{
//VenueName.Text + "@&" +
cookie2.Value = AddressLabel.Text + "@&" + CityState.Text + "@&" + country;
cookiename.Value = dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14);
}
cookie2.Expires = DateTime.Now.Add(new TimeSpan(1, 0, 0));
cookiename.Expires = DateTime.Now.Add(new TimeSpan(1, 0, 0));
Response.Cookies.Add(cookie2);
Response.Cookies.Add(cookiename);
string content = ds.Tables[0].Rows[0]["Content"].ToString();
Session["messageText"] = "Venue: " + dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14) + ". Address: " + AddressLabel.Text + ", " + CityState.Text;
Session["messageEmail"] = "Venue: " + dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14) + " \n\r Address: " + AddressLabel.Text + " \n\r Location: " +
CityState.Text + " \n\r " + content;
ShowDescriptionBegining.Text = dat.BreakUpString(content, 60);
CalendarLink.NavigateUrl = dat.MakeNiceName(dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14)) + "_" + ID + "_Calendar";
//Media Categories: NONE: 0, Picture: 1, Video: 2, YouTubeVideo: 3, Slider: 4
int mediaCategory = int.Parse(ds.Tables[0].Rows[0]["mediaCategory"].ToString());
DataSet dsEvents = dat.GetData("SELECT EO.DateTimeStart AS Start, EO.DateTimeEnd AS [End], " +
"E.Header, E.ID, E.ShortDescription FROM Event_Occurance EO, Events E WHERE " +
"(CONVERT(NVARCHAR,DAY(EO.DateTimeStart)) + '.' + CONVERT(NVARCHAR,MONTH(EO.DateTimeStart)) + " +
"'.' + CONVERT(NVARCHAR,YEAR(EO.DateTimeStart))) = (CONVERT(NVARCHAR,DAY(GETDATE())) + " +
"'.' + CONVERT(NVARCHAR,MONTH(GETDATE())) + '.' + CONVERT(NVARCHAR,YEAR(GETDATE())))" +
"AND EO.EventID=E.ID AND E.Venue=" + ID + " ORDER BY Start");
bool noEvents = false;
EventsPanel.Controls.Clear();
if (dsEvents.Tables.Count > 0)
if (dsEvents.Tables[0].Rows.Count > 0)
{
int eventCount = dsEvents.Tables[0].Rows.Count;
for (int i = 0; i < eventCount; i++)
{
HyperLink eventHeader = new HyperLink();
eventHeader.CssClass = "NavyLink16UD";
eventHeader.NavigateUrl = dat.MakeNiceName(dsEvents.Tables[0].Rows[i]["Header"].ToString())+"_" + dsEvents.Tables[0].Rows[i]["ID"].ToString()+"_Event";
eventHeader.Text = dsEvents.Tables[0].Rows[i]["Header"].ToString() + "<br/>";
Label dateStart = new Label();
dateStart.CssClass = "Text12UDPd";
dateStart.Text = DateTime.Parse(dsEvents.Tables[0].Rows[i]["Start"].ToString()).ToShortTimeString() + " - " +
DateTime.Parse(dsEvents.Tables[0].Rows[i]["End"].ToString()).ToShortTimeString() + "<br/>";
Label shortDescription = new Label();
shortDescription.CssClass = "Text12Pd";
shortDescription.Text = dsEvents.Tables[0].Rows[i]["ShortDescription"].ToString() + "<br/>";
EventsPanel.Controls.Add(eventHeader);
EventsPanel.Controls.Add(dateStart);
EventsPanel.Controls.Add(shortDescription);
}
}
else
{
noEvents = true;
}
else
{
noEvents = true;
}
if (noEvents)
{
Label eventHeader = new Label();
eventHeader.Text = "There are no events at " + dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14) + " today.";
EventsPanel.Controls.Add(eventHeader);
}
//Media Categories: NONE: 0, Picture: 1, Video: 2, YouTubeVideo: 3, Slider: 4
string youtube = ds.Tables[0].Rows[0]["YouTubeVideo"].ToString();
Rotator1.Items.Clear();
switch (mediaCategory)
{
case 0:
break;
case 1:
char[] delim4 = { ';' };
string[] youtokens = youtube.Split(delim4);
if (youtube != "")
{
for (int i = 0; i < youtokens.Length; i++)
{
if (youtokens[i].Trim() != "")
{
Literal literal3 = new Literal();
literal3.Text = "<div class=\"FloatLeft\"><object width=\"412\" height=\"250\"><param name=\"wmode\" value=\"opaque\" ></param><param name=\"movie\" value=\"http://www.youtube.com/v/" + youtokens[i] +
"\"></param><param name=\"allowFullScreen\" value=\"true\"></param><embed wmode=\"opaque\" src=\"http://www.youtube.com/v/" + youtokens[i] +
"\" type=\"application/x-shockwave-flash\" allowfullscreen=\"true\" width=\"412\" height=\"250\"></embed></object></div>";
Telerik.Web.UI.RadRotatorItem r3 = new Telerik.Web.UI.RadRotatorItem();
r3.Controls.Add(literal3);
Rotator1.Items.Add(r3);
}
}
}
DataView dsSlider = dat.GetDataDV("SELECT * FROM Venue_Slider_Mapping WHERE VenueID=" + ID);
if (dsSlider.Count > 0)
{
char[] delim = { '\\' };
char[] delim3 = { '.' };
for (int i = 0; i < dsSlider.Count; i++)
{
string[] tokens = dsSlider[i]["PictureName"].ToString().Split(delim3);
//dsSlider.RowFilter = "RealPictureName='" + tokens[0] + "." + tokens[1] + "'";
if (tokens.Length >= 2)
{
if (tokens[1].ToUpper() == "JPG" || tokens[1].ToUpper() == "JPEG" || tokens[1].ToUpper() == "GIF" || tokens[1].ToUpper() == "PNG")
{
try
{
System.Drawing.Image image = System.Drawing.Image.FromFile(MapPath(".") +
"\\VenueFiles\\" + ID + "\\Slider\\" + dsSlider[i]["PictureName"].ToString());
int width = 410;
int height = 250;
int newHeight = 0;
int newIntWidth = 0;
//if image height is less than resize height
if (height >= image.Height)
{
//leave the height as is
newHeight = image.Height;
if (width >= image.Width)
{
newIntWidth = image.Width;
}
else
{
newIntWidth = width;
double theDivider = double.Parse(image.Width.ToString()) / double.Parse(newIntWidth.ToString());
double newDoubleHeight = double.Parse(newHeight.ToString());
newDoubleHeight = double.Parse(height.ToString()) / theDivider;
newHeight = (int)newDoubleHeight;
}
}
//if image height is greater than resize height...resize it
else
{
//make height equal to the requested height.
newHeight = height;
//get the ratio of the new height/original height and apply that to the width
double theDivider = double.Parse(image.Height.ToString()) / double.Parse(newHeight.ToString());
double newDoubleWidth = double.Parse(newIntWidth.ToString());
newDoubleWidth = double.Parse(image.Width.ToString()) / theDivider;
newIntWidth = (int)newDoubleWidth;
//if the resized width is still to big
if (newIntWidth > width)
{
//make it equal to the requested width
newIntWidth = width;
//get the ratio of old/new width and apply it to the already resized height
theDivider = double.Parse(image.Width.ToString()) / double.Parse(newIntWidth.ToString());
double newDoubleHeight = double.Parse(newHeight.ToString());
newDoubleHeight = double.Parse(image.Height.ToString()) / theDivider;
newHeight = (int)newDoubleHeight;
}
}
Literal literal4 = new Literal();
string[] nameTokens = dsSlider[i]["RealPictureName"].ToString().Split(delim3);
string realName = dat.MakeNiceName(nameTokens[0]).Replace("_", " ");
literal4.Text = "<div class=\"RotatorImage\"><img alt=\"" + realName +
"\" style=\" margin-left: " + ((410 - newIntWidth) / 2).ToString() + "px; margin-top: " + ((250 - newHeight) / 2).ToString() + "px;\" height=\"" + newHeight + "px\" width=\"" + newIntWidth + "px\" src=\""
+ "VenueFiles/" + ID + "/Slider/" + dsSlider[i]["PictureName"].ToString() + "\" /></div>";
Telerik.Web.UI.RadRotatorItem r4 = new Telerik.Web.UI.RadRotatorItem();
r4.Controls.Add(literal4);
Rotator1.Items.Add(r4);
}
catch (Exception ex)
{
}
}
else if (tokens[1].ToUpper() == "WMV")
{
Literal literal4 = new Literal();
literal4.Text = "<div style=\"width: 410px; height: 250px;\" ><OBJECT stop=\"true\" loop=\"false\" controller=\"true\" wmode2=\"opaque\" wmode=\"transparent\" autoplay=\"false\" classid=\"clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B\" " +
"width=\"410\" height=\"250\" codebase=\"http://www.apple.com/qtactivex/qtplugin.cab\">" +
"<param name=\"src\" value=\"UserFiles/Events/" + ID + "/Slider/" + dsSlider[i]["PictureName"].ToString() + "\"></param>" +
"<param name=\"autoplay\" value=\"false\"></param><param name=\"wmode\" value=\"transparent\"></param>" +
"<param name=\"controller\" value=\"true\"></param>" +
"<param name=\"stop\" value=\"true\" ></param>" +
"<param name=\"loop\" value=\"false\"><param name=\"wmode2\" value=\"opaque\" ></param>" +
"<EMBED stop=\"true\" wmode=\"transparent\" wmode2=\"opaque\" src=\"UserFiles/Events/" + ID + "/Slider/" + dsSlider[i]["PictureName"].ToString() + "\" width=\"410\" height=\"250\" autoplay=\"false\" " +
"controller=\"true\" loop=\"false\" bgcolor=\"#000000\" pluginspage=\"http://www.apple.com/quicktime/download/\">" +
"</EMBED>" +
"</OBJECT></div>";
//literal4.Text = "<div style=\"float:left;\"><embed height=\"250px\" width=\"400px\" src=\""
// + "VenueFiles/" + ID + "/Slider/" + fileArray[i].Split(delim)[length - 1].ToString() + "\" /></div>";
Telerik.Web.UI.RadRotatorItem r4 = new Telerik.Web.UI.RadRotatorItem();
r4.Controls.Add(literal4);
Rotator1.Items.Add(r4);
}
}
}
}
break;
default: break;
}
if (Rotator1.Items.Count == 0)
RotatorPanel.Visible = false;
else
{
RotatorPanel.Visible = true;
if (Rotator1.Items.Count == 1)
{
RotatorPanel.CssClass = "HiddeButtons";
}
}
if (fillUserData)
{
ASP.controls_addtofavorites_ascx AddTo1 = new ASP.controls_addtofavorites_ascx();
AddTo1.VENUE_ID = int.Parse(ID);
ASP.controls_sendmessage_ascx SendMessage1 = new ASP.controls_sendmessage_ascx();
SendMessage1.THE_TEXT = "Share on Hippo";
SendMessage1.RE_LABEL = "Re: " + Session["UserName"].ToString() +
" would like to share the venue '\"" + dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14) + "\"' with you.";
SendMessage1.TYPE = "v";
SendMessage1.ID = int.Parse(ID);
CalendarPanel.Controls.Add(AddTo1);
CalendarPanel.Controls.Add(SendMessage1);
}
this.Title = dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14);
}
else
{
Response.Redirect("~/home");
}
}
else
{
Response.Redirect("~/home");
}
}
else
{
Response.Redirect("~/home");
}
}
catch (Exception ex)
{
ErrorLabel.Text = ex.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
if (cookie == null)
{
cookie = new HttpCookie("BrowserDate");
cookie.Value = DateTime.Now.ToString();
cookie.Expires = DateTime.Now.AddDays(22);
Response.Cookies.Add(cookie);
}
try
{
Session["RedirectTo"] = Request.Url.AbsoluteUri;
bool fillUserData = false;
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
try
{
if (Session["User"] != null)
{
fillUserData = true;
}
else
{
Button calendarLink = (Button)dat.FindControlRecursive(this, "CalendarLink");
calendarLink.Visible = false;
}
}
catch (Exception ex)
{
}
if (Request.QueryString["ID"] == null)
Response.Redirect("~/Home.aspx");
string ID = Request.QueryString["ID"].ToString();
if (Session["User"] != null)
{
LoggedInPanel.Visible = true;
LoggedOutPanel.Visible = false;
DataSet dsComments;
string commentPrefs = dat.GetData("SELECT * FROM UserPreferences WHERE UserID=" + Session["User"].ToString()).Tables[0].Rows[0]["CommentsPreferences"].ToString();
if (commentPrefs == "1")
{
dsComments = dat.GetData("SELECT VC.CommentDate AS theDate, * FROM Venue_Comments VC, Users U WHERE VC.UserID=U.User_ID AND VC.VenueID=" + ID + " ORDER BY VC.CommentDate ");
}
else
{
dsComments = dat.GetData("SELECT DISTINCT U.ProfilePicture, U.User_ID, U.UserName, VC.Comment, VC.CommentDate AS theDate FROM Venue_Comments VC, Users U, User_Friends UF WHERE ((UF.UserID=" + Session["User"].ToString() + " AND UF.FriendID=U.User_ID AND U.User_ID=VC.UserID) OR (U.User_ID=" +
Session["User"].ToString() + " AND U.User_ID=VC.UserID)) AND VC.VenueID=" + ID + " ORDER BY VC.CommentDate");
}
TheComments.DATA_SET = dsComments;
TheComments.DataBind2(true);
//Show edit link if use is logged in.
EditLink.NavigateUrl = "EnterVenue.aspx?ID=" + ID;
EditLink.Visible = true;
TopPanel.Visible = true;
//Query whether current owner was delinquent on approve/reject changes
if (dat.IsOwnerDelinquent(Request.QueryString["ID"].ToString(), Request.IsLocal, "V"))
{
//make the button visable
TopPanel.Visible = true;
OwnerPanel.Visible = true;
Session["Message"] = "The ownership of this venue is <b>open</b>. <br/>The ownership became " +
"open because the previous owner of this venue became un-responsive to rejecting/" +
"approving user's changes to this venue.<br/>If you would like to become " +
"the owner, click on the button below to go to the venue's edit page. <br/><br/> " +
"Being the owner, you will have the privilage of having your <b>edits come though right " +
"away.</b> Other participants' changes to this venue will have to be <b>approved by you.</b><br/><br/>" +
"<button style=\"cursor: pointer;font-size: 11px;font-weight: bold;margin-top: 20px; padding-bottom: 4px;height: 30px; width: 112px;background-color: transparent; " +
"color: White; background-image: url('image/PostButtonNoPost.png'); background-repeat: " +
"no-repeat; border: 0;\" onclick=\"Search('EnterVenue.aspx?ID=" + Request.QueryString["ID"].ToString() +
"');\" onmouseover=\"this.style.backgroundImage='url(image/PostButtonNoPostHover.png)'\" " +
"onmouseout=\"this.style.backgroundImage='url(image/PostButtonNoPost.png)'\">Edit</button>" +
"<button style=\"cursor: pointer;font-size: 11px;font-weight: bold;margin-top: 20px; padding-bottom: 4px;height: 30px; width: 112px;background-color: transparent; " +
"color: White; background-image: url('image/PostButtonNoPost.png'); background-repeat: " +
"no-repeat; border: 0;\" onclick=\"Search();\" " +
"onmouseover=\"this.style.backgroundImage='url(image/PostButtonNoPostHover.png)'\" " +
"onmouseout=\"this.style.backgroundImage='url(image/PostButtonNoPost.png)'\">Close</button>";
}
}
else
{
LoggedInPanel.Visible = false;
LoggedOutPanel.Visible = true;
DataSet dsComments = dat.GetData("SELECT VC.CommentDate AS theDate, * FROM Venue_Comments VC, Users U WHERE VC.UserID=U.User_ID AND VC.VenueID=" + ID + " ORDER BY VC.CommentDate ");
TheComments.DATA_SET = dsComments;
TheComments.DataBind2(false);
}
DataSet ds = dat.GetData("SELECT * FROM Venues WHERE ID=" + ID);
Session["FlagID"] = ID;
Session["FlagType"] = "V";
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
if (bool.Parse(ds.Tables[0].Rows[0]["Live"].ToString()))
{
//Get venue's categories
DataSet dscat = dat.GetData("SELECT DISTINCT VC.Name, VC.ID FROM Venue_Category V_C, VenueCategories VC WHERE " +
"V_C.Venue_ID=" + ID + " AND V_C.Category_ID=VC.ID ");
if (dscat.Tables.Count > 0)
{
if (dscat.Tables[0].Rows.Count > 0)
{
CategoriesLiteral.Text = "<label class=\"AddWhiteLinkSmall\">Categories:</label> ";
int charcount = 0;
bool charReached = false;
int currentcount = 0;
int leftovercount = 0;
for (int u = 0; u < dscat.Tables[0].Rows.Count; u++)
{
CategoriesLiteral.Text += "<a class=\"AddLinkSmall\" href=\""+dat.MakeNiceName(dscat.Tables[0].Rows[u]["Name"].ToString())+"_Venue_Category\">" + dscat.Tables[0].Rows[u]["Name"].ToString() + "</a> ";
charcount += dscat.Tables[0].Rows[u]["Name"].ToString().Length + 1;
if (dscat.Tables[0].Rows[u]["Name"].ToString().ToLower().Contains("happy hour"))
{
CategoriesLiteral.Text += "<label class=\"AddLinkSmallUn\"> (see venue calendar) </label>";
charcount += 23;
if (charReached)
{
leftovercount += 23;
}
}
if (!charReached)
{
if (charcount > 145)
{
charReached = true;
leftovercount = dscat.Tables[0].Rows[u]["Name"].ToString().Length + 1;
}
else
{
currentcount = CategoriesLiteral.Text.Length;
}
}
else
{
leftovercount += dscat.Tables[0].Rows[u]["Name"].ToString().Length + 1;
}
}
//if the list is too long, add a 'more' link drop down.
if (charReached)
{
string beginning = "<div>" + CategoriesLiteral.Text.Substring(0, currentcount - 1) +
" <a onclick=\"OpenCatDiv();\" id=\"morelessA\" class=\"AddWhiteLinkSmall\"> more...</a></div>";
int divHeight = leftovercount / 82;
if (divHeight == 0)
divHeight = 20;
else
divHeight = (divHeight + 1) * 20;
string hiddenDiv = "<div style=\"display: none;\" id=\"infoDiv\">" + divHeight.ToString() +
"</div><div style=\"height: 0px; border: 0; width: 420px;\" id=\"CatDiv\">" +
CategoriesLiteral.Text.Substring(currentcount, CategoriesLiteral.Text.Length - currentcount) + "</div>";
CategoriesLiteral.Text = beginning + hiddenDiv;
}
}
}
string theLink = "http://" + Request.Url.Authority + "/" +
dat.MakeNiceName(dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14)) +
"_" + ID.ToString() + "_Venue";
// DiggLiteral.Text = " <table> "+
// "<tr>"+
// "<td valign=\"bottom\" style=\"padding-right: 10px;\">"+
// "<a name=\"fb_share\" type=\"button\" href=\"http://www.facebook.com/sharer.php\">Share</a><script src=\"http://static.ak.fbcdn.net/connect.php/js/FB.Share\" type=\"text/javascript\"></script>"+
// "</td>"+
// "<td valign=\"bottom\" style=\"padding-right: 10px;\">"+
// " <a style=\"border: 0; padding: 0; margin: 0;\" id=\"TweeterA\" title=\"Click to send this page to Twitter!\" target=\"_blank\" rel=\"nofollow\"><img style=\"border: 0; padding: 0; margin: 0;\" src=\"http://twitter-badges.s3.amazonaws.com/twitter-a.png\" alt=\"Share on Twitter\"/></a>"+
// "</td>"+
// "<td valign=\"bottom\" style=\"padding-right: 10px;\">"+
// " <a href=\"javascript:void(window.open('http://www.myspace.com/Modules/PostTo/Pages/?u='+encodeURIComponent(document.location.toString()),'ptm','height=450,width=440').focus())\">"+
// " <img src=\"http://cms.myspacecdn.com/cms/ShareOnMySpace/small.png\" border=\"0\" alt=\"Share on MySpace\" />"+
// " </a>"+
// "</td>"+
// "<td valign=\"bottom\" style=\"padding-right: 10px;\"><a alt=\"Digg it!\" class=\"DiggThisButton DiggIcon\" id=\"dibbButt\"" +
// "href='http://digg.com/submit?phase=2&url=" + "http://" + Request.Url.Authority + "/" +
// dat.MakeNiceName(ds.Tables[0].Rows[0]["Name"].ToString()) +
// "_" + ID.ToString() + "_Venue" +
// "' target=\"_blank\">Digg</a></td> "+
// "<td valign=\"bottom\" style=\"padding-right: 10px;\">" +
// "<a href=\"http://delicious.com/save\" onclick=\"window.open('http://delicious.com/save?v=5&noui&jump=close&url='+encodeURIComponent(location.href)+'&title='+encodeURIComponent(document.title), 'delicious','toolbar=no,width=550,height=550'); return false;\">" +
// " <img border=\"0\" src=\"http://static.delicious.com/img/delicious.small.gif\" height=\"10\" width=\"10\" alt=\"Delicious\" />" +
// "</a>" +
// "</td>" +
// "<td>" +
// " <script src=\"http://www.stumbleupon.com/hostedbadge.php?s=4\"></script>" +
// "</td>" +
// "</tr>" +
//"</table>";
HtmlHead head = (HtmlHead)Page.Header;
HtmlLink lk = new HtmlLink();
lk.Href = theLink;
lk.Attributes.Add("rel", "bookmark");
head.Controls.AddAt(0, lk);
VenueName.Text = "<a style=\"text-decoration: none; color: white;\" href=\"" +
theLink + "\">" + dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14) + "</a>";
Session["Subject"] = "Re: " + ds.Tables[0].Rows[0]["Name"].ToString();
Session["CommentSubject"] = "Re: " + ds.Tables[0].Rows[0]["Name"].ToString();
string Venue = dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14);
//TagCloud.THE_ID = int.Parse(ID);
PhoneLabel.Text = "Phone: " + ds.Tables[0].Rows[0]["Phone"].ToString() + "<br/>Email: " +
ds.Tables[0].Rows[0]["Email"].ToString() + "<br/>Web: <a class='AddLink' target='_blank' href='" + ds.Tables[0].Rows[0]["Web"].ToString() + "'>" +
ds.Tables[0].Rows[0]["Web"].ToString()+"</a>";
DataSet dsCountry = new DataSet();
string country = "";
if (ds.Tables[0].Rows[0]["Country"] != null)
{
dsCountry = dat.GetData("SELECT country_2_code FROM Countries WHERE country_id=" + ds.Tables[0].Rows[0]["Country"].ToString());
if (dsCountry.Tables[0].Rows.Count > 0)
{
country = dsCountry.Tables[0].Rows[0]["country_2_code"].ToString();
}
}
if (country.ToLower() == "us")
{
try
{
AddressLabel.Text = dat.GetAddress(ds.Tables[0].Rows[0]["Address"].ToString(), false);
}
catch (Exception ex1)
{
AddressLabel.Text = "";
}
}
else
{
AddressLabel.Text = dat.GetAddress(ds.Tables[0].Rows[0]["Address"].ToString(), true);
}
//if (ds.Tables[0].Rows[0]["Country"].ToString() == "222")
//{
// CityState.Text = ds.Tables[0].Rows[0]["City"].ToString();
//}
//else
//{
CityState.Text = ds.Tables[0].Rows[0]["City"].ToString() + " " +
ds.Tables[0].Rows[0]["State"].ToString() + " " + ds.Tables[0].Rows[0]["Zip"].ToString();
//}
HttpCookie cookie2 = new HttpCookie("addressParameter");
HttpCookie cookiename = new HttpCookie("addressParameterName");
if (country.ToLower() == "uk")
{
//VenueName.Text + "@&" +
cookie2.Value = AddressLabel.Text + "@&" +
ds.Tables[0].Rows[0]["City"].ToString() + ", " +
ds.Tables[0].Rows[0]["Zip"].ToString() + ", " + country;
cookiename.Value = dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14);
}
else
{
//VenueName.Text + "@&" +
cookie2.Value = AddressLabel.Text + "@&" + CityState.Text + "@&" + country;
cookiename.Value = dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14);
}
cookie2.Expires = DateTime.Now.Add(new TimeSpan(1, 0, 0));
cookiename.Expires = DateTime.Now.Add(new TimeSpan(1, 0, 0));
Response.Cookies.Add(cookie2);
Response.Cookies.Add(cookiename);
string content = ds.Tables[0].Rows[0]["Content"].ToString();
Session["messageText"] = "Venue: " + dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14) + ". Address: " + AddressLabel.Text + ", " + CityState.Text;
Session["messageEmail"] = "Venue: " + dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14) + " \n\r Address: " + AddressLabel.Text + " \n\r Location: " +
CityState.Text + " \n\r " + content;
ShowDescriptionBegining.Text = dat.BreakUpString(content, 60);
//Create keyword and description meta tags
HtmlMeta hm = new HtmlMeta();
HtmlMeta kw = new HtmlMeta();
kw.Name = "keywords";
kw.Content = dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14) + ", " + AddressLabel.Text;
DataView dvCats = dat.GetDataDV("SELECT DISTINCT C.ID, C.Name AS CategoryName, " +
"VC.tagSize FROM Venue_Category VC, VenueCategories C WHERE VC.CATEGORY_ID=C.ID " +
"AND VC.VENUE_ID=" + ID);
string justCats = "";
for (int i = 0; i < dvCats.Count; i++)
{
kw.Content += ", " + dvCats[i]["CategoryName"].ToString();
justCats += dvCats[i]["CategoryName"].ToString() + " ";
}
head.Controls.AddAt(0, kw);
hm.Name = "Description";
hm.Content = ShowDescriptionBegining.Text + ", " + kw.Content;
head.Controls.AddAt(0, hm);
this.Title = dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14) + " | " + justCats + " | HippoHappenings";
CalendarLink.NavigateUrl = dat.MakeNiceName(dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14)) + "_" + ID + "_Calendar";
//Media Categories: NONE: 0, Picture: 1, Video: 2, YouTubeVideo: 3, Slider: 4
int mediaCategory = int.Parse(ds.Tables[0].Rows[0]["mediaCategory"].ToString());
DataSet dsEvents = dat.GetData("SELECT EO.DateTimeStart AS Start, EO.DateTimeEnd AS [End], " +
"E.Header, E.ID, E.ShortDescription FROM Event_Occurance EO, Events E WHERE " +
"(CONVERT(NVARCHAR,DAY(EO.DateTimeStart)) + '.' + CONVERT(NVARCHAR,MONTH(EO.DateTimeStart)) + " +
"'.' + CONVERT(NVARCHAR,YEAR(EO.DateTimeStart))) = (CONVERT(NVARCHAR,DAY(GETDATE())) + " +
"'.' + CONVERT(NVARCHAR,MONTH(GETDATE())) + '.' + CONVERT(NVARCHAR,YEAR(GETDATE())))" +
"AND EO.EventID=E.ID AND E.Venue=" + ID + " ORDER BY Start");
bool noEvents = false;
EventsPanel.Controls.Clear();
if (dsEvents.Tables.Count > 0)
if (dsEvents.Tables[0].Rows.Count > 0)
{
int eventCount = dsEvents.Tables[0].Rows.Count;
for (int i = 0; i < eventCount; i++)
{
HyperLink eventHeader = new HyperLink();
eventHeader.CssClass = "CalendarHeader";
eventHeader.NavigateUrl = dat.MakeNiceName(dsEvents.Tables[0].Rows[i]["Header"].ToString())+"_" + dsEvents.Tables[0].Rows[i]["ID"].ToString()+"_Event";
eventHeader.Text = dsEvents.Tables[0].Rows[i]["Header"].ToString() + "<br/>";
Label dateStart = new Label();
dateStart.CssClass = "CalendarTime";
dateStart.Text = DateTime.Parse(dsEvents.Tables[0].Rows[i]["Start"].ToString()).ToShortTimeString() + " - " +
DateTime.Parse(dsEvents.Tables[0].Rows[i]["End"].ToString()).ToShortTimeString() + "<br/>";
Label shortDescription = new Label();
shortDescription.CssClass = "CalendarDescription";
shortDescription.Text = dsEvents.Tables[0].Rows[i]["ShortDescription"].ToString() + "<br/><br/>";
EventsPanel.Controls.Add(eventHeader);
EventsPanel.Controls.Add(dateStart);
EventsPanel.Controls.Add(shortDescription);
}
}
else
{
noEvents = true;
}
else
{
noEvents = true;
}
if (noEvents)
{
HyperLink eventHeader = new HyperLink();
eventHeader.CssClass = "CalendarHeader";
eventHeader.Text = "There are no events at " + dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14) + " today.";
EventsPanel.Controls.Add(eventHeader);
}
//Media Categories: NONE: 0, Picture: 1, Video: 2, YouTubeVideo: 3, Slider: 4
string youtube = ds.Tables[0].Rows[0]["YouTubeVideo"].ToString();
Rotator1.Items.Clear();
switch (mediaCategory)
{
case 0:
break;
case 1:
ShowVideoPictureLiteral.Text = "";
char[] delim4 = { ';' };
string[] youtokens = youtube.Split(delim4);
if (youtube != "")
{
for (int i = 0; i < youtokens.Length; i++)
{
if (youtokens[i].Trim() != "")
{
Literal literal3 = new Literal();
literal3.Text = "<div style=\"float:left;\"><object width=\"400\" height=\"250\"><param name=\"wmode\" value=\"opaque\" ></param><param name=\"movie\" value=\"http://www.youtube.com/v/" + youtokens[i] +
"\"></param><param name=\"allowFullScreen\" value=\"true\"></param><embed wmode=\"opaque\" src=\"http://www.youtube.com/v/" + youtokens[i] +
"\" type=\"application/x-shockwave-flash\" allowfullscreen=\"true\" width=\"400\" height=\"250\"></embed></object></div>";
Telerik.Web.UI.RadRotatorItem r3 = new Telerik.Web.UI.RadRotatorItem();
r3.Controls.Add(literal3);
Rotator1.Items.Add(r3);
}
}
}
DataView dsSlider = dat.GetDataDV("SELECT * FROM Venue_Slider_Mapping WHERE VenueID=" + ID);
if (dsSlider.Count > 0)
{
char[] delim = { '\\' };
char[] delim3 = { '.' };
string[] fileArray = System.IO.Directory.GetFiles(MapPath(".") + "\\VenueFiles\\" + ID + "\\Slider");
string[] finalFileArray = new string[fileArray.Length];
for (int i = 0; i < dsSlider.Count; i++)
{
int length = fileArray[i].Split(delim).Length;
finalFileArray[i] = "http://" + Request.Url.Authority + "/HippoHappenings/VenueFiles/" +
ID + "/Slider/" + dsSlider[i]["PictureName"].ToString();
string[] tokens = dsSlider[i]["PictureName"].ToString().Split(delim3);
//dsSlider.RowFilter = "RealPictureName='" + tokens[0] + "." + tokens[1] + "'";
if (tokens.Length >= 2)
{
if (tokens[1].ToUpper() == "JPG" || tokens[1].ToUpper() == "JPEG" || tokens[1].ToUpper() == "GIF" || tokens[1].ToUpper() == "PNG")
{
System.Drawing.Image image = System.Drawing.Image.FromFile(MapPath(".") +
"\\VenueFiles\\" + ID + "\\Slider\\" + dsSlider[i]["PictureName"].ToString());
int width = 400;
int height = 250;
int newHeight = 0;
int newIntWidth = 0;
//if image height is less than resize height
if (height >= image.Height)
{
//leave the height as is
newHeight = image.Height;
if (width >= image.Width)
{
newIntWidth = image.Width;
}
else
{
newIntWidth = width;
double theDivider = double.Parse(image.Width.ToString()) / double.Parse(newIntWidth.ToString());
double newDoubleHeight = double.Parse(newHeight.ToString());
newDoubleHeight = double.Parse(height.ToString()) / theDivider;
newHeight = (int)newDoubleHeight;
}
}
//if image height is greater than resize height...resize it
else
{
//make height equal to the requested height.
newHeight = height;
//get the ratio of the new height/original height and apply that to the width
double theDivider = double.Parse(image.Height.ToString()) / double.Parse(newHeight.ToString());
double newDoubleWidth = double.Parse(newIntWidth.ToString());
newDoubleWidth = double.Parse(image.Width.ToString()) / theDivider;
newIntWidth = (int)newDoubleWidth;
//if the resized width is still to big
if (newIntWidth > width)
{
//make it equal to the requested width
newIntWidth = width;
//get the ratio of old/new width and apply it to the already resized height
theDivider = double.Parse(image.Width.ToString()) / double.Parse(newIntWidth.ToString());
double newDoubleHeight = double.Parse(newHeight.ToString());
newDoubleHeight = double.Parse(image.Height.ToString()) / theDivider;
newHeight = (int)newDoubleHeight;
}
}
Literal literal4 = new Literal();
literal4.Text = "<div style=\"width: 400px; height: 250px;background-color: black;\"><img align=\"middle\" style=\"cursor: pointer; margin-left: " + ((400 - newIntWidth) / 2).ToString() + "px; margin-top: " + ((250 - newHeight) / 2).ToString() + "px;\" height=\"" + newHeight + "px\" width=\"" + newIntWidth + "px\" onclick=\"OpenEventModal(" + i.ToString() + ", " + ID + ");\" height=\"" + height.ToString() + "px\" width=\"" + width.ToString() + "px\" src=\""
+ "VenueFiles/" + ID + "/Slider/" + dsSlider[i]["PictureName"].ToString()+ "\" /></div>";
Telerik.Web.UI.RadRotatorItem r4 = new Telerik.Web.UI.RadRotatorItem();
r4.Controls.Add(literal4);
Rotator1.Items.Add(r4);
}
else if (tokens[1].ToUpper() == "WMV")
{
Literal literal4 = new Literal();
literal4.Text = "<div style=\"float:left;\"><OBJECT wmode=\"transparent\" classid='clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B' " +
"width=\"400\" height=\"250\" codebase='http://www.apple.com/qtactivex/qtplugin.cab'>" +
"<param name='src' value=\"VenueFiles/" + ID + "/Slider/" + fileArray[i].Split(delim)[length - 1].ToString() + "\">" +
"<param name='autoplay' value=\"false\"><param name=\"wmode\" value=\"transparent\"/>" +
"<param name='controller' value=\"true\">" +
"<param name='loop' value=\"false\"><param name=\"wmode2\" value=\"opaque\" ></param>" +
"<EMBED wmode=\"transparent\" wmode2=\"opaque\" src=\"VenueFiles/" + ID + "/Slider/" + fileArray[i].Split(delim)[length - 1].ToString() + "\" width=\"400\" height=\"250\" autoplay=\"false\" " +
"controller=\"true\" loop=\"false\" bgcolor=\"#000000\" pluginspage='http://www.apple.com/quicktime/download/'>" +
"</EMBED>" +
"</OBJECT></div> ";
//literal4.Text = "<div style=\"float:left;\"><embed height=\"250px\" width=\"400px\" src=\""
// + "VenueFiles/" + ID + "/Slider/" + fileArray[i].Split(delim)[length - 1].ToString() + "\" /></div>";
Telerik.Web.UI.RadRotatorItem r4 = new Telerik.Web.UI.RadRotatorItem();
r4.Controls.Add(literal4);
Rotator1.Items.Add(r4);
}
}
}
}
break;
default: break;
}
if (Rotator1.Items.Count == 0)
RotatorPanel.Visible = false;
else
{
RotatorPanel.Visible = true;
if (Rotator1.Items.Count == 1)
{
RotatorPanel.CssClass = "HiddeButtons";
}
}
if (fillUserData)
{
ASP.controls_addtofavorites_ascx AddTo1 = new ASP.controls_addtofavorites_ascx();
AddTo1.VENUE_ID = int.Parse(ID);
ASP.controls_sendmessage_ascx SendMessage1 = new ASP.controls_sendmessage_ascx();
SendMessage1.THE_TEXT = "Share this with a friend";
SendMessage1.RE_LABEL = "Re: " + Session["UserName"].ToString() +
" would like to share the venue '\"" + dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14) + "\"' with you.";
SendMessage1.TYPE = "v";
SendMessage1.ID = int.Parse(ID);
CalendarPanel.Controls.Add(AddTo1);
CalendarPanel.Controls.Add(SendMessage1);
}
this.Title = dat.BreakUpString(ds.Tables[0].Rows[0]["Name"].ToString(), 14);
}
else
{
Response.Redirect("~/Home.aspx");
}
}
else
{
Response.Redirect("~/Home.aspx");
}
}
else
{
Response.Redirect("~/Home.aspx");
}
if (ReturnPanel.Visible)
{
if (EditLink.Visible)
{
if (OwnerPanel.Visible)
{
TopPanel.Width = 430;
}
else
{
TopPanel.Width = 240;
}
}
else
{
if (OwnerPanel.Visible)
{
TopPanel.Width = 300;
}
else
{
TopPanel.Width = 150;
}
}
}
else
{
if (EditLink.Visible)
{
if (OwnerPanel.Visible)
{
TopPanel.Width = 280;
}
else
{
TopPanel.Width = 80;
}
EditLink.Text = " Edit Venue";
}
else
{
if (OwnerPanel.Visible)
{
TopPanel.Width = 60;
}
else
{
TopPanel.Width = 0;
}
HyperLink1.InnerHtml = " Venue Ownership is Open";
}
}
}
catch (Exception ex)
{
ErrorLabel.Text = ex.ToString();
}
}
protected int GetAllEventLiteral(DataView dv, Data dat)
{
Hashtable normalEventHash = new Hashtable();
DataView dvEvents = dv;
int i = 0;
string theLiteral = "<script type=\"text/javascript\">function initializeAll(){var address;";
int thecount = dvEvents.Count;
string oneStringRecord = "";
int normalRecordCount = 0;
int countOfAllUniqueVenues = 0;
try
{
string address = "";
string venue = "";
bool isFirstElement = true;
string country = "US";
Hashtable venueMapping = new Hashtable();
Hashtable venuesNumMapping = new Hashtable();
DataView dvRecords = new DataView();
DataTable dt = new DataTable();
DataColumn dc2 = new DataColumn("Address");
dt.Columns.Add(dc2);
dc2 = new DataColumn("Letter");
dt.Columns.Add(dc2);
foreach (DataRowView row in dvEvents)
{
if (!bool.Parse(row["isGroup"].ToString()))
{
if (!normalEventHash.Contains(row["EID"].ToString()))
{
normalEventHash.Add(row["EID"].ToString(), normalRecordCount.ToString());
address = "";
DataView dvE = dat.GetDataDV("SELECT * FROM Events WHERE ID=" + row["EID"].ToString());
DataView dvV = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + dvE[0]["Venue"].ToString());
DataView dvCountry = dat.GetDataDV("SELECT * FROM countries WHERE country_id=" + dvE[0]["Country"].ToString());
country = dvCountry[0]["country_2_code"].ToString();
if (country.ToLower() == "us")
{
try
{
address = dat.GetAddress(dvV[0]["Address"].ToString(), false);
}
catch (Exception ex1)
{
address = "";
}
}
else
{
address = dat.GetAddress(dvV[0]["Address"].ToString(), true);
}
if (dvE[0]["Country"].ToString().ToLower() == "uk")
{
//VenueName.Text + "@&" +
if (venueMapping.ContainsKey(address))
{
venueMapping[address] += ",<br/><div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>";
}
else
{
countOfAllUniqueVenues++;
if (!isFirstElement)
{
i++;
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; " +
"showAddressUS('<span style=\\\"color: #98cb2a; font-weight: bold;text-decoration: underline; " +
" cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>', 1, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
}
else
{
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; showAddressUS('<span style=\\\"color: #98cb2a; font-weight: bold;text-decoration: underline; " +
" cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',1, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
}
}
}
else
{
//VenueName.Text + "@&" +
if (venueMapping.ContainsKey(address))
{
venueMapping[address] += ",<br/><div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>";
}
else
{
countOfAllUniqueVenues++;
if (!isFirstElement)
{
i++;
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; showAddressUS('<span style=\\\"color: #98cb2a; font-weight: bold;text-decoration: underline; " +
" cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',1, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
}
else
{
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; showAddressUS('<span style=\\\"color: #98cb2a; font-weight: bold;text-decoration: underline; " +
"cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',1, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
}
}
}
isFirstElement = false;
normalRecordCount++;
venue = address;
}
}
else
{
countOfAllUniqueVenues++;
bool isVenue = false;
address = "";
DataView dvE = dat.GetDataDV("SELECT * FROM GroupEvents GE, GroupEvent_Occurance GEO WHERE GE.ID=" +
row["EID"].ToString() + " AND GEO.GroupEventID=GE.ID AND GEO.ID=" + row["ReoccurrID"].ToString());
country = dat.GetDataDV("SELECT * FROM Countries C, GroupEvent_Occurance GEO WHERE GEO.ID=" +
row["ReoccurrID"].ToString() +
" AND C.country_id=GEO.Country ")[0]["country_2_code"].ToString();
DataView dvV = new DataView();
if (dvE[0]["VenueID"] != null)
{
if (dvE[0]["VenueID"].ToString().Trim() != "")
{
dvV = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + dvE[0]["VenueID"].ToString());
address = dat.GetAddress(dvV[0]["Address"].ToString(),
dvV[0]["Country"].ToString() != "223").Trim();
isVenue = true;
}
}
if (!isVenue)
{
if (dvE[0]["Country"].ToString() == "223")
{
address = dvE[0]["StreetNumber"].ToString() + " " + dvE[0]["StreetName"].ToString() +
" " + dvE[0]["StreetDrop"].ToString();
}
else
{
address = dvE[0]["Location"].ToString();
}
}
address = address.Trim() + " " + dvE[0]["City"].ToString() + " " + dvE[0]["State"].ToString() +
" " + dvE[0]["Zip"].ToString() + " " + country;
if (venueMapping.ContainsKey(address))
{
venueMapping[address] += ",<br/><div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Name"].ToString()) + "_" + row["ReoccurrID"].ToString() + "_" +
dvE[0]["ID"].ToString() + "_GroupEvent" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>";
}
else
{
if (!isFirstElement)
{
i++;
if (isVenue)
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(",
" ").Replace(")", " ") + "';showAddressUS('<span style=\\\"color: #98cb2a; font-weight: bold;text-decoration: underline; " +
"cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',1, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Name"].ToString()) + "_" + row["ReoccurrID"].ToString() + "_" +
dvE[0]["ID"].ToString() + "_GroupEvent" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
else
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(",
" ").Replace(")", " ") + "';showAddressUS('', 1, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Name"].ToString()) + "_" + row["ReoccurrID"].ToString() + "_" +
dvE[0]["ID"].ToString() + "_GroupEvent" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
}
else
{
if (isVenue)
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(",
" ").Replace(")", " ") + "'; showAddressUS('<span style=\\\"color: #98cb2a; font-weight: bold;text-decoration: underline; " +
"cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',1, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Name"].ToString()) + "_" + row["ReoccurrID"].ToString() + "_" +
dvE[0]["ID"].ToString() + "_GroupEvent" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
else
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(",
" ").Replace(")", " ") + "';showAddressUS('', 1, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Name"].ToString()) + "_" + row["ReoccurrID"].ToString() + "_" +
dvE[0]["ID"].ToString() + "_GroupEvent" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
}
}
isFirstElement = false;
normalRecordCount++;
venue = address;
}
}
dvRecords = new DataView(dt, "", "Letter ASC", DataViewRowState.CurrentRows);
oneStringRecord = theLiteral;
int theCount = 0;
foreach (DataRowView rowster in dvRecords)
{
if (theCount == 0)
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', false);".Replace(" ",
" ").Replace(" ", " ");
if (theCount == dvRecords.Count - 1)
{
oneStringRecord += " }}</script>".Replace(" ",
" ").Replace(" ", " ");
}
}
else if (theCount == dvRecords.Count - 1)
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', false); }}</script>".Replace(" ",
" ").Replace(" ", " ");
}
else
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', false);".Replace(" ",
" ").Replace(" ", " ");
}
theCount++;
}
}
catch (Exception ex)
{
ErrorLabel.Text = ex.ToString();
}
ScriptLiteral.Text = oneStringRecord;
return countOfAllUniqueVenues;
}
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
if (cookie == null)
{
cookie = new HttpCookie("BrowserDate");
cookie.Value = DateTime.Now.ToString();
cookie.Expires = DateTime.Now.AddDays(22);
Response.Cookies.Add(cookie);
}
Literal lit = new Literal();
lit.Text = "<script src=\"http://maps.google.com/maps?file=api&v=2&sensor=false&key=ABQIAAAAjjoxQtYNtdn3Tc17U5-jbBR2Kk_H7gXZZZniNQ8L14X1BLzkNhQjgZq1k-Pxm8FxVhUy3rfc6L9O4g\" type=\"text/javascript\"></script>";
Master.HEAD_TAG.Controls.Add(lit);
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
string command = "";
try
{
DataView dvGroup = dat.GetDataDV("SELECT * FROM GroupEvents WHERE ID=" + Request.QueryString["ID"].ToString());
DataView dvRealGroup = dat.GetDataDV("SELECT * FROM Groups WHERE ID=" +
dvGroup[0]["GroupID"].ToString());
string groupID = dvRealGroup[0]["ID"].ToString();
#region Take Care of Style
ColorAa_1.Style.Add("background-color", "#" + dvGroup[0]["ColorA"].ToString());
ColorAb_1.Style.Add("background-color", "#" + dvGroup[0]["ColorA"].ToString());
ColorAa_1.Style.Add("color", "#" + dvGroup[0]["TextA"].ToString());
ColorAa_2.Style.Add("background-color", "#" + dvGroup[0]["ColorA"].ToString());
ColorAb_2.Style.Add("background-color", "#" + dvGroup[0]["ColorA"].ToString());
ColorAa_2.Style.Add("color", "#" + dvGroup[0]["TextA"].ToString());
ColorAa_3.Style.Add("background-color", "#" + dvGroup[0]["ColorA"].ToString());
ColorAb_3.Style.Add("background-color", "#" + dvGroup[0]["ColorA"].ToString());
ColorAa_3.Style.Add("color", "#" + dvGroup[0]["TextA"].ToString());
ColorBa_1.Style.Add("background-color", "#" + dvGroup[0]["ColorB"].ToString());
ColorBb_1.Style.Add("background-color", "#" + dvGroup[0]["ColorB"].ToString());
ColorBa_1.Style.Add("color", "#" + dvGroup[0]["TextB"].ToString());
//ColorBa_2.Style.Add("background-color", "#" + dvGroup[0]["ColorB"].ToString());
//ColorBb_2.Style.Add("background-color", "#" + dvGroup[0]["ColorB"].ToString());
//ColorBa_2.Style.Add("color", "#" + dvGroup[0]["TextB"].ToString());
ColorBa_3.Style.Add("background-color", "#" + dvGroup[0]["ColorB"].ToString());
ColorBb_3.Style.Add("background-color", "#" + dvGroup[0]["ColorB"].ToString());
ColorBa_3.Style.Add("color", "#" + dvGroup[0]["TextB"].ToString());
ColorBa_4.Style.Add("background-color", "#" + dvGroup[0]["ColorB"].ToString());
ColorBb_4.Style.Add("background-color", "#" + dvGroup[0]["ColorB"].ToString());
ColorBa_4.Style.Add("color", "#" + dvGroup[0]["TextB"].ToString());
MapLabels.Style.Add("color", "#" + dvGroup[0]["TextA"].ToString() + " !important");
#endregion
command = "SELECT * FROM GroupEvent_Occurance WHERE ID=" + Request.QueryString["O"].ToString();
DataView dvEvent = dat.GetDataDV(command);
if (dvEvent.Count == 0)
{
command = "SELECT * FROM GroupEvent_Occurance WHERE GroupEventID=" +
Request.QueryString["ID"].ToString();
dvEvent = dat.GetDataDV(command);
if (dvEvent.Count > 0)
{
Response.Redirect(dat.MakeNiceName(dvGroup[0]["Name"].ToString()) + "_" + dvEvent[0]["ID"].ToString() + "_" + Request.QueryString["ID"].ToString() + "_GroupEvent");
}
else
{
Response.Redirect(dat.MakeNiceName(dvRealGroup[0]["Name"].ToString()) +
"_" + dvRealGroup[0]["ID"].ToString() + "_Group");
}
}
DateAndTimeLabel.Text = dvEvent[0]["DateTimeStart"].ToString() + " -- " + dvEvent[0]["DateTimeEnd"].ToString();
GroupLabel.Text = dvRealGroup[0]["Header"].ToString();
GroupLabel.NavigateUrl = dat.MakeNiceName(dvRealGroup[0]["Header"].ToString()) + "_" + dvRealGroup[0]["ID"].ToString() + "_Group";
Page.Title = dvGroup[0]["Name"].ToString() + " | Hippo Group Event";
if (!IsPostBack)
{
Session["RedirectTo"] = Request.Url.AbsoluteUri;
}
string country = dat.GetDataDV("SELECT * FROM Countries WHERE country_id=" + dvEvent[0]["Country"].ToString())[0]["country_name"].ToString();
Literal liter = new Literal();
liter.Text = "<link type=\"text/css\" href=\"Rads.css\" rel=\"stylesheet\" />";
Page.Header.Controls.Add(liter);
bool isMember = false;
#region Take care of user types
if (Session["User"] != null)
{
#region Take care of Share with friends and Share though email and Flag
LoggedInPanel.Visible = true;
ShareFriends.THE_TEXT = "Share this with a friend";
ShareFriends.RE_LABEL = "Re: " + Session["UserName"].ToString() +
" would like to share the group event '\"" + dat.BreakUpString(dvGroup[0]["Name"].ToString(), 14) +
"\"' with you.";
ShareFriends.TYPE = "ge";
ShareFriends.ID = int.Parse(Request.QueryString["ID"].ToString());
string descrip = dvGroup[0]["Content"].ToString();
if (descrip.Length > 200)
descrip = descrip.Substring(0, 200) + "...";
Session["messageEmail"] = "Group Event Name: <a href=\"http://hippohappenings.com/" +
dat.MakeNiceName(dat.BreakUpString(dvGroup[0]["Name"].ToString(), 14)) + "_" +
Request.QueryString["O"].ToString() + "_" +
Request.QueryString["ID"].ToString() + "_GroupEvent\">" +
dat.BreakUpString(dvGroup[0]["Name"].ToString(), 14) + "</a><br/><br/> " +
descrip;
Session["FlagID"] = Request.QueryString["ID"].ToString();
Session["FlagType"] = "GE";
Session["ReOccurID"] = Request.QueryString["O"].ToString();
DataView dvMember = dat.GetDataDV("SELECT * FROM Group_Members WHERE GroupID=" +
dvGroup[0]["GroupID"].ToString() + " AND MemberID=" + Session["User"].ToString());
PostMessageID.Attributes.Add("onclick", "OpenMess('" + Request.QueryString["ID"].ToString() +
"', '" + Request.QueryString["O"].ToString() + "')");
#endregion
switch (dvGroup[0]["EventType"].ToString())
{
case "1":
PrivateLabel.Text = "Public Event";
break;
case "2":
PrivateLabel.Text = "Private Event";
break;
case "3":
PrivateLabel.Text = "Exclusive Event";
break;
default: break;
}
DataView dvGoingMember = dat.GetDataDV("SELECT * FROM GroupEvent_Members WHERE GroupEventID=" +
Request.QueryString["ID"].ToString() + " AND Accepted='True' AND ReoccurrID=" +
Request.QueryString["O"].ToString());
dvGoingMember.RowFilter = "UserID=" + Session["User"].ToString();
//if it's a public event
if(dvGroup[0]["EventType"].ToString() == "1")
dvGoingMember = dat.GetDataDV("SELECT * FROM User_GroupEvent_Calendar WHERE GroupEventID=" +
Request.QueryString["ID"].ToString() + " AND ReoccurrID=" +
Request.QueryString["O"].ToString());
dvGoingMember.RowFilter = "UserID=" + Session["User"].ToString();
AreGoingPanel.Visible = false;
RegistrationEndedPanel.Visible = false;
GoingPanel.Visible = true;
if (dvGoingMember.Count > 0)
{
AreGoingPanel.Visible = true;
RegistrationEndedPanel.Visible = false;
GoingPanel.Visible = false;
}
else
{
dvGoingMember.RowFilter = "";
if (dvGroup[0]["RegType"].ToString() == "2")
{
if (dvGroup[0]["RegNum"] != null)
{
if (dvGroup[0]["RegNum"].ToString().Trim() != "")
{
if (dvGoingMember.Count >= int.Parse(dvGroup[0]["RegNum"].ToString()))
{
AreGoingPanel.Visible = false;
RegistrationEndedPanel.Visible = true;
GoingPanel.Visible = false;
}
else
{
AreGoingPanel.Visible = false;
RegistrationEndedPanel.Visible = false;
GoingPanel.Visible = true;
}
}
if (dvGroup[0]["RegDeadline"] != null)
{
if (dvGroup[0]["RegDeadline"].ToString().Trim() != "")
{
if (DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")) >
DateTime.Parse(dvGroup[0]["RegDeadline"].ToString()))
{
AreGoingPanel.Visible = false;
RegistrationEndedPanel.Visible = true;
GoingPanel.Visible = false;
}
}
}
}
if (dvGroup[0]["RegDeadline"] != null)
{
if (dvGroup[0]["RegDeadline"].ToString().Trim() != "")
{
if (DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")) >
DateTime.Parse(dvGroup[0]["RegDeadline"].ToString()))
{
AreGoingPanel.Visible = false;
RegistrationEndedPanel.Visible = true;
GoingPanel.Visible = false;
}
}
}
}
else
{
DataView dvInvitedMember = dat.GetDataDV("SELECT * FROM GroupEvent_Members WHERE GroupEventID=" +
Request.QueryString["ID"].ToString() + " AND ReoccurrID=" +Request.QueryString["O"].ToString());
DataView dvMember2 = dat.GetDataDV("SELECT * FROM Group_Members WHERE GroupID=" +
groupID + " AND MemberID=" + Session["User"].ToString());
if (dvGroup[0]["EventType"].ToString() == "2")
{
if (dvMember2.Count > 0)
{
AreGoingPanel.Visible = false;
RegistrationEndedPanel.Visible = false;
GoingPanel.Visible = true;
}
else
{
AreGoingPanel.Visible = false;
RegistrationEndedPanel.Visible = false;
GoingPanel.Visible = false;
}
}
else if (dvGroup[0]["EventType"].ToString() == "3")
{
dvInvitedMember.RowFilter = "UserID=" + Session["User"].ToString();
if (dvInvitedMember.Count > 0)
{
AreGoingPanel.Visible = false;
RegistrationEndedPanel.Visible = false;
GoingPanel.Visible = true;
}
else
{
AreGoingPanel.Visible = false;
RegistrationEndedPanel.Visible = false;
GoingPanel.Visible = false;
}
}
else
{
AreGoingPanel.Visible = false;
RegistrationEndedPanel.Visible = false;
GoingPanel.Visible = true;
}
}
}
if (dvMember.Count > 0)
{
isMember = true;
if (bool.Parse(dvMember[0]["SharedHosting"].ToString()))
{
Session["isHost"] = true;
HostHeaderPanel.Visible = true;
MemberHeaderPanel.Visible = false;
//if is host, take care of host options
LinkButton1.Attributes.Add("onclick", "window.location='EnterGroupEvent.aspx?ID=" + Request.QueryString["ID"].ToString() + "&GroupID=" + dvGroup[0]["GroupID"].ToString() + "&O=" + Request.QueryString["O"].ToString() + "';");
LinkButton2.Attributes.Add("onclick", "window.location='EnterGroupEvent.aspx?copy=true&ID=" + Request.QueryString["ID"].ToString() + "&GroupID=" + dvGroup[0]["GroupID"].ToString() + "';");
Label1.Attributes.Add("onclick", "OpenSendMess('" + Request.QueryString["ID"].ToString() + "')");
Label3.Attributes.Add("onclick", "OpenParticipants('" + Request.QueryString["ID"].ToString() +
"', '" + Request.QueryString["O"].ToString() + "')");
Label2.Attributes.Add("onclick", "OpenGroupEventDelete('" + Request.QueryString["ID"].ToString() +
"', '" + Request.QueryString["O"].ToString() + "')");
}
else
{
Session["isHost"] = false;
Session["isMember"] = true;
HostHeaderPanel.Visible = false;
MemberHeaderPanel.Visible = true;
}
PostMessagePanel.Visible = true;
}
else
{
Session["isHost"] = false;
Session["isMember"] = false;
HostHeaderPanel.Visible = false;
MemberHeaderPanel.Visible = false;
PostMessagePanel.Visible = false;
}
}
else
{
Session["isHost"] = false;
Session["isMember"] = false;
HostHeaderPanel.Visible = false;
MemberHeaderPanel.Visible = false;
PostMessagePanel.Visible = false;
}
#endregion
#region Members
string members = "";
string friendImg = "";
string strFill = "";
string title = "";
string description = "";
string mem = "";
FillMembers();
#endregion
#region Stuff we need
DataView dvStuff = dat.GetDataDV("SELECT * FROM GroupEvent_StuffNeeded WHERE GroupEventID=" +
Request.QueryString["ID"].ToString());
if (dvStuff.Count > 0)
StuffsPanel.Visible = true;
CheckBox check;
DataView dvUserID;
bool userNotGrabbed = false;
bool isStuffCheckable = bool.Parse(dvGroup[0]["StuffNeededCheckable"].ToString());
foreach (DataRowView row in dvStuff)
{
userNotGrabbed = false;
if (row["UserID"] == null)
{
userNotGrabbed = true;
}
else
{
if (row["UserID"].ToString() == "")
userNotGrabbed = true;
else
{
//if (isMember)
//{
if (isStuffCheckable)
{
dvUserID = dat.GetDataDV("SELECT * FROM Users WHERE User_ID=" + row["UserID"].ToString());
string addthis = "";
if (Session["User"] != null)
{
if (row["UserID"].ToString() == Session["User"].ToString())
{
addthis = "<div style=\"float: left;\"><img style=\"cursor: pointer;\" name=\"remove the user\" src=\"image/X.png\" onclick=\"RemoveStuffUser('" + row["ID"].ToString() +
"');\" onmouseout=\"this.src = 'image/X.png';\" " +
"onmouseover=\"this.src = 'image/XSelected.png';\" /></div>";
}
}
lit = new Literal();
lit.ID = "lit" + row["ID"].ToString();
lit.Text = "<div class=\"topDiv\" width=\"400px\" style=\"padding-top: 5px;\"><div style=\"float: left;\"><ul style=\"font-weight: bold;padding: 0; margin: 0; color: #" + dvGroup[0]["TextA"].ToString() + " !important;padding-left: 22px;\"><li><span style=\"color: #" + dvGroup[0]["TextA"].ToString() + " !important; font-size: 14px;\"><div style=\"float: left;\">" + row["StuffNeeded"].ToString() +
" -- </div><div style=\"float: left;padding-left: 5px;\"><div style=\"float: left;\"><div style=\"height: 19px; background-position: left; background-repeat: no-repeat; background-image: url(images/UserNameLeft.png); " +
"padding-left: 4px;\"><div style=\"height: 19px; background-repeat: no-repeat; background-position: right; " +
"background-image: url(images/UserNameRight.png); " +
"padding-right: 4px;\"><div style=\"height: 19px; background-repeat: repeat-x; " +
"background-image: url(images/UserNameMiddle.png);\"><a style=\"float: left;padding-bottom: 0px;\" href=\"" + dvUserID[0]["UserName"].ToString() + "_Friend\" class=\"AddLink\">" +
dvUserID[0]["UserName"].ToString() + "</a></div></div></div></div></div></span></li></ul></div>" + addthis + "</div>";
StuffWeNeedPanel.Controls.Add(lit);
}
else
{
lit = new Literal();
lit.ID = "lit" + row["ID"].ToString();
lit.Text = "<div class=\"topDiv\" width=\"400px\" style=\"padding-top: 5px;\">"+
"<div style=\"float: left;\"><ul style=\"font-weight: bold;padding: 0; margin: 0; "+
"color: #" + dvGroup[0]["TextA"].ToString() + " !important;padding-left: 22px;\">"+
"<li><span style=\"color: #" + dvGroup[0]["TextA"].ToString() + " !important; "+
"font-size: 14px;\"><div style=\"float: left;\">" + row["StuffNeeded"].ToString() +
"</div></span></li></ul></div></div>";
StuffWeNeedPanel.Controls.Add(lit);
}
//}
}
}
if (isMember)
{
if (userNotGrabbed)
{
if (isStuffCheckable)
{
check = new CheckBox();
check.ID = "check" + row["ID"].ToString();
check.Text = row["StuffNeeded"].ToString();
check.AutoPostBack = true;
check.CheckedChanged += new EventHandler(StuffGrabbed);
check.ForeColor = System.Drawing.ColorTranslator.FromHtml("#" + dvGroup[0]["TextB"].ToString());
check.Font.Size = 14;
lit = new Literal();
lit.Text = "<div width=\"400px\">";
StuffWeNeedPanel.Controls.Add(lit);
StuffWeNeedPanel.Controls.Add(check);
lit = new Literal();
lit.Text = "</div>";
StuffWeNeedPanel.Controls.Add(lit);
}
else
{
lit = new Literal();
lit.Text = "<div width=\"400px\" style=\"padding-top: 5px;\"><ul style=\"font-weight: bold;padding: 0; margin: 0; color: #" +
dvGroup[0]["TextB"].ToString() + " !important;padding-left: 22px;\"><li><span style=\" color: #" +
dvGroup[0]["TextB"].ToString() + " !important; font-size: 14px;\">" + row["StuffNeeded"].ToString() +
"</span></li></ul></div>";
StuffWeNeedPanel.Controls.Add(lit);
}
}
}
else
{
if (userNotGrabbed)
{
lit = new Literal();
lit.Text = "<div width=\"400px\" style=\"padding-top: 5px;\"><ul style=\"font-weight: bold;padding: 0; margin: 0; color: #" +
dvGroup[0]["TextB"].ToString() + " !important;padding-left: 22px;\"><li><span style=\" color: #" +
dvGroup[0]["TextB"].ToString() + " !important; font-size: 14px;\">" + row["StuffNeeded"].ToString() +
"</span></li></ul></div>";
StuffWeNeedPanel.Controls.Add(lit);
}
}
}
#endregion
DataView dvUser = dat.GetDataDV("SELECT * FROM Users WHERE User_ID=" + dvGroup[0]["UserID"].ToString());
HostLabel.Text = dvUser[0]["UserName"].ToString();
HostLabel.NavigateUrl = HostLabel.Text + "_Friend";
EventName.Text = dvGroup[0]["Name"].ToString();
#region Event Message Board
DataView dvMessages = dat.GetDataDV("SELECT *, GM.ID AS MessageID FROM GroupEventMessages GM, Users U WHERE GM.GroupEventID=" +
Request.QueryString["ID"].ToString() + " AND GM.UserID=U.User_ID");
DataView dvSticky = dat.GetDataDV("SELECT *, GM.ID AS MessageID FROM GroupEventMessages GM, Group_Members M, Users U WHERE GM.GroupEventID=" +
Request.QueryString["ID"].ToString() + " AND GM.UserID=U.User_ID and M.GroupID=" +
dvGroup[0]["GroupID"].ToString() + " AND M.MemberID=U.User_ID AND M.SharedHosting='True' AND GM.isSticky='True'");
members = "";
friendImg = "";
strFill = "";
description = "";
string stickyID = "";
if (dvSticky.Count > 0)
{
dvSticky.Sort = "DatePosted DESC";
stickyID = dvSticky[0]["MessageID"].ToString();
if (System.IO.File.Exists(Server.MapPath(".") + "\\UserFiles\\" + dvSticky[0]["UserName"].ToString() +
"\\Profile\\" + dvSticky[0]["ProfilePicture"].ToString()))
{
friendImg = "UserFiles/" + dvSticky[0]["UserName"].ToString() + "/Profile/" + dvSticky[0]["ProfilePicture"].ToString();
strFill = "";
}
else
{
friendImg = "image/noAvatar_50x50_small.png";
strFill = "onmouseover=\"this.src='NewImages/noAvatar_50x50_smallhover.png'\"" +
"onmouseout=\"this.src='image/noAvatar_50x50_small.png'\" ";
}
string imgLit = "";
if (Session["User"] != null)
{
if (Session["User"].ToString() == dvSticky[0]["User_ID"].ToString())
{
imgLit = "<div style=\"float: right;\"><img style=\"cursor: pointer;\" name=\"remove stickyness\" src=\"image/X.png\" onclick=\"OpenRemoveSticky('" + Request.QueryString["ID"].ToString() +
"', '" + stickyID + "', '"+Request.QueryString["O"].ToString()+"');\" onmouseout=\"this.src = 'image/X.png';\" " +
"onmouseover=\"this.src = 'image/XSelected.png';\" /></div>";
}
}
members = imgLit + "<div style=\"border-bottom: solid 1px #1b1b1b;float: left; clear: both; padding-left: 3px; padding-top: 5px;\"><a target='_blank' href=\"" + dvSticky[0]["UserName"].ToString() + "_Friend\"><img " + strFill +
" style=\" border: 0;float: left;padding-right: 7px; padding-bottom: 2px;\" " +
"src=\"" + friendImg + "\" width=\"50px\" height=\"50px\" /></a><div style=\"float: left;\"><div style=\"height: 19px; background-position: left; background-repeat: no-repeat; background-image: url(images/UserNameLeft.png); " +
"padding-left: 4px;\"><div style=\"height: 19px; background-repeat: no-repeat; background-position: right; " +
"background-image: url(images/UserNameRight.png); " +
"padding-right: 4px;\"><div style=\"height: 19px; background-repeat: repeat-x; " +
"background-image: url(images/UserNameMiddle.png);\"><a style=\"float: left;padding-bottom: 0px;\" href=\"" + dvSticky[0]["UserName"].ToString() + "_Friend\" class=\"AddLink\">" +
dvSticky[0]["UserName"].ToString() +
"</a></div></div></div></div><span class=\"MemberTitle\" style=\"color: #" + dvGroup[0]["TextB"].ToString() + " !important;\"> - Posted On: " +
dvSticky[0]["DatePosted"].ToString().Trim() +
"</span> - <span style=\"color: #ff6b09; font-size: 30px;font: bold;\">!</span>" +
"<span class=\"MemberDescription\" style=\"color: #" + dvGroup[0]["TextB"].ToString() + " !important;\"> " + dvSticky[0]["Content"].ToString() +
"</span><span style=\"font: bold;color: #ff6b09; font-size: 30px;\">!</span></div>";
StickyMessageLiteral.Text = members;
}
members = "";
if (stickyID != "")
{
dvMessages.RowFilter = "MessageID <> " + stickyID;
}
if (dvMessages.Count == 0)
{
lit = new Literal();
lit.Text = "<div class=\"EventMemberDescription\" style=\"color: #" + dvGroup[0]["TextB"].ToString() + " !important;\">No messages have been posted for this group.</div>";
MessagesPanel.Controls.Add(lit);
}
else
{
dvMessages.Sort = "DatePosted DESC";
foreach (DataRowView row in dvMessages)
{
if (System.IO.File.Exists(Server.MapPath(".") + "\\UserFiles\\" + row["UserName"].ToString() +
"\\Profile\\" + row["ProfilePicture"].ToString()))
{
friendImg = "UserFiles/" + row["UserName"].ToString() + "/Profile/" + row["ProfilePicture"].ToString();
strFill = "";
}
else
{
friendImg = "image/noAvatar_50x50_small.png";
strFill = "onmouseover=\"this.src='NewImages/noAvatar_50x50_smallhover.png'\"" +
"onmouseout=\"this.src='image/noAvatar_50x50_small.png'\" ";
}
description = "<span class=\"MemberDescription\" style=\"color: #" + dvGroup[0]["TextB"].ToString() + " !important;\"> " + row["Content"].ToString().Trim() + "</span>";
members += "<div style=\"float: left; clear: both; padding-left: 3px; padding-top: 5px;\"><a target='_blank' href=\"" + row["UserName"].ToString() + "_Friend\"><img " + strFill +
" style=\" border: 0;float: left;padding-right: 7px; padding-bottom: 2px;\" " +
"src=\"" + friendImg + "\" width=\"50px\" height=\"50px\" /></a><div style=\"float: left;\"><div style=\"height: 19px; background-position: left; background-repeat: no-repeat; background-image: url(images/UserNameLeft.png); " +
"padding-left: 4px;\"><div style=\"height: 19px; background-repeat: no-repeat; background-position: right; " +
"background-image: url(images/UserNameRight.png); " +
"padding-right: 4px;\"><div style=\"height: 19px; background-repeat: repeat-x; " +
"background-image: url(images/UserNameMiddle.png);\"><a style=\"float: left;padding-bottom: 0px;\" href=\"" + row["UserName"].ToString() + "_Friend\" class=\"AddLink\">" +
row["UserName"].ToString() + "</a></div></div></div></div><span class=\"MemberTitle\" style=\"color: #" + dvGroup[0]["TextB"].ToString() + " !important;\"> - Posted On: " + row["DatePosted"].ToString().Trim() + "</span> - " + description + "</div>";
}
lit = new Literal();
lit.Text = members;
MessagesPanel.Controls.Add(lit);
}
#endregion
#region Take care of Groupings
DataView dvGroupings = dat.GetDataDV("SELECT * FROM GroupEvent_Groupings WHERE GroupEventID=" + Request.QueryString["ID"].ToString());
DataView dvGroupingMembers = dat.GetDataDV("SELECT * FROM GroupEvent_UserGroupings GG, Users U "+
"WHERE GG.UserID=U.User_ID AND GG.GroupEventID=" + Request.QueryString["ID"].ToString());
if (dvGroupings.Count > 0)
{
string headerStr = "";
string usersStr = "";
GroupingLabel.Text = "Groupings";
Telerik.Web.UI.RadToolTip tip;
foreach (DataRowView row in dvGroupings)
{
lit = new Literal();
lit.Text = "<div style=\"float: left; padding-bottom: 10px;\">";
GroupingPanel.Controls.Add(lit);
Label lab = new Label();
lab.Text = row["GroupingName"].ToString();
lab.CssClass = "AddWhiteLink";
lab.ID = "tooltip" + row["ID"].ToString();
GroupingPanel.Controls.Add(lab);
tip = new RadToolTip();
tip.Text = "<div class=\"EventDiv\"><label>" + row["GroupingDescription"].ToString() + "</label></div>";
tip.TargetControlID = lab.ClientID;
tip.IsClientID = true;
tip.ManualClose = true;
tip.Position = ToolTipPosition.MiddleRight;
tip.RelativeTo = ToolTipRelativeDisplay.Element;
tip.Skin = "Black";
tip.Width = 200;
tip.ShowEvent = ToolTipShowEvent.OnClick;
GroupingPanel.Controls.Add(tip);
lit = new Literal();
lit.Text = "<br/>";
GroupingPanel.Controls.Add(lit);
dvGroupingMembers.RowFilter = "GroupingID=" + row["ID"].ToString();
headerStr = "";
foreach (DataRowView row2 in dvGroupingMembers)
{
friendImg = "";
strFill = "";
if (System.IO.File.Exists(Server.MapPath(".") + "\\UserFiles\\" + row2["UserName"].ToString() +
"\\Profile\\" + row2["ProfilePicture"].ToString()))
{
friendImg = "UserFiles/" + row2["UserName"].ToString() + "/Profile/" +
row2["ProfilePicture"].ToString();
strFill = "";
}
else
{
friendImg = "image/noAvatar_50x50_small.png";
strFill = "onmouseover=\"this.src='NewImages/noAvatar_50x50_smallhover.png'\"" +
"onmouseout=\"this.src='image/noAvatar_50x50_small.png'\" ";
}
headerStr += "<div style=\"float: left; clear: both; padding-left: 3px; padding-top: 5px;\"><a target='_blank' href=\"" + row2["UserName"].ToString() + "_Friend\"><img " + strFill +
" style=\" border: 0;float: left;padding-right: 7px; padding-bottom: 2px;\" " +
"src=\"" + friendImg + "\" title=\"" + row2["UserName"].ToString() +
"\" name=\"" + row2["UserName"].ToString() +
"\" width=\"50px\" height=\"50px\" /></a></div><br/>";
}
headerStr += "</div>";
lit = new Literal();
lit.Text = headerStr;
GroupingPanel.Controls.Add(lit);
}
}
else
{
MembersPanel.Width = 435;
}
#endregion
//other details
DescriptionLiteral.Text = "<div style=\"color: White; font-size: 18px;padding-bottom: 3px;border-bottom: solid 1px #" + dvGroup[0]["ColorA"].ToString() + ";\" " +
">Our Event Details</div>";
if (dvGroup[0]["Agenda"] != null)
{
if (dvGroup[0]["Agenda"].ToString().Trim() != "")
{
AgendaLiteral.Text = MakeAgenda(dvGroup[0]["Agenda"].ToString()).Replace("color: #cccccc;", "color: #" + dvGroup[0]["TextB"].ToString() + ";");
AgendaPanel.Visible = true;
}
else
AgendaPanel.Visible = false;
}
else
{
AgendaPanel.Visible = false;
}
//TagCloud.THE_ID = int.Parse(Request.QueryString["ID"].ToString());
GroupDescriptionLabel.Text = dvGroup[0]["Content"].ToString();
HostLabel.Text = dvUser[0]["UserName"].ToString();
#region Take care of map
HttpCookie cookie2 = new HttpCookie("addressParameterName");
cookie2.Value = dvGroup[0]["Name"].ToString();
cookie2.Expires = DateTime.Now.AddDays(22);
Response.Cookies.Add(cookie2);
bool isVenue = false;
string address = "";
if (dvEvent[0]["VenueID"] != null)
{
if (dvEvent[0]["VenueID"].ToString().Trim() != "")
{
DataView dvVenue = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + dvEvent[0]["VenueID"].ToString());
NameOfPlaceLabel.Text = dvVenue[0]["Name"].ToString() + "<br />";
address = dat.GetAddress(dvVenue[0]["Address"].ToString(), dvVenue[0]["Country"].ToString() != "223");
isVenue = true;
Address1Label.Text = address;
Address2Label.Visible = false;
CityStateZipLabel.Text = dvVenue[0]["City"].ToString() + ", " +
dvVenue[0]["State"].ToString() + " " + dvVenue[0]["Zip"].ToString();
}
else
NameOfPlaceLabel.Visible = false;
}
else
NameOfPlaceLabel.Visible = false;
if (!isVenue)
{
if (dvEvent[0]["Country"].ToString() == "223")
{
address = dvEvent[0]["StreetNumber"].ToString() + " " + dvEvent[0]["StreetName"].ToString() +
" " + dvEvent[0]["StreetDrop"].ToString();
}
else
{
address = dvEvent[0]["Location"].ToString();
}
}
cookie2 = new HttpCookie("addressParameter");
cookie2.Value = address + " " + dvEvent[0]["City"].ToString() + " " + dvEvent[0]["State"].ToString() +
" " + dvEvent[0]["Zip"].ToString() + " " + country;
cookie2.Expires = DateTime.Now.AddDays(22);
Response.Cookies.Add(cookie2);
lit = new Literal();
lit.Text = "<script src=\"http://maps.google.com/maps?file=api&v=2&sensor=false&key=ABQIAAAAjjoxQtYNtdn3Tc17U5-jbBR2Kk_H7gXZZZniNQ8L14X1BLzkNhQjgZq1k-Pxm8FxVhUy3rfc6L9O4g\" type=\"text/javascript\"></script>";
Page.Header.Controls.Add(lit);
Master.BodyTag.Attributes.Add("onload", "initialize();");
Master.BodyTag.Attributes.Add("onunload", "GUnload()");
if (!isVenue)
{
if (dvEvent[0]["Country"].ToString() == "223")
Address1Label.Text = dvEvent[0]["StreetNumber"].ToString() + " " +
dvEvent[0]["StreetName"].ToString() + " " + dvEvent[0]["StreetDrop"].ToString();
else
Address1Label.Text = dvEvent[0]["Location"].ToString();
if (dvEvent[0]["AptName"].ToString().Trim() != "")
{
Address2Label.Text = dvEvent[0]["AptName"].ToString() + " " +
dvEvent[0]["AptNo"].ToString() + "<br/>";
}
else
Address2Label.Visible = false;
CityStateZipLabel.Text = dvEvent[0]["City"].ToString() + ", " +
dvEvent[0]["State"].ToString() + " " + dvEvent[0]["Zip"].ToString();
}
#endregion
#region Take care of images and youtube
char[] delim4 = { ';' };
DataView dsSlider = dat.GetDataDV("SELECT * FROM GroupEvent_Slider_Mapping WHERE GroupEventID=" + Request.QueryString["ID"].ToString());
if (dsSlider.Count > 0)
{
char[] delim = { '\\' };
char[] delim3 = { '.' };
for (int i = 0; i < dsSlider.Count; i++)
{
string caption = "";
if (dsSlider[i]["Caption"] != null)
{
if (dsSlider[i]["Caption"].ToString().Trim() != "")
{
caption = "<div class=\"CaptionText\">" + dsSlider[i]["Caption"].ToString().Trim() + "</div>";
}
}
string[] tokens = dsSlider[i]["PictureName"].ToString().Split(delim3);
//dsSlider.RowFilter = "RealPictureName='" + tokens[0] + "." + tokens[1] + "'";
if (tokens.Length >= 2)
{
if (tokens[1].ToUpper() == "JPG" || tokens[1].ToUpper() == "JPEG" || tokens[1].ToUpper() == "GIF" || tokens[1].ToUpper() == "PNG")
{
System.Drawing.Image image = System.Drawing.Image.FromFile(MapPath(".") +
"\\GroupEventFiles\\" + Request.QueryString["ID"].ToString() + "\\Slider\\" + dsSlider[i]["PictureName"].ToString());
int width = 400;
int height = 250;
int newHeight = 0;
int newIntWidth = 0;
//if image height is less than resize height
if (height >= image.Height)
{
//leave the height as is
newHeight = image.Height;
if (width >= image.Width)
{
newIntWidth = image.Width;
}
else
{
newIntWidth = width;
double theDivider = double.Parse(image.Width.ToString()) / double.Parse(newIntWidth.ToString());
double newDoubleHeight = double.Parse(newHeight.ToString());
newDoubleHeight = double.Parse(height.ToString()) / theDivider;
newHeight = (int)newDoubleHeight;
}
}
//if image height is greater than resize height...resize it
else
{
//make height equal to the requested height.
newHeight = height;
//get the ratio of the new height/original height and apply that to the width
double theDivider = double.Parse(image.Height.ToString()) / double.Parse(newHeight.ToString());
double newDoubleWidth = double.Parse(newIntWidth.ToString());
newDoubleWidth = double.Parse(image.Width.ToString()) / theDivider;
newIntWidth = (int)newDoubleWidth;
//if the resized width is still to big
if (newIntWidth > width)
{
//make it equal to the requested width
newIntWidth = width;
//get the ratio of old/new width and apply it to the already resized height
theDivider = double.Parse(image.Width.ToString()) / double.Parse(newIntWidth.ToString());
double newDoubleHeight = double.Parse(newHeight.ToString());
newDoubleHeight = double.Parse(image.Height.ToString()) / theDivider;
newHeight = (int)newDoubleHeight;
}
}
Literal literal4 = new Literal();
literal4.Text = "<div style=\"width: 400px; height: 250px;background-color: black;\">" +
"<img align=\"middle\" style=\"cursor: default; margin-left: " +
((400 - newIntWidth) / 2).ToString() + "px; margin-top: " +
((250 - newHeight) / 2).ToString() + "px;\" height=\"" + newHeight +
"px\" width=\"" + newIntWidth + "px\" height=\"" + height.ToString() + "px\" width=\"" + width.ToString() +
"px\" src=\"" + "GroupEventFiles/" + Request.QueryString["ID"].ToString() + "/Slider/" + dsSlider[i]["PictureName"].ToString() +
"\" /></div>" + caption;
Telerik.Web.UI.RadRotatorItem r4 = new Telerik.Web.UI.RadRotatorItem();
r4.Controls.Add(literal4);
Rotator1.Items.Add(r4);
}
}
else
{
Literal literal3 = new Literal();
literal3.Text = "<div class=\"topDiv\"><div style=\"float:left;background-color: black;\"><object width=\"400\" height=\"250\"><param name=\"wmode\" value=\"opaque\" ></param><param name=\"movie\" value=\"http://www.youtube.com/v/" + dsSlider[i]["PictureName"].ToString() +
"\"></param><param name=\"allowFullScreen\" value=\"true\"></param><embed wmode=\"opaque\" src=\"http://www.youtube.com/v/" + dsSlider[i]["PictureName"].ToString() +
"\" type=\"application/x-shockwave-flash\" allowfullscreen=\"true\" width=\"400\" height=\"250\"></embed></object></div>" + caption + "</div>";
Telerik.Web.UI.RadRotatorItem r3 = new Telerik.Web.UI.RadRotatorItem();
r3.Controls.Add(literal3);
Rotator1.Items.Add(r3);
}
}
}
if (Rotator1.Items.Count == 0)
RotatorPanel.Visible = false;
else
{
RotatorPanel.Visible = true;
if (Rotator1.Items.Count == 1)
{
RotatorPanel.CssClass = "HiddeButtons";
}
}
#endregion
//Digg
DiggLiteral.Text = "<table style=\"padding-top: 5px;\"> " +
" <tr>" +
" <td valign=\"bottom\" style=\"padding-right: 0px;\">" +
" <a name=\"fb_share\" type=\"button\" href=\"http://www.facebook.com/sharer.php\">Share</a><script src=\"http://static.ak.fbcdn.net/connect.php/js/FB.Share\" type=\"text/javascript\"></script>" +
"</td>" +
"<td valign=\"bottom\" style=\"padding-right: 0px;\">" +
" <a style=\"border: 0; padding: 0; margin: 0;\" id=\"TweeterA\" title=\"Click to send this page to Twitter!\" target=\"_blank\" rel=\"nofollow\"><img style=\"border: 0; padding: 0; margin: 0;\" src=\"http://twitter-badges.s3.amazonaws.com/twitter-a.png\" alt=\"Share on Twitter\"/></a>" +
"</td>" +
"<td valign=\"bottom\">" +
" <a href=\"javascript:void(window.open('http://www.myspace.com/Modules/PostTo/Pages/?u='+encodeURIComponent(document.location.toString()),'ptm','height=450,width=440').focus())\">" +
" <img src=\"http://cms.myspacecdn.com/cms/ShareOnMySpace/small.png\" border=\"0\" alt=\"Share on MySpace\" />" +
" </a>" +
"</td>" +
"<td><a alt=\"Digg it!\" class=\"DiggThisButton DiggIcon\" id=\"dibbButt\"" +
"href='http://digg.com/submit?phase=2&url=" + "http://" +
Request.Url.Authority + "/" +
dat.MakeNiceName(dvGroup[0]["Name"].ToString()) +
"_" + Request.QueryString["ID"].ToString() + "_GroupEvent" +
"' target=\"_blank\">Digg</a> </td>" +
"<td>" +
" <a href=\"http://delicious.com/save\" onclick=\"window.open('http://delicious.com/save?v=5&noui&jump=close&url='+encodeURIComponent(location.href)+'&title='+encodeURIComponent(document.title), 'delicious','toolbar=no,width=550,height=550'); return false;\">" +
" <img border=\"0\" src=\"http://static.delicious.com/img/delicious.small.gif\" height=\"10\" width=\"10\" alt=\"Delicious\" />" +
" </a>" +
"</td>" +
" <td>" +
" <script src=\"http://www.stumbleupon.com/hostedbadge.php?s=4\"></script>" +
" </td>" +
" </tr>" +
"</table>";
}
catch (Exception ex)
{
ErrorLabel.Text = ex.ToString() + "<br/>" + command;
}
}
protected string[] GetEventLiteral(DataView dvEvents, Data dat, int numOfRecordsPerPage)
{
int thecount = dvEvents.Count;
int numberInArray = thecount / numOfRecordsPerPage;
if (thecount % numOfRecordsPerPage != 0)
numberInArray++;
string oneStringRecord = "";
int normalRecordCount = 0;
int countInArray = 0;
string[] theArray = new string[numberInArray];
try
{
Hashtable normalEventHash = new Hashtable();
int i = 0;
string funcCount = "";
string theLiteral = "<script type=\"text/javascript\">function initialize"+
(countInArray+1).ToString()+"(){ "+
" if(map != null && map != undefined) " +
" { var address;";
string address = "";
string venue = "";
bool isFirstElement = true;
string country = "US";
Hashtable venueMapping = new Hashtable();
Hashtable venuesNumMapping = new Hashtable();
DataView dvRecords = new DataView();
DataTable dt = new DataTable();
DataColumn dc2 = new DataColumn("Address");
dt.Columns.Add(dc2);
dc2 = new DataColumn("Letter");
dt.Columns.Add(dc2);
int lastUsedCount = 0;
foreach (DataRowView row in dvEvents)
{
if (normalRecordCount % numOfRecordsPerPage == 0)
{
if (normalRecordCount != 0 && normalRecordCount != lastUsedCount)
{
lastUsedCount = normalRecordCount;
//ErrorLabel.Text += "on script insert normal rec count: " + normalRecordCount.ToString();
dvRecords = new DataView(dt, "", "Letter ASC", DataViewRowState.CurrentRows);
theLiteral = "<script type=\"text/javascript\">function initialize" +
(countInArray + 1).ToString() + "(){if(map != null && map != undefined) " +
" { var address;";
oneStringRecord = theLiteral;
int rowCount = 0;
foreach (DataRowView rowster in dvRecords)
{
if (rowCount == 0)
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', true);".Replace(" ",
" ").Replace(" ", " ");
if (rowCount == dvRecords.Count - 1)
{
oneStringRecord += " }}</script>".Replace(" ",
" ").Replace(" ", " ");
}
}
else if (rowCount == dvRecords.Count - 1)
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', false); }}</script>".Replace(" ",
" ").Replace(" ", " ");
}
else
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', false);".Replace(" ",
" ").Replace(" ", " ");
}
rowCount++;
}
TopLiteral.Text += oneStringRecord;
theArray[countInArray] = oneStringRecord;
dt.Rows.Clear();
countInArray++;
venueMapping.Clear();
venuesNumMapping.Clear();
}
venue = "";
isFirstElement = true;
i = 0;
}
if (!bool.Parse(row["isGroup"].ToString()))
{
if (!normalEventHash.Contains(row["EID"].ToString()))
{
normalEventHash.Add(row["EID"].ToString(), normalRecordCount.ToString());
row["CalendarNum"] = dat.GetCalendarLetter(normalRecordCount);
address = "";
DataView dvE = dat.GetDataDV("SELECT * FROM Events WHERE ID=" + row["EID"].ToString());
DataView dvV = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + dvE[0]["Venue"].ToString());
DataView dvCountry = dat.GetDataDV("SELECT * FROM countries WHERE country_id=" + dvE[0]["Country"].ToString());
country = dvCountry[0]["country_2_code"].ToString();
if (country.ToLower() == "us")
{
try
{
address = dat.GetAddress(dvV[0]["Address"].ToString(), false);
}
catch (Exception ex1)
{
address = "";
}
}
else
{
address = dat.GetAddress(dvV[0]["Address"].ToString(), true);
}
if (dvE[0]["Country"].ToString().ToLower() == "uk")
{
//VenueName.Text + "@&" +
if (venueMapping.ContainsKey(address))
{
row["SearchNum"] = venuesNumMapping[address].ToString();
venueMapping[address] += ",<br/><div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>";
}
else
{
if (!isFirstElement)
{
i++;
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; " +
"showAddressUS('<span style=\\\"color: #98cb2a; font-weight: bold;text-decoration: underline; " +
" cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>', 0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
row["SearchNum"] = dat.GetImage(i.ToString());
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
}
else
{
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
row["SearchNum"] = dat.GetImage(i.ToString());
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; showAddressUS('<span style=\\\"color: #98cb2a; font-weight: bold;text-decoration: underline; " +
" cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
}
}
}
else
{
//VenueName.Text + "@&" +
if (venueMapping.ContainsKey(address))
{
row["SearchNum"] = venuesNumMapping[address].ToString();
venueMapping[address] += ",<br/><div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>";
}
else
{
if (!isFirstElement)
{
i++;
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; showAddressUS('<span style=\\\"color: #98cb2a; font-weight: bold;text-decoration: underline; " +
" cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
row["SearchNum"] = dat.GetImage(i.ToString());
}
else
{
row["SearchNum"] = dat.GetImage(i.ToString());
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; showAddressUS('<span style=\\\"color: #98cb2a; font-weight: bold;text-decoration: underline; " +
"cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Header"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
}
}
}
isFirstElement = false;
normalRecordCount++;
venue = address;
}
else
{
row["CalendarNum"] = dat.GetCalendarLetter(int.Parse(normalEventHash[row["EID"].ToString()].ToString()));
}
}
else
{
bool isVenue = false;
address = "";
row["CalendarNum"] = dat.GetCalendarLetter(normalRecordCount);
DataView dvE = dat.GetDataDV("SELECT * FROM GroupEvents GE, GroupEvent_Occurance GEO WHERE GE.ID=" +
row["EID"].ToString() + " AND GEO.GroupEventID=GE.ID AND GEO.ID=" + row["ReoccurrID"].ToString());
country = dat.GetDataDV("SELECT * FROM Countries C, GroupEvent_Occurance GEO WHERE GEO.ID=" +
row["ReoccurrID"].ToString() +
" AND C.country_id=GEO.Country ")[0]["country_2_code"].ToString();
DataView dvV = new DataView();
if (dvE[0]["VenueID"] != null)
{
if (dvE[0]["VenueID"].ToString().Trim() != "")
{
dvV = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + dvE[0]["VenueID"].ToString());
address = dat.GetAddress(dvV[0]["Address"].ToString(),
dvV[0]["Country"].ToString() != "223").Trim();
isVenue = true;
}
}
if (!isVenue)
{
if (dvE[0]["Country"].ToString() == "223")
{
address = dvE[0]["StreetNumber"].ToString() + " " + dvE[0]["StreetName"].ToString() +
" " + dvE[0]["StreetDrop"].ToString();
}
else
{
address = dvE[0]["Location"].ToString();
}
}
address = address.Trim() + " " + dvE[0]["City"].ToString() + " " + dvE[0]["State"].ToString() +
" " + dvE[0]["Zip"].ToString() + " " + country;
if (venueMapping.ContainsKey(address))
{
row["SearchNum"] = venuesNumMapping[address];
venueMapping[address] += ",<br/><div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Name"].ToString()) + "_" + row["ReoccurrID"].ToString() + "_" +
dvE[0]["ID"].ToString() + "_GroupEvent" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>";
}
else
{
if (!isFirstElement)
{
i++;
if (isVenue)
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(",
" ").Replace(")", " ") + "';showAddressUS('<span style=\\\"color: #98cb2a; font-weight: bold;text-decoration: underline; " +
"cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Name"].ToString()) + "_" + row["ReoccurrID"].ToString() + "_" +
dvE[0]["ID"].ToString() + "_GroupEvent" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
else
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(",
" ").Replace(")", " ") + "';showAddressUS('', 0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Name"].ToString()) + "_" + row["ReoccurrID"].ToString() + "_" +
dvE[0]["ID"].ToString() + "_GroupEvent" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
row["SearchNum"] = dat.GetImage(i.ToString());
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
row["SearchNum"] = dat.GetImage(i.ToString());
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
}
else
{
row["SearchNum"] = dat.GetImage(i.ToString());
if (isVenue)
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(",
" ").Replace(")", " ") + "'; showAddressUS('<span style=\\\"color: #98cb2a; font-weight: bold;text-decoration: underline; " +
"cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span>',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Name"].ToString()) + "_" + row["ReoccurrID"].ToString() + "_" +
dvE[0]["ID"].ToString() + "_GroupEvent" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
else
venueMapping.Add(address, "address = '" + address.Trim().Replace("'", "''").Replace("(",
" ").Replace(")", " ") + "';showAddressUS('', 0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #1fb6e7; font-weight: bold; text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvE[0]["Name"].ToString()) + "_" + row["ReoccurrID"].ToString() + "_" +
dvE[0]["ID"].ToString() + "_GroupEvent" + "\\');\\\">" +
dat.CleanExcelString(dvE[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ")) + "</div>");
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
row["SearchNum"] = dat.GetImage(i.ToString());
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
}
}
isFirstElement = false;
normalRecordCount++;
venue = address;
}
}
//if (thecount % numOfRecordsPerPage != 0)
//{
dvRecords = new DataView(dt, "", "Letter ASC", DataViewRowState.CurrentRows);
theLiteral = "<script type=\"text/javascript\">function initialize" +
(countInArray + 1).ToString() + "(){if(map != null && map != undefined) " +
" { var address;";
oneStringRecord = theLiteral;
int theCount = 0;
foreach (DataRowView rowster in dvRecords)
{
if (theCount == 0)
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', true);".Replace(" ",
" ").Replace(" ", " ");
if (theCount == dvRecords.Count - 1)
{
oneStringRecord += " }}</script>".Replace(" ",
" ").Replace(" ", " ");
}
}
else if (theCount == dvRecords.Count - 1)
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', false); }}</script>".Replace(" ",
" ").Replace(" ", " ");
}
else
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', false);".Replace(" ",
" ").Replace(" ", " ");
}
theCount++;
}
TopLiteral.Text += oneStringRecord;
theArray[countInArray] = oneStringRecord;
//}
}
catch (Exception ex)
{
ErrorLabel.Text += ex.ToString() + "; countInArray: " + countInArray +
"; theArray.Length: " + theArray.Length + "; eventsCount: " + thecount.ToString() + "; normalRecordCount: " + normalRecordCount.ToString();
}
return theArray;
}
protected void GetAllVenuesLiteral(DataView dvEvents, Data dat)
{
string theLiteral = "<script type=\"text/javascript\">function initializeAll(){" +
" if(map != null && map != undefined) " +
" { " +
" var address;";
string address = "";
string country = "US";
foreach (DataRowView row in dvEvents)
{
address = "";
DataView dvV = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + row["VID"].ToString());
DataView dvCountry = dat.GetDataDV("SELECT * FROM countries WHERE country_id=" +
dvV[0]["Country"].ToString());
country = dvCountry[0]["country_2_code"].ToString();
if (country.ToLower() == "us")
{
try
{
address = dat.GetAddress(dvV[0]["Address"].ToString(), false);
}
catch (Exception ex1)
{
address = "";
}
}
else
{
address = dat.GetAddress(dvV[0]["Address"].ToString(), true);
}
if (dvV[0]["Country"].ToString().ToLower() == "uk")
{
theLiteral += "address = '" + address.Replace("'", "''").Replace("(", " ").Replace(")", " ") +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; " +
"showAddressUS('',1, address, 0, address, 1, 0, '" +
"<div style=\\\"color: #98cb2a;font-weight: bold;text-decoration: underline; float: left; cursor: pointer;\\\" " +
"onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'", " ").Replace("(",
" ").Replace(")", " ") + "</div>', false);";
}
else
{
theLiteral += "address = '" + address +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; " +
"showAddressUS('',1, address, 0, address, 1, 0, '" +
"<div style=\\\"color: #98cb2a;font-weight: bold;text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'", " ").Replace("(",
" ").Replace(")", " ") + "</div>', false);";
}
}
ScriptLiteral.Text += theLiteral + "}}</script>";
}
protected void RadScheduler1_AppointmentCreated(object sender, AppointmentCreatedEventArgs e)
{
try
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
char[] delim = { ';' };
string[] calendarKeys = e.Appointment.ID.ToString().Split(delim);
bool isGroup = bool.Parse(calendarKeys[0]);
string EID = calendarKeys[1];
string reoccurrID = calendarKeys[2];
bool isVenue = false;
DataView dvE = new DataView();
DataView dvV = new DataView();
DataView dvCountry = new DataView();
string theDate = "";
string eventLink = "";
string venueStr = "";
string address = "";
string country = "";
string eventColumnTitle = "";
if (isGroup)
{
eventColumnTitle = "Name";
country = dat.GetDataDV("SELECT * FROM Countries C, GroupEvent_Occurance GEO WHERE GEO.ID=" +
reoccurrID + " AND C.country_id=GEO.Country ")[0]["country_2_code"].ToString();
dvE = dat.GetDataDV("SELECT * FROM GroupEvents E, GroupEvent_Occurance EO WHERE EO.ID=" + reoccurrID +
" and EO.GroupEventID=E.ID AND E.ID=" + EID);
if (dvE[0]["VenueID"] != null)
{
if (dvE[0]["VenueID"].ToString() != "")
{
isVenue = true;
dvV = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + dvE[0]["VenueID"].ToString());
venueStr = "<span style=\"color: #98cb2a; " +
"font-weight: bold;text-decoration: underline; " +
" cursor: pointer;\" onclick=\"CloseWindow(\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\');\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span><br/>";
}
}
eventLink = dat.MakeNiceName(dvE[0]["Name"].ToString()) + "_" + reoccurrID + "_" +
dvE[0]["ID"].ToString() + "_GroupEvent";
if (!isVenue)
{
if (dvE[0]["Country"].ToString() == "223")
{
address = dvE[0]["StreetNumber"].ToString() + " " + dvE[0]["StreetName"].ToString() +
" " + dvE[0]["StreetDrop"].ToString();
}
else
{
address = dvE[0]["Location"].ToString();
}
}
else
{
address = dat.GetAddress(dvV[0]["Address"].ToString(),
dvV[0]["Country"].ToString() != "223").Trim();
}
address = address.Trim() + " " + dvE[0]["City"].ToString() + " " + dvE[0]["State"].ToString() +
" " + dvE[0]["Zip"].ToString() + " " + country;
}
else
{
eventColumnTitle = "Header";
dvE = dat.GetDataDV("SELECT * FROM Events E, Event_Occurance EO WHERE EO.ID=" + reoccurrID +
" and EO.EventID=E.ID AND E.ID=" + EID);
dvV = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + dvE[0]["Venue"].ToString());
dvCountry = dat.GetDataDV("SELECT * FROM countries WHERE country_id=" + dvE[0]["Country"].ToString());
country = dvCountry[0]["country_2_code"].ToString();
if (country.ToLower() == "us")
{
try
{
address = dat.GetAddress(dvV[0]["Address"].ToString(), false);
}
catch (Exception ex1)
{
address = "";
}
}
else
{
address = dat.GetAddress(dvV[0]["Address"].ToString(), true);
}
address = address.Trim().Replace("'", "''").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ");
eventLink = dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
dvE[0]["ID"].ToString() + "_Event";
venueStr = "<span style=\"color: #98cb2a; " +
"font-weight: bold;text-decoration: underline; " +
" cursor: pointer;\" onclick=\"CloseWindow(\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\');\">" +
dvV[0]["Name"].ToString().Replace("'",
" ").Replace("(", " ").Replace(")", " ") + "</span><br/>";
}
theDate = dvE[0]["DateTimeStart"].ToString();
RadToolTip newToolTip = new RadToolTip();
newToolTip.Text = "<div class='AddLink' style=\"width: 200px;color: #cccccc; font-weight: normal;\">" +
"<div style=\"color: #1fb6e7; font-weight: bold; text-decoration: " +
"underline; float: left; cursor: pointer;\" onclick=\"CloseWindow('" + "../" +
eventLink + "');\">" +
dvE[0][eventColumnTitle].ToString().Replace("'", " ").Replace("(",
" ").Replace(")", " ") + "</div><br/>on "+theDate+"<br/>at " + venueStr + address + "</div>";
newToolTip.TargetControlID = e.Appointment.ClientID;
newToolTip.IsClientID = true;
newToolTip.HideEvent = ToolTipHideEvent.ManualClose;
newToolTip.Animation = ToolTipAnimation.None;
newToolTip.Position = ToolTipPosition.MiddleRight;
newToolTip.ShowEvent = ToolTipShowEvent.OnClick;
newToolTip.Skin = "Black";
newToolTip.ID = isGroup.ToString() + EID + reoccurrID;
ToolTipPanel.Controls.Add(newToolTip);
if (Session["SelectToolTip"] != null)
{
if (Session["SelectToolTip"].ToString() == isGroup.ToString() + EID + reoccurrID)
{
newToolTip.Show();
Session["SelectToolTip"] = null;
}
}
}
catch (Exception ex)
{
ErrorLabel.Text = ex.ToString();
}
}
//protected void GetEventLiteral(ref DataView dvEvents, Data dat)
//{
// Hashtable normalEventHash = new Hashtable();
// int i = 0;
// string theLiteral = "<script type=\"text/javascript\">function initialize(){if (GBrowserIsCompatible()){ " +
// " map = new GMap2(document.getElementById(\"map_canvas\")); " +
// " map.addControl(new GMapTypeControl()); " +
// " if(map != null && map != undefined) " +
// " { " +
// " map.setUIToDefault(); " +
// " geocoder = new GClientGeocoder(); var address;";
// string address = "";
// string venue = "";
// bool isVenueSame = false;
// bool gotEntry = false;
// string nameStr = "";
// bool isFirstElement = true;
// string country = "US";
// dvEvents.Sort = " VID ASC";
// foreach (DataRowView row in dvEvents)
// {
// if (!bool.Parse(row["isGroup"].ToString()))
// {
// if (!normalEventHash.Contains(row["EID"].ToString()))
// {
// normalEventHash.Add(row["EID"].ToString(), "");
// gotEntry = false;
// address = "";
// DataView dvE = dat.GetDataDV("SELECT * FROM Events WHERE ID=" + row["EID"].ToString());
// DataView dvV = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + dvE[0]["Venue"].ToString());
// if (venue == dvE[0]["Venue"].ToString())
// {
// isVenueSame = true;
// }
// else
// {
// isVenueSame = false;
// }
// venue = dvE[0]["Venue"].ToString();
// DataView dvCountry = dat.GetDataDV("SELECT * FROM countries WHERE country_id=" + dvE[0]["Country"].ToString());
// country = dvCountry[0]["country_2_code"].ToString();
// if (country.ToLower() == "us")
// {
// try
// {
// address = dat.GetAddress(dvV[0]["Address"].ToString(), false);
// }
// catch (Exception ex1)
// {
// address = "";
// }
// }
// else
// {
// address = dat.GetAddress(dvV[0]["Address"].ToString(), true);
// }
// if (dvE[0]["Country"].ToString().ToLower() == "uk")
// {
// //VenueName.Text + "@&" +
// if (isVenueSame)
// {
// row["SearchNum"] = dat.GetImage(i.ToString());
// nameStr += ",<br/><div style=\\\"text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
// dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
// dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
// dvE[0]["Header"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + "</div>";
// }
// else
// {
// if (!isFirstElement)
// {
// theLiteral += nameStr + "', false); ";
// theLiteral += "address = '" + dvV[0]["Name"].ToString().Replace("'", " ").Replace("(",
// " ").Replace(")", " ") + " " + address.Replace("'", "''").Replace("(", " ").Replace(")", " ") +
// dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
// dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
// country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; ";
// nameStr = "";
// i++;
// nameStr = " showAddressUS(address, 0, address, 1, " + i.ToString() + ", '" +
// "<div style=\\\"text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
// dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
// dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
// dvE[0]["Header"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + "</div>";
// row["SearchNum"] = dat.GetImage(i.ToString());
// }
// else
// {
// row["SearchNum"] = dat.GetImage(i.ToString());
// theLiteral += "address = '" + dvV[0]["Name"].ToString().Replace("'", " ").Replace("(",
// " ").Replace(")", " ") +
// " " + address.Replace("'", "''").Replace("(", " ").Replace(")", " ") +
// dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
// dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
// country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; ";
// nameStr = " showAddressUS(address, 0, address, 1, " + i.ToString() + ", '" +
// "<div style=\\\"text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
// dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
// dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
// dvE[0]["Header"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + "</div>";
// }
// }
// }
// else
// {
// if (isVenueSame)
// {
// row["SearchNum"] = dat.GetImage(i.ToString());
// nameStr += ",<br/><div style=\\\"text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
// dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
// dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
// dvE[0]["Header"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + "</div>";
// }
// else
// {
// if (!isFirstElement)
// {
// theLiteral += nameStr + "', false); ";
// theLiteral += "address = '" + address.Trim() +" " +
// dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
// dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
// dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
// country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; ";
// nameStr = "";
// i++;
// nameStr = " showAddressUS(address, 0, address, 1, " + i.ToString() + ", '" +
// "<div style=\\\"text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
// dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
// dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
// dvE[0]["Header"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + "</div>";
// row["SearchNum"] = dat.GetImage(i.ToString());
// }
// else
// {
// row["SearchNum"] = dat.GetImage(i.ToString());
// theLiteral += "address = '" + address.Trim() +" "+
// dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
// dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
// dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
// country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; ";
// nameStr = " showAddressUS(address, 0, address, 1, " + i.ToString() + ", '" +
// "<div style=\\\"text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
// dat.MakeNiceName(dvE[0]["Header"].ToString()) + "_" +
// dvE[0]["ID"].ToString() + "_Event" + "\\');\\\">" +
// dvE[0]["Header"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + "</div>";
// }
// }
// }
// isFirstElement = false;
// }
// }
// else
// {
// bool isVenue = false;
// address = "";
// DataView dvE = dat.GetDataDV("SELECT * FROM GroupEvents GE, GroupEvent_Occurance GEO WHERE GE.ID=" +
// row["EID"].ToString() + " AND GEO.GroupEventID=GE.ID AND GEO.ID=" + row["ReoccurrID"].ToString());
// country = dat.GetDataDV("SELECT * FROM Countries C, GroupEvent_Occurance GEO WHERE GEO.ID=" +
// row["ReoccurrID"].ToString() +
// " AND C.country_id=GEO.Country ")[0]["country_2_code"].ToString();
// DataView dvV = new DataView();
// if (dvE[0]["VenueID"] != null)
// {
// if (dvE[0]["VenueID"].ToString().Trim() != "")
// {
// dvV = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + dvE[0]["VenueID"].ToString());
// address = dat.GetAddress(dvV[0]["Address"].ToString(),
// dvV[0]["Country"].ToString() != "223");
// isVenue = true;
// }
// }
// if (!isVenue)
// {
// if (dvE[0]["Country"].ToString() == "223")
// {
// address = dvE[0]["StreetNumber"].ToString() + " " + dvE[0]["StreetName"].ToString() +
// " " + dvE[0]["StreetDrop"].ToString();
// }
// else
// {
// address = dvE[0]["Location"].ToString();
// }
// }
// address += " " + dvE[0]["City"].ToString() + " " + dvE[0]["State"].ToString() +
// " " + dvE[0]["Zip"].ToString() + " " + country;
// if (venue == address)
// {
// isVenueSame = true;
// }
// else
// {
// isVenueSame = false;
// }
// venue = address;
// if (isVenueSame)
// {
// row["SearchNum"] = dat.GetImage(i.ToString());
// nameStr += ",<br/><div style=\\\"text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
// dat.MakeNiceName(dvE[0]["Name"].ToString()) + "_" + row["ReoccurrID"].ToString() + "_" +
// dvE[0]["ID"].ToString() + "_GroupEvent" + "\\');\\\">" +
// dvE[0]["Name"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + "</div>";
// }
// else
// {
// if (!isFirstElement)
// {
// theLiteral += nameStr + "', false); ";
// if (isVenue)
// theLiteral += "address = '" + dvV[0]["Name"].ToString().Replace("'", " ").Replace("(",
// " ").Replace(")", " ") + " " + address.Replace("'", "''").Replace("(",
// " ").Replace(")", " ") + "'; ";
// else
// theLiteral += "address = '" + address.Replace("'", "''").Replace("(",
// " ").Replace(")", " ") + "'; ";
// nameStr = "";
// i++;
// nameStr = " showAddressUS(address, 0, address, 1, " + i.ToString() + ", '" +
// "<div style=\\\"text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
// dat.MakeNiceName(dvE[0]["Name"].ToString()) + "_" + row["ReoccurrID"].ToString() + "_" +
// dvE[0]["ID"].ToString() + "_GroupEvent" + "\\');\\\">" +
// dvE[0]["Name"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + "</div>";
// row["SearchNum"] = dat.GetImage(i.ToString());
// }
// else
// {
// row["SearchNum"] = dat.GetImage(i.ToString());
// if (isVenue)
// theLiteral += "address = '" + dvV[0]["Name"].ToString().Replace("'", " ").Replace("(",
// " ").Replace(")", " ") + " " + address.Replace("'", "''").Replace("(",
// " ").Replace(")", " ") + "'; ";
// else
// theLiteral += "address = '" + address.Replace("'", "''").Replace("(",
// " ").Replace(")", " ") + "'; ";
// nameStr = " showAddressUS(address, 0, address, 1, " + i.ToString() + ", '" +
// "<div style=\\\"text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
// dat.MakeNiceName(dvE[0]["Name"].ToString()) + "_" + row["ReoccurrID"].ToString() + "_" +
// dvE[0]["ID"].ToString() + "_GroupEvent" + "\\');\\\">" +
// dvE[0]["Name"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + "</div>";
// }
// }
// isFirstElement = false;
// }
// }
// theLiteral += nameStr + "', true)";
// theLiteral = theLiteral.Replace(" ", " ");
// theLiteral = theLiteral.Replace(" ", " ");
// ScriptLiteral.Text = theLiteral + "}}}</script>";
//}
protected string[] GetVenuesLiteral(DataView dvEvents, Data dat, int numOfRecordsPerPage)
{
int i = 0;
string address = "";
string lastAddress = "";
string nameStr = "";
string country = "US";
dvEvents.Sort = " Address DESC ";
bool isAddressSame = false;
bool isFirstElement = true;
int thecount = dvEvents.Count;
int numberInArray = thecount / numOfRecordsPerPage;
if (thecount % numOfRecordsPerPage != 0)
numberInArray++;
string oneStringRecord = "";
int normalRecordCount = 0;
int countInArray = 0;
string theLiteral = "<script type=\"text/javascript\">function initialize" +
(countInArray + 1).ToString() + "(){"+
" if(map != null && map != undefined) " +
" { " +
" map.setUIToDefault(); " +
" geocoder = new GClientGeocoder(); var address;";
string[] theArray = new string[numberInArray];
int lastUsedCount = 0;
Hashtable venueMapping = new Hashtable();
Hashtable venuesNumMapping = new Hashtable();
DataView dvRecords = new DataView();
DataTable dt = new DataTable();
DataColumn dc2 = new DataColumn("Address");
dt.Columns.Add(dc2);
dc2 = new DataColumn("Letter");
dt.Columns.Add(dc2);
string addToLit = "";
string addToLitBottom = "";
foreach (DataRowView row in dvEvents)
{
if (normalRecordCount % numOfRecordsPerPage == 0)
{
if (normalRecordCount != 0 && normalRecordCount != lastUsedCount)
{
lastUsedCount = normalRecordCount;
//ErrorLabel.Text += "on script insert normal rec count: " + normalRecordCount.ToString();
dvRecords = new DataView(dt, "", "Letter ASC", DataViewRowState.CurrentRows);
//if (countInArray == 0)
//{
// addToLit = "if (GBrowserIsCompatible()){ " +
// " map = new GMap2(document.getElementById(\"map_canvas\")); " +
// " map.addControl(new GMapTypeControl()); " +
// " if(map != null && map != undefined) " +
// " { " +
// " map.setUIToDefault(); " +
// " geocoder = new GClientGeocoder(); ";
// addToLitBottom = "}}}";
//}
//else
//{
// addToLit = " if(map != null && map != undefined) " +
// " {";
// addToLitBottom = "}}";
//}
addToLit = " if(map != null && map != undefined) " +
" {";
addToLitBottom = "}}";
theLiteral = "<script type=\"text/javascript\">function initialize" +
(countInArray + 1).ToString() + "(){" + addToLit + "var address;";
oneStringRecord = theLiteral;
int rowCount = 0;
foreach (DataRowView rowster in dvRecords)
{
if (rowCount == 0)
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', true);".Replace(" ",
" ").Replace(" ", " ");
if (rowCount == dvRecords.Count - 1)
{
oneStringRecord += addToLitBottom+"</script>".Replace(" ",
" ").Replace(" ", " ");
}
}
else if (rowCount == dvRecords.Count - 1)
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', false); " + addToLitBottom + "</script>".Replace(" ",
" ").Replace(" ", " ");
}
else
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', false);".Replace(" ",
" ").Replace(" ", " ");
}
rowCount++;
}
TopLiteral.Text += oneStringRecord;
theArray[countInArray] = oneStringRecord;
dt.Rows.Clear();
countInArray++;
venueMapping.Clear();
venuesNumMapping.Clear();
}
lastAddress = "";
isFirstElement = true;
i = 0;
}
isAddressSame = false;
address = "";
DataView dvV = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + row["VID"].ToString());
DataView dvCountry = dat.GetDataDV("SELECT * FROM countries WHERE country_id=" +
dvV[0]["Country"].ToString());
country = dvCountry[0]["country_2_code"].ToString();
if (country.ToLower() == "us")
{
try
{
address = dat.GetAddress(dvV[0]["Address"].ToString(), false);
}
catch (Exception ex1)
{
address = "";
}
}
else
{
address = dat.GetAddress(dvV[0]["Address"].ToString(), true);
}
if (lastAddress == address && !isFirstElement)
isAddressSame = true;
else
isAddressSame = false;
if (dvV[0]["Country"].ToString().ToLower() == "uk")
{
if (venueMapping.ContainsKey(address))
{
row["SearchNum"] = venuesNumMapping[address].ToString();
venueMapping[address] += ",<br/><div style=\\\"color: #98cb2a;font-weight: bold;text-decoration: underline; float: left; cursor: pointer;\\\" " +
"onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + "</div>";
}
else
{
if (!isFirstElement)
{
i++;
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
venueMapping.Add(address, "address = '" + address.Replace("'", "''").Replace("(", " ").Replace(")", " ") +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; "+
"showAddressUS('',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #98cb2a;font-weight: bold;text-decoration: underline; float: left; cursor: pointer;\\\" " +
"onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'", " ").Replace("(",
" ").Replace(")", " ") + "</div> ");
row["SearchNum"] = dat.GetImage(i.ToString());
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
}
else
{
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
row["SearchNum"] = dat.GetImage(i.ToString());
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
venueMapping.Add(address, "address = '" + address.Replace("'", "''").Replace("(", " ").Replace(")", " ") +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + ", " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; "+
" showAddressUS('',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #98cb2a;font-weight: bold;text-decoration: underline; float: left; cursor: pointer;\\\" " +
"onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'", " ").Replace("(",
" ").Replace(")", " ") + "</div> ");
}
}
}
else
{
if (venueMapping.ContainsKey(address))
{
row["SearchNum"] = venuesNumMapping[address].ToString();
venueMapping[address] += ",<br/><div style=\\\"color: #98cb2a;font-weight: bold;text-decoration: underline; float: left; cursor: pointer;\\\" " +
"onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + "</div>";
}
else
{
if (!isFirstElement)
{
i++;
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
venueMapping.Add(address, "address = '" + address +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; "+
"showAddressUS('',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #98cb2a;font-weight: bold;text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'", " ").Replace("(",
" ").Replace(")", " ") + "</div> ");
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
row["SearchNum"] = dat.GetImage(i.ToString());
}
else
{
row["SearchNum"] = dat.GetImage(i.ToString());
DataRow r = dt.NewRow();
r["Address"] = address;
r["Letter"] = dat.GetImage(i.ToString());
dt.Rows.Add(r);
venuesNumMapping.Add(address, dat.GetImage(i.ToString()));
venueMapping.Add(address, "address = '" + address +
dvV[0]["City"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["State"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
dvV[0]["Zip"].ToString().Replace("'", " ").Replace("(", " ").Replace(")", " ") + " " +
country.Replace("'", " ").Replace("(", " ").Replace(")", " ") + "'; " +
"showAddressUS('',0, address, 0, address, 1, " + i.ToString() + ", '" +
"<div style=\\\"color: #98cb2a;font-weight: bold;text-decoration: underline; float: left; cursor: pointer;\\\" onclick=\\\"CloseWindow(\\'" + "../" +
dat.MakeNiceName(dvV[0]["Name"].ToString()) + "_" +
dvV[0]["ID"].ToString() + "_Venue" + "\\');\\\">" +
dvV[0]["Name"].ToString().Replace("'", " ").Replace("(",
" ").Replace(")", " ") + "</div> ");
}
}
}
lastAddress = address;
isFirstElement = false;
normalRecordCount++;
}
//if (thecount % numOfRecordsPerPage != 0)
//{
dvRecords = new DataView(dt, "", "Letter ASC", DataViewRowState.CurrentRows);
//if (countInArray == 0)
//{
// addToLit = "if (GBrowserIsCompatible()){ " +
// " map = new GMap2(document.getElementById(\"map_canvas\")); " +
// " map.addControl(new GMapTypeControl()); " +
// " if(map != null && map != undefined) " +
// " { " +
// " map.setUIToDefault(); " +
// " geocoder = new GClientGeocoder(); ";
// addToLitBottom = "}}}";
//}
//else
//{
// addToLit = " if(map != null && map != undefined) " +
// " {";
// addToLitBottom = "}}";
//}
addToLit = " if(map != null && map != undefined) " +
" {";
addToLitBottom = "}}";
theLiteral = "<script type=\"text/javascript\">function initialize" +
(countInArray + 1).ToString() + "(){" + addToLit + "var address;";
oneStringRecord = theLiteral;
int theCount = 0;
foreach (DataRowView rowster in dvRecords)
{
if (theCount == 0)
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', true);".Replace(" ",
" ").Replace(" ", " ");
if (theCount == dvRecords.Count - 1)
{
oneStringRecord += addToLitBottom+"</script>".Replace(" ",
" ").Replace(" ", " ");
}
}
else if (theCount == dvRecords.Count - 1)
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', false); " + addToLitBottom + "</script>".Replace(" ",
" ").Replace(" ", " ");
}
else
{
oneStringRecord += venueMapping[rowster["Address"].ToString()].ToString() +
"', false);".Replace(" ",
" ").Replace(" ", " ");
}
theCount++;
}
TopLiteral.Text += oneStringRecord;
theArray[countInArray] = oneStringRecord;
//}
return theArray;
}
protected void Page_Load(object sender, EventArgs e)
{
string eventID = Request.QueryString["ID"].ToString();
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", ":")));
try
{
Session["RedirectTo"] = Request.Url.AbsoluteUri;
bool fillUserData = false;
try
{
if (Session["User"] != null)
{
LoggedInPanel.Visible = true;
LoggedOutPanel.Visible = false;
fillUserData = true;
}
else
{
LoggedOutPanel.Visible = true;
LoggedInPanel.Visible = false;
}
GetOtherEvents();
}
catch (Exception ex)
{
ErrorLabel.Text = ex.ToString();
}
if (Request.QueryString["ID"] == null)
Response.Redirect("~/home");
string ID = eventID;
Session["TripID"] = ID;
DataView dv = dat.GetDataDV("SELECT * FROM Trips WHERE ID=" + ID);
Session["FlagID"] = ID;
Session["FlagType"] = "T";
#region SEO
//Create keyword and description meta tags and title
topTopLiteral.Text = "<a class=\"NavyLink12UD\" href=\"#" + dat.MakeNiceNameFull(dv[0]["Header"].ToString()) + "\">" +
dat.MakeNiceNameFull(dv[0]["Header"].ToString()).Replace("-", " ") + " From The Top</a>";
HtmlMeta hm = new HtmlMeta();
HtmlMeta kw = new HtmlMeta();
HtmlMeta lg = new HtmlMeta();
HtmlLink cn = new HtmlLink();
HtmlHead head = (HtmlHead)Page.Header;
cn.Attributes.Add("rel", "canonical");
cn.Href = "http://" + Request.Url.Authority + "/" +
dat.MakeNiceName(dv[0]["Header"].ToString()) +
"_" + eventID + "_Trip";
head.Controls.AddAt(0, cn);
kw.Name = "keywords";
hm.Name = "Description";
lg.Name = "language";
lg.Content = "English";
head.Controls.AddAt(0, lg);
char[] delimeter = { ' ' };
string[] keywords = dat.MakeNiceNameFull(dv[0]["Header"].ToString()).Replace("-", " ").Split(delimeter, StringSplitOptions.RemoveEmptyEntries);
int count2 = 0;
foreach (string token in keywords)
{
if (count2 < 16)
{
if (kw.Content != "")
kw.Content += " ";
kw.Content += token;
count2++;
}
}
head.Controls.AddAt(0, kw);
hm.Content = dat.MakeNiceNameFull(dat.stripHTML(dv[0]["Content"].ToString()).Replace(" ", " ").Replace(" ", " ")).Replace("-", " ");
if (hm.Content.Length > 200)
hm.Content = hm.Content.Substring(0, 197) + "...";
head.Controls.AddAt(0, hm);
this.Title = kw.Content;
HtmlLink lk = new HtmlLink();
lk.Href = "http://" + Request.Url.Authority + "/" +
dat.MakeNiceName(dat.BreakUpString(dv[0]["Header"].ToString(), 14)) +
"_" + ID.ToString() + "_Trip";
lk.Attributes.Add("rel", "bookmark");
head.Controls.AddAt(0, lk);
#endregion
fbLiteral.Text = "<fb:like href=\"" + Request.Url.AbsoluteUri + "\" send=\"true\" layout=\"button_count\" width=\"100\" show_faces=\"true\" font=\"\"></fb:like>";
Literal lit = new Literal();
lit.Text = "<script src=\"http://maps.google.com/maps?file=api&v=2&sensor=false&key=ABQIAAAAjjoxQtYNtdn3Tc17U5-jbBR2Kk_H7gXZZZniNQ8L14X1BLzkNhQjgZq1k-Pxm8FxVhUy3rfc6L9O4g\" type=\"text/javascript\"></script>";
head.Controls.Add(lit);
if (bool.Parse(dv[0]["Live"].ToString()))
{
if (Session["User"] != null)
{
if (dv[0]["UserName"].ToString() == Session["UserName"].ToString())
EditLink.Visible = true;
else
EditLink.Visible = false;
}
else
{
EditLink.Visible = false;
}
ASP.controls_contactad_ascx contact = new ASP.controls_contactad_ascx();
contact.THE_TEXT = "Contact Adventure Poster";
contact.RE_LABEL = "Re: " + dat.BreakUpString(dv[0]["Header"].ToString(), 14);
contact.TYPE = "ConnectTrip";
contact.ID = int.Parse(eventID);
ContactPanel.Controls.Add(contact);
PricePanel.Visible = false;
if (dv[0]["MaxPrice"] != null)
{
if (dv[0]["MaxPrice"].ToString() != "")
{
MinPrice.Text = dv[0]["MinPrice"].ToString().Replace(".00", "");
MaxPrice.Text = dv[0]["MaxPrice"].ToString().Replace(".00", "");
PricePanel.Visible = true;
}
}
DurationLabel.Text = "<b>Duration:</b> " + dat.GetDuration(dv[0]["Duration"].ToString());
char[] del = { ';' };
DataView daysToGo = dat.GetDataDV("SELECT * FROM TripDays WHERE TripID=" + eventID);
foreach (DataRowView row in daysToGo)
{
DaysLabel.Text += dat.GetHours(row["Days"].ToString()) + " " +
row["StartTime"].ToString() + " - " + row["EndTime"].ToString() + "<br/>";
}
DataView monthsToGo = dat.GetDataDV("SELECT * FROM TripMonths WHERE TripID=" + eventID);
foreach (DataRowView row in monthsToGo)
{
MonthsLabel.Text += dat.GetMonths(row["MonthStart"].ToString()) + ", " +
row["DayStart"].ToString() + " - " + dat.GetMonths(row["MonthEnd"].ToString()) +
", " + row["DayEnd"].ToString() + "<br/>";
}
ObtainLabel.Text = dv[0]["WhatObtain"].ToString();
DressLabel.Text = dv[0]["HowDress"].ToString();
foreach (ListItem item in MeansCheckList.Items)
{
if (dv[0]["Means"].ToString().Contains(item.Value))
{
item.Selected = true;
}
}
foreach (ListItem item in MeansCheckList2.Items)
{
if (dv[0]["Means"].ToString().Contains(item.Value))
{
item.Selected = true;
}
}
foreach (ListItem item in MeansCheckList3.Items)
{
if (dv[0]["Means"].ToString().Contains(item.Value))
{
item.Selected = true;
}
}
DataView dvBring = dat.GetDataDV("SELECT * FROM Trips_WhatToBring WHERE TripID=" + eventID);
int count = 1;
foreach (DataRowView row in dvBring)
{
BringLabel.Text += count.ToString() + ". " + row["WhatToBring"].ToString() + "<br/>";
count++;
}
dvBring = dat.GetDataDV("SELECT * FROM TripDirections WHERE TripID=" + eventID);
count = 1;
string dirFunc = "function PlotMapDirections(){var address; var address2; \r\n";
string prevAddrs = "";
string thisAddress = "";
int mapCount = 0;
string walking = "";
if (dvBring.Count == 1)
{
Directions.Text += count.ToString() + ". " + dvBring[0]["Directions"].ToString();
MapLiteral.Text = "<div id=\"map_canvas\" class=\"TripMapCanvas\"></div>";
thisAddress = dat.GetAddress(dvBring[0]["Address"].ToString(),
dvBring[0]["Country"].ToString() != "223") + " " + dvBring[0]["City"].ToString() + " " + dvBring[0]["State"].ToString() +
" " + dvBring[0]["Zip"].ToString() + " " + dvBring[0]["Country"].ToString();
dirFunc += "map = new GMap2(document.getElementById(\"map_canvas\")); map.setUIToDefault(); " +
"address = '" +
thisAddress.Replace("'", "''") + "'; createMarker(address, '" + dv[0]["Header"].ToString().Replace("'", "''") +
"','<div class=\"MapHeader\"><h2>" + dv[0]["Header"].ToString().Replace("'", "''") + ":</h2> <br/>" + dvBring[0]["Directions"].ToString().Replace("'", "''") + "</div>');}";
}
else
{
string firstAddress = "";
foreach (DataRowView row in dvBring)
{
Directions.Text += count.ToString() + ". " + row["Directions"].ToString() + "<br/>";
count++;
thisAddress = dat.GetAddress(row["Address"].ToString(),
row["Country"].ToString() != "223") + " " + row["City"].ToString() + " " + row["State"].ToString() +
" " + row["Zip"].ToString() + " " + row["Country"].ToString();
if (prevAddrs != "")
{
if ((bool)row["Walking"])
walking = "{travelMode:G_TRAVEL_MODE_WALKING}";
else
walking = "{travelMode:G_TRAVEL_MODE_DRIVING}";
dirFunc += "map = new GMap2(document.getElementById(\"map_canvas" +
mapCount.ToString() + "\")); \r\n map.setUIToDefault();\r\n directionsPanel = document.getElementById(\"my_textual_div" +
mapCount.ToString() + "\"); \r\n directions = " +
"new GDirections(map, directionsPanel);directions.load(\"from: " + prevAddrs.Replace("'", "''") +
" to: " + thisAddress.Replace("'", "''") + "\", " + walking + ");\r\n ";
GoogleDirectionsLiteral.Text += "<div id=\"my_textual_div" + mapCount.ToString() + "\"></div>";
MapLiteral.Text += "<div class=\"MapLiteral2\" id=\"map_canvas" + mapCount.ToString() + "\"></div>";
mapCount++;
}
else
{
firstAddress = thisAddress;
}
prevAddrs = thisAddress;
}
MapLiteral.Text += "<h1 class=\"SideColumn\">Map: <a onclick=\"createMarker('" + firstAddress.Replace("'", "''") + "', 'Beginning', '<h2>Beginning:</h2> <br/>" +
dvBring[0]["Directions"].ToString().Replace("'", "''") + "');\" class=\"NavyLinkUD\">Beginning</a> " +
"and <a class=\"NavyLinkUD\" onclick=\"createMarker('" + prevAddrs.Replace("'", "''") + "', 'Destination', '<h2>Destination:</h2> <br/>" +
dvBring[dvBring.Count - 1]["Directions"].ToString() + "');\">Destination</a></h1><div class=\"topDiv MapLiteral3\" id=\"map_canvas\" " +
"></div>";
dirFunc += "\r\n map = new GMap(document.getElementById(\"map_canvas\"));" +
"map.addControl(new GSmallMapControl());map.setCenter(new GLatLng(0,0), 0);\r\n " +
"createMarker('" + firstAddress.Replace("'", "''") + "', \"Beginning\", '<div class=\"MapHeader\"><h2>Beginning:</h2> <br/>" +
dvBring[0]["Directions"].ToString().Replace("'", "''") + "</div>');\r\n";
dirFunc += "}\r\n";
}
DirectionsLiteral.Text = "<script type=\"text/javascript\">" + dirFunc + "</script>";
Master.BodyTag.Attributes.Add("onload", "initialize();");
Master.BodyTag.Attributes.Add("onunload", "GUnload()");
EventName.Text = "<a id=\"" + dat.MakeNiceNameFull(dv[0]["Header"].ToString()) + "\" class=\"aboutLink\" href=\"http://" + Request.Url.Authority +
"/" +
dat.MakeNiceName(dv[0]["Header"].ToString()) +
"_" + ID.ToString() + "_Trip\"><h1>" +
dat.BreakUpString(dv[0]["Header"].ToString(), 50) + "</h1></a>";
Session["Subject"] = "Re: " + dv[0]["Header"].ToString();
Session["CommentSubject"] = "Re: " + dv[0]["Header"].ToString();
string UserName = dv[0]["UserName"].ToString();
TagCloud.THE_ID = int.Parse(ID);
string content = dv[0]["Content"].ToString();
string niceName = dat.MakeNiceName(dv[0]["Header"].ToString());
//ScriptLiteral.Text = "<script type=\"text/javascript\">ReturnURL('" + niceName.Replace("_", " ") + " http://HippoHappenings.com/" + Request.QueryString["ID"].ToString() + "_Trip');</script>";
if (Session["User"] != null)
{
DataSet dsComments;
string commentPrefs = dat.GetData("SELECT * FROM UserPreferences WHERE UserID=" + Session["User"].ToString()).Tables[0].Rows[0]["CommentsPreferences"].ToString();
if (commentPrefs == "1")
{
dsComments = dat.GetData("SELECT C.BlogDate AS theDate, * FROM TripComments C, Users U WHERE U.User_ID=C.UserID AND C.BlogID=" + ID + " ORDER BY C.BlogDate");
}
else
{
dsComments = dat.GetData("SELECT DISTINCT U.ProfilePicture, U.User_ID, U.UserName, C.Comment, C.BlogDate AS theDate FROM TripComments C, Users U, User_Friends UF WHERE ((UF.UserID=" + Session["User"].ToString() + " AND UF.FriendID=U.User_ID AND U.User_ID=C.UserID) OR (U.User_ID=" +
Session["User"].ToString() + " AND U.User_ID=C.UserID)) AND C.BlogID=" + ID + " ORDER BY C.BlogDate");
}
TheComments.DATA_SET = dsComments;
TheComments.DataBind2(true);
}
else
{
DataSet dsComments = dat.GetData("SELECT C.BlogDate AS theDate, * FROM TripComments C, Users U WHERE U.User_ID=C.UserID AND C.BlogID=" + ID + " ORDER BY C.BlogDate");
TheComments.DATA_SET = dsComments;
TheComments.DataBind2(true);
}
ShowDescriptionBegining.Text = dat.BreakUpString(content, 20);
Session["messageText"] = dat.BreakUpString(dv[0]["Header"].ToString(), 14);
Session["messageEmail"] = "Adventure Name: <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(dat.BreakUpString(dv[0]["Header"].ToString(), 14)) + "_" + ID + "_Trip\">" +
dat.BreakUpString(dv[0]["Header"].ToString(), 14) + "</a> <br/><br/> "+ ShowDescriptionBegining.Text;
//Media Categories: NONE: 0, Picture: 1, Video: 2, YouTubeVideo: 3, Slider: 4
Rotator1.Items.Clear();
int mediaCategory = int.Parse(dv[0]["mediaCategory"].ToString());
string youtube = dv[0]["YouTubeVideo"].ToString();
switch (mediaCategory)
{
case 0:
break;
case 1:
char[] delim4 = { ';' };
string[] youtokens = youtube.Split(delim4);
if (youtube != "")
{
for (int i = 0; i < youtokens.Length; i++)
{
if (youtokens[i].Trim() != "")
{
Literal literal3 = new Literal();
//literal3.Text = "<object width=\"400\" height=\"250\"><param name=\"wmode\" value=\"opaque\" ><param name=\"movie\" value=\"http://www.youtube.com/cp/vjVQa1PpcFOFUjhw1qTHaE09Z1e9QYKk9y1JrWf5VAc=\"></param><embed wmode=\"opaque\" src=\"http://www.youtube.com/cp/vjVQa1PpcFOFUjhw1qTHaE09Z1e9QYKk9y1JrWf5VAc=\" type=\"application/x-shockwave-flash\" width=\"400\" height=\"250\"></embed></object>";
literal3.Text = "<div class=\"YouTubeWrapper\"><object class=\"toHidde\" width=\"412\" " +
"height=\"250\"><param name=\"movie\" value=\"http://www.youtube.com/v/" + youtokens[i] +
"\"/><param name=\"wmode2\" value=\"transparent\" /><param name=\"wmode\" " +
"value=\"opaque\" /><param name=\"allowFullScreen\" value=\"true\"/><embed " +
"src=\"http://www.youtube.com/v/" +
youtokens[i] + "\" wmode=\"opaque\" wmode2=\"transparent\" type=\"application/x-shockwave" +
"-flash\" allowfullscreen=\"true\" width=\"412\" height=\"250\"/></object></div>";
Telerik.Web.UI.RadRotatorItem r3 = new Telerik.Web.UI.RadRotatorItem();
r3.Controls.Add(literal3);
Rotator1.Items.Add(r3);
}
}
}
DataView dsSlider = dat.GetDataDV("SELECT * FROM Trip_Slider_Mapping WHERE TripID=" + ID);
if (dsSlider.Count > 0)
{
try
{
char[] delim = { '\\' };
char[] delim3 = { '.' };
string[] fileArray = System.IO.Directory.GetFiles(MapPath(".") + "\\Trips\\" + ID + "\\Slider");
string[] finalFileArray = new string[fileArray.Length];
for (int i = 0; i < dsSlider.Count; i++)
{
string[] tokens = dsSlider[i]["PictureName"].ToString().Split(delim3);
//dsSlider.RowFilter = "PictureName='" + tokens[0] + "." + tokens[1] + "'";
if (tokens.Length >= 2 && dsSlider.Count > 0)
{
if (tokens[1].ToUpper() == "JPG" || tokens[1].ToUpper() == "JPEG" || tokens[1].ToUpper() == "GIF" || tokens[1].ToUpper() == "PNG")
{
System.Drawing.Image image = System.Drawing.Image.FromFile(MapPath(".") + "\\Trips\\" +
ID + "\\Slider\\" + dsSlider[i]["PictureName"].ToString());
int width = 410;
int height = 250;
int newHeight = 0;
int newIntWidth = 0;
//if image height is less than resize height
if (height >= image.Height)
{
//leave the height as is
newHeight = image.Height;
if (width >= image.Width)
{
newIntWidth = image.Width;
}
else
{
newIntWidth = width;
double theDivider = double.Parse(image.Width.ToString()) / double.Parse(newIntWidth.ToString());
double newDoubleHeight = double.Parse(newHeight.ToString());
newDoubleHeight = double.Parse(height.ToString()) / theDivider;
newHeight = (int)newDoubleHeight;
}
}
//if image height is greater than resize height...resize it
else
{
//make height equal to the requested height.
newHeight = height;
//get the ratio of the new height/original height and apply that to the width
double theDivider = double.Parse(image.Height.ToString()) / double.Parse(newHeight.ToString());
double newDoubleWidth = double.Parse(newIntWidth.ToString());
newDoubleWidth = double.Parse(image.Width.ToString()) / theDivider;
newIntWidth = (int)newDoubleWidth;
//if the resized width is still to big
if (newIntWidth > width)
{
//make it equal to the requested width
newIntWidth = width;
//get the ratio of old/new width and apply it to the already resized height
theDivider = double.Parse(image.Width.ToString()) / double.Parse(newIntWidth.ToString());
double newDoubleHeight = double.Parse(newHeight.ToString());
newDoubleHeight = double.Parse(image.Height.ToString()) / theDivider;
newHeight = (int)newDoubleHeight;
}
}
Literal literal4 = new Literal();
string[] nameTokens = dsSlider[i]["RealPictureName"].ToString().Split(delim3);
string realName = dat.MakeNiceName(nameTokens[0]).Replace("_", " ");
literal4.Text = "<div class=\"RotatorImage\"><img alt=\"" + realName +
"\" style=\" margin-left: " + ((410 - newIntWidth) / 2).ToString() + "px; margin-top: " + ((250 - newHeight) / 2).ToString() + "px;\" height=\"" + newHeight + "px\" width=\"" + newIntWidth + "px\" src=\""
+ "Trips/" + ID + "/Slider/" + dsSlider[i]["PictureName"].ToString() + "\" /></div>";
Telerik.Web.UI.RadRotatorItem r4 = new Telerik.Web.UI.RadRotatorItem();
r4.Controls.Add(literal4);
Rotator1.Items.Add(r4);
}
}
}
}
catch (Exception ex)
{
}
}
break;
default: break;
}
if (Rotator1.Items.Count == 0)
RotatorPanel.Visible = false;
else
{
RotatorPanel.Visible = true;
if (Rotator1.Items.Count == 1)
{
RotatorPanel.CssClass = "HiddeButtons";
}
}
if (fillUserData)
{
ASP.controls_sendmessage_ascx SendMessage1 = new ASP.controls_sendmessage_ascx();
SendMessage1.THE_TEXT = "Share on Hippo";
SendMessage1.RE_LABEL = "Re: " + Session["UserName"].ToString() +
" would like to share \"" + dat.BreakUpString(dv[0]["Header"].ToString(), 14) + "\" with you.";
SendMessage1.TYPE = "t";
SendMessage1.ID = int.Parse(ID);
CalendarSharePanel.Controls.Add(SendMessage1);
Session["Subject"] = "Re: " + Session["UserName"].ToString() +
" would like to share \"" + dat.BreakUpString(dv[0]["Header"].ToString(), 14) + "\" with you.";
}
}
else
{
EventName.Text = "This adventure has been disabled";
}
}
catch (Exception ex)
{
ErrorLabel.Text = ex.ToString();
//Response.Redirect("~/home");
}
}
