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);
}
}
}
