Rev 226 | Rev 228 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 226 | Rev 227 | ||
|---|---|---|---|
| Line 1... | Line 1... | ||
| 1 | package br.com.ec.repository.jpa; |
1 | package br.com.ec.repository.jpa; |
| - | 2 | ||
| - | 3 | import java.util.List; |
|
| 2 | 4 | ||
| 3 | import javax.persistence.NoResultException; |
5 | import javax.persistence.NoResultException; |
| 4 | import javax.persistence.TypedQuery; |
6 | import javax.persistence.TypedQuery; |
| 5 | 7 | ||
| 6 | import org.springframework.stereotype.Repository; |
8 | import org.springframework.stereotype.Repository; |
| 7 | 9 | ||
| 8 | import br.com.ec.core.exception.NegocioException; |
10 | import br.com.ec.core.exception.NegocioException; |
| 9 | import br.com.ec.domain.dto.UsuarioDTO; |
11 | import br.com.ec.domain.dto.UsuarioDTO; |
| - | 12 | import br.com.ec.domain.dto.UsuarioLojaDTO; |
|
| - | 13 | import br.com.ec.domain.dto.UsuarioPerfilDTO; |
|
| 10 | import br.com.ec.domain.modal.Usuario; |
14 | import br.com.ec.domain.modal.Usuario; |
| 11 | import br.com.ec.repository.SistemaAbstractRepository; |
15 | import br.com.ec.repository.SistemaAbstractRepository; |
| 12 | import br.com.ec.repository.UsuarioRepository; |
16 | import br.com.ec.repository.UsuarioRepository; |
| 13 | 17 | ||
| 14 | @Repository |
18 | @Repository |
| Line 27... | Line 31... | ||
| 27 | .setParameter("senha", senha) |
31 | .setParameter("senha", senha) |
| 28 | .getSingleResult(); |
32 | .getSingleResult(); |
| 29 | } catch (NoResultException nre) { |
33 | } catch (NoResultException nre) { |
| 30 | throw new NegocioException("Usuário não existe"); |
34 | throw new NegocioException("Usuário não existe"); |
| 31 | }
|
35 | }
|
| - | 36 | }
|
|
| - | 37 | ||
| - | 38 | @Override |
|
| - | 39 | public List<UsuarioPerfilDTO> consultarPerfisDoUsuario(Long sequencialUsuario) { |
|
| - | 40 | StringBuilder jpql = new StringBuilder(); |
|
| - | 41 | jpql.append("SELECT new br.com.ec.domain.dto.UsuarioPerfilDTO(uf.usuario.sequencial, uf.perfil.codigo) FROM UsuarioPerfil uf "); |
|
| - | 42 | jpql.append("WHERE uf.usuario.sequencial = :sequencialUsuario"); |
|
| - | 43 | try { |
|
| - | 44 | return getEntityManager().createQuery(jpql.toString(), UsuarioPerfilDTO.class) |
|
| - | 45 | .setParameter("sequencialUsuario", sequencialUsuario) |
|
| - | 46 | .getResultList(); |
|
| - | 47 | } catch (Exception ex) { |
|
| - | 48 | ex.printStackTrace(); |
|
| - | 49 | }
|
|
| - | 50 | return null; |
|
| - | 51 | }
|
|
| - | 52 | ||
| - | 53 | @Override |
|
| - | 54 | public List<UsuarioLojaDTO> consultarLojasDoUsuario(Long sequencialUsuario) { |
|
| - | 55 | StringBuilder jpql = new StringBuilder(); |
|
| - | 56 | jpql.append("SELECT new br.com.ec.domain.dto.UsuarioLojaDTO(ul.loja.sequencial, ul.loja.descricao) FROM UsuarioLoja ul "); |
|
| - | 57 | jpql.append("WHERE ul.usuario.sequencial = :sequencialUsuario"); |
|
| - | 58 | try { |
|
| - | 59 | return getEntityManager().createQuery(jpql.toString(), UsuarioLojaDTO.class) |
|
| - | 60 | .setParameter("sequencialUsuario", sequencialUsuario) |
|
| - | 61 | .getResultList(); |
|
| - | 62 | } catch (Exception ex) { |
|
| - | 63 | ex.printStackTrace(); |
|
| - | 64 | }
|
|
| - | 65 | return null; |
|
| 32 | }
|
66 | }
|
| 33 | 67 | ||
| 34 | @Override |
68 | @Override |
| 35 | public Integer obterQuantidadeUsuarioDiferenteComSenhaInformada(String login, String senha) { |
69 | public Integer obterQuantidadeUsuarioDiferenteComSenhaInformada(String login, String senha) { |
| 36 | StringBuilder jpql = new StringBuilder(); |
70 | StringBuilder jpql = new StringBuilder(); |