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(); }