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 findLecturers()
{
// filter lecturers based on search keyword
try
{
var searchValue = txtFindLecturer.Text;
var source = LecturerDataAccess.filterLecturers(searchValue);
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);
}
}