Exemple #1
0
        private void WybierzUzytkownika_SelectionChanged(object sender, MouseButtonEventArgs e)
        {
            if (this.contentDataGrid.SelectedIndex >= 0 && this.contentDataGrid.AlternationCount >= 0)
            {
                LecturerCursesDataView course = (LecturerCursesDataView)this.contentDataGrid.SelectedItems[0];

                choosenCourseID   = course.IndexCourse;
                choosenCourseName = course.NameOfCourse;
                CreateZajeciaPrzegladanieGrup();
            }
        }
        public List <LecturerCursesDataView> DataBaseShowLecturerCurses(User user)
        {
            command = new MySqlCommand($"CALL wyswietl_prowadzone_kursy_prowadzacego('{user.UserID}')", this.conection);
            reader  = command.ExecuteReader();
            List <LecturerCursesDataView> lecturerCursesDatas = new List <LecturerCursesDataView>();

            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    LecturerCursesDataView lecturerCursesData = new LecturerCursesDataView();
                    lecturerCursesData.IndexCourse  = int.Parse(reader.GetValue(0).ToString());
                    lecturerCursesData.NameOfCourse = reader.GetValue(1).ToString();
                    lecturerCursesData.Ects         = int.Parse(reader.GetValue(2).ToString());
                    lecturerCursesDatas.Add(lecturerCursesData);
                }
            }
            reader.Close();
            return(lecturerCursesDatas);
        }