cardfeesmanagerbean.java

THIS IS A FINANCIAL BANK APPLICATION

package Pcrd.Subscription.Beans;

import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.PersistenceContext;

import Pcrd.Subscription.Entities.CardFees;
import Pcrd.Subscription.Entities.CardFeesPK;
import Pcrd.Subscription.Sessions.CardFeesManager;
@Stateless
public class CardFeesManagerBean implements CardFeesManager{
	@PersistenceContext
	EntityManager em;
	EntityManagerFactory emf;
	public CardFees genererTarif(String codeBank,String codeProduit) {
		// TODO Auto-generated method stub
		return (CardFees) em.createQuery("SELECT cf FROM CardFees cf,CardProduct cp WHERE ( cf.pk.bankCode='"+codeBank+"' AND cp.pk.productCode='"+codeProduit+"' AND cp.cardFeesIndPrim=cf.pk.cardFeesCode )").getSingleResult();
	}
	public CardFees generationTarif(String codeBank,String codeProduit){
		 CardFeesPK pk=new CardFeesPK();
         pk.setBankCode(codeBank);
         pk.setCardFeesCode(codeProduit);
         CardFees cf=new CardFees();
       cf= em.find(CardFees.class,pk);
       return(cf);
         
	}
}