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