protected bool Login(string email, string senha, ConexaoBD conexaoBD)
        {
            this.atributos = new AtributosPaciente();
            this.atributos.AdicionarSenha(senha);

            DataSet data = conexaoBD.ExecuteSelect("select email, nomeCompleto, celular, telefoneResidencial, endereco, dataDeNascimento, caminhoFoto " +
                                                   " from paciente where email='" + email + "' and senha='" + this.atributos.SenhaCriptografada + "'");

            if (data.Tables[0].Rows.Count <= 0)
            {
                return(false);
            }

            Paciente.ColocarAtributosFromDs(ref this.atributos, 0, data);
            return(true);
        }
        public static AtributosPaciente DeEmail(string email, ConexaoBD conexaoBD)
        {
            try
            {
                DataSet data = conexaoBD.ExecuteSelect("select email, nomeCompleto, celular, telefoneResidencial, endereco, dataDeNascimento, caminhoFoto " +
                                                       " from paciente where email='" + email + "'");
                if (data.Tables[0].Rows.Count <= 0)
                {
                    return(null);
                }

                AtributosPaciente atributos = new AtributosPaciente();
                Paciente.ColocarAtributosFromDs(ref atributos, 0, data);
                return(atributos);
            }
            catch (Exception e)
            {
                return(null);
            }
        }