Package org.hibernate.criterion

Examples of org.hibernate.criterion.Conjunction


 
  @SuppressWarnings("unchecked")
  private List<Legame> getLegamiPerMutuiRID (long numeroMutuo){
    DetachedCriteria criteria = DetachedCriteria.forClass(Legame.class);
   
    Conjunction conj = Restrictions.conjunction();   
    conj.add(Restrictions.eq("mutuo.numeroMutuo", numeroMutuo));   
   
    criteria.add(conj);
       
    return (List<Legame>) getHibernateTemplate().findByCriteria(criteria);
  }
View Full Code Here


 
  @SuppressWarnings("unchecked")
  @Override
  public SpesePerizia getSpesePerizia(long codiceBroker, Double importoRiferimento) {
    DetachedCriteria criteria = DetachedCriteria.forClass(SpesePerizia.class);
    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("codiceBroker", codiceBroker));
    conj.add(Restrictions.eq("legalEntity", legalEntity));
    conj.add(Restrictions.eq("organizationUnit", organizationUnit));
    conj.add(Restrictions.le("importoMinimo", importoRiferimento));
    conj.add(Restrictions.ge("importoMassimo", importoRiferimento));
    criteria.add(conj);
   
    List<SpesePerizia> result = (List<SpesePerizia>)getHibernateTemplate().findByCriteria(criteria);
   
    return null != result && result.size() > 0 ? result.get(0) : null;
View Full Code Here

 
  @SuppressWarnings("unchecked")
  @Override
  public AnticipoMutuo getAnticipoMutuoById(long numeroAnticipo) {
    DetachedCriteria criteria = DetachedCriteria.forClass(AnticipoMutuo.class);
    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("numeroAnticipo", numeroAnticipo));
    conj.add(Restrictions.eq("legalEntity", legalEntity));
    conj.add(Restrictions.eq("organizationUnit", organizationUnit));
    criteria.add(conj);
   
    List<AnticipoMutuo> result = (List<AnticipoMutuo>)getHibernateTemplate().findByCriteria(criteria);
   
    return null != result && result.size() > 0 ? result.get(0) : null;
View Full Code Here

    criteria.add(Restrictions.eq("organizationUnit", organizationUnit).ignoreCase());
   
    Disjunction or = Restrictions.disjunction();
    or.add(Restrictions.between("dataInizioValidita", dallaData, allaData));
   
    Conjunction and = Restrictions.conjunction();
    and.add(Restrictions.le("dataInizioValidita", dallaData));
    Disjunction orDt = Restrictions.disjunction();
    orDt.add(Restrictions.isNull("dataFineValidita"));
    orDt.add(Restrictions.gt("dataFineValidita", allaData));
    and.add(orDt);
    or.add(and);
    and = Restrictions.conjunction();
    and.add(Restrictions.le("dataInizioValidita", dallaData));
    and.add(Restrictions.ge("dataFineValidita", dallaData));
    or.add(and);
   
    criteria.add(or);
    List<VariazioneParametroFinanziario> result = getHibernateTemplate().findByCriteria(criteria);
    return result;
View Full Code Here

 
  @SuppressWarnings("unchecked")
  public MutuoTest getMutuoByNumeroUnivoco(long numeroMutuo){
    DetachedCriteria criteria = DetachedCriteria.forClass(MutuoTest.class);
   
    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("legalEntity", legalEntity));
    conj.add(Restrictions.eq("organizationUnit", organizationUnit));
    conj.add(Restrictions.eq("numeroMutuo", numeroMutuo));
    criteria.add(conj);
   
    List<MutuoTest> result = (List<MutuoTest>) getHibernateTemplate().findByCriteria(criteria);
    if (result != null && result.size() > 0){
      MutuoTest m = result.get(0);
View Full Code Here

  @SuppressWarnings("unchecked")
  @Override
  public Mutuo getMutuoById(long idNumeroMutuo) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Mutuo.class);

    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("legalEntity", legalEntity).ignoreCase());
    conj.add(Restrictions.eq("organizationUnit", organizationUnit).ignoreCase());
    conj.add(Restrictions.eq("numeroMutuo", idNumeroMutuo));
    criteria.add(conj);

    List<Mutuo> result = (List<Mutuo>) getHibernateTemplate().findByCriteria(criteria);
    if (result != null && result.size() > 0)
      return result.get(0);
View Full Code Here

  @SuppressWarnings("unchecked")
  @Override
  public AgenteTabellaFinanziaria getAgenteTabellaFinanziaria(long numeroAgente, Long numeroTabellaFinanziaria) {
    DetachedCriteria criteria = DetachedCriteria.forClass(AgenteTabellaFinanziaria.class);
    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("numeroAgente", numeroAgente));
    conj.add(Restrictions.eq("numeroTabellaFinanziaria", numeroTabellaFinanziaria));
    conj.add(Restrictions.eq("legalEntity", legalEntity).ignoreCase());
    conj.add(Restrictions.eq("organizationUnit", organizationUnit).ignoreCase());
    criteria.add(conj);

    List<AgenteTabellaFinanziaria> result = getHibernateTemplate().findByCriteria(criteria);

    if (result != null && result.size() > 0)
View Full Code Here

  @SuppressWarnings("unchecked")
  @Override
  public Assicurazione getAssicurazione(long numeroCompagnia, String codicePolizza, String tipoAssicurazione,
      int durata, String sesso, int anni) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Assicurazione.class);
    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("legalEntity", legalEntity).ignoreCase());
    conj.add(Restrictions.eq("organizationUnit", organizationUnit).ignoreCase());
    conj.add(Restrictions.eq("numeroCompagnia", numeroCompagnia));
    conj.add(Restrictions.eq("codicePolizza", codicePolizza));
    conj.add(Restrictions.eq("tipoAssicurazione", tipoAssicurazione));

    if (!"".equals(sesso)) {
      conj.add(Restrictions.eq("sessoIntestatario", sesso).ignoreCase());
    }
    if (anni > 0) {
      conj.add(Restrictions.eq("anniIntestatario", anni));
    }

    conj.add(Restrictions.le("durataMinimaContratto", durata));

    Disjunction orDett = Restrictions.disjunction();
    orDett = Restrictions.disjunction();
    orDett.add(Restrictions.isNull("durataMassimaContratto"));
    orDett.add(Restrictions.ge("durataMassimaContratto", durata));
    conj.add(orDett);

    criteria.add(conj);
    List<Assicurazione> result = getHibernateTemplate().findByCriteria(criteria);
    if (result != null && result.size() > 0)
      return result.get(0);
View Full Code Here

  @SuppressWarnings("unchecked")
  @Override
  public Assicurazione getAssicurazioneByListaSessi(long numeroCompagnia, String codicePolizza, String tipoAssicurazione,
      int durata, String[] sessi, int anni) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Assicurazione.class);
    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("legalEntity", legalEntity).ignoreCase());
    conj.add(Restrictions.eq("organizationUnit", organizationUnit).ignoreCase());
    conj.add(Restrictions.eq("numeroCompagnia", numeroCompagnia));
    conj.add(Restrictions.eq("codicePolizza", codicePolizza));
    conj.add(Restrictions.eq("tipoAssicurazione", tipoAssicurazione));
    conj.add(Restrictions.in("sessoIntestatario", sessi));
    conj.add(Restrictions.eq("anniIntestatario", anni));
    conj.add(Restrictions.le("durataMinimaContratto", durata));

    Disjunction orDett = Restrictions.disjunction();
    orDett = Restrictions.disjunction();
    orDett.add(Restrictions.isNull("durataMassimaContratto"));
    orDett.add(Restrictions.ge("durataMassimaContratto", durata));
    conj.add(orDett);

    criteria.add(conj);
    List<Assicurazione> result = getHibernateTemplate().findByCriteria(criteria);
    if (result != null && result.size() > 0)
      return result.get(0);
View Full Code Here

  @SuppressWarnings("unchecked")
  @Override
  public Assicurazione getAssicurazioneByNumero(long numeroAssicurazione) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Assicurazione.class);
    Conjunction conj = Restrictions.conjunction();
    conj.add(Restrictions.eq("legalEntity", legalEntity).ignoreCase());
    conj.add(Restrictions.eq("organizationUnit", organizationUnit).ignoreCase());
    conj.add(Restrictions.eq("numeroAssicurazione", numeroAssicurazione));

    criteria.add(conj);
    List<Assicurazione> result = getHibernateTemplate().findByCriteria(criteria);
    if (result != null && result.size() > 0)
      return result.get(0);
View Full Code Here

TOP

Related Classes of org.hibernate.criterion.Conjunction

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.