protected void Page_Load(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); BeginingLiteral.Text = "<div style=\"background-color:" + color + "; width: " + width.ToString() + "px; padding: 3px; margin-bottom: 3px;\">"; SearchLabel.Text = searchLabel; //search = true is disabled here if (windowT) { SearchLabel.Attributes.Add("onclick", "CloseWindow('" + "../" + dat.MakeNiceName(searchLabel) + "_" + adID + "_Ad" + "');"); } else { SearchLabel.NavigateUrl = "../" + dat.MakeNiceName(searchLabel) + "_" + adID + "_Ad"; } string begining = "<a style=\"color: #b1a812; font-family: Arial; font-size: 11px;\">"; string end = "</a>"; dat.TAG_TYPE = Data.tagType.AD; string tags = dat.getTags(dat.GetData("SELECT C.ID, C.Name AS CategoryName, ACM.tagSize FROM Ad_Category_Mapping ACM, AdCategories C WHERE ACM.CategoryID=C.ID AND ACM.AdID=" + adID), false, windowT); TagsLiteral.Text = "<span style=\"color: #b1a812; line-height: 10px; font-size: 11px;\" >" + tags + "</span>"; }
protected void DrawEvents(DataView dvEvents, int cutOff) { string eventID = GetEventID(); 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 isNow = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")); Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); Literal lit = new Literal(); int count = 0; DataView dvEvent; string contentSub = ""; foreach (DataRowView row in dvEvents) { if (count > cutOff - 1) { break; } else { contentSub = dat.stripHTML(row["Content"].ToString().Replace("<br>", "").Replace("</br>", "").Replace("<br/>", "").Replace("<BR>", "").Replace("<BR/>", "").Replace("<br />", "").Replace("<BR />", "")); if (dat.stripHTML(row["Content"].ToString().Replace("<br>", "").Replace("</br>", "").Replace("<br/>", "").Replace("<BR>", "").Replace("<BR/>", "").Replace("<br />", "").Replace("<BR />", "")).Length > 100) contentSub = dat.stripHTML(row["Content"].ToString().Replace("<br>", "").Replace("</br>", "").Replace("<br/>", "").Replace("<BR>", "").Replace("<BR/>", "").Replace("<br />", "").Replace("<BR />", "")).Substring(0, 100); dvEvent = dat.GetDataDV("SELECT * FROM Events E, Event_Occurance EO WHERE E.ID=EO.EventID AND E.ID=" + row["EventID"].ToString()); lit.Text += "<div class=\"SimilarSide\">"; lit.Text += "<a class=\"Blue12Link\" href=\"" + dat.MakeNiceName(row["Header"].ToString()) + "_" + row["EventID"].ToString() + "_Event\">" + row["Header"].ToString() + "</a> at " + "<a class=\"Green12LinkNF\" href=\"" + dat.MakeNiceName(row["Name"].ToString()) + "_" + row["Venue"].ToString() + "_Venue\">" + row["Name"].ToString() + "</a> on " + DateTime.Parse(dvEvent[0]["DateTimeStart"].ToString()).ToShortDateString() + ". " + dat.BreakUpString(contentSub, 30) + "... <a class=\"Blue12Link\" href=\"" + dat.MakeNiceName(row["Header"].ToString()) + "_" + row["EventID"].ToString() + "_Event\">Read More</a>"; lit.Text += "</div>"; count++; } } OtherEventsPanel.Controls.Add(lit); }
protected void Page_Load(object sender, EventArgs e) { Data dat = new Data(DateTime.Now); DayLabel.Text = day; MonthLabel.Text = month; DayNumberLabel.Text = daynumber; EventNameLabel.Text = eventname; theTable.Attributes.Add("onclick", "window.location = '" + dat.MakeNiceName(eventname) + "_" + eventID + "_Event'"); EventNameLabel.NavigateUrl = "~/" + dat.MakeNiceName(eventname) + "_" + eventID + "_Event"; SummaryLabel.Text = summary; ReadMoreLink.NavigateUrl = "~/" + dat.MakeNiceName(eventname) + "_" + eventID + "_Event"; //ReadMoreLink.NavigateUrl = "~/Event.aspx?EventID="+eventID; }
protected void DrawBulletins(DataView dvEvents, int cutOff) { string eventID = Request.QueryString["AdID"]; 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 isNow = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")); Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); Literal lit = new Literal(); int count = 0; DataView dvEvent; string contentSub = ""; foreach (DataRowView row in dvEvents) { if (count > cutOff - 1) { break; } else { contentSub = dat.stripHTML(row["Content"].ToString().Replace("<br>", "").Replace("</br>", "").Replace("<br/>", "").Replace("<BR>", "").Replace("<BR/>", "").Replace("<br />", "").Replace("<BR />", "")); if (dat.stripHTML(row["Content"].ToString().Replace("<br>", "").Replace("</br>", "").Replace("<br/>", "").Replace("<BR>", "").Replace("<BR/>", "").Replace("<br />", "").Replace("<BR />", "")).Length > 100) contentSub = dat.stripHTML(row["Content"].ToString().Replace("<br>", "").Replace("</br>", "").Replace("<br/>", "").Replace("<BR>", "").Replace("<BR/>", "").Replace("<br />", "").Replace("<BR />", "")).Substring(0, 100); lit.Text += "<div class=\"SimilarSide\">"; lit.Text += "<a class=\"Green12LinkNF\" href=\"" + dat.MakeNiceName(row["Header"].ToString()) + "_" + row["AdID"].ToString() + "_Ad\">" + row["Header"].ToString() + "</a>. " + dat.BreakUpString(contentSub, 30) + "... <a class=\"Blue12Link\" href=\"" + dat.MakeNiceName(row["Header"].ToString()) + "_" + row["AdID"].ToString() + "_Ad\">Read More</a>"; lit.Text += "</div>"; count++; } } OtherAdsPanel.Controls.Add(lit); }
protected void Page_Load(object sender, EventArgs e) { HtmlMeta hm = new HtmlMeta(); HtmlHead head = (HtmlHead)Page.Header; hm.Name = "ROBOTS"; hm.Content = "NOINDEX, FOLLOW"; head.Controls.AddAt(0, hm); HttpCookie cookie = Request.Cookies["BrowserDate"]; if (cookie == null) { cookie = new HttpCookie("BrowserDate"); cookie.Value = DateTime.Now.ToString(); cookie.Expires = DateTime.Now.AddDays(22); Response.Cookies.Add(cookie); } //Ajax.Utility.RegisterTypeForAjax(typeof(Delete)); if (!IsPostBack) { string cookieName = FormsAuthentication.FormsCookieName; HttpCookie authCookie = Context.Request.Cookies[cookieName]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); DataView dvEvent = dat.GetDataDV("SELECT * FROM GroupEvents WHERE ID=" + Request.QueryString["ID"].ToString()); string groupID = dvEvent[0]["GroupID"].ToString(); DataView dvGroup = dat.GetDataDV("SELECT * FROM Groups WHERE ID=" + groupID); ImageButton9.OnClientClick = "Search('" + dat.MakeNiceName(dvGroup[0]["Header"].ToString()) + "_" + groupID + "_Group');"; TextLabel.Text = "Are you sure you want to delete the event '" + dvEvent[0]["Name"].ToString() + "' from the group '" + dvGroup[0]["Header"].ToString() + "'"; } }
protected void Page_Load(object sender, EventArgs e) { try { HtmlMeta hm = new HtmlMeta(); HtmlHead head = (HtmlHead)Page.Header; hm.Name = "ROBOTS"; hm.Content = "NOINDEX, FOLLOW"; head.Controls.AddAt(0, hm); HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); DataView dvGroupEvent = dat.GetDataDV("SELECT * FROM GroupEvents WHERE ID=" + Request.QueryString["ID"].ToString()); ImageButton9.OnClientClick = "javascript:Search('" + dat.MakeNiceName(dvGroupEvent[0]["Name"].ToString()) + "_" + Request.QueryString["O"].ToString() + "_" + Request.QueryString["ID"].ToString() + "_GroupEvent');"; string groupID = Request.QueryString["ID"].ToString(); string command = "SELECT * FROM Group_Members WHERE GroupID=" + dvGroupEvent[0]["GroupID"].ToString() + " AND MemberID=" + Session["User"].ToString(); DataView dvMembers = dat.GetDataDV(command); if (bool.Parse(dvMembers[0]["SharedHosting"].ToString())) { HostPanel.Visible = true; } else HostPanel.Visible = false; } 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); } Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); if (Session["User"] == null) { Response.Redirect("~/Home.aspx"); } if (Request.QueryString["ID"] == null) Response.Redirect("Home.aspx"); if (dat.HasEventPassed(Request.QueryString["ID"].ToString())) { DataView dvName = dat.GetDataDV("SELECT * FROM Events WHERE ID="+ Request.QueryString["ID"].ToString()); Response.Redirect(dat.MakeNiceName(dvName[0]["Header"].ToString()) + "_" + Request.QueryString["ID"].ToString() + "_Event"); } }
protected void Page_Load(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); TitleLabel.Text = title; TitleLabel.NavigateUrl = "../" + dat.MakeNiceName(title) + "_" + eventID + "_Event"; summary = summary.Replace("<br/>", " "); if (summary.Length > 70) summary = dat.BreakUpString(summary.Substring(0, 70), 35) + "..."; OtherEventSummaryLabel.Text = summary; PresentedByLabel.Text = "presented on " + presentedBy; }
protected void SubmitIt(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); if (UpdateText.Text.Trim() != "") { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString()); conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO EventUpdates (modifierID, EventID, eventChange) "+ "VALUES("+Session["User"].ToString()+", "+Request.QueryString["ID"].ToString()+", @p3)", conn); cmd.Parameters.Add("@p3", SqlDbType.NVarChar).Value = UpdateText.Text; cmd.ExecuteNonQuery(); conn.Close(); string ID = Request.QueryString["ID"].ToString(); Encryption encrypt = new Encryption(); DataSet dsEvent = dat.GetData("SELECT * FROM Events WHERE ID=" + ID); //send email to users who have this event in their calendar and selected their preferences string emailBody = "<br/><br/>Updates have been made to an event in your calendar: Event '\"" + dsEvent.Tables[0].Rows[0]["Header"].ToString() + "\"'. <br/><br/> To view these updates, please go to this event's <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Header"].ToString())+ "_" + ID + "_Event\">page</a> and click on the updates drop down. " + "<br/><br/><br/>Have a Hippo Happening Day!<br/><br/> <a href=\"http://HippoHappenings.com\">Happening Hippo</a>"; DataSet dsAllUsers = dat.GetData("SELECT * FROM User_Calendar UC, Users U, UserPreferences UP WHERE U.User_ID=UP.UserID AND UP.EmailPrefs LIKE '%C%' AND U.User_ID=UC.UserID AND UC.EventID=" + ID); DataView dv = new DataView(dsAllUsers.Tables[0], "", "", DataViewRowState.CurrentRows); if (dv.Count > 0) { for (int i = 0; i < dv.Count; i++) { dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(), System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), dv[i]["Email"].ToString(), emailBody, "Event '" + dsEvent.Tables[0].Rows[0]["Header"].ToString() + "' has been modified"); } } Session["Message"] = "Your update has been posted successfully<br/><br/> Here are your next steps. <br/><br/>"; Session["Message"] += "<br/><br/>" + "-Go to <a class=\"AddLink\" onclick=\"Search('" + dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Header"].ToString()) + "_" + ID + "_Event');\">this event's</a> home page.<br/><br/> -<a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Type=E&ID=" + ID + "');\" >Rate </a>your user experience posting this event."; MessageRadWindow.NavigateUrl = "Message.aspx?message=" + encrypt.encrypt(Session["Message"].ToString() + "<br/><br/><img onclick=\"Search('Home.aspx');\" onmouseover=\"this.src='image/DoneSonButtonSelected.png'\" onmouseout=\"this.src='image/DoneSonButton.png'\" src=\"image/DoneSonButton.png\"/><br/>"); MessageRadWindow.Visible = true; MessageRadWindowManager.VisibleOnPageLoad = true; } else { ErrorLabel.Text = "Please enter an Update."; } }
protected void Page_Load(object sender, EventArgs e) { HtmlMeta hm = new HtmlMeta(); HtmlHead head = (HtmlHead)Page.Header; hm.Name = "ROBOTS"; hm.Content = "NOINDEX, FOLLOW"; head.Controls.AddAt(0, hm); HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); DataView dvGroupEvent = dat.GetDataDV("SELECT * FROM GroupEvents WHERE ID=" + Request.QueryString["ID"].ToString()); ImageButton9.OnClientClick = "javascript:Search('" + dat.MakeNiceName(dvGroupEvent[0]["Name"].ToString()) + "_" + Request.QueryString["O"].ToString() + "_" + Request.QueryString["ID"].ToString() + "_GroupEvent');"; }
protected void Page_Load(object sender, EventArgs e) { Data dat = new Data(DateTime.Now); if(Request.QueryString["ID"] == null) Response.Redirect("../home"); string theID = Request.QueryString["ID"].ToString(); DataView dv = dat.GetDataDV("SELECT * FROM HippoBlogContent WHERE ID=" + theID); TitleLiteral.Text = dv[0]["Title"].ToString(); TagLineLiteral.Text = dv[0]["TagLine"].ToString(); MainContentLiteral.Text = dv[0]["MainContent"].ToString(); MainImage.Visible = false; if (dv[0]["MainImage"].ToString() != "") { MainImage.ImageUrl = dv[0]["MainImage"].ToString(); MainImage.Visible = true; } Page.Title = dat.MakeNiceName(dv[0]["Title"].ToString()); }
protected string GetEmailString(string header, string picture, string ID, string description, string userName, ref int normalAdCount, string templateID) { HttpCookie cookie = Request.Cookies["BrowserDate"]; DateTime isn = DateTime.Now; if (!DateTime.TryParse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"), out isn)) isn = DateTime.Now; DateTime isNow = isn; Data dat = new Data(isn); string adtitle = "style=\"color: #7c7a7a;font-size: 14px;font-weight: bold;text-decoration: none;\""; string adbody = "style=\"color: #7c7a7a;font-size: 12px;font-weight: normal;\""; string readmorelink = "style=\"color: #09718F;text-decoration: none;cursor: pointer;\""; string email = ""; string w = ""; string h = ""; if (normalAdCount % 2 == 0) { email += "<tr><td>"; } else { email += "<td>"; } email += "<div align=\"center\" style=\"position: relative;float: left;width: 198px; height: 262px;border: solid 1px #d9d6d6; " + "margin-right: 2px; " + "\">"; if (picture == null) { email += "<div style=\"padding-top: 10px; clear: both; padding-left: 1px;\">"; } else { GetAdSize(out w, out h, picture, templateID); if (templateID == "1") { email += "<div style=\"padding-top: 10px; clear: both; padding-left: 1px;\"><div style=\"float: left;padding-right: 2px;\"><table width=\"100px\" height=\"100px\" " + "cellpadding=\"0\" cellspacing=\"0\"><tbody align=\"center\"><tr><td valign=\"middle\">"; } else if (templateID == "2") { email += "<div style=\"padding-top: 10px; clear: both;\"><div style=\"float: left;padding-right: 2px;\"><table width=\"198px\" height=\"140px\" " + "cellpadding=\"0\" cellspacing=\"0\"><tbody align=\"center\"><tr><td valign=\"middle\"> "; } else { email += "<div style=\"clear: both;\"><div center=\"float\" style=\"float: left;\"><table width=\"198px\" height=\"262px\" " + "cellpadding=\"0\" cellspacing=\"0\"><tbody align=\"center\"><tr><td valign=\"middle\"> "; } if (ID == null) { email += "<img alt=\"" + header + "\" " + "name=\"" + header + "\" width='" + w + "px' height='" + h + "px' src=\"./UserFiles/" + userName + "/" + picture + "\" /></td></tr></tbody></table></div>"; } else { email += "<a href=\"http://HippoHappenings.com/" + dat.MakeNiceName(header) + "_" + ID + "_Ad" + "\" ><img style='border: 0;' alt=\"" + header + "\" " + "name=\"" + header + "\" width='" + w + "px' height='" + h + "px' src=\"http://hippohappenings.com/UserFiles/" + userName + "/" + picture + "\" /></a></td></tr></tbody></table></div>"; } } if (ID == null) { if (templateID == "1") { email += "<div><a class=\"Text14\">" + dat.BreakUpString(header, 10) + "</a></div></div>" + "<div align=\"center\" style=\"clear: both; padding-left: 2px; padding-right: 2px;" + "padding-top: 1px;\"> " + "<span class=\"Text12\">" + dat.BreakUpString(description, 21) + "</span>" + "</div>" + "<div style=\"clear: none;\"><a class=\"ReadMoreHome2\">Read More</a>" + "</div></div>"; } else if (templateID == "2") { email += "</div><div style=\"padding-top: 5px; clear: both; padding-right: 4px;padding-left: 4px;\"><a class=\"Text14\">" + dat.BreakUpString(header, 21) + "</a></div>" + "<div align=\"center\" style=\"clear: both; padding-left: 4px; padding-right: 4px;\"> " + "<span class=\"Text12\">" + dat.BreakUpString(description, 21) + "</span>" + "</div>" + "<div style=\"clear: none;\"><a class=\"ReadMoreHome2\">Read More</a>" + "</div></div>"; } } else { if (templateID == "1") { email += "<div><a href=\"../" + dat.MakeNiceName(header) + "_" + ID + "_Ad\" class=\"Text14\">" + dat.BreakUpString(header, 10) + "</a></div></div>" + "<div align=\"center\" style=\"clear: both; padding-left: 2px; padding-right: 2px;" + "padding-top: 1px;\"> " + "<span class=\"Text12\">" + dat.BreakUpString(description, 21) + "</span>" + "</div>" + "<div style=\"clear: none;\"><a class=\"ReadMoreHome2\" href=\"../" + dat.MakeNiceName(header) + "_" + ID + "_Ad\">Read More</a>" + "</div></div>"; } else if (templateID == "2") { email += "</div><div style=\"padding-top: 5px; clear: both; padding-right: 4px;padding-left: 4px;\"><a href=\"../" + dat.MakeNiceName(header) + "_" + ID + "_Ad\" class=\"Text14\">" + dat.BreakUpString(header, 21) + "</a></div>" + "<div align=\"center\" style=\"clear: both; padding-left: 4px; padding-right: 4px;\"> " + "<span class=\"Text12\">" + dat.BreakUpString(description, 21) + "</span>" + "</div>" + "<div style=\"clear: none;\"><a class=\"ReadMoreHome2\" href=\"../" + dat.MakeNiceName(header) + "_" + ID + "_Ad\">Read More</a>" + "</div></div>"; } } if (normalAdCount % 2 == 0) { email += "</td>"; } else { email += "</td></tr>"; } normalAdCount++; return email; }
protected void GetAds() { AdPanel.Controls.Clear(); HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); DataSet dsAds = dat.GetData("SELECT * FROM Ads WHERE User_ID=" + Session["User"].ToString() + " ORDER BY Header"); DataView dvAdds = new DataView(dsAds.Tables[0], "", "", DataViewRowState.CurrentRows); Panel panel; ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx(); if (dvAdds.Count > 0) { pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 10; pagerPanel.WIDTH = 576; pagerPanel.NUMBER_OF_VISIBLE_PAGES = 4; ArrayList a = new ArrayList(dvAdds.Count); int pagecount = 1; for (int i = 0; i < dvAdds.Count; i++) { string featured = "False"; if (bool.Parse(dvAdds[i]["Featured"].ToString())) featured = "True"; Literal label = new Literal(); label.Text = "<tr><td><a class=\"AddGreyLinkAlt\" style=\"padding-left: 10px;\" " + "href=\"" + dat.MakeNiceName(dvAdds[i]["Header"].ToString()) + "_" + dvAdds[i]["Ad_ID"].ToString() + "_Ad\">" + dvAdds[i]["Header"].ToString() + "</a></td><td><label class=\"AddGreenLink\">" + featured + "</label></td>"; string disableStr = ""; if (bool.Parse(dvAdds[i]["LIVE"].ToString())) { disableStr = "<td><a class=\"PageButtons\" onclick=\"OpenRadDeleteAd(" + dvAdds[i]["Ad_ID"].ToString() + ")\">Disable</a></td>"; } else { disableStr = "<td><a class=\"PageButtons\" onclick=\"OpenRadEnableAd(" + dvAdds[i]["Ad_ID"].ToString() + ")\">Enable</a></td>"; } if (featured == "True") { label.Text += "<td><a class=\"AddGreyLinkAlt\" href=\"AdStatistics.aspx?Ad=" + dvAdds[i]["Ad_ID"].ToString() + "\">View Statistics</a></td><td width=\"50px\"><a " + "class=\"PageButtons\" href=\"PostAnAd.aspx?copy=true&ID=" + dvAdds[i]["Ad_ID"].ToString() + "\">Copy</a></td>"+disableStr+"</tr>"; } else { label.Text += "<td></td><td width=\"50px\"><a " + "class=\"PageButtons\" href=\"PostAnAd.aspx?copy=true&ID=" + dvAdds[i]["Ad_ID"].ToString() + "\">Copy</a></td>"+disableStr+"</tr>"; } //panel = new Panel(); //Literal lNew = new Literal(); if ((i % pagerPanel.NUMBER_OF_ITEMS_PER_PAGE) == 0) { label.Text = "<table width=\"576px\"><tbody style=\"opacity: .7; filter: alpha(opacity = 70);background-color: #603E6A;\"><tr><td width=\"400px\"><label>Ad Name</label></td><td><label>Featured?</label></td><td></td><td></td><td></td></tr>" + label.Text; //panel.Controls.Add(lNew); } //Literal lOld = new Literal(); //panel.Controls.Add(label); if ((i + 1) == 10 * pagecount || i == dvAdds.Count - 1) { label.Text = label.Text + "</tbody></table>"; pagecount++; //panel.Controls.Add(lOld); } a.Add(label); } pagerPanel.DATA = a; pagerPanel.DataBind2(); AdPanel.Controls.Add(pagerPanel); } else { pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 1; pagerPanel.WIDTH = 576; pagerPanel.NUMBER_OF_VISIBLE_PAGES = 1; ArrayList a = new ArrayList(1); Literal lit = new Literal(); lit.Text = "<label>You are not an owner of any ads. To post ads go to <a href=\"PostAnAd.aspx\" class=\"AddLink\">Post An Ad page</a>.</label>"; a.Add(lit); pagerPanel.DATA = a; pagerPanel.DataBind2(); AdPanel.Controls.Add(pagerPanel); } }
protected void GetVenues() { VenuesPanel.Controls.Clear(); HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); DataSet dsAds = dat.GetData("SELECT * FROM Venues WHERE Owner=" + Session["User"].ToString() + " ORDER BY Name"); DataView dvAdds = new DataView(dsAds.Tables[0], "", "", DataViewRowState.CurrentRows); ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx(); if (dvAdds.Count > 0) { pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 10; pagerPanel.WIDTH = 576; pagerPanel.NUMBER_OF_VISIBLE_PAGES = 4; ArrayList a = new ArrayList(dvAdds.Count); int pagecount = 1; for (int i = 0; i < dvAdds.Count; i++) { Literal label = new Literal(); //label.CssClass = "AddLink"; if (i % 10 == 0) label.Text = "<table width=\"576px\"><tbody style=\"opacity: .8; filter: alpha(opacity = 80);background-color: #603E6A;\">"; label.Text += "<tr><td><a class=\"AddGreyLinkAlt\" style=\"padding-left: 10px;\" href=\"" + dat.MakeNiceName(dvAdds[i]["Name"].ToString()) + "_" + dvAdds[i]["ID"].ToString() + "_Venue\">" + dvAdds[i]["Name"].ToString() + "</a></td></tr>"; if ((i + 1) == 10 * pagecount || i == dvAdds.Count - 1) { label.Text += "</tbody></table>"; pagecount++; } //panel = new Panel(); //panel.Controls.Add(label); a.Add(label); } pagerPanel.DATA = a; pagerPanel.DataBind2(); VenuesPanel.Controls.Add(pagerPanel); } else { pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 1; pagerPanel.WIDTH = 576; pagerPanel.NUMBER_OF_VISIBLE_PAGES = 1; ArrayList a = new ArrayList(1); Literal lit = new Literal(); lit.Text = "<label>You are not an owner of any venues. To post venues go to <a href=\"EnterVenueIntro.aspx\" class=\"AddLink\">Post A Venue page</a>.</label>"; a.Add(lit); pagerPanel.DATA = a; pagerPanel.DataBind2(); VenuesPanel.Controls.Add(pagerPanel); } }
protected void GetEvents() { EventsPanel.Controls.Clear(); HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); DataSet dsAds = dat.GetData("SELECT * FROM Events WHERE Owner=" + Session["User"].ToString() + " ORDER BY Header"); DataView dvAdds = new DataView(dsAds.Tables[0], "", "", DataViewRowState.CurrentRows); Panel panel; ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx(); if (dvAdds.Count > 0) { pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 10; pagerPanel.WIDTH = 576; pagerPanel.NUMBER_OF_VISIBLE_PAGES = 4; ArrayList a = new ArrayList(dvAdds.Count); int pagecount = 1; for (int i = 0; i < dvAdds.Count; i++) { Literal label = new Literal(); //label.CssClass = "AddLink"; string disableStr = ""; if (bool.Parse(dvAdds[i]["LIVE"].ToString())) { disableStr = "<td width=\"50px\"><a class=\"PageButtons\" onclick=\"OpenRadDeleteEvent(" + dvAdds[i]["ID"].ToString() + ")\">Disable</a></td>"; } else { disableStr = "<td width=\"50px\"><a class=\"PageButtons\" onclick=\"OpenRadEnableEvent(" + dvAdds[i]["ID"].ToString() + ")\">Enable</a></td>"; } if (i % 10 == 0) label.Text = "<table width=\"576px\"><tbody style=\"background-color: #628E02;opacity: .8; filter:alpha(opacity = 80);\">"; label.Text += "<tr><td><a class=\"AddGreyLinkAlt\" style=\"padding-left: 10px;\" href=\"" + dat.MakeNiceName(dvAdds[i]["Header"].ToString()) + "_" + dvAdds[i]["ID"].ToString() + "_Event\">" + dvAdds[i]["Header"].ToString() + "</a></td><td width=\"50px\"><a style=\"font-family: Arial; font-size: 14px;text-decoration: none; color: #cccccc; font-weight: bold;\" href=\"BlogEvent.aspx?copy=true&ID=" + dvAdds[i]["ID"].ToString() + "\">Copy</a></td>"+disableStr+"</tr>"; if ((i + 1) == 10 * pagecount || i == dvAdds.Count - 1) { label.Text += "</tbody></table>"; pagecount++; } //panel = new Panel(); //panel.Controls.Add(label); a.Add(label); } pagerPanel.DATA = a; pagerPanel.DataBind2(); EventsPanel.Controls.Add(pagerPanel); } else { pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 1; pagerPanel.WIDTH = 576; pagerPanel.NUMBER_OF_VISIBLE_PAGES = 1; ArrayList a = new ArrayList(1); Literal lit = new Literal(); lit.Text = "<label>You are not an owner of any events. To post events go to <a href=\"EnterEvent.aspx\" class=\"AddLink\">Post An Event page</a>.</label>"; a.Add(lit); pagerPanel.DATA = a; pagerPanel.DataBind2(); EventsPanel.Controls.Add(pagerPanel); } }
protected void CreateMembers(string theID, bool isUpdate, string IDofFirstOccurance) { if (ParticipantsList.SelectedValue != "1") { string command = ""; try { char[] delim = { '-' }; HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); string emailBody = Session["UserName"].ToString() + " has created a new group event <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT.Trim()) + "_" + IDofFirstOccurance + "_" + theID + "_GroupEvent\">" + VenueNameTextBox.THE_TEXT.Trim() + "</a> and is inviting you to it." + " To accept this invitation <a href=\"http://hippohappenings.com/my-account\">log in to HippoHappenings</a>, view your messages in 'My Account' and " + "click 'Accept' in the message corresponding to this email. Have good fun at the event! <br/><br/>HippoHappenings"; string emailSubject = "You have a group event invite for '" + VenueNameTextBox.THE_TEXT + "'"; string messageBody = theID + " " + Session["UserName"].ToString() + " has created a new group event <a class=\"AddLink\" href=\"" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT.Trim()) + "_" + IDofFirstOccurance + "_" + theID + "_GroupEvent\">" + VenueNameTextBox.THE_TEXT.Trim() + "</a> and is inviting you to it. Click " + "the 'Accept' button to the right if you accept this invitation. "; if (isUpdate) { emailBody = Session["UserName"].ToString() + " has updated the group event <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT.Trim()) + "_" + IDofFirstOccurance + "_" + theID + "_GroupEvent\">" + VenueNameTextBox.THE_TEXT.Trim() + "</a> and is inviting you to it." + " To accept this invitation <a href=\"http://hippohappenings.com/my-account\">log in to HippoHappenings</a>, view your messages in 'My Account' and " + "click 'Accept' in the message corresponding to this email. Have good fun at the event! <br/><br/>HippoHappenings"; emailSubject = "You have a group event invite for '" + VenueNameTextBox.THE_TEXT + "'"; messageBody = theID + " " + Session["UserName"].ToString() + " has updated the group event <a class=\"AddLink\" href=\"" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT.Trim()) + "_" + IDofFirstOccurance + "_" + theID + "_GroupEvent\">" + VenueNameTextBox.THE_TEXT.Trim() + "</a> and is inviting you to it. Click " + "the 'Accept' button to the right if you accept this invitation. "; } DataView dvMems; dvMems = dat.GetDataDV("SELECT * FROM Group_Members WHERE GroupID=" + Request.QueryString["GroupID"].ToString()); DataView dvUserGroupCalendar = dat.GetDataDV("SELECT * FROM User_GroupEvent_Calendar WHERE GroupEventID=" + theID); bool doIt = false; if (dvUserGroupCalendar.Count > 0) { if (ParticipantsList.SelectedValue == "2" || ParticipantsList.SelectedValue == "3") { foreach (DataRowView row in dvUserGroupCalendar) { doIt = false; if (ParticipantsList.SelectedValue == "2") { dvMems.RowFilter = "MemberID=" + row["UserID"].ToString(); if (dvMems.Count > 0) doIt = true; } else { if (GroupMembersSelectedListBox.Items.Contains(new ListItem(dat.GetDataDV("SELECT * FROM "+ "Users WHERE User_ID="+row["UserID"].ToString())[0]["UserName"].ToString(), row["UserID"].ToString()))) doIt = true; } if (doIt) { if (dat.GetDataDV("SELECT * FROM GroupEvent_Members WHERE UserID=" + row["UserID"].ToString() + " AND GroupEventID=" + theID + " AND ReoccurrID=" + row["ReoccurrID"].ToString()).Count == 0) { dat.Execute("INSERT INTO GroupEvent_Members (UserID, GroupEventID, Accepted, ReoccurrID, DateAdded) " + "VALUES(" + row["UserID"].ToString() + ", " + theID + ", 'True', " + row["ReoccurrID"].ToString() + ", CONVERT(DATETIME, '" + row["DateAdded"].ToString() + "'))"); } } } } } DataView dvPrevMembers = dat.GetDataDV("SELECT * FROM GroupEvent_Members WHERE GroupEventID=" + theID); if (dvPrevMembers.Count > 0 && ParticipantsList.SelectedValue == "1") { foreach (DataRowView row in dvUserGroupCalendar) { if (dat.GetDataDV("SELECT * FROM User_GroupEvent_Calendar WHERE UserID=" + row["UserID"].ToString() + " AND GroupEventID=" + theID + " AND ReoccurrID=" + row["ReoccurrID"].ToString()).Count == 0) { dat.Execute("INSERT INTO User_GroupEvent_Calendar (UserID, GroupEventID, ReoccurrID, DateAdded) " + "VALUES(" + row["UserID"].ToString() + ", " + theID + ", " + row["ReoccurrID"].ToString() + ", CONVERT(DATETIME, '" + row["DateAdded"].ToString() + "'))"); } } } DataView dvAllOccurances = dat.GetDataDV("SELECT * FROM GroupEvent_Occurance WHERE GroupEventID=" + theID); string keepthese = ""; if (ParticipantsList.SelectedValue == "3") { foreach (ListItem item in GroupMembersSelectedListBox.Items) { //execute update/insert member foreach (DataRowView row in dvAllOccurances) { if (isUpdate) { dvPrevMembers.RowFilter = "UserID=" + item.Value + " AND ReoccurrID=" + row["ID"].ToString(); if (dvPrevMembers.Count == 0) { command = "INSERT INTO GroupEvent_Members (GroupEventID, UserID, ReoccurrID) VALUES(" + theID + ", " + item.Value + ", " + row["ID"].ToString() + ")"; dat.Execute(command); keepthese += " AND NOT(UserID = " + item.Value + " AND ReoccurrID=" + row["ID"].ToString() + ") "; DataView dvUser = dat.GetDataDV("SELECT * FROM Users WHERE User_ID=" + item.Value); if (item.Value != Session["User"].ToString()) { dat.Execute("INSERT INTO UserMessages (MessageContent, MessageSubject, From_UserID, To_UserID, " + "[Date], [Read], [Mode], [Live]) VALUES('" + messageBody.Replace("'", "''") + "', '" + emailSubject.Replace("'", "''") + "', " + dat.HIPPOHAPP_USERID.ToString() + ", " + item.Value + ", '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString() + "', 'False', 9, 'True')"); dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(), System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), dvUser[0]["Email"].ToString(), emailBody, emailSubject); } } else { keepthese += " AND NOT(UserID = " + item.Value + " AND ReoccurrID=" + row["ID"].ToString() + ")"; } } else { command = "INSERT INTO GroupEvent_Members (GroupEventID, UserID, ReoccurrID) VALUES(" + theID + ", " + item.Value + ", " + row["ID"].ToString() + ")"; dat.Execute(command); DataView dvUser = dat.GetDataDV("SELECT * FROM Users WHERE User_ID=" + item.Value); if (item.Value != Session["User"].ToString()) { dat.Execute("INSERT INTO UserMessages (MessageContent, MessageSubject, From_UserID, To_UserID, " + "[Date], [Read], [Mode], [Live]) VALUES('" + messageBody.Replace("'", "''") + "', '" + emailSubject.Replace("'", "''") + "', " + dat.HIPPOHAPP_USERID.ToString() + ", " + item.Value + ", '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString() + "', 'False', 9, 'True')"); dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(), System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), dvUser[0]["Email"].ToString(), emailBody, emailSubject); } } } } if (isUpdate) { dat.Execute("DELETE FROM GroupEvent_Members WHERE GroupEventID=" + theID + keepthese); } } else if (ParticipantsList.SelectedValue == "2") { foreach (DataRowView item in dvMems) { //execute update/insert member foreach (DataRowView row in dvAllOccurances) { if (isUpdate) { dvPrevMembers.RowFilter = "UserID=" + item["MemberID"] + " AND ReoccurrID=" + row["ID"].ToString(); if (dvPrevMembers.Count == 0) { command = "INSERT INTO GroupEvent_Members (GroupEventID, UserID, ReoccurrID) VALUES(" + theID + ", " + item["MemberID"] + ", " + row["ID"].ToString() + ")"; dat.Execute(command); keepthese += " AND NOT(UserID = " + item["MemberID"] + " AND ReoccurrID=" + row["ID"].ToString() + ") "; DataView dvUser = dat.GetDataDV("SELECT * FROM Users WHERE User_ID=" + item["MemberID"]); if (item["MemberID"] != Session["User"].ToString()) { dat.Execute("INSERT INTO UserMessages (MessageContent, MessageSubject, From_UserID, To_UserID, " + "[Date], [Read], [Mode], [Live]) VALUES('" + messageBody.Replace("'", "''") + "', '" + emailSubject.Replace("'", "''") + "', " + dat.HIPPOHAPP_USERID.ToString() + ", " + item["MemberID"] + ", '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString() + "', 'False', 9, 'True')"); dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(), System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), dvUser[0]["Email"].ToString(), emailBody, emailSubject); } } else { keepthese += " AND NOT(UserID = " + item["MemberID"] + " AND ReoccurrID=" + row["ID"].ToString() + ")"; } } else { command = "INSERT INTO GroupEvent_Members (GroupEventID, UserID, ReoccurrID) VALUES(" + theID + ", " + item["MemberID"] + ", " + row["ID"].ToString() + ")"; dat.Execute(command); DataView dvUser = dat.GetDataDV("SELECT * FROM Users WHERE User_ID=" + item["MemberID"]); if (item["MemberID"] != Session["User"].ToString()) { dat.Execute("INSERT INTO UserMessages (MessageContent, MessageSubject, From_UserID, To_UserID, " + "[Date], [Read], [Mode], [Live]) VALUES('" + messageBody.Replace("'", "''") + "', '" + emailSubject.Replace("'", "''") + "', " + dat.HIPPOHAPP_USERID.ToString() + ", " + item["MemberID"] + ", '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString() + "', 'False', 9, 'True')"); dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(), System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), dvUser[0]["Email"].ToString(), emailBody, emailSubject); } } } } if (isUpdate) { dat.Execute("DELETE FROM GroupEvent_Members WHERE GroupEventID=" + theID + keepthese); } } } catch (Exception ex) { MessagePanel.Visible = true; YourMessagesLabel.Text = ex.ToString() + "<br/>command: " + command; } } }
protected void SendGroupEventNotifications(string eventID, string IDofFirstOccurance) { string theID = Request.QueryString["GroupID"].ToString(); HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); DataView dvUsers = dat.GetDataDV("SELECT * FROM Group_Members GM, Users U WHERE GM.MemberID=" + "U.User_ID AND GM.GroupID=" + theID + " AND Prefs LIKE '%2%'"); DataView dvGroup = dat.GetDataDV("SELECT * FROM Groups WHERE ID=" + theID); DataView dvThread = dat.GetDataDV("SELECT * FROM GroupEvents WHERE ID=" + eventID); string email = "A new event '" + dvThread[0]["Name"].ToString() + "' has been posted for the group '" + dvGroup[0]["Header"].ToString() + "'. <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(dvThread[0]["Name"].ToString()) + "_" + IDofFirstOccurance + "_" + eventID + "_GroupEvent\">Check it out.</a>"; foreach (DataRowView row in dvUsers) { dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(), System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), row["Email"].ToString(), email, "A new group event has been posted"); } }
protected void PostIt(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; if (AgreeCheckBox.Checked) { Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString()); conn.Open(); string command = ""; try { bool isUpdate = false; bool isCopy = false; DataSet dsVenue = new DataSet(); if (Request.QueryString["ID"] != null) { if (Request.QueryString["copy"] != null) { if (!bool.Parse(Request.QueryString["copy"].ToString())) { dsVenue = dat.GetData("SELECT * FROM GroupEvents WHERE ID=" + Request.QueryString["ID"].ToString()); isUpdate = true; } else { isCopy = true; } } else { dsVenue = dat.GetData("SELECT * FROM GroupEvents WHERE ID=" + Request.QueryString["ID"].ToString()); isUpdate = true; } } bool cont = true; if (cont) { if (isUpdate) { command = "UPDATE GroupEvents SET StuffNeededCheckable=@checkable, ColorA=@cA, ColorB=@cB, TextA=@tA, TextB=@tB, LastEdit=GETDATE(), LastEditBy=" + Session["User"].ToString() + ", Name=@name, [Content]=@content, Agenda=@agenda, " + " EventType=@eType, RegType=@rType, RegNum=@rNum, RegDeadline=@rDeadline WHERE ID=" + Request.QueryString["ID"].ToString(); } else command = "INSERT INTO GroupEvents (StuffNeededCheckable, ColorA, ColorB, TextA, TextB, PostedOn, LastEdit, LastEditBy, UserID, GroupID, Name, [Content], " + " Agenda, EventType, RegType, RegNum, RegDeadline) VALUES(@checkable, @cA, @cB, @tA, @tB, GETDATE(), GETDATE()," + Session["User"].ToString() + ", " + Session["User"].ToString() + ", " + Request.QueryString["GroupID"].ToString() + ", @name, @content, @agenda, @eType, " + " @rType, @rNum, @rDeadline)"; SqlCommand cmd = new SqlCommand(command, conn); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@checkable", SqlDbType.Bit).Value = StuffCheckableCheckBox.Checked; if (ColorSchemeRadioList.SelectedValue == "0") { cmd.Parameters.Add("@cA", SqlDbType.NVarChar).Value = "568301"; cmd.Parameters.Add("@cB", SqlDbType.NVarChar).Value = "1fb6e7"; } else { cmd.Parameters.Add("@cA", SqlDbType.NVarChar).Value = ColorTd1.BgColor.Replace("#", ""); cmd.Parameters.Add("@cB", SqlDbType.NVarChar).Value = ColorTd2.BgColor.Replace("#", ""); } if (ColorTextRadioList.SelectedValue == "0") { cmd.Parameters.Add("@tA", SqlDbType.NVarChar).Value = "ffffff"; cmd.Parameters.Add("@tB", SqlDbType.NVarChar).Value = "ffffff"; } else { cmd.Parameters.Add("@tA", SqlDbType.NVarChar).Value = System.Drawing.ColorTranslator.ToHtml(Text1Label.ForeColor).Replace("#", ""); cmd.Parameters.Add("@tB", SqlDbType.NVarChar).Value = System.Drawing.ColorTranslator.ToHtml(Text2Label.ForeColor).Replace("#", ""); } cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = VenueNameTextBox.THE_TEXT.Trim(); cmd.Parameters.Add("@content", SqlDbType.NVarChar).Value = DescriptionTextBox.Content.Trim(); if (AgendaCheckBox.Checked) cmd.Parameters.Add("@agenda", SqlDbType.NVarChar).Value = AgendaLiteral.Text; else cmd.Parameters.Add("@agenda", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@eType", SqlDbType.Int).Value = ParticipantsList.SelectedValue; cmd.Parameters.Add("@rType", SqlDbType.Int).Value = RagistrationRadioList.SelectedValue; if (RagistrationRadioList.SelectedValue == "1") { cmd.Parameters.Add("@rNum", SqlDbType.Int).Value = DBNull.Value; cmd.Parameters.Add("@rDeadline", SqlDbType.DateTime).Value = DBNull.Value; } else { if (NumRegTextBox.Text.Trim() != "") cmd.Parameters.Add("@rNum", SqlDbType.Int).Value = NumRegTextBox.Text.Trim(); else cmd.Parameters.Add("@rNum", SqlDbType.Int).Value = DBNull.Value; if (DeadlineDatePicker.SelectedDate == null) cmd.Parameters.Add("@rDeadline", SqlDbType.DateTime).Value = DBNull.Value; else cmd.Parameters.Add("@rDeadline", SqlDbType.DateTime).Value = DeadlineDatePicker.SelectedDate.Value; } cmd.ExecuteNonQuery(); string IDofFirstOccurance = ""; string eventID = ""; if (isUpdate) { eventID = Request.QueryString["ID"].ToString(); IDofFirstOccurance = Request.QueryString["O"].ToString(); } else { cmd = new SqlCommand("SELECT @@IDENTITY AS IDS", conn); SqlDataAdapter da2 = new SqlDataAdapter(cmd); DataSet ds3 = new DataSet(); da2.Fill(ds3); eventID = ds3.Tables[0].Rows[0]["IDS"].ToString(); } #region Take care of Venue and Occurance string state = ""; string zip = ""; string city = ""; string country = ""; string address = ""; string apt = ""; string aptNo = ""; string aptName = ""; string location = ""; string streetNo = ""; string streetName = ""; string streetDrop = ""; DataView dvRealVenue; char[] delim = { ';' }; string[] delimStr = { "--" }; string[] tokens3; string[] tokens2; int venueID = 0; bool isVenue = false; string startDate = ""; string endDate = ""; foreach (ListItem item in DateSelectionsListBox.Items) { isVenue = false; tokens3 = item.Text.Split(delimStr, StringSplitOptions.RemoveEmptyEntries); startDate = tokens3[0].Trim(); endDate = tokens3[1].Trim(); tokens2 = item.Value.Split(delim); if (tokens3[2].Trim() != "Private Location") { isVenue = true; venueID = int.Parse(item.Value); } if (!isVenue) { state = tokens2[1]; city = tokens2[0]; zip = tokens2[2]; location = tokens2[3]; apt = tokens2[4]; country = tokens2[5]; if(apt.Trim() != ""){ char [] tempdelimer = {' '}; string [] apttoks = apt.Split(tempdelimer); aptName = apttoks[0]; aptNo = apttoks[1]; } if (country == "223") { char[] tempDelim = { '%' }; string[] streettoks = location.Split(tempDelim); streetNo = streettoks[0]; streetName = streettoks[1]; streetDrop = streettoks[2]; } } else { dvRealVenue = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + item.Value); state = dvRealVenue[0]["State"].ToString(); zip = dvRealVenue[0]["Zip"].ToString(); city = dvRealVenue[0]["City"].ToString(); country = dvRealVenue[0]["Country"].ToString(); } if (isUpdate) { DataView dvSelect = dat.GetDataDV("SELECT * FROM GroupEvent_Occurance WHERE GroupEventID=" + eventID + " AND DateTimeStart = CONVERT(DATETIME,'" + startDate + "')"); if (dvSelect.Count == 0) { command = "INSERT INTO GroupEvent_Occurance (GroupEventID, DateTimeStart, DateTimeEnd, " + "State, City, Country, Zip, StreetNumber, StreetName, StreetDrop, AptName, AptNo, Location, VenueID) VALUES(" + eventID + ", @start, @end, @state, " + "@city, @country, @zip, @sNo, @sName, @sDrop, @aName, @aNo, @location, @venue)"; } else { command = "UPDATE GroupEvent_Occurance SET DateTimeEnd=@end, State=@state, " + "City=@city, Country=@country, Zip=@zip, StreetNumber=@sNo, StreetName=@sName, " + "StreetDrop=@sDrop, AptName=@aName, AptNo=@aNo, Location=@location, VenueID=@venue " + " WHERE ID=" + dvSelect[0]["ID"].ToString(); } } else { command = "INSERT INTO GroupEvent_Occurance (GroupEventID, DateTimeStart, DateTimeEnd, " + "State, City, Country, Zip, StreetNumber, StreetName, StreetDrop, AptName, AptNo, Location, VenueID) VALUES(" + eventID + ", @start, @end, @state, " + "@city, @country, @zip, @sNo, @sName, @sDrop, @aName, @aNo, @location, @venue)"; } cmd = new SqlCommand(command, conn); command += "venueID: '" + venueID.ToString() + "', country: " + country + ", address: " + address; if (!isVenue) cmd.Parameters.Add("@venue", SqlDbType.Int).Value = DBNull.Value; else cmd.Parameters.Add("@venue", SqlDbType.Int).Value = venueID; cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = startDate; cmd.Parameters.Add("@end", SqlDbType.DateTime).Value = endDate; cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = zip; cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = city; cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = state; if (isVenue) { cmd.Parameters.Add("@sNo", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@sName", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@sDrop", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@aName", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@aNo", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@location", SqlDbType.NVarChar).Value = DBNull.Value; } else { if (country == "223") { cmd.Parameters.Add("@sNo", SqlDbType.NVarChar).Value = streetNo; cmd.Parameters.Add("@sName", SqlDbType.NVarChar).Value = streetName; cmd.Parameters.Add("@sDrop", SqlDbType.NVarChar).Value = streetDrop; cmd.Parameters.Add("@aName", SqlDbType.NVarChar).Value = aptName; cmd.Parameters.Add("@aNo", SqlDbType.NVarChar).Value = aptNo; cmd.Parameters.Add("@location", SqlDbType.NVarChar).Value = DBNull.Value; } else { cmd.Parameters.Add("@sNo", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@sName", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@sDrop", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@location", SqlDbType.NVarChar).Value = location; cmd.Parameters.Add("@aName", SqlDbType.NVarChar).Value = aptName; cmd.Parameters.Add("@aNo", SqlDbType.NVarChar).Value = aptNo; } } cmd.Parameters.Add("@country", SqlDbType.Int).Value = country; cmd.ExecuteNonQuery(); if (IDofFirstOccurance == "") { cmd = new SqlCommand("SELECT @@IDENTITY AS AAS", conn); DataSet dsTemp = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dsTemp); IDofFirstOccurance = dsTemp.Tables[0].Rows[0]["AAS"].ToString(); } } #endregion #region Take care of slider bool isSlider = false; if (PictureCheckList.Items.Count > 0) isSlider = true; if (isSlider) { char[] delim2 = { '\\' }; string[] fileArray = System.IO.Directory.GetFiles(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\Slider\\"); if (!System.IO.Directory.Exists(MapPath(".") + "\\GroupEventFiles")) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\GroupEventFiles\\"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\GroupEventFiles\\" + eventID + "\\"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\GroupEventFiles\\" + eventID + "\\Slider\\"); } else { if (!System.IO.Directory.Exists(MapPath(".") + "\\GroupEventFiles\\" + eventID)) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\GroupEventFiles\\" + eventID + "\\"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\GroupEventFiles\\" + eventID + "\\Slider\\"); } else { if (!!System.IO.Directory.Exists(MapPath(".") + "\\GroupEventFiles\\" + eventID + "\\Slider\\")) System.IO.Directory.CreateDirectory(MapPath(".") + "\\GroupEventFiles\\" + eventID + "\\Slider\\"); } } char[] delim3 = { '.' }; char[] delim4 = { '-' }; string realName = ""; string origName = ""; string caption = ""; dat.Execute("DELETE FROM GroupEvent_Slider_Mapping WHERE GroupEventID=" + eventID.ToString()); for (int i = 0; i < PictureCheckList.Items.Count; i++) { caption = ""; string[] tokensN = PictureCheckList.Items[i].Value.Split(delim4); if (tokensN.Length > 1) { realName = tokensN[0].Trim(); caption = PictureCheckList.Items[i].Value.Replace(tokensN[0].Trim() + " - ", ""); } else { realName = tokensN[0].Trim(); } tokensN = PictureCheckList.Items[i].Text.Split(delim4); origName = tokensN[0].Trim(); string[] tokens = realName.Split(delim3); if (tokens.Length >= 2) { if (tokens[1].ToUpper() == "JPG" || tokens[1].ToUpper() == "JPEG" || tokens[1].ToUpper() == "GIF" || tokens[1].ToUpper() == "PNG") { if (!System.IO.File.Exists(MapPath(".") + "\\GroupEventFiles\\" + eventID.ToString() + "\\Slider\\" + realName)) { System.IO.File.Copy(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\Slider\\" + realName, MapPath(".") + "\\GroupEventFiles\\" + eventID.ToString() + "\\Slider\\" + realName); } cmd = new SqlCommand("INSERT INTO GroupEvent_Slider_Mapping (GroupEventID, PictureName, RealPictureName, Caption) " + "VALUES (@eventID, @picName, @realName, @cap)", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = eventID; cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = realName; cmd.Parameters.Add("@realName", SqlDbType.NVarChar).Value = origName; cmd.Parameters.Add("@cap", SqlDbType.NVarChar).Value = caption; cmd.ExecuteNonQuery(); } } else { cmd = new SqlCommand("INSERT INTO GroupEvent_Slider_Mapping (isYouTube,GroupEventID, PictureName, RealPictureName, Caption) " + "VALUES ('True',@eventID, @picName, @realName, @cap)", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = eventID; cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = realName.Replace("YouTube ID: ", ""); cmd.Parameters.Add("@realName", SqlDbType.NVarChar).Value = realName.Replace("YouTube ID: ", ""); cmd.Parameters.Add("@cap", SqlDbType.NVarChar).Value = caption; cmd.ExecuteNonQuery(); } } } #endregion #region Take care of 'Stuff we Need' int order = 0; DataView dvStuff; bool doInsert = false; string keepthese = ""; if (StuffCheckBox.Checked) { foreach (ListItem item in StuffNeededListBox.Items) { if (isUpdate) { dvStuff = dat.GetDataDV("SELECT * FROM GroupEvent_StuffNeeded WHERE GroupEventID=" + eventID + " AND StuffNeeded='" + item.Text.Replace("'", "''") + "'"); if (dvStuff.Count == 0) { doInsert = true; } else { cmd = new SqlCommand("UPDATE GroupEvent_StuffNeeded SET OrderID=@order WHERE GroupEventID=" + eventID + " AND StuffNeeded='" + item.Text.Replace("'", "''") + "'", conn); cmd.Parameters.Add("@order", SqlDbType.Int).Value = order++; cmd.ExecuteNonQuery(); keepthese += " AND ID <> " + dvStuff[0]["ID"].ToString(); } } else { doInsert = true; } if (doInsert) { cmd = new SqlCommand("INSERT INTO GroupEvent_StuffNeeded (GroupEventID, StuffNeeded, " + "UserID, OrderID) VALUES(" + eventID + ", @stuff, @UserID, @order)", conn); cmd.Parameters.Add("@stuff", SqlDbType.NVarChar).Value = item.Text; cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = DBNull.Value; cmd.Parameters.Add("@order", SqlDbType.Int).Value = order++; cmd.ExecuteNonQuery(); cmd = new SqlCommand("SELECT @@IDENTITY AS AID", conn); DataSet dsN = new DataSet(); SqlDataAdapter d1 = new SqlDataAdapter(cmd); d1.Fill(dsN); keepthese += " AND ID <> " + dsN.Tables[0].Rows[0]["AID"].ToString(); } } } dat.Execute("DELETE FROM GroupEvent_StuffNeeded WHERE GroupEventID=" + eventID + keepthese); #endregion CreateMembers(eventID, isUpdate, IDofFirstOccurance); CreateGroupings(eventID, isUpdate); CreateCategories(eventID, isUpdate); //Send the informational email to the user DataSet dsUser = dat.GetData("SELECT Email, UserName FROM USERS WHERE User_ID=" + Session["User"].ToString()); string emailBody = "<br/><br/>Dear " + dsUser.Tables[0].Rows[0]["UserName"].ToString() + ", <br/><br/> you have successfully posted the group event \"" + VenueNameTextBox.THE_TEXT + "\". <br/><br/> You can find this group event <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + IDofFirstOccurance + "_" + eventID + "_GroupEvent\">here</a>. " + "<br/><br/> To rate your experience posting this group event <a href=\"http://hippohappenings.com/RateExperience.aspx?Edit=" + isUpdate.ToString() + "&Type=GE&ID=" + eventID + "\">please include your feedback here.</a>" + "<br/><br/><br/>Have a Hippo Happening Day!<br/><br/>"; try { if (isUpdate) { if (!Request.Url.AbsoluteUri.Contains("localhost")) { dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(), System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "You have updated group event: " + VenueNameTextBox.THE_TEXT); } } else { if (!Request.Url.AbsoluteUri.Contains("localhost")) { dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(), System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "You have posted the event: " + VenueNameTextBox.THE_TEXT); SendGroupEventNotifications(eventID, IDofFirstOccurance); } } } catch (Exception ex) { } conn.Close(); //pop up the message to the user Encryption encrypt = new Encryption(); if (!isUpdate) { Session["Message"] = "Your group event has been posted successfully! An email with this info will also be sent to your account.<br/>" + "<br/>Check out <a class=\"AddLink\" onclick=\"Search('" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + IDofFirstOccurance + "_" + eventID + "_GroupEvent');\">this group event's</a> home page.<br/><br/><br/> " + "-<a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Edit=" + isUpdate.ToString() + "&Type=GE&ID=" + eventID + "');\" >Rate </a>your user experience posting this group event.<br/>"; } else { Session["Message"] = "You have successfully updated group event: \"" + VenueNameTextBox.THE_TEXT.Trim() + "\".<br/><br/>Check out <a class=\"AddLink\" onclick=\"Search('" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + Request.QueryString["O"].ToString() + "_" + eventID + "_GroupEvent');\">this group event's</a> home page.<br/><br/> <a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Edit=" + isUpdate.ToString() + "&Type=GE&ID=" + eventID + "');\" >Rate </a>your user experience editing this group event.<br/>"; } MessageRadWindow.NavigateUrl = "Message.aspx?message=" + encrypt.encrypt(Session["Message"].ToString() + "<br/><img onclick=\"Search('home');\" onmouseover=\"this.src='image/DoneSonButtonSelected.png'\" onmouseout=\"this.src='image/DoneSonButton.png'\" src=\"image/DoneSonButton.png\"/>"); MessageRadWindow.Visible = true; MessageRadWindow.VisibleOnPageLoad = true; } } catch (Exception ex) { MessagePanel.Visible = true; YourMessagesLabel.Text += ex.ToString() + command; } } else { MessagePanel.Visible = true; YourMessagesLabel.Text += "<br/><br/>You must agree to the terms and conditions."; } }
protected void Page_Load(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; bool isCl = false; if (Request.QueryString["cl"] != null) if (bool.Parse(Request.QueryString["cl"])) { isCl = true; } string command = ""; try { if (cookie != null) { HtmlMeta hm = new HtmlMeta(); HtmlHead head = (HtmlHead)Page.Header; hm.Name = "ROBOTS"; hm.Content = "NOINDEX, FOLLOW"; head.Controls.AddAt(0, hm); HtmlLink lk = new HtmlLink(); lk.Attributes.Add("rel", "canonical"); lk.Href = "http://hippohappenings.com/MessageAlert.aspx"; head.Controls.AddAt(0, lk); MessageLabel2.Text = ""; SendItButton.SERVER_CLICK += ServerSendMessage; if (!IsPostBack) { Session["ButtonClicked"] = null; Session["CheckUsers"] = null; Session["AllFriends"] = null; Session.Remove("ButtonClicked"); Session.Remove("CheckUsers"); Session.Remove("AllFriends"); } Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); if (Session["User"] != null) { TechLiteral.Text = ""; DataSet dsFriends = dat.GetData("SELECT * FROM User_Friends UF, Users U WHERE UF.FriendID=U.User_ID AND UF.UserID=" + Session["User"].ToString()); bool getFriendsMessage = false; if (dsFriends.Tables.Count > 0) if (dsFriends.Tables[0].Rows.Count > 0) { Session["AllFriends"] = ""; ImageButton theImage; string eventID = ""; string type = ""; if (isCl) { type = "cl"; eventID = Request.QueryString["EID"]; } else { if (Request.QueryString["ID"] == null) { if (Request.QueryString["EID"] == null) { type = "a"; eventID = Request.QueryString["AID"]; } else { type = "e"; eventID = Request.QueryString["EID"]; } } else { type = Request.QueryString["A"].ToString(); eventID = Request.QueryString["ID"].ToString(); } } for (int i = 0; i < dsFriends.Tables[0].Rows.Count; i++) { theImage = new ImageButton(); theImage.Width = 50; theImage.Height = 50; theImage.Style.Add("padding", "5px"); theImage.AlternateText = dsFriends.Tables[0].Rows[i]["UserName"].ToString(); theImage.ToolTip = dsFriends.Tables[0].Rows[i]["UserName"].ToString(); theImage.Click += new ImageClickEventHandler(AddFriendPanel); theImage.CommandArgument = dsFriends.Tables[0].Rows[i]["UserName"].ToString(); Session["AllFriends"] += dsFriends.Tables[0].Rows[i]["UserName"].ToString() + ";"; if (System.IO.File.Exists(Server.MapPath(".") + "\\UserFiles\\" + dsFriends.Tables[0].Rows[i]["UserName"].ToString() + "\\Profile\\" + dsFriends.Tables[0].Rows[i]["ProfilePicture"].ToString())) { theImage.ImageUrl += "UserFiles/" + dsFriends.Tables[0].Rows[i]["UserName"].ToString() + "/Profile/" + dsFriends.Tables[0].Rows[i]["ProfilePicture"].ToString(); } else { theImage.ImageUrl = "~/NewImages/noAvatar_50x50_small.png"; theImage.Attributes.Add("onmouseover", "this.src='NewImages/noAvatar_50x50_smallhover.png'"); theImage.Attributes.Add("onmouseout", "this.src='NewImages/noAvatar_50x50_small.png'"); } FriendsPanel.Controls.Add(theImage); } DataSet dsUser = dat.GetData("SELECT * FROM Users WHERE User_ID=" + Session["User"].ToString()); DataSet dsEvent = new DataSet(); if (type == "a") { dsEvent = dat.GetData("SELECT * FROM Ads WHERE Ad_ID=" + eventID); Session["MessageBody"] = "<label>Ad: <a class=\"AddLink\" href=\"http://hippohappenings.com/" + dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Header"].ToString()) + "_" + eventID + "_Ad\">" + dsEvent.Tables[0].Rows[0]["Header"].ToString() + "</a>" + " \nDescription: " + dsEvent.Tables[0].Rows[0]["Description"].ToString() + "</label>"; Session["EventName"] = dsEvent.Tables[0].Rows[0]["Header"].ToString(); } else if (type == "cl") { string desc = Session["ClDescription"].ToString(); if (desc.Length > 100) desc = desc.Substring(0, 100) + "..."; Session["MessageBody"] = "<label>Event: <a class=\"AddLink\" href=\"http://hippohappenings.com/" + dat.MakeNiceName(Session["ClHeader"].ToString()) + "_CLHH" + eventID.Replace("/", "_") + "_ClEvent\">" + Session["ClHeader"].ToString() + "</a>" + " \nDescription: " + desc + "</label>"; Session["EventName"] = Session["ClHeader"].ToString(); } else if (type == "e") { dsEvent = dat.GetData("SELECT * FROM Events E, Event_Occurance EO, " + "Venues V WHERE E.ID=EO.EventID AND E.Venue=V.ID AND E.ID=" + eventID); Session["MessageBody"] = "<label>Event: <a class=\"AddLink\" href=\"http://hippohappenings.com/" + dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Header"].ToString()) + "_" + eventID + "_Event\">" + dsEvent.Tables[0].Rows[0]["Header"].ToString() + "</a>" + " \nVenue: " + dsEvent.Tables[0].Rows[0]["Name"].ToString() + " \nDate: " + dsEvent.Tables[0].Rows[0]["DateTimeStart"].ToString() + " \nDescription: " + dsEvent.Tables[0].Rows[0]["Content"].ToString() + "</label>"; Session["EventName"] = dsEvent.Tables[0].Rows[0]["Header"].ToString(); } else if (type == "ge") { string reocurr = Request.QueryString["O"].ToString(); command = "SELECT * FROM GroupEvents GE, GroupEvent_Occurance GO WHERE GE.ID=" + eventID + " AND GE.ID=GO.GroupEventID"; dsEvent = dat.GetData(command); Session["MessageBody"] = "<label>Group Event: <a class=\"AddLink\" " + "href=\"http://hippohappenings.com/" + dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Name"].ToString()) + "_" + reocurr + "_" + eventID + "_GroupEvent\">" + dsEvent.Tables[0].Rows[0]["Name"].ToString() + "</a>" + " \nDate: " + dsEvent.Tables[0].Rows[0]["DateTimeStart"].ToString() + " \nDescription: " + dsEvent.Tables[0].Rows[0]["Content"].ToString() + "</label>"; Session["EventName"] = dsEvent.Tables[0].Rows[0]["Name"].ToString(); } else if (type == "g") { command = "SELECT * FROM Groups WHERE ID=" + eventID; dsEvent = dat.GetData(command); Session["MessageBody"] = "<label>Group: <a class=\"AddLink\" href=\"http://hippohappenings.com/" + dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Header"].ToString()) + "_" + eventID + "_Group\">" + dsEvent.Tables[0].Rows[0]["Header"].ToString() + "</a>" + " \nDescription: " + dsEvent.Tables[0].Rows[0]["Content"].ToString() + "</label>"; Session["EventName"] = dsEvent.Tables[0].Rows[0]["Header"].ToString(); } else if (type == "t") { command = "SELECT * FROM Trips WHERE ID=" + eventID; dsEvent = dat.GetData(command); Session["MessageBody"] = "<label>Trip: <a class=\"AddLink\" href=\"http://hippohappenings.com/" + dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Header"].ToString()) + "_" + eventID + "_Trip\">" + dsEvent.Tables[0].Rows[0]["Header"].ToString() + "</a>" + " \nDescription: " + dsEvent.Tables[0].Rows[0]["Content"].ToString() + "</label>"; Session["EventName"] = dsEvent.Tables[0].Rows[0]["Header"].ToString(); } else { dsEvent = dat.GetData("SELECT * FROM Venues WHERE ID=" + eventID); Session["MessageBody"] = "<label>Venue: <a class=\"AddLink\" href=\"http://hippohappenings.com/" + dat.MakeNiceName(dsEvent.Tables[0].Rows[0]["Name"].ToString()) + "_" + eventID + "_Venue\">" + dsEvent.Tables[0].Rows[0]["Name"].ToString() + "</a>" + " \nDescription: " + dsEvent.Tables[0].Rows[0]["Content"].ToString() + "</label>"; Session["EventName"] = dsEvent.Tables[0].Rows[0]["Name"].ToString(); } } else getFriendsMessage = true; else getFriendsMessage = true; if (getFriendsMessage) { Literal FriendLiteral = new Literal(); FriendLiteral.Text = "You do not have any friends listed. To add friends visit 'My Account'. To send information of this event to an email account please visit this event's page."; FriendsPanel.Controls.Add(FriendLiteral); } CreateCheckUser(); } else { TechLiteral.Text = "<script type=\"text/javascript\">Search('login');</script>"; } } else { TechLiteral.Text = "<script type=\"text/javascript\">Search('login');</script>"; } } catch (Exception ex) { MessageLabel.Text += ex.ToString() + "<br/>" + command; } }
protected void Page_Load(object sender, EventArgs e) { DayOfWeek theWeekDay = DayOfWeek.Friday; switch (theDay) { case days.Sun: theWeekDay = DayOfWeek.Sunday; break; case days.Mon: theWeekDay = DayOfWeek.Monday; break; case days.Tues: theWeekDay = DayOfWeek.Tuesday; break; case days.Wed: theWeekDay = DayOfWeek.Wednesday; break; case days.Thurs: theWeekDay = DayOfWeek.Thursday; break; case days.Fri: theWeekDay = DayOfWeek.Friday; break; case days.Sat: theWeekDay = DayOfWeek.Saturday; break; } if (!IsPostBack) { string imageSrc = ""; string eventStr = ""; string thisDay = theDay.ToString(); HttpCookie cookie = Request.Cookies["BrowserDate"]; DateTime datNow = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")); Data dat = new Data(datNow); int thisDayCount = 0; DataView dvAll = dat.GetDataDV("SELECT DISTINCT EO.DateTimeStart AS TheDate, EO.EventID AS ID, E.Header FROM Events E, User_Calendar UC, Event_Occurance EO WHERE " + "UC.EventID=EO.EventID AND EO.EventID=E.ID AND UC.UserID=" + Session["User"].ToString()); int subtraction = 0; switch (datNow.DayOfWeek) { case DayOfWeek.Friday: subtraction = 5; break; case DayOfWeek.Monday: subtraction = 1; break; case DayOfWeek.Saturday: subtraction = 6; break; case DayOfWeek.Sunday: subtraction = 0; break; case DayOfWeek.Thursday: subtraction = 4; break; case DayOfWeek.Tuesday: subtraction = 2; break; case DayOfWeek.Wednesday: subtraction = 3; break; default: break; } string toolTipText = ""; if (dvAll.Count > 0) { for (int i = 0; i < dvAll.Count; i++) { DateTime date2 = DateTime.Parse(dvAll[i]["TheDate"].ToString()); if (date2.DayOfWeek == theWeekDay) { if (dat.IsThisWeek(date2)) { thisDayCount++; toolTipText += "<div class=\"TextNormal\" style=\"clear: both;\"><a class=\"NavyLink12\" href=\"" + dat.MakeNiceName(dvAll[i]["Header"].ToString()) + "_" + dvAll[i]["ID"].ToString() + "_Event\">" + dvAll[i]["Header"].ToString() + "</a> at " + DateTime.Parse(dvAll[i]["TheDate"].ToString()).ToShortTimeString() + "</div>"; } } } } numberOfEvents = thisDayCount; switch (numberOfEvents) { case 0: imageSrc = "NewImages/GlanceCalendarOpen.png"; eventStr = "open"; break; default: imageSrc = "NewImages/GlanceCalendarOpen.png"; if (numberOfEvents == 1) eventStr = numberOfEvents + " event"; else eventStr = numberOfEvents + " events"; break; } if (datNow.DayOfWeek.ToString().Substring(0, 3) == theDay.ToString() || datNow.DayOfWeek.ToString().Substring(0, 4) == theDay.ToString() || datNow.DayOfWeek.ToString().Substring(0, 5) == theDay.ToString()) { thisDay = "Today"; imageSrc = "NewImages/GlanceCalendarOrange.png"; } string addStr = ""; if (toolTipText != "") addStr = " style=\"text-decoration: underline;cursor: pointer;\""; ImageLiteral.Text = "<div class=\"TextNormal\" id=\"theDay" + theDay.ToString() + "\" style=\"font-size: 10px;float:left;margin-right:5px;" + "width: 53px; height: 58px; background-image:url('" + imageSrc + "'); font-weight: bold;\"><div style=\"padding-left:2px;\"> " + thisDay + "</div><br/><div align=\"center\" " + addStr + ">" + eventStr + "</div></div>"; ImageLiteral.ID = "lit" + theDay.ToString(); if (toolTipText != "") { Telerik.Web.UI.RadToolTip tip = new Telerik.Web.UI.RadToolTip(); tip.Text = "<div style=\"padding: 10px;\">" + toolTipText + "</div>"; tip.Width = 200; tip.TargetControlID = "theDay" + theDay.ToString(); tip.IsClientID = true; tip.HideEvent = Telerik.Web.UI.ToolTipHideEvent.ManualClose; tip.Animation = Telerik.Web.UI.ToolTipAnimation.None; tip.Position = Telerik.Web.UI.ToolTipPosition.TopCenter; tip.ShowEvent = Telerik.Web.UI.ToolTipShowEvent.OnClick; tip.Skin = "Sunset"; ToolTipPanel.Controls.Add(tip); tip.RelativeTo = Telerik.Web.UI.ToolTipRelativeDisplay.Element; } } }
protected void Page_Load(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); if (searchNumber != "") { string markerNumber = dat.GetImageNum(searchNumber); //(int.Parse(dat.GetImageNum(searchNumber)) + numofallresults).ToString(); ImageLiteral.Text = imageLiteral + "<div style=\"float: left;\"><img style=\"cursor: pointer;\" onclick=\"myclick(" + markerNumber + ");\" src=" + "\"http://www.google.com/mapfiles/marker" + searchNumber + ".png\" /></div>"; //SearchLiteral.Text += "<script type=\"text/javascript\">var letter = String.fromCharCode(\"A\".charCodeAt(0) + " + // searchNumber + "); var letteredIcon = new GIcon(baseIcon); document.getElementById('image" + searchNumber + // "').src = \"http://www.google.com/mapfiles/marker\" + letter + \".png\";</script>"; BeginingLiteral.Text = "<div style=\";background-color:" + color + "; min-height: 33px; width: " + width.ToString() + "px; padding: 3px; margin-bottom: 3px;\">"; } else { BeginingLiteral.Text = "<div style=\"background-color:" + color + "; width: " + width.ToString() + "px; padding: 3px; margin-bottom: 3px;\">"; } SearchLabel.Text = searchLabel; //search = true is disabled here if (windowT) { SearchLabel.Attributes.Add("onclick", "CloseWindow('" + "../" + dat.MakeNiceName(searchLabel) + "_" + venueID + "_Venue" + "');"); } else { SearchLabel.NavigateUrl = "../" + dat.MakeNiceName(searchLabel) + "_" + venueID + "_Venue"; } string begining = "<div style=\"color: #b1a812; font-family: Arial; font-size: 11px;\">"; string end = "</div>"; TagsLiteral.Text = begining + city + ", " + state + end; dat.TAG_TYPE = Data.tagType.VENUE; string tags = dat.getTags(dat.GetData("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=" + venueID), false, windowT); TagsLiteral.Text += "<span style=\"color: #b1a812; line-height: 10px; font-size: 11px;\" >" + tags + "</span>"; }
protected void PostIt(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; if (AgreeCheckBox.Checked) { Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString()); conn.Open(); bool mediaChanged = false; bool contentChanged = false; string mediaCat = "0"; if (PictureCheckList.Items.Count > 0) mediaCat = "1"; bool isUpdate = false; bool isOwner = false; string ownerID = ""; DataSet dsVenue = new DataSet(); bool ownerUpForGrabs = false; if (Request.QueryString["ID"] != null) { dsVenue = dat.GetData("SELECT * FROM Venues WHERE ID=" + Request.QueryString["ID"].ToString()); isUpdate = true; ownerUpForGrabs = dat.IsOwnerUpForGrabs(Request.QueryString["ID"].ToString(), ref ownerID, ref isOwner, true); } string state = ""; if (StateDropDownPanel.Visible) state = StateDropDown.SelectedItem.Text; else state = StateTextBox.THE_TEXT; //We already do this in 'Onwards' method //SqlCommand cmd = new SqlCommand("SELECT * FROM Venues WHERE Name=@name AND City=@city AND State=@state ", conn); //cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = VenueNameTextBox.THE_TEXT; //cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = CityTextBox.Text; //cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = state; //DataSet ds = new DataSet(); //SqlDataAdapter da = new SqlDataAdapter(cmd); //da.Fill(ds); //bool cont = false; //if (ds.Tables.Count > 0) // if (ds.Tables[0].Rows.Count > 0 && !isUpdate) // { // MessagePanel.Visible = true; // YourMessagesLabel.Text += "<br/><br/>A venue under this name already exists in this City and State. To edit the details of this particular venue please contact Hippo Happenings " + "<a class=\"AddGreenLink\" href=\"ContactUs.aspx\">here</a>. Otherwise, please modify the name slightly."; // } // else // cont = true; //else // cont = true; bool cont = true; if (cont) { string command = ""; if (isUpdate) { if (isOwner || ownerUpForGrabs) command = "UPDATE Venues SET Name=@name, Owner=@owner, City=@city, Edit='False', Email=@email, Phone=@phone, State=@state, Country=@country, Zip=@zip, Address=@address, " + " EditedByUser=@user, Content=@content, Web=@web, mediaCategory=" + mediaCat + ", LastEditOn=@dateE WHERE ID=" + Request.QueryString["ID"].ToString(); else { command = "INSERT INTO VenueRevisions (Web, modifierID, VenueID, [Content], " + "City, State, Country, Zip, Name, Email, Phone, Address, DATE)" + " VALUES(@web, "+Session["User"].ToString()+"," + Request.QueryString["ID"].ToString() + ", @content, @city, @state, @country, @zip, "+ "@name, @email, @phone, @address, '"+DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))+"')"; } } else command = "INSERT INTO Venues (Web, Owner, City, State, Country, Zip, Edit, Name, Email, Phone, Address, CreatedByUser,Content, mediaCategory, Rating, PostedOn) " + "VALUES(@web, @owner, @city, @state, @country, @zip, 'False', @name, @email, @phone, @address, @user, @content, " + mediaCat + ", 0, @dateE)"; string locationStr = ""; string apt = ""; if (AptNumberTextBox.Text.Trim() != "") apt = AptDropDown.SelectedItem.Text + " " + AptNumberTextBox.Text.Trim().ToLower(); if (CountryDropDown.SelectedValue == "223") { locationStr = StreetNumberTextBox.Text.Trim().ToLower() + ";" + StreetNameTextBox.Text.Trim().ToLower() + ";" + StreetDropDown.SelectedItem.Text + ";" + apt; } else { locationStr = LocationTextBox.Text.Trim().ToLower() + ";" + apt; } SqlCommand cmd = new SqlCommand(command, conn); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@dateE", SqlDbType.DateTime).Value = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")); if (isUpdate && !isOwner) { if (ownerUpForGrabs) { if (OwnerCheckBox.Checked) cmd.Parameters.Add("@owner", SqlDbType.Int).Value = Session["User"].ToString(); else { if (ownerUpForGrabs) { cmd.Parameters.Add("@owner", SqlDbType.Int).Value = DBNull.Value; } } } else { } cmd.Parameters.Add("@user", SqlDbType.Int).Value = Session["User"].ToString(); if (dsVenue.Tables[0].Rows[0]["Name"].ToString() != VenueNameTextBox.THE_TEXT.Trim()) { cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = VenueNameTextBox.THE_TEXT.Trim(); contentChanged = true; } else { if (ownerUpForGrabs) { cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["Name"].ToString(); } else { cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = DBNull.Value; } } if (dsVenue.Tables[0].Rows[0]["Email"].ToString() != EmailTextBox.Text.Trim()) { if(EmailTextBox.Text.Trim() != "") cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = EmailTextBox.Text.Trim(); else cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = DBNull.Value; contentChanged = true; } else { if (ownerUpForGrabs) { cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["Email"].ToString(); } else { cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = DBNull.Value; } } if (dsVenue.Tables[0].Rows[0]["Phone"].ToString() != PhoneTextBox.Text.Trim()) { if (PhoneTextBox.Text.Trim() != "") cmd.Parameters.Add("@phone", SqlDbType.NVarChar).Value = PhoneTextBox.Text.Trim(); else cmd.Parameters.Add("@phone", SqlDbType.NVarChar).Value = DBNull.Value; contentChanged = true; } else { if (ownerUpForGrabs) { cmd.Parameters.Add("@phone", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["Phone"].ToString(); } else { cmd.Parameters.Add("@phone", SqlDbType.NVarChar).Value = DBNull.Value; } } if (dsVenue.Tables[0].Rows[0]["Web"].ToString() != WebSiteTextBox.Text.Trim()) { if (WebSiteTextBox.Text.Trim() != "") cmd.Parameters.Add("@web", SqlDbType.NVarChar).Value = WebSiteTextBox.Text.Trim(); else cmd.Parameters.Add("@web", SqlDbType.NVarChar).Value = DBNull.Value; contentChanged = true; } else { if (ownerUpForGrabs) { cmd.Parameters.Add("@web", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["Web"].ToString(); } else { cmd.Parameters.Add("@web", SqlDbType.NVarChar).Value = DBNull.Value; } } if (dsVenue.Tables[0].Rows[0]["Address"].ToString() != locationStr) { cmd.Parameters.Add("@address", SqlDbType.NVarChar).Value = locationStr; contentChanged = true; } else { if (ownerUpForGrabs) { cmd.Parameters.Add("@address", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["Address"].ToString(); } else { cmd.Parameters.Add("@address", SqlDbType.NVarChar).Value = DBNull.Value; } } if (dsVenue.Tables[0].Rows[0]["Content"].ToString() != DescriptionTextBox.Content.Trim()) { cmd.Parameters.Add("@content", SqlDbType.NVarChar).Value = DescriptionTextBox.Content; contentChanged = true; } else { if (ownerUpForGrabs) { cmd.Parameters.Add("@content", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["Content"].ToString(); } else { cmd.Parameters.Add("@content", SqlDbType.NVarChar).Value = DBNull.Value; } } if (dsVenue.Tables[0].Rows[0]["Country"].ToString() != CountryDropDown.SelectedValue) { cmd.Parameters.Add("@country", SqlDbType.Int).Value = int.Parse(CountryDropDown.SelectedValue); contentChanged = true; } else { if (ownerUpForGrabs) { cmd.Parameters.Add("@country", SqlDbType.Int).Value = dsVenue.Tables[0].Rows[0]["Country"].ToString(); } else { cmd.Parameters.Add("@country", SqlDbType.Int).Value = DBNull.Value; } } if (dsVenue.Tables[0].Rows[0]["Zip"].ToString() != ZipTextBox.Text.Trim()) { cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = ZipTextBox.Text.Trim(); contentChanged = true; } else { if (ownerUpForGrabs) { cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["Zip"].ToString(); } else { cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = DBNull.Value; } } if (dsVenue.Tables[0].Rows[0]["City"].ToString() != CityTextBox.Text.Trim()) { cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = CityTextBox.Text.Trim(); contentChanged = true; } else { if (ownerUpForGrabs) { cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["City"].ToString(); } else { cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = DBNull.Value; } } if (dsVenue.Tables[0].Rows[0]["State"].ToString() != state) { cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = state; contentChanged = true; } else { if (ownerUpForGrabs) { cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["State"].ToString(); } else { cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = DBNull.Value; } } } else { if (OwnerPanel.Visible) { if(OwnerCheckBox.Checked) cmd.Parameters.Add("@owner", SqlDbType.Int).Value = Session["User"].ToString(); else cmd.Parameters.Add("@owner", SqlDbType.Int).Value = DBNull.Value; } else { } cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = VenueNameTextBox.THE_TEXT.Trim(); if (EmailTextBox.Text != "") cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = EmailTextBox.Text.Trim(); else cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = DBNull.Value; if (PhoneTextBox.Text != "") cmd.Parameters.Add("@phone", SqlDbType.NVarChar).Value = PhoneTextBox.Text.Trim(); else cmd.Parameters.Add("@phone", SqlDbType.NVarChar).Value = DBNull.Value; if (WebSiteTextBox.Text != "") cmd.Parameters.Add("@web", SqlDbType.NVarChar).Value = WebSiteTextBox.Text.Trim(); else cmd.Parameters.Add("@web", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@address", SqlDbType.NVarChar).Value = locationStr; cmd.Parameters.Add("@user", SqlDbType.Int).Value = int.Parse(Session["User"].ToString()); cmd.Parameters.Add("@content", SqlDbType.NVarChar).Value = DescriptionTextBox.Content.Trim(); cmd.Parameters.Add("@country", SqlDbType.Int).Value = int.Parse(CountryDropDown.SelectedValue); cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = ZipTextBox.Text.Trim(); cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = CityTextBox.Text.Trim(); cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = state; } cmd.ExecuteNonQuery(); string ID = ""; string revisionID = "1"; if (isUpdate) { if (!isOwner) { ID = Request.QueryString["ID"].ToString(); cmd = new SqlCommand("SELECT @@IDENTITY AS IDS", conn); SqlDataAdapter da2 = new SqlDataAdapter(cmd); DataSet ds3 = new DataSet(); da2.Fill(ds3); revisionID = ds3.Tables[0].Rows[0]["IDS"].ToString(); } else { ID = Request.QueryString["ID"].ToString(); } } else { cmd = new SqlCommand("SELECT @@IDENTITY AS IDS", conn); SqlDataAdapter da2 = new SqlDataAdapter(cmd); DataSet ds3 = new DataSet(); da2.Fill(ds3); ID = ds3.Tables[0].Rows[0]["IDS"].ToString(); } bool isSlider = false; if (PictureCheckList.Items.Count > 0) isSlider = true; if (isSlider) { char[] delim2 = { '\\' }; //string[] fileArray = System.IO.Directory.GetFiles(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\Slider\\"); if (!System.IO.Directory.Exists(MapPath(".") + "\\VenueFiles")) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\VenueFiles\\"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\VenueFiles\\" + ID+"\\"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\VenueFiles\\" + ID + "\\Slider\\"); } else { if (!System.IO.Directory.Exists(MapPath(".") + "\\VenueFiles\\" + ID)) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\VenueFiles\\" + ID+"\\"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\VenueFiles\\" + ID+"\\Slider\\"); } else { if (!!System.IO.Directory.Exists(MapPath(".")+"\\VenueFiles\\" + ID+"\\Slider\\")) System.IO.Directory.CreateDirectory(MapPath(".")+"\\VenueFiles\\" + ID+"\\Slider\\"); } } string YouTubeStr = ""; char[] delim3 = { '.'}; dat.Execute("DELETE FROM Venue_Slider_Mapping WHERE VenueID=" + ID.ToString()); for (int i = 0; i < PictureCheckList.Items.Count; i++) { //int length = fileArray[i].Split(delim2).Length; string[] tokens = PictureCheckList.Items[i].Value.ToString().Split(delim3); if (tokens.Length >= 2) { //if (PictureCheckList.Items[i].Enabled) //{ if (tokens[1].ToUpper() == "JPG" || tokens[1].ToUpper() == "JPEG" || tokens[1].ToUpper() == "GIF" || tokens[1].ToUpper() == "PNG") { if (!System.IO.File.Exists(MapPath(".") + "\\VenueFiles\\" + ID.ToString() + "\\Slider\\" + PictureCheckList.Items[i].Value)) { System.IO.File.Copy(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\Slider\\" + PictureCheckList.Items[i].Value, MapPath(".") + "\\VenueFiles\\" + ID.ToString() + "\\Slider\\" + PictureCheckList.Items[i].Value); } cmd = new SqlCommand("INSERT INTO Venue_Slider_Mapping (VenueID, PictureName, RealPictureName) "+ "VALUES (@eventID, @picName, @realName)", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = ID; cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Value; cmd.Parameters.Add("@realName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Text; cmd.ExecuteNonQuery(); } else if (tokens[1].ToUpper() == "WMV") { if (!System.IO.File.Exists(MapPath(".") + "\\VenueFiles\\" + ID.ToString() + "\\Slider\\" + PictureCheckList.Items[i].Value)) { System.IO.File.Copy(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\Slider\\" + PictureCheckList.Items[i].Value, MapPath(".") + "\\VenueFiles\\" + ID.ToString() + "\\Slider\\" + PictureCheckList.Items[i].Value); } cmd = new SqlCommand("INSERT INTO Venue_Slider_Mapping (VenueID, PictureName) VALUES (@eventID, @picName)", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = ID; cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Value; cmd.ExecuteNonQuery(); } //} } else { YouTubeStr += PictureCheckList.Items[i].Value + ";"; } } dat.Execute("UPDATE Venues SET YouTubeVideo='" + YouTubeStr + "' WHERE ID=" + ID); } CreateCategories(ID, isOwner, isUpdate, revisionID, ownerUpForGrabs); //if (CategoriesCheckBoxes.Items.Count > 0) //{ // int catCount = CategoriesCheckBoxes.Items.Count; // for (int i = 0; i < catCount; i++) // { // cmd = new SqlCommand("INSERT INTO Event_Category_Mapping (EventID, CategoryID) VALUES (@eventID, @catID)", conn); // cmd.Parameters.Add("@catID", SqlDbType.Int).Value = int.Parse(CategoriesCheckBoxes.Items[i].Value); // cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = ID; // cmd.ExecuteNonQuery(); // } //} //Send the informational email to the user DataSet dsUser = dat.GetData("SELECT Email, UserName FROM USERS WHERE User_ID=" + Session["User"].ToString()); string emailBody = "<br/><br/>Dear " + dsUser.Tables[0].Rows[0]["UserName"].ToString() + ", <br/><br/> you have successfully posted the venue \"" + VenueNameTextBox.THE_TEXT + "\". <br/><br/> You can find this venue <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + ID + "_Venue\">here</a>. " + "<br/><br/> To rate your experience posting this venue <a href=\"http://hippohappenings.com/RateExperience.aspx?Edit=" + isUpdate.ToString() + "&Type=V&ID=" + ID + "\">please include your feedback here.</a>" + "<br/><br/><br/>Have a Hippo Happening Day!<br/><br/>"; //MessageLiteral.Text = "<script type=\"text/javascript\">alert('" + message + "');</script>"; if (isUpdate && !isOwner) { if (!ownerUpForGrabs) { DataSet dsEventUser = dat.GetData("SELECT * FROM Users U WHERE User_ID=" + ownerID); emailBody = "<br/><br/>A change request has been submitted for a venue you are the owner of on HippoHappenings: \"" + VenueNameTextBox.THE_TEXT.Trim() + "\". <br/><br/> You can find this venue <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + ID + "_Venue\">here</a>. " + "<br/><br/> Please log into Hippo Happenings and check your messages to view and approve these changes.</a>" + "<br/><br/><br/>Have a Hippo Happening Day!<br/><br/>"; //conn.Open(); SqlCommand cmd34 = new SqlCommand("INSERT INTO UserMessages (MessageContent, MessageSubject, From_UserID, To_UserID, Date, [Read], Mode, Live, SentLive) VALUES('" + "VenueID:" + Request.QueryString["ID"].ToString() + ",UserID:" + Session["User"].ToString() + ",RevisionID:" + revisionID + "',@content, "+dat.HIPPOHAPP_USERID.ToString()+", " + ownerID + ", '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString() + "', 0, 5, 1, 1)", conn); cmd34.Parameters.Add("@content", SqlDbType.NVarChar).Value = "A change request has been submitted for a venue you've created: " + VenueNameTextBox.THE_TEXT; cmd34.ExecuteNonQuery(); conn.Close(); if (!Request.Url.AbsoluteUri.Contains("localhost")) { dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(), System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), dsEventUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "A change request has been submitted for a venue you own on HippoHappenings: " + VenueNameTextBox.THE_TEXT); } } } if (isUpdate) { if (isOwner) { //dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(), // System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), // dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "You have updated venue: " + // VenueNameTextBox.THE_TEXT); } else { if (ownerUpForGrabs) { emailBody = "<br/><br/>You have successfully submitted updates for venue: \"" + VenueNameTextBox.THE_TEXT.Trim() + "\". <br/><br/> You can find this venue <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + ID + "_Venue\">here</a>. " + "<br/><br/> To rate your experience posting this venue <a href=\"http://hippohappenings.com/RateExperience.aspx?Edit=" + isUpdate.ToString() + "&Type=V&ID=" + ID + "\">please include your feedback here.</a><br/><br/>"+ "Have a Hippo Happening Day!<br/><br/>"; } else { emailBody = "<br/><br/>You have successfully submitted updates for venue: \"" + VenueNameTextBox.THE_TEXT.Trim() + "\". <br/><br/> You can find this venue <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + ID + "_Venue\">here</a>. " + "<br/><br/> The owner of the venue will need to approve/reject your change suggestions. If you do not hear back " + "from the venue's owner within 7 days, you will be allowed to take over ownership of this venue and automatically submit changes. That is, if no one else beats you to it! " + "If you have chosen to take over ownership, a button will be available for you on the venue's page. If you have not, you will need to edit the venue's details again." + "<br/><br/><br/>Have a Hippo Happening Day!<br/><br/>"; } if (!Request.Url.AbsoluteUri.Contains("localhost")) { dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(), System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "You have submitted updates for venue: " + VenueNameTextBox.THE_TEXT); } } } else { if (!Request.Url.AbsoluteUri.Contains("localhost")) { dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(), System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "You have posted the venue: " + VenueNameTextBox.THE_TEXT); } } conn.Close(); //Update ownership history if neccessary if (isUpdate) { if (OwnerPanel.Visible) { if (isOwner) { if (!OwnerCheckBox.Checked) { string OwnerHistoryID = dat.GetData("SELECT * FROM VenueOwnerHistory WHERE VenueID="+ Request.QueryString["ID"].ToString()+" AND OwnerID="+Session["User"].ToString()+ " ORDER BY DateCreatedOwnership DESC").Tables[0].Rows[0]["ID"].ToString(); dat.Execute("UPDATE VenueOwnerHistory SET DateLostOwnership='"+DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString()+ "', GaveUpOwnership='True' WHERE ID="+OwnerHistoryID); } } else { if (OwnerCheckBox.Checked) { dat.Execute("INSERT INTO VenueOwnerHistory (VenueID, OwnerID, DateCreatedOwnership) "+ "VALUES("+Request.QueryString["ID"].ToString()+", "+Session["User"].ToString()+ ", '"+DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString()+"')"); } } } } else { dat.Execute("INSERT INTO VenueOwnerHistory (VenueID, OwnerID, DateCreatedOwnership) VALUES("+ID+", "+Session["User"].ToString()+", '"+DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString()+"')"); } //pop up the message to the user Encryption encrypt = new Encryption(); if (isOwner || !isUpdate) { Session["Message"] = "Your venue has been posted successfully! An email with this info will also be sent to your account.<br/>" + "Check out <a class=\"AddLink\" onclick=\"Search('" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + ID + "_Venue');\">this venues's</a> home page.<br/><br/><br/> -<a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Edit=" + isUpdate.ToString() + "&Type=V&ID=" + ID + "');\" >Rate </a>your user experience posting this venue.<br/>"; //MessageLiteral.Text = "<script type=\"text/javascript\">alert('" + message + "');</script>"; } else { if (ownerUpForGrabs) { Session["Message"] = "You have successfully submitted updates for venue: \"" + VenueNameTextBox.THE_TEXT.Trim() + "\".<br/><br/>Check out <a class=\"AddLink\" onclick=\"Search('" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + ID + "_Venue');\">this venues's</a> home page.<br/><br/> <a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Edit=" + isUpdate.ToString() + "&Type=V&ID=" + ID + "');\" >Rate </a>your user experience editing this venue.<br/>"; } else { Session["Message"] = "You have successfully submitted updates for this venue." + "<br/><br/> The owner of the venue will need to <b>approve/reject</b> your change suggestions. If you do not hear back " + "from the venue's owner within <b>7 days</b>, you will be allowed to <b>take over ownership</b> of this venue and automatically submit changes. That is, if no one else beats you to it! " + "If you have chosen to take over ownership, a button will be available for you on the venue's page to do so. If you have not, you will need to edit the venue's details again.<br/><br/>" + "Check out <a class=\"AddLink\" onclick=\"Search('" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + ID + "_Venue');\">this venues's</a> home page.<br/><br/> <a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Edit=" + isUpdate.ToString() + "&Type=V&ID=" + ID + "');\" >Rate </a>your user experience editing this venue.<br/>"; MessageRadWindow.Width = 530; MessageRadWindow.Height = int.Parse(MessageRadWindow.Height.Value.ToString()) + 20; } } MessageRadWindow.NavigateUrl = "Message.aspx?message=" + encrypt.encrypt(Session["Message"].ToString() + "<br/><img onclick=\"Search('Home.aspx');\" onmouseover=\"this.src='image/DoneSonButtonSelected.png'\" onmouseout=\"this.src='image/DoneSonButton.png'\" src=\"image/DoneSonButton.png\"/>"); MessageRadWindow.Visible = true; MessageRadWindowManager.VisibleOnPageLoad = true; } } else { MessagePanel.Visible = true; YourMessagesLabel.Text += "<br/><br/>You must agree to the terms and conditions."; } }
protected string GetEmailString(string header, string picture, string ID, string description, string userName, bool isBig, ref int normalAdCount) { HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); string adtitle = "style=\"color: White;font-weight: bold;font-family: Arial;font-size: 14px;margin-top: 10px;text-decoration: none;\""; string adbody = "style=\"color: #cccccc;font-family: Arial;font-size: 12px;line-height: 20px;\""; string readmorelink = "style=\"font-family: Arial; font-weight: bold;color: #1fb6e7; font-size: 12px;text-decoration: none;\""; string email = ""; if (isBig) { email += "<tr><td colspan=\"2\"><div style=\"float: left;width: 419px;margin: 10px; height: 206px; background-color: #686868;\">" + "<div class=\"topDiv\" style=\"padding-top: 5px; clear: both; padding-left: 5px; background-color: #686868;\">"; if (picture == null) { email += "</div>" + "<div style=\"float: left;padding-top: 5px; padding-left: 3px;\">"; } else { email += "<div style=\"float: left;\"><table width='212px' height='190px' " + "bgcolor=\"black\" cellpadding=\"0\" cellspacing=\"0\"><tbody align=\"center\"><tr>" + "<td valign=\"middle\"><img alt=\"" + header + "\" " + "name=\"" + header + "\" src=\"./UserFiles/" + userName + "/" + picture + "\" /></td></tr></tbody></table></div>" + "" + "<div style=\"text-align: center; padding-top: 5px; padding-left: 3px;\">"; } if (ID == null) { email += "<a " + adtitle + ">" + dat.BreakUpString(header, 21) + "</a><br/>"; } else { email += "<a href=\"http://HippoHappenings.com/" + dat.MakeNiceName(header) + "_" + ID + "_Ad" + "\" " + adtitle + ">" + dat.BreakUpString(header, 10) + "</a><br/>"; } email += "<label " + adbody + ">" + description + "</label>"; if (ID == null) { email += "<div style=\"float: right; padding-right: 8px; height: 50px; width: 80px; padding-top: 10px;\">" + "<div style=\"float: left;padding-top: 5px; clear: none;\"><img src=\"http://HippoHappenings.com/image/ReadMoreArrow.png\" /></div>" + "<div style=\"float: right;clear: none;\"><a " + readmorelink + ">Read More</a>"; } else { email += "<div style=\"float: right; padding-right: 8px; height: 50px; width: 80px; padding-top: 10px;\">" + "<div style=\"float: left;padding-top: 5px; clear: none;\"><img src=\"http://HippoHappenings.com/image/ReadMoreArrow.png\" /></div>" + "<div style=\"float: right;clear: none;\"><a " + readmorelink + " href=\"http://HippoHappenings.com/" + dat.MakeNiceName(header) + "_" + ID + "_Ad\">Read More</a>"; } email += "</div></div>" + "</div>" + "</div>" + "</div></td></tr>"; } else { if (normalAdCount % 2 == 0) { email += "<tr><td>"; } else { email += "<td>"; } email += "<div style=\"float: left;margin: 10px; width: 214px; height: 268px; "+ "background-color: #686868;\">" + "<div style=\"float: left;width: 214px; height: 268px; background-color: #686868;\">" + "<div class=\"topDiv\" style=\";padding-top: 10px; clear: both; padding-left: 10px;\">"; if (picture == null) { email += ""; } else { string w = ""; string h = ""; GetAdSize(out w, out h, picture); email += "<div style=\"float: left;\"><table width=\"100px\" height=\"100px\" " + "bgcolor=\"black\" cellpadding=\"0\" cellspacing=\"0\"><tbody align=\"center\"><tr><td valign=\"middle\">" + "<img alt=\"" + header + "\" " + "name=\"" + header + "\" width='" + w + "px' height='" + h + "px' src=\"./UserFiles/" + userName + "/" + picture + "\" /></td></tr></tbody></table></div>"; } if (ID == null) { email += "<div style=\"text-align: center; padding-left: 3px;\"><a " + adtitle + ">" + dat.BreakUpString(header, 10) + "</a><br/>" + "</div>" + "</div>" + "<div align=\"left\" style=\"clear: both; padding-left: 12px; padding-right: 8px;\">" + "<label " + adbody + ">" + description + "</label>" + "</div>" + "<div style=\"float: right; padding-right: 8px; height: 50px; width: 80px; padding-top: 10px;\">" + "<div style=\"float: left;padding-top: 5px; clear: none;\"><img src=\"http://HippoHappenings.com/image/ReadMoreArrow.png\" /></div>" + "<div style=\"float: right;clear: none;\"><a " + readmorelink + " >Read More</a>" + "</div></div></div></div>"; } else { email += "<div><a href=\"http://HippoHappenings.com/" + dat.MakeNiceName(header) + "_" + ID + "_Ad\" " + adtitle + ">" + dat.BreakUpString(header, 10) + "</a><br/>" + "</div>" + "</div>" + "<div align=\"left\" style=\"clear: both; padding-left: 12px; padding-right: 8px;\">" + "<label " + adbody + ">" + description + "</label>" + "</div>" + "<div style=\"float: right; padding-right: 8px; height: 50px; width: 80px; padding-top: 10px;\">" + "<div style=\"float: left;padding-top: 5px; clear: none;\"><img src=\"http://HippoHappenings.com/image/ReadMoreArrow.png\" /></div>" + "<div style=\"float: right;clear: none;\"><a " + readmorelink + " href=\"http://HippoHappenings.com/" + dat.MakeNiceName(header) + "_" + ID + "_Ad\">Read More</a>" + "</div></div></div></div>"; } if (normalAdCount % 2 == 0) { email += "</td>"; } else { email += "</td></tr>"; } normalAdCount++; } return email; }
protected void GetVenues() { VenuesPanel.Controls.Clear(); HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); DataSet dsAds = dat.GetData("SELECT * FROM Venues WHERE Owner=" + Session["User"].ToString() + " ORDER BY Name"); DataView dvAdds = new DataView(dsAds.Tables[0], "", "", DataViewRowState.CurrentRows); ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx(); VenuesPanel.Controls.Add(pagerPanel); pagerPanel.PANEL_NAME = pagerPanel.ClientID + "_Panel"; if (dvAdds.Count > 0) { pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 10; pagerPanel.WIDTH = 700; pagerPanel.NUMBER_OF_VISIBLE_PAGES = 4; ArrayList a = new ArrayList(dvAdds.Count); int pagecount = 1; for (int i = 0; i < dvAdds.Count; i++) { Literal label = new Literal(); //label.CssClass = "AddLink"; if (i % 10 == 0) label.Text = "<table cellpadding=\"5px\" width=\"700px\"><tbody>"; label.Text += "<tr><td><a class=\"NavyLink12\" style=\"padding-left: 10px;\" href=\"" + dat.MakeNiceName(dvAdds[i]["Name"].ToString()) + "_" + dvAdds[i]["ID"].ToString() + "_Venue\">" + dvAdds[i]["Name"].ToString() + "</a></td>"; //if (!bool.Parse(dvAdds[i]["Featured"].ToString())) //{ label.Text += "<td align=\"center\" width=\"100px\"><div style=\"width: 65px\" align=\"center\">" + "<div style=\"width: 100px;\" onclick=\"window.location = 'enter-locale?edit=true&ID=" + dvAdds[i]["ID"].ToString() + "';\">" + "<div class=\"topDiv\" style=\"clear: both;\">" + " <img style=\"float: left;\" src=\"NewImages/ButtonLeft.png\" height=\"27px\" /> " + " <div class=\"NavyLink\" style=\"font-size: 12px; text-decoration: none; padding-top: 5px;" + "padding-left: 6px; padding-right: 6px;height: 27px;float: left;background: url('NewImages/ButtonPixel.png'); background-repeat: repeat-x;\">" + " Edit " + "</div>" + " <img style=\"float: left;\" src=\"NewImages/ButtonRight.png\" height=\"27px\" /> " + "</div>" + "</div>" + "</div></td><td></td></tr>"; //} //else //{ // char[] delim = { ';' }; // string[] tokens = dvAdds[i]["DaysFeatured"].ToString().Split(delim, StringSplitOptions.RemoveEmptyEntries); // label.Text += "<td align=\"center\" width=\"100px\"><label>Featured on "; // foreach (string token in tokens) // { // label.Text += token + ", "; // } // label.Text = label.Text.Trim().Substring(0, label.Text.Trim().Length - 1) + "</label></td>"; // label.Text += "<td align=\"center\" width=\"170px\"><div style=\"width: 158px\" align=\"center\">" + // "<div style=\"width: 160px;\" onclick=\"window.location = 'enter-locale?edit=true&Feature=true&ID=" + dvAdds[i]["ID"].ToString() + "';\">" + // "<div class=\"topDiv\" style=\"clear: both;\">" + // " <img style=\"float: left;\" src=\"NewImages/ButtonLeft.png\" height=\"27px\" /> " + // " <div class=\"NavyLink\" style=\"font-size: 12px; text-decoration: none; padding-top: 5px;" + // "padding-left: 6px; padding-right: 6px;height: 27px;float: left;background: url('NewImages/ButtonPixel.png'); background-repeat: repeat-x;\">" + // "Add More Feature Dates" + // "</div>" + // " <img style=\"float: left;\" src=\"NewImages/ButtonRight.png\" height=\"27px\" /> " + // "</div>" + // "</div>" + // "</div></td>"; // label.Text += "</tr>"; //} if ((i + 1) == 10 * pagecount || i == dvAdds.Count - 1) { label.Text += "</tbody></table>"; pagecount++; } //panel = new Panel(); //panel.Controls.Add(label); a.Add(label); } pagerPanel.DATA = a; pagerPanel.DataBind2(); } else { pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 1; pagerPanel.WIDTH = 700; pagerPanel.NUMBER_OF_VISIBLE_PAGES = 1; ArrayList a = new ArrayList(1); Literal lit = new Literal(); lit.Text = "<div style=\"padding: 10px;\"><label>You are not an owner of any venues. To post venues go to <a href=\"EnterVenueIntro.aspx\" class=\"NavyLink12\">Post A Venue page</a>.</label></div>"; a.Add(lit); pagerPanel.DATA = a; pagerPanel.DataBind2(); } }
//protected void GetAds() //{ // AdPanel.Controls.Clear(); // HttpCookie cookie = Request.Cookies["BrowserDate"]; // Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); // DataSet dsAds = dat.GetData("SELECT * FROM Ads WHERE User_ID=" + Session["User"].ToString() + " ORDER BY Header"); // DataView dvAdds = new DataView(dsAds.Tables[0], "", "", DataViewRowState.CurrentRows); // Panel panel; // ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx(); // AdPanel.Controls.Add(pagerPanel); // pagerPanel.PANEL_NAME = pagerPanel.ClientID + "_Panel"; // if (dvAdds.Count > 0) // { // pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 10; // pagerPanel.WIDTH = 700; // pagerPanel.NUMBER_OF_VISIBLE_PAGES = 4; // ArrayList a = new ArrayList(dvAdds.Count); // int pagecount = 1; // for (int i = 0; i < dvAdds.Count; i++) // { // string featured = "False"; // if (bool.Parse(dvAdds[i]["Featured"].ToString())) // featured = "True"; // Literal label = new Literal(); // label.Text = "<tr><td width=\"400px\"><a class=\"NavyLink12\" style=\"padding-left: 10px;\" " + // "href=\"" + dat.MakeNiceName(dvAdds[i]["Header"].ToString()) + "_" + // dvAdds[i]["Ad_ID"].ToString() + "_Ad\">" + dvAdds[i]["Header"].ToString() + // "</a></td>"; // string disableStr = ""; // if (bool.Parse(dvAdds[i]["LIVE"].ToString())) // { // disableStr = "<td><a class=\"PageButtons\" onclick=\"OpenRadDeleteAd(" + dvAdds[i]["Ad_ID"].ToString() + // ")\">Disable</a></td>"; // } // else // { // disableStr = "<td><a class=\"PageButtons\" onclick=\"OpenRadEnableAd(" + dvAdds[i]["Ad_ID"].ToString() + // ")\">Enable</a></td>"; // } // label.Text += "<td width=\"50px\"><a " + // "class=\"PageButtons\" href=\"post-bulletin?copy=true&ID=" + // dvAdds[i]["Ad_ID"].ToString() + "\">Copy</a></td>" + disableStr; // if (!bool.Parse(featured)) // { // label.Text += "<td align=\"center\" width=\"100px\"><div style=\"width: 65px\" align=\"center\">" + // "<div style=\"width: 100px;\" onclick=\"window.location = 'post-bulletin?edit=true&Feature=true&ID=" + dvAdds[i]["Ad_ID"].ToString() + "';\">" + // "<div class=\"topDiv\" style=\"clear: both;\">" + // " <img style=\"float: left;\" src=\"NewImages/ButtonLeft.png\" height=\"27px\" /> " + // " <div class=\"NavyLink\" style=\"font-size: 12px; text-decoration: none; padding-top: 5px;" + // "padding-left: 6px; padding-right: 6px;height: 27px;float: left;background: url('NewImages/ButtonPixel.png'); background-repeat: repeat-x;\">" + // " Feature " + // "</div>" + // " <img style=\"float: left;\" src=\"NewImages/ButtonRight.png\" height=\"27px\" /> " + // "</div>" + // "</div>" + // "</div></td>"; // } // else // { // char[] delim = { ';' }; // string[] tokens = dvAdds[i]["DatesOfAd"].ToString().Split(delim, StringSplitOptions.RemoveEmptyEntries); // label.Text += "<td align=\"center\" width=\"100px\"><label>Featured on "; // foreach (string token in tokens) // { // label.Text += token + ", "; // } // label.Text = label.Text.Trim().Substring(0, label.Text.Trim().Length - 1) + "</label>"; // label.Text += "<td align=\"center\" width=\"170px\"><div style=\"width: 158px\" align=\"center\">" + // "<div style=\"width: 160px;\" onclick=\"window.location = 'post-bulletin?edit=true&Feature=true&ID=" + dvAdds[i]["Ad_ID"].ToString() + "';\">" + // "<div class=\"topDiv\" style=\"clear: both;\">" + // " <img style=\"float: left;\" src=\"NewImages/ButtonLeft.png\" height=\"27px\" /> " + // " <div class=\"NavyLink\" style=\"font-size: 12px; text-decoration: none; padding-top: 5px;" + // "padding-left: 6px; padding-right: 6px;height: 27px;float: left;background: url('NewImages/ButtonPixel.png'); background-repeat: repeat-x;\">" + // "Add More Feature Dates" + // "</div>" + // " <img style=\"float: left;\" src=\"NewImages/ButtonRight.png\" height=\"27px\" /> " + // "</div>" + // "</div>" + // "</div></td>"; // label.Text += "</tr>"; // } // //panel = new Panel(); // //Literal lNew = new Literal(); // if ((i % pagerPanel.NUMBER_OF_ITEMS_PER_PAGE) == 0) // { // label.Text = "<table cellpadding=\"5px\" width=\"700px\"><tbody style=\"\">" // + label.Text; // //panel.Controls.Add(lNew); // } // //Literal lOld = new Literal(); // //panel.Controls.Add(label); // if ((i + 1) == 10 * pagecount || i == dvAdds.Count - 1) // { // label.Text = label.Text + "</tbody></table>"; // pagecount++; // //panel.Controls.Add(lOld); // } // a.Add(label); // } // pagerPanel.DATA = a; // pagerPanel.DataBind2(); // } // else // { // pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 1; // pagerPanel.WIDTH = 700; // pagerPanel.NUMBER_OF_VISIBLE_PAGES = 1; // ArrayList a = new ArrayList(1); // Literal lit = new Literal(); // lit.Text = "<div style=\"padding: 10px;\"><label>You are not an owner of any ads. To post ads go to <a href=\"post-bulletin\" class=\"NavyLink12\">Post An Ad page</a>.</label></div>"; // a.Add(lit); // pagerPanel.DATA = a; // pagerPanel.DataBind2(); // } //} protected void GetEvents() { EventsPanel.Controls.Clear(); HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); DataSet dsAds = dat.GetData("SELECT * FROM Events E WHERE Owner=" + Session["User"].ToString() + " ORDER BY Header"); DataView dvAdds = new DataView(dsAds.Tables[0], "", "", DataViewRowState.CurrentRows); Panel panel; ASP.controls_pager_ascx pagerPanel = new ASP.controls_pager_ascx(); EventsPanel.Controls.Add(pagerPanel); pagerPanel.PANEL_NAME = pagerPanel.ClientID + "_Panel"; DataView dvEvent; if (dvAdds.Count > 0) { pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 10; pagerPanel.WIDTH = 700; pagerPanel.NUMBER_OF_VISIBLE_PAGES = 4; ArrayList a = new ArrayList(dvAdds.Count); int pagecount = 1; for (int i = 0; i < dvAdds.Count; i++) { dvEvent = dat.GetDataDV("SELECT * FROM Events E, Event_Occurance EO Where E.ID=EO.EventID AND E.ID=" + dvAdds[i]["ID"].ToString() + " ORDER BY EO.DateTimeEnd"); Literal label = new Literal(); //label.CssClass = "AddLink"; string disableStr = ""; if (bool.Parse(dvAdds[i]["LIVE"].ToString())) { disableStr = "<td align=\"center\" width=\"50px\"><a class=\"PageButtons\" onclick=\"OpenRadDeleteEvent(" + dvAdds[i]["ID"].ToString() + ")\">Disable</a></td>"; //if (!bool.Parse(dvAdds[i]["Featured"].ToString())) //{ if (DateTime.Parse(dvEvent[0]["DateTimeEnd"].ToString()) >= DateTime.Now) { disableStr += "<td align=\"center\" width=\"100px\"><div style=\"width: 65px\" align=\"center\">" + "<div style=\"width: 100px;\" onclick=\"window.location = 'blog-event?edit=true&ID=" + dvAdds[i]["ID"].ToString() + "';\">" + "<div class=\"topDiv\" style=\"clear: both;\">" + " <img style=\"float: left;\" src=\"NewImages/ButtonLeft.png\" height=\"27px\" /> " + " <div class=\"NavyLink\" style=\"font-size: 12px; text-decoration: none; padding-top: 5px;" + "padding-left: 6px; padding-right: 6px;height: 27px;float: left;background: url('NewImages/ButtonPixel.png'); background-repeat: repeat-x;\">" + " Edit " + "</div>" + " <img style=\"float: left;\" src=\"NewImages/ButtonRight.png\" height=\"27px\" /> " + "</div>" + "</div>" + "</div></td>"; } else { disableStr += "<td align=\"center\" width=\"100px\"><label>This event has passed</label></td>"; } //} //else //{ // char[] delim = { ';' }; // string[] tokens = dvAdds[i]["DaysFeatured"].ToString().Split(delim, StringSplitOptions.RemoveEmptyEntries); // disableStr += "<td align=\"center\" width=\"100px\"><label>Featured on "; // foreach (string token in tokens) // { // disableStr += token + ", "; // } // disableStr = disableStr.Trim().Substring(0, disableStr.Trim().Length - 1) + "</label>"; // if (DateTime.Parse(dvEvent[0]["DateTimeEnd"].ToString()) >= DateTime.Now) // { // disableStr += "<td align=\"center\" width=\"170px\"><div style=\"width: 158px\" align=\"center\">" + // "<div style=\"width: 160px;\" onclick=\"window.location = 'blog-event?edit=true&Feature=true&ID=" + dvAdds[i]["ID"].ToString() + "';\">" + // "<div class=\"topDiv\" style=\"clear: both;\">" + // " <img style=\"float: left;\" src=\"NewImages/ButtonLeft.png\" height=\"27px\" /> " + // " <div class=\"NavyLink\" style=\"font-size: 12px; text-decoration: none; padding-top: 5px;" + // "padding-left: 6px; padding-right: 6px;height: 27px;float: left;background: url('NewImages/ButtonPixel.png'); background-repeat: repeat-x;\">" + // "Add More Feature Dates" + // "</div>" + // " <img style=\"float: left;\" src=\"NewImages/ButtonRight.png\" height=\"27px\" /> " + // "</div>" + // "</div>" + // "</div></td>"; // } // else // { // disableStr += "<td align=\"center\" width=\"140px\"><label>This event has passed</label></td>"; // } // disableStr += "</tr>"; //} } else { disableStr = "<td align=\"center\" width=\"50px\"><a class=\"PageButtons\" onclick=\"OpenRadEnableEvent(" + dvAdds[i]["ID"].ToString() + ")\">Enable</a></td>"; //disableStr += "<td align=\"center\" width=\"100px\"><label>To feature event, enable it first.</label></td>"; } if (i % 10 == 0) label.Text = "<table cellpadding=\"5px\" width=\"700px\"><tbody style=\"\">"; label.Text += "<tr><td><a class=\"NavyLink12\" style=\"padding-left: 10px;\" href=\"" + dat.MakeNiceName(dvAdds[i]["Header"].ToString()) + "_" + dvAdds[i]["ID"].ToString() + "_Event\">" + dvAdds[i]["Header"].ToString() + "</a></td><td width=\"50px\"><a class=\"PageButtons\" href=\"blog-event?copy=true&ID=" + dvAdds[i]["ID"].ToString() + "\">Copy</a></td>"+disableStr+"</tr>"; if ((i + 1) == 10 * pagecount || i == dvAdds.Count - 1) { label.Text += "</tbody></table>"; pagecount++; } //panel = new Panel(); //panel.Controls.Add(label); a.Add(label); } pagerPanel.DATA = a; pagerPanel.DataBind2(); } else { pagerPanel.NUMBER_OF_ITEMS_PER_PAGE = 1; pagerPanel.WIDTH = 700; pagerPanel.NUMBER_OF_VISIBLE_PAGES = 1; ArrayList a = new ArrayList(1); Literal lit = new Literal(); lit.Text = "<div style=\"padding: 10px;\"><label>You are not an owner of any events. To post events go to <a href=\"enter-event\" class=\"AddLink\">Post An Event page</a>.</label></div>"; a.Add(lit); pagerPanel.DATA = a; pagerPanel.DataBind2(); } }
protected void Page_Load(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; DateTime isn = DateTime.Now; if (!DateTime.TryParse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"), out isn)) isn = DateTime.Now; DateTime isNow = isn; Data dat = new Data(isn); string background = ""; if (isFeatured) { background = "background-color: #e9f1f4;"; } else { background = "border-bottom: solid 1px #dedbdb;"; } if (searchNumber != "") { string markerNumber = dat.GetImageNum(searchNumber); ImageLiteral.Text = imageLiteral + "<div style=\"float: left;padding-right: 5px;height: 50px;\"><img style=\"cursor: pointer;\" onclick=\"myclick(" + markerNumber + ");\" src=" + "\"http://www.google.com/mapfiles/marker" + searchNumber + ".png\" /></div>"; BeginingLiteral.Text = "<div style=\"clear: both;margin-top: 3px;height: 56px;margin-bottom: 3px; width: " + width.ToString() + "px; padding: 3px;" + background + "\">"; } else { BeginingLiteral.Text = "<div class=\"topDiv\" style=\"clear: both;background-color:" + color + "; width: " + width.ToString() + "px; padding: 3px; margin-bottom: 3px;" + background + "\">"; } SearchLabel.NavigateUrl = "../" + dat.MakeNiceName(searchLabel) + "_" + venueID + "_Venue"; if (searchLabel.Length > 36) { searchLabel = searchLabel.Substring(0, 33) + "..."; } SearchLabel.Text = dat.stripHTML(searchLabel); DataView dvEvent = dat.GetDataDV("SELECT * FROM Venues WHERE ID=" + venueID); string shortDesc = ""; if (dvEvent[0]["Content"].ToString().Trim() != "") { shortDesc = dat.stripHTML(dvEvent[0]["Content"].ToString()).Trim(); if (shortDesc.Length > 113) { shortDesc = shortDesc.Substring(0, 110) + "..."; } } ShortDescriptionLabel.Text = dat.stripHTML(shortDesc); DataView dvEventsSlider = dat.GetDataDV("SELECT * FROM Venues E, Venue_Slider_Mapping ESM "+ "WHERE E.ID=ESM.VenueID AND E.ID=" + venueID); if (dvEventsSlider.Count > 0) { if (System.IO.File.Exists(MapPath("../") + "\\VenueFiles\\" + venueID + "\\Slider\\" + dvEventsSlider[0]["PictureName"].ToString())) { System.Drawing.Image img = System.Drawing.Image.FromFile(MapPath("../") + "\\VenueFiles\\" + venueID + "\\Slider\\" + dvEventsSlider[0]["PictureName"].ToString()); SaveThumbnail(img, MapPath("../") + "\\Temp\\Temp_" + dvEventsSlider[0]["PictureName"].ToString()); EventImageLiteral.Text = "<img style='float: left; padding-right: 5px;' src='http://hippohappenings.com/Temp/Temp_" + dvEventsSlider[0]["PictureName"].ToString() + "' />"; } } else { EventImageLiteral.Text = ""; } string begining = "<div class=\"TextNormal\">"; string end = "</div>"; TagsLiteral.Text = begining + end; dat.TAG_TYPE = Data.tagType.VENUE; int tagLength = 0; if (ShortDescriptionLabel.Text.Length > 64) { tagLength = 57; } else if (ShortDescriptionLabel.Text.Length == 0) { tagLength = 183; } else { tagLength = 122; } string tags = dat.getTagsRestricted(dat.GetData("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=" + venueID), false, windowT, tagLength); TagsLiteral.Text += tags; }
protected void PostIt(object sender, EventArgs e) { object appSeshCountry; object appSeshState; object appSeshCity; object appSeshZip; object appSeshRadius; HttpCookie cookie = Request.Cookies["BrowserDate"]; if (AgreeCheckBox.Checked) { Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString()); conn.Open(); bool isEdit = false; if (Request.QueryString["edit"] != null) { isEdit = bool.Parse(Request.QueryString["edit"].ToString()); } string mediaCat = "0"; if (PictureCheckList.Items.Count > 0) mediaCat = "1"; string command = ""; DataSet dsEvent; int numViews = 0; if (isEdit) { dsEvent = dat.GetData("SELECT * FROM Ads WHERE Ad_ID="+adID.Text); numViews = int.Parse(dsEvent.Tables[0].Rows[0]["NumViews"].ToString()); string rad = ""; if (RadiusPanel.Visible) rad = ", Radius=@radius "; command = "UPDATE Ads SET hasSongs=@songs, User_ID=@userID, FeaturedSummary=@featuredSummary , " + "Description=@description, Header=@header, CountShown=@countShown, mediaCategory=" + mediaCat + ", " + "FeaturedPicture=@featuredPicture, FeaturedPictureName=@featuredPictureName, CatCountry=@catCountry, CatState=@catState, CatCity=@catCity, " + "CatZip=@catZip" + rad + ", DisplayToAll=@displayAll, NumViews=@num WHERE Ad_ID=" + adID.Text; } else { string rad = ""; string radEnd = ""; if (RadiusPanel.Visible) { rad = ", Radius "; radEnd = ", @radius "; } command = "INSERT INTO Ads (hasSongs, User_ID, FeaturedSummary ,Description, Header, "+ "CountShown, Featured, mediaCategory, FeaturedPicture, FeaturedPictureName, CatCountry, CatState, CatCity, "+ "CatZip" + rad + ", DisplayToAll, NumViews, NumCurrentViews, BigAd, DateAdded) " + " VALUES(@songs, @userID, @featuredSummary, @description, @header, @countShown, "+ "@featured, " + mediaCat + ", @featuredPicture, @featuredPictureName, @catCountry, @catState, @catCity, @catZip" + radEnd + ", @displayAll, @num, 0, @big, '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString() + "')"; } SqlCommand cmd = new SqlCommand(command, conn); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@num", SqlDbType.Int).Value = int.Parse(UsersTextBox.Text) + numViews; cmd.Parameters.Add("@description", SqlDbType.NVarChar).Value = DescriptionTextBox.Content; cmd.Parameters.Add("@userID", SqlDbType.Int).Value = int.Parse(Session["User"].ToString()); cmd.Parameters.Add("@featured", SqlDbType.Bit).Value = bool.Parse(isFeatured.Text); cmd.Parameters.Add("@songs", SqlDbType.Bit).Value = MusicCheckBox.Checked; if (bool.Parse(isFeatured.Text)) cmd.Parameters.Add("@featuredSummary", SqlDbType.NVarChar).Value = SummaryTextBox.InnerHtml; else cmd.Parameters.Add("@featuredSummary", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@header", SqlDbType.NVarChar).Value = AdNameTextBox.THE_TEXT; cmd.Parameters.Add("@countShown", SqlDbType.Int).Value = 0; if (AdPlacementList.SelectedValue == "0.01") cmd.Parameters.Add("@big", SqlDbType.Bit).Value = false; else cmd.Parameters.Add("@big", SqlDbType.Bit).Value = true; if (bool.Parse(isFeatured.Text)) if (AdPictureCheckList.Items.Count > 0 && AdMediaPanel.Visible) { cmd.Parameters.Add("@featuredPicture", SqlDbType.NVarChar).Value = AdPictureCheckList.Items[0].Value; cmd.Parameters.Add("@featuredPictureName", SqlDbType.NVarChar).Value = AdPictureCheckList.Items[0].Text; } else { cmd.Parameters.Add("@featuredPicture", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@featuredPictureName", SqlDbType.NVarChar).Value = DBNull.Value; } else { cmd.Parameters.Add("@featuredPicture", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@featuredPictureName", SqlDbType.NVarChar).Value = DBNull.Value; } if (CountryDropDown.SelectedIndex != -1) { appSeshCountry = CountryDropDown.SelectedValue; cmd.Parameters.Add("@catCountry", SqlDbType.Int).Value = CountryDropDown.SelectedValue; string state = ""; if (StateDropDownPanel.Visible) { if (StateDropDown.SelectedIndex != -1) state = StateDropDown.SelectedItem.Text; } else state = StateTextBox.THE_TEXT; appSeshState = state; if (state != "") cmd.Parameters.Add("@catState", SqlDbType.NVarChar).Value = state; else cmd.Parameters.Add("@catState", SqlDbType.NVarChar).Value = DBNull.Value; if (CityTextBox.Text.Trim() != "") { appSeshCity = CityTextBox.Text.Trim(); cmd.Parameters.Add("@catCity", SqlDbType.NVarChar).Value = CityTextBox.Text.Trim(); } else cmd.Parameters.Add("@catCity", SqlDbType.NVarChar).Value = DBNull.Value; if (ZipTextBox.Text.Trim() != "") { appSeshZip = ZipTextBox.Text.Trim(); appSeshRadius = RadiusDropDown.SelectedValue; cmd.Parameters.Add("@catZip", SqlDbType.NVarChar).Value = dat.GetAllZipsInRadius(RadiusDropDown.SelectedValue, ZipTextBox.Text.Trim(), true); } else cmd.Parameters.Add("@catZip", SqlDbType.NVarChar).Value = DBNull.Value; if(CountryDropDown.SelectedValue == "223") cmd.Parameters.Add("@radius", SqlDbType.Int).Value = RadiusDropDown.SelectedValue; } else { cmd.Parameters.Add("@catCountry", SqlDbType.Int).Value = DBNull.Value; cmd.Parameters.Add("@catState", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@catCity", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@catZip", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@radius", SqlDbType.Int).Value = DBNull.Value; } cmd.Parameters.Add("@displayAll", SqlDbType.Bit).Value = DisplayCheckList.Items[0].Selected; //Media Categories: NONE: 0, Slider: 1. bool isSlider = false; if (PictureCheckList.Items.Count > 0) isSlider = true; cmd.ExecuteNonQuery(); cmd = new SqlCommand("SELECT @@IDENTITY AS ID", conn); SqlDataAdapter da2 = new SqlDataAdapter(cmd); DataSet ds3 = new DataSet(); da2.Fill(ds3); string ID = ds3.Tables[0].Rows[0]["ID"].ToString(); if (isEdit) { dat.Execute("DELETE FROM Ad_Calendar WHERE AdID="+adID.Text); if (bool.Parse(isFeatured.Text)) { cmd = new SqlCommand("INSERT INTO Ad_Calendar (AdID, DateTimeStart, DateTimeEnd) VALUES(@id, @start, @end)", conn); cmd.Parameters.Add("@id", SqlDbType.Int).Value = adID.Text; cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = Session["SelectedStartDate"].ToString(); cmd.Parameters.Add("@end", SqlDbType.DateTime).Value = DateTime.Parse(Session["SelectedStartDate"].ToString()).AddDays(double.Parse(DaysDropDown.SelectedValue)); cmd.ExecuteNonQuery(); } else { cmd = new SqlCommand("INSERT INTO Ad_Calendar (AdID, DateTimeStart, DateTimeEnd) VALUES(@id, @start, @end)", conn); cmd.Parameters.Add("@id", SqlDbType.Int).Value = adID.Text; cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = StartDateTimePicker.DbSelectedDate; cmd.Parameters.Add("@end", SqlDbType.DateTime).Value = DateTime.Parse(StartDateTimePicker.DbSelectedDate.ToString()).AddDays(double.Parse(DaysDropDown.SelectedValue)); cmd.ExecuteNonQuery(); } } else { cmd = new SqlCommand("INSERT INTO Ad_Calendar (AdID, DateTimeStart, DateTimeEnd) VALUES(@id, @start, @end)", conn); cmd.Parameters.Add("@id", SqlDbType.Int).Value = ID; if (bool.Parse(isFeatured.Text)) { cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = Session["SelectedStartDate"].ToString(); cmd.Parameters.Add("@end", SqlDbType.DateTime).Value = DateTime.Parse(Session["SelectedStartDate"].ToString()).AddDays(double.Parse(DaysDropDown.SelectedValue)); } else { cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = DateTime.Parse(StartDateTimePicker.DbSelectedDate.ToString()); cmd.Parameters.Add("@end", SqlDbType.DateTime).Value = DateTime.Parse(StartDateTimePicker.DbSelectedDate.ToString()).AddDays(double.Parse(DaysDropDown.SelectedValue)); } cmd.ExecuteNonQuery(); } string theID = ID; if (isEdit) { theID = adID.Text; } if (MusicCheckBox.Checked) { if (isEdit) { dat.Execute("DELETE FROM Ad_Song_Mapping WHERE AdID="+theID); } for (int i = 0; i < SongCheckList.Items.Count; i++) { cmd = new SqlCommand("INSERT INTO Ad_Song_Mapping (AdID, SongName, SongTitle) "+ "VALUES(@eventID, @songName, @songTitle)", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = int.Parse(theID); cmd.Parameters.Add("@songName", SqlDbType.NVarChar).Value = SongCheckList.Items[i].Value.ToString(); cmd.Parameters.Add("@songTitle", SqlDbType.NVarChar).Value = SongCheckList.Items[i].Text; cmd.ExecuteNonQuery(); dat.Execute("UPDATE Ads SET hasSongs=1 WHERE Ad_ID="+theID); } } if (isEdit) { dat.Execute("DELETE FROM Ad_Slider_Mapping WHERE AdID=" + theID); } if (MainAttractionCheck.Checked) { if (isSlider) { char[] delim2 = { '\\' }; string[] fileArray = System.IO.Directory.GetFiles(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\"); if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles")) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID); } else { if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\")) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\" + theID); } else { if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider")) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID); } else { if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID)) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID); } } } } string YouTubeStr = ""; char[] delim3 = { '.' }; for (int i = 0; i < PictureCheckList.Items.Count; i++) { int length = fileArray[i].Split(delim2).Length; string[] tokens = PictureCheckList.Items[i].Value.ToString().Split(delim3); if (tokens.Length >= 2) { if (tokens[1].ToUpper() == "JPG" || tokens[1].ToUpper() == "JPEG" || tokens[1].ToUpper() == "GIF") { if (!System.IO.File.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID + "\\" + PictureCheckList.Items[i].Value)) { System.IO.File.Copy(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + PictureCheckList.Items[i].Value, MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID + "\\" + PictureCheckList.Items[i].Value); } cmd = new SqlCommand("INSERT INTO Ad_Slider_Mapping (AdID, PictureName, RealPictureName) " + "VALUES (@eventID, @picName, @realName)", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = theID; cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Value; cmd.Parameters.Add("@realName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Text; cmd.ExecuteNonQuery(); } } else { YouTubeStr += PictureCheckList.Items[i].Value + ";"; } } //if (YouTubeStr != "") //{ dat.Execute("UPDATE Ads SET YouTubeVideo='" + YouTubeStr + "' WHERE Ad_ID=" + theID); //} } } else { } if (isEdit) { dat.Execute("DELETE FROM Ad_Category_Mapping WHERE AdID="+theID); } CreateCategories(theID); string views = dat.GetDataDV("SELECT NumViews - NumCurrentViews AS Views FROM Ads WHERE Ad_ID=" + theID)[0]["Views"].ToString(); if (bool.Parse(isFeatured.Text) && int.Parse(views) != 0) EmailSavedSearches(theID, views); //if (CategoriesCheckBoxes.Items.Count > 0) //{ // int catCount = CategoriesCheckBoxes.Items.Count; // for (int i = 0; i < catCount; i++) // { // cmd = new SqlCommand("INSERT INTO Ad_Category_Mapping (AdID, CategoryID) VALUES (@adID, @catID)", conn); // cmd.Parameters.Add("@adID", SqlDbType.Int).Value = ID; // cmd.Parameters.Add("@catID", SqlDbType.Int).Value = int.Parse(CategoriesCheckBoxes.Items[i].Value); // cmd.ExecuteNonQuery(); // } //} string adFeatured = ""; string adFeaturedEmail = ""; if (bool.Parse(isFeatured.Text)) { adFeatured += "<br/><br/>Since you selected to have your ad Featured, you can view the progress of your ad on the <a class=\"AddLink\" onclick=\"Search('AdStatistics.aspx?Ad="+theID+"');\">Ad Statistics</a> page, which is also linkable from your user page."; adFeaturedEmail += "<br/><br/>Since you selected to have your ad Featured, you can view the progress of your ad on the <a href=\"http://hippohappenings.com/AdStatistics.aspx?Ad="+theID+"\">Ad Statistics</a> page, which is also linkable from your user page."; } DataSet dsUser = dat.GetData("SELECT Email, UserName FROM USERS WHERE User_ID=" + Session["User"].ToString()); string emailBody = "<br/><br/>Dear " + dsUser.Tables[0].Rows[0]["UserName"].ToString() + ", <br/><br/> you have successfully posted the ad \"" + AdNameTextBox.THE_TEXT + "\". <br/><br/> You can find this ad <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(AdNameTextBox.THE_TEXT)+"_" + theID + "_Ad\">here</a>. " + adFeaturedEmail + "<br/><br/> To rate your experience posting this ad <a href=\"http://hippohappenings.com/RateExperience.aspx?Type=A&ID=" + theID + "\">please include your feedback here.</a>" + "<br/><br/><br/>Have a Hippo Happening Day!<br/><br/>"; if (isEdit) { emailBody = "<br/><br/>Dear " + dsUser.Tables[0].Rows[0]["UserName"].ToString() + ", <br/><br/> you have successfully edited the ad \"" + AdNameTextBox.THE_TEXT + "\". <br/><br/> You can find this ad <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(AdNameTextBox.THE_TEXT) + "_" + theID + "_Ad\">here</a>. " + adFeaturedEmail + "<br/><br/> To rate your experience editing this ad <a href=\"http://hippohappenings.com/RateExperience.aspx?Type=A&ID=" + theID + "\">please include your feedback here.</a>" + "<br/><br/><br/>Have a Hippo Happening Day!<br/><br/>"; } if (!Request.IsLocal) { dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(), System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "You have successfully posted the ad: " + AdNameTextBox.THE_TEXT); } conn.Close(); dat.SendFriendPostedAdNotification(Session["User"].ToString(), theID); Session["Message"] = "Your ad has been posted successfully!<br/> Here are your next steps: <br/>"; if (isEdit) { Session["Message"] = "Your ad has been edited successfully!<br/> Here are your next steps: <br/>"; } CheckAllUsers(AdPlacementList.SelectedValue != "0.01", theID); //Clear cache so that the PlayerList.xml can be grabbed by the browser again. ClearCache(); Session["Message"] += "<br/>" + "Go to <a class=\"AddLink\" onclick=\"Search('" + dat.MakeNiceName(AdNameTextBox.THE_TEXT) + "_" + theID + "_Ad');\">your ad's</a> home page." + adFeatured + "<br/><br/> -<a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Type=A&ID=" + theID + "');\" >Rate </a>your user experience posting this venue.<br/>"; //MessageLiteral.Text = "<script type=\"text/javascript\">alert('" + message + "');</script>"; Encryption encrypt = new Encryption(); MessageRadWindow.NavigateUrl = "Message.aspx?message=" + encrypt.encrypt(Session["Message"].ToString() + "<br/><img onclick=\"Search('Home.aspx');\" onmouseover=\"this.src='image/DoneSonButtonSelected.png'\" onmouseout=\"this.src='image/DoneSonButton.png'\" src=\"image/DoneSonButton.png\"/>"); MessageRadWindow.Visible = true; MessageRadWindowManager.VisibleOnPageLoad = true; Session["categorySession"] = null; } else { MessagePanel.Visible = true; YourMessagesLabel.Text += "<br/><br/>You must agree to the terms and conditions."; } }
protected void PostIt(object sender, EventArgs e) { object appSeshCountry; object appSeshState; object appSeshCity; object appSeshZip; object appSeshRadius; HttpCookie cookie = Request.Cookies["BrowserDate"]; DateTime isn = DateTime.Now; if (!DateTime.TryParse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"), out isn)) isn = DateTime.Now; DateTime isNow = isn; Data dat = new Data(isn); string state = ""; AuthorizePayPal d = new AuthorizePayPal(); if (AgreeCheckBox.Checked) { bool chargeCard = false; SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString()); conn.Open(); //Add case for if Paypal is filled in... //Authorize Credit Card decimal price = 0.00M; bool goOn = false; string message = ""; string transactionID = ""; if (FeaturePanel.Visible && TotalLabel.Text.Trim() != "") { if (decimal.TryParse(TotalLabel.Text.Trim(), out price)) { if (price != 0.00M) { if (PaymentPanel.Visible) { if (FirstNameTextBox.Text.Trim() == "" || LastNameTextBoxtBox.Text.Trim() == "" || BillingStreetAddressTextBox.Text.Trim() == "" || BillingCityTextBox.Text.Trim() == "" || BillingZipCodeTextBox.Text.Trim() == "" || BillingStateTextBox.Text.Trim() == "" || CardNumberTextBox.Text.Trim() == "" || CSVTextBox.Text.Trim() == "") { goOn = false; Session["Featured"] = false; message = "Please fill in all of the billing information."; } else { goOn = false; Session["Featured"] = false; string country = dat.GetDataDV("SELECT country_2_code FROM Countries WHERE country_id=" + BillingCountry.SelectedValue)[0]["country_2_code"].ToString(); com.paypal.sdk.util.NVPCodec status = d.DoPayment("Authorization", TotalLabel.Text, CardTypeDropDown.SelectedValue, CardNumberTextBox.Text.Trim(), ExpirationMonth.SelectedItem.Text, ExpirationYear.SelectedItem.Text, CSVTextBox.Text.Trim(), FirstNameTextBox.Text.Trim(), LastNameTextBoxtBox.Text.Trim(), BillingStreetAddressTextBox.Text.Trim(), BillingCityTextBox.Text, BillingStateTextBox.Text, country, BillingZipCodeTextBox.Text.Trim(), dat.GetIP()); message = status.ToString(); string successORFailure = status["ACK"]; switch (successORFailure.ToLower()) { case "failure": goOn = false; Session["Featured"] = false; message = status["L_LONGMESSAGE0"]; break; case "successwithwarning": goOn = false; Session["Featured"] = false; message = status["L_SHORTMESSAGE0"]; if (message == "Transaction approved but with invalid CSC format.") message = "Your CVC/CSV format for this card is not valid."; break; case "success": transactionID = status["TRANSACTIONID"]; Session["TransID"] = transactionID; goOn = true; chargeCard = true; Session["Featured"] = true; break; default: goOn = false; Session["Featured"] = false; message = "There was an internal problem. Please contact support at: [email protected]. Please include as much detail as possible about what you are trying to do."; foreach (string key in status.Keys) { message += "key: " + key.ToString() + ", value: " + status[key].ToString() + "<br/>"; } break; } } } else { goOn = true; Session["Featured"] = true; } } else { if (SearchTermsListBox.Items.Count > 0 && price == 0.00M) { goOn = false; Session["Featured"] = false; message = "You have entered search terms, but, have not included any dates."; } else { goOn = true; Session["Featured"] = false; } } } else { goOn = true; Session["Featured"] = false; } } else { goOn = true; Session["Featured"] = false; } if (goOn) { bool isEdit = false; DateTime LastFetUpdate = DateTime.Now; if (Request.QueryString["edit"] != null) { isEdit = bool.Parse(Request.QueryString["edit"].ToString()); } string mediaCat = "0"; if (PictureCheckList.Items.Count > 0) mediaCat = "1"; string command = ""; DataSet dsEvent; bool wasFeatured = false; DataView dvRenu = new DataView(); if (isEdit) { dsEvent = dat.GetData("SELECT * FROM Ads WHERE Ad_ID=" + adID.Text); wasFeatured = bool.Parse(dsEvent.Tables[0].Rows[0]["Featured"].ToString()); LastFetUpdate = DateTime.Parse(dsEvent.Tables[0].Rows[0]["LastFetUpdate"].ToString()); //numViews = int.Parse(dsEvent.Tables[0].Rows[0]["NumViews"].ToString()); string rad = ""; //if (RadiusPanel.Visible) // rad = ", Radius=@radius "; dvRenu = dat.GetDataDV("SELECT * FROM Ads WHERE Ad_ID=" + adID.Text); command = "UPDATE Ads SET LastFetUpdate=@fetUpdate, DatesOfAd=@dates, Template=@template, hasSongs=@songs, User_ID=@userID, FeaturedSummary=@featuredSummary , " + "Description=@description, Featured=@featured, Header=@header, CountShown=@countShown, mediaCategory=" + mediaCat + ", " + "FeaturedPicture=@featuredPicture, FeaturedPictureName=@featuredPictureName, CatCountry=@catCountry, " + "CatState=@catState, CatCity=@catCity WHERE Ad_ID=" + adID.Text; } else { string rad = ""; string radEnd = ""; //if (RadiusPanel.Visible) //{ // rad = ", Radius "; // radEnd = ", @radius "; //} command = "INSERT INTO Ads (LastFetUpdate, DatesOfAd, Template, hasSongs, User_ID, FeaturedSummary ,Description, Header, " + "CountShown, Featured, mediaCategory, FeaturedPicture, FeaturedPictureName, CatCountry, CatState, CatCity, " + " DateAdded) " + " VALUES('" + DateTime.Now.ToString() + "', @dates, @template, @songs, @userID, @featuredSummary, @description, @header, @countShown, " + "@featured, " + mediaCat + ", @featuredPicture, @featuredPictureName, @catCountry, @catState, @catCity, '" + DateTime.Now.ToString() + "')"; } SqlCommand cmd = new SqlCommand(command, conn); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@description", SqlDbType.NVarChar).Value = DescriptionTextBox.Content; cmd.Parameters.Add("@userID", SqlDbType.Int).Value = int.Parse(Session["User"].ToString()); string fetDays = ""; bool newDates = false; foreach (ListItem item in FeatureDatesListBox.Items) { fetDays += ";" + item.Text + ";"; if (item.Value != "Disabled") newDates = true; } if (wasFeatured) { if (newDates) cmd.Parameters.Add("@fetUpdate", SqlDbType.DateTime).Value = DateTime.Now; else cmd.Parameters.Add("@fetUpdate", SqlDbType.DateTime).Value = LastFetUpdate; cmd.Parameters.Add("@featured", SqlDbType.Bit).Value = true; if (FeaturePanel.Visible) { cmd.Parameters.Add("@dates", SqlDbType.NVarChar).Value = fetDays; } else cmd.Parameters.Add("@dates", SqlDbType.NVarChar).Value = dvRenu[0]["DatesOfAd"].ToString(); } else { cmd.Parameters.Add("@fetUpdate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@featured", SqlDbType.Bit).Value = FeaturePanel.Visible; if (FeaturePanel.Visible) { cmd.Parameters.Add("@dates", SqlDbType.NVarChar).Value = fetDays; } else { cmd.Parameters.Add("@dates", SqlDbType.NVarChar).Value = DBNull.Value; } } if (FeaturePanel.Visible) { if (BannerAdCheckBox.Checked) { cmd.Parameters.Add("@template", SqlDbType.Int).Value = TemplateRadioList.SelectedValue; } else { cmd.Parameters.Add("@template", SqlDbType.Int).Value = 1; } } else { if (wasFeatured) cmd.Parameters.Add("@template", SqlDbType.Int).Value = dvRenu[0]["Template"].ToString(); else cmd.Parameters.Add("@template", SqlDbType.Int).Value = DBNull.Value; } cmd.Parameters.Add("@songs", SqlDbType.Bit).Value = false; if (FeaturePanel.Visible) cmd.Parameters.Add("@featuredSummary", SqlDbType.NVarChar).Value = SummaryTextBox.InnerHtml; else { if (wasFeatured) cmd.Parameters.Add("@featuredSummary", SqlDbType.NVarChar).Value = dvRenu[0]["FeaturedSummary"].ToString(); else cmd.Parameters.Add("@featuredSummary", SqlDbType.NVarChar).Value = DBNull.Value; } cmd.Parameters.Add("@header", SqlDbType.NVarChar).Value = AdNameTextBox.Text; cmd.Parameters.Add("@countShown", SqlDbType.Int).Value = 0; if (FeaturePanel.Visible) if (AdPictureCheckList.Items.Count > 0 && AdMediaPanel.Visible) { cmd.Parameters.Add("@featuredPicture", SqlDbType.NVarChar).Value = AdPictureCheckList.Items[0].Value; cmd.Parameters.Add("@featuredPictureName", SqlDbType.NVarChar).Value = AdPictureCheckList.Items[0].Text; } else { cmd.Parameters.Add("@featuredPicture", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@featuredPictureName", SqlDbType.NVarChar).Value = DBNull.Value; } else { if (wasFeatured) { cmd.Parameters.Add("@featuredPicture", SqlDbType.NVarChar).Value = dvRenu[0]["FeaturedPicture"].ToString(); cmd.Parameters.Add("@featuredPictureName", SqlDbType.NVarChar).Value = dvRenu[0]["FeaturedPictureName"].ToString(); } else { cmd.Parameters.Add("@featuredPicture", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@featuredPictureName", SqlDbType.NVarChar).Value = DBNull.Value; } } if (CountryDropDown.SelectedIndex != -1) { appSeshCountry = CountryDropDown.SelectedValue; cmd.Parameters.Add("@catCountry", SqlDbType.Int).Value = CountryDropDown.SelectedValue; if (StateDropDownPanel.Visible) { if (StateDropDown.SelectedIndex != -1) state = StateDropDown.SelectedItem.Text; } else state = StateTextBox.Text; appSeshState = state; if (state != "") cmd.Parameters.Add("@catState", SqlDbType.NVarChar).Value = state; else cmd.Parameters.Add("@catState", SqlDbType.NVarChar).Value = DBNull.Value; string city = ""; if (CityDropDownPanel.Visible) city = MajorCityDrop.SelectedItem.Text; else city = CityTextBox.Text; appSeshCity = city; cmd.Parameters.Add("@catCity", SqlDbType.NVarChar).Value = city; } else { cmd.Parameters.Add("@catCountry", SqlDbType.Int).Value = DBNull.Value; cmd.Parameters.Add("@catState", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@catCity", SqlDbType.NVarChar).Value = DBNull.Value; } //Media Categories: NONE: 0, Slider: 1. bool isSlider = false; if (PictureCheckList.Items.Count > 0) isSlider = true; cmd.ExecuteNonQuery(); cmd = new SqlCommand("SELECT @@IDENTITY AS ID", conn); SqlDataAdapter da2 = new SqlDataAdapter(cmd); DataSet ds3 = new DataSet(); da2.Fill(ds3); string ID = ds3.Tables[0].Rows[0]["ID"].ToString(); if (isEdit) ID = Request.QueryString["ID"].ToString(); #region Take care of search terms if (FeaturePanel.Visible) { string terms = ""; foreach (ListItem item in SearchTermsListBox.Items) { terms += ";" + item.Text + ";"; } foreach (ListItem item in FeatureDatesListBox.Items) { if (item.Value != "Disabled") dat.Execute("INSERT INTO AdSearchTerms (AdID, SearchTerms, SearchDate) VALUES(" + ID + ", '" + terms.Replace("'", "''") + "', '" + item.Text + "')"); } } #endregion string theID = ID; if (isEdit) { theID = adID.Text; } //if (MusicCheckBox.Checked) //{ // if (isEdit) // { // dat.Execute("DELETE FROM Ad_Song_Mapping WHERE AdID="+theID); // } // for (int i = 0; i < SongCheckList.Items.Count; i++) // { // cmd = new SqlCommand("INSERT INTO Ad_Song_Mapping (AdID, SongName, SongTitle) "+ // "VALUES(@eventID, @songName, @songTitle)", conn); // cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = int.Parse(theID); // cmd.Parameters.Add("@songName", SqlDbType.NVarChar).Value = SongCheckList.Items[i].Value.ToString(); // cmd.Parameters.Add("@songTitle", SqlDbType.NVarChar).Value = SongCheckList.Items[i].Text; // cmd.ExecuteNonQuery(); // dat.Execute("UPDATE Ads SET hasSongs=1 WHERE Ad_ID="+theID); // } //} if (isEdit) { dat.Execute("DELETE FROM Ad_Slider_Mapping WHERE AdID=" + theID); } if (MainAttractionCheck.Checked) { if (isSlider) { char[] delim2 = { '\\' }; string[] fileArray = System.IO.Directory.GetFiles(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\"); if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles")) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID); } else { if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\")) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\" + theID); } else { if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider")) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID); } else { if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID)) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID); } } } } string YouTubeStr = ""; char[] delim3 = { '.' }; for (int i = 0; i < PictureCheckList.Items.Count; i++) { int length = fileArray[i].Split(delim2).Length; string[] tokens = PictureCheckList.Items[i].Value.ToString().Split(delim3); if (tokens.Length >= 2) { if (tokens[1].ToUpper() == "JPG" || tokens[1].ToUpper() == "JPEG" || tokens[1].ToUpper() == "GIF" || tokens[1].ToUpper() == "PNG") { if (!System.IO.File.Exists(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID + "\\" + PictureCheckList.Items[i].Value)) { System.IO.File.Copy(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + PictureCheckList.Items[i].Value, MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + "\\AdSlider\\" + theID + "\\" + PictureCheckList.Items[i].Value); } cmd = new SqlCommand("INSERT INTO Ad_Slider_Mapping (AdID, PictureName, RealPictureName) " + "VALUES (@eventID, @picName, @realName)", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = theID; cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Value; cmd.Parameters.Add("@realName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Text; cmd.ExecuteNonQuery(); } } else { YouTubeStr += PictureCheckList.Items[i].Value + ";"; } } //if (YouTubeStr != "") //{ dat.Execute("UPDATE Ads SET YouTubeVideo='" + YouTubeStr + "' WHERE Ad_ID=" + theID); //} } } else { } if (isEdit) { dat.Execute("DELETE FROM Ad_Category_Mapping WHERE AdID=" + theID); } CreateCategories(theID); string adFeatured = ""; string adFeaturedEmail = ""; DataSet dsUser = dat.GetData("SELECT Email, UserName FROM USERS WHERE User_ID=" + Session["User"].ToString()); try { bool showMessage = false; if (chargeCard) { Encryption encrypt = new Encryption(); //Charge Card string country = dat.GetDataDV("SELECT country_2_code FROM Countries WHERE country_id=" + BillingCountry.SelectedValue)[0]["country_2_code"].ToString(); com.paypal.sdk.util.NVPCodec status = d.DoCaptureCode(transactionID, price.ToString(), "B" + theID + isn.ToString(), "Capture Transaction for Featuring Bulletin '" + dat.MakeNiceNameFull(AdNameTextBox.Text) + "'"); //message = status.ToString(); string successORFailure = status["ACK"]; switch (successORFailure.ToLower()) { case "failure": MessagePanel.Visible = true; YourMessagesLabel.Text += status["L_LONGMESSAGE0"]; //MessagePanel.Visible = true; //foreach (string key in status.Keys) //{ // YourMessagesLabel.Text += "key: '" + key + "', value: '" + status[key] + "' <br/>"; //} break; case "success": showMessage = true; break; default: MessagePanel.Visible = true; foreach (string key in status.Keys) { YourMessagesLabel.Text += "key: '" + key + "', value: '" + status[key] + "' <br/>"; } break; } } else { showMessage = true; } if (showMessage) { string emailBody = "Dear " + dsUser.Tables[0].Rows[0]["UserName"].ToString() + ", <br/><br/> you have successfully posted the bulletin \"" + AdNameTextBox.Text + "\". <br/><br/> You can find this bulletin <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(AdNameTextBox.Text) + "_" + theID + "_Ad\">here</a>. " + adFeaturedEmail + "<br/><br/> To rate your experience posting this bulletin <a href=\"http://hippohappenings.com/RateExperience.aspx?Type=A&ID=" + theID + "\">please include your feedback here.</a>" + "<br/><br/><br/>Have a HippoHappening Day!<br/><br/>"; if (isEdit) { emailBody = "Dear " + dsUser.Tables[0].Rows[0]["UserName"].ToString() + ", <br/><br/> you have successfully edited the bulletin \"" + AdNameTextBox.Text + "\". <br/><br/> You can find this bulletin <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(AdNameTextBox.Text) + "_" + theID + "_Ad\">here</a>. " + adFeaturedEmail + "<br/><br/> To rate your experience editing this bulletin <a href=\"http://hippohappenings.com/RateExperience.aspx?Type=A&ID=" + theID + "\">please include your feedback here.</a>" + "<br/><br/><br/>Have a HippoHappening Day!<br/><br/>"; } if (!Request.IsLocal) { dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(), System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(), dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "You have successfully posted the bulletin: " + AdNameTextBox.Text); } conn.Close(); Session["Message"] = "Your bulletin has been posted successfully!<br/> Here are your next steps: <br/>"; if (isEdit) { Session["Message"] = "Your bulletin has been edited successfully!<br/> Here are your next steps: <br/>"; } //Clear cache so that the PlayerList.xml can be grabbed by the browser again. ClearCache(); Session["Message"] += "<br/>" + "Go to <a class=\"AddLink\" onclick=\"Search('" + dat.MakeNiceName(AdNameTextBox.Text) + "_" + theID + "_Ad');\">your bulletin's</a> home page." + adFeatured + "<br/><br/> -<a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Type=A&ID=" + theID + "');\" >Rate </a>your user experience posting this bulletin.<br/>"; //MessageLiteral.Text = "<script type=\"text/javascript\">alert('" + message + "');</script>"; Encryption encrypt = new Encryption(); MessageRadWindow.NavigateUrl = "Message.aspx?message=" + encrypt.encrypt(Session["Message"].ToString() + "<br/><br/><div align=\"center\">" + "<div style=\"width: 50px;\" onclick=\"Search('home')\">" + "<div class=\"topDiv\" style=\"clear: both;\">" + " <img style=\"float: left;\" src=\"NewImages/ButtonLeft.png\" height=\"27px\" /> " + " <div class=\"NavyLink\" style=\"font-size: 12px; text-decoration: none; padding-top: 5px;padding-left: 6px; padding-right: 6px;height: 27px;float: left;background: url('NewImages/ButtonPixel.png'); background-repeat: repeat-x;\">" + " OK " + "</div>" + " <img style=\"float: left;\" src=\"NewImages/ButtonRight.png\" height=\"27px\" /> " + "</div>" + "</div>" + "</div><br/>"); MessageRadWindow.Visible = true; MessageRadWindowManager.VisibleOnPageLoad = true; Session["categorySession"] = null; } } catch (Exception ex) { MessagePanel.Visible = true; YourMessagesLabel.Text += ex.ToString(); } } else { MessagePanel.Visible = true; YourMessagesLabel.Text = message; } } else { MessagePanel.Visible = true; YourMessagesLabel.Text += "You must agree to the terms and conditions."; } }
protected bool OnwardsIT(bool changeTab, int selectedIndex) { HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString()); conn.Open(); switch (selectedIndex) { case 0: #region Case 0 bool goOn = false; bool isInternational = false; string locationStr = ""; VenueNameTextBox.THE_TEXT = dat.stripHTML(VenueNameTextBox.THE_TEXT); CityTextBox.Text = dat.stripHTML(CityTextBox.Text); ZipTextBox.Text = dat.stripHTML(ZipTextBox.Text); if (CountryDropDown.SelectedValue == "223") { isInternational = true; string apt = ""; if(AptNumberTextBox.Text.Trim() != "") apt = AptDropDown.SelectedItem.Text + " " + AptNumberTextBox.Text.Trim().ToLower(); locationStr = StreetNumberTextBox.Text.Trim().ToLower() + ";" + StreetNameTextBox.Text.Trim().ToLower() + ";" + StreetDropDown.SelectedItem.Text + ";" + apt; goOn = VenueNameTextBox.THE_TEXT.Trim() != "" && StreetNumberTextBox.Text.Trim() != "" && StreetNameTextBox.Text.Trim() != "" && StreetDropDown.SelectedItem.Text != "Select One..." && CityTextBox.Text.Trim() != "" && ZipTextBox.Text.Trim() != ""; } else { string apt = ""; if (AptNumberTextBox.Text.Trim() != "") apt = AptDropDown.SelectedItem.Text + " " + AptNumberTextBox.Text.Trim().ToLower(); locationStr = LocationTextBox.Text.Trim().ToLower() + ";" + apt; goOn = VenueNameTextBox.THE_TEXT.Trim() != "" && LocationTextBox.Text.Trim() != "" && CityTextBox.Text.Trim() != "" && ZipTextBox.Text.Trim() != ""; } if (goOn) { bool isUpdate = false; if (Request.QueryString["ID"] != null) { isUpdate = true; } if (EmailTextBox.Text.Trim() != "") { if (!dat.ValidateEmail(EmailTextBox.Text)) { MessagePanel.Visible = true; YourMessagesLabel.Text += "<br/><br/>*Email address is not in the appropriate format."; goOn = false; } } if (CountryDropDown.SelectedValue == "223") { int zip = 0; if (int.TryParse(ZipTextBox.Text.Trim(), out zip)) { if (ZipTextBox.Text.Trim().Length == 5) { } else { MessagePanel.Visible = true; YourMessagesLabel.Text += "<br/><br/>*Zip must be a 5 digit code."; goOn = false; } } else { MessagePanel.Visible = true; YourMessagesLabel.Text += "<br/><br/>*Zip must be a 5 digit code."; goOn = false; } } if (StateDropDown.Visible) { if (StateDropDown.SelectedIndex == -1) { MessagePanel.Visible = true; YourMessagesLabel.Text += "<br/><br/>*Must include state."; goOn = false; } } else { if (StateTextBox.THE_TEXT.Trim() == "") { MessagePanel.Visible = true; YourMessagesLabel.Text += "<br/><br/>*Must include state."; goOn = false; } } if (!isUpdate && goOn) { string state = ""; if (StateDropDownPanel.Visible) state = StateDropDown.SelectedItem.Text; else state = StateTextBox.THE_TEXT; SqlCommand cmd = new SqlCommand("SELECT * FROM Venues WHERE Address=@address AND City=@city AND State=@state", conn); cmd.Parameters.Add("@address", SqlDbType.NVarChar).Value = locationStr; cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = CityTextBox.Text.Trim().ToLower(); cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = state; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); if (ds.Tables.Count > 0) if (ds.Tables[0].Rows.Count > 0) { MessagePanel.Visible = true; YourMessagesLabel.Text += "<br/><br/>A venue already exists under this address. " + "Please take a look at it " + "<a target=\"_blank\" class=\"AddGreenLink\" href=\"" + dat.MakeNiceName(VenueNameTextBox.THE_TEXT) + "_" + ds.Tables[0].Rows[0]["ID"].ToString() + "_Venue\">here.</a> You can submit edits to the existing venue by licking on the 'Edit Venue' link at the top of the venue page."; goOn = false; } } if (goOn) { if(changeTab) ChangeSelectedTab(0, 1); FillLiteral(); return true; } else { return false; } } else { MessagePanel.Visible = true; YourMessagesLabel.Text += "<br/><br/>*Please fill in all fields."; } return false; #endregion break; case 1: DescriptionTextBox.Content = dat.StripHTML_LeaveLinks(DescriptionTextBox.Content.Replace("<div>", "<br/>").Replace("</div>", "")); if (DescriptionTextBox.Text.Length >= 50) { if(changeTab) ChangeSelectedTab(1, 2); FillLiteral(); return true; } else { MessagePanel.Visible = true; YourMessagesLabel.Text += "<br/><br/>*Make sure you say what you want your viewers to hear about this venue! The description must be at least 50 characters."; return false; } break; case 2: if(Session["CategoriesSet"] == null && Request.QueryString["ID"] != null) SetCategories(); if (changeTab) { ChangeSelectedTab(2, 3); } FillLiteral(); return true; break; case 3: if (CategorySelected()) { FillLiteral(); bool isownerupforgrabs = false; EnableOwnerPanel(ref isownerupforgrabs); if(changeTab) ChangeSelectedTab(3, 4); return true; } else { MessagePanel.Visible = true; YourMessagesLabel.Text = "Must include at least one category."; return false; } break; default: break; } return false; }
protected void Page_Load(object sender, EventArgs e) { HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); if (IsPostBack) { MessageRadWindowManager.VisibleOnPageLoad = false; } //take care of mapping to the search map if (searchNumber != "") { string markerNumber = dat.GetImageNum(searchNumber); // (int.Parse(dat.GetImageNum(searchNumber)) + numofallresults).ToString(); ImageLiteral.Text = imageLiteral + "<div style=\"float: left;\"><img style=\"cursor: pointer;\" onclick=\"selectFirstTab();myclick(" + markerNumber + ");\" id='image" + searchNumber + "' src=" + "\"http://www.google.com/mapfiles/marker" + searchNumber + ".png\" /></div>"; //SearchLiteral.Text += "<script type=\"text/javascript\">var letter = String.fromCharCode(\"A\".charCodeAt(0) + " + // searchNumber + "); var letteredIcon = new GIcon(baseIcon); document.getElementById('image" + searchNumber + // "').src = \"http://www.google.com/mapfiles/marker\" + letter + \".png\";</script>"; BeginingLiteral.Text = "<div style=\"margin-bottom: 3px;background-color:" + color + "; width: " + width.ToString() + "px; min-height: 33px; padding: 3px;\">"; } else { BeginingLiteral.Text = "<div style=\"margin-bottom: 3px;background-color:" + color + "; width: " + width.ToString() + "px;padding: 3px;\">"; } if (calendarLetter != "") { ImageLiteral.Text += "<div onclick=\"selectCalendarDate('"+firstDate+"', '"+toolTipID+"');\" align=\"center\" style=\"cursor: pointer;margin-right: 3px;margin-left: 5px; margin-top: 6px;font-weight: bold;width: 20px; height: 14px;color: #1b1b1b;font-size: " + "10px; padding-top: 6px;float: left; background-image: url(images/CalendarIcon.png);" + "\">" + calendarLetter + "</div>"; } if (isGroup) { ImageLiteral.Text += "<div style=\"float: left; height: 30px; margin-top: -4px\"><img height=\"40px\" title=\"Group Event\" " + "name=\"Group Event\" src=\"images/GroupsIcon2.png\" /></div>"; } //search = true is disabled here SearchLabel.Text = searchLabel; if (venueLabel.Trim() != "") VenueLabel.Text = venueLabel; else { VenueRealLabel.Text = address; VenueRealLabel.Style.Add("color", "#cccccc"); VenueRealLabel.Style.Add("font-weight", "normal"); VenueRealLabel.Style.Add("pointer", "default"); VenueRealLabel.Style.Add("font-family", "Arial"); VenueRealLabel.Style.Add("font-size", "12px"); } if (windowT) { if (isGroup) SearchLabel.Attributes.Add("onclick", "CloseWindow('" + "../" + dat.MakeNiceName(searchLabel) + "_" + reoccurrID + "_" + eventID + "_GroupEvent" + "');"); else SearchLabel.Attributes.Add("onclick", "CloseWindow('" + "../" + dat.MakeNiceName(searchLabel) + "_" + eventID + "_Event" + "');"); if (venueLabel.Trim() != "") VenueLabel.Attributes.Add("onclick", "CloseWindow('" + "../" + dat.MakeNiceName(venueLabel) + "_" + venueID + "_Venue" + "');"); } else { if (isGroup) SearchLabel.NavigateUrl = "../" + dat.MakeNiceName(searchLabel) + "_" + reoccurrID + "_" + eventID + "_GroupEvent"; else SearchLabel.NavigateUrl = "../" + dat.MakeNiceName(searchLabel) + "_" + eventID + "_Event"; if (venueLabel.Trim() != "") VenueLabel.NavigateUrl = "../" + dat.MakeNiceName(venueLabel) + "_" + venueID + "_Venue"; } //if(numLabel != "") // NumLabel.Text = numLabel; DateLabel.Text = datelabel; string begining = "<a style=\"color: #b1a812; font-family: Arial; font-size: 11px;\">"; string end = "</a>"; string tags = ""; if (isGroup) { dat.TAG_TYPE = Data.tagType.GROUP_EVENT; DataSet ds1 = dat.GetData("SELECT DISTINCT C.ID, C.GroupName AS CategoryName, '22px' AS tagSize FROM GroupEvent_Category VC, GroupCategories C WHERE C.ID=VC.CATEGORY_ID AND VC.GROUPEVENT_ID=" + eventID); tags = dat.getTags(ds1, false, windowT); } else { dat.TAG_TYPE = Data.tagType.EVENT; tags = dat.getTags(dat.GetData("SELECT C.ID, C.Name AS CategoryName, ECM.tagSize FROM Event_Category_Mapping ECM, EventCategories C WHERE ECM.CategoryID=C.ID AND ECM.EventID=" + eventID), false, windowT); DataSet ds = dat.GetData("SELECT ShortDescription FROM Events WHERE ID=" + eventID); //ShortDescriptionLabel.Text = dat.BreakUpString(ds.Tables[0].Rows[0]["ShortDescription"].ToString(), 300); } //if (Session["User"] != null && !isGroup) //{ // dat.GetRecommendationIcons(eventID.ToString(), ref RecomPanel); //} TagsLiteral.Text = "<span style=\"color: #b1a812; line-height: 10px; font-size: 11px;\" >" + tags + "</span>"; if (isConnectTo) { ConnectImageButton.Visible = true; } }