public JsonResult contactos(string Prefix, string vkorg, string vtweg, string kunnr) { if (Prefix == null) { Prefix = ""; } TAT001Entities db = new TAT001Entities(); Cadena cad = new Cadena(); kunnr = cad.completaCliente(kunnr); var c = (from m in db.CONTACTOCs where m.NOMBRE.Contains(Prefix) && m.ACTIVO == true && m.VKORG == vkorg && m.VTWEG == vtweg && /*&& m.SPART == spart*/ m.KUNNR == kunnr select new { m.NOMBRE, m.EMAIL }).ToList(); if (c.Count == 0) { var c2 = (from m in db.CONTACTOCs where m.EMAIL.Contains(Prefix) && m.ACTIVO == true && m.VKORG == vkorg && m.VTWEG == vtweg && /*&& m.SPART == spart*/ m.KUNNR == kunnr select new { m.NOMBRE, m.EMAIL }).ToList(); c.AddRange(c2); } JsonResult cc = Json(c, JsonRequestBehavior.AllowGet); return(cc); }
// GET: Workflows public ActionResult Index() { int pagina = 103; //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(); 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; } return(View(db.WORKFHs.Where(x => x.ESTATUS == true).ToList())); }
// GET: Leyenda public ActionResult Index() { int pagina = 751; //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(); 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 + ".svg"; } catch { //ViewBag.pais = "mx.svg"; //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; ViewBag.lan = user.SPRAS_ID; } var lEYENDAs = db.LEYENDAs.Include(l => l.PAI).ToList(); //Que solo retorno los activos return(View(lEYENDAs.Where(a => a.ACTIVO == true).ToList())); }
// GET: Negs public ActionResult Index() { int pagina = 901; //ID EN BASE DE DATOS USUARIO user = null; using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; //string u = "admin"; user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault(); ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList(); ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList(); ViewBag.usuario = user; ViewBag.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 + ".svg"; } catch { //ViewBag.pais = "mx.svg"; //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; ViewBag.lan = user.SPRAS_ID; } return(View(db.NEGOCIACIONs.Where(a => a.ACTIVO == true).ToList())); }
public ActionResult Index() { int pagina = 301; //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(); 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; } Models.PresupuestoModels carga = new Models.PresupuestoModels(); ViewBag.ultMod = carga.consultarUCarga(); ViewBag.anio = "20" + carga.consultaAnio(); return(View(carga.consultSociedad(""))); }
// GET: TALLs/Create public ActionResult Create() { int pagina = 884; //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(); 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.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 + ".svg"; } catch { //ViewBag.pais = "mx.svg"; //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; ViewBag.lan = user.SPRAS_ID; } ViewBag.GALL_ID = new SelectList(db.GALLs, "ID", "DESCRIPCION"); return(View()); }
// GET: Impuestos/Details/5 public ActionResult Details(string id) { int pagina = 742; //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(); 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.MIEMBROS.FirstOrDefault().ROL.NOMBRE; 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(741) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList(); try { string p = Session["pais"].ToString(); ViewBag.pais = p + ".svg"; } catch { //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; var con = db.IMPUESTOes .Where(x => x.MWSKZ == id).First(); IMPUESTO co = new IMPUESTO(); co.MWSKZ = con.MWSKZ; co.ACTIVO = con.ACTIVO; return(View(co)); } }
public decimal getUkursUSD(string waers, string waersusd, out string errorString) { decimal ukurs = 0; errorString = string.Empty; using (TAT001Entities db = new TAT001Entities()) { try { var date = DateTime.Now.Date; var tcambio = db.TCAMBIOs.Where(t => t.FCURR.Equals(waers) && t.TCURR.Equals(waersusd) && t.GDATU.Equals(date)).FirstOrDefault(); if (tcambio == null) { var max = db.TCAMBIOs.Where(t => t.FCURR.Equals(waers) && t.TCURR.Equals(waersusd)).Max(a => a.GDATU); tcambio = db.TCAMBIOs.Where(t => t.FCURR.Equals(waers) && t.TCURR.Equals(waersusd) && t.GDATU.Equals(max)).FirstOrDefault(); } ukurs = Convert.ToDecimal(tcambio.UKURS); } catch (Exception e) { errorString = "detail: conversion " + waers + " to " + waersusd + " in date " + DateTime.Now.Date; return(0); } } return(ukurs); }
// GET: CartaD/Details/5 public ActionResult Details(string ruta) { int pagina = 230; //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(); 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.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 { //return RedirectToAction("Pais", "Home"); } } ViewBag.url = ruta; return(View()); }
public DateTime getPrimerDia(int ejercicio, int periodo) { TAT001Entities db = new TAT001Entities(); DateTime dia = new DateTime(); if (periodo == 1) { ejercicio--; periodo = 13; } List <PERIODO445> pp = db.PERIODO445.Where(a => a.EJERCICIO == ejercicio).ToList(); PERIODO445 p = pp.Where(a => a.MES_NATURAL == periodo - 1).FirstOrDefault(); if (p == null) { dia = new DateTime(ejercicio, 1, 1); } else { dia = new DateTime(ejercicio, p.PERIODO, p.DIA_NATURAL); dia = dia.AddDays(1); } return(dia); }
public JsonResult Det_Aprob2(string bukrs, string puesto, string spras) { TAT001Entities db = new TAT001Entities(); int p = Int16.Parse(puesto); DET_APROBH dh = db.DET_APROBH.Where(a => a.SOCIEDAD_ID.Equals(bukrs) & a.PUESTOC_ID == p).OrderByDescending(a => a.VERSION).FirstOrDefault(); if (dh != null) { var c = (from N in db.DET_APROBP join St in db.PUESTOTs on N.PUESTOA_ID equals St.PUESTO_ID where N.SOCIEDAD_ID.Equals(bukrs) & N.PUESTOC_ID.Equals(p) & St.SPRAS_ID.Equals(spras) & N.VERSION.Equals(dh.VERSION) //where N.BUKRS.Equals(bukrs) select new { N.POS, N.PUESTOA_ID.Value, St.TXT50, N.MONTO, PRESUPUESTO = (bool)N.PRESUPUESTO.Value }).ToList(); TAX_LAND tl = db.TAX_LAND.Where(a => a.SOCIEDAD_ID.Equals(bukrs) & a.ACTIVO == true).FirstOrDefault(); if (tl != null) { var col = (from St in db.PUESTOTs where St.PUESTO_ID == 9 & St.SPRAS_ID.Equals(spras) //where N.BUKRS.Equals(bukrs) select new { POS = 98, Value = St.PUESTO_ID, St.TXT50, MONTO = (decimal?)decimal.Parse("-1"), PRESUPUESTO = false }); c.AddRange(col); } var ca = c.OrderBy(a => a.POS); JsonResult cc = Json(ca, JsonRequestBehavior.AllowGet); return(cc); } else { return(null); } }
//COSULTA DE AJAX PARA EL TIPO DE MONEDA public JsonResult moneda(string Prefix) { string sociedadUser = Session["sociedadUser"].ToString(); if (Prefix == null) { Prefix = ""; } TAT001Entities db = new TAT001Entities(); var c = (from m in db.MONEDAs join so in db.SOCIEDADs on m.WAERS equals so.WAERS where (so.BUKRS == sociedadUser && m.KTEXT.Contains(Prefix) && m.ACTIVO == true) || (m.WAERS == "USD" && m.ACTIVO == true) group m by m.WAERS into g select new { WAERS = g.Key }).ToList(); if (c.Count <= 1) { c = (from m in db.MONEDAs join so in db.SOCIEDADs on m.WAERS equals so.WAERS where (so.BUKRS == sociedadUser && m.WAERS.Contains(Prefix) && m.ACTIVO == true) || (m.WAERS == "USD" && m.ACTIVO == true) group m by m.WAERS into g select new { WAERS = g.Key }).ToList(); //c.AddRange(c2); } JsonResult cc = Json(c, JsonRequestBehavior.AllowGet); return(cc); }
public int getPeriodoF(DateTime fecha) { TAT001Entities db = new TAT001Entities(); int periodo = 0; List <PERIODO445> pp = db.PERIODO445.Where(a => a.EJERCICIO == fecha.Year).ToList(); //PERIODO445 p = pp.Where(a => a.MES_NATURAL == fecha.Month).FirstOrDefault(); PERIODO445 p = pp.Where(a => a.MES_NATURAL == fecha.Month && a.DIA_NATURAL == fecha.Day).OrderBy(a => a.DIA_NATURAL).FirstOrDefault(); if (p == null) { p = pp.Where(a => a.MES_NATURAL == fecha.Month).OrderBy(a => a.DIA_NATURAL).FirstOrDefault(); } else { if (fecha.Day > p.DIA_NATURAL) { periodo = p.PERIODO + 1; } else { periodo = p.PERIODO; } } return(periodo); }
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 Create2(string vko, string vtw, string kun, string spa, Contactoc conC) { using (TAT001Entities db = new TAT001Entities()) { if (conC.defecto) { var conAct = db.CONTACTOCs .Where(x => x.VKORG == vko && x.VTWEG == vtw && x.KUNNR == kun && x.SPART == spa && x.DEFECTO == true).ToList(); foreach (var item in conAct) { item.DEFECTO = false; } db.SaveChanges(); var con = db.CONTACTOCs .Add(new CONTACTOC { NOMBRE = conC.nombre, PHONE = conC.telefono, EMAIL = conC.correo, VKORG = vko, VTWEG = vtw, KUNNR = kun, SPART = spa, ACTIVO = true, DEFECTO = conC.defecto, CARTA = conC.carta }); db.SaveChanges(); } else { var con = db.CONTACTOCs .Add(new CONTACTOC { NOMBRE = conC.nombre, PHONE = conC.telefono, EMAIL = conC.correo, VKORG = vko, VTWEG = vtw, KUNNR = kun, SPART = spa, ACTIVO = true, DEFECTO = conC.defecto, CARTA = conC.carta }); db.SaveChanges(); } return(RedirectToAction("Index", new { vko = vko, vtw = vtw, kun = kun, spa = spa })); } }
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)); } }
public string getHtml(decimal num_doc, string spras, List <ESTATU> ee) { TAT001Entities db = new TAT001Entities(); DOCUMENTO d = db.DOCUMENTOes.Find(num_doc); string estatus = getEstatus(d); string ret = ""; foreach (ESTATU e in ee) { foreach (ESTATUSR reg in e.ESTATUSRs) { if (System.Text.RegularExpressions.Regex.IsMatch(estatus, reg.REGEX)) { ESTATUST t = e.ESTATUSTs.FirstOrDefault(x => x.SPRAS_ID == spras); if (t != null) { ret = "<span class='" + e.CLASS + "' data-badge-caption=''>" + t.TXT050 + "</span>"; } else { ret = "<span class='" + e.CLASS + "' data-badge-caption=''>" + e.DESCRIPCION + "</span>"; } if (ret != "") { return(ret); } } } } return(ret); }
// GET: NOTICIAs/Create public ActionResult Create() { int pagina = 912; //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(); 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 + ".svg"; } catch { //ViewBag.pais = "mx.svg"; //return RedirectToAction("Pais", "Home"); } Session["spras"] = user.SPRAS_ID; ViewBag.lan = user.SPRAS_ID; } ViewBag.imgnoticia = db.NOTICIAs.Where(x => x.FECHAI <= DateTime.Now && x.FECHAF >= DateTime.Now && x.ACTIVO == true).Select(x => x.PATH).FirstOrDefault(); ViewBag.USUARIOC_ID = new SelectList(db.USUARIOs, "ID", "PASS"); return(View()); }
public string getText(decimal num_doc, string spras) { string ret = ""; TAT001Entities db = new TAT001Entities(); DOCUMENTO doc = db.DOCUMENTOes.Find(num_doc); string estatus = getEstatus(doc); List <ESTATU> ee = db.ESTATUS.Where(x => x.ACTIVO).ToList(); foreach (ESTATU e in ee) { foreach (ESTATUSR reg in e.ESTATUSRs) { if (System.Text.RegularExpressions.Regex.IsMatch(estatus, reg.REGEX)) { ESTATUST t = e.ESTATUSTs.FirstOrDefault(x => x.SPRAS_ID == spras); if (t != null) { ret = t.TXT050; } else { ret = e.DESCRIPCION; } return(ret); } } } return(ret); }
// 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)); }
public JsonResult selectImpuesto(string bukrs, string pais, string vkorg, string vtweg, string spart, string kunnr, string concepto, string spras) { TAT001Entities db = new TAT001Entities(); int co = int.Parse(concepto); var c = (from T in db.TAXEOHs where T.SOCIEDAD_ID == bukrs & T.PAIS_ID == pais & T.VKORG == vkorg & T.VTWEG == vtweg & T.SPART == spart & T.KUNNR == kunnr & T.CONCEPTO_ID == co select new { T.IMPUESTO_ID, T.PORC, TXT50 = "IVA" }).ToList(); var c2 = (from T in db.TAXEOPs join R in db.TRETENCIONTs on T.TRETENCION_ID equals R.TRETENCION_ID where T.SOCIEDAD_ID == bukrs & T.PAIS_ID == pais & T.VKORG == vkorg & T.VTWEG == vtweg & T.SPART == spart & T.KUNNR == kunnr & T.CONCEPTO_ID == co & R.SPRAS_ID == spras select new { IMPUESTO_ID = T.RETENCION_ID.ToString(), T.PORC, R.TXT50 }).ToList(); c.AddRange(c2); JsonResult cc = Json(c, JsonRequestBehavior.AllowGet); return(cc); }
// 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: CartaD public ActionResult Index(string ruta, decimal ids) { int pagina = 230; //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(); 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.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 { //return RedirectToAction("Pais", "Home"); } } ViewBag.url = Request.Url.OriginalString.Replace(Request.Url.PathAndQuery, "") + HostingEnvironment.ApplicationVirtualPath + "/" + ruta; ViewBag.miNum = ids; return(View()); }
// 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()); }
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 (TAT001Entities db = new TAT001Entities()) { 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 FLUJO determinaAgenteI(DOCUMENTO d, string user, string delega, int pos, DET_AGENTEC dah) { if (delega != null) { user = delega; } bool fin = false; TAT001Entities db = new TAT001Entities(); DET_AGENTEC dap = new DET_AGENTEC(); USUARIO u = db.USUARIOs.Find(d.USUARIOC_ID); if (pos.Equals(0)) { //dap = db.DET_AGENTEP.Where(a => a.SOCIEDAD_ID.Equals(dah.SOCIEDAD_ID) & a.PUESTOC_ID == dah.PUESTOC_ID & // a.VERSION == dah.VERSION & a.AGROUP_ID == dah.AGROUP_ID & a.POS == 1).FirstOrDefault(); dap = db.DET_AGENTEC.Where(a => a.USUARIOC_ID.Equals(delega) & a.PAIS_ID == dah.PAIS_ID & a.VKORG.Equals(dah.VKORG) & a.VTWEG.Equals(dah.VTWEG) & a.SPART.Equals(dah.SPART) & a.KUNNR.Equals(dah.KUNNR) & a.VERSION == dah.VERSION & a.POS == 1).FirstOrDefault(); } string agente = ""; FLUJO f = new FLUJO(); f.DETPOS = 0; if (!fin) { agente = dap.USUARIOA_ID; f.DETPOS = dap.POS; } f.USUARIOA_ID = agente; return(f); }
// GET: TSOL public ActionResult Index() { int pagina = 791; //ID EN BASE DE DATOS USUARIO user = null; using (TAT001Entities db = new TAT001Entities()) { string u = User.Identity.Name; //string u = "admin"; user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault(); ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList(); ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList(); ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;; ViewBag.rol = user.PUESTO.PUESTOTs.Where(a => a.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50; ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50; ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList(); ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(pagina) || 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; } var tSOLs = db.TSOLs.Include(t => t.RANGO).Include(t => t.TSOL2).Include(x => x.TSOLTs).ToList(); return(View(tSOLs)); }
public int getPeriodoF(DateTime fecha) { TAT001Entities db = new TAT001Entities(); int periodo = 0; List <PERIODO445> pp = db.PERIODO445.Where(a => a.EJERCICIO == fecha.Year || (a.EJERCICIO == (fecha.Year + 1) && a.SUMA > 0)).ToList(); PERIODO445 p = pp.Where(a => a.MES_NATURAL == fecha.Month && a.DIA_NATURAL == fecha.Day).OrderBy(a => a.DIA_NATURAL).FirstOrDefault(); if (p == null) { return(0); p = pp.Where(a => a.MES_NATURAL == fecha.Month).OrderBy(a => a.DIA_NATURAL).FirstOrDefault(); } ////else ////{ if (fecha.Day > p.DIA_NATURAL) { periodo = p.PERIODO + 1; } else { periodo = p.PERIODO; } ////} if (periodo > 12) { periodo = periodo % 12; } return(periodo); }
public PRESUPUESTO_MOD getPresupuesto(string kunnr)//RSG 07.06.2018--------------------------------------------- { TAT001Entities db = new TAT001Entities(); PRESUPUESTO_MOD pm = new PRESUPUESTO_MOD(); try { if (kunnr == null) { kunnr = ""; } //Obtener presupuesto Calendario445 c445 = new Calendario445(); string mes = c445.getPeriodo(DateTime.Now.Date) + ""; var presupuesto = db.CSP_PRESU_CLIENT(cLIENTE: kunnr, pERIODO: mes).Select(p => new { DESC = p.DESCRIPCION.ToString(), VAL = p.VALOR.ToString() }).ToList(); string clien = db.CLIENTEs.Where(x => x.KUNNR == kunnr).Select(x => x.BANNERG).First(); var clien2 = db.CLIENTEs.Where(x => x.KUNNR == kunnr).FirstOrDefault(); string desCanal = db.CANALs.Where(x => x.CANAL1 == clien2.CANAL).FirstOrDefault().CDESCRIPCION; if (presupuesto != null) { pm.CANAL = desCanal; pm.CLIENTE = clien2.NAME1; if (String.IsNullOrEmpty(clien)) { //pm.P_CANAL = presupuesto[0].VAL; //pm.P_BANNER = presupuesto[1].VAL; //pm.PC_C = (float.Parse(presupuesto[4].VAL) + float.Parse(presupuesto[5].VAL) + float.Parse(presupuesto[6].VAL)).ToString(); //pm.PC_A = presupuesto[8].VAL; //pm.PC_P = presupuesto[9].VAL; //pm.PC_T = presupuesto[10].VAL; //pm.CONSU = (float.Parse(presupuesto[1].VAL) - float.Parse(presupuesto[10].VAL)).ToString(); pm.P_CANAL = decimal.Parse(presupuesto[0].VAL); pm.P_BANNER = decimal.Parse(presupuesto[1].VAL); pm.PC_C = (decimal.Parse(presupuesto[4].VAL) + decimal.Parse(presupuesto[5].VAL) + decimal.Parse(presupuesto[6].VAL)); pm.PC_A = decimal.Parse(presupuesto[8].VAL); pm.PC_P = decimal.Parse(presupuesto[9].VAL); pm.PC_T = pm.PC_C + pm.PC_A + pm.PC_P; pm.CONSU = (decimal.Parse(presupuesto[1].VAL) - pm.PC_T); } else { pm.P_CANAL = decimal.Parse(presupuesto[0].VAL); pm.P_BANNER = decimal.Parse(presupuesto[0].VAL); pm.PC_C = (decimal.Parse(presupuesto[4].VAL) + decimal.Parse(presupuesto[5].VAL) + decimal.Parse(presupuesto[6].VAL)); pm.PC_A = decimal.Parse(presupuesto[8].VAL); pm.PC_P = decimal.Parse(presupuesto[9].VAL); pm.PC_T = pm.PC_C + pm.PC_A + pm.PC_P; pm.CONSU = (decimal.Parse(presupuesto[0].VAL) - pm.PC_T); } } } catch { } db.Dispose(); return(pm); }
public JsonResult materiales(string Prefix, string vkorg, string vtweg, string spras) { if (Prefix == null) { Prefix = ""; } TAT001Entities db = new TAT001Entities(); var ids = (from m in db.MATERIALs join g in db.MATERIALVKEs on m.ID equals g.MATERIAL_ID where (m.ID.Contains(Prefix) | m.MAKTG.Contains(Prefix) | m.MAKTX.Contains(Prefix)) && m.ACTIVO == true && m.MATERIALGP_ID != null && g.VKORG == vkorg && g.VTWEG == vtweg select new { m.ID }).ToList(); if (ids.Count == 0) { var ids2 = (from m in db.MATERIALTs join g in db.MATERIALVKEs on m.MATERIAL_ID equals g.MATERIAL_ID where (m.MAKTX.Contains(Prefix) | m.MAKTG.Contains(Prefix)) && m.MATERIAL.ACTIVO == true && m.MATERIAL.MATERIALGP_ID != null && g.VKORG == vkorg && g.VTWEG == vtweg && m.SPRAS == spras select new { ID = m.MATERIAL_ID }).ToList(); ids.AddRange(ids2); } List <MATERIAL> mats = (from m in db.MATERIALs.Where(a => a.ACTIVO == true).ToList() join i in ids on m.ID equals i.ID select m).ToList(); List <MATERIALT> matts = (from m in db.MATERIALTs.Where(a => a.SPRAS == spras).ToList() join i in ids on m.MATERIAL_ID equals i.ID where m.SPRAS == spras select m).ToList(); foreach (MATERIAL m in mats) { foreach (MATERIALT mt in matts.Where(x => x.MATERIAL_ID == m.ID)) { m.MAKTX = mt.MAKTX; } } var ct = (from m in mats select new { m.ID, m.MAKTX }).ToList(); JsonResult cc = Json(ct, JsonRequestBehavior.AllowGet); return(cc); }