TransportDAO

package th.in.oneauthen.object.DAO;

import java.util.List;

import org.apache.log4j.Logger;

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

public class TransportDAO extends StandardDAOImpl<TransportDB>{

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

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

    public List<TransportDB> getFileByEmail(String email , boolean status) {
        List<TransportDB> history = null;
        try {
            DAO.begin();
            history = (List<TransportDB>) DAO.getEntityManager().createNamedQuery("fileByEmail")
                    .setParameter("email", email)
                    .setParameter("status", status)
                    .setMaxResults(75)
                    .getResultList();

        } catch (Exception e) {
            logger.error("Invalid user loading with ID " + status+" and "+email, e);
        } finally {
            DAO.close();
        }
        return history;
    }

    public List<TransportDB> getFileForPreview(String email , String fileName ,boolean status) {
        List<TransportDB> history = null;
        try {
            DAO.begin();
            history = (List<TransportDB>) DAO.getEntityManager().createNamedQuery("getFileForPreview")
                    .setParameter("email", email)
                    .setParameter("fileName", fileName)
                    .setParameter("status", status)
                    .setMaxResults(1)
                    .getResultList();

        } catch (Exception e) {
            logger.error("Invalid user loading with ID " + fileName+" and "+email, e);
        } finally {
            DAO.close();
        }
        return history;
    }


}