private void UpdateStudyGroups(object sender, SelectionChangedEventArgs e)
{
var sqlParams = new[]
{
new SqlParameter
{
ParameterName = "@InstituteId",
Value = _mainWindow.Institutes[InstitutesComboBox.SelectedIndex].InstituteId
}
};
var studyGroups = SqlServer.SqlServer.ExecuteStoredProcedure(_connectionString, _userCredential,
"GetStudyGroupsByInstitute", "StudyGroupsView", sqlParams).Tables["StudyGroupsView"].Rows;
StudyGroups = StudyGroup.GetCollection(studyGroups);
StudyGroupsComboBox.ItemsSource = StudyGroups.Select(g => g.CourseName + " " + g.GroupNum);
}
public void UpdateStudyGroupsDataGrid(object sender, SelectionChangedEventArgs e)
{
if (DepartmentsComboBox.SelectedIndex == -1)
{
Groups = null;
return;
}
var sqlParams = new[]
{
new SqlParameter
{
ParameterName = "@DepartmentId",
Value = Departments[DepartmentsComboBox.SelectedIndex].DepartmentId
}
};
var groups = SqlServer.SqlServer.ExecuteStoredProcedure(_connectionString, _userCredential,
"GetStudyGroupsByDepartment", "StudyGroupsView", sqlParams).Tables["StudyGroupsView"].Rows;
Groups = StudyGroup.GetCollection(groups);
}
