// 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 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: 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: Iimpuesto/Create public ActionResult Create() { int pagina = 734; //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(); 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()); }
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)); }
// 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: Iimpuesto/Delete/5 public ActionResult Delete(string id, string id2, string id3) { int pagina = 201; //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(); 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)); }
bool ValidarCondExistente(WARNINGP warningP, List <WARNING_COND> warningConds) { int pagina_id = 540; bool existeCondParaTabCampo = false; List <WARNING_COND> warningPs = db.WARNINGPs .Where(x => x.CAMPO_ID == warningP.CAMPO_ID && x.TAB_ID == warningP.TAB_ID && x.ID != warningP.ID && ((x.SOCIEDAD_ID == null || x.SOCIEDAD_ID == warningP.SOCIEDAD_ID) && (x.TSOL_ID == null || x.TSOL_ID == warningP.TSOL_ID))) .Join(db.WARNING_COND, w => w.ID, wc => wc.WARNING_ID, (w, wc) => wc) .ToList(); warningPs.ForEach(x => { if (warningConds.Any(y => y.VALOR_COMP == x.VALOR_COMP && y.CONDICION_ID == x.CONDICION_ID)) { existeCondParaTabCampo = true; } }); if (warningConds.Count == 2 && warningConds[0].VALOR_COMP == warningConds[1].VALOR_COMP && warningConds[0].CONDICION_ID == warningConds[1].CONDICION_ID) { existeCondParaTabCampo = true; } if (existeCondParaTabCampo) { ViewBag.mnjError = FnCommon.ObtenerTextoMnj(db, pagina_id, "lbl_mnjExisteCondAlerta", User.Identity.Name); return(false); } return(true); }
// GET: Alertas/Create public ActionResult Create() { int pagina_id = 541;//ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller); AlertaViewModel modelView = new AlertaViewModel { //Mensajes alertaMensajes = new List <WARNINGPT> { new WARNINGPT { SPRAS_ID = "ES" }, new WARNINGPT { SPRAS_ID = "EN" } }, //Condiciones alertaCondiciones = new List <WARNING_COND> { new WARNING_COND { POS = 1 }, new WARNING_COND { POS = 2, ORAND = ")" } } }; //Combos CargarSelectList(ref modelView, new string[] { CMB_TIPOS, CMB_SOCIEDADES, CMBTREE_TIPOSSOLICITUD, CMB_TABS, CMB_CONDCAMPOS }, null, true); return(View(modelView)); }
// 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/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)); }
// GET: ccat/Edit/5 public ActionResult Edit(string id) { int pagina_id = 873; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller, 871); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ////var per = Convert.ToInt32(pr); CONFDIST_CAT cONFDIST_CAT = db.CONFDIST_CAT.Where(i => i.SOCIEDAD_ID == id).FirstOrDefault(); if (cONFDIST_CAT == null) { return(HttpNotFound()); } 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, cONFDIST_CAT.PORC_AD); return(View(cONFDIST_CAT)); }
public ActionResult Create([Bind(Include = "BUKRS,ID_USER,TIPOPRE")] SociedadesUsuario sociedadesUsuario) { DET_TIPOPRESUPUESTO u = new DET_TIPOPRESUPUESTO(); u.BUKRS = sociedadesUsuario.BUKRS; u.ID_USER = sociedadesUsuario.ID_USER; u.TIPOPRE = sociedadesUsuario.TIPOPRE; db.DET_TIPOPRESUPUESTO.Add(u); try { db.SaveChanges(); return(RedirectToAction("Index")); } catch { ViewBag.Error = "El usuario ya existe. Introduzca un ID de usuario diferente"; int pagina = 723; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller); SociedadesUsuario obj = new SociedadesUsuario(); return(View(obj)); } }
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)); } }
// GET: DesviacionesTS/Details/5 public ActionResult Details(int id) { int pagina = 1311; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller, 1312); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".png"; } catch { //ViewBag.pais = "mx.png"; //return RedirectToAction("Pais", "Home"); } TS_CAMPO tS_CAMPO = db.TS_CAMPO.Include(x => x.TS_FORM).First(x => x.ID == id); if (!tS_CAMPO.TS_FORMT.Any(x => x.SPRAS_ID == "ES")) { tS_CAMPO.TS_FORMT.Add(new TS_FORMT { SPRAS_ID = "ES", TSFORM_ID = tS_CAMPO.ID, SPRA = db.SPRAS.Find("ES") }); } if (!tS_CAMPO.TS_FORMT.Any(x => x.SPRAS_ID == "EN")) { tS_CAMPO.TS_FORMT.Add(new TS_FORMT { SPRAS_ID = "EN", TSFORM_ID = tS_CAMPO.ID, SPRA = db.SPRAS.Find("EN") }); } return(View(tS_CAMPO)); }
bool ValidarPeriodoExistente(CALENDARIO_AC calendarioAc) { int pagina_id = 530; string spras_id = FnCommon.ObtenerSprasId(db, User.Identity.Name); int noExiste = 0; sociedadesDao.ListaSociedades(TATConstantes.ACCION_LISTA_SOCIEDADES).ForEach(x => { tiposSolicitudesDao.ListaTiposSolicitudes(spras_id, null).ForEach(z => { calendarioAc.SOCIEDAD_ID = x.BUKRS; calendarioAc.TSOL_ID = z.TSOL_ID; if (!db.CALENDARIO_AC.Any(y => y.EJERCICIO == calendarioAc.EJERCICIO && y.PERIODO == calendarioAc.PERIODO && y.SOCIEDAD_ID == calendarioAc.SOCIEDAD_ID && y.TSOL_ID == calendarioAc.TSOL_ID)) { noExiste++; } }); }); if (noExiste == 0) { ViewBag.mnjError = FnCommon.ObtenerTextoMnj(db, pagina_id, "lbl_mnjExistePeriodo", User.Identity.Name); return(false); } return(true); }
// GET: Iimpuesto/Details/5 public ActionResult Details(string id, string id2, string id3) { int pagina = 732; //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(); 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)); } }
public ActionResult CreateFA(string id, int pid, int v) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ObtenerConfPage(923, 925); List <DET_APROBP> flujosva = db.DET_APROBP.Where(t => t.SOCIEDAD_ID == id && t.PUESTOC_ID == pid && t.VERSION == v).ToList(); var lan = ViewBag.usuario.SPRAS_ID; var puestos = db.PUESTOes.Where(t => t.ID == pid).ToList(); var sl_puestos = puestos.Select(x => new { x.ID, Puesto = x.PUESTOTs.Count > 0 ? x.PUESTOTs.Where(t => t.SPRAS_ID == lan).FirstOrDefault().TXT50 : "" }).ToList(); ViewBag.PUESTOC_ID = new SelectList(sl_puestos, "ID", "Puesto"); ViewBag.NivelesA = new SelectList(FnCommon.ObtenerCmbNivelesA(), "Value", "Text"); ViewBag.NivelesP = new SelectList(FnCommon.ObtenerCmbNivel(), "Value", "Text"); ViewBag.NivelesM = new SelectList(FnCommon.ObtenerCmbNivel(), "Value", "Text"); DET_APROBH dET_APROBP = new DET_APROBH { SOCIEDAD_ID = id, ACTIVO = true, VERSION = v + 1, PUESTOC_ID = pid }; var sociedad = db.SOCIEDADs.Find(id); ViewBag.Miles = db.PAIS.Where(t => t.LAND == sociedad.LAND).SingleOrDefault().MILES; ViewBag.PD = db.PAIS.Where(t => t.LAND == sociedad.LAND).SingleOrDefault().DECIMAL; ViewBag.FlujosActuales = flujosva; return(View(dET_APROBP)); }
// 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())); }
void CargarSelectList(ref Calendario445ViewModel modelView, string[] combos) { string spras_id = FnCommon.ObtenerSprasId(db, User.Identity.Name); for (int i = 0; i < combos.Length; i++) { string[] combosSplit = combos[i].Split(','); string combo = combosSplit[0]; string id = combosSplit.Length > 1 ? combosSplit[1] : null; switch (combo) { case CMB_SOCIEDADES: modelView.sociedades = sociedadesDao.ComboSociedades(TATConstantes.ACCION_LISTA_SOCIEDADES, id); break; case CMB_PERIODOS: int?idAux = (id == null ? null : (int?)int.Parse(id)); modelView.periodos = periodosDao.ComboPeriodos(spras_id, idAux); break; case CMB_USUARIOS: modelView.usuarios = usuariosDao.ComboUsuarios(TATConstantes.ACCION_LISTA_USUARIO, id); break; case CMB_TIPOSSOLICITUD: modelView.cmbTiposSolicitud = tiposSolicitudesDao.ComboTiposSolicitudes(spras_id, id); break; default: break; } } }
// 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)); }
// 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)); }
public ActionResult Create([Bind(Include = "REGION1,SOCIEDAD")] REGION rEGION) { int pagina_id = 951;//ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina_id, User.Identity.Name, this.ControllerContext.Controller, 950); string spras_id = ViewBag.spras_id; ViewBag.SOCIEDAD = new SelectList(db.SOCIEDADs.Where(t => t.ACTIVO).ToList(), "BUKRS", "BUKRS"); if (ModelState.IsValid) { if (!existeRegion(rEGION.REGION1)) { rEGION.REGION1 = rEGION.REGION1.ToUpper(); db.REGIONs.Add(rEGION); db.SaveChanges(); return(RedirectToAction("Index")); } else { TempData["MensajeExiste"] = "Ya existe una región con el mismo ID"; } } return(View(rEGION)); }
// GET: TSOL public ActionResult Index() { int pagina = 790; //ID EN BASE DE DATOS FnCommon.ObtenerConfPage(db, pagina, User.Identity.Name, this.ControllerContext.Controller); string u = User.Identity.Name; USUARIO user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault(); 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; var tSOLs = db.TSOLs.Include(t => t.RANGO).Include(t => t.TSOL2).Include(x => x.TSOLTs).ToList(); return(View(tSOLs)); }
// 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)); }