public EditAssociatedSubjectWindow(MainWindow mainWindow, string connectionString, SqlCredential credential, AssociatedSubject selectedAssociatedSubject) : this() { _mainWindow = mainWindow; _connectionString = connectionString; _userCredential = credential; _selectedAssociatedSubject = selectedAssociatedSubject; InstitutesComboBox.ItemsSource = _mainWindow.Institutes.Select(i => i.InstituteSName).ToList(); InstitutesComboBox2.ItemsSource = _mainWindow.Institutes.Select(i => i.InstituteSName).ToList(); InstitutesComboBox.SelectedIndex = _mainWindow.InstitutesComboBoxTab5.SelectedIndex; StudyGroupComboBox.SelectedItem = selectedAssociatedSubject.GroupName; SubjectsComboBox.SelectedItem = selectedAssociatedSubject.SubjectName; InstitutesComboBox2.SelectedItem = selectedAssociatedSubject.InstituteSName; DepartmentsComboBox.SelectedItem = selectedAssociatedSubject.DepartmentName; TeachersComboBox.SelectedItem = selectedAssociatedSubject.AcademicRankName + " " + selectedAssociatedSubject.TeacherFullName; }
public void UpdateAssociatedSubjectsDataGrid(object sender, SelectionChangedEventArgs e) { if (CoursesComboBoxTab5.SelectedIndex == -1) { AssociatedSubjects = null; return; } var sqlParams = new[] { new SqlParameter { ParameterName = "@CourseId", Value = CoursesTab5[CoursesComboBoxTab5.SelectedIndex].CourseId } }; var associatedSubjects = SqlServer.SqlServer.ExecuteStoredProcedure(_connectionString, _userCredential, "GetAssociatedSubjectsByCourse", "AssociatedSubjectsView", sqlParams).Tables["AssociatedSubjectsView"] .Rows; AssociatedSubjects = AssociatedSubject.GetCollection(associatedSubjects); }