private void SubmitButton_Click(object sender, EventArgs e)
{
if (!String.Equals(PasswordTextbox.Text, ConfirmTextbox.Text))
{
label13.Text = "Passwords Must Match";
label13.Visible = true;
}
else
{
string str = Properties.Settings.Default.DefaultConnection;
SqlConnection con = new SqlConnection
{
ConnectionString = str
};
con.Open();
SqlCommand cmd = new SqlCommand("Insert into Employee(SSN, FirstName, LastName, City, State, " +
"ZipCode, Email, Password, Telephone, StartDate, HourlyRate, Type) " +
"Values(@SSN, @FirstName, @LastName, @City, @State, @ZipCode, @Email, @Password, @Telephone, @AccountCreationDate, " +
"@HourlyRate, @AccountType)", con);
cmd.Parameters.AddWithValue("@SSN", SSNTextbox.Text);
cmd.Parameters.AddWithValue("@FirstName", FirstNameTextbox.Text);
cmd.Parameters.AddWithValue("@LastName", LastNameTextbox.Text);
cmd.Parameters.AddWithValue("@City", CityTextbox.Text);
cmd.Parameters.AddWithValue("@State", StateTextbox.Text);
cmd.Parameters.AddWithValue("@ZipCode", ZipTextbox.Text);
cmd.Parameters.AddWithValue("@Email", EmailTextbox.Text);
cmd.Parameters.AddWithValue("@Password", PasswordTextbox.Text);
cmd.Parameters.AddWithValue("@Telephone", TelephoneTextbox.Text);
cmd.Parameters.AddWithValue("@AccountCreationDate", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@HourlyRate", HourlyWageTextBox.Text);
cmd.Parameters.AddWithValue("@AccountType", comboBox1.Text);
cmd.ExecuteNonQuery();
label13.Text = "Successfully Added " + FirstNameTextbox.Text + " " + LastNameTextbox.Text;
label13.Visible = true;
//Clear the textboxes
SSNTextbox.Clear();
FirstNameTextbox.Clear();
FirstNameTextbox.Clear();
LastNameTextbox.Clear();
CityTextbox.Clear();
StateTextbox.Clear();
ZipTextbox.Clear();
EmailTextbox.Clear();
PasswordTextbox.Clear();
ConfirmTextbox.Clear();
TelephoneTextbox.Clear();
HourlyWageTextBox.Clear();
comboBox1.SelectedIndex = -1;
}
}
private void ClearForm()
{
if (UserId == 0)
{
IdTextbox.Text = "0";
UsernameTextbox.Clear();
FirstnameTextbox.Clear();
LastnameTextbox.Clear();
PasswordTextbox.Clear();
ConfirmTextbox.Clear();
IsAdminCheckbox.Checked = false;
IsApproverCheckbox.Checked = false;
IsVisitorCheckbox.Checked = false;
}
else
{
LoadUserDetails();
}
passwordNotMatch = false;
}