com.levinas.ecole.dao.ResponsableDaoImpl.java Source code

Introduction

Here is the source code for com.levinas.ecole.dao.ResponsableDaoImpl.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package com.levinas.ecole.dao;

import com.levinas.ecole.model.Responsable;
import java.util.HashMap;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Configuration;
import org.springframework.stereotype.Repository;

/**
 *
 * @author Administrateur
 */
@Repository
@Configuration
public class ResponsableDaoImpl implements ResponsableDao {

    @Autowired
    SessionFactory sessionFactory;

    @Override
    public List findAll() {
        Session session = sessionFactory.getCurrentSession();
        Query query = session.getNamedQuery("Responsable.findAll");
        return query.list();
    }

    public HashMap listAll(int page, int rpp, String search, boolean all) {
        Integer iRpp = rpp;
        HashMap result = new HashMap();

        Session session = sessionFactory.getCurrentSession();
        Query query = session.createQuery(
                "SELECT r FROM Responsable r WHERE r.nom like :search OR r.prenom like :search OR r.adresse like :search OR r.ville like :search OR r.codePostale like :search");
        query.setParameter("search", search);
        double nbResult = query.list().size();

        if (!all) {
            query.setFirstResult((page - 1) * rpp);
            query.setMaxResults(rpp);
        }
        List listItems = query.list();

        result.put("items", listItems);
        result.put("page_count", Math.ceil(nbResult / iRpp.doubleValue()));
        result.put("total_items", nbResult);

        return result;
    }

    @Override
    public Responsable findByIdresponsable(int idResponsable) {
        Session session = sessionFactory.getCurrentSession();
        Query query = session.getNamedQuery("Responsable.findByIdresponsable");
        query.setParameter("idresponsable", idResponsable);
        return (Responsable) query.uniqueResult();
    }

    @Override
    public List findByNom(String nom) {
        Session session = sessionFactory.getCurrentSession();
        Query query = session.getNamedQuery("Responsable.findByNom");
        query.setParameter("nom", nom);
        return query.list();
    }

    @Override
    public List findByPrenom(String prenom) {
        Session session = sessionFactory.getCurrentSession();
        Query query = session.getNamedQuery("Responsable.findByPrenom");
        query.setParameter("prenom", prenom);
        return query.list();
    }

    @Override
    public List findByVille(String ville) {
        Session session = sessionFactory.getCurrentSession();
        Query query = session.getNamedQuery("Responsable.findByVille");
        query.setParameter("ville", ville);
        return query.list();
    }

    @Override
    public List findByCodePostale(String codePostal) {
        Session session = sessionFactory.getCurrentSession();
        Query query = session.getNamedQuery("Responsable.findByCodePostale");
        query.setParameter("codePostale", codePostal);
        return query.list();
    }

    @Override
    public void saveOrUpdate(Responsable responsable) {
        Session session = sessionFactory.getCurrentSession();
        session.saveOrUpdate(responsable);
    }

    @Override
    public void delete(Responsable responsable) {
        Session session = sessionFactory.getCurrentSession();
        session.delete(responsable);
    }

}