SignatureProfileDAO

package th.in.oneauthen.object.DAO;

import java.util.ArrayList;
import java.util.List;

import javax.persistence.NoResultException;

import org.apache.log4j.Logger;

import th.athichitsakul.dao.impl.StandardDAOImpl;
import th.in.oneauthen.object.SignatureProfileDB;
import th.in.oneauthen.object.UserUidDB;
import th.in.oneauthen.util.SystemLogger;

public class SignatureProfileDAO extends StandardDAOImpl<SignatureProfileDB>{

    private Logger logger = SystemLogger.generateSystemLogger(SignatureProfileDAO.class);

    public void updateSignatureProfile(SignatureProfileDB updateData) {
        DAO.begin();
        try {
            SignatureProfileDB db = DAO.getEntityManager().find(SignatureProfileDB.class, updateData.getProfileID());

            //== do update ==
            db.setProfileKey(updateData.getProfileKey());
            db.setProfileKeyPIN(updateData.getProfileKeyPIN());

            DAO.getEntityManager().merge(db);
            DAO.getTransaction().commit();
        }catch (Exception e) {
            if (DAO.getTransaction().isActive()) {
                DAO.getTransaction().rollback();
            }
            logger.error("Update signature profile failed for "+updateData.getProfileName(),e);
        }

    }

    public SignatureProfileDAO() {
        super("esigning");
    }

    public SignatureProfileDB findByNameAndUserUID ( String profileName, int ownerId ) {//String profileName, int ownerId
        SignatureProfileDB profile = null;
        try {
            UserUidDB user = new UserUidDAO().find(ownerId);
//          UserUidDB user = new UserUidDAO().findUserByIdCard(ownerId);
            if ( user == null ) {
                logger.error("User not found with ID "+ownerId);
            } else {
                DAO.begin();
                profile = ( SignatureProfileDB ) DAO.getEntityManager().createNamedQuery("getSignatureProfileByNameAndOwner")
                        .setParameter("profileName", profileName)
                        .setParameter("userUid", user)
                        .getSingleResult();
            }

        } catch (NoResultException nullE){
            logger.debug("Profile not found with userId="+ownerId + " and profileName="+profileName);
        } catch (Exception e) {
            logger.error("Invalid user loading with ID "+ownerId , e);
        } finally {
            DAO.close();
        }
        return profile;
    }

    public List<SignatureProfileDB> listUserSignature(int ownerId) {
        List<SignatureProfileDB> profile = new ArrayList();
        try {
            UserUidDB user = new UserUidDAO().find(ownerId);
            if ( user == null ) {
                logger.error("User not found with ID "+ownerId);
            } else {
                DAO.begin();
                profile = ( List<SignatureProfileDB> ) DAO.getEntityManager().createNamedQuery("listSignatureProfileByOwner")
                        .setParameter("userUid", user).getResultList();
            }

        } catch (Exception e) {
            logger.error("Invalid user loading with ID "+ownerId , e);
        } finally {
            DAO.close();
        }
        return profile;
    }
}