public ActionResult Editar_Compania(int?ID) { try { ViewData["Nombre"] = AccesoController.nombre; ViewData["Apellido"] = AccesoController.apellido; AddCompaniaViewModel model = new AddCompaniaViewModel(); using (SII_Entities db = new SII_Entities()) { var obj_Comp = db.Tbl_Compania.Find(ID); model.razon_Soc = obj_Comp.razon_Social; model.cedula_Jud = obj_Comp.cedula_Juridica; model.nombre_Comp = obj_Comp.nom_Compania; model.direc = obj_Comp.direccion; model.tel = obj_Comp.telefono; model.correo_Electronico = obj_Comp.correo_Electronico; model.id_Comp = obj_Comp.id_Compania; } return(View(model)); } catch (Exception) { return(Redirect("/Error/InaccessiblePage")); } }
public ActionResult Nueva_Compania(AddCompaniaViewModel model) { try { if (ModelState.IsValid) { using (SII_Entities db = new SII_Entities()) { var comp_ced = (from c in db.Tbl_Compania where c.cedula_Juridica == model.cedula_Jud select c.cedula_Juridica); if (comp_ced.Count() != 0) { Response.Write("<script>alert('¡El numero de cédula ya se encuentra registrado en el sistema! por favor, revíselo e intente de nuevo.');</script>"); return(View(model)); } else { var obj_Comp = new Tbl_Compania(); obj_Comp.razon_Social = model.razon_Soc; obj_Comp.cedula_Juridica = model.cedula_Jud; obj_Comp.nom_Compania = model.nombre_Comp; obj_Comp.direccion = model.direc; obj_Comp.telefono = model.tel; obj_Comp.correo_Electronico = model.correo_Electronico; obj_Comp.estado = 1; db.Tbl_Compania.Add(obj_Comp); db.SaveChanges(); TempData["msg"] = "Agregado"; ViewBag.Msg = TempData["msg"]; } } return(Redirect("/Compania/Mant_Compania")); } return(View(model)); } catch (Exception) { return(Redirect("/Error/InaccessiblePage")); } }
public ActionResult Editar_Compania(AddCompaniaViewModel model) { try { if (ModelState.IsValid) { using (SII_Entities db = new SII_Entities()) { var comp_ced = (from c in db.Tbl_Compania where c.cedula_Juridica == model.cedula_Jud select c.cedula_Juridica); if (comp_ced.Count() > 1) { Response.Write("<script>alert('¡El numero de cédula ya se encuentra registrado en el sistema! por favor, revíselo e intente de nuevo.');</script>"); return(View(model)); } var obj_Comp = db.Tbl_Compania.Find(model.id_Comp); obj_Comp.razon_Social = model.razon_Soc; obj_Comp.cedula_Juridica = model.cedula_Jud; obj_Comp.nom_Compania = model.nombre_Comp; obj_Comp.direccion = model.direc; obj_Comp.telefono = model.tel; obj_Comp.correo_Electronico = model.correo_Electronico; db.Entry(obj_Comp).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); TempData["msg"] = "Modificado"; ViewBag.Msg = TempData["msg"]; } return(Redirect("/Compania/Mant_Compania")); } return(View(model)); } catch (Exception ex) { throw new Exception(ex.Message); } }