public ActionResult DeleteConfirmed(int id) { try { TX_CONCEPTO txc = db.TX_CONCEPTO.Where(x => x.ID == id).FirstOrDefault(); txc.ACTIVO = false; db.Entry(txc).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception e) { var x = e.ToString(); } return(View()); }
// GET: Txc/Details/5 public ActionResult Details(int?id) { int pagina = 802; //ID EN BASE DE DATOS USUARIO user = null; using (TruequeEntities db = new TruequeEntities()) { string u = User.Identity.Name; //string u = "admin"; 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(801) || 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)); } TX_CONCEPTO tX_CONCEPTO = db.TX_CONCEPTO.Find(id); if (tX_CONCEPTO == null) { return(HttpNotFound()); } ViewBag.SPRAS = db.SPRAS.ToList(); return(View(tX_CONCEPTO)); }
// GET: Txc/Create public ActionResult Create() { int pagina = 804; //ID EN BASE DE DATOS USUARIO user = null; using (TruequeEntities db = new TruequeEntities()) { string u = User.Identity.Name; //string u = "admin"; 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(801) || 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; } ViewBag.SPRAS = db.SPRAS.ToList(); TX_CONCEPTO concepto = new TX_CONCEPTO(); concepto.ACTIVO = true; return(View(concepto)); }
public ActionResult Edit([Bind(Include = "ID,DESCRIPCION,ACTIVO")] TX_CONCEPTO tX_CONCEPTO, string[] txval) { if (ModelState.IsValid) { //Recuperamos todas las descripciones en sus lenguajes List <SPRA> ss = db.SPRAS.ToList(); foreach (SPRA s in ss) { try { TX_CONCEPTOT txt = new TX_CONCEPTOT(); txt.SPRAS_ID = s.ID; txt.TXT50 = Request.Form[s.ID].ToString(); txt.CONCEPTO_ID = tX_CONCEPTO.ID; db.Entry(txt).State = EntityState.Modified; db.SaveChanges(); } catch (Exception e) { var ex = e.ToString(); } } if (txval != null) { //Posterior a lo ingresado List <TX_CONCEPTOT> lstc = db.TX_CONCEPTOT.Where(i => i.CONCEPTO_ID == tX_CONCEPTO.ID).ToList(); //si el arreglo solo incluye 1 dato, significa que ya hay 2 lenguajes if (txval.Length == 1) { var x1 = lstc[0].SPRAS_ID; var x2 = lstc[1].SPRAS_ID; if (lstc[0].SPRAS_ID == "EN") { if (lstc[1].SPRAS_ID == "ES") { // Lleno el primer objeto TX_CONCEPTOT trvt = new TX_CONCEPTOT(); trvt.SPRAS_ID = "PT"; trvt.CONCEPTO_ID = tX_CONCEPTO.ID; trvt.TXT50 = txval[0]; db.TX_CONCEPTOT.Add(trvt); db.SaveChanges(); } if (lstc[1].SPRAS_ID == "PT") { //Lleno el primer objeto TX_CONCEPTOT trvt = new TX_CONCEPTOT(); trvt.SPRAS_ID = "ES"; trvt.CONCEPTO_ID = tX_CONCEPTO.ID; trvt.TXT50 = txval[0]; db.TX_CONCEPTOT.Add(trvt); db.SaveChanges(); } } if (lstc[0].SPRAS_ID == "ES") { if (lstc[1].SPRAS_ID == "PT") { //Lleno el primer objeto TX_CONCEPTOT trvt = new TX_CONCEPTOT(); trvt.SPRAS_ID = "EN"; trvt.CONCEPTO_ID = tX_CONCEPTO.ID; trvt.TXT50 = txval[0]; db.TX_CONCEPTOT.Add(trvt); db.SaveChanges(); } } } //si el arreglo incluye 2 datos, significa que ya hay 1 lenguaje else if (txval.Length == 2) { if (lstc[0].SPRAS_ID == "ES") { //Lleno el primer objeto TX_CONCEPTOT trvt = new TX_CONCEPTOT(); trvt.SPRAS_ID = "EN"; trvt.CONCEPTO_ID = tX_CONCEPTO.ID; trvt.TXT50 = txval[0]; db.TX_CONCEPTOT.Add(trvt); db.SaveChanges(); //Lleno el segundo objeto TX_CONCEPTOT trvt2 = new TX_CONCEPTOT(); trvt2.SPRAS_ID = "PT"; trvt2.CONCEPTO_ID = tX_CONCEPTO.ID; trvt2.TXT50 = txval[1]; db.TX_CONCEPTOT.Add(trvt2); db.SaveChanges(); } else if (lstc[0].SPRAS_ID == "EN") { //Lleno el primer objeto TX_CONCEPTOT trvt = new TX_CONCEPTOT(); trvt.SPRAS_ID = "ES"; trvt.CONCEPTO_ID = tX_CONCEPTO.ID; trvt.TXT50 = txval[0]; db.TX_CONCEPTOT.Add(trvt); db.SaveChanges(); //Lleno el segundo objeto TX_CONCEPTOT trvt2 = new TX_CONCEPTOT(); trvt2.SPRAS_ID = "PT"; trvt2.CONCEPTO_ID = tX_CONCEPTO.ID; trvt2.TXT50 = txval[1]; db.TX_CONCEPTOT.Add(trvt2); db.SaveChanges(); } else if (lstc[0].SPRAS_ID == "PT") { //Lleno el primer objeto TX_CONCEPTOT trvt = new TX_CONCEPTOT(); trvt.SPRAS_ID = "ES"; trvt.CONCEPTO_ID = tX_CONCEPTO.ID; trvt.TXT50 = txval[0]; db.TX_CONCEPTOT.Add(trvt); db.SaveChanges(); //Lleno el segundo objeto TX_CONCEPTOT trvt2 = new TX_CONCEPTOT(); trvt.SPRAS_ID = "EN"; trvt.CONCEPTO_ID = tX_CONCEPTO.ID; trvt.TXT50 = txval[1]; db.TX_CONCEPTOT.Add(trvt); db.SaveChanges(); } } } db.Entry(tX_CONCEPTO).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tX_CONCEPTO)); }
public ActionResult CreateA([Bind(Include = "ID,DESCRIPCION,ACTIVO")] TX_CONCEPTO tX_CONCEPTO) { try { if (tX_CONCEPTO.DESCRIPCION != null) { if (ModelState.IsValid) { tX_CONCEPTO.ACTIVO = true; db.TX_CONCEPTO.Add(tX_CONCEPTO); db.SaveChanges(); //Posterior a la insercion del registro, insertar en treversat List <SPRA> ss = db.SPRAS.ToList(); foreach (SPRA s in ss) { TX_CONCEPTOT trvt = new TX_CONCEPTOT(); trvt.SPRAS_ID = s.ID; trvt.CONCEPTO_ID = tX_CONCEPTO.ID; trvt.TXT50 = tX_CONCEPTO.DESCRIPCION; db.TX_CONCEPTOT.Add(trvt); db.SaveChanges(); } TempData["Mensaje"] = "Concepto creado correctamente."; return(Json("Concepto creado correctamente.", JsonRequestBehavior.AllowGet)); } } else { ViewBag.error = "Sin Texto"; } } catch (Exception e) { var x = e.ToString(); } int pagina = 804; //ID EN BASE DE DATOS USUARIO user = null; using (TruequeEntities db = new TruequeEntities()) { string u = User.Identity.Name; //string u = "admin"; 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(801) || 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; } return(Json("")); }
public ActionResult Create([Bind(Include = "ID,DESCRIPCION,ACTIVO")] TX_CONCEPTO tX_CONCEPTO, string[] txval) { try { if (tX_CONCEPTO.DESCRIPCION != null) { if (ModelState.IsValid) { db.TX_CONCEPTO.Add(tX_CONCEPTO); db.SaveChanges(); //Recuperamos todas las descripciones en sus lenguajes List <SPRA> ss = db.SPRAS.ToList(); var i = 0; foreach (SPRA s in ss) { try { TX_CONCEPTOT txt = new TX_CONCEPTOT(); txt.SPRAS_ID = s.ID; txt.TXT50 = txval[i]; txt.CONCEPTO_ID = tX_CONCEPTO.ID; db.Entry(txt).State = EntityState.Added; db.SaveChanges(); i++; } catch (Exception e) { var ex = e.ToString(); } } return(RedirectToAction("Index")); } } else { ViewBag.error = "Sin Texto"; } } catch (Exception e) { var x = e.ToString(); } int pagina = 804; //ID EN BASE DE DATOS USUARIO user = null; using (TruequeEntities db = new TruequeEntities()) { string u = User.Identity.Name; //string u = "admin"; 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(801) || 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; } return(View(tX_CONCEPTO)); }