private void txtFind_TextChanged(object sender, EventArgs e)
{
// filter datagrid
try
{
gridLecturers.DataSource = null;
gridLecturers.DataSource = LecturerDataAccess.filterLecturers(txtFind.Text)
.Select(x => new
{
LecturerID = x.LecturerId,
Surname = x.SurName,
Firstname = x.FirstName,
Lastname = x.LastName,
Nic = x.Nic,
Mobile = x.Mobile,
Email = x.Email,
Address = x.Address,
isRemoved = x.IsRemoved
}).ToList();
gridLecturers.Columns["LecturerID"].HeaderText = "Lecturer ID";
gridLecturers.Columns["Surname"].HeaderText = "Surname";
gridLecturers.Columns["Firstname"].HeaderText = "First Name";
gridLecturers.Columns["Lastname"].HeaderText = "Last Name";
gridLecturers.Columns["Nic"].HeaderText = "NIC #";
gridLecturers.Columns["Mobile"].HeaderText = "Mobile #";
gridLecturers.Columns["Email"].HeaderText = "E-mail";
gridLecturers.Columns["Address"].HeaderText = "Address";
gridLecturers.Columns["isRemoved"].HeaderText = "Inactive";;
}
catch (Exception ex)
{
MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void gridRefresh()
{
// refresh grid
try
{
gridLecturers.DataSource = null;
gridLecturers.DataSource = LecturerDataAccess.getLecturers()
.Select(x => new
{
LecturerID = x.LecturerId,
Surname = x.SurName,
Firstname = x.FirstName,
Lastname = x.LastName,
Nic = x.Nic,
Mobile = x.Mobile,
Email = x.Email,
Address = x.Address,
isRemoved = x.IsRemoved
}).ToList();
gridLecturers.Columns["LecturerID"].HeaderText = "Lecturer ID";
gridLecturers.Columns["Surname"].HeaderText = "Surname";
gridLecturers.Columns["Firstname"].HeaderText = "First Name";
gridLecturers.Columns["Lastname"].HeaderText = "Last Name";
gridLecturers.Columns["Nic"].HeaderText = "NIC #";
gridLecturers.Columns["Mobile"].HeaderText = "Mobile #";
gridLecturers.Columns["Email"].HeaderText = "E-mail";
gridLecturers.Columns["Address"].HeaderText = "Address";
gridLecturers.Columns["isRemoved"].HeaderText = "Inactive";
}
catch (Exception ex)
{
MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
// edit lecturer data
if (MessageBox.Show("Do you want to delete this record ?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
var lecturer = new Lecturer();
lecturer.LecturerId = LecturerId;
lecturer.IsRemoved = true;
LecturerDataAccess.deleteLecturer(lecturer);
MessageBox.Show("Record has been deleted successfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
gridRefresh(); // call grid refresh method
clearField(); // call clear field method
}
catch (Exception ex)
{
MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
return;
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
// edit lecturer data
if (MessageBox.Show("Do you want to edit this record ?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
var lecturer = new Lecturer();
lecturer.LecturerId = LecturerId;
lecturer.SurName = txtSurName.Text;
lecturer.FirstName = txtFirstName.Text;
lecturer.LastName = txtLastName.Text;
lecturer.Nic = txtNic.Text;
lecturer.Address = txtAddress.Text;
lecturer.Mobile = txtMobile.Text;
lecturer.Email = txtEmail.Text;
LecturerDataAccess.editLecturer(lecturer);
MessageBox.Show("Record has been updated successfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
gridRefresh(); // call grid refresh method
clearField(); // call clear field method
}
catch (Exception ex)
{
MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
return;
}
}
private void txtLecturerId_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.Enter)
{
var lecturer = new Lecturer();
lecturer.LecturerId = txtLecturerId.Text;
var record = LecturerDataAccess.findLecturerById(lecturer);
if (record == null)
{
MessageBox.Show("Unable to locate lecturer. Please check lecturer-ID", "Message", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
txtLecturerName.Text = record.FirstName + " " + record.LastName;
}
}
}
catch (Exception ex)
{
MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
// add new lecturer
try
{
var lecturer = new Lecturer();
lecturer.SurName = txtSurName.Text;
lecturer.FirstName = txtFirstName.Text;
lecturer.LastName = txtLastName.Text;
lecturer.Nic = txtNic.Text;
lecturer.Mobile = txtMobile.Text;
lecturer.Email = txtEmail.Text;
lecturer.Address = txtAddress.Text;
var miliseconds = DateTime.Now.Millisecond.ToString();
var first = txtFirstName.Text.Trim().Substring(0, 3);
var lecId = miliseconds + first;
lecturer.LecturerId = lecId; // lecturer id
var result = LecturerDataAccess.addLecturer(lecturer);
if (result = true)
{
MessageBox.Show("Lecturer has been added successfully", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
gridRefresh(); // call grid refresh method
clearField(); // call clear field method
// assign courses
if (MessageBox.Show("Do you want to assign courses for lecturer ?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
var fullname = lecturer.FirstName + " " + lecturer.LastName;
var assign = new frm_assignCourses(lecId, fullname, Role);
var record = assign.ShowDialog();
if (record == DialogResult.OK)
{
assign.Show();
}
else
{
}
}
else
{
return;
}
}
}
catch (Exception ex)
{
MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void showLecturers()
{
// show all lecturers
try
{
var searchValue = txtFindLecturer.Text;
var source = LecturerDataAccess.getLecturers();
gridLecturer.DataSource = source
.Select(x => new
{
LecturerId = x.LecturerId,
Surname = x.SurName,
Firstname = x.FirstName,
Lastname = x.LastName,
Nic = x.Nic,
Email = x.Email,
Mobile = x.Mobile,
Address = x.Address,
IsRemoved = x.IsRemoved
}).Where(x => x.IsRemoved == false).ToList();
gridLecturer.Columns["LecturerId"].HeaderText = "Lecturer ID";
gridLecturer.Columns["Surname"].HeaderText = "Surname";
gridLecturer.Columns["Firstname"].HeaderText = "Firstname";
gridLecturer.Columns["Lastname"].HeaderText = "Lastname";
gridLecturer.Columns["Nic"].HeaderText = "NIC #";
gridLecturer.Columns["Email"].HeaderText = "E-mail";
gridLecturer.Columns["Mobile"].HeaderText = "Mobile";
gridLecturer.Columns["Address"].HeaderText = "Address";
gridLecturer.Columns["IsRemoved"].HeaderText = "Status";
gridLecturer.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
gridLecturer.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
gridLecturer.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
gridLecturer.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
gridLecturer.Columns[8].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
}
catch (Exception ex)
{
MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
