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