/// <summary>
/// Método para buscar todas as Company inativas
/// </summary>
/// <returns>Retorna uma lista de Company com status = inativo</returns>
public List <Company> GetInactive()
{
return(_context.Companies
.Where(CompanySpecs.GetInactives())
.OrderBy(CompanySpecs.OrderByDefault())
.ToList());
}
public List <Company> GetByRange(int skip, int take, string word, EStatusCompany status)
{
return(_context.Company
.Include("ListAddressCompany")
.Include("ListPhonesCompany")
.Where(CompanySpecs.GetCompany(word, status))
.OrderBy(x => x.IdCompany).Skip((skip - 1) * take).Take(take).ToList());
}
/// <summary>
/// Método para buscar companies, informando quantas deseja buscar e quantas deseja pular
/// </summary>
/// <param name="skip">Quantidade de Companies a ser desconsiderada</param>
/// <param name="take">Quantidade de Companies que deseja obter</param>
/// <returns>Retorna uma Lista de Company</returns>
public List <Company> Get(int skip, int take)
{
return(_context.Companies
.Skip(skip)
.Take(take)
.OrderBy(CompanySpecs.OrderByDefault())
.ToList());
}
public int GetCount(string word, EStatusCompany status)
{
return(_context.Company.Where(CompanySpecs.GetCompany(word, status)).Count());
}
/// <summary>
/// Método para buscar Companies por ID
/// </summary>
/// <param name="companyId">ID da Company a ser buscada</param>
/// <returns>Retorna a Company com o ID informado</returns>
public Company GetById(Guid companyId)
{
return(_context.Companies
.FirstOrDefault(CompanySpecs.GetById(companyId)));
}
/// <summary>
/// Método para buscar todas as Companies
/// </summary>
/// <returns>Retorna todas as Companies criadas</returns>
public List <Company> Get()
{
return(_context.Companies
.OrderBy(CompanySpecs.OrderByDefault())
.ToList());
}
/// <summary>
/// Método para buscar uma Company pelo nome
/// </summary>
/// <param name="name">Nome da Company a ser buscada</param>
/// <returns>Retorna uma Company caso exista com o nome informado</returns>
public Company GetByName(string name)
{
return(_context.Companies
.FirstOrDefault(CompanySpecs.GetByName(name)));
}
