private void gridTeacherStudents_CellValueChanged(object sender, DataGridViewCellEventArgs e) { DataGridViewRow row = gridTeacherStudents.SelectedRows[0]; int entryId = Convert.ToInt32(row.Cells["EntryId"].Value); int partialExam = Convert.ToInt32(row.Cells["PartialExam"].Value == DBNull.Value ? 0 : row.Cells["PartialExam"].Value); int finalExam = Convert.ToInt32(row.Cells["FinalExam"].Value == DBNull.Value ? 0 : row.Cells["FinalExam"].Value); int laboratory = Convert.ToInt32(row.Cells["Laboratory"].Value == DBNull.Value ? 0 : row.Cells["Laboratory"].Value); int seminary = Convert.ToInt32(row.Cells["Seminary"].Value == DBNull.Value ? 0 : row.Cells["Seminary"].Value); int bonusPoints = Convert.ToInt32(row.Cells["BonusPoints"].Value == DBNull.Value ? 0 : row.Cells["BonusPoints"].Value); BLTeachers bl = new BLTeachers(); bl.UpdateCatalogInfo(entryId, partialExam, finalExam, laboratory, seminary, bonusPoints); String studentName = String.IsNullOrWhiteSpace(txtNameFilter.Text) == true ? "" : txtNameFilter.Text; String studyGroup = String.IsNullOrWhiteSpace(txtGroupFilter.Text) == true ? "" : txtGroupFilter.Text; gridTeacherStudents.Rows.Clear(); gridTeacherStudents.Columns.Clear(); List <CatalogInfoModel> list = new List <CatalogInfoModel>(); DataGridViewRow row1 = gridTeacherCourses.SelectedRows[0]; list = bl.GetTeacherStudents(Convert.ToInt32(row1.Cells["CourseId"].Value), row1.Cells["StudySet"].Value.ToString(), studentName, studyGroup); gridTeacherStudents.Columns.Add("EntryId", "EntryId"); gridTeacherStudents.Columns.Add("StudentId", "StudentId"); gridTeacherStudents.Columns.Add("StudyGroup", "Grupa"); gridTeacherStudents.Columns.Add("StudentName", "Nume"); gridTeacherStudents.Columns.Add("Laboratory", "Laborator"); gridTeacherStudents.Columns.Add("Seminary", "Seminar"); gridTeacherStudents.Columns.Add("PartialExam", "Examen partial"); gridTeacherStudents.Columns.Add("FinalExam", "Examen final"); gridTeacherStudents.Columns.Add("BonusPoints", "Puncte bonus"); gridTeacherStudents.Columns.Add("Total", "Total"); gridTeacherStudents.Columns.Add("LastUpdate", "Ultima actualizare"); gridTeacherStudents.Columns[0].Visible = false; gridTeacherStudents.Columns[1].Visible = false; gridTeacherStudents.Columns[2].ReadOnly = true; gridTeacherStudents.Columns[3].ReadOnly = true; gridTeacherStudents.Columns[9].ReadOnly = true; gridTeacherStudents.Columns[10].ReadOnly = true; foreach (CatalogInfoModel catalogInfo in list) { gridTeacherStudents.Rows.Add(catalogInfo.EntryId, catalogInfo.Student.StudentId, catalogInfo.Student.StudyGroup, catalogInfo.Student.StudentName, catalogInfo.Laboratory, catalogInfo.Seminary, catalogInfo.PartialExam, catalogInfo.FinalExam, catalogInfo.BonusPoints, catalogInfo.Total, catalogInfo.LastUpdate); } gridTeacherStudents.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }
private void gridTeacherCourses_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e) { lblSelectCourse.Text = ""; lblFilter.Visible = true; lblName.Visible = true; lblGroup.Visible = true; pictureFilter.Visible = true; btnClearFilters.Visible = true; txtNameFilter.Visible = true; txtGroupFilter.Visible = true; gridTeacherStudents.Rows.Clear(); gridTeacherStudents.Columns.Clear(); DataGridViewRow row = gridTeacherCourses.SelectedRows[0]; BLTeachers bl = new BLTeachers(); List <CatalogInfoModel> list = new List <CatalogInfoModel>(); list = bl.GetTeacherStudents(Convert.ToInt32(row.Cells["CourseId"].Value), row.Cells["StudySet"].Value.ToString()); gridTeacherStudents.Columns.Add("EntryId", "EntryId"); gridTeacherStudents.Columns.Add("StudentId", "StudentId"); gridTeacherStudents.Columns.Add("StudyGroup", "Grupa"); gridTeacherStudents.Columns.Add("StudentName", "Nume"); gridTeacherStudents.Columns.Add("Laboratory", "Laborator"); gridTeacherStudents.Columns.Add("Seminary", "Seminar"); gridTeacherStudents.Columns.Add("PartialExam", "Examen partial"); gridTeacherStudents.Columns.Add("FinalExam", "Examen final"); gridTeacherStudents.Columns.Add("BonusPoints", "Puncte bonus"); gridTeacherStudents.Columns.Add("Total", "Total"); gridTeacherStudents.Columns.Add("LastUpdate", "Ultima actualizare"); gridTeacherStudents.Columns[0].Visible = false; gridTeacherStudents.Columns[1].Visible = false; gridTeacherStudents.Columns[2].ReadOnly = true; gridTeacherStudents.Columns[3].ReadOnly = true; gridTeacherStudents.Columns[9].ReadOnly = true; gridTeacherStudents.Columns[10].ReadOnly = true; foreach (CatalogInfoModel catalogInfo in list) { gridTeacherStudents.Rows.Add(catalogInfo.EntryId, catalogInfo.Student.StudentId, catalogInfo.Student.StudyGroup, catalogInfo.Student.StudentName, catalogInfo.Laboratory, catalogInfo.Seminary, catalogInfo.PartialExam, catalogInfo.FinalExam, catalogInfo.BonusPoints, catalogInfo.Total, catalogInfo.LastUpdate); } gridTeacherStudents.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }