private void btnSearch_Click(object sender, EventArgs e)
{
var filter = new EmployeeBasicFilter
{
IsMale = rdbMale.Checked,
IsSingle = cmbStatus.SelectedIndex == 1
};
dgvEmployees.DataSource = Repository.GetAllEmployeesByFilter(filter);
}
public IEnumerable <Employee> GetAllEmployeesByFilter(EmployeeBasicFilter filter)
{
var list = new List <Employee>();
var query = @"SELECT e.BusinessEntityId, e.BirthDate, e.MaritalStatus AS [Status], e.Gender, p.FirstName, p.LastName FROM HumanResources.Employee e
INNER JOIN Person.Person p ON e.BusinessEntityID = p.BusinessEntityID
WHERE p.PersonType = 'EM' AND e.MaritalStatus = @ms AND e.Gender = @gn";
var cmd = new SqlCommand(query, Connection);
cmd.Parameters.AddWithValue("@ms", filter.MarrialStatusText);
cmd.Parameters.AddWithValue("@gn", filter.GenderText);
var reader = cmd.ExecuteReader();
MapEmployee(list, reader);
return(list);
}
