Пример #1
0
        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);
        }
Пример #2
0
        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]));
            }
        }