public void gridRefresh() { try { var source = LecturerCoursesDataAccess.getCourses() .Select(x => new { IndexNo = x.Id, LecturerId = x.LecturerId, LecturerName = x.LecturerName, CourseId = x.CourseId, CourseName = x.CourseName }).ToList(); gridCourseAssignments.DataSource = null; gridCourseAssignments.DataSource = source; gridCourseAssignments.Columns["IndexNo"].HeaderText = "Index #"; gridCourseAssignments.Columns["LecturerId"].HeaderText = "Lecturer ID"; gridCourseAssignments.Columns["LecturerName"].HeaderText = "Lecturer Name"; gridCourseAssignments.Columns["CourseId"].HeaderText = "Course ID"; gridCourseAssignments.Columns["CourseName"].HeaderText = "Course Name"; // setting grid column size gridCourseAssignments.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; gridCourseAssignments.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; gridCourseAssignments.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void txtFind_TextChanged(object sender, EventArgs e) { // filter datagrid try { gridCourseAssignments.DataSource = null; var source = gridCourseAssignments.DataSource = LecturerCoursesDataAccess.filter(txtFind.Text) .Select(x => new { IndexNo = x.Id, LecturerId = x.LecturerId, LecturerName = x.LecturerName, CourseId = x.CourseId, CourseName = x.CourseName }).ToList(); gridCourseAssignments.DataSource = null; gridCourseAssignments.DataSource = source; gridCourseAssignments.Columns["IndexNo"].HeaderText = "Index #"; gridCourseAssignments.Columns["LecturerId"].HeaderText = "Lecturer ID"; gridCourseAssignments.Columns["LecturerName"].HeaderText = "Lecturer Name"; gridCourseAssignments.Columns["CourseId"].HeaderText = "Course ID"; gridCourseAssignments.Columns["CourseName"].HeaderText = "Course Name"; // setting grid column size gridCourseAssignments.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; gridCourseAssignments.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; gridCourseAssignments.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("Do you want to delete this record ?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { var assign = new LecturerCourses(); assign.Id = Convert.ToInt32(recordId); var result = LecturerCoursesDataAccess.delete(assign); if (result == true) { MessageBox.Show("Record has been removed successfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); gridRefresh(); // call grid refresh method clearFileds(); // call clear field method } else { MessageBox.Show("Unable to delete record", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { return; } }
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 btnEdit_Click(object sender, EventArgs e) { // edit lecturer course assign data if (MessageBox.Show("Do you want to update this record ?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { var assign = new LecturerCourses(); assign.Id = Convert.ToInt32(recordId); assign.LecturerId = txtLecturerId.Text; assign.LecturerName = txtLecturerName.Text; assign.CourseId = txtCourseId.Text; assign.CourseName = txtCourseName.Text; var result = LecturerCoursesDataAccess.edit(assign); if (result == true) { MessageBox.Show("Data have been updated sucessfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); gridRefresh(); // call grid refresh method clearFileds(); // call clear field method } else { MessageBox.Show("Unable to update data", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { return; } }
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); } }
private void btnAdd_Click(object sender, EventArgs e) { // assign courses if (txtLecturerId.Text == "" || txtLecturerName.Text == "" || txtCourseId.Text == "" || txtCourseName.Text == "") { MessageBox.Show("Please check the fields", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { try { var assign = new LecturerCourses(); assign.LecturerId = txtLecturerId.Text; assign.LecturerName = txtLecturerName.Text; assign.CourseId = txtCourseId.Text; assign.CourseName = txtCourseName.Text; var result = LecturerCoursesDataAccess.assignCourse(assign); if (result == true) { MessageBox.Show("Lecturer has been added successfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); gridRefresh(); // call grid refresh method clearFileds(); // call clear field method } else { MessageBox.Show("Unable to add lecturer", "Message", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }