protected void signUp_Click1(object sender, EventArgs e)
{
string userId = (userid.Text).Trim();
string FName = (fname.Text).Trim();
string LName = (lname.Text).Trim();
string Address1 = (address1.Text).Trim();
string Address2 = (address2.Text).Trim();
string City = (city.Text).Trim();
string State = (state.Text).Trim();
string Zip = (zip.Text).Trim();
string Country = (country.Text).Trim();
string PhoneNum = (phoneNumber.Text).Trim();
string Carrier = networkProvider.SelectedValue;
string Workphone = (workphone.Text).Trim();
string Email = (email.Text).Trim();
string Password = (signUpPassword.Text).Trim();
string Role = role.SelectedValue;
string selectRole = "";
switch (Role)
{
case "P":
selectRole = "Public";
break;
case "SC":
selectRole = "Steering Committe";
break;
case "A":
selectRole = "Admin";
break;
}
if (Page.IsPostBack)
{
Page.Validate();
if (Page.IsValid)
{
SqlConnection dbConnection = new SqlConnection("Data Source=itksqlexp8;Integrated Security=true");
try
{
dbConnection.Open();
dbConnection.ChangeDatabase("nasa_SilentAuction_v1");
// string SQLString = "SELECT * FROM users WHERE userID='" + userId + "'";
string SQLString = "SELECT userID FROM users WHERE userID= @user_id";
SqlCommand checkIDTable = new SqlCommand(SQLString, dbConnection);
checkIDTable.Parameters.AddWithValue("@user_id", userId);
SqlDataReader idRecords = checkIDTable.ExecuteReader();
if (idRecords.Read())
{
// form1.Visible = false;
SignUpReply.Text = "User ID already exist. Use another user ID";
idRecords.Close();
}
else
{
idRecords.Close();
string UserInfo =
"INSERT INTO users (userID,firstName,lastName," +
"addressLine1,addressLine2,city,stateName,zip,country," +
"phoneHome,cellPhone,phncarrier,email,role,approvalStatus," +
"password,app_pending)" +
"VALUES(@userId,@FName,@LName,@Address1,@Address2,@City,@State," +
"@Zip,@Country,@PhoneNum,@Workphone,@Carrier,@Email," +
"@selectRole,@app_status,@Password,@app_pending)";
SqlCommand sqlCommandEmp = new SqlCommand(UserInfo, dbConnection);
sqlCommandEmp.Parameters.AddWithValue("@userId", userId);
sqlCommandEmp.Parameters.AddWithValue("@FName", FName);
sqlCommandEmp.Parameters.AddWithValue("@LName", LName);
sqlCommandEmp.Parameters.AddWithValue("@Address1", Address1);
sqlCommandEmp.Parameters.AddWithValue("@Address2", Address2);
sqlCommandEmp.Parameters.AddWithValue("@City", City);
sqlCommandEmp.Parameters.AddWithValue("@State", State);
sqlCommandEmp.Parameters.AddWithValue("@Zip", Zip);
sqlCommandEmp.Parameters.AddWithValue("@Country", Country);
sqlCommandEmp.Parameters.AddWithValue("@PhoneNum", PhoneNum);
sqlCommandEmp.Parameters.AddWithValue("@Workphone", Workphone);
sqlCommandEmp.Parameters.AddWithValue("@Carrier", Carrier);
sqlCommandEmp.Parameters.AddWithValue("@Email", Email);
sqlCommandEmp.Parameters.AddWithValue("@selectRole", selectRole);
sqlCommandEmp.Parameters.AddWithValue("@app_status", false);
sqlCommandEmp.Parameters.AddWithValue("@Password", Password);
sqlCommandEmp.Parameters.AddWithValue("@app_pending", true);
sqlCommandEmp.ExecuteNonQuery();
SignUpReply.Text = "SignUp Succesfull";
//form1.Visible = false;
string message = "Thank you for siging up with us. You will receive an email shortly. Please Check your inbox. Happy Bidding :)";
textMessage = new SMSService(Carrier, PhoneNum, message);
textMessage.SendTextMessage(textMessage);
MailAddress messageTo = new MailAddress(Email);
MailMessage emailMessage = new MailMessage();
emailMessage.To.Add(messageTo.Address);
string messageSubject = ("Thank you For SignUp");
string messageBody = ("You Successfuly Signed Up, please wait for the Approval :) " +
Environment.NewLine + " First Name: " + FName + Environment.NewLine + " Last Name: " + LName +
Environment.NewLine + " User ID: " + userId +
Environment.NewLine + " Email: " + Email);
//Attachment logo = new Attachment(Server.MapPath("Capture.JPG"));
//logo.ContentId = "Capture.JPG";
//emailMessage.Attachments.Add(logo);
emailMessage.Subject = messageSubject;
emailMessage.Body = messageBody;
SmtpClient mailClient = new SmtpClient();
mailClient.UseDefaultCredentials = true;
mailClient.Send(emailMessage);
SignUpReply.Text += " Thank you for the SignUp, Please wait for the account approval. Thank you for your patience";
SignUpReply.ForeColor = Color.Green;
}
}
catch (SqlException exception)
{
Response.Write("<p>Error code " + exception.Number
+ ": " + exception.Message + "</p>");
}
}
}
}
public void SendTextMessage(SMSService textMessage)
{
var sms = new SUSMSClient();
sms.sendSMS(textMessage.Provider, textMessage.Number, textMessage.Message);
}
protected void signUp_Click1(object sender, EventArgs e)
{
string userId = (userid.Text).Trim();
string FName = (fname.Text).Trim();
string LName = (lname.Text).Trim();
string Address1 = (address1.Text).Trim();
string Address2 = (address2.Text).Trim();
string City = (city.Text).Trim();
string State = (state.Text).Trim();
string Zip = (zip.Text).Trim();
string Country = (country.Text).Trim();
string PhoneNum = (phoneNumber.Text).Trim();
string Carrier = networkProvider.SelectedValue;
string Workphone = (workphone.Text).Trim();
string Email = (email.Text).Trim();
string Password = (signUpPassword.Text).Trim();
string Role = role.SelectedValue;
string selectRole = "";
switch (Role)
{
case "P":
selectRole = "Public";
break;
case "SC":
selectRole = "SC";
break;
case "A":
selectRole = "Admin";
break;
}
if (Page.IsPostBack)
{
Page.Validate();
if (Page.IsValid)
{
SqlConnection dbConnection = new SqlConnection("Data Source=itksqlexp8;Integrated Security=true");
try
{
dbConnection.Open();
dbConnection.ChangeDatabase("nasa_SilentAuction_v1");
// string SQLString = "SELECT * FROM users WHERE userID='" + userId + "'";
string SQLString = "SELECT userID FROM users WHERE userID= @user_id";
SqlCommand checkIDTable = new SqlCommand(SQLString, dbConnection);
checkIDTable.Parameters.AddWithValue("@user_id", userId);
SqlDataReader idRecords = checkIDTable.ExecuteReader();
if (idRecords.Read())
{
// form1.Visible = false;
SignUpReply.Text = "User ID already exist. Use another user ID";
SignUpReply.ForeColor = System.Drawing.Color.Red;
idRecords.Close();
}
else
{
idRecords.Close();
string UserInfo =
"INSERT INTO users (userID,firstName,lastName," +
"addressLine1,addressLine2,city,stateName,zip,country," +
"phoneHome,cellPhone,phncarrier,email,role,approvalStatus," +
"password,app_pending)" +
"VALUES(@userId,@FName,@LName,@Address1,@Address2,@City,@State," +
"@Zip,@Country,@PhoneNum,@Workphone,@Carrier,@Email," +
"@selectRole,@app_status,@Password,@app_pending)";
SqlCommand sqlCommandEmp = new SqlCommand(UserInfo, dbConnection);
sqlCommandEmp.Parameters.AddWithValue("@userId", userId);
sqlCommandEmp.Parameters.AddWithValue("@FName", FName);
sqlCommandEmp.Parameters.AddWithValue("@LName", LName);
sqlCommandEmp.Parameters.AddWithValue("@Address1", Address1);
sqlCommandEmp.Parameters.AddWithValue("@Address2", Address2);
sqlCommandEmp.Parameters.AddWithValue("@City", City);
sqlCommandEmp.Parameters.AddWithValue("@State", State);
sqlCommandEmp.Parameters.AddWithValue("@Zip", Zip);
sqlCommandEmp.Parameters.AddWithValue("@Country", Country);
sqlCommandEmp.Parameters.AddWithValue("@PhoneNum", PhoneNum);
sqlCommandEmp.Parameters.AddWithValue("@Workphone", Workphone);
sqlCommandEmp.Parameters.AddWithValue("@Carrier", Carrier);
sqlCommandEmp.Parameters.AddWithValue("@Email", Email);
sqlCommandEmp.Parameters.AddWithValue("@selectRole", selectRole);
sqlCommandEmp.Parameters.AddWithValue("@app_status", false);
sqlCommandEmp.Parameters.AddWithValue("@Password", Password);
sqlCommandEmp.Parameters.AddWithValue("@app_pending", true);
int rowcount = sqlCommandEmp.ExecuteNonQuery();
//if (rowcount == 1) {
// SignUpReply.Text = "SignUp Succesfull";
//}
//else
//form1.Visible = false;
string message = "Thank you for siging up with us. You will receive an email shortly. Please Check your inbox. Happy Bidding :)";
textMessage = new SMSService(Carrier, PhoneNum, message);
textMessage.SendTextMessage(textMessage);
// commented because no mail account setup
MailAddress messageTo = new MailAddress(Email);
MailMessage emailMessage = new MailMessage();
emailMessage.To.Add(messageTo.Address);
string messageSubject = ("Thank you For SignUp");
string messageBody = ("You Successfuly Signed Up, please wait for the Approval :) " +
Environment.NewLine + " First Name: " + FName + Environment.NewLine + " Last Name: " + LName +
Environment.NewLine + " User ID: " + userId +
Environment.NewLine + " Email: " + Email);
emailMessage.Subject = messageSubject;
emailMessage.Body = messageBody;
SmtpClient mailClient = new SmtpClient();
mailClient.UseDefaultCredentials = true;
mailClient.Send(emailMessage);
SignUpReply.Text += " Thank you for the SignUp, Please wait for the account approval. Thank you for your patience";
SignUpReply.ForeColor = Color.Green;
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Successfully Signup. Please wait for the account approval')", true);
}
}
catch (SqlException exception)
{
Response.Write("<p>Error code " + exception.Number
+ ": " + exception.Message + "</p>");
}
}
}
}
public void SendTextMessage(SMSService textMessage)
{
var sms = new SUSMSClient();
sms.sendSMS(textMessage.Provider, textMessage.Number, textMessage.Message);
}
