예제 #1
0
        private void deleteSubjectButton_Click(object sender, EventArgs e)
        {
            string     selectedGroup = (string)subjectsListBox.SelectedItem;
            SqlCommand comm          = new SqlCommand("SELECT COUNT(*) FROM Groups WHERE SubjectId = @SubjectId");

            comm.Parameters.AddWithValue("@SubjectId", Subjects.GetSubjectIdByName(selectedGroup));
            int groupsAffected = SqlTools.ExecuteScalar(comm);
            // Create a simple MessageBox for admin confirmation.
            DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete the selected subject?\r\n" +
                                                        groupsAffected + " groups will be deleted!",
                                                        "Delete subject",
                                                        MessageBoxButtons.YesNo,
                                                        MessageBoxIcon.Warning);

            switch (dialogResult)
            {
            case DialogResult.Yes:
                Subjects.DeleteSubject(selectedGroup);
                break;

            default:
                // Do nothing
                break;
            }
        }