private void StudentGroupListView_CellClick(object sender, DataGridViewCellEventArgs e) { var studentGroup = ((List <StudentGroup>)StudentGroupListView.DataSource)[e.RowIndex]; StudentGroupName.Text = studentGroup.name; groupFromPicker.Value = studentGroup.from; groupToPicker.Value = studentGroup.to; var group = sgRepo.all().FirstOrDefault(sg => sg.name == StudentGroupName.Text); if (group == null) { return; } var groupStudents = sRepo.groupAll(group.id); var studentsView = StudentInGroupView.StudentsInGroupToView(groupStudents) .OrderBy(s => s.fio) .ThenBy(s => s.from) .ToList(); StudentsInGroupListView.DataSource = studentsView; StudentsInGroupListView.Columns["id"].Visible = false; StudentsInGroupListView.Columns["student_id"].Visible = false; StudentsInGroupListView.Columns["fio"].Width = 200; StudentsInGroupListView.Columns["fio"].HeaderText = "Ф.И.О."; StudentsInGroupListView.Columns["from"].Width = 80; StudentsInGroupListView.Columns["from"].HeaderText = "Начало периода"; StudentsInGroupListView.Columns["to"].Width = 80; StudentsInGroupListView.Columns["to"].HeaderText = "Конец периода"; StudentsInGroupListView.Columns["zach_number"].Width = 80; StudentsInGroupListView.Columns["zach_number"].HeaderText = "№ зачётки"; StudentsInGroupListView.Columns["birth_date"].Width = 80; StudentsInGroupListView.Columns["birth_date"].HeaderText = "Дата рождения"; StudentsInGroupListView.Columns["address"].Width = 150; StudentsInGroupListView.Columns["address"].HeaderText = "Адрес"; StudentsInGroupListView.Columns["phone"].Width = 80; StudentsInGroupListView.Columns["phone"].HeaderText = "Телефон"; StudentsInGroupListView.Columns["orders"].Width = 150; StudentsInGroupListView.Columns["orders"].HeaderText = "Приказы"; StudentsInGroupListView.Columns["starosta"].Width = 50; StudentsInGroupListView.Columns["starosta"].HeaderText = "Староста"; StudentsInGroupListView.Columns["n_factor"].Width = 50; StudentsInGroupListView.Columns["n_factor"].HeaderText = "Наяновец"; StudentsInGroupListView.Columns["paid_edu"].Width = 50; StudentsInGroupListView.Columns["paid_edu"].HeaderText = "Платное обучение"; StudentsInGroupListView.Columns["expelled"].Width = 50; StudentsInGroupListView.Columns["expelled"].HeaderText = "Отчислен"; StudentsInGroupListView.Columns["summary"].Visible = false; StudentsInGroupListView.ClearSelection(); }
private void RefreshView(int refreshType) { // 1 - groups only // 2 - students only // 3 - full refresh if ((refreshType == 1) || (refreshType == 3)) { var studentGroupList = sgRepo.all(); studentGroupList = studentGroupList.OrderBy(sg => sg.name).ToList(); StudentGroupListView.DataSource = studentGroupList; StudentGroupListView.Columns["id"].Visible = false; StudentGroupListView.Columns["name"].Width = 80; StudentGroupListView.Columns["from"].Width = 80; StudentGroupListView.Columns["to"].Width = 80; } StudentGroupListView.ClearSelection(); if ((refreshType == 2) || (refreshType == 3)) { var group = sgRepo.all().FirstOrDefault(sg => sg.name == StudentGroupName.Text); if (group == null) { return; } var groupStudents = sRepo.groupAll(group.id); if (groupStudents != null) { var studentsView = StudentInGroupView.StudentsInGroupToView(groupStudents); studentsView = studentsView .OrderBy(s => s.expelled) .ThenBy(s => s.fio) .ToList(); StudentsInGroupListView.DataSource = studentsView; StudentsInGroupListView.Columns["id"].Visible = false; StudentsInGroupListView.Columns["fio"].Width = 200; StudentsInGroupListView.Columns["fio"].HeaderText = "Ф.И.О."; StudentsInGroupListView.Columns["zach_number"].Width = 80; StudentsInGroupListView.Columns["zach_number"].HeaderText = "№ зачётки"; StudentsInGroupListView.Columns["birth_date"].Width = 80; StudentsInGroupListView.Columns["birth_date"].HeaderText = "Дата рождения"; StudentsInGroupListView.Columns["address"].Width = 150; StudentsInGroupListView.Columns["address"].HeaderText = "Адрес"; StudentsInGroupListView.Columns["phone"].Width = 80; StudentsInGroupListView.Columns["phone"].HeaderText = "Телефон"; StudentsInGroupListView.Columns["orders"].Width = 150; StudentsInGroupListView.Columns["orders"].HeaderText = "Приказы"; StudentsInGroupListView.Columns["starosta"].Width = 50; StudentsInGroupListView.Columns["starosta"].HeaderText = "Староста"; StudentsInGroupListView.Columns["n_factor"].Width = 50; StudentsInGroupListView.Columns["n_factor"].HeaderText = "Наяновец"; StudentsInGroupListView.Columns["paid_edu"].Width = 50; StudentsInGroupListView.Columns["paid_edu"].HeaderText = "Платное обучение"; StudentsInGroupListView.Columns["expelled"].Width = 50; StudentsInGroupListView.Columns["expelled"].HeaderText = "Отчислен"; //StudentsInGroupListView.ClearSelection(); } } }