Z-Archive » Maybank Projects » M2U UPASS Project

/**

 * Copyright (M) 2011 Penril Datability (M) Sdn Bhd All rights reserved.

 *

 * This software is copyrighted. Under the copyright laws, this software

 * may not be copied, in whole or in part, without prior written consent

 * of Penril Datability (M) Sdn Bhd or its assignees. This software is

 * provided under the terms of a license between Penril Datability (M)

 * Sdn Bhd and the recipient, and its use is subject to the terms of that

 * license.

 */

package my.com.upass.dao.hibernate;

import my.com.upass.dao.UserTacDAO;

import my.com.upass.pojo.TacBean;

import net.penril.generic.hibernate.GenericDAOHibernate;

import org.apache.log4j.Logger;

import org.hibernate.Criteria;

import org.hibernate.FetchMode;

import org.hibernate.HibernateException;

import org.hibernate.Session;

import org.hibernate.criterion.Restrictions;

/**

 * 

 * PROGRAMMER: Danniell CHANGE-NO: TASK-NO: DATE CREATED: Aug 3, 2011 TAG AS:

 * REASON(S): MODIFICATION:

 */

public class UserTacDAOHibernate

                extends GenericDAOHibernate<TacBean, String>

                implements UserTacDAO {

        private static Logger logger = Logger.getLogger(UserTacDAOHibernate.class);

        /**

         * @see my.com.upass.dao.UserTacDAO#getTacFromStore(java.lang.String, int)

         */

        @Override

        public TacBean getTacFromStore(String userAlias, int appId) {

                TacBean tac = null;

                Criteria criteria;

                Session session = null;

                try {

                        session = getSession();

                        criteria = session.createCriteria(TacBean.class);

                        criteria.setFetchMode("upassUser", FetchMode.JOIN);

                        criteria.createAlias("upassUser", "u");

                        criteria.add(Restrictions.eq("u.userAlias", userAlias));

                        criteria.add(Restrictions.eq("u.applicationId", appId));

                        tac = (TacBean) criteria.uniqueResult();

                } catch (Exception e) {

                        logger.error(e, e);

                } finally {

                        if (session != null && session.isConnected()) {

                                session.close();

                        }

                }

                return tac;

        }

        /**

         * @see my.com.upass.dao.UserTacDAO#updateTacToStore(my.com.upass.pojo.TacBean)

         */

        @Override

        public boolean updateTacToStore(TacBean tacBean) {

                boolean isUpdated = false;

                Session session = null;

                try {

                        session = getSession();

                        session.beginTransaction();

                        session.update(tacBean);

                        session.getTransaction().commit();

                        isUpdated = true;

                } catch (Exception e) {

                        if (e instanceof HibernateException) {

                                if (session != null) {

                                        session.getTransaction().rollback();

                                }

                        }

                        logger.error(e, e);

                } finally {

                        if (session != null && session.isConnected()) {

                                session.close();

                        }

                }

                return isUpdated;

        }

}