Example usage for org.hibernate.criterion Restrictions ne

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions ne.

Prototype

public static SimpleExpression ne(String propertyName, Object value)

Source Link

Document

Apply a "not equal" constraint to the named property

Usage

From source file:helper.LogHelper.java

public List<Tablo> listTablo() throws Exception {

    Session session = null;//from   w  ww  . j  a va 2s. co m
    List<Tablo> list = new ArrayList<>();

    try {
        session = sessionFactory.openSession();
        list = session.createCriteria(Tablo.class, "tablo").add(Restrictions.ne("tablo.isAktif", false)).list();

    } catch (Exception e) {

        throw e;
    } finally {
        session.close();
    }
    return list;
}

From source file:helper.LogHelper.java

public List<Log> listLog() throws Exception {

    Session session = null;/*from   ww w  .jav a2s .co  m*/
    List<Log> list = new ArrayList<>();

    try {
        session = sessionFactory.openSession();
        list = session.createCriteria(Log.class, "log").createAlias("log.tablo", "tablo")
                .createAlias("log.logDurum", "logDurum").createAlias("log.cihaz", "cihaz")
                .createAlias("log.personel", "personel").add(Restrictions.ne("tablo.isAktif", false))
                .add(Restrictions.ne("logDurum.isAktif", false)).add(Restrictions.ne("cihaz.isAktif", false))
                .add(Restrictions.ne("log.isAktif", false)).addOrder(Order.desc("log.tarih")).list();

    } catch (Exception e) {

        throw e;
    } finally {
        session.close();
    }
    return list;
}

From source file:helper.LogHelper.java

public List<Log> listLog(LogDurum logDurum) throws Exception {

    Session session = null;/*from  w w w  . j ava  2 s .c  o  m*/
    List<Log> list = new ArrayList<>();

    try {
        session = sessionFactory.openSession();
        list = session.createCriteria(Log.class, "log").createAlias("log.tablo", "tablo")
                .createAlias("log.logDurum", "logDurum").createAlias("log.cihaz", "cihaz")
                .createAlias("log.personel", "personel")
                .add(Restrictions.eq("logDurum.logDurumId", logDurum.getLogDurumId()))
                .add(Restrictions.ne("tablo.isAktif", false)).add(Restrictions.ne("logDurum.isAktif", false))
                .add(Restrictions.ne("cihaz.isAktif", false)).add(Restrictions.ne("log.isAktif", false))
                .addOrder(Order.desc("log.tarih"))

                .list();
        System.out.println("list : " + list.size() + " logDurum " + logDurum.getLogDurumId());
    } catch (Exception e) {

        throw e;
    } finally {
        session.close();
    }
    return list;
}

From source file:helper.MasaNoHelper.java

public List<MasaNo> list() throws Exception {

    Session session = null;// ww  w  . j av  a  2 s. c  o  m
    List<MasaNo> listMasaNo = new ArrayList<>();

    try {
        session = sessionFactory.openSession();
        listMasaNo = session.createCriteria(MasaNo.class, "masaNo")
                .add(Restrictions.ne("masaNo.isAktif", false)).list();

    } catch (Exception e) {
        throw e;
    } finally {
        session.close();
    }
    return listMasaNo;
}

From source file:helper.MutfakHelper.java

public List<Siparis> list() throws Exception {

    Session session = null;/*from   ww w .  ja  v a2  s. co  m*/
    List<Siparis> list = new ArrayList<>();

    try {
        session = sessionFactory.openSession();
        list = session.createCriteria(Siparis.class, "siparis").createAlias("siparis.stok", "stok")
                .createAlias("stok.urun", "urun").createAlias("urun.urunTur", "urunTur")
                .createAlias("siparis.masa", "masa").createAlias("masa.masaNo", "masaNo")
                .add(Restrictions.eq("siparis.isIptal", false)).add(Restrictions.ne("siparis.isAktif", false))
                .add(Restrictions.ne("stok.isAktif", false)).add(Restrictions.eq("siparis.isHazir", false))
                .addOrder(Order.desc("siparis.satisTarihi")).list();
    } catch (Exception e) {
        throw e;
    } finally {
        session.close();
    }
    return list;
}

From source file:helper.PersonelHelper.java

public List<Personel> listPersonel() throws Exception {

    Session session = null;//from  w w w  .j  a v  a2s. c  o  m
    List<Personel> list = new ArrayList<>();
    try {
        session = sessionFactory.openSession();
        list = session.createCriteria(Personel.class, "personel").createAlias("personel.yetki", "yetki")
                .add(Restrictions.ne("personel.isAktif", false)).list();

    } catch (Exception e) {
        throw e;
    } finally {
        session.close();
    }

    return list;
}

From source file:helper.PersonelHelper.java

public Personel login(Personel personel) throws Exception {

    Session session = null;//  w w w .  jav a 2  s .c o  m
    Personel loginPersonel = new Personel();

    try {
        session = sessionFactory.openSession();
        loginPersonel = (Personel) session.createCriteria(Personel.class, "personel")
                .createAlias("personel.yetki", "yetki")
                .add(Restrictions.eq("personel.kullaniciAd", personel.getKullaniciAd()))
                .add(Restrictions.eq("personel.sifre", personel.getSifre()))
                .add(Restrictions.ne("personel.isAktif", false)).uniqueResult();

        if (loginPersonel == null) {

            return null;
        }
    } catch (Exception e) {
        throw e;
    } finally {

        session.close();
    }
    return loginPersonel;
}

From source file:helper.SiparisHelper.java

public List<Siparis> listele(int masaNoId) throws Exception {

    Session session = null;//from w  w  w .j  ava 2  s  .  c om
    List<Siparis> list = new ArrayList<>();
    try {
        session = sessionFactory.openSession();
        list = session.createCriteria(Siparis.class, "siparis").createAlias("siparis.masa", "masa")
                .createAlias("siparis.stok", "stok").createAlias("stok.urun", "urun")
                .createAlias("masa.masaNo", "masaNo").add(Restrictions.eq("masaNo.masaNoId", masaNoId))
                .add(Restrictions.eq("masa.isOdendi", false)).add(Restrictions.ne("masa.isAktif", false))
                .add(Restrictions.eq("siparis.isIptal", false)).add(Restrictions.ne("siparis.isOdendi", true))
                .add(Restrictions.ne("siparis.isAktif", false)).list();

    } catch (Exception e) {
        throw e;
    } finally {
        session.close();
    }
    return list;
}

From source file:helper.SiparisHelper.java

public Masa checkMasa(int masaNoId) throws Exception {

    List<Siparis> list = new ArrayList<>();
    Session session = null;//from  w ww  .j  ava 2s.  c o m

    try {
        session = sessionFactory.openSession();
        list = session.createCriteria(Siparis.class, "siparis").createAlias("siparis.masa", "masa")
                .createAlias("masa.masaNo", "masaNo").add(Restrictions.eq("masaNo.masaNoId", masaNoId))
                .add(Restrictions.eq("siparis.isOdendi", false)).add(Restrictions.eq("siparis.isIptal", false))
                .add(Restrictions.ne("siparis.isAktif", false)).add(Restrictions.ne("masa.isAktif", false))
                .list();

    } catch (Exception e) {
        throw e;
    } finally {
        session.close();
    }

    if (list.size() != 0) {
        return list.get(0).getMasa();
    }
    return null;
}

From source file:helper.SiparisHelper.java

public List<Siparis> listReport(Date pStartDate, Date pEndDate) throws Exception { //Satilan rnlerin raporlar getiriliyor.

    Session session = null;//  ww  w .  j av a2  s  .co m
    List<Siparis> list = new ArrayList<>();

    try {
        session = sessionFactory.openSession();
        list = session.createCriteria(Siparis.class, "siparis").createAlias("siparis.masa", "masa")
                .createAlias("siparis.stok", "stok").createAlias("stok.urun", "urun")
                .add(Restrictions.ne("stok.isAktif", false)).add(Restrictions.ne("siparis.isAktif", false))
                .add(Restrictions.ne("masa.isAktif", false)).add(Restrictions.eq("masa.isOdendi", true))
                .add(Restrictions.eq("siparis.isOdendi", true))
                .add(Restrictions.between("siparis.satisTarihi", pStartDate, pEndDate))
                .addOrder(Order.desc("siparis.satisTarihi")).list();

    } catch (Exception e) {
        throw e;
    } finally {
        session.close();
    }

    return list;
}