public ActionResult DeleteConfirmed(int id) { Cat_ExpMedico cat_ExpMedico = db.Cat_ExpMedico.Find(id); db.Cat_ExpMedico.Remove(cat_ExpMedico); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: Cat_ExpMedico/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Cat_ExpMedico cat_ExpMedico = db.Cat_ExpMedico.Find(id); if (cat_ExpMedico == null) { return(HttpNotFound()); } return(View(cat_ExpMedico)); }
// GET: Exp_AntPersoPatolog/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Cat_ExpMedico expediente = db.Cat_ExpMedico.Find(id); Exp_AntPersoPatolog exp_AntPersoPatolog = db.Exp_AntPersoPatolog.Find(expediente.i_fk_AntPatoPersonales); if (exp_AntPersoPatolog == null) { return(HttpNotFound()); } return(View(exp_AntPersoPatolog)); }
// GET: Exp_GinecoObstreticos/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Cat_ExpMedico expediente = db.Cat_ExpMedico.Find(id); Exp_GinecoObstreticos exp_GinecoObstreticos = db.Exp_GinecoObstreticos.Find(expediente.i_fk_GineObstetricos); if (exp_GinecoObstreticos == null) { return(HttpNotFound()); } return(View(exp_GinecoObstreticos)); }
// GET: Exp_HeredoFamiliar/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Cat_ExpMedico expediente = db.Cat_ExpMedico.Find(id); Exp_HeredoFamiliar exp_HeredoFamiliar = db.Exp_HeredoFamiliar.Find(expediente.i_fk_HereFamiliar); if (exp_HeredoFamiliar == null) { return(HttpNotFound()); } return(View(exp_HeredoFamiliar)); }
// GET: Exp_AnteQuirurTrauma/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Cat_ExpMedico expediente = db.Cat_ExpMedico.Find(id); Exp_AnteQuirurTrauma exp_AnteQuirurTrauma = db.Exp_AnteQuirurTrauma.Find(expediente.i_fk_QuirTrauma); if (exp_AnteQuirurTrauma == null) { return(HttpNotFound()); } return(View(exp_AnteQuirurTrauma)); }
public ActionResult Edit([Bind(Include = "i_PK_ExpMedico,i_FK_idFuncionario,i_FK_idUsuExterno,d_ExpMedico,i_fk_GineObstetricos,i_fk_HereFamiliar,i_fk_QuirTrauma,i_fk_AntPatoPersonales,b_Estado")] Cat_ExpMedico cat_ExpMedico) { if (ModelState.IsValid) { db.Entry(cat_ExpMedico).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.i_FK_idUsuExterno = new SelectList(db.CM_UsuarioExterno, "i_Pk_idUsuExterno", "vc_Cedula", cat_ExpMedico.i_FK_idUsuExterno); ViewBag.i_fk_QuirTrauma = new SelectList(db.Exp_AnteQuirurTrauma, "i_Pk_QuirurTrauma", "vc_FracDonde", cat_ExpMedico.i_fk_QuirTrauma); ViewBag.i_fk_AntPatoPersonales = new SelectList(db.Exp_AntPersoPatolog, "i_Pk_AntPatologicos", "vc_Piel", cat_ExpMedico.i_fk_AntPatoPersonales); ViewBag.i_fk_GineObstetricos = new SelectList(db.Exp_GinecoObstreticos, "i_Pk_idGinObste", "vc_Menarca", cat_ExpMedico.i_fk_GineObstetricos); ViewBag.i_fk_HereFamiliar = new SelectList(db.Exp_HeredoFamiliar, "i_Pk_HereFamiliar", "vc_Piel", cat_ExpMedico.i_fk_HereFamiliar); ViewBag.i_FK_idFuncionario = new SelectList(db.Funcionarios, "i_Pk_Funcionario", "vc_Cedula", cat_ExpMedico.i_FK_idFuncionario); return(View(cat_ExpMedico)); }
// GET: Cat_ExpMedico/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Cat_ExpMedico cat_ExpMedico = db.Cat_ExpMedico.Find(id); if (cat_ExpMedico == null) { return(HttpNotFound()); } ViewBag.i_FK_idUsuExterno = new SelectList(db.CM_UsuarioExterno, "i_Pk_idUsuExterno", "vc_Cedula", cat_ExpMedico.i_FK_idUsuExterno); ViewBag.i_fk_QuirTrauma = new SelectList(db.Exp_AnteQuirurTrauma, "i_Pk_QuirurTrauma", "vc_FracDonde", cat_ExpMedico.i_fk_QuirTrauma); ViewBag.i_fk_AntPatoPersonales = new SelectList(db.Exp_AntPersoPatolog, "i_Pk_AntPatologicos", "vc_Piel", cat_ExpMedico.i_fk_AntPatoPersonales); ViewBag.i_fk_GineObstetricos = new SelectList(db.Exp_GinecoObstreticos, "i_Pk_idGinObste", "vc_Menarca", cat_ExpMedico.i_fk_GineObstetricos); ViewBag.i_fk_HereFamiliar = new SelectList(db.Exp_HeredoFamiliar, "i_Pk_HereFamiliar", "vc_Piel", cat_ExpMedico.i_fk_HereFamiliar); ViewBag.i_FK_idFuncionario = new SelectList(db.Funcionarios, "i_Pk_Funcionario", "vc_Cedula", cat_ExpMedico.i_FK_idFuncionario); return(View(cat_ExpMedico)); }
// GET: Cat_ExpMedico/Delete/5 public ActionResult Delete(int?id) { Cat_ExpMedico exp_Medico = db.Cat_ExpMedico.Find(id); var r = from b in db.Cat_ExpMedico where b.i_PK_ExpMedico == id select b; foreach (var t in r) { if (t.b_Estado == true) { t.b_Estado = false; } else { t.b_Estado = true; } } db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "i_PK_ExpMedico,i_FK_idFuncionario,i_FK_idUsuExterno,d_ExpMedico,i_fk_GineObstetricos,i_fk_HereFamiliar,i_fk_QuirTrauma,i_fk_AntPatoPersonales,b_Estado")] Cat_ExpMedico cat_ExpMedico) { if (ModelState.IsValid) { try { Exp_GinecoObstreticos gineco = new Exp_GinecoObstreticos(); Exp_AnteQuirurTrauma quiTraum = new Exp_AnteQuirurTrauma(); Exp_HeredoFamiliar hereFam = new Exp_HeredoFamiliar(); Exp_AntPersoPatolog persoPato = new Exp_AntPersoPatolog(); cat_ExpMedico.Exp_GinecoObstreticos = gineco; cat_ExpMedico.Exp_AnteQuirurTrauma = quiTraum; cat_ExpMedico.Exp_HeredoFamiliar = hereFam; cat_ExpMedico.Exp_AntPersoPatolog = persoPato; var usuario_encontrado = from s in db.Funcionarios where s.vc_Cedula == cat_ExpMedico.i_FK_idFuncionario.ToString() select s; if (usuario_encontrado.Count() == 0) { var usuarioTemp2 = from a in db.CM_UsuarioExterno where a.vc_Cedula == cat_ExpMedico.i_FK_idUsuExterno.ToString() select a; if (usuarioTemp2.Count() == 0) { Response.Write("<script>window.alert('El usuario no se encuentra en el sistema.');</script>"); } else { foreach (var s in usuarioTemp2) { cat_ExpMedico.i_FK_idUsuExterno = s.i_Pk_idUsuExterno; } Response.Write("<script>window.alert('Expediente creado correctamente.');</script>"); db.Cat_ExpMedico.Add(cat_ExpMedico); db.SaveChanges(); return(RedirectToAction("Index")); } } else { foreach (var s in usuario_encontrado) { cat_ExpMedico.i_FK_idFuncionario = s.i_Pk_Funcionario; } Response.Write("<script>window.alert('Expediente creado correctamente.');</script>"); db.Cat_ExpMedico.Add(cat_ExpMedico); db.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception) { Response.Write("<script>window.alert('Error al crear expediente.');</script>"); } return(RedirectToAction("Index")); } ViewBag.i_FK_idUsuExterno = new SelectList(db.CM_UsuarioExterno, "i_Pk_idUsuExterno", "vc_Cedula", cat_ExpMedico.i_FK_idUsuExterno); ViewBag.i_fk_QuirTrauma = new SelectList(db.Exp_AnteQuirurTrauma, "i_Pk_QuirurTrauma", "vc_FracDonde", cat_ExpMedico.i_fk_QuirTrauma); ViewBag.i_fk_AntPatoPersonales = new SelectList(db.Exp_AntPersoPatolog, "i_Pk_AntPatologicos", "vc_Piel", cat_ExpMedico.i_fk_AntPatoPersonales); ViewBag.i_fk_GineObstetricos = new SelectList(db.Exp_GinecoObstreticos, "i_Pk_idGinObste", "vc_Menarca", cat_ExpMedico.i_fk_GineObstetricos); ViewBag.i_fk_HereFamiliar = new SelectList(db.Exp_HeredoFamiliar, "i_Pk_HereFamiliar", "vc_Piel", cat_ExpMedico.i_fk_HereFamiliar); ViewBag.i_FK_idFuncionario = new SelectList(db.Funcionarios, "i_Pk_Funcionario", "vc_Cedula", cat_ExpMedico.i_FK_idFuncionario); return(View(cat_ExpMedico)); }