public List <EmployeeCompany> GetByRange(int skip, string word, EStatusUser status)
{
int take = 12;
return(_context.EmployeeCompany
.Include("Company")
.Include("User")
.Include("User.ProfileUser")
.Include("SectorCompany")
.Where(EmployeeCompanySpecs.GetEmployeeCompany(word, status))
.OrderBy(x => x.IdCompany).Skip((skip - 1) * take).Take(take).ToList());
}
public static Expression <Func <EmployeeCompany, bool> > GetEmployeeCompany(string word, EStatusUser status)
{
if (string.IsNullOrEmpty(word) || word.Equals("null"))
{
return(x => x.User.StatusUser == status);
}
return(x => x.User.StatusUser == status && (x.User.Name.Contains(word) || x.User.LastName.Contains(word) || x.User.Email.Contains(word) || x.Cpf.Contains(word)));
}
public Task <HttpResponseMessage> GetCount(string word, EStatusUser status)
{
var countEmployee = _service.GetCount(word, status);
return(CreateResponse(HttpStatusCode.OK, countEmployee));
}
public Task <HttpResponseMessage> GetByRange(int skip, EStatusUser status, string word)
{
var employee = _service.GetByRange(skip, word, status);
return(CreateResponse(HttpStatusCode.OK, employee));
}
public List <EmployeeCompany> GetByRange(int skip, string word, EStatusUser status)
{
return(_repository.GetByRange(skip, word, status));
}
public int GetCount(string word, EStatusUser status)
{
return(_repository.GetCount(word, status));
}
public int GetCount(string word, EStatusUser status)
{
return(_context.EmployeeCompany.Where(EmployeeCompanySpecs.GetEmployeeCompany(word, status)).Count());
}
