public void sendEmail() { String url = "http://*****:*****@noreply", "Order Confirmed!", 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(); } } }
private void tryValidate(String validate) { try { List <SqlJacknife.ParmStruct> parms = new List <SqlJacknife.ParmStruct>(); parms.Add(new SqlJacknife.ParmStruct("@Validate", validate, 8, SqlDbType.Char, ParameterDirection.Input)); DataTable dt = SqlJacknife.GetDS("ValidateCustomer", parms).Tables[0]; String fname = dt.Rows[0]["fname"].ToString(); String confirmMessage = "Hello " + fname + ",</br>" + "Your account has been verified and you may now purchase ideas!</br></br>" + "- The Last Braincell Team"; master.messageSuccess(dt.Rows[0]["UserName"].ToString() + " has been validated!"); IdeaHeaderAndSide.sendEmail(dt.Rows[0]["Email"].ToString(), "ideaShopRobot@noreply", "You're In!", confirmMessage); } catch (Exception ex) { master.messageError(ex.Message); } }