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