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])); } }