public bool ValidarSenha(int crm, string senha)
        {
            Persistencia_46272Entities contexto = new Persistencia_46272Entities();
            var valida = from p in contexto.tbMedico 
                        where p.Senha == senha && p.CRM == crm
                        select p;

            if (valida.Count() > 0)
                return true;
            else
                return false;
        }
 public IQueryable ListarLaudo()
 {
     Persistencia_46272Entities contexto = new Persistencia_46272Entities();
     try
     {
         IQueryable laudos = from p in contexto.tbLaudo select p;
         return laudos;
     }
     catch (Exception)
     {
         
         throw;
     }
 }
        public void AtenderPaciente(DateTime dataAtendimento, string descricao, int crm, int cpf, string senha)
        {
            Persistencia_46272Entities contexto = new Persistencia_46272Entities();
            try
            {
                tbLaudo laudo = new tbLaudo();
                laudo.Data = dataAtendimento;
                laudo.Descricao = descricao;
                laudo.CRM = crm;
                laudo.CPF = cpf;

                contexto.tbLaudo.Add(laudo);
                contexto.SaveChanges();
            }
            catch (Exception)
            {
                
                throw;
            }
        }
Esempio n. 4
0
 public Medico()
 {
     contexto = new Persistencia_46272Entities();
 }