private void btnAdd_Click(object sender, EventArgs e)
 {
     if (comboBoxCourses.SelectedItem == null)
     {
         MessageBox.Show("Alegeti cursul pe care doriti sa il adaugati profesorului.", "Atentie", MessageBoxButtons.OK, MessageBoxIcon.Warning);
     }
     else if (comboBoxSet.SelectedItem == null)
     {
         MessageBox.Show("Alegeti seria la care doriti sa adaugati cursul.", "Atentie", MessageBoxButtons.OK, MessageBoxIcon.Warning);
     }
     else
     {
         DataGridViewRow row = gridTeachers.SelectedRows[0];
         BLAdmin         bl  = new BLAdmin();
         bl.AddTeacherCourse(Convert.ToInt32(row.Cells["TeacherId"].Value), Convert.ToInt32(comboBoxCourses.SelectedValue), comboBoxSet.GetItemText(comboBoxSet.SelectedItem));
         MessageBox.Show("Cursul a fost adaugat cu succes!", "Succes", MessageBoxButtons.OK, MessageBoxIcon.Information);
         gridCourses.DataSource = bl.GetCourses(Convert.ToInt32(row.Cells["TeacherId"].Value));
         DataTable tableCourses = bl.GetListOfCourses(Convert.ToInt32(row.Cells["TeacherId"].Value));
         comboBoxCourses.ValueMember   = "CourseId";
         comboBoxCourses.DisplayMember = "CourseName";
         comboBoxCourses.DataSource    = tableCourses;
         comboBoxCourses.SelectedItem  = null;
         comboBoxSet.SelectedItem      = null;
         lblCourse.Visible             = true;
         lblSet.Visible = true;
     }
 }
 private void btnDelete_Click(object sender, EventArgs e)
 {
     if (gridCourses.SelectedRows[0] == null)
     {
         MessageBox.Show("Alegeti materia pe care doriti sa o stergeti.", "Atentie", MessageBoxButtons.OK, MessageBoxIcon.Warning);
     }
     else
     {
         DataGridViewRow rowTeacher = gridTeachers.SelectedRows[0];
         DataGridViewRow rowCourse  = gridCourses.SelectedRows[0];
         DialogResult    result     = MessageBox.Show("Sunteti sigur ca doriti sa stergeti " + rowCourse.Cells["CourseName"].Value.ToString() + " din lista de materii predate de " + rowTeacher.Cells["TeacherName"].Value.ToString() + " " + rowTeacher.Cells["TeacherSurname"].Value.ToString() + "?", "Confirmare", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
         if (result == DialogResult.Yes)
         {
             BLAdmin bl = new BLAdmin();
             bl.DeleteTeacherCourse(Convert.ToInt32(rowTeacher.Cells["TeacherId"].Value), Convert.ToInt32(rowCourse.Cells["CourseId"].Value));
             MessageBox.Show("Cursul a fost sters cu succes!", "Succes", MessageBoxButtons.OK, MessageBoxIcon.Information);
             gridCourses.DataSource = bl.GetCourses(Convert.ToInt32(rowTeacher.Cells["TeacherId"].Value));
             DataTable tableCourses = bl.GetListOfCourses(Convert.ToInt32(rowTeacher.Cells["TeacherId"].Value));
             comboBoxCourses.ValueMember   = "CourseId";
             comboBoxCourses.DisplayMember = "CourseName";
             comboBoxCourses.DataSource    = tableCourses;
             comboBoxCourses.SelectedItem  = null;
         }
         else
         {
             return;
         }
     }
 }
        private void gridTeachers_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            DataGridViewRow row = gridTeachers.SelectedRows[0];
            BLAdmin         bl  = new BLAdmin();

            gridCourses.DataSource = bl.GetCourses(Convert.ToInt32(row.Cells["TeacherId"].Value));
            gridCourses.Columns["CourseId"].Visible      = false;
            gridCourses.Columns["CourseName"].HeaderText = "Materie";
            gridCourses.Columns["StudySet"].HeaderText   = "Serie";
            gridCourses.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;

            DataTable tableCourses = bl.GetListOfCourses(Convert.ToInt32(row.Cells["TeacherId"].Value));

            comboBoxCourses.ValueMember   = "CourseId";
            comboBoxCourses.DisplayMember = "CourseName";
            comboBoxCourses.DataSource    = tableCourses;
            comboBoxCourses.SelectedItem  = null;

            lblCourse.Visible       = true;
            lblSet.Visible          = true;
            gridCourses.Visible     = true;
            btnAdd.Visible          = true;
            btnDelete.Visible       = true;
            comboBoxCourses.Visible = true;
            comboBoxSet.Visible     = true;
            lblInfo.Visible         = true;
            lblInfo.Text            = "Lista materiilor predate de " + row.Cells["TeacherName"].Value.ToString() + " " + row.Cells["TeacherSurname"].Value.ToString() + ".";
        }