public void SaveUserTransaction(UserTransaction transaction)
{
DB db = new DB();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddUserTransaction";
cmd.Parameters.AddWithValue("@ProductID", transaction.ProductID);
cmd.Parameters.AddWithValue("@FirstName", transaction.FirstName);
cmd.Parameters.AddWithValue("@LastName", transaction.LastName);
cmd.Parameters.AddWithValue("@Email", transaction.Email);
cmd.Parameters.AddWithValue("@Password", transaction.Password);
cmd.Parameters.AddWithValue("@Address", transaction.Address);
cmd.Parameters.AddWithValue("@City", transaction.City);
cmd.Parameters.AddWithValue("@Zip", transaction.Zip);
cmd.Parameters.AddWithValue("@State", transaction.State);
cmd.Parameters.AddWithValue("@Phone", transaction.Phone);
cmd.Parameters.AddWithValue("@Amount", transaction.Amount);
db.Execute(cmd);
return;
}
public static void SendWelcomeMailWorkShop(UserTransaction transaction, decimal amt, string ProductName)
{
var InfoEmail = System.Configuration.ConfigurationManager.AppSettings["InfoEmail"];
var CustServiceEmail = System.Configuration.ConfigurationManager.AppSettings["CustServiceEmail"];
var TestInfoEmail = System.Configuration.ConfigurationManager.AppSettings["TestInfoEmail"];
var TestCustServiceEmail = System.Configuration.ConfigurationManager.AppSettings["TestCustServiceEmail"];
var sb = new StringBuilder();
sb.Append("Name: ").Append(transaction.FirstName).Append(" ").AppendLine(transaction.LastName);
sb.Append("Email: ").AppendLine(transaction.Email);
sb.Append("Address: ").AppendLine(transaction.Address);
sb.Append("City: ").AppendLine(transaction.City);
sb.Append("State: ").AppendLine(transaction.State);
sb.Append("Zip: ").AppendLine(transaction.Zip);
sb.Append("Phone: ").AppendLine(transaction.Phone);
sb.Append("Amount Paid: $").AppendLine(amt.ToString());
sb.AppendLine();
sb.Append("WorkShop Purchased: ").AppendLine(ProductName);
sb.AppendLine();
sb.Append("This is confirmation of your purchase of the Workshop.");
sb.Append("If you have any questions please e-mail at: [email protected]");
var sbAdmin = new StringBuilder();
sbAdmin.Append("Name: ").Append(transaction.FirstName).Append(" ").AppendLine(transaction.LastName);
sbAdmin.Append("Email: ").AppendLine(transaction.Email);
sbAdmin.Append("Address: ").AppendLine(transaction.Address);
sbAdmin.Append("City: ").AppendLine(transaction.City);
sbAdmin.Append("State: ").AppendLine(transaction.State);
sbAdmin.Append("Zip: ").AppendLine(transaction.Zip);
sbAdmin.Append("Phone: ").AppendLine(transaction.Phone);
sbAdmin.Append("Amount Paid: $").AppendLine(amt.ToString());
sbAdmin.AppendLine();
sbAdmin.Append("Product Purchased: ").AppendLine(ProductName);
var isTest = Convert.ToBoolean(System.Configuration.ConfigurationManager.AppSettings["IsTestMode"]);
var IsTestEmailDelivery = Convert.ToBoolean(System.Configuration.ConfigurationManager.AppSettings["IsTestEmailDelivery"]);
var TestString = String.Empty;
if (isTest)
{
TestString = " - Testing Please Ignore";
}
if (IsTestEmailDelivery)
{
SendMail(transaction.Email, TestCustServiceEmail, "Thank you for Purchasing The Myss.com Workshop" + TestString, sb.ToString(), false);
SendMail(TestCustServiceEmail, TestInfoEmail, "New Myss.com Workshop Customer" + TestString, sbAdmin.ToString(), false);
}
else
{
SendMail(transaction.Email, CustServiceEmail, "Thank you for Purchasing The Myss.com Workshop" + TestString, sb.ToString(), false);
SendMail(CustServiceEmail, InfoEmail, "New Myss.com Workshop Customer" + TestString, sbAdmin.ToString(), false);
}
}
protected void RegisterButton_Click(object sender, ImageClickEventArgs e)
{
var id = txtProductID.Value;
if (!string.IsNullOrEmpty(id))
{
if (Helper.IsNumeric(id))
{
ProductID = Int32.Parse(id);
try
{
product = controller.getProduct(ProductID);
}
catch (Exception ex)
{
throw ex;
}
ProductPrice = Convert.ToInt32(product.ProductPrice);
}
else
{
Response.Redirect("http://www.myss.com/");
}
}
var amt = 0;
try
{
if (controller.EmailExists(EmailTextBox.Text.Trim(), ProductID))
{
lblErrorMessage.Text = "You have already signed up for this class.";
ClassLogin.Visible = true;
return;
}
int charge = ProductPrice;
if (charge > 0)
{
CreateCharge(out amt, charge);
UserTransaction transaction = new UserTransaction
{
ProductID = product.ProductID,
FirstName = FirstNameTextBox.Text,
LastName = LastNameTextBox.Text,
Email = EmailTextBox.Text,
Password = PasswordTextBox.Text,
Address = AddressTextBox.Text,
City = CityTextBox.Text,
Zip = ZipTextBox.Text,
State = State.SelectedValue,
Phone = PhoneNumberTextBox.Text,
Amount = Convert.ToDecimal(charge)
};
try
{
controller.SaveUserTransaction(transaction);
Util.SendWelcomeMail(transaction, product);
String s = "product_thankyou.aspx?id=" + ProductID;
Response.Redirect(s);
}
catch (Exception ex)
{
string error = ex.Message;
lblErrorMessage.Text = "Unable to create customer record, please contact myss.com support. ";
return;
}
}
}
catch (Exception ex)
{
string error = ex.Message;
lblErrorMessage.Text = "Unable to process your credit card. Please verify the information or try another card. ";
return;
}
}
public static void SendWelcomeMail(UserTransaction transaction, MyssProduct product)
{
var InfoEmail = System.Configuration.ConfigurationManager.AppSettings["InfoEmail"];
var CustServiceEmail = System.Configuration.ConfigurationManager.AppSettings["CustServiceEmail"];
var TestInfoEmail = System.Configuration.ConfigurationManager.AppSettings["TestInfoEmail"];
var TestCustServiceEmail = System.Configuration.ConfigurationManager.AppSettings["TestCustServiceEmail"];
var sb = new StringBuilder();
sb.Append("Name: ").Append(transaction.FirstName).Append(" ").AppendLine(transaction.LastName);
sb.Append("Email: ").AppendLine(transaction.Email);
sb.Append("Address: ").AppendLine(transaction.Address);
sb.Append("City: ").AppendLine(transaction.City);
sb.Append("State: ").AppendLine(transaction.State);
sb.Append("Zip: ").AppendLine(transaction.Zip);
sb.Append("Phone: ").AppendLine(transaction.Phone);
sb.Append("Amount Paid: $").AppendLine(product.ProductPrice.ToString());
sb.AppendLine();
sb.Append("Product Purchased: ").AppendLine(product.ProductName.ToUpper());
sb.AppendLine();
sb.Append("This is confirmation of your purchase of the Caroline Myss Reflection Class.");
sb.Append("You will receive e-mail instructions to view this class 48 hours prior to the live class.");
sb.Append("If you have any questions please e-mail at: [email protected]");
var sbAdmin = new StringBuilder();
sbAdmin.Append("Name: ").Append(transaction.FirstName).Append(" ").AppendLine(transaction.LastName);
sbAdmin.Append("Email: ").AppendLine(transaction.Email);
sbAdmin.Append("Address: ").AppendLine(transaction.Address);
sbAdmin.Append("City: ").AppendLine(transaction.City);
sbAdmin.Append("State: ").AppendLine(transaction.State);
sbAdmin.Append("Zip: ").AppendLine(transaction.Zip);
sbAdmin.Append("Phone: ").AppendLine(transaction.Phone);
sbAdmin.Append("Amount Paid: $").AppendLine(product.ProductPrice.ToString());
sbAdmin.AppendLine();
sbAdmin.Append("Product Purchased: ").AppendLine(product.ProductName.ToUpper());
var isTest = Convert.ToBoolean(System.Configuration.ConfigurationManager.AppSettings["IsTestMode"]);
var IsTestEmailDelivery = Convert.ToBoolean(System.Configuration.ConfigurationManager.AppSettings["IsTestEmailDelivery"]);
var TestString = String.Empty;
if (isTest)
{
TestString = " - Testing Please Ignore";
}
if (IsTestEmailDelivery)
{
SendMail(transaction.Email, TestCustServiceEmail, "Welcome to Myss.com Reflections Classes" + TestString, sb.ToString(), false);
SendMail(TestCustServiceEmail, TestInfoEmail, "New Myss.com Reflections Customer" + TestString, sbAdmin.ToString(), false);
}
else
{
SendMail(transaction.Email, CustServiceEmail, "Welcome to Myss.com Reflections Classes" + TestString, sb.ToString(), false);
SendMail(CustServiceEmail, InfoEmail, "New Myss.com Reflections Customer" + TestString, sbAdmin.ToString(), false);
}
}
