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