public ActionResult Agree() { if (_SessionId != null) { using (var DB = new emeciEntities()) { var Data = (from p in DB.Paciente where p.idPaciente == _SessionId.Value select p).FirstOrDefault(); if (Data != null) { Data.acepto = true; DB.SaveChanges(); } } } return(Json(new { status = "ok" }, JsonRequestBehavior.AllowGet)); }
protected override void OnActionExecuting(ActionExecutingContext filterContext) { base.OnActionExecuting(filterContext); if (_SessionId == null) { filterContext.Result = new RedirectResult(Url.Action("FirstAccess", "LogIn")); } else { GetImage_Patient(); using (var DB = new emeciEntities()) { var query = (from p in DB.Paciente join r in DB.Registro on p.IdRegistro equals r.idRegistro where p.idPaciente == _SessionId.Value select new { r.Nombre, r.Apellido, p.Sexo, p.FechaNacimiento }).First(); if (query != null) { ViewBag.Header_PatientName = $"{query.Nombre} {query.Apellido}"; ViewBag.Header_PatientSex = query.Sexo; ViewBag.Header_PatientAge = (DateTime.Now.Year - query.FechaNacimiento.Value.Year); if (query.FechaNacimiento.HasValue) { ViewBag.agePatient = (DateTime.Now.Year - query.FechaNacimiento.Value.Year); } else { ViewBag.agePatient = 0; } ViewBag.sexPatient = query.Sexo; ViewBag.showObstetrica_Ginecologia = (ViewBag.agePatient >= 12 && query.Sexo == "F"); ViewBag.showAntecedent = (ViewBag.agePatient >= 12 && query.Sexo == "M"); } } } }