classe.restaurantUtil.java Source code

Introduction

Here is the source code for classe.restaurantUtil.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 classe;

import java.io.BufferedInputStream;
import java.util.List;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import javax.faces.context.ExternalContext;
import javax.faces.context.FacesContext;
import javax.servlet.http.Part;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

/**
 *
 * @author Alexandre
 */
public class restaurantUtil {
    Session session = null;

    public void ajouterResto(String description, String nom, String siteweb, int prix, Part img) {
        Restaurant unResto = new Restaurant();
        unResto.setDescription(description);
        unResto.setNom(nom);
        unResto.setSiteweb(siteweb);
        unResto.setPrixmoyen(prix);

        String path = getFilename(img);
        try {
            this.upload(img);

        } catch (Exception e) {
            e.printStackTrace();
        }
        unResto.setImage(path);
        Typecuisine typeCus = new Typecuisine();
        typeCus.setTypecui("pici");
        unResto.setTypecuisine(typeCus);

        Transaction tx = null;
        this.session = HibernateUtil.getSessionFactory().openSession();

        try {
            tx = session.beginTransaction();
            session.saveOrUpdate(typeCus);
            // l'ajout ne se fait typeCus car il reste des champs null qui ne doivent pas l'tre

            session.saveOrUpdate(unResto);
            tx.commit();
        } catch (Exception e) {
            tx.rollback();
            e.printStackTrace();
        }

        this.session.close();

    }

    public List<Restaurant> listeRestaurant() {
        List<Restaurant> listeResto = null;

        Transaction tx = null;
        this.session = HibernateUtil.getSessionFactory().openSession();

        try {

            tx = session.beginTransaction();

            // Liste de tous les livres
            Query Resto = session.createQuery("from Restaurant");

            listeResto = Resto.list();

        } catch (Exception e) {
            e.printStackTrace();
        }

        this.session.close();
        return listeResto;

    }

    public String supResto(int id) {
        String message;
        Transaction tx = null;
        List<Restaurant> listeResto = null;
        this.session = HibernateUtil.getSessionFactory().openSession();

        try {

            tx = session.beginTransaction();

            // Liste de tous les livres
            Query Resto = session.createQuery("from Restaurant where id =" + id);

            listeResto = Resto.list();

        } catch (Exception e) {
            e.printStackTrace();
        }
        if (listeResto.size() != 0) {
            session.delete(listeResto.get(0));
            this.session.close();
            return "le restaurant a bien t supprimer";

        } else {
            this.session.close();
            return "Restaurant introuvable";
        }

    }

public List<Restaurant> RestosRcents() {
    List<Restaurant> listeResto = null;
        
    Transaction tx = null;
    this.session = HibernateUtil.getSessionFactory().openSession();
       
    try {
            
        tx = session.beginTransaction();
            
        Query requete = session.createQuery("FROM Restaurant ORDER BY Idresto DESC");
        requete.setFirstResult(0);
        requete.setMaxResults(3);
           
        listeResto = requete.list();
           
    } catch (Exception e) {
        e.printStackTrace();
    }
       
    this.session.close();
    return listeResto;
}

    public List<Restaurant> RechercherRestos(String infos) {
        List<Restaurant> listeResto = null;

        Transaction tx = null;
        this.session = HibernateUtil.getSessionFactory().openSession();

        try {
            tx = session.beginTransaction();

            Query requete = session.createQuery(
                    "FROM Restaurant where lower(nom) like '%infos%' OR lower(typecuisine) like '%infos%'");
            // Requte qui cherche un resto selon son nom ou son type de cuisine

            listeResto = requete.list();

        } catch (Exception e) {
            e.printStackTrace();
        }

        this.session.close();
        return listeResto;
    }
    // source : http://www.ramkitech.com/2013/06/file-upload-is-easy-in-jsf22.html

    public String upload(Part img) throws IOException {
        try (InputStream inputStream = img.getInputStream()) {
            String path = getFilename(img);

            String pathAbsolute = FacesContext.getCurrentInstance().getExternalContext()
                    .getRealPath("/resources/images");
            String pathAModif = pathAbsolute + "\\" + path;
            String pathFinal = pathAModif.replace('\\', '/');
            File file = new File(pathFinal);

            FileOutputStream outputStream = new FileOutputStream(file);

            byte[] buffer = new byte[4096];
            int bytesRead = 0;
            while (true) {
                bytesRead = inputStream.read(buffer);
                if (bytesRead > 0) {
                    outputStream.write(buffer, 0, bytesRead);
                } else {
                    break;
                }
            }
            outputStream.close();
        }

        return "success";
    }

    // source : http://www.ramkitech.com/2013/06/file-upload-is-easy-in-jsf22.html

    private static String getFilename(Part part) {
        for (String cd : part.getHeader("content-disposition").split(";")) {
            if (cd.trim().startsWith("filename")) {
                String filename = cd.substring(cd.indexOf('=') + 1).trim().replace("\"", "");
                return filename.substring(filename.lastIndexOf('/') + 1).substring(filename.lastIndexOf('\\') + 1); // MSIE fix.
            }
        }
        return null;
    }

    public Restaurant getRestoId(int id) {
        Restaurant unResto = null;
        List<Restaurant> listeRestaurants = null;

        Transaction tx = null;
        this.session = HibernateUtil.getSessionFactory().openSession();

        try {

            tx = session.beginTransaction();

            // Liste de tous les livres
            Query resto = session.createQuery("from Restaurant where idresto=:id");
            resto.setInteger("id", id);
            listeRestaurants = resto.list();

        } catch (Exception e) {
            e.printStackTrace();
        }

        this.session.close();
        if (listeRestaurants.size() != 0) {
            return listeRestaurants.get(0);
        } else {
            return null;
        }

    }

}