/*
* Copyright (C) 2014 Thibaut Comte
*
* This is for your eyes only!
* Destroy after reading!
*/
package abonnements.gestionnaires;
import abonnements.modele.Abonnement;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Iterator;
import java.util.List;
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
/**
*
* @author Thibaut
*/
@Stateless
public class GestionnaireAbonnements {
@PersistenceContext
private EntityManager em;
public List<Abonnement> creerAbonnementDefault(){
List<Abonnement> list = new ArrayList<>();
list.add(new Abonnement("week-end",2,2.00));
list.add(new Abonnement("hebdomadaire",7,6.00));
list.add(new Abonnement("mensuel",30,25.00));
list.add(new Abonnement("annuel",365,250.00));
list.add(new Abonnement("à vie",55000,1000.00));
for(Abonnement g : list){
em.persist(g);
}
return list;
}
public Collection<Abonnement> getAllAbonnements() {
Query q = em.createQuery("select a from Abonnement a order by a.prix asc");
return q.getResultList();
}
public Abonnement getAbonnementByName(String name) {
Query q = em.createQuery("select a from Abonnement a where a.name ='"+name+"'");
List results = q.getResultList();
if (!results.isEmpty()) {
Iterator stIterator = results.iterator();
Abonnement a = (Abonnement) stIterator.next();
return a;
} else {
return null;
}
}
public Abonnement getAbonnementById(String abonnement) {
Query q = em.createQuery("select a from Abonnement a where a.id='" + abonnement + "'");
List results = q.getResultList();
if (!results.isEmpty()) {
Iterator stIterator = results.iterator();
Abonnement a = (Abonnement) stIterator.next();
return a;
} else {
return null;
}
}
}