public ActionResult Create([Bind(Include = "ID,TITULO,FINICIO,FRECUENCIA,FRECUENCIA_N,DIA_SEMANA,DIA_MES,ORDINAL_MES,ORDINAL_DSEMANA")] NEGOCIACION2 nEGOCIACION, FormCollection col) { int pagina = 903; //ID EN BASE DE DATOS string u = User.Identity.Name; USUARIO user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault(); FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller, 901); ViewBag.mensajes = JsonConvert.SerializeObject(db.MENSAJES.Where(a => (a.PAGINA_ID.Equals(901) || a.PAGINA_ID.Equals(0)) && a.SPRAS.Equals(user.SPRAS_ID)).ToList(), Formatting.Indented); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".svg"; } catch { } ViewBag.lan = user.SPRAS_ID; if (ModelState.IsValid) { NEGOCIACION2 nego = new NEGOCIACION2(); var proximaFecha = FnCommon.obtenerProximaFecha(nEGOCIACION, col["group1"]); nego.FRECUENCIA_N = nEGOCIACION.FRECUENCIA_N; nego.TITULO = nEGOCIACION.TITULO; nego.FRECUENCIA = nEGOCIACION.FRECUENCIA; nego.FINICIO = nEGOCIACION.FINICIO; if (nego.FRECUENCIA == "S") { nego.DIA_SEMANA = nEGOCIACION.DIA_SEMANA; } else if (nego.FRECUENCIA == "M") { if (col["group1"] == "1") { nego.DIA_MES = nEGOCIACION.DIA_MES; } else { nego.ORDINAL_DSEMANA = nEGOCIACION.ORDINAL_DSEMANA; nego.ORDINAL_MES = nEGOCIACION.ORDINAL_MES; } } db.NEGOCIACION2.Add(nego); db.SaveChanges(); try { return(RedirectToAction("Index")); } catch (Exception e) { return(View("Error")); } } else { ViewBag.FRECUENCIA = new SelectList(FnCommon.ObtenerCmbFrecuencia(user.SPRAS_ID), "Value", "Text"); ViewBag.ORDINAL_DSEMANA = new SelectList(FnCommon.ObtenerCmbDias(user.SPRAS_ID), "Value", "Text"); ViewBag.ORDINAL_MES = new SelectList(FnCommon.ObtenerCmbOrdinales(user.SPRAS_ID), "Value", "Text"); return(View(nEGOCIACION)); } }
// GET: Cuenta/Details/5 public ActionResult Details(string soc, string pai, string tal, int?eje) { int pagina = 694; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller, 693); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".svg"; } catch { //return RedirectToAction("Pais", "Home"); } if (soc == null || pai == null || tal == null || eje == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CUENTA cUENTA = db.CUENTAs.Find(soc, pai, tal, eje); if (cUENTA == null) { return(HttpNotFound()); } return(View(cUENTA)); }
// GET: Iimpuesto/Details/5 public ActionResult Details(string id, string id2, string id3) { int pagina = 732; //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(); FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller, 731); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".svg"; } catch { //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; //Busqueda de un registro que coincida con los parametros var con = db.IIMPUESTOes.Where(x => x.LAND == id && x.MWSKZ == id2 && x.KSCHL == id3).First(); IIMPUESTO txx = new IIMPUESTO(); txx.LAND = con.LAND; txx.MWSKZ = con.MWSKZ; txx.KSCHL = con.KSCHL; txx.KBETR = con.KBETR; return(View(txx)); } }
// GET: Consoporte/Details/5 public ActionResult Details(string tsol, string tsopo) { int pagina_id = 843; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".svg"; } catch { //return RedirectToAction("Pais", "Home"); } if (tsol == null || tsopo == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CONSOPORTE cONSOPORTE = db.CONSOPORTEs.Include(c => c.TSOL.TSOLTs).Include(c => c.TSOPORTE.TSOPORTETs).Where(x => x.TSOL_ID == tsol && x.TSOPORTE_ID == tsopo).First(); if (cONSOPORTE == null) { return(HttpNotFound()); } return(View(cONSOPORTE)); }
// GET: LAContabilizacion public ActionResult Index() { FnCommon.ObtenerConfPage(db, 560, User.Identity.Name, this.ControllerContext.Controller); string spras_id = ViewBag.spras_id; return(View()); }
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 Create(string vko, string vtw, string kun, string spa) { int pagina = 643; //ID EN BASE DE DATOS using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } Contactoc conC = new Contactoc { vkorg = vko, vtweg = vtw, kunnr = kun, spart = spa }; CLIENTE cliente = db.CLIENTEs.Find(vko, vtw, spa, kun); ViewBag.Cliente = cliente.NAME1; ViewBag.NoCliente = cliente.KUNNR; return(View(conC)); } }
// 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)); }
// GET: Soporte/Details/5 public ActionResult Details(string tsoporte_id) { int pagina_id = 1315; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".svg"; } catch { //return RedirectToAction("Pais", "Home"); } if (tsoporte_id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var sopor = db.TSOPORTEs.Where(x => x.ID == tsoporte_id).FirstOrDefault(); if (tsoporte_id == null) { return(HttpNotFound()); } return(View(sopor)); }
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 public ActionResult Index(string id) { int pagina = 510; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } TempData["id"] = id; try { int idi = Int32.Parse(id); var wARNINGs = db.WARNINGs.Where(a => a.PAGINA_ID.Equals(idi)).Include(w => w.CAMPOS); return(View(wARNINGs.ToList())); } catch { var wARNINGs = db.WARNINGs.Include(w => w.CAMPOS); return(View(wARNINGs.ToList())); } }
// 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)); }
// GET: Usuarios/Create public ActionResult Create() { int pagina = 923; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller); return(View()); }
// GET: Taxeoh/Create public ActionResult Create(string kun, string vko, string vtw, string spa) { int pagina_id = 854; //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"); ViewBag.IMPUESTO_ID = new SelectList(db.IMPUESTOes.Where(x => x.ACTIVO), "MWSKZ", "MWSKZ"); ViewBag.PAIS_ID = new SelectList(db.PAIS, "LAND", "SPRAS"); ViewBag.SOCIEDAD_ID = new SelectList(db.SOCIEDADs, "BUKRS", "BUTXT"); ViewBag.CONCEPTO_ID = new SelectList(db.TX_CONCEPTO, "ID", "DESCRIPCION"); ViewBag.TNOTA_ID = new SelectList(db.TX_TNOTA, "ID", "DESCRIPCION"); ViewBag.kun = kun; ViewBag.vko = vko; ViewBag.vtw = vtw; ViewBag.spa = spa; CLIENTE cli = db.CLIENTEs.Find(vko, vtw, spa, kun); ViewBag.Cliente = cli.NAME1; ViewBag.NoCliente = cli.KUNNR; return(View()); }
// GET: Soporte/Create public ActionResult Create() { int pagina_id = 1316; //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"); } TSOPORTE soporte = new TSOPORTE(); soporte.ACTIVO = true; soporte.TSOPORTETs = new List <TSOPORTET>(); soporte.TSOPORTETs.Add(new TSOPORTET { SPRAS_ID = "ES" }); soporte.TSOPORTETs.Add(new TSOPORTET { SPRAS_ID = "EN" }); return(View(soporte)); }
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 Details(string id) { int pagina_id = 662; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MATERIAL mATERIAL = db.MATERIALs.Find(id); if (mATERIAL == null) { return(HttpNotFound()); } return(View(mATERIAL)); }
// GET: DocRelacion/Details/5 public ActionResult Details(string id, string pais, string tsol) { int pagina_id = 1212; //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 { //ViewBag.pais = "mx.svg"; //return RedirectToAction("Pais", "Home"); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var rel = db.FACTURASCONFs.Where(x => x.SOCIEDAD_ID == id && x.PAIS_ID == pais && x.TSOL == tsol).FirstOrDefault(); if (id == null) { return(HttpNotFound()); } return(View(rel)); }
// GET: Taxeoh public ActionResult Index(string vko, string vtw, string kun, string spa) { int pagina_id = 851; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".svg"; } catch { //ViewBag.pais = "mx.svg"; //return RedirectToAction("Pais", "Home"); } var tAXEOHs = db.TAXEOHs.Include(t => t.CLIENTE).Include(t => t.IMPUESTO).Include(t => t.PAI).Include(t => t.SOCIEDAD).Include(t => t.TX_CONCEPTO).Include(t => t.TX_TNOTA); ViewBag.kun = kun; ViewBag.vko = vko; ViewBag.vtw = vtw; ViewBag.spa = spa; CLIENTE cli = db.CLIENTEs.Find(vko, vtw, spa, kun); ViewBag.Cliente = cli.NAME1; ViewBag.NoCliente = cli.KUNNR; return(View(tAXEOHs.Where(x => x.VKORG == vko && x.VTWEG == vtw && x.KUNNR == kun && x.SPART == spa && x.ACTIVO == true).ToList())); }
public ActionResult Index(string vko, string vtw, string kun, string spa, string aa) { int pagina = 641; //ID EN BASE DE DATOS using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //return RedirectToAction("Pais", "Home"); } var con = db.CONTACTOCs .Where(x => x.VKORG == vko && x.VTWEG == vtw && x.KUNNR == kun && x.SPART == spa && x.ACTIVO == true).ToList(); Contactoc conCli = new Contactoc { kunnr = kun, vkorg = vko, vtweg = vtw, spart = spa, tabContacto = con }; return(View(conCli)); } }
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 Create([Bind(Include = "ID,HOST,PORT,SSL,MAIL,PASS")] Conmail conmail) { CONMAIL u = new CONMAIL(); u.ID = conmail.ID; u.HOST = conmail.HOST; u.PORT = conmail.PORT; u.SSL = conmail.SSL; u.MAIL = conmail.MAIL; u.PASS = conmail.PASS; u.ACTIVO = true; db.CONMAILs.Add(u); try { db.SaveChanges(); return(RedirectToAction("Index")); } catch { ViewBag.Error = "El usuario ya existe. Introduzca un ID de usuario diferente"; int pagina = 933; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller); Conmail cONMAIL = new Conmail(); return(View(cONMAIL)); } }
// GET: Taxeoh/Delete/5 public ActionResult Delete(string kun, string vk, string con) { int pagina_id = 855; //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"); } int ci = Convert.ToInt32(con); TAXEOH tAXEOH = db.TAXEOHs.Where(x => x.KUNNR == kun && x.VKORG == vk && x.CONCEPTO_ID == ci).FirstOrDefault(); if (tAXEOH == null) { return(HttpNotFound()); } return(View(tAXEOH)); }
// GET: CalendarioEx445/5 public ActionResult Index(short ejercicio, int periodo, string sociedad_id, string tsol_id) { int pagina_id = 533;//ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller); Calendario445ViewModel modelView = new Calendario445ViewModel(); modelView.calendarioEx445.EJERCICIO = ejercicio; modelView.calendarioEx445.PERIODO = periodo; modelView.calendarioEx445.SOCIEDAD_ID = sociedad_id; modelView.calendarioEx445.TSOL_ID = tsol_id; modelView.calendariosEx445List = ObtenerExcepciones(ejercicio, periodo, sociedad_id, tsol_id); modelView.calendario445 = ObtenerCalendario445(ejercicio, periodo, sociedad_id, tsol_id); CargarSelectList(ref modelView, new string[] { CMB_SOCIEDADES + "," + sociedad_id, CMB_PERIODOS + "," + periodo, CMB_TIPOSSOLICITUD + "," + tsol_id, CMB_USUARIOS }); return(View(modelView)); }
public ActionResult DeleteConfirmed(TAXEOH tx) { try { TAXEOH tAXEOH = db.TAXEOHs.Where(x => x.KUNNR == tx.KUNNR && x.VKORG == tx.VKORG && x.CONCEPTO_ID == tx.CONCEPTO_ID && x.VTWEG == tx.VTWEG).FirstOrDefault(); tAXEOH.ACTIVO = false; db.Entry(tAXEOH).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", new { vko = tAXEOH.VKORG, vtw = tAXEOH.VTWEG, kun = tAXEOH.KUNNR, spa = tAXEOH.SPART })); } catch (Exception e) { int pagina_id = 855; //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"); } return(View(tx)); } }
// GET: Iimpuesto/Delete/5 public ActionResult Delete(string id, string id2, string id3) { int pagina = 201; //ID EN BASE DE DATOS using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; //string u = "admin"; var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault(); FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".svg"; } catch { //ViewBag.pais = "mx.svg"; //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } IIMPUESTO txx = db.IIMPUESTOes.Where(x => x.LAND == id && x.MWSKZ == id2 && x.KSCHL == id3).FirstOrDefault(); return(View(txx)); }
// GET: Taxeoh/Details/5 public ActionResult Details(string kun, string vk, string con, string sc) { int pagina_id = 852; //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 { //return RedirectToAction("Pais", "Home"); } var coni = Convert.ToInt32(con); TAXEOH tAXEOH = db.TAXEOHs.Where(x => x.KUNNR == kun && x.VKORG == vk && x.CONCEPTO_ID == coni && x.SOCIEDAD_ID == sc).FirstOrDefault(); if (tAXEOH == null) { return(HttpNotFound()); } //ViewBag.kun = kun; //ViewBag.vko = vko; //ViewBag.vtw = vtw; //ViewBag.spa = spa; CLIENTE cli = db.CLIENTEs.Find(vk, tAXEOH.VTWEG, tAXEOH.SPART, kun); ViewBag.Cliente = cli.NAME1; ViewBag.NoCliente = cli.KUNNR; return(View(tAXEOH)); }
// GET: Iimpuesto/Create public ActionResult Create() { int pagina = 734; //ID EN BASE DE DATOS using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; //string u = "admin"; var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault(); FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller, 731); 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.MWSKZ = new SelectList(db.IMPUESTOes, "MWSKZ", "MWSKZ"); ViewBag.LAND = new SelectList(db.PAIS, "LAND", "SPRAS"); return(View()); }
// GET: Negs/Edit/5 public ActionResult Edit(int id) { int pagina = 902; //ID EN BASE DE DATOS string u = User.Identity.Name; USUARIO user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault(); FnCommon.ObtenerConfPage(db, pagina, u, this.ControllerContext.Controller, 901); ViewBag.mensajes = JsonConvert.SerializeObject(db.MENSAJES.Where(a => (a.PAGINA_ID.Equals(901) || a.PAGINA_ID.Equals(0)) && a.SPRAS.Equals(user.SPRAS_ID)).ToList(), Formatting.Indented); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".svg"; } catch { } Session["spras"] = user.SPRAS_ID; ViewBag.lan = user.SPRAS_ID; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } NEGOCIACION2 nEGOCIACION = db.NEGOCIACION2.Where(x => x.ID == id).FirstOrDefault(); if (nEGOCIACION == null) { return(HttpNotFound()); } ViewBag.FRECUENCIA = new SelectList(FnCommon.ObtenerCmbFrecuencia(user.SPRAS_ID), "Value", "Text", nEGOCIACION.FRECUENCIA); ViewBag.ORDINAL_DSEMANA = new SelectList(FnCommon.ObtenerCmbDias(user.SPRAS_ID), "Value", "Text", nEGOCIACION.ORDINAL_DSEMANA); ViewBag.ORDINAL_MES = new SelectList(FnCommon.ObtenerCmbOrdinales(user.SPRAS_ID), "Value", "Text", nEGOCIACION.ORDINAL_MES); return(View(nEGOCIACION)); }