package br.com.centralit.citcorpore.integracao; import java.util.ArrayList; import java.util.Collection; import java.util.List; import br.com.centralit.citcorpore.bean.ControleContratoDTO; import br.com.centralit.citcorpore.bean.ControleContratoTreinamentoDTO; import br.com.citframework.dto.IDto; import br.com.citframework.excecao.PersistenceException; import br.com.citframework.integracao.CrudDaoDefaultImpl; import br.com.citframework.integracao.Field; import br.com.citframework.util.Constantes; /** * @author Pedro * */ public class ControleContratoTreinamentoDao extends CrudDaoDefaultImpl { public ControleContratoTreinamentoDao() { super(Constantes.getValue("DATABASE_ALIAS"), null); } @SuppressWarnings("rawtypes") public Class getBean() { return ControleContratoTreinamentoDTO.class; } public Collection<Field> getFields() { Collection<Field> listFields = new ArrayList<>(); listFields.add(new Field("idcctreinamento", "idCcTreinamento", true, true, false, false)); listFields.add(new Field("idcontrolecontrato", "idControleContrato", false, false, false, false)); listFields.add(new Field("idempregadotreinamento", "idEmpregadoTreinamento", false, false, false, false)); listFields.add(new Field("nomecctreinamento", "nomeCcTreinamento", false, false, false, false)); listFields.add(new Field("datacctreinamento", "dataCcTreinamento", false, false, false, false)); return listFields; } public String getTableName() { return "CONTROLECONTRATOTREINAMENTO"; } @SuppressWarnings({ "rawtypes" }) public Collection find(IDto obj) throws PersistenceException { List ordem = new ArrayList(); return super.find(obj, ordem); } @SuppressWarnings({ "rawtypes" }) public Collection list() throws PersistenceException { List list = new ArrayList(); return super.list(list); } private static final String SQL_DELETE = "DELETE FROM CONTROLECONTRATOTREINAMENTO WHERE idcontrolecontrato = ? "; public void deleteByIdControleContrato(ControleContratoDTO controleContrato) throws PersistenceException { super.execUpdate(SQL_DELETE, new Object[]{controleContrato.getIdControleContrato()}); } private static final String SQL_FIND = "SELECT * FROM CONTROLECONTRATOTREINAMENTO WHERE idcontrolecontrato = ? "; public Collection findByIdControleContrato(ControleContratoTreinamentoDTO dto) throws PersistenceException { return super.listConvertion(getBean(), super.execSQL(SQL_FIND, new Object[]{dto.getIdControleContrato()}), new ArrayList(getFields())); } }