public ActionResult Create([Bind(Include = "ID,PAIS_ID,LEYENDA1,ACTIVO,EDITABLE,OBLIGATORIA")] LEYENDA lEYENDA, bool ed, bool Ob) { if (ModelState.IsValid) { lEYENDA.ACTIVO = true; lEYENDA.EDITABLE = ed; lEYENDA.OBLIGATORIA = Ob; db.LEYENDAs.Add(lEYENDA); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.PAIS_ID = new SelectList(db.PAIS, "LAND", "LAND", lEYENDA.PAIS_ID); return(View(lEYENDA)); }
public ActionResult DeleteConfirmed(string id) { try { LEYENDA lEYENDA = db.LEYENDAs.Where(i => i.ID == id).FirstOrDefault(); //Lo damos de baja con el false lEYENDA.ACTIVO = false; db.Entry(lEYENDA).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception e) { var x = e.ToString(); return(View()); } }
// GET: Leyenda/Delete/5 public ActionResult Delete(string id) { int pagina = 755; //ID EN BASE DE DATOS using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; //string u = "admin"; var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault(); ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList(); ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList(); ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;; ViewBag.rol = user.PUESTO.PUESTOTs.Where(a => a.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50; ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50; ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList(); ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(751) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList(); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".svg"; } catch { //ViewBag.pais = "mx.svg"; //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; ViewBag.lan = user.SPRAS_ID; } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LEYENDA lEYENDA = db.LEYENDAs.Where(i => i.ID == id).FirstOrDefault(); ViewBag.ed = lEYENDA.EDITABLE; ViewBag.ob = lEYENDA.OBLIGATORIA; ViewBag.ac = lEYENDA.ACTIVO; if (lEYENDA == null) { return(HttpNotFound()); } return(View(lEYENDA)); }
public ActionResult Edit([Bind(Include = "ID,PAIS_ID,LEYENDA1,ACTIVO,EDITABLE,OBLIGATORIA")] LEYENDA lEYENDA, bool Ed, bool Ob, string ac) { if (ModelState.IsValid) { if (ac == "true") { lEYENDA.ACTIVO = true; } else { lEYENDA.ACTIVO = false; } lEYENDA.EDITABLE = Ed; lEYENDA.OBLIGATORIA = Ob; db.Entry(lEYENDA).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.PAIS_ID = new SelectList(db.PAIS, "LAND", "LAND", lEYENDA.PAIS_ID); return(View(lEYENDA)); }
// GET: Leyenda/Edit/5 public ActionResult Edit(string id) { int pagina = 753; //ID EN BASE DE DATOS using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; //string u = "admin"; var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault(); ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList(); ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList(); ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;; ViewBag.rol = user.PUESTO.PUESTOTs.Where(a => a.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50; ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50; ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList(); ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(751) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList(); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".svg"; } catch { //ViewBag.pais = "mx.svg"; //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; ViewBag.lan = user.SPRAS_ID; } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LEYENDA lEYENDA = db.LEYENDAs.Where(i => i.ID == id).FirstOrDefault(); List <bool> lstE = new List <bool>(); List <bool> lstO = new List <bool>(); //Para Editable if (lEYENDA.EDITABLE == false) { lstE.Add(lEYENDA.EDITABLE); lstE.Add(true); } else if (lEYENDA.EDITABLE == true) { lstE.Add(lEYENDA.EDITABLE); lstE.Add(false); } //Para Obligatorio if (lEYENDA.OBLIGATORIA == false) { lstO.Add(lEYENDA.OBLIGATORIA); lstO.Add(true); } else if (lEYENDA.OBLIGATORIA == true) { lstO.Add(lEYENDA.OBLIGATORIA); lstO.Add(false); } if (lEYENDA == null) { return(HttpNotFound()); } ViewBag.Ed = new SelectList(lstE); ViewBag.Ob = new SelectList(lstO); ViewBag.idA = lEYENDA.ACTIVO; ViewBag.PAIS_ID = new SelectList(db.PAIS, "LAND", "LAND", lEYENDA.PAIS_ID); return(View(lEYENDA)); }