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