// GET: Warnings/Create public ActionResult Create(string id) { int pagina = 511; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller, 510); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } int ids = Int32.Parse(id); ViewBag.CAMPO_ID = new SelectList(db.CAMPOS.Where(a => a.PAGINA_ID.Equals(ids)), "ID", "ID"); ViewBag.SPRAS_ID = new SelectList(db.SPRAS.Where(x => x.ID != "PT"), "ID", "ID"); ViewBag.POSICION = new SelectList(db.POSICIONs, "ID", "ID"); WARNING w = new WARNING(); w.PAGINA_ID = ids; return(View(w)); }
public ActionResult Edit([Bind(Include = "PAGINA_ID,CAMPO_ID,SPRAS_ID,WARNING1,POSICION,ACTIVO")] WARNING wARNING) { if (ModelState.IsValid) { wARNING.WARNING1 = wARNING.WARNING1.Replace("\r\n", "<br>"); db.Entry(wARNING).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", new { id = wARNING.PAGINA_ID })); } int pagina = 512; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller, 510); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } ViewBag.PAGINA_ID = new SelectList(db.CAMPOS, "PAGINA_ID", "DESCRIPCION", wARNING.PAGINA_ID); ViewBag.POSICION = new SelectList(db.POSICIONs, "ID", "ID"); return(View(wARNING)); }
// GET: Warnings/Edit/5 public ActionResult Edit(string spras_id, string campo_id, int pagina_id) { int pagina = 512; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller, 510); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } WARNING wARNING = db.WARNINGs.Find(pagina_id, campo_id, spras_id); if (wARNING == null) { return(HttpNotFound()); } wARNING.WARNING1 = wARNING.WARNING1.Replace("<br>", "\r\n"); ViewBag.PAGINA_ID = new SelectList(db.CAMPOS, "PAGINA_ID", "DESCRIPCION", wARNING.PAGINA_ID); ViewBag.CAMPO_ID = new SelectList(db.CAMPOS.Where(a => a.PAGINA_ID.Equals(wARNING.PAGINA_ID)), "ID", "ID"); ViewBag.POSICION = new SelectList(db.POSICIONs, "ID", "ID"); return(View(wARNING)); }
public ActionResult Create([Bind(Include = "PAGINA_ID,CAMPO_ID,SPRAS_ID,WARNING1,POSICION,ACTIVO")] WARNING wARNING) { if (ModelState.IsValid) { var obj = db.WARNINGs.Where(a => a.PAGINA_ID.Equals(wARNING.PAGINA_ID) && a.CAMPO_ID.Equals(wARNING.CAMPO_ID) && a.SPRAS_ID.Equals(wARNING.SPRAS_ID)).FirstOrDefault(); if (obj == null) { wARNING.WARNING1 = wARNING.WARNING1.Replace("\r\n", "<br>"); db.WARNINGs.Add(wARNING); db.SaveChanges(); return(RedirectToAction("Index", new { id = wARNING.PAGINA_ID })); } } int pagina = 511; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller, 510); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } ViewBag.CAMPO_ID = new SelectList(db.CAMPOS.Where(a => a.PAGINA_ID.Equals(wARNING.PAGINA_ID)), "ID", "ID"); ViewBag.SPRAS_ID = new SelectList(db.SPRAS.Where(x => x.ID != "PT"), "ID", "ID"); ViewBag.POSICION = new SelectList(db.POSICIONs, "ID", "ID"); ViewBag.Error = "Registro duplicado"; return(View(wARNING)); }
public ActionResult DeleteConfirmed(int id) { WARNING wARNING = db.WARNINGs.Find(id); db.WARNINGs.Remove(wARNING); db.SaveChanges(); return(RedirectToAction("Index", new { id = wARNING.PAGINA_ID })); }
public ActionResult Create([Bind(Include = "PAGINA_ID,CAMPO_ID,SPRAS_ID,WARNING1,POSICION,ACTIVO")] WARNING wARNING) { if (ModelState.IsValid) { var obj = db.WARNINGs.Where(a => a.PAGINA_ID.Equals(wARNING.PAGINA_ID) && a.CAMPO_ID.Equals(wARNING.CAMPO_ID) && a.SPRAS_ID.Equals(wARNING.SPRAS_ID)).FirstOrDefault(); if (obj == null) { wARNING.ACTIVO = true; wARNING.WARNING1 = wARNING.WARNING1.Replace("\r\n", "<br>"); db.WARNINGs.Add(wARNING); db.SaveChanges(); return(RedirectToAction("Index", new { id = wARNING.PAGINA_ID })); } } int pagina = 511; //ID EN BASE DE DATOS using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; 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(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList(); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } } ViewBag.CAMPO_ID = new SelectList(db.CAMPOS.Where(a => a.PAGINA_ID.Equals(wARNING.PAGINA_ID)), "ID", "ID"); ViewBag.SPRAS_ID = new SelectList(db.SPRAS, "ID", "ID"); ViewBag.POSICION = new SelectList(db.POSICIONs, "ID", "ID"); ViewBag.Error = "Registro duplicado"; return(View(wARNING)); }
// GET: Warnings/Edit/5 public ActionResult Edit(string spras_id, string campo_id, int pagina_id) { int pagina = 512; //ID EN BASE DE DATOS using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; 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(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList(); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } } if (spras_id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WARNING wARNING = db.WARNINGs.Find(pagina_id, campo_id, spras_id); if (wARNING == null) { return(HttpNotFound()); } wARNING.WARNING1 = wARNING.WARNING1.Replace("<br>", "\r\n"); ViewBag.PAGINA_ID = new SelectList(db.CAMPOS, "PAGINA_ID", "DESCRIPCION", wARNING.PAGINA_ID); ViewBag.CAMPO_ID = new SelectList(db.CAMPOS.Where(a => a.PAGINA_ID.Equals(wARNING.PAGINA_ID)), "ID", "ID"); ViewBag.POSICION = new SelectList(db.POSICIONs, "ID", "ID"); return(View(wARNING)); }
// GET: Warnings/Create public ActionResult Create(string id) { int pagina = 511; //ID EN BASE DE DATOS using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; 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(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList(); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; } int ids = Int32.Parse(id); //ViewBag.PAGINA_ID = new SelectList(db.PAGINAs, "ID", "URL"); ViewBag.CAMPO_ID = new SelectList(db.CAMPOS.Where(a => a.PAGINA_ID.Equals(ids)), "ID", "ID"); ViewBag.SPRAS_ID = new SelectList(db.SPRAS, "ID", "ID"); ViewBag.POSICION = new SelectList(db.POSICIONs, "ID", "ID"); WARNING w = new WARNING(); w.PAGINA_ID = ids; return(View(w)); }
// GET: Warnings/Details/5 public ActionResult Details(string spras_id, string campo_id, int pagina_id) { int pagina = 513; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller, 510); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } WARNING wARNING = db.WARNINGs.Find(pagina_id, campo_id, spras_id); if (wARNING == null) { return(HttpNotFound()); } return(View(wARNING)); }