subscriptionpendingmanagerbean.java

THIS IS A FINANCIAL BANK APPLICATION

package Pcrd.Subscription.Beans;

import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import java.util.Locale;

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

import Pcrd.Subscription.Entities.SubscriptionPending;
import Pcrd.Subscription.Entities.SubscriptionPendingPK;
import Pcrd.Subscription.Sessions.SubscriptionPendingManager;


@Stateless
public class SubscriptionPendingManagerBean implements SubscriptionPendingManager {
	 @PersistenceContext
	   EntityManager em;
	 
 public void InsertSubscriptionPending(SubscriptionPending P_Subscription){
	em.persist(P_Subscription);	
	}
 public List<SubscriptionPending> listerContrats() {
		// TODO Auto-generated method stub
		return em.createQuery("SELECT subp FROM SubscriptionPending subp")
				.getResultList();

	}

	public void UpdateSubscriptionPending(SubscriptionPendingPK pk,String account){
	
		//em.getTransaction().begin();
    	
    	
		SubscriptionPending sp=em.find(SubscriptionPending.class,pk);
		sp.setAccountNumber(account);
		System.out.println("subscription"+sp.getAccountNumber());
    	
    	//em.getTransaction().commit();


	}
	public List<SubscriptionPending> ConractSearch(String ContractNumber,String numCIN,String tel,String codeBank,String codeBranch, Date dateD, Date dateF) {
		// TODO Auto-generated method stub
		Locale locale = Locale.getDefault();
		String dateDSQL="";
		String dateFSQL="";
		 //Date actuelle = new Date();
		 DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
		//java.sql.Date dateDSQL = new java.sql.Date(dateD.getTime()); 
		//java.sql.Date dateFSQL = new java.sql.Date(dateF.getTime()); 
		if(dateD!=null)
		 dateDSQL = dateFormat.format(dateD);
		if (dateF!=null)
		 dateFSQL = dateFormat.format(dateF);
		
		String query="SELECT subp FROM SubscriptionPending subp WHERE subp.pk.contractNumber=subp.pk.contractNumber";
		int i=ContractNumber.indexOf("%");
		if (ContractNumber.equals("")==false && i==-1){
			query+=" AND subp.pk.contractNumber='"+ContractNumber+"'";
			return em.createQuery(query).getResultList();
		}
		
		if (ContractNumber.equals("")==false && i!=-1)
			{query+=" AND subp.pk.contractNumber LIKE '"+ContractNumber+"'";
			return em.createQuery(query).getResultList();
			}
	
	
		if (tel.equals("")==false)
			query+=" AND subp.phone='"+tel+"'";
	    if (numCIN.equals("")==false)
		    query+=" AND subp.documentCode='"+numCIN+"'";
		
		if (codeBank.equals("all")==false)
			query+=" AND subp.pk.bankCode='"+codeBank+"'";
		if (codeBranch.equals("all")==false)
			query+=" AND subp.branchCode='"+codeBranch+"'";
		if (dateD!=null)
			query+=" AND subp.souscriptionDate >= To_date('"+dateDSQL+"','DD/MM/YYYY')";
		if (dateF!=null)
			query+=" AND subp.souscriptionDate <= To_date('"+dateFSQL+"','DD/MM/YYYY')";	
		
		return em.createQuery(query).getResultList();
	}
	public String SelectCodeAgence(String BankCode,String ContractNumber){
		SubscriptionPendingPK pk=new SubscriptionPendingPK();
		pk.setBankCode(BankCode);
		pk.setContractNumber(ContractNumber);
		SubscriptionPending sp=em.find(SubscriptionPending.class,pk);
		return(sp.getBranchCode());
	}
	public String DeleteSubscriptionPending(String BankCode,String ContractNumber){
		SubscriptionPendingPK pk=new SubscriptionPendingPK();
		pk.setBankCode(BankCode);
		pk.setContractNumber(ContractNumber);
		
		SubscriptionPending sp=em.find(SubscriptionPending.class,pk);
		em.remove(sp);
		return(sp.getBranchCode());
	}
	
}