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