protected void Page_Load(object sender, EventArgs e) { uid = Request["uid"]; string pwd = Request["upwd"]; if (uid == "") { Response.Redirect("/default.aspx"); } if (pwd == "") { errormsg = "You've not input password"; return; } if (IsPostBack) { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@link", uid)); DataSet ds = BookDBProvider.getDataSet("uspGetPwdReset", param); if (ds.Tables[0].Rows.Count == 0) { errormsg = "You've gotten wrong link."; return; } email = ds.Tables[0].Rows[0]["Email"].ToString(); byte[] salt = AuthenticationManager.GenerateSalt(); int repeats = AuthenticationManager.GenerateRepeats(); byte[] pwdhash = AuthenticationManager.HashPassword(pwd, salt, repeats); param.Clear(); param.Add(new SqlParameter("@email", email)); param.Add(new SqlParameter("@salt", salt)); param.Add(new SqlParameter("@repeat", repeats)); param.Add(new SqlParameter("@hash", pwdhash)); param.Add(new SqlParameter("@link", uid)); BookDBProvider.getDataSet("uspUpdateUserPwd", param); string msg_format = @"Notification from Vacations-abroad.com <br/> You've reset the password of the account at vacations-abroad.com <br/> If this is not your activity, please contact administrator of vacation-abroad.com , '*****@*****.**'! <br/> Vacations-Abroad.com "; BookDBProvider.SendEmail(email, "Password changed : Vacations-abroad.com", msg_format); triger_redirect = 1; } }
protected void btnsendback_ServerClick(object sender, System.EventArgs e) { if (pass_recaptcha == false) { return; } string name = Request["username"]; string email = Request["useremail"]; string subject = Request["userselect"]; string phone = Request["userphone"]; string comment = Request["usercomment"]; if (name == "" || email == "") { return; } int ind_subject = 0; if (!Int32.TryParse(subject, out ind_subject)) { ind_subject = 0; } if (ind_subject == 0 || ind_subject > 2) { return; } string msg_format = @"Dear Linda <br/> General Inquiry originating on Vacations-Abroad.com <br/> Name: {0} <br/> Email: {1} <br/> Telephone: {2} <br/> Message: {3}"; string msg = String.Format(msg_format, name, email, phone, comment); BookDBProvider.SendEmail("*****@*****.**", questions[ind_subject], msg, email); // BookDBProvider.SendEmail("*****@*****.**", questions[ind_subject], msg, email); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { } else { email = Request["uemail"]; List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@email", email)); DataSet ds = BookDBProvider.getDataSet("uspGetUserInfo", param); if (ds.Tables[0].Rows.Count == 0) { errormsg = "You didn't input correct registered email!"; return; } else { List <SqlParameter> newparam = new List <SqlParameter>(); newparam.Add(new SqlParameter("@email", email)); string uid = generateID(); newparam.Add(new SqlParameter("@link", uid)); BookDBProvider.getDataSet("uspAddPwdReset", newparam); //Sending email to reset password string msg_format = @"Notification from Vacations-abroad.com <br/> To Reset Password of vacations-abroad account,please click <a href='{0}'>{0}</a> <br /> If this is not your activity, please contact administrator of vacation-abroad.com , '*****@*****.**'! <br/> Vacations-Abroad.com "; BookDBProvider.SendEmail(email, "Password Reset:Vacations-Abroad.com", String.Format(msg_format, String.Format("https://www.vacations-abroad.com/accounts/pwdreset.aspx?uid={0}", uid))); triger_redirect = 1; return; } } }
protected void SendQuote_Click(object sender, EventArgs e) { if (!Page.IsValid) { return; } if (rates.Value == "") { return; } decimal _rates, _cleanfee, _secfee, _lodgingtax, _cancel90, _cancel60, _cancel30, _total_sum, _lodgingvalue, _balance; int _validnumber; if (!Decimal.TryParse(rates.Value, out _rates)) { _rates = 0; } if (!Decimal.TryParse(cleaningfee.Value, out _cleanfee)) { _cleanfee = 0; } if (!Decimal.TryParse(secdeposit.Value, out _secfee)) { _secfee = 0; } if (!Decimal.TryParse(loadingtax.Value, out _lodgingtax)) { _lodgingtax = 0; } if (!Decimal.TryParse(cancel90.Value, out _cancel90)) { _cancel90 = 0; } if (!Decimal.TryParse(cancel60.Value, out _cancel60)) { _cancel60 = 0; } if (!Decimal.TryParse(cancel30.Value, out _cancel30)) { _cancel30 = 0; } if (!Int32.TryParse(validnumber.Value, out _validnumber)) { _validnumber = 0; } //_total_sum = _rates * inquiryinfo.Nights; _total_sum = _rates; _lodgingvalue = _total_sum * _lodgingtax / 100; _balance = _lodgingvalue + _secfee + _cleanfee; int newrespid = 0; int _currency = Convert.ToInt32(currency.SelectedValue); if ((newrespid = BookDBProvider.addEmailResponse(inquiryinfo.PropertyOwnerID, inquiryinfo.UserID, quoteid, _rates, _cleanfee, _secfee, _lodgingtax, _cancel30, _cancel60, _cancel90, DateTime.Now, _validnumber, _currency, comment.InnerText)) > 0) { BookDBProvider.updateEmailQuoteState(quoteid); } UserInfo userinfo = BookDBProvider.getUserInfo(inquiryinfo.PropertyOwnerID); // BookResponseEmail /for owner string toOwner = String.Format("Hi, {0}!<br> You have replied the inquiry for the property {1} in {2},{3},{4}.<br> Thanks.", userinfo.firstname + " " + userinfo.lastname, inquiryinfo.PropertyID, countryinfo.city, countryinfo.state, countryinfo.country); BookDBProvider.SendEmail(userinfo.email, "You have replied for the inquiry", toOwner); PropertyDetailInfo propinfo = AjaxProvider.getPropertyDetailInfo(inquiryinfo.PropertyID); string url = String.Format("https://www.vacations-abroad.com/{0}/{1}/{2}/{3}/default.aspx", propinfo.Country, propinfo.StateProvince, propinfo.City, propinfo.ID).ToLower().Replace(" ", "_"); //To traveler // UserInfo traveler = BookDBProvider.getUserInfo(inquiryinfo.UserID); string toTraveler = @"<body> {22} <table border='0px' width='600px' > <tr> <td> <table style='width:600px;'> <tr> <td style='color:#000;font-size:16pt;width:300px;font-family: Verdana;'> <b>Vacations Abroad</b> </td> <td style='color:#000;font-size:10pt;width:300px;text-align: right;font-family: Verdana;'> {0} </td> </tr> </table> </td> </tr> <tr> <td bgcolor='#4472c4' style='border:1px solid #2f528f;text-align:center;padding: 10px 0px;color:#fff;font-size:12pt;font-family: Verdana;'> <a href='https://www.vacations-abroad.com/quoteresponse.aspx?respid={21}' style='cursor: pointer;color: #fff;text-decoration: none;font-size:12pt;font-family: Verdana;'> <b>Book Now!<b> </a> </td> </tr> <tr> <td style='text-align: center;padding: 10px 0px;'> <img src='{2}' style='width:350px;height: 220px;' width='350' height='220' /> </td> </tr> <tr> <td style='text-align: center;font-size:10pt;font-family: Verdana;'> Name of property:{3} Type of property:{4} </td> </tr> <tr> <td style='padding: 10px;'> <table style='border:1px dashed #000;width:600px;font-size:12pt;'> <tr> <td style='padding:10px;font-family: Verdana;'> <a href='{5}'>Property {6}</a> <br/> Date of Arrival: {7} <br/> {8} of nights <br/> # of Guests: {9} Adults, {10} children <br/><br/> Total Amount Due:{12} {19}<br/> Amount Due to Reserve:{13} {19} <br/> </td> </tr> <tr> <td style='background: none; border: dotted 1px #999999; border-width:1px 0 0 0; height:1px;font-size:1px;'></td> </tr> <tr> <td style='padding:3px;font-family: Verdana;'> Cleaning Fee:{15} {19}<br/> Security Deposit:{16} {19}<br/> Lodging Tax:{17}% {20}{19}<br/> Amount Due Upon Arrival:{18} <br/> Comment:{23}<br/> </td> </tr> </table> </td> </tr> <tr> <td style='padding: 15px; text-align: center;'> <a href='https://www.vacations-abroad.com/quoteresponse.aspx?respid={21}' style='padding:3px 20px;border:1px solid #000;cursor: pointer;color: #f86308;text-decoration: none;font-size:12pt;font-family: Verdana;'> <b>Book Now</b> </a> </td> </tr> <tr> <td style='text-align: center;'> <img src='https://www.vacations-abroad.com/images/elogo.jpg' style='width:240px;height: 100px;' width='240' height='100' /> </td> </tr> </table> </body>"; decimal _total = _total_sum + _balance; string msg = String.Format(toTraveler, DateTime.Now.ToString("MMM d, yyyy"), inquiryinfo.ContactorName, "https://www.vacations-abroad.com/images/" + propinfo.FileName, propinfo.Name2, propinfo.CategoryTypes, url, propinfo.ID, inquiryinfo.ArrivalDate, inquiryinfo.Nights, inquiryinfo.Adults, inquiryinfo.Children, userinfo.name, BookDBProvider.DoFormat(_total), BookDBProvider.DoFormat(_total_sum), BookDBProvider.DoFormat(_rates), BookDBProvider.DoFormat(_cleanfee), BookDBProvider.DoFormat(_secfee), _lodgingtax, BookDBProvider.DoFormat(_balance), currency.SelectedItem.Text, BookDBProvider.DoFormat(_lodgingvalue), AjaxProvider.Base64Encode(newrespid.ToString()), "<style>a:hover{color:#8bbdeb;} </style>", comment.InnerText); //BookDBProvider.SendEmail(traveler.email, toTraveler, "You have received the response from the property owner"); BookDBProvider.SendEmail(inquiryinfo.ContactorEmail, String.Format("{0}, here is your quote for {1}", inquiryinfo.ContactorName, inquiryinfo.ArrivalDate), msg); BookDBProvider.SendEmail("*****@*****.**", String.Format("{0} has responded to {1}", userinfo.name, inquiryinfo.ContactorName), msg); if (AuthenticationManager.IfAdmin) { Response.Redirect("/userowner/listings.aspx?userid=" + inquiryinfo.PropertyOwnerID); } else { Response.Redirect("/userowner/listings.aspx"); } }
protected void sendcomments_Click(object sender, EventArgs e) { string comments = Request["comments"]; // Response.Write(comments); if (comments == "") { return; } int newrespid = 0; int _currency = Convert.ToInt32(currency.SelectedValue); if ((newrespid = BookDBProvider.addEmailResponse(inquiryinfo.PropertyOwnerID, inquiryinfo.UserID, quoteid, 0, 0, 0, 0, 0, 0, 0, DateTime.Now, -1, _currency, comments)) > 0) { BookDBProvider.updateEmailQuoteState(quoteid); } UserInfo userinfo = BookDBProvider.getUserInfo(inquiryinfo.PropertyOwnerID); // BookResponseEmail /for owner string toOwner = String.Format("Hi, {0}!<br> You have replied the inquiry for the property {1} in {2},{3},{4}.<br> Thanks.", userinfo.firstname + " " + userinfo.lastname, inquiryinfo.PropertyID, countryinfo.city, countryinfo.state, countryinfo.country); BookDBProvider.SendEmail(userinfo.email, "You have replied for the inquiry", toOwner); PropertyDetailInfo propinfo = AjaxProvider.getPropertyDetailInfo(inquiryinfo.PropertyID); string url = String.Format("https://www.vacations-abroad.com/{0}/{1}/{2}/{3}/default.aspx", propinfo.Country, propinfo.StateProvince, propinfo.City, propinfo.ID).ToLower().Replace(" ", "_"); //To traveler // UserInfo traveler = BookDBProvider.getUserInfo(inquiryinfo.UserID); string toTraveler = @"<body> <table border='0px' width='600px' > <tr> <td> <table style='width:600px;'> <tr> <td style='color:#000;font-size:16pt;width:300px;font-family: Verdana;'> <b>Vacations Abroad</b> </td> <td style='color:#000;font-size:10pt;width:300px;text-align: right;font-family: Verdana;'> {0} </td> </tr> </table> </td> </tr> <tr> <td bgcolor='#4472c4' style='border:1px solid #2f528f;text-align:center;padding: 10px 0px;color:#fff;font-size:12pt;font-family: Verdana;'> <a style='cursor: pointer;color: #fff;text-decoration: none;font-size:12pt;font-family: Verdana;'> <b>Sorry! The property is not available on {6}<b> </a> </td> </tr> <tr> <td style='text-align: center;padding: 10px 0px;'> <img src='{1}' style='width:350px;height: 220px;' width='350' height='220' /> </td> </tr> <tr> <td style='text-align: center;font-size:10pt;font-family: Verdana;'> Name of property:{2} Type of property:{3} </td> </tr> <tr> <td style='padding: 10px;'> <table style='border:1px dashed #000;width:600px;font-size:12pt;'> <tr> <td style='padding:10px;font-family: Verdana;'> <a href='{4}'>Property {5}</a> <br/> Date of Arrival: {6} <br/> {7} of nights <br/> # of Guests: {8} Adults, {9} children <br/><br/> </td> </tr> <tr> <td style='background: none; border: dotted 1px #999999; border-width:1px 0 0 0; height:1px;font-size:1px;'></td> </tr> <tr> <td style='padding:3px;font-family: Verdana;'> Comment:{10}<br/> </td> </tr> </table> </td> </tr> <tr> <td style='padding: 15px; text-align: center;'> <a style='padding:3px 20px;border:1px solid #000;cursor: pointer;color: #f86308;text-decoration: none;font-size:12pt;font-family: Verdana;'> <b>Sorry! The property is not available on {6}</b> </a> </td> </tr> <tr> <td style='text-align: center;'> <img src='https://www.vacations-abroad.com/images/elogo.jpg' style='width:240px;height: 100px;' width='240' height='100' /> </td> </tr> </table> </body>"; string msg = String.Format(toTraveler, DateTime.Now.ToString("MMM d, yyyy"), "https://www.vacations-abroad.com/images/" + propinfo.FileName, propinfo.Name2, propinfo.CategoryTypes, url, propinfo.ID, inquiryinfo.ArrivalDate, inquiryinfo.Nights, inquiryinfo.Adults, inquiryinfo.Children, comments); //BookDBProvider.SendEmail(traveler.email, toTraveler, "You have received the response from the property owner"); BookDBProvider.SendEmail(inquiryinfo.ContactorEmail, String.Format("{0}, here is your quote for {1}", inquiryinfo.ContactorName, inquiryinfo.ArrivalDate), msg); BookDBProvider.SendEmail("*****@*****.**", String.Format("{0} has responded to {1}", userinfo.name, inquiryinfo.ContactorName), msg); if (AuthenticationManager.IfAdmin) { Response.Redirect("/userowner/listings.aspx?userid=" + inquiryinfo.PropertyOwnerID); } else { Response.Redirect("/userowner/listings.aspx"); } }
protected bool InsertNewUser(SocialUser social) { try { int newid; using (SqlConnection connection = CommonFunctions.GetConnection()) { connection.Open(); //lock(CommonFunctions.Connection) SqlCommand getmaxid = new System.Data.SqlClient.SqlCommand("SELECT MAX(ID) FROM Users", connection); object maxid = getmaxid.ExecuteScalar(); if (maxid is int) { newid = (int)maxid + 1; } else { newid = 1; } byte[] salt = AuthenticationManager.GenerateSalt(); int repeats = AuthenticationManager.GenerateRepeats(); byte[] pwdhash = AuthenticationManager.HashPassword(social.id, salt, repeats); string sqlQuery = "select * from Users where 0 = 1"; SqlDataAdapter dataAdapter = new SqlDataAdapter(sqlQuery, connection); DataSet MainDataSet = new DataSet(); dataAdapter.Fill(MainDataSet, "Users"); DataRow newuser = MainDataSet.Tables["Users"].NewRow(); newuser["ID"] = newid; newuser["Username"] = social.username; newuser["PasswordSalt"] = salt; newuser["Repeats"] = repeats; newuser["PasswordHash"] = pwdhash; newuser["Email"] = social.email; newuser["IfAdmin"] = 0; newuser["UserID"] = social.id; newuser["AdministrativeEmail"] = newuser["Email"]; newuser["IfAgent"] = 0; newuser["ReservationEmail"] = newuser["Email"]; newuser["DateCreated"] = DateTime.Now; newuser["FirstName"] = ""; newuser["LastName"] = ""; //new part newuser["dateModified"] = DateTime.Today.ToString(); int type = (acctype.Value == "1") ? 1 : 2; newuser["AccountType"] = type; //0:email 1: facebook 2:twitter bool bl_show = showproperty.Checked; newuser["Listing"] = (bl_show) ? 1 : 0; MainDataSet.Tables["Users"].Rows.Add(newuser); new SqlCommandBuilder(dataAdapter); int rows = dataAdapter.Update(MainDataSet, "Users"); if (rows < 1) { return(false); } // CommonFunctions.sendEmail(social.username, social.email); string msg = "New owner registered at " + CommonFunctions.GetSiteName() + ". <br>" + "Owner details: <br>" + "Login name:" + social.username + " <br>" + "Email address:" + social.email + " <br>"; BookDBProvider.SendEmail(ConfigurationManager.AppSettings["NewOwnerEmail"], "New owner registered at Vacations-abroad.com", msg, social.email); connection.Close(); if (AuthenticationManager.Login(social.email, social.id, type) != "") { FormsAuthentication.RedirectFromLoginPage(LoginName.Text, false); } } } catch (Exception ex) { throw ex; } return(true); }
protected void SendButton_Click(object sender, System.EventArgs e) { EmailRequired.Validate(); bool toall = false; if (!EmailRequired.IsValid) { return; } PropertiesSet.Clear(); if (SendProperty.Checked) { PropertyNumberRequired.Validate(); PropertyNumberValid.Validate(); if (!PropertyNumberRequired.IsValid || !PropertyNumberValid.IsValid) { return; } GetIDsByNumber.SelectCommand.Parameters["@PropertyID"].Value = Convert.ToInt32(PropertyNumber.Text); //lock (CommonFunctions.Connection) GetIDsByNumber.Fill(PropertiesSet); } else if (SendOwner.Checked) { OwnerUsernameRequired.Validate(); OwnerUsernameValid.Validate(); if (!OwnerUsernameRequired.IsValid || !OwnerUsernameValid.IsValid) { return; } GetIDsByUsername.SelectCommand.Parameters["@Username"].Value = OwnerUsername.Text; //lock (CommonFunctions.Connection) GetIDsByUsername.Fill(PropertiesSet); } else if (SendAll.Checked) { toall = true; List <SqlParameter> sparam = new List <SqlParameter>(); ds_owners = BookDBProvider.getDataSet("usp_get_all_owners_proved_properties", sparam); } //lock (CommonFunctions.Connection) if (toall) { if (ds_owners.Tables.Count > 0) { string emails = ""; foreach (DataRow datarow in ds_owners.Tables[0].Rows) { System.Text.RegularExpressions.Regex regex = new System.Text.RegularExpressions.Regex("^\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*$"); if ((datarow["Email"] is string) && regex.Match((string)datarow["Email"]).Success) { SmtpClient smtpclient = new SmtpClient("mail.vacations-abroad.com", 25); MailMessage message = new MailMessage("noreply@" + CommonFunctions.GetDomainName(), (string)datarow["Email"]); message.Subject = CommonFunctions.GetSiteAddress() + CommonFunctions.PrepareURL(((string)datarow["Country"]).Replace(" ", "_").ToLower() + "/" + ((string)datarow["StateProvince"]).Replace(" ", "_").ToLower() + "/" + ((string)datarow["City"]).Replace(" ", "_").ToLower() + "/" + ((int)datarow["ID"]).ToString() + "/default.aspx"); message.Body = "Dear " + (string)datarow["FirstName"] + " " + (string)datarow["LastName"] + "!\n\n" + "You received a new message from " + CommonFunctions.GetSiteName() + " administration:\n\n" + EmailBody.Text; message.IsBodyHtml = false; message.Body = message.Body.Replace("\r", "").Replace("\n", Environment.NewLine); message.Headers["Content-Type"] = "text/plain; charset = \"iso-8859-1\""; BookDBProvider.SendEmail((string)datarow["Email"], message.Subject, message.Body); } DataRow newrow = EmailsSet.Tables["Emails"].NewRow(); newrow["PropertyID"] = datarow["ID"]; newrow["DateTime"] = DateTime.Now; newrow["Email"] = EmailBody.Text; newrow["IfCustom"] = true; EmailsSet.Tables["Emails"].Rows.Add(newrow); } EmailsAdapter.Update(EmailsSet); EmailsSent.Text = ds_owners.Tables[0].Rows.Count.ToString() + " e-mails sent"; } else { EmailsSent.Text = "0 e-mails sent"; } //lock (CommonFunctions.Connection) EmailsSent.Visible = true; } else { foreach (DataRow datarow in PropertiesSet.Tables["Properties"].Rows) { System.Text.RegularExpressions.Regex regex = new System.Text.RegularExpressions.Regex("^\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*$"); if ((datarow["Email"] is string) && regex.Match((string)datarow["Email"]).Success) { SmtpClient smtpclient = new SmtpClient("mail.vacations-abroad.com", 25); MailMessage message = new MailMessage("noreply@" + CommonFunctions.GetDomainName(), (string)datarow["Email"]); message.Subject = CommonFunctions.GetSiteAddress() + CommonFunctions.PrepareURL(((string)datarow["Country"]).Replace(" ", "_").ToLower() + "/" + ((string)datarow["StateProvince"]).Replace(" ", "_").ToLower() + "/" + ((string)datarow["City"]).Replace(" ", "_").ToLower() + "/" + ((int)datarow["ID"]).ToString() + "/default.aspx"); message.Body = "Dear " + (string)datarow["FirstName"] + " " + (string)datarow["LastName"] + "!\n\n" + "You received a new message from " + CommonFunctions.GetSiteName() + " administration:\n\n" + EmailBody.Text; message.IsBodyHtml = false; message.Body = message.Body.Replace("\r", "").Replace("\n", Environment.NewLine); message.Headers["Content-Type"] = "text/plain; charset = \"iso-8859-1\""; try { smtpclient.Send(message); } catch (Exception ex) { } } DataRow newrow = EmailsSet.Tables["Emails"].NewRow(); newrow["PropertyID"] = datarow["ID"]; newrow["DateTime"] = DateTime.Now; newrow["Email"] = EmailBody.Text; newrow["IfCustom"] = true; EmailsSet.Tables["Emails"].Rows.Add(newrow); } //lock (CommonFunctions.Connection) EmailsAdapter.Update(EmailsSet); EmailsSent.Text = PropertiesSet.Tables["Properties"].Rows.Count.ToString() + " e-mails sent"; EmailsSent.Visible = true; } }
protected void bt_register_Click(object sender, EventArgs e) { logtype = 0; if (!IsValid) { return; } try { int newid; using (SqlConnection connection = CommonFunctions.GetConnection()) { connection.Open(); //lock(CommonFunctions.Connection) SqlCommand getmaxid = new System.Data.SqlClient.SqlCommand("SELECT MAX(ID) FROM Users", connection); object maxid = getmaxid.ExecuteScalar(); if (maxid is int) { newid = (int)maxid + 1; } else { newid = 1; } byte[] salt = AuthenticationManager.GenerateSalt(); int repeats = AuthenticationManager.GenerateRepeats(); byte[] pwdhash = AuthenticationManager.HashPassword(Password.Text, salt, repeats); string sqlQuery = "select * from Users where 0 = 1"; SqlDataAdapter dataAdapter = new SqlDataAdapter(sqlQuery, connection); DataSet MainDataSet = new DataSet(); dataAdapter.Fill(MainDataSet, "Users"); DataRow newuser = MainDataSet.Tables["Users"].NewRow(); newuser["ID"] = newid; newuser["Username"] = LoginName.Text; newuser["PasswordSalt"] = salt; newuser["Repeats"] = repeats; newuser["PasswordHash"] = pwdhash; newuser["Email"] = Email.Text; newuser["IfAdmin"] = 0; newuser["UserID"] = newuser["Username"]; newuser["AdministrativeEmail"] = newuser["Email"]; newuser["IfAgent"] = 0; newuser["ReservationEmail"] = newuser["Email"]; newuser["DateCreated"] = DateTime.Now; newuser["FirstName"] = reg_firstname.Text; newuser["LastName"] = reg_lastname.Text; //new part newuser["dateModified"] = DateTime.Today.ToString(); newuser["AccountType"] = 0; //0:email 1: facebook 2:twitter bool bl_show = false; // showproperty.Checked; newuser["Listing"] = (bl_show) ? 1 : 0; MainDataSet.Tables["Users"].Rows.Add(newuser); new SqlCommandBuilder(dataAdapter); int rows = dataAdapter.Update(MainDataSet, "Users"); if (rows < 1) { return; } // CommonFunctions.sendEmail(LoginName.Text, Email.Text); string msg = "New owner registered at " + CommonFunctions.GetSiteName() + ". <br>" + "Owner details: <br>" + "Login name:" + LoginName.Text + " <br>" + "Email address:" + Email.Text + " <br>"; BookDBProvider.SendEmail(ConfigurationManager.AppSettings["NewOwnerEmail"], "New owner registered at Vacations-abroad.com", msg, Email.Text); // if (regex.Match(message.To.ToString()).Success) // smtpclient.Send(message); //CommonFunctions.Connection.Close (); connection.Close(); try { using (WebClient client = new WebClient()) { byte[] response = client.UploadValues("https://api.madmimi.com/audience_lists/Owners/add", new NameValueCollection() { { "username", "*****@*****.**" }, { "api_key", "9881316569391d3dbfba35b71670b4b2" }, { "email", Email.Text }, { "first_name", reg_firstname.Text }, { "last_name", reg_lastname.Text } }); //string result = System.Text.Encoding.UTF8.GetString(response); } } catch { } string username; if ((username = AuthenticationManager.Login(LoginName.Text, Password.Text, 0)) != "") { FormsAuthentication.SetAuthCookie(username, true); // if (backlinkpassed) Response.Redirect("http://" + Request.ServerVariables["SERVER_NAME"] + ":" + Request.ServerVariables["SERVER_PORT"] + backlinkurl); if (backlinkpassed) { Response.Redirect(backlinkurl); } else { Response.Redirect("/userowner/Listings.aspx?UserID=" + AuthenticationManager.UserID.ToString()); } } } } catch (Exception ex) { throw ex; } //CommonFunctions.Connection.Open (); Response.Redirect(backlinkurl); }
protected void Page_Load(object sender, EventArgs e) { if (HttpContext.Current.Request.HttpMethod != "POST") { Response.Write("Wrong request"); return; } context = HttpContext.Current; parseTransaction(); PaymentHelper.addPaymentLog(transitem); email_resp = BookResponseEmail.getResponseInfo(transitem.item_number); //respid // if (email_resp.ID == 0 || email_resp.IsValid < 1) Response.Redirect("/Error.aspx?error=Wrong Response number or not valid"); inquiryinfo = BookDBProvider.getQuoteInfo(email_resp.QuoteID); owner_info = BookDBProvider.getDetailedUserInfo(inquiryinfo.PropertyOwnerID); // traveler_info = BookDBProvider.getUserInfo(inquiryinfo.UserID); prop_info = AjaxProvider.getPropertyDetailInfo(inquiryinfo.PropertyID); ServicePointManager.Expect100Continue = true; ServicePointManager.SecurityProtocol = (SecurityProtocolType)3072; // string requestUriString = "https://www.sandbox.paypal.com/cgi-bin/webscr"; string requestUriString = "https://www.paypal.com/cgi-bin/webscr"; HttpWebRequest request = (HttpWebRequest)WebRequest.Create(requestUriString); string strFormValues = Encoding.ASCII.GetString( context.Request.BinaryRead(context.Request.ContentLength)); // Set values for the request back request.Method = "POST"; request.ContentType = "application/x-www-form-urlencoded"; string obj2 = strFormValues + "&cmd=_notify-validate"; request.ContentLength = obj2.Length; /* * System.IO.StreamWriter file = new System.IO.StreamWriter(Server.MapPath("/logwrite.txt")); * file.Write(obj2); * file.Close(); */ // Write the request back IPN strings StreamWriter writer = new StreamWriter(request.GetRequestStream(), Encoding.ASCII); writer.Write(RuntimeHelpers.GetObjectValue(obj2)); writer.Close(); //send the request, read the response HttpWebResponse response = (HttpWebResponse)request.GetResponse(); Stream responseStream = response.GetResponseStream(); Encoding encoding = Encoding.GetEncoding("utf-8"); StreamReader reader = new StreamReader(responseStream, encoding); string resp = reader.ReadToEnd(); //_total_sum = email_resp.NightRate * inquiryinfo.Nights; _total_sum = email_resp.NightRate; _lodgingval = _total_sum * email_resp.LoadingTax / 100; _balance = _lodgingval + email_resp.CleaningFee + email_resp.SecurityDeposit; _total = _total_sum + _balance; /* * System.IO.StreamWriter sfile = new System.IO.StreamWriter(Server.MapPath("/log.txt")); * sfile.Write(resp); * sfile.Close(); */ int discount; if (transitem.custom.Length == 13) { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@coupon", transitem.custom)); DataSet ds_coupon = BookDBProvider.getDataSet("uspGetCouponItem", param); if (ds_coupon.Tables[0].Rows.Count > 0) { if (!int.TryParse(ds_coupon.Tables[0].Rows[0]["Discount"].ToString(), out discount)) { discount = 0; } _total = _total_sum * (100 - discount) / 100 + _balance; } } _total = Decimal.Parse(BookDBProvider.DoFormat(_total)); if (resp == "VERIFIED") { //if(transitem.business == ConfigurationManager.AppSettings["PaypalEmail"].ToString() && transitem.txn_type!= "reversal") /* System.IO.StreamWriter ssfile = new System.IO.StreamWriter(Server.MapPath("/logt.txt")); * ssfile.Write(resp); * ssfile.Close(); */ // if (transitem.business == "*****@*****.**" && transitem.txn_type != "reversal") if (transitem.business == ConfigurationManager.AppSettings["PaypalEmail"].ToString() && transitem.txn_type != "reversal") { if ((transitem.mc_gross == (_total)) && transitem.payment_status == "Completed" && transitem.mc_currency == currency_type[email_resp.CurrencyType]) { PaymentHelper.addPaymentHistory(transitem, inquiryinfo); BookResponseEmail.updateEmailResponseState(transitem.item_number); string format_traveler = @"This is your receipt for your reservation with Vacations-Abroad.com <br/> This email confirms that {0} has booked a reservation with {1}. <br/> Your Arrival Date is: {2} <br/> You paid: {3} {4} on {5} <br/> The owner’s cancellation policy is <br/> 90 days prior to arrival:{6}% <br/> 60 days prior to arrival:{7}% <br/> 30 days prior to arrival:{8}% <br/> Owner Contact Details <br/> Owner Name:{9} <br/> Owner Email:{10} <br/> Owner Telephone:{11} <br/> Name of Property:{1} <br/> Owner Website: {12} <br/> Please contact the owner to obtain the actual property address. <br/> If you do not cancel, the funds will be transferred to the owner on (7 days prior to your {13}) <br/> When you return, please write a review of the property and add photos. <br/>"; string msg_traveler = String.Format(format_traveler, inquiryinfo.ContactorName, prop_info.PropertyName, DateTime.Parse(inquiryinfo.ArrivalDate).ToString("MMM d, yyyy"), transitem.mc_gross, transitem.mc_currency, DateTime.Now.ToString("MMM d, yyyy"), email_resp.Cancel90, email_resp.Cancel60, email_resp.Cancel30 , String.Format("{0} {1}", owner_info.FirstName, owner_info.LastName), owner_info.Email, owner_info.MobileTelephone, owner_info.Website, DateTime.Parse(inquiryinfo.ArrivalDate).ToString("MMM d, yyyy")); string trv_subject = String.Format("Reservation Confirmation for {0}", DateTime.Now.ToString("MMM d, yyyy")); BookDBProvider.SendEmail(inquiryinfo.ContactorEmail, trv_subject, msg_traveler); string format_owner = @"This is a confirmation for the reservation completed through Vacations-Abroad.com <br/> This email confirms that {0} has booked a reservation with {1}. <br/> Arrival Date is: {2} <br/> They have paid: {3} {4} on {5} <br/> The owner’s cancellation policy is <br/> 90 days prior to arrival:{6}% <br/> 60 days prior to arrival:{7}% <br/> 30 days prior to arrival:{8}% <br/><br/> Traveler Contact Details <br/><br/> Traveler Name:{9} <br/> Traveler Email:{10} <br/> Traveler Telephone:{11} <br/><br/> Please contact the traveler to provide them with directions to your property and inform them of any check-in procedures. <br/> If the Traveler does not cancel, the funds will be transferred to your Paypal or bank account (7 days prior to your {2}) less a 10% commission fee. If any fees such as cleaning fees, security deposit or lodging taxes are to be collected by you at arrival. <br/> You have specified these additional fees are due at arrival. <br/> Cleaning:{12} {4} <br/> Security Deposit:{13} {4}<br/> Lodging Tax:{14} {4}<br/><br/> Let us know if we can be of further assistance. <br/> Linda Jenkins <br/> 770-687-6889 <br/>"; string owner_subject = String.Format("Reservation Confirmation for {0}", DateTime.Now.ToString("MMM d, yyyy")); string msg_owner = String.Format(format_owner, inquiryinfo.ContactorName, prop_info.PropertyName , DateTime.Parse(inquiryinfo.ArrivalDate).ToString("MMM d, yyyy"), transitem.mc_gross, transitem.mc_currency, DateTime.Now.ToString("MMM d, yyyy"), email_resp.Cancel90, email_resp.Cancel60, email_resp.Cancel30, inquiryinfo.ContactorName, inquiryinfo.ContactorEmail, inquiryinfo.Telephone, BookDBProvider.DoFormat(email_resp.CleaningFee), BookDBProvider.DoFormat(email_resp.SecurityDeposit), BookDBProvider.DoFormat(_lodgingval)); BookDBProvider.SendEmail(owner_info.Email, owner_subject, msg_owner); BookDBProvider.SendEmail("*****@*****.**", String.Format("{0} has paid for property {1} Transaction:{2}", inquiryinfo.ContactorName, transitem.item_number, transitem.txn_id), msg_owner); BookDBProvider.SendEmail("*****@*****.**", "Notification: Transaction:" + transitem.txn_id, msg_owner); } } } else { } }
protected void Page_Load(object sender, EventArgs e) { // Request.SaveAs(Server.MapPath("~/assets/ss.txt"),true); pass_recaptcha = false; string sec_key = "6LeiuBcUAAAAAPEGRRVqTcLsdO83GSnGetOwOfMM"; string g_url = "https://www.google.com/recaptcha/api/siteverify"; using (WebClient wc = new WebClient()) { byte[] response = wc.UploadValues(g_url, new NameValueCollection() { { "secret", sec_key }, { "response", Request["g-recaptcha-response"] } }); string result = System.Text.Encoding.UTF8.GetString(response); JObject json = JObject.Parse(result); if (json["success"].ToString() != "True" || json["hostname"].ToString() != "www.vacations-abroad.com") { // Response.Write(String.Format("{0} <<<< {1}<<<< {2}", Request["g-recaptcha-response"], json["success"].ToString(), json["hostname"].ToString())); return; } pass_recaptcha = true; } if (!pass_recaptcha) { return; } propNum = Int32.Parse(Request.Form["propid"]); image_count = Int32.Parse(Request.Form["image_count"]); fname = Server.HtmlEncode(Request.Form["txtFName"]); lname = Server.HtmlEncode(Request.Form["txtLName"]); vmon = Server.HtmlEncode(Request.Form["ddlMonth"]); vyear = Server.HtmlEncode(Request.Form["ddlYear"]); email = Server.HtmlEncode(Request.Form["email"]); phonenumber = Server.HtmlEncode(Request.Form["txtPhone"]); comment = Server.HtmlEncode(Request.Form["txtComments"]); rate = Int32.Parse(Request.Form["ratings"]); int newid = BookDBProvider.addComment(propNum, rate, fname, lname, vmon, vyear, email, phonenumber, comment); List <string> imgname = new List <string>(); List <string> comments = new List <string>(); for (int i = 0; i < image_count; i++) { imgname.Add(Request.Form["img" + i]); comments.Add(Request.Form["com" + i]); } BookDBProvider.addImagecomment(propNum, newid, comments, imgname); string msg_format = @"Dear Linda <br/> {0} has commented to property {1} <br/> Travel Date: {2} <br/> Email: {3} <br/> Phone: {4} <br/> Comment: {5} <br/> Rate: {6} <br/>"; string msg = String.Format(msg_format, String.Format("{0} {1}", fname, lname), propNum, String.Format("{0} {1}", vyear, vmon) , email, phonenumber, comment, rate); BookDBProvider.SendEmail("*****@*****.**", "Comment Notification", msg); }