private void LoadDataGridView()
{
EmployeeDAO aEmployeeDao = new EmployeeDAO();
List <Employee> aEmployees = new List <Employee>();
aEmployees = aEmployeeDao.GetAllEmployee();
employeedataGridView.DataSource = aEmployees;
}
public EmployeeSalaryReport()
{
InitializeComponent();
yearcomboBox.SelectedIndex = 0;
monthcomboBox.SelectedIndex = 0;
EmployeeDAO aEmployeeDao = new EmployeeDAO();
List <Employee> aEmployees = new List <Employee>();
aEmployees = aEmployeeDao.GetAllEmployee();
employeecomboBox.DataSource = aEmployees;
employeecomboBox.DisplayMember = "EmployeeName";
employeecomboBox.ValueMember = "EmployeeId";
}
private void findemployeebutton_Click(object sender, EventArgs e)
{
if (employeeNametextBox.Text == "" || string.IsNullOrEmpty(employeeNametextBox.Text))
{
LoadDataGridView();
}
else
{
EmployeeDAO aEmployeeDao = new EmployeeDAO();
List <Employee> aEmployees = new List <Employee>();
aEmployees = aEmployeeDao.GetAllEmployee();
List <Employee> aaEmployees = (from myRow in aEmployees.AsEnumerable()
where myRow.EmployeeName.ToUpper().StartsWith(employeeNametextBox.Text.ToUpper())
select myRow).ToList();
// DataView view = results.AsDataView();
employeedataGridView.DataSource = aaEmployees;
}
}
