protected void btnConfirm_Click(object sender, EventArgs e)
{
List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>();
parms.Add(new SqlJacknife.ParmStruct("@ID_Order", 0, 20, SqlDbType.Int, ParameterDirection.Output));
parms.Add(new SqlJacknife.ParmStruct("@ID_Cart", Session["ID_Cart"], 8, System.Data.SqlDbType.Int, System.Data.ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@ShippingAddress", Request.Cookies["address"].Value, 300, System.Data.SqlDbType.NVarChar, System.Data.ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@PaymentType", Session["Payment"].ToString(), 20, System.Data.SqlDbType.NVarChar, System.Data.ParameterDirection.Input));
try
{
String OrderId = SqlJacknife.SendCommandGetString("PlaceOrderOutput", parms);
sendEmail(OrderId);
Response.Cookies.Clear();
Response.Cookies["ID_Cart"].Expires = DateTime.Now.AddDays(-1);
String ordered = Session["ID_Cart"].ToString();
Session["ID_Cart"] = "";
Response.Redirect("Ordered.aspx?ordered=" + ordered + "&messageSuccess=Your ideas are on the way!");
}
catch (Exception ex)
{
master.messageError(ex.Message);
}
}
protected void CreateAccount()
{
using (SqlConnection conn = new SqlConnection(cnnString))
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
String validCode = generateGarble(8);
String message = "Hello, " + fname.Text + ",</br> Please follow the link to validate your account"
+ "<p><a href = 'http://*****:*****@ID_cust", null, 0, SqlDbType.Int, ParameterDirection.Output));
parms.Add(new SqlJacknife.ParmStruct("@fname", fname.Text, 20, SqlDbType.VarChar, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@mname", mname.Text, 20, SqlDbType.VarChar, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@lname", lname.Text, 20, SqlDbType.VarChar, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@username", username.Text, 20, SqlDbType.VarChar, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@password", password.Text, 50, SqlDbType.VarChar, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@dob", ExtractBirthday(), 0, SqlDbType.Date, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@street", address.Text, 20, SqlDbType.VarChar, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@city", city.Text, 20, SqlDbType.VarChar, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@state", sOrP.Text, 20, SqlDbType.VarChar, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@zip", zip.Text, 10, SqlDbType.NVarChar, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@country", country.Text, 20, SqlDbType.VarChar, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@phone", phone.Text, 10, SqlDbType.VarChar, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@email", email.Text, 50, SqlDbType.VarChar, ParameterDirection.Input));
parms.Add(new SqlJacknife.ParmStruct("@Validate", validCode, 8, SqlDbType.Char, ParameterDirection.Input));
string ID = SqlJacknife.SendCommandGetString("CreateCustomer", parms);
if (ID != "0")
{
master.messageSuccess("Account Created Successfully, ID: " + ID.ToString());
trans.Commit();
}
IdeaHeaderAndSide.sendEmail(email.Text, "ideaShopRobot@noreply", "One last step, " + fname.Text, message);
}
catch (Exception ex)
{
master.messageLoggedError(ex.Message);
IdeaHeaderAndSide.logMessage("IdeaShop-Account Editor: Create Account", ex.Message);
trans.Rollback();
}
}
}