public ActionResult RegistroPersonas(Personitas newpersona) { DataClasses1DataContext db = new DataClasses1DataContext(); if (ModelState.IsValid) { persona per = new persona(); cliente cli = new cliente(); cli.nombre = newpersona.nombr; cli.telefono = newpersona.tel; cli.email = newpersona.email; cli.direccion = newpersona.dir; cli.ciudad = newpersona.ciu; cli.pais = newpersona.pa; cli.estado = newpersona.est; cli.contacto = newpersona.cont; db.clientes.InsertOnSubmit(cli); db.SubmitChanges(); int id = db.clientes.OrderByDescending(b => b.id).First().id; per.idCli = id; per.apellido_pat = newpersona.apel; per.apellido_mat = newpersona.apel_mat; per.pasaporte = newpersona.pas; per.comentarios = newpersona.come; per.cumpleanos = Convert.ToString(newpersona.cump); db.personas.InsertOnSubmit(per); db.SubmitChanges(); } ViewBag.cli = (from a in db.clientes join j in db.personas on a.id equals j.idCli select a).ToList(); return(Redirect("../Cliente/RegistroPersonas")); }
public ActionResult eliminarpersona(Personitas newpersonas) { DataClasses1DataContext dt = new DataClasses1DataContext(); if ((from i in dt.clientes where i.nombre == newpersonas.nombr select i).ToList().Count == 0) { ViewBag.flag = 0; } else { var x = (from i in dt.clientes join j in dt.personas on i.id equals j.idCli where i.nombre == newpersonas.nombr select new { telefono = i.telefono, id = i.id, apellido_pat = j.apellido_pat, apellido_mat = j.apellido_mat, pasaporte = j.pasaporte, email = i.email, direccion = i.direccion, ciudad = i.ciudad, estado = i.estado, pais = i.pais, contacto = i.contacto, cumple = j.cumpleanos, comen = j.comentarios }).ToArray()[0]; ViewBag.id = x.id; ViewBag.apellido_pat = x.apellido_pat; ViewBag.apellido_mat = x.apellido_mat; ViewBag.telefono = x.telefono; ViewBag.pasaporte = x.pasaporte; ViewBag.email = x.email; ViewBag.direccion = x.direccion; ViewBag.ciudad = x.ciudad; ViewBag.estado = x.estado; ViewBag.pais = x.pais; ViewBag.contacto = x.contacto; ViewBag.comentario = x.comen; ViewBag.cumpleaños = x.cumple; ViewBag.flag = 1; } return(View()); }
public ActionResult actualizarper(Personitas newpersonas) { DataClasses1DataContext db = new DataClasses1DataContext(); cliente c = db.clientes.Single(u => u.id == newpersonas.id); persona p = db.personas.Single(u => u.idCli == newpersonas.id); c.nombre = newpersonas.nombr; c.telefono = newpersonas.tel; c.direccion = newpersonas.dir; c.email = newpersonas.email; c.estado = newpersonas.est; c.ciudad = newpersonas.ciu; c.pais = newpersonas.pa; c.contacto = newpersonas.cont; p.apellido_pat = newpersonas.apel; p.apellido_mat = newpersonas.apel_mat; p.pasaporte = newpersonas.pas; p.cumpleanos = newpersonas.cump; p.comentarios = newpersonas.come; db.SubmitChanges(); return(Redirect("../Cliente/RegistroPersonas")); }