sequencebybranchmanagerbean.java

THIS IS A FINANCIAL BANK APPLICATION

package Pcrd.Subscription.Beans;

import java.math.BigDecimal;

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

import Pcrd.Subscription.Entities.SequenceByBranch;
import Pcrd.Subscription.Entities.SequenceByBranchPK;
import Pcrd.Subscription.Entities.SubscriptionPending;
import Pcrd.Subscription.Entities.SubscriptionPendingPK;
import Pcrd.Subscription.Sessions.SequenceByBranchManager;
import Pcrd.Subscription.Sessions.SubscriptionPendingManager;


@Stateless
public class SequenceByBranchManagerBean implements SequenceByBranchManager {
	 @PersistenceContext
	   EntityManager em;
	 
 
	public void UpdateSequenceByBranchManager(String BankCode,String BrancheCode){
    	
		 SequenceByBranchPK pk=new SequenceByBranchPK();
         pk.setBankCode(BankCode);
         pk.setBranchCode(BrancheCode);
         SequenceByBranch sb=em.find(SequenceByBranch.class,pk);
         BigDecimal CurrVal=sb.getSeqCurrentVal();
         BigDecimal SeqMaxVal=sb.getSeqMaxVal();
         BigDecimal SeqMinVal=sb.getSeqMinVal();
         BigDecimal IncrmBy=sb.getIncrementBy();
         BigDecimal NextVal=CurrVal.add(IncrmBy);
         BigDecimal Max=SeqMaxVal.add(new BigDecimal(1));
         if(NextVal.equals(Max)){
        	 sb.setSeqCurrentVal(SeqMinVal); 
         }
         else{
		sb.setSeqCurrentVal(NextVal);
         }
		System.out.println("SequenceByBranche"+sb.getSeqCurrentVal());
    	
    	//em.getTransaction().commit();


	}

public SequenceByBranch genererCurrSeq(String branchCode, String bankCode) {
	return (SequenceByBranch) em.createQuery(
			"SELECT sbb FROM SequenceByBranch sbb WHERE ( sbb.pk.branchCode='"
					+ branchCode + "' AND sbb.pk.bankCode='" + bankCode
					+ "' )").getSingleResult();

}
}