// 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));
}
