public List <CurriculoViewModel> Listagem()
{
List <CurriculoViewModel> lista = new List <CurriculoViewModel>();
string sql = "select * from CadastroCurriculo order by nome";
DataTable tabela = HelperDAO.ExecutaSelect(sql, null);
foreach (DataRow registro in tabela.Rows)
{
lista.Add(MontaCurriculo(registro));
}
return(lista);
}
public CurriculoViewModel Consulta(string cpf)
{
string sql = "select * from CadastroCurriculo where cpf = " + cpf;
DataTable tabela = HelperDAO.ExecutaSelect(sql, null);
if (tabela.Rows.Count == 0)
{
return(null);
}
else
{
return(MontaCurriculo(tabela.Rows[0]));
}
}
