D-Net

package eu.dnetlib.goldoa.service.dao;

import eu.dnetlib.goldoa.domain.Help;

import org.hibernate.criterion.Restrictions;

import org.springframework.stereotype.Repository;

import java.util.List;

/*

 * Created by antleb on 4/17/15.

*/

@Repository

public class HelpDAO extends  AbstractDao<String,Help>{

//	private final static String UPDATE_HELP = "update help set name=?, text=? where id=?";

//	private final static String INSERT_HELP = "insert into help (name, text, id) values (?, ?, ?)";

//	private final static String GET_BY_ID = "select id, name, text from help where id = ?";

//	private final static String GET_ALL = "select id, name, text from help";

//	private final static String DELETE = "delete from help where id = ?";

	public Help saveHelp(Help help) {

		getSession().merge(help);

		return help;

	}

	public Help getById(String id) {

		List res = createEntityCriteria().add(Restrictions.eq("id", id)).list();

		if (!res.isEmpty())

        	return (Help) res.get(0);

		else

			return null;

    }

    @SuppressWarnings("unchecked")

	public List<Help> getAll() {

        return createEntityCriteria().list();

    }

	public void delete(String helpId) {

	    delete(getById(helpId));

	}

}