protected void GetCategoriesFromNode(bool isUpdate, bool isOwner, Telerik.Web.UI.RadTreeNode TreeNode, DataView dvCat, string ID, string revisionID) { HttpCookie cookie = Request.Cookies["BrowserDate"]; Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"))); string ownerID = ""; bool isOwnerUpForGrabs = dat.IsOwnerUpForGrabs(ID, ref ownerID, ref isOwner, true); if (TreeNode.Checked && TreeNode.Enabled) { dvCat.RowFilter = "CATEGORY_ID=" + TreeNode.Value; //distinctHash.Add(CategoriesCheckBoxes.Items[i], 21); //tagHash.Add(CategoriesCheckBoxes.Items[i], "22"); if (isUpdate) { if (isOwner || isOwnerUpForGrabs) { if (dvCat.Count == 0) { dat.Execute("INSERT INTO Venue_Category (VENUE_ID, CATEGORY_ID, tagSize) VALUES(" + ID + ", " + TreeNode.Value + ", 22)"); } } else { if (dvCat.Count == 0) { dat.Execute("INSERT INTO VenueCategoryRevisions (AddOrRemove, VenueID, CatID, modifierID, RevisionID, DATE) " + "VALUES(1, " + ID + ", " + TreeNode.Value + ", " + Session["User"].ToString() + ", " + revisionID + ", '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")) + "')"); } else { //dat.Execute("INSERT INTO VenueCategoryRevisions (AddOrRemove, VenueID, CatID, modifierID, RevisionID) " + // "VALUES(0, " + ID + ", " + CategoryTree.Nodes[i].Value + ", " + Session["User"].ToString() + ", " + revisionID + ")"); } } } else { dat.Execute("INSERT INTO Venue_Category (VENUE_ID, CATEGORY_ID, tagSize) VALUES(" + ID + ", " + TreeNode.Value + ", 22)"); } } else if (!TreeNode.Checked) { dvCat.RowFilter = "CATEGORY_ID=" + TreeNode.Value; if (isUpdate) { if (isOwner || isOwnerUpForGrabs) { if (dvCat.Count == 0) { } else { dat.Execute("DELETE FROM Venue_Category WHERE VENUE_ID=" + ID + " AND CATEGORY_ID = " + TreeNode.Value); } } else { if (dvCat.Count == 0) { } else { if (isOwnerUpForGrabs) { dat.Execute("DELETE FROM Venue_Category WHERE VENUE_ID=" + ID + " AND CATEGORY_ID = " + TreeNode.Value); } else { dat.Execute("INSERT INTO VenueCategoryRevisions (AddOrRemove, VenueID, CatID, modifierID, RevisionID, DATE) " + "VALUES(0, " + ID + ", " + TreeNode.Value + ", " + Session["User"].ToString() + ", " + revisionID + ", '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")) + "')"); } } } } else { } } if (TreeNode.Nodes.Count > 0) { for (int j = 0; j < TreeNode.Nodes.Count; j++) { GetCategoriesFromNode(isUpdate, isOwner, TreeNode.Nodes[j], dvCat, ID, revisionID); } } }
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 GetCategoriesFromNode(bool isUpdate, bool isOwner, Telerik.Web.UI.RadTreeNode TreeNode, DataView dvCat, string ID, string revisionID) { 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 ownerID = ""; string categories = ""; bool isOwnerUpForGrabs = dat.IsOwnerUpForGrabs(ID, ref ownerID, ref isOwner, false); if (TreeNode.Checked && TreeNode.Enabled) { dvCat.RowFilter = "CategoryID=" + TreeNode.Value; //distinctHash.Add(CategoriesCheckBoxes.Items[i], 21); //tagHash.Add(CategoriesCheckBoxes.Items[i], "22"); if (isUpdate) { if (isOwner || isOwnerUpForGrabs) { if (dvCat.Count == 0) { dat.Execute("INSERT INTO Event_Category_Mapping (CategoryID, EventID, tagSize) VALUES(" + TreeNode.Value + "," + ID + ", 22)"); if (categories != "") categories += " OR "; categories += " UC.CategoryID=" + TreeNode.Value; } } else { if (dvCat.Count == 0) { string command22 = "INSERT INTO EventCategoryRevisions (AddOrRemove, EventID, CatID, modifierID, RevisionID, DATE) " + "VALUES(1, " + ID + ", " + TreeNode.Value + ", " + Session["User"].ToString() + ", " + revisionID + ", '" + isn + "')"; Session["command"] = command22; dat.Execute(command22); } else { //This case is unnecessary since if the Node is checked and it exists for this event, we don't need to do anything //dat.Execute("INSERT INTO VenueCategoryRevisions (AddOrRemove, VenueID, CatID, modifierID, RevisionID) " + // "VALUES(0, " + ID + ", " + CategoryTree.Nodes[i].Value + ", " + Session["User"].ToString() + ", " + revisionID + ")"); } } } else { dat.Execute("INSERT INTO Event_Category_Mapping (CategoryID, EventID, tagSize) VALUES(" + TreeNode.Value + "," + ID + ", 22)"); if (categories != "") categories += " OR "; categories += " UC.CategoryID=" + TreeNode.Value; } } else if (!TreeNode.Checked) { dvCat.RowFilter = "CategoryID=" + TreeNode.Value; if (isUpdate) { if (isOwner || isOwnerUpForGrabs) { if (dvCat.Count == 0) { } else { dat.Execute("DELETE FROM Event_Category_Mapping WHERE EventID=" + ID + " AND CategoryID = " + TreeNode.Value); } } else { if (dvCat.Count == 0) { } else { if (isOwnerUpForGrabs) { dat.Execute("DELETE FROM Event_Category_Mapping WHERE EventID=" + ID + " AND CategoryID = " + TreeNode.Value); } else { dat.Execute("INSERT INTO EventCategoryRevisions (AddOrRemove, EventID, CatID, modifierID, RevisionID, DATE) " + "VALUES(0, " + ID + ", " + TreeNode.Value + ", " + Session["User"].ToString() + ", " + revisionID + ", '" + isn.ToString() + "')"); } } } } else { } } if (TreeNode.Nodes.Count > 0) { for (int j = 0; j < TreeNode.Nodes.Count; j++) { GetCategoriesFromNode(isUpdate, isOwner, TreeNode.Nodes[j], dvCat, ID, revisionID); } } return categories; }
protected void PostIt(object sender, EventArgs e) { MessagePanel.Visible = false; YourMessagesLabel.Text = ""; string problem = ""; bool hasEditChanged = false; bool chargeCard = false; AuthorizePayPal d = new AuthorizePayPal(); 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 email = ""; try { if (OnwardsIT()) { //Add case for if Paypal is filled in... //Authorize Credit Card bool goOn = false; string message = ""; decimal price = 0.00M; string transactionID = ""; if (AgreeCheckBox.Checked) { if (TotalLabel.Text.Trim() != "") { if (decimal.TryParse(TotalLabel.Text.Trim(), out price)) { if (price != 0.00M) { 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": chargeCard = true; transactionID = status["TRANSACTIONID"]; Session["TransID"] = transactionID; goOn = 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["Featrued"] = false; } } else { goOn = true; Session["Featured"] = false; } } else { goOn = true; Session["Featured"] = false; } if (goOn) { string textEmail = ""; SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString()); conn.Open(); string mediaCat = "0"; if (PictureCheckList.Items.Count > 0) mediaCat = "1"; bool isOwner = false; string ownerID = ""; bool ownerUpForGrabs = false; bool wasFeatured = false; bool isEditing = false; if (isEdit.Text != "") { isEditing = bool.Parse(isEdit.Text); ownerUpForGrabs = dat.IsOwnerUpForGrabs(Request.QueryString["ID"].ToString(), ref ownerID, ref isOwner, false); } bool hadSongs = false; DataSet dsEvent = new DataSet(); DataView dvEvent = new DataView(); string theCat = "NULL"; if (isEditing) { dsEvent = dat.GetData("SELECT * FROM Events WHERE ID=" + eventID.Text); dvEvent = dat.GetDataDV("SELECT * FROM Events WHERE ID=" + eventID.Text); wasFeatured = bool.Parse(dsEvent.Tables[0].Rows[0]["Featured"].ToString()); hadSongs = bool.Parse(dsEvent.Tables[0].Rows[0]["hasSongs"].ToString()); if (dsEvent.Tables[0].Rows[0]["MediaCategory"].ToString() != mediaCat) { theCat = mediaCat; hasEditChanged = true; } } string addAdressBeg = ""; string addAddressEnd = ""; string addAddressUpdate = ""; string privInsertBeg = ", Private "; string privInsertEnd = ", 'False' "; string privUpdate = ", Private = 'False' "; if (LocaleRadioButtonList.SelectedValue == "1") { addAdressBeg = ", Address "; addAddressEnd = ", @address"; addAddressUpdate = ", Address = @address "; privInsertBeg = ", Private "; privInsertEnd = ", 'True' "; privUpdate = ", Private = 'True' "; } string command = ""; if (isEditing) { if (isOwner || ownerUpForGrabs) { string sngs = ""; if (!hadSongs) sngs = "hasSongs=@songs,"; command = "UPDATE Events SET DaysFeatured=@daysFet, " + addAddressUpdate + privUpdate + "Featured=@fet, MinPrice=@min, MaxPrice=@max, Owner=@owner, [Content]=@content, Header=@header, " + "Venue=@venue,SponsorPresenter=@sponsor, " + sngs + " mediaCategory=" + mediaCat + ", " + "ShortDescription=@shortDescription, Country=@country, State=@state, " + "Zip=@zip, City=@city, LastEditOn=@dateP WHERE ID=" + Request.QueryString["ID"].ToString(); } else { command = "INSERT INTO EventRevisions (DaysFeatured," + addAdressBeg + privInsertBeg + "Featured,MinPrice, MaxPrice, EventID, [Content], " + "Header, Venue, modifierID, " + "ShortDescription, Country, State, Zip, City, DATE)" + " VALUES(@daysFet, " + addAddressEnd + privInsertEnd + "@fet,@min, @max, " + eventID.Text + ", @content,@header, @venue, @userName, @shortDescription" + ", @country, @state, @zip, @city, '" + isn.ToString() + "')"; dsEvent = dat.GetData("SELECT * FROM Events WHERE ID=" + eventID.Text); } } else { command = "INSERT INTO Events (DaysFeatured" + addAdressBeg + privInsertBeg + ", Featured,MinPrice, MaxPrice, Owner, [Content], " + "Header, Venue, EventGoersCount, SponsorPresenter, hasSongs, mediaCategory, UserName, " + "ShortDescription, Country, State, Zip, City, StarRating, PostedOn, LastEditOn)" + " VALUES(@daysFet" + addAddressEnd + privInsertEnd + ", @fet, @min, @max, @owner, @content, @header, @venue, " + " @eventGoers, @sponsor, @songs, " + mediaCat + ", @userName, @shortDescription" + ", @country, @state, @zip, @city, 0, @dateP, @dateP)"; } SqlCommand cmd = new SqlCommand(command, conn); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@dateP", SqlDbType.DateTime).Value = DateTime.Now; string fetDays = ""; foreach (ListItem item in FeatureDatesListBox.Items) { fetDays += ";" + item.Text + ";"; } if (wasFeatured) { cmd.Parameters.Add("@fet", SqlDbType.Bit).Value = true; if (FeaturePanel.Visible) { cmd.Parameters.Add("@daysFet", SqlDbType.NVarChar).Value = fetDays; } else cmd.Parameters.Add("@daysFet", SqlDbType.NVarChar).Value = dvEvent[0]["DaysFeatured"].ToString(); } else { cmd.Parameters.Add("@fet", SqlDbType.Bit).Value = FeaturePanel.Visible; if (FeaturePanel.Visible) { cmd.Parameters.Add("@daysFet", SqlDbType.NVarChar).Value = fetDays; } else { cmd.Parameters.Add("@daysFet", SqlDbType.NVarChar).Value = DBNull.Value; } } if (MinTextBox.Text.Trim() != "") { cmd.Parameters.Add("@min", SqlDbType.Decimal).Value = decimal.Parse(MinTextBox.Text.Trim()); } else { cmd.Parameters.Add("@min", SqlDbType.Decimal).Value = DBNull.Value; } if (MaxTextBox.Text.Trim() != "") { cmd.Parameters.Add("@max", SqlDbType.Decimal).Value = decimal.Parse(MaxTextBox.Text.Trim()); } else { cmd.Parameters.Add("@max", SqlDbType.Decimal).Value = DBNull.Value; } if (isEditing && !isOwner) { if (ownerUpForGrabs) { if (OwnerCheckBox.Checked) { hasEditChanged = true; cmd.Parameters.Add("@owner", SqlDbType.Int).Value = Session["User"].ToString(); dat.Execute("INSERT INTO EventOwnerHistory (EventID, OwnerID, DateCreatedOwnership) " + "VALUES(" + eventID.Text + ", " + Session["User"].ToString() + ", '" + isn.ToString() + "')"); } else { if (ownerUpForGrabs) { cmd.Parameters.Add("@owner", SqlDbType.Int).Value = DBNull.Value; } } } else { } if (dsEvent.Tables[0].Rows[0]["Content"].ToString() != DescriptionTextBox.Content) { cmd.Parameters.Add("@content", SqlDbType.NVarChar).Value = DescriptionTextBox.Content; hasEditChanged = true; } else { if (ownerUpForGrabs) { cmd.Parameters.Add("@content", SqlDbType.NVarChar).Value = dsEvent.Tables[0].Rows[0]["Content"].ToString(); } else { cmd.Parameters.Add("@content", SqlDbType.NVarChar).Value = DBNull.Value; } } if (dsEvent.Tables[0].Rows[0]["Header"].ToString() != EventNameTextBox.Text) { cmd.Parameters.Add("@header", SqlDbType.NVarChar).Value = EventNameTextBox.Text; hasEditChanged = true; } else { if (ownerUpForGrabs) { hasEditChanged = true; cmd.Parameters.Add("@header", SqlDbType.NVarChar).Value = dsEvent.Tables[0].Rows[0]["Header"].ToString(); } else { cmd.Parameters.Add("@header", SqlDbType.NVarChar).Value = DBNull.Value; } } string shortDesc = DescriptionTextBox.Text; if (shortDesc.Length > 150) shortDesc = shortDesc.Substring(0, 150); if (dsEvent.Tables[0].Rows[0]["ShortDescription"].ToString() != shortDesc) { cmd.Parameters.Add("@shortDescription", SqlDbType.NVarChar).Value = shortDesc; hasEditChanged = true; } else { if (ownerUpForGrabs) { cmd.Parameters.Add("@shortDescription", SqlDbType.NVarChar).Value = dsEvent.Tables[0].Rows[0]["ShortDescription"].ToString(); hasEditChanged = true; } else { cmd.Parameters.Add("@shortDescription", SqlDbType.NVarChar).Value = DBNull.Value; } } //users that are not the owner are not allowed to delete songs or other media //therefore, users can only change the state of 'hasSongs' to 'true', never to 'false' if (ownerUpForGrabs && MusicCheckBox.Checked) { cmd.Parameters.Add("@songs", SqlDbType.Bit).Value = MusicCheckBox.Checked; hasEditChanged = true; } else { cmd.Parameters.Add("@songs", SqlDbType.Bit).Value = dsEvent.Tables[0].Rows[0]["hasSongs"].ToString(); } cmd.Parameters.Add("@sponsor", SqlDbType.NVarChar).Value = DBNull.Value; } else { string shortDesc = DescriptionTextBox.Text; if (shortDesc.Length > 150) shortDesc = shortDesc.Substring(0, 150); hasEditChanged = true; cmd.Parameters.Add("@content", SqlDbType.NVarChar).Value = DescriptionTextBox.Content; cmd.Parameters.Add("@header", SqlDbType.NVarChar).Value = EventNameTextBox.Text; cmd.Parameters.Add("@shortDescription", SqlDbType.NVarChar).Value = shortDesc; cmd.Parameters.Add("@songs", SqlDbType.Bit).Value = MusicCheckBox.Checked; if (!isEditing) { cmd.Parameters.Add("@rating", SqlDbType.Int).Value = 0; cmd.Parameters.Add("@userName", SqlDbType.NVarChar).Value = Session["UserName"].ToString(); cmd.Parameters.Add("@eventGoers", SqlDbType.Int).Value = 0; if (OwnerCheckBox.Checked) { cmd.Parameters.Add("@owner", SqlDbType.Int).Value = Session["User"].ToString(); } else { cmd.Parameters.Add("@owner", SqlDbType.Int).Value = DBNull.Value; } } else { if (isOwner) { if (OwnerCheckBox.Checked) cmd.Parameters.Add("@owner", SqlDbType.NVarChar).Value = Session["User"].ToString(); else cmd.Parameters.Add("@owner", SqlDbType.NVarChar).Value = DBNull.Value; } } cmd.Parameters.Add("@sponsor", SqlDbType.NVarChar).Value = DBNull.Value; } #region Create/Assign Venue string country = ""; string state1 = ""; string venue = ""; bool isNewVenue = false; int venueID = 0; if (LocaleRadioButtonList.SelectedValue == "0") { //Need to check if the user is creating a new venue. //First If statement is if a user chose existing venue from dropdown //The Else statement if for the new venue. venueID = int.Parse(Session["NewVenue"].ToString()); DataSet dsVenue = dat.GetData("SELECT * FROM Venues WHERE ID=" + venueID.ToString()); venue = dsVenue.Tables[0].Rows[0]["Name"].ToString(); if (isEditing && !isOwner) { if (dsEvent.Tables[0].Rows[0]["Venue"].ToString() != venueID.ToString()) { hasEditChanged = true; cmd.Parameters.Add("@venue", SqlDbType.Int).Value = venueID; if (dsEvent.Tables[0].Rows[0]["Country"].ToString() != dsVenue.Tables[0].Rows[0]["Country"].ToString()) cmd.Parameters.Add("@country", SqlDbType.Int).Value = dsVenue.Tables[0].Rows[0]["Country"].ToString(); else { if (ownerUpForGrabs) { cmd.Parameters.Add("@country", SqlDbType.Int).Value = dsEvent.Tables[0].Rows[0]["Country"].ToString(); } else { cmd.Parameters.Add("@country", SqlDbType.Int).Value = DBNull.Value; } } if (dsEvent.Tables[0].Rows[0]["State"].ToString() != dsVenue.Tables[0].Rows[0]["State"].ToString()) cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["State"].ToString(); else { if (ownerUpForGrabs) { cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = dsEvent.Tables[0].Rows[0]["State"].ToString(); } else { cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = DBNull.Value; } } if (dsEvent.Tables[0].Rows[0]["City"].ToString() != dsVenue.Tables[0].Rows[0]["City"].ToString()) cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["City"].ToString(); else { if (ownerUpForGrabs) { cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = dsEvent.Tables[0].Rows[0]["City"].ToString(); } else { cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = DBNull.Value; } } if (dsEvent.Tables[0].Rows[0]["Zip"].ToString() != dsVenue.Tables[0].Rows[0]["Zip"].ToString()) cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["Zip"].ToString(); else { if (ownerUpForGrabs) { cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = dsEvent.Tables[0].Rows[0]["Zip"].ToString(); } else { cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = DBNull.Value; } } } else { if (ownerUpForGrabs) { cmd.Parameters.Add("@venue", SqlDbType.Int).Value = dsEvent.Tables[0].Rows[0]["Venue"].ToString(); cmd.Parameters.Add("@country", SqlDbType.Int).Value = dsEvent.Tables[0].Rows[0]["Country"].ToString(); cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = dsEvent.Tables[0].Rows[0]["State"].ToString(); cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = dsEvent.Tables[0].Rows[0]["City"].ToString(); cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = dsEvent.Tables[0].Rows[0]["Zip"].ToString(); } else { cmd.Parameters.Add("@venue", SqlDbType.Int).Value = DBNull.Value; cmd.Parameters.Add("@country", SqlDbType.Int).Value = DBNull.Value; cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = DBNull.Value; } } } else { cmd.Parameters.Add("@venue", SqlDbType.Int).Value = venueID; cmd.Parameters.Add("@country", SqlDbType.Int).Value = dsVenue.Tables[0].Rows[0]["Country"].ToString(); cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["State"].ToString(); cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["City"].ToString(); cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = dsVenue.Tables[0].Rows[0]["Zip"].ToString(); } country = dsVenue.Tables[0].Rows[0]["Country"].ToString(); state1 = dsVenue.Tables[0].Rows[0]["State"].ToString(); } else { venue = dat.stripHTML(addressTextBox.Text.Trim()); string privState = ""; if (privateStateDropDown.Visible) privState = privateStateDropDown.SelectedItem.Text; else privState = dat.stripHTML(privateStateTextBox.Text.Trim()); cmd.Parameters.Add("@venue", SqlDbType.NVarChar).Value = DBNull.Value; cmd.Parameters.Add("@address", SqlDbType.NVarChar).Value = dat.stripHTML(addressTextBox.Text.Trim()); cmd.Parameters.Add("@country", SqlDbType.Int).Value = privateCountryDropDown.SelectedValue; cmd.Parameters.Add("@state", SqlDbType.NVarChar).Value = privState; cmd.Parameters.Add("@city", SqlDbType.NVarChar).Value = dat.stripHTML(cityTextBox.Text.Trim()); cmd.Parameters.Add("@zip", SqlDbType.NVarChar).Value = dat.stripHTML(ZipTextBox.Text.Trim()); country = privateCountryDropDown.SelectedValue; state1 = privState; } #endregion if (isEditing) { cmd.ExecuteNonQuery(); } if (!isEditing || isOwner) { cmd.ExecuteNonQuery(); } bool songsChanged = false; bool mediaChanged = false; bool occuranceChanged = false; cmd = new SqlCommand("SELECT @@IDENTITY AS ID", conn); SqlDataAdapter da2 = new SqlDataAdapter(cmd); DataSet ds3 = new DataSet(); da2.Fill(ds3); string revisionID = ""; if (isEditing && !isOwner && !ownerUpForGrabs) { revisionID = ds3.Tables[0].Rows[0]["ID"].ToString(); } string ID = ds3.Tables[0].Rows[0]["ID"].ToString(); if (!isEditing) { if (OwnerCheckBox.Checked) { dat.Execute("INSERT INTO EventOwnerHistory (EventID, OwnerID, DateCreatedOwnership) " + "VALUES(" + ID + ", " + Session["User"].ToString() + ", '" + isn.ToString() + "')"); } } string firstStartDate = DateSelectionsListBox.Items[0].Text; email += "<br/><br/><a href=\"http://HippoHappenings.com/" + dat.MakeNiceName(EventNameTextBox.Text) + "_" + ID + "_Event\">" + EventNameTextBox.Text + "</a><br/><br/>" + venue + "<br/><br/>First Dates: " + firstStartDate + "<br/><br/>" + DescriptionTextBox.Content; textEmail = ". Name: " + EventNameTextBox.Text + ". Venue: " + venue + ". First Date: " + firstStartDate + ". Link: http://HippoHappenings.com/" + dat.MakeNiceName(EventNameTextBox.Text) + "_" + ID + "_Event"; string temporaryID = ""; if (isEditing) { temporaryID = eventID.Text; } else { temporaryID = ID; } string categories = CreateCategories(temporaryID, isOwner, isEditing, revisionID, ownerUpForGrabs); if (isEditing) ID = Request.QueryString["ID"].ToString(); //string temp = categories; //if (categories != "") // temp += " OR "; //temp += "UV.VenueID=" + venueID; #region Take Care of Media if (MusicCheckBox.Checked || hadSongs) { for (int i = 0; i < SongCheckList.Items.Count; i++) { if (isEditing) { if (SongCheckList.Items[i].Enabled) { if (revisionID != "" && !isOwner && !ownerUpForGrabs) { cmd = new SqlCommand("INSERT INTO EventRevisions_Song_Mapping (RevisionID, EventID, SongName) " + "VALUES(" + revisionID + ",@eventID, @songName)", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = int.Parse(eventID.Text); cmd.Parameters.Add("@songName", SqlDbType.NVarChar).Value = SongCheckList.Items[i].Value.ToString(); cmd.ExecuteNonQuery(); } songsChanged = true; dat.Execute("UPDATE Events SET hasSongs='True' WHERE ID=" + eventID.Text); if (i == 0) dat.Execute("DELETE FROM Event_Song_Mapping WHERE EventID=" + eventID.Text); cmd = new SqlCommand("INSERT INTO Event_Song_Mapping (EventID, SongName, SongTitle) " + "VALUES(@eventID, @songName, @songTitle)", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = int.Parse(eventID.Text); 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(); } } else { dat.Execute("UPDATE Events SET hasSongs='True' WHERE ID=" + ID); cmd = new SqlCommand("INSERT INTO Event_Song_Mapping (EventID, SongName, SongTitle) " + "VALUES(@eventID, @songName, @songTitle)", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = int.Parse(ID); 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(); } } } //Media Categories: NONE: 0, Picture: 1, Video: 2, YouTubeVideo: 3, Slider: 4 bool isSlider = false; if (PictureCheckList.Items.Count > 0) isSlider = true; string tempID = ID; if (isEditing) { tempID = eventID.Text; } if (isSlider) { char[] delim2 = { '\\' }; string[] fileArray = System.IO.Directory.GetFiles(MapPath(".") + "\\UserFiles\\" + Session["EffectiveUserName"].ToString() + "\\Slider\\"); if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles")) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\Events\\"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\Events\\" + tempID); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\Events\\" + tempID + "\\Slider\\"); } else { if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles\\Events\\")) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\Events\\"); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\Events\\" + tempID); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\Events\\" + tempID + "\\Slider\\"); } else { if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles\\Events\\" + tempID)) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\Events\\" + tempID); System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\Events\\" + tempID + "\\Slider\\"); } else { if (!System.IO.Directory.Exists(MapPath(".") + "\\UserFiles\\Events\\" + tempID + "\\Slider\\")) { System.IO.Directory.CreateDirectory(MapPath(".") + "\\UserFiles\\Events\\" + tempID + "\\Slider\\"); } } } } string YouTubeStr = ""; char[] delim3 = { '.' }; bool isPathAbsolute = false; for (int i = 0; i < PictureCheckList.Items.Count; i++) { //int length = fileArray[i].Split(delim2).Length; if (PictureCheckList.Items[i].Value == "ImgPathAbsolute") isPathAbsolute = true; else isPathAbsolute = false; if (isPathAbsolute) { cmd = new SqlCommand("INSERT INTO Event_Slider_Mapping (EventID, PictureName, RealPictureName, ImgPathAbsolute) " + "VALUES(@eventID, @picName, @realName, 'True')", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = tempID; cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Text; cmd.Parameters.Add("@realName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Text; cmd.ExecuteNonQuery(); } else { 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\\Events\\" + tempID + "\\Slider\\" + PictureCheckList.Items[i].Value)) { System.IO.File.Copy(MapPath(".") + "\\UserFiles\\" + Session["EffectiveUserName"].ToString() + "\\Slider\\" + PictureCheckList.Items[i].Value, MapPath(".") + "\\UserFiles\\Events\\" + tempID + "\\Slider\\" + PictureCheckList.Items[i].Value); } if (isEditing) { if (revisionID != "" && !isOwner && !ownerUpForGrabs) { if (PictureCheckList.Items[i].Enabled) { cmd = new SqlCommand("INSERT INTO EventRevisions_Slider_Mapping (RevisionID, EventID, " + "PictureName) VALUES(" + revisionID + ",@eventID, @picName)", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = tempID; cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Value; cmd.ExecuteNonQuery(); } } mediaChanged = true; if (i == 0) dat.Execute("DELETE FROM Event_Slider_Mapping WHERE EventID=" + eventID.Text); dat.Execute("UPDATE Events SET mediaCategory=" + mediaCat + " WHERE ID=" + tempID); cmd = new SqlCommand("INSERT INTO Event_Slider_Mapping (EventID, PictureName, RealPictureName) " + "VALUES(@eventID, @picName, @realName)", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = tempID; 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 { cmd = new SqlCommand("INSERT INTO Event_Slider_Mapping (EventID, PictureName, RealPicturename) " + "VALUES(@eventID, @picName, @realName)", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = tempID; cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Value; cmd.Parameters.Add("@realName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Text; cmd.ExecuteNonQuery(); } } //WE NO LONGER ALLOW Videos to be uploaded to the site itself. Only YouTube videos allowed. //else if (tokens[1].ToUpper() == "WMV") //{ // if (!System.IO.File.Exists(MapPath(".") + "\\UserFiles\\Events\\" + tempID + "\\Slider\\" + PictureCheckList.Items[i].Value)) // { // System.IO.File.Copy(MapPath(".") + "\\UserFiles\\" + Session["UserName"].ToString() + // "\\Slider\\" + PictureCheckList.Items[i].Value, // MapPath(".") + "\\UserFiles\\Events\\" + tempID + "\\Slider\\" + PictureCheckList.Items[i].Value); // } // if (isEditing) // { // if (PictureCheckList.Items[i].Enabled) // { // cmd = new SqlCommand("INSERT INTO EventRevisions_Slider_Mapping (modifierID, EventID, PictureName) VALUES("+Session["User"].ToString()+",@eventID, @picName)", conn); // cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = tempID; // cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Value; // cmd.ExecuteNonQuery(); // mediaChanged = true; // cmd = new SqlCommand("INSERT INTO Event_Slider_Mapping (EventID, PictureName) VALUES(@eventID, @picName)", conn); // cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = tempID; // cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Value; // cmd.ExecuteNonQuery(); // } // } // else // { // cmd = new SqlCommand("INSERT INTO Event_Slider_Mapping (EventID, PictureName) VALUES(@eventID, @picName)", conn); // cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = tempID; // cmd.Parameters.Add("@picName", SqlDbType.NVarChar).Value = PictureCheckList.Items[i].Value; // cmd.ExecuteNonQuery(); // } //} } else { mediaChanged = true; YouTubeStr += PictureCheckList.Items[i].Value + ";"; } } } if (YouTubeStr != "") if (isEditing) { if (dsEvent.Tables[0].Rows[0]["YouTubeVideo"].ToString() != YouTubeStr && !isOwner && !ownerUpForGrabs) { dat.Execute("INSERT INTO EventRevisions_YouTube (EventID, YouTubeStr, RevisionID) " + "VALUES(" + ID + ", '" + YouTubeStr + "', " + revisionID + ")"); } dat.Execute("UPDATE Events SET mediaCategory=" + mediaCat + ", YouTubeVideo='" + YouTubeStr + "' WHERE ID=" + tempID); } else { dat.Execute("UPDATE Events SET mediaCategory=" + mediaCat + ", YouTubeVideo='" + YouTubeStr + "' WHERE ID=" + ID); } } #endregion #region Take Care of Event Occurance DataSet dsEOccur = dat.GetData("SELECT * FROM Event_Occurance WHERE EventID=" + tempID); DataView dvEOccur = new DataView(dsEOccur.Tables[0], "", "", DataViewRowState.CurrentRows); //if (isEditing && (!isOwner || ownerUpForGrabs)) //{ // dvEOccur.RowFilter = "DateTimeStart = '" + StartDateTimePicker.DbSelectedDate.ToString() + "' AND " + // "DateTimeEnd = '" + EndDateTimePicker.DbSelectedDate.ToString() + "'"; // if (dvEOccur.Count == 0) // { // occuranceChanged = true; // hasEditChanged = true; // cmd = new SqlCommand("INSERT INTO EventRevisions_Occurance (EventID, DateTimeStart, DateTimeEnd, RevisionID, DATE) " + // "VALUES(@eventID, @dateStart, @dateEnd, " + temporaryID + ", '"+DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).ToString()+"')", conn); // cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = tempID; // cmd.Parameters.Add("@dateStart", SqlDbType.DateTime).Value = StartDateTimePicker.DbSelectedDate.ToString(); // if (EndDateTimePicker.DbSelectedDate != null) // cmd.Parameters.Add("@dateEnd", SqlDbType.DateTime).Value = EndDateTimePicker.DbSelectedDate.ToString(); // else // cmd.Parameters.Add("@dateEnd", SqlDbType.DateTime).Value = DBNull.Value; // cmd.ExecuteNonQuery(); // } //} //else //{ // dat.Execute("DELETE FROM Event_Occurance WHERE EventID="+temporaryID); // cmd = new SqlCommand("INSERT INTO Event_Occurance (EventID, DateTimeStart, DateTimeEnd) VALUES(@eventID, @dateStart, @dateEnd)", conn); // cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = tempID; // cmd.Parameters.Add("@dateStart", SqlDbType.DateTime).Value = StartDateTimePicker.DbSelectedDate.ToString(); // if (EndDateTimePicker.DbSelectedDate != null) // cmd.Parameters.Add("@dateEnd", SqlDbType.DateTime).Value = EndDateTimePicker.DbSelectedDate.ToString(); // else // cmd.Parameters.Add("@dateEnd", SqlDbType.DateTime).Value = DBNull.Value; // cmd.ExecuteNonQuery(); //} //DateTime a = DateTime.Parse(EndDateTimePicker.DbSelectedDate.ToString()); //TimeSpan b = a.Subtract(DateTime.Parse(StartDateTimePicker.DbSelectedDate.ToString())); string[] delimStr = { " -- " }; dat.Execute("DELETE FROM Event_Occurance WHERE EventID=" + tempID); for (int i = 0; i < DateSelectionsListBox.Items.Count; i++) { if (isEditing) { string[] tokensStr = DateSelectionsListBox.Items[i].Text.Split(delimStr, StringSplitOptions.RemoveEmptyEntries); //if (dvEOccur.Count == 0) //{ occuranceChanged = true; hasEditChanged = true; if (!ownerUpForGrabs && !isOwner) { cmd = new SqlCommand("INSERT INTO EventRevisions_Occurance (EventID, DateTimeStart, DateTimeEnd, RevisionID, DATE)" + "VALUES(@eventID, @dateStart, @dateEnd, " + temporaryID + ", '" + isn.ToString() + "')", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = tempID; cmd.Parameters.Add("@dateStart", SqlDbType.DateTime).Value = tokensStr[0]; cmd.Parameters.Add("@dateEnd", SqlDbType.DateTime).Value = tokensStr[1]; cmd.ExecuteNonQuery(); } else { cmd = new SqlCommand("INSERT INTO Event_Occurance (EventID, DateTimeStart, DateTimeEnd) VALUES(@eventID, @dateStart, @dateEnd)", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = tempID; cmd.Parameters.Add("@dateStart", SqlDbType.DateTime).Value = tokensStr[0]; cmd.Parameters.Add("@dateEnd", SqlDbType.DateTime).Value = tokensStr[1]; cmd.ExecuteNonQuery(); } //} } else { string[] tokensStr = DateSelectionsListBox.Items[i].Text.Split(delimStr, StringSplitOptions.RemoveEmptyEntries); cmd = new SqlCommand("INSERT INTO Event_Occurance (EventID, DateTimeStart, DateTimeEnd) VALUES(@eventID, @dateStart, @dateEnd)", conn); cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = tempID; cmd.Parameters.Add("@dateStart", SqlDbType.DateTime).Value = tokensStr[0]; cmd.Parameters.Add("@dateEnd", SqlDbType.DateTime).Value = tokensStr[1]; cmd.ExecuteNonQuery(); } } #endregion conn.Close(); #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 EventSearchTerms (EventID, SearchTerms, SearchDate) VALUES(" + ID + ", '" + terms.Replace("'", "''") + "', '" + item.Text + "')"); } } #endregion try { if (chargeCard) { Encryption encrypt = new Encryption(); //Charge Card though Capture 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(), "E" + temporaryID + isn.ToString(), "Capture Transaction for Featuring Event '" + dat.MakeNiceNameFull(EventNameTextBox.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": //MessagePanel.Visible = true; //foreach (string key in status.Keys) //{ // YourMessagesLabel.Text += "key: '" + key + "', value: '" + status[key] + "' <br/>"; //} TakeCareOfPostEmail(isEditing, isOwner, isNewVenue, ownerUpForGrabs, temporaryID, venueID.ToString(), tempID, revisionID, ownerID); break; default: MessagePanel.Visible = true; foreach (string key in status.Keys) { YourMessagesLabel.Text += "key: '" + key + "', value: '" + status[key] + "' <br/>"; } break; } } else { //MessagePanel.Visible = true; //YourMessagesLabel.Text = "no charge here"; TakeCareOfPostEmail(isEditing, isOwner, isNewVenue, ownerUpForGrabs, temporaryID, venueID.ToString(), tempID, revisionID, ownerID); } } catch (Exception ex) { MessagePanel.Visible = true; YourMessagesLabel.Text = "problem: " + problem + ex.ToString(); } } else { MessagePanel.Visible = true; YourMessagesLabel.Text = "" + message; } } else { MessagePanel.Visible = true; YourMessagesLabel.Text = "You must agree to the terms and conditions."; } } } catch (Exception ex) { MessagePanel.Visible = true; YourMessagesLabel.Text = "problem: " + problem + ex.ToString() + ", command: "; } }
protected void PostIt(object sender, EventArgs e) { if (AgreeCheckBox.Checked) { string validateMessage = ValidatePage(); if (validateMessage == "success") { bool chargeCard = false; string message = ""; 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 email = ""; //AuthorizePayPal d = new AuthorizePayPal(); 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 = true; //string transactionID = ""; //if (TotalLabel.Text.Trim() != "") //{ // if (decimal.TryParse(TotalLabel.Text.Trim(), out price)) // { // if (price != 0.00M) // { // 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": // chargeCard = true; // transactionID = status["TRANSACTIONID"]; // Session["TransID"] = transactionID; // goOn = 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"] = false; // } // } // else // { // goOn = true; // Session["Featured"] = false; // } //} //else //{ // goOn = true; // Session["Featured"] = false; //} if (goOn) { 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; DataView dvVenue = new DataView(); bool wasFeatured = false; if (Request.QueryString["ID"] != null) { dsVenue = dat.GetData("SELECT * FROM Venues WHERE ID=" + Request.QueryString["ID"].ToString()); dvVenue = new DataView(dsVenue.Tables[0], "", "", DataViewRowState.CurrentRows); //wasFeatured = bool.Parse(dvVenue[0]["Featured"].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.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.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=\"contact-us\">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 DaysFeatured=@fetDays, Featured=@fet, 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 (DaysFeatured, Featured, Web, Owner, City, State, Country, Zip, Edit, Name, Email, Phone, Address, CreatedByUser,Content, mediaCategory, Rating, PostedOn) " + "VALUES(@fetDays, @fet, @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.Now; string fetDays = ""; //foreach (ListItem item in FeatureDatesListBox.Items) //{ // fetDays += ";" + item.Text + ";"; //} if (isUpdate && (isOwner || ownerUpForGrabs) || !isUpdate) { //if (wasFeatured) //{ // cmd.Parameters.Add("@fet", SqlDbType.Bit).Value = true; // if (FeaturePanel.Visible) // { // cmd.Parameters.Add("@fetDays", SqlDbType.NVarChar).Value = fetDays; // } // else // cmd.Parameters.Add("@fetDays", SqlDbType.NVarChar).Value = dvVenue[0]["DaysFeatured"].ToString(); //} //else //{ cmd.Parameters.Add("@fet", SqlDbType.Bit).Value = false; //FeaturePanel.Visible; //if (FeaturePanel.Visible) //{ // cmd.Parameters.Add("@fetDays", SqlDbType.NVarChar).Value = fetDays; //} //else //{ cmd.Parameters.Add("@fetDays", SqlDbType.NVarChar).Value = DBNull.Value; //} //} } 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.Text.Trim()) { cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = VenueNameTextBox.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.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); } //if (ownerUpForGrabs || isOwner) CreateHoursEventsAndTerms(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 locale \"" + VenueNameTextBox.Text + "\". <br/><br/> You can find this locale <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(VenueNameTextBox.Text) + "_" + ID + "_Venue\">here</a>. " + "<br/><br/> To rate your experience posting this locale <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 locale you are the owner of on HippoHappenings: \"" + VenueNameTextBox.Text.Trim() + "\". <br/><br/> You can find this locale <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(VenueNameTextBox.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 locale you've created: " + VenueNameTextBox.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 locale you own on HippoHappenings: " + VenueNameTextBox.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.Text); } else { if (ownerUpForGrabs) { emailBody = "<br/><br/>You have successfully submitted updates for locale: \"" + VenueNameTextBox.Text.Trim() + "\". <br/><br/> You can find this locale <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(VenueNameTextBox.Text) + "_" + ID + "_Venue\">here</a>. " + "<br/><br/> To rate your experience posting this locale <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 locale: \"" + VenueNameTextBox.Text.Trim() + "\". <br/><br/> You can find this locale <a href=\"http://hippohappenings.com/" + dat.MakeNiceName(VenueNameTextBox.Text) + "_" + ID + "_Venue\">here</a>. " + "<br/><br/> The owner of the locale will need to approve/reject your change suggestions. If you do not hear back " + "from the locale's owner within 7 days, you will be allowed to take over ownership of this locale 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 locale's page. If you have not, you will need to edit the locale'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 locale: " + VenueNameTextBox.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 locale: " + VenueNameTextBox.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() + "')"); } try { bool showMessage = true; //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(), // "V" + ID + isn.ToString(), "Capture Transaction for Featuring Locale '" + // dat.MakeNiceNameFull(VenueNameTextBox.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": // //MessagePanel.Visible = true; // //foreach (string key in status.Keys) // //{ // // YourMessagesLabel.Text += "key: '" + key + "', value: '" + status[key] + "' <br/>"; // //} // 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) { //pop up the message to the user Encryption encrypt = new Encryption(); if (isOwner || !isUpdate) { Session["Message"] = "Your locale 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.Text) + "_" + ID + "_Venue');\">this locale'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 posting this locale.<br/>"; //MessageLiteral.Text = "<script type=\"text/javascript\">alert('" + message + "');</script>"; } else { if (ownerUpForGrabs) { Session["Message"] = "You have successfully submitted updates for locale: \"" + VenueNameTextBox.Text.Trim() + "\".<br/><br/>Check out <a class=\"AddLink\" onclick=\"Search('" + dat.MakeNiceName(VenueNameTextBox.Text) + "_" + ID + "_Venue');\">this locale's</a> home page.<br/> <a class=\"AddLink\" onclick=\"Search('RateExperience.aspx?Edit=" + isUpdate.ToString() + "&Type=V&ID=" + ID + "');\" >Rate </a>your user experience editing this locale.<br/>"; } else { Session["Message"] = "You have successfully submitted updates for this locale." + "<br/><br/> The owner of the locale will need to <b>approve/reject</b> your change suggestions. If you do not hear back " + "from the locale's owner within <b>7 days</b>, you will be allowed to <b>take over ownership</b> of this locale 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 locale's page to do so. If you have not, you will need to edit the locale's details again.<br/><br/>" + "Check out <a class=\"AddLink\" onclick=\"Search('" + dat.MakeNiceName(VenueNameTextBox.Text) + "_" + ID + "_Venue');\">this locales'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 locale.<br/>"; MessageRadWindow.Width = 530; MessageRadWindow.Height = int.Parse(MessageRadWindow.Height.Value.ToString()) + 20; } } 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; MessageRadWindow.VisibleOnPageLoad = true; } } catch (Exception ex) { MessagePanel.Visible = true; YourMessagesLabel.Text += "<br/><br/>" + ex.ToString(); } } } else { MessagePanel.Visible = true; YourMessagesLabel.Text = message; } } else { MessagePanel.Visible = true; YourMessagesLabel.Text += validateMessage; } } else { MessagePanel.Visible = true; YourMessagesLabel.Text += "You must agree to the terms and conditions."; } }