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