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.TbAmUsermasDAO;

import my.com.upass.pojo.UserMasterBean;

import net.penril.generic.hibernate.GenericDAOHibernate;

import org.hibernate.Criteria;

import org.hibernate.HibernateException;

import org.hibernate.criterion.Restrictions;

/**

 * 

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

 * REASON(S): MODIFICATION:

 */

public class UserMasterDAOHibernate extends

                GenericDAOHibernate<UserMasterBean, Long> implements TbAmUsermasDAO

{

        public UserMasterBean getTbAmUsermasByUserId (Integer tUserId)

                        throws Exception

        {

                UserMasterBean TbAmUserMas;

                try

                {

                        getSession ().beginTransaction ();

                        Criteria m_oCriteria = getSession ().createCriteria (

                                        UserMasterBean.class);

                        m_oCriteria.add (Restrictions.eq ("userId", tUserId));

                        TbAmUserMas = (UserMasterBean) m_oCriteria.uniqueResult ();

                        getSession ().getTransaction ().commit ();

                }

                catch (Exception e)

                {

                        if (e instanceof HibernateException)

                        {

                                getSession ().getTransaction ().rollback ();

                        }

                        throw e;

                }

                finally

                {

                        getSession ().close ();

                }

                return TbAmUserMas;

        }

        public UserMasterBean getTbAmUsermasByUserAlias (String userAlias)

                        throws Exception

        {

                UserMasterBean TbAmUserMas;

                try

                {

                        getSession ().beginTransaction ();

                        Criteria m_oCriteria = getSession ().createCriteria (

                                        UserMasterBean.class);

                        m_oCriteria.add (Restrictions.eq ("userAlias", userAlias));

                        TbAmUserMas = (UserMasterBean) m_oCriteria.uniqueResult ();

                        getSession ().getTransaction ().commit ();

                }

                catch (Exception e)

                {

                        if (e instanceof HibernateException)

                        {

                                getSession ().getTransaction ().rollback ();

                        }

                        throw e;

                }

                finally

                {

                        getSession ().close ();

                }

                return TbAmUserMas;

        }

        public void deleteTbAmUsermas (Integer tUserId) throws Exception

        {

                Long ID = Long.valueOf (String.valueOf (tUserId));

                UserMasterBean tbAmUsermas;

                try

                {

                        getSession ().beginTransaction ();

                        Criteria m_oCriteria = getSession ().createCriteria (

                                        UserMasterBean.class);

                        m_oCriteria.add (Restrictions.eq ("userId", ID));

                        tbAmUsermas = (UserMasterBean) m_oCriteria.uniqueResult ();

                        makeTransient (tbAmUsermas);

                        getSession ().getTransaction ().commit ();

                        getSession ().close ();

                }

                catch (Exception e)

                {

                        getSession ().getTransaction ().rollback ();

                        throw e;

                }

                finally

                {

                        getSession ().close ();

                }

        }

}