public ActionResult Edit([Bind(Include = "SOCIEDAD_ID,PAIS_ID,VKORG,VTWEG,SPART,KUNNR,CONCEPTO_ID,TNOTA_ID,FECHAC,USUARIOC_ID,FECHAM,USUARIOM_ID,IMPUESTO_ID,PORC,PAY_T,ACTIVO")] TAXEOH tx, string MWSKZ) { if (ModelState.IsValid) { var por = db.IIMPUESTOes.Where(ip => ip.MWSKZ == MWSKZ).FirstOrDefault(); var tax = db.TAXEOHs.Where(x => x.KUNNR == tx.KUNNR && x.VKORG == tx.VKORG && x.CONCEPTO_ID == tx.CONCEPTO_ID).FirstOrDefault(); tax.IMPUESTO_ID = MWSKZ; tax.PORC = por.KBETR; tax.PAY_T = tx.PAY_T; db.Entry(tax).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } int pagina_id = 853; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller, 851); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".svg"; } catch { //ViewBag.pais = "mx.svg"; //return RedirectToAction("Pais", "Home"); } ViewBag.VKORG = new SelectList(db.CLIENTEs, "VKORG", "NAME1", tx.VKORG); ViewBag.IMPUESTO_ID = new SelectList(db.IMPUESTOes, "MWSKZ", "MWSKZ", tx.IMPUESTO_ID); ViewBag.PAIS_ID = new SelectList(db.PAIS, "LAND", "SPRAS", tx.PAIS_ID); ViewBag.SOCIEDAD_ID = new SelectList(db.SOCIEDADs, "BUKRS", "BUTXT", tx.SOCIEDAD_ID); ViewBag.CONCEPTO_ID = new SelectList(db.TX_CONCEPTO, "ID", "DESCRIPCION", tx.CONCEPTO_ID); ViewBag.TNOTA_ID = new SelectList(db.TX_TNOTA, "ID", "DESCRIPCION", tx.TNOTA_ID); return(View(tx)); }
public ActionResult Edit([Bind(Include = "SOCIEDAD_ID,CAMPO,PORC_AD,PERIODOS,ACTIVO")] CONFDIST_CAT cONFDIST_CAT, string bools) { try { ////CONFDIST_CAT cf = db.CONFDIST_CAT.Where(i => i.SOCIEDAD_ID == cONFDIST_CAT.SOCIEDAD_ID && i.CAMPO == cONFDIST_CAT.CAMPO && i.PERIODOS == cONFDIST_CAT.PERIODOS).FirstOrDefault(); CONFDIST_CAT cf = db.CONFDIST_CAT.Where(i => i.SOCIEDAD_ID == cONFDIST_CAT.SOCIEDAD_ID).FirstOrDefault(); cf.PORC_AD = false; cf.ACTIVO = true; cf.CAMPO = cONFDIST_CAT.CAMPO; cf.PERIODOS = cONFDIST_CAT.PERIODOS; if (cf.PERIODOS == null) { cf.PERIODOS = 1; } if (ModelState.IsValid) { db.Entry(cf).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Details", new { id = cf.SOCIEDAD_ID })); } } catch (Exception e) { ViewBag.error = e.ToString(); } int pagina = 873; //ID EN BASE DE DATOS using (TruequeEntities db = new TruequeEntities()) { 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(871) || 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; } List <bool> lstb = new List <bool>(); lstb.Add(true); lstb.Add(false); ViewBag.CAMPO = new SelectList(db.CAMPOZKE24, "CAMPO", "CAMPO", cONFDIST_CAT.CAMPO); ViewBag.SOCIEDAD_ID = new SelectList(db.SOCIEDADs, "BUKRS", "BUKRS", cONFDIST_CAT.SOCIEDAD_ID); ViewBag.bools = new SelectList(lstb); return(View(cONFDIST_CAT)); }
public ActionResult Edit([Bind(Include = "ID,ACTIVO")] PUESTO pUESTO) { if (ModelState.IsValid) { List <SPRA> ss = db.SPRAS.ToList(); foreach (SPRA s in ss) { try { PUESTOT p = new PUESTOT(); p.PUESTO_ID = pUESTO.ID; p.SPRAS_ID = s.ID; p.TXT50 = Request.Form[s.ID].ToString(); db.Entry(p).State = EntityState.Modified; db.SaveChanges(); } catch { } } db.Entry(pUESTO).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } int pagina = 621; //ID EN BASE DE DATOS using (TruequeEntities db = new TruequeEntities()) { 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(623)).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 { //ViewBag.pais = "mx.png"; //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; } return(View(pUESTO)); }
public ActionResult Edit([Bind(Include = "WORKF_ID,WF_VERSION,WF_POS,NUM_DOC,POS,LOOP,USUARIOA_ID,USUARIOD_ID,ESTATUS,FECHAC,HORAC,FECHAM,HORAM")] FLUJO fLUJO) { if (ModelState.IsValid) { db.Entry(fLUJO).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.NUM_DOC = new SelectList(db.DOCUMENTOes, "NUM_DOC", "TSOL_ID", fLUJO.NUM_DOC); ViewBag.USUARIOA_ID = new SelectList(db.USUARIOs, "ID", "PASS", fLUJO.USUARIOA_ID); ViewBag.USUARIOD_ID = new SelectList(db.USUARIOs, "ID", "PASS", fLUJO.USUARIOD_ID); ViewBag.WORKF_ID = new SelectList(db.WORKFPs, "ID", "EMAIL", fLUJO.WORKF_ID); return(View(fLUJO)); }
public ActionResult Edit([Bind(Include = "BUKRS,BUTXT,ORT01,LAND,SUBREGIO,WAERS,SPRAS,NAME1,KTOPL,ACTIVO,REGION")] SOCIEDAD sOCIEDAD) { if (ModelState.IsValid) { db.Entry(sOCIEDAD).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ObtenerConfPage(922); //if (sOCIEDAD.REGION != null) // sOCIEDAD.REGION = sOCIEDAD.REGION.TrimEnd(); //ViewBag.REGION = new SelectList(db.REGIONs.Where(x => x.SOCIEDAD == sOCIEDAD.BUKRS).ToList(), "REGION1", "REGION1", sOCIEDAD.REGION != null ? sOCIEDAD.REGION.TrimEnd() : ""); return(View(sOCIEDAD)); }
public ActionResult Edit([Bind(Include = "ID,NOMBRE,SOCIEDAD_ID,PAIS_ID,ACTIVO")] PROVEEDOR pROVEEDOR) { if (ModelState.IsValid) { try { pROVEEDOR.PAIS_ID = pROVEEDOR.PAIS_ID; pROVEEDOR.SOCIEDAD_ID = pROVEEDOR.SOCIEDAD_ID; db.Entry(pROVEEDOR).State = EntityState.Modified; db.SaveChanges(); } catch (Exception e) { var ex = e.ToString(); } return(RedirectToAction("Index")); } int pagina = 773; //ID EN BASE DE DATOS using (TruequeEntities db = new TruequeEntities()) { 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(771) || 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.SOCIEDAD_ID = new SelectList(db.SOCIEDADs, "BUKRS", "BUTXT", pROVEEDOR.SOCIEDAD_ID); ViewBag.PAIS_ID = new SelectList(db.PAIS, "LAND", "LANDX", pROVEEDOR.PAIS_ID); return(View(pROVEEDOR)); }
public ActionResult Edit([Bind(Include = "SOCIEDAD_ID,PAIS_ID,TSOL,FACTURA,FECHA,PROVEEDOR,CONTROL,AUTORIZACION,VENCIMIENTO,FACTURAK,EJERCICIOK,BILL_DOC,BELNR,IMPORTE_FAC,PAYER,DESCRIPCION,SOCIEDAD,ACTIVO")] FACTURASCONF fACTURASCONF) { if (ModelState.IsValid) { db.Entry(fACTURASCONF).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } int pagina_id = 1213; //ID EN BASE DE DATOS int pagina2 = 1210; FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller, pagina2); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".svg"; } catch { //return RedirectToAction("Pais", "Home"); } return(View(fACTURASCONF)); }
public ActionResult Edit(Calendario445ViewModel modelView) { int pagina_id = 532;//ID EN BASE DE DATOS try { CALENDARIO_AC calendarioAc = modelView.calendario445; DateTime fechaActual = DateTime.Now; calendarioAc.USUARIOM_ID = User.Identity.Name; calendarioAc.FECHAM = fechaActual; if (!ValidarFechas(calendarioAc)) { throw (new Exception()); } db.Entry(calendarioAc).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception) { FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller); CargarSelectList(ref modelView, new string[] { CMB_SOCIEDADES + "," + modelView.calendario445.SOCIEDAD_ID, CMB_PERIODOS + "," + modelView.calendario445.PERIODO, CMB_EJERCICIO, CMB_TIPOSSOLICITUD + "," + modelView.calendario445.TSOL_ID }); return(View(modelView)); } }
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)); }
public ActionResult ListModAutorizador(List <SolicitudPorAprobar> solicitudPorAprobar) { try { string usuarioa_id = solicitudPorAprobar.First().USUARIOA_ID_NUEVO; foreach (SolicitudPorAprobar sol in solicitudPorAprobar) { //actualizar registro ant. FLUJO f = db.FLUJOes.Where(x => x.NUM_DOC == sol.NUM_DOC).OrderByDescending(a => a.POS).FirstOrDefault(); if (f.ESTATUS == "P") { db.FLUJOes.Add(new FLUJO { WORKF_ID = f.WORKF_ID, WF_VERSION = f.WF_VERSION, WF_POS = f.WF_POS, NUM_DOC = f.NUM_DOC, POS = f.POS + 1, DETPOS = f.DETPOS, DETVER = f.DETVER, LOOP = f.LOOP, USUARIOD_ID = f.USUARIOD_ID, USUARIOA_ID = usuarioa_id, ESTATUS = f.ESTATUS, FECHAC = DateTime.Now, FECHAM = DateTime.Now, COMENTARIO = "Se modifica Autorizador", STATUS = f.STATUS }); f.ESTATUS = "M"; f.STATUS = null; f.FECHAM = DateTime.Now; db.Entry(f).State = EntityState.Modified; } } db.SaveChanges(); } catch (Exception e) { Log.ErrorLogApp(e, "ModificacionesGlobales", "ListModAutorizador"); } return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "SOCIEDAD_ID,PAIS_ID,VKORG,VTWEG,SPART,KUNNR,CONCEPTO_ID,POS,RETENCION_ID,PORC,ACTIVO,TRETENCION_ID")] TAXEOP tAXEOP) { TAXEOP tx = db.TAXEOPs.Where(t => t.POS == tAXEOP.POS).FirstOrDefault(); tx.RETENCION_ID = tAXEOP.RETENCION_ID; tx.TRETENCION_ID = tAXEOP.TRETENCION_ID; tx.PORC = tAXEOP.PORC; if (ModelState.IsValid) { db.Entry(tx).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", new { sc = tx.SOCIEDAD_ID, ld = tx.PAIS_ID, kun = tx.KUNNR, vk = tx.VKORG, vtw = tx.VTWEG, sp = tx.SPART, con = tx.CONCEPTO_ID })); } ViewBag.RETENCION_ID = new SelectList(db.RETENCIONs, "ID", "DESCRIPCIÓN", tAXEOP.RETENCION_ID); ViewBag.SOCIEDAD_ID = new SelectList(db.TAXEOHs, "SOCIEDAD_ID", "USUARIOC_ID", tAXEOP.SOCIEDAD_ID); ViewBag.TRETENCION_ID = new SelectList(db.TRETENCIONs, "ID", "DESCRIPCION", tAXEOP.TRETENCION_ID); return(View(tAXEOP)); }
public ActionResult Edit([Bind(Include = "CANAL1,CDESCRIPCION")] CANAL cANAL) { if (ModelState.IsValid) { db.Entry(cANAL).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cANAL)); }
public ActionResult Edit([Bind(Include = "WAERS,ISOCD,ALTWR,LTEXT,KTEXT,ACTIVO")] MONEDA mONEDA) { if (ModelState.IsValid) { db.Entry(mONEDA).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(mONEDA)); }
public ActionResult Edit([Bind(Include = "SOCIEDAD_ID,PAIS_ID,TALL_ID,EJERCICIO,ABONO,CARGO,CLEARING,LIMITE,IMPUESTO")] CUENTA cUENTA) { if (ModelState.IsValid) { db.Entry(cUENTA).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cUENTA)); }
public ActionResult Edit([Bind(Include = "LAND,SPRAS,LANDX,IMAGE,ACTIVO")] PAI pAI) { if (ModelState.IsValid) { db.Entry(pAI).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(pAI)); }
public ActionResult Edit([Bind(Include = "ID,CLAVE,NOMBRE,ACTIVO")] ROL rOL) { if (ModelState.IsValid) { db.Entry(rOL).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(rOL)); }
public ActionResult Edit([Bind(Include = "ID,DESCRIPCION,TSOL_ID,ESTATUS,USUARIO_ID,FECHAC")] WORKFH wORKFH) { if (ModelState.IsValid) { db.Entry(wORKFH).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(wORKFH)); }
public ActionResult Edit([Bind(Include = "ID,FECHAI,FECHAF,PATH,USUARIOC_ID,FECHAC,ACTIVO")] NOTICIA nOTICIA) { if (ModelState.IsValid) { db.Entry(nOTICIA).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.USUARIOC_ID = new SelectList(db.USUARIOs, "ID", "PASS", nOTICIA.USUARIOC_ID); return(View(nOTICIA)); }
public ActionResult Edit([Bind(Include = "ID,SPRAS_ID,CAMPO,TEXTO")] TEXTOCV tEXTOCV) { if (ModelState.IsValid) { db.Entry(tEXTOCV).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SPRAS_ID = new SelectList(db.SPRAS, "ID", "DESCRIPCION", tEXTOCV.SPRAS_ID); return(View(tEXTOCV)); }
public ActionResult Edit([Bind(Include = "KURST,FCURR,TCURR,GDATU,UKURS")] TCAMBIO tCAMBIO) { //Codigo incrustado //tCAMBIO.KURST = "C"; if (ModelState.IsValid) { db.Entry(tCAMBIO).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tCAMBIO)); }
// GET: Flujos public ActionResult Index() { int pagina = 103; //ID EN BASE DE DATOS using (TruequeEntities db = new TruequeEntities()) { 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 { //ViewBag.pais = "mx.png"; //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; } List <DET_AGENTE> dda = db.DET_AGENTE.ToList(); foreach (DET_AGENTE da in dda) { string id = da.GAUTORIZACION.USUARIOs.Where(a => a.PUESTO_ID.Equals(da.PUESTOA_ID)).FirstOrDefault().ID; da.USUARIOA = id; da.USUARIOC = da.GAUTORIZACION.USUARIOs.Where(a => a.PUESTO_ID.Equals(da.PUESTOC_ID)).FirstOrDefault().ID; db.Entry(da).State = EntityState.Modified; db.SaveChanges(); } //List<USUARIO> uu = db.USUARIOs.ToList(); //foreach(USUARIO u in uu) //{ // foreach(GAUTORIZACION g in u.GAUTORIZACIONs) // { // int i = 0; // } //} var fLUJOes = db.FLUJOes.Include(f => f.DOCUMENTO).Include(f => f.USUARIO).Include(f => f.USUARIO1).Include(f => f.WORKFP); return(View(fLUJOes.ToList())); }
public ActionResult Edit([Bind(Include = "ID,URL,TITULO,CARPETA_ID,ICON,ACTIVO,MOSTRAR")] PAGINA pAGINA) { if (ModelState.IsValid) { List <SPRA> ss = db.SPRAS.ToList(); foreach (SPRA s in ss) { PAGINAT p = new PAGINAT(); try { p.ID = pAGINA.ID; p.SPRAS_ID = s.ID; p.TXT50 = Request.Form[s.ID].ToString(); db.PAGINATs.Add(p); db.SaveChanges(); } catch (Exception e) { db.Entry(p).State = EntityState.Modified; db.SaveChanges(); } } return(RedirectToAction("Index")); } int pagina = 504; //ID EN BASE DE DATOS 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(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 { //ViewBag.pais = "mx.png"; //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; ViewBag.CARPETA_ID = new SelectList(db.CARPETAs, "ID", "URL", pAGINA.CARPETA_ID); return(View(pAGINA)); }
public ActionResult Edit([Bind(Include = "PUESTOC_ID,POS,PUESTOA_ID,BUKRS,MONTO,PRESUPUESTO,ACTIVO")] DET_APROB dET_APROB) { if (ModelState.IsValid) { db.Entry(dET_APROB).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.PUESTOC_ID = new SelectList(db.PUESTOes, "ID", "ID", dET_APROB.PUESTOC_ID); ViewBag.PUESTOA_ID = new SelectList(db.PUESTOes, "ID", "ID", dET_APROB.PUESTOA_ID); ViewBag.BUKRS = new SelectList(db.SOCIEDADs, "BUKRS", "BUTXT", dET_APROB.BUKRS); return(View(dET_APROB)); }
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)); }
public ActionResult Edit([Bind(Include = "LAND,MWSKZ,KSCHL,KBETR")] IIMPUESTO iIMPUESTO) { if (ModelState.IsValid) { iIMPUESTO.ACTIVO = true; db.Entry(iIMPUESTO).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MWSKZ = new SelectList(db.IMPUESTOes, "MWSKZ", "MWSKZ", iIMPUESTO.MWSKZ); ViewBag.LAND = new SelectList(db.PAIS, "LAND", "SPRAS", iIMPUESTO.LAND); return(View(iIMPUESTO)); }
public ActionResult Edit([Bind(Include = "ID,DESCRIPCION,ACTIVO")] TSOPORTE tSOPORTE, FormCollection collection) { if (ModelState.IsValid) { db.Entry(tSOPORTE).State = EntityState.Modified; db.SaveChanges(); var textos = db.TSOPORTETs.Where(t => t.TSOPORTE_ID == tSOPORTE.ID).ToList(); db.TSOPORTETs.RemoveRange(textos); List <TSOPORTET> listTextos = new List <TSOPORTET>(); if (collection.AllKeys.Contains("EN") && !String.IsNullOrEmpty(collection["EN"])) { TSOPORTET m = new TSOPORTET { SPRAS_ID = "EN", TSOPORTE_ID = tSOPORTE.ID, TXT50 = collection["EN"].ToUpper() }; listTextos.Add(m); } if (collection.AllKeys.Contains("ES") && !String.IsNullOrEmpty(collection["ES"])) { TSOPORTET m = new TSOPORTET { SPRAS_ID = "ES", TSOPORTE_ID = tSOPORTE.ID, TXT50 = collection["ES"].ToUpper() }; listTextos.Add(m); } db.TSOPORTETs.AddRange(listTextos); db.SaveChanges(); return(RedirectToAction("Index")); } int pagina_id = 1317; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller); ViewBag.activo = true; try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".svg"; } catch { //return RedirectToAction("Pais", "Home"); } return(View(tSOPORTE)); }
public ActionResult Create([Bind(Include = "TSOL_ID,TSOPORTE_ID,OBLIGATORIO,ACTIVO")] CONSOPORTE cONSOPORTE) { if (ModelState.IsValid) { if (db.CONSOPORTEs.Any(x => x.TSOPORTE_ID == cONSOPORTE.TSOPORTE_ID && x.TSOL_ID == cONSOPORTE.TSOL_ID)) { CONSOPORTE cONSOPORTEAux = db.CONSOPORTEs.First(x => x.TSOPORTE_ID == cONSOPORTE.TSOPORTE_ID && x.TSOL_ID == cONSOPORTE.TSOL_ID); cONSOPORTEAux.ACTIVO = cONSOPORTE.ACTIVO; cONSOPORTEAux.OBLIGATORIO = cONSOPORTE.OBLIGATORIO; db.Entry(cONSOPORTEAux).State = EntityState.Modified; } else { db.CONSOPORTEs.Add(cONSOPORTE); } db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.TSOL_ID = new SelectList(db.TSOLs, "ID", "DESCRIPCION", cONSOPORTE.TSOL_ID); ViewBag.TSOPORTE_ID = new SelectList(db.TSOPORTEs, "ID", "DESCRIPCION", cONSOPORTE.TSOPORTE_ID); return(View(cONSOPORTE)); }
public ActionResult Create([Bind(Include = "ID,DESCRIPCION,ACTIVO")] TX_TNOTA tX_TNOTA, string[] txval) { try { if (ModelState.IsValid) { db.TX_TNOTA.Add(tX_TNOTA); db.SaveChanges(); TX_TNOTA txn = db.TX_TNOTA.Where(x => x.DESCRIPCION == tX_TNOTA.DESCRIPCION).FirstOrDefault(); if (txn != null) { List <SPRA> ss = db.SPRAS.ToList(); var i = 0; foreach (SPRA s in ss) { try { TX_NOTAT txt = new TX_NOTAT(); txt.SPRAS_ID = s.ID; txt.TXT50 = txval[i]; txt.TNOTA_ID = txn.ID; db.Entry(txt).State = EntityState.Added; db.SaveChanges(); i++; } catch (Exception e) { var ex = e.ToString(); } } } return(RedirectToAction("Index")); } } catch (Exception e) { var a = e.ToString(); } return(View(tX_TNOTA)); }
public ActionResult Edit([Bind(Include = "PAGINA_ID,ROL_ID,PERMISO")] PERMISO_PAGINA pERMISO_PAGINA, string ac) { if (ModelState.IsValid) { PERMISO_PAGINA pp = pERMISO_PAGINA; if (ac == "Activo") { pp.PERMISO = false; } else if (ac == "Inactivo") { pp.PERMISO = true; } db.Entry(pERMISO_PAGINA).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", new { id = pp.ROL_ID })); } int pagina = 763; //ID EN BASE DE DATOS using (TruequeEntities db = new TruequeEntities()) { 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(761) || 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.PAGINA_ID = new SelectList(db.PAGINAs, "ID", "URL", pERMISO_PAGINA.PAGINA_ID); ViewBag.ROL_ID = new SelectList(db.PUESTOes, "ID", "ID", pERMISO_PAGINA.ROL_ID); return(View(pERMISO_PAGINA)); }
public void updateRango(string TSOL_ID, decimal actual) { using (TruequeEntities db = new TruequeEntities()) { RANGO rango = getRango(TSOL_ID); if (rango.ACTUAL > rango.INICIO && rango.ACTUAL < rango.FIN) { rango.ACTUAL = actual; } db.Entry(rango).State = EntityState.Modified; db.SaveChanges(); } }