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