us.mn.state.health.lims.inventory.daoimpl.InventoryLocationDAOImpl.java Source code

Introduction

Here is the source code for us.mn.state.health.lims.inventory.daoimpl.InventoryLocationDAOImpl.java

Source

/**
* The contents of this file are subject to the Mozilla Public License
* Version 1.1 (the "License"); you may not use this file except in
* compliance with the License. You may obtain a copy of the License at
* http://www.mozilla.org/MPL/ 
* 
* Software distributed under the License is distributed on an "AS IS"
* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
* License for the specific language governing rights and limitations under
* the License.
* 
* The Original Code is OpenELIS code.
* 
* Copyright (C) The Minnesota Department of Health.  All Rights Reserved.
*/
package us.mn.state.health.lims.inventory.daoimpl;

import java.util.List;

import org.apache.commons.beanutils.PropertyUtils;

import us.mn.state.health.lims.audittrail.dao.AuditTrailDAO;
import us.mn.state.health.lims.audittrail.daoimpl.AuditTrailDAOImpl;
import us.mn.state.health.lims.common.action.IActionConstants;
import us.mn.state.health.lims.common.daoimpl.BaseDAOImpl;
import us.mn.state.health.lims.common.exception.LIMSRuntimeException;
import us.mn.state.health.lims.common.log.LogEvent;
import us.mn.state.health.lims.hibernate.HibernateUtil;
import us.mn.state.health.lims.inventory.dao.InventoryLocationDAO;
import us.mn.state.health.lims.inventory.valueholder.InventoryLocation;

public class InventoryLocationDAOImpl extends BaseDAOImpl implements InventoryLocationDAO {

    @SuppressWarnings("unchecked")
    public List<InventoryLocation> getAllInventoryLocations() throws LIMSRuntimeException {
        List<InventoryLocation> inventoryItems;
        try {
            String sql = "from InventoryLocation";
            org.hibernate.Query query = HibernateUtil.getSession().createQuery(sql);
            inventoryItems = query.list();
            HibernateUtil.getSession().flush();
            HibernateUtil.getSession().clear();
        } catch (Exception e) {
            LogEvent.logError("InventoryLocationDAOImpl", "getAllInventoryLocations()", e.toString());
            throw new LIMSRuntimeException("Error in InventoryLocation getAllInventoryLocations()", e);
        }

        return inventoryItems;
    }

    public void deleteData(List<InventoryLocation> inventoryItems) throws LIMSRuntimeException {
        try {
            AuditTrailDAO auditDAO = new AuditTrailDAOImpl();
            for (InventoryLocation data : inventoryItems) {

                InventoryLocation oldData = readInventoryLocation(data.getId());
                InventoryLocation newData = new InventoryLocation();

                String sysUserId = data.getSysUserId();
                String event = IActionConstants.AUDIT_TRAIL_DELETE;
                String tableName = "INVENTORY_ITEM";
                auditDAO.saveHistory(newData, oldData, sysUserId, event, tableName);
            }

            for (InventoryLocation data : inventoryItems) {

                data = readInventoryLocation(data.getId());
                HibernateUtil.getSession().delete(data);
                HibernateUtil.getSession().flush();
                HibernateUtil.getSession().clear();
            }
        } catch (Exception e) {
            LogEvent.logError("InventoryLocationDAOImpl", "deleteData()", e.toString());
            throw new LIMSRuntimeException("Error in InventoryLocation deleteData()", e);
        }
    }

    public boolean insertData(InventoryLocation inventoryItem) throws LIMSRuntimeException {
        try {
            String id = (String) HibernateUtil.getSession().save(inventoryItem);
            inventoryItem.setId(id);

            AuditTrailDAO auditDAO = new AuditTrailDAOImpl();
            String sysUserId = inventoryItem.getSysUserId();
            String tableName = "INVENTORY_ITEM";
            auditDAO.saveNewHistory(inventoryItem, sysUserId, tableName);

            HibernateUtil.getSession().flush();
            HibernateUtil.getSession().clear();

        } catch (Exception e) {
            LogEvent.logError("InventoryLocationDAOImpl", "insertData()", e.toString());
            throw new LIMSRuntimeException("Error in InventoryLocation insertData()", e);
        }

        return true;
    }

    public void updateData(InventoryLocation inventoryItem) throws LIMSRuntimeException {
        InventoryLocation oldData = readInventoryLocation(inventoryItem.getId());
        InventoryLocation newData = inventoryItem;

        //add to audit trail
        try {
            AuditTrailDAO auditDAO = new AuditTrailDAOImpl();
            String sysUserId = inventoryItem.getSysUserId();
            String event = IActionConstants.AUDIT_TRAIL_UPDATE;
            String tableName = "INVENTORY_ITEM";
            auditDAO.saveHistory(newData, oldData, sysUserId, event, tableName);

            HibernateUtil.getSession().merge(inventoryItem);
            HibernateUtil.getSession().flush();
            HibernateUtil.getSession().clear();
            HibernateUtil.getSession().evict(inventoryItem);
            HibernateUtil.getSession().refresh(inventoryItem);
        } catch (Exception e) {
            LogEvent.logError("InventoryLocationDAOImpl", "updateData()", e.toString());
            throw new LIMSRuntimeException("Error in InventoryLocation updateData()", e);
        }
    }

    public void getData(InventoryLocation inventoryItem) throws LIMSRuntimeException {
        try {
            InventoryLocation tmpInventoryLocation = (InventoryLocation) HibernateUtil.getSession()
                    .get(InventoryLocation.class, inventoryItem.getId());
            HibernateUtil.getSession().flush();
            HibernateUtil.getSession().clear();
            if (tmpInventoryLocation != null) {
                PropertyUtils.copyProperties(inventoryItem, tmpInventoryLocation);
            } else {
                inventoryItem.setId(null);
            }
        } catch (Exception e) {
            LogEvent.logError("InventoryLocationDAOImpl", "getData()", e.toString());
            throw new LIMSRuntimeException("Error in InventoryLocation getData()", e);
        }
    }

    public InventoryLocation readInventoryLocation(String idString) throws LIMSRuntimeException {
        InventoryLocation data = null;
        try {
            data = (InventoryLocation) HibernateUtil.getSession().get(InventoryLocation.class, idString);
            HibernateUtil.getSession().flush();
            HibernateUtil.getSession().clear();
        } catch (Exception e) {
            LogEvent.logError("InventoryLocationDAOImpl", "readInventoryLocation()", e.toString());
            throw new LIMSRuntimeException("Error in InventoryLocation readInventoryLocation()", e);
        }

        return data;
    }

    public InventoryLocation getInventoryLocationById(InventoryLocation inventoryItem) throws LIMSRuntimeException {
        try {
            InventoryLocation re = (InventoryLocation) HibernateUtil.getSession().get(InventoryLocation.class,
                    inventoryItem.getId());
            HibernateUtil.getSession().flush();
            HibernateUtil.getSession().clear();
            return re;
        } catch (Exception e) {
            LogEvent.logError("InventoryLocationDAOImpl", "getInventoryLocationById()", e.toString());
            throw new LIMSRuntimeException("Error in InventoryLocation getInventoryLocationById()", e);
        }
    }

}