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