public IEnumerable <Employee> GetEmployees(EmployeeQueryFilter filters)
{
return(_context.Employee.FromSqlRaw <Employee>("getEmployees {0},{1},{2}",
filters.NumberDocument,
filters.FirstName,
filters.LastName).ToList());
}
public async Task <IActionResult> Get([FromQuery] EmployeeQueryFilter filters)
{
var employees = await _employeeService.FindAllAsync(filters);
var response = new Response(employees);
return(Ok(response));
}
public async Task <IEnumerable <Employee> > FindAllAsync(EmployeeQueryFilter filters)
{
return(await _employeeRepository.Queryable()
.WhereFor(!filters.IncludeInactivated, employee => !employee.Inactivated)
.WhereFor(filters.Name, employee => EF.Functions.Like(employee.Name, $"%{filters.Name}%"))
.WhereFor(filters.Email, employee => EF.Functions.Like(employee.Email, $"%{filters.Email}%"))
.WhereFor(filters.CompanyId, employee => employee.Department.CompanyId == filters.CompanyId)
.WhereFor(filters.DepartmentId, employee => employee.DepartmentId == filters.DepartmentId)
.ToListAsync());
}
public async Task <IEnumerable <EmployeeResponseModel> > FindAllAsync(EmployeeQueryFilter filters)
{
var employees = await _employeeService.FindAllAsync(filters);
return(_mapper.Map <IEnumerable <EmployeeResponseModel> >(employees));
}
public IActionResult GetEmployees([FromQuery] EmployeeQueryFilter filters)
{
var employees = _employeeService.GetEmployees(filters);
return(Ok(employees));
}
public IEnumerable <Employee> GetEmployees(EmployeeQueryFilter filters)
{
return(_employeeRepository.GetEmployees(filters));
}