// GET: HistoriaClinicas public ActionResult HistoriaCompleta() { //var nombre = "1"; using (var DB = new DermatologiaEntities()) { var nombre = DB.Database.SqlQuery <string>("Select * From Paciente JOIN HistoriaClinica ON Paciente.Cedula = HistoriaClinica.IDPaciente").ToList(); return(View(nombre)); } // return View(nombre.ToList()); }
public ActionResult Login(Empleado objUser) { //if (ModelState.IsValid) //{ using (DermatologiaEntities db = new DermatologiaEntities()) { var obj = db.Empleado.Where(a => a.Login.Equals(objUser.Login) && a.Password.Equals(objUser.Password)).FirstOrDefault(); if (obj != null) { Session["Login"] = obj.Login.ToString(); Session["Name"] = obj.Nombre.ToString(); return(RedirectToAction("Index", "Home", null)); } else { return(Content("F")); } } //} return(View(objUser)); }