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; } }
public Medico() { contexto = new Persistencia_46272Entities(); }