private void btnRegister_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtUsername.Text)) { lblErrorMsg.Text = "Enter username"; } else if (checkUsername() == 1) { lblErrorMsg.Text = "username already exists"; } else if (string.IsNullOrEmpty(txtPassword.Text)) { lblErrorMsg.Text = "Enter a password"; } else if (string.IsNullOrEmpty(txtName.Text)) { lblErrorMsg.Text = "Enter name"; } else if (string.IsNullOrEmpty(txtSurname.Text)) { lblErrorMsg.Text = "Enter Surname"; } else if (string.IsNullOrEmpty(ddlGender.Text)) { lblErrorMsg.Text = "Select gender"; } else if (string.IsNullOrEmpty(txtJobTitle.Text)) { lblErrorMsg.Text = "Enter Job Title"; } else { try { SqlConnection conn = new SqlConnection(@"Data Source=KAVEER-PC\MSSQL;Initial Catalog=petcare;Integrated Security=True"); conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO userTable(username,userPassword,name,surname,dob,gender,userStatus,jobTitle,userType) VALUES(@user,@pwd,@name,@surname,@dob,@gender,'active',@jobTitle,'staff')", conn); cmd.Parameters.AddWithValue("@user", txtUsername.Text); cmd.Parameters.AddWithValue("@pwd", MD5Hash(txtPassword.Text)); cmd.Parameters.AddWithValue("@name", txtName.Text); cmd.Parameters.AddWithValue("@surname", txtSurname.Text); cmd.Parameters.AddWithValue("@dob", dpDob.Value.ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@gender", ddlGender.SelectedItem.ToString()); cmd.Parameters.AddWithValue("@jobTitle", txtJobTitle.Text); cmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("New staff added"); this.Close(); AdminHome home = new AdminHome(); home.Show(); } catch (Exception ee) { MessageBox.Show(ee.Message); } } }