com.cimmyt.model.dao.impl.CompanyDAOImpl.java Source code

Introduction

Here is the source code for com.cimmyt.model.dao.impl.CompanyDAOImpl.java

Source

/*
Copyright 2013 International Maize and Wheat Improvement Center
   Licensed under the Apache License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0
   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
*/
//
// Created: April 2009
//
// Copyright 2009 International Rice Research Institute (IRRI) and 
// Centro Internacional de Mejoramiento de Maiz y Trigo (CIMMYT)
//
// Licensed under the Apache License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
//
//$ Id: CompanyDAO.java, Jun 10, 2010 TMSANCHEZ $
package com.cimmyt.model.dao.impl;

import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Restrictions;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.cimmyt.model.bean.Company;
import com.cimmyt.model.bean.StorageLocation;
import com.cimmyt.model.dao.CompanyDAO;
import com.cimmyt.model.dao.StorageLocationDAO;;

/**
 * Data Access Object class for Company management
 * @version $Revision$, $Date: 2010-08-27 16:44:59 -0500 (Fri, 27 Aug 2010) $
 */
public class CompanyDAOImpl extends AbstractDAO<Company, Integer> implements CompanyDAO {

    private StorageLocationDAO storageLocationDAO;

    public CompanyDAOImpl() {
        super(Company.class);
    }

    /**
     * 
     * @param criteria
     * @param companyFilter
     */
    protected void buildCriteria(DetachedCriteria criteria, Company companyFilter) {
        if (companyFilter.getIdCompany() != null) {
            criteria.add(Restrictions.eq("idCompany", companyFilter.getIdCompany()));
        }

        if (companyFilter.getName() != null && companyFilter.getName().trim().length() > 0) {
            criteria.add(Restrictions.like("name", "%" + companyFilter.getName() + "%"));
        }
    }

    public boolean SearchIfAnyHaveThisLocations(final StorageLocation slocat) {
        Company company;
        final String queryString = "from Company as com " + " where com.storagelocation.imslocid = :LOCID ";

        company = (Company) getHibernateTemplate().execute(new HibernateCallback() {

            @Override
            public Object doInHibernate(Session session) throws HibernateException, SQLException {
                Company compa = new Company();

                Query query = session.createQuery(queryString);
                query.setParameter("LOCID", slocat.getImslocid());

                if (query.uniqueResult() != null) {
                    compa = (Company) query.uniqueResult();
                }

                return compa;
            }
        });

        if (company.getStoragelocation() == null)
            return false;
        else
            return true;
    }

    /**
     * Get List Company by filter
     * @param Company
     */
    @Override
    public List<Company> getListByFilter(Company bean) {
        return super.getListByFilter(bean);
    }

    /**
     * Add Company
     * @param Company
     */
    @Override
    public void add(Company bean) {
        StorageLocation storagecompany = new StorageLocation();
        storagecompany.setImslocidparent(1);
        storagecompany.setLname(bean.getName());
        storageLocationDAO.create(storagecompany);
        bean.setStoragelocation(storagecompany);
        super.update(bean);

    }

    /**
     * Delete Company
     * @param Company
     */
    @Override
    public void delete(Company bean) {
        super.delete(bean);
    }

    /**
     * Get Company by name
     * @param String name
     */
    @Override
    public Company getCompanyByName(String name) {
        try {
            Company company = super.findSingleByValues(new Company(), new String[] { "name" },
                    new Object[] { name });
            return company;
        } catch (Exception e) {
            return null;
        }
    }

    public void setStorageLocationDAO(StorageLocationDAO storageLocationDAO) {
        this.storageLocationDAO = storageLocationDAO;
    }

    @Override
    protected void buildCriteria(DetachedCriteria criteria, Company filter, Integer id) {
        // TODO Auto-generated method stub

    }

}