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