private void AddStaffbtn_Click_1(object sender, EventArgs e) { DialogResult AddStaff = MessageBox.Show("Are You Sure You Wish To ADD This Staff Member?", "Add Staff", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (AddStaff == DialogResult.Yes) { MySqlConnection con = new MySqlConnection(); con.ConnectionString = LoginForm.constring; con.Open(); MySqlCommand command = con.CreateCommand(); command.CommandText = "INSERT INTO staff (job_id, staff_forename, staff_surname, staff_username, staff_phone, staff_password) VALUES " + "(" + Rolecb.SelectedIndex + ",'" + Forenametxt.Text + "','" + Surnametxt.Text + "','" + Usernametxt.Text + "'," + Phonetxt.Text + ",'" + "password" + "');"; command.ExecuteNonQuery(); MessageBox.Show("The Staff Member Has Been Added Successfully."); con.Close(); ManageStaffAccounts ManageStaffAccounts = new ManageStaffAccounts(); ManageStaffAccounts.Show(); this.Close(); } }
private void Removebtn_Click(object sender, EventArgs e) { DialogResult RemoveStaff = MessageBox.Show("Are You Sure You Wish To DELETE This Staff Member?", "Delete Staff Member", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (RemoveStaff == DialogResult.Yes) { MySqlConnection con = new MySqlConnection(); con.ConnectionString = LoginForm.constring; con.Open(); MySqlCommand command = con.CreateCommand(); command.CommandText = "DELETE FROM staff WHERE staff_username='******';"; command.ExecuteNonQuery(); MessageBox.Show("The Staff Member Has Been Removed Successfully."); con.Close(); ManageStaffAccounts ManageStaffAccounts = new ManageStaffAccounts(); ManageStaffAccounts.Show(); this.Close(); } }
private void StaffAccountsbtn_Click(object sender, EventArgs e) { ManageStaffAccounts ManageStaffAccounts = new ManageStaffAccounts(); ManageStaffAccounts.Show(); this.Dispose(false); }