private void txtCourseId_KeyDown(object sender, KeyEventArgs e) { // find course name try { if (e.KeyCode == Keys.Enter) { var course = new Course(); course.RefNo = txtCourseId.Text; var record = CoursesDataAccess.findCourseById(course); if (record.RefNo == null) { MessageBox.Show("Course-ID not found", "Message", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else if (record.IsRemoved == true) { // Detect inactive student id MessageBox.Show("Inactive Course-ID found", "Message", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { // fill course name textfield txtCourseName.Text = record.Title; gridLecturer.DataSource = null; var source = LecturerCoursesDataAccess.findLectuerersByCourseId(txtCourseId.Text); gridLecturer.DataSource = source.Select(x => new { LecturerId = x.LecturerId, LecturerName = x.LecturerName }).ToList(); gridLecturer.Columns["LecturerId"].HeaderText = "Lecturer ID"; gridLecturer.Columns["LecturerName"].HeaderText = "Lecturer Name"; // setting data grid column width gridLecturer.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } } } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void gridRegistration_MouseDoubleClick(object sender, MouseEventArgs e) { // fill fields try { // activate manage tab metroTabControl1.SelectedTab = tab_Registration; txtStudentId.Text = gridRegistration.SelectedRows[0].Cells[2].Value.ToString(); txtStudentName.Text = gridRegistration.SelectedRows[0].Cells[3].Value.ToString(); txtCourseId.Text = gridRegistration.SelectedRows[0].Cells[4].Value.ToString(); txtCourseName.Text = gridRegistration.SelectedRows[0].Cells[5].Value.ToString(); txtLecturerId.Text = gridRegistration.SelectedRows[0].Cells[6].Value.ToString(); txtLecturerName.Text = gridRegistration.SelectedRows[0].Cells[7].Value.ToString(); // fill lecturer grid gridLecturer.DataSource = null; var source = LecturerCoursesDataAccess.findLectuerersByCourseId(txtCourseId.Text); gridLecturer.DataSource = source.Select(x => new { LecturerId = x.LecturerId, LecturerName = x.LecturerName }).ToList(); gridLecturer.Columns["LecturerId"].HeaderText = "Lecturer ID"; gridLecturer.Columns["LecturerName"].HeaderText = "Lecturer Name"; // setting data grid column width gridLecturer.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }