private void recordData_Click(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection("Data Source=.;Initial Catalog=CarInsuranceSystem;Integrated Security=True");
connection.Open();
SqlCommand checkEmail = new SqlCommand("SELECT count(*) FROM Car_Owner WHERE Email='" + email.Text.ToString() + "';", connection);
SqlCommand checkusername = new SqlCommand("SELECT count(*) FROM Car_Owner WHERE UserName='******';", connection);
int mail = (int)checkEmail.ExecuteScalar();
int userCheck = (int)checkusername.ExecuteScalar();
bool saveData = true;
Regex emailForm = new Regex(@"^\w+([-_.]\w+)*@\w+([-.]\w)*\.\w+([-.]\w+)*$");
error.Visible = false; p1.Visible = false; p2.Visible = false; p3.Visible = false;
p4.Visible = false; p5.Visible = false;
p6.Visible = false; p7.Visible = false;
p8.Visible = false; p14.Visible = false;
if (!female.Checked && !male.Checked)
{
saveData = false; error.Text = "Please, Select a gender.";
error.Visible = true; saveData = false;
}
if (PaymentMethod.SelectedIndex < 0)
{
error.Visible = true; saveData = false; p8.Visible = true; error.Text = "Please, Select a paymant Method."; PaymentMethod.Focus();
}
if (typeOfinsurance.SelectedIndex < 0)
{
error.Visible = true; saveData = false; p7.Visible = true; error.Text = "Please, Select a Status."; PaymentMethod.Focus();
}
if (key.SelectedIndex < 0)
{
error.Visible = true; saveData = false; p6.Visible = true; error.Text = "Please, Select a key."; key.Focus();
}
if (phoneNum.Text.Trim() == "" || (phoneNum.Text.Trim() == "Phone number" && phoneNum.ForeColor == Color.DarkGray))
{
phoneNum.Focus(); saveData = false;
phoneNum.BackColor = Color.AliceBlue; p6.Visible = true;
error.Visible = true; error.Text = "Please, Enter a Phone Number.";
}
else if (phoneNum.Text.Length < 11)
{
error.Visible = true; p6.Visible = true;
error.Text = "Invalid Phone Number";
phoneNum.Focus(); saveData = false;
}
if (repassword.Text.Trim() == "" || (repassword.Text.Trim() == "Re-enter password" && repassword.ForeColor == Color.DarkGray) || repassword.Text.Trim() != password.Text.Trim())
{
repassword.Focus(); saveData = false; p5.Visible = true;
repassword.BackColor = Color.AliceBlue;
}
if (password.Text.Trim() == "" || (password.Text.Trim() == "Password" && password.ForeColor == Color.DarkGray))
{
password.Focus(); password.BackColor = Color.AliceBlue; saveData = false; p4.Visible = true;
}
else if (password.Text.Length < 8)
{
error.Visible = true; error.Text = "Password is at least 8 Characters. "; p4.Visible = true;
}
if (username.Text.Trim() == "" || (username.Text.Trim() == "Username" && username.ForeColor == Color.DarkGray))
{
username.Focus(); username.BackColor = Color.AliceBlue; saveData = false; p3.Visible = true;
}
else if (userCheck != 0)
{
error.Text = "This Username's already exist."; error.Visible = true; saveData = false; p3.Visible = true;
}
if (email.Text.Trim() == "" || (email.Text.Trim() == "Email" && email.ForeColor == Color.DarkGray))
{
email.Focus(); email.BackColor = Color.AliceBlue; saveData = false; p2.Visible = true;
error.Visible = false;
}
else if (!emailForm.IsMatch(email.Text.Trim()))
{
error.Text = "Please, Enter Valid email."; error.Visible = true; saveData = false; p2.Visible = true; email.Focus();
}
else if (mail != 0)
{
error.Text = "This email's already exist."; error.Visible = true; saveData = false; p2.Visible = true; email.Focus();
}
if (lastname.Text.Trim() == "" || (lastname.Text.Trim() == "LastName" && lastname.ForeColor == Color.DarkGray))
{
lastname.Focus(); lastname.BackColor = Color.AliceBlue; saveData = false; p1.Visible = true;
error.Text = "Please, Enter Full data."; error.Visible = true;
}
if (firstname.Text.Trim() == "" || (firstname.Text.Trim() == "FirstName" && firstname.ForeColor == Color.DarkGray))
{
firstname.Focus(); firstname.BackColor = Color.AliceBlue; saveData = false; p14.Visible = true;
error.Text = "Please, Enter Full data."; error.Visible = true;
}
if (saveData)
{
string gender = (female.Checked) ? "Female" : "Male";
SqlCommand command = new SqlCommand("Signup", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@FirstName", firstname.Text.Trim()));
command.Parameters.Add(new SqlParameter("@LastName", lastname.Text.Trim()));
command.Parameters.Add(new SqlParameter("@UserName", username.Text.Trim()));
command.Parameters.Add(new SqlParameter("@Password", password.Text.Trim()));
command.Parameters.Add(new SqlParameter("@Email", email.Text.Trim()));
command.Parameters.Add(new SqlParameter("@Phone_Num1", phoneNum.Text.Trim()));
command.Parameters.Add(new SqlParameter("@TypeOfInsurance", typeOfinsurance.SelectedItem));
command.Parameters.Add(new SqlParameter("@payment", PaymentMethod.SelectedItem.ToString().Trim()));
command.Parameters.Add(new SqlParameter("@Gender", gender.Trim()));
command.ExecuteNonQuery();
reset();
this.Refresh();
MessageBox.Show("SignedUp successfully.");
}
connection.Close();
}
