// GET: Leyenda
public ActionResult Index()
{
int pagina = 751; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
string u = User.Identity.Name;
//string u = "admin";
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList();
ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList();
ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;;
ViewBag.rol = user.PUESTO.PUESTOTs.Where(a => a.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList();
ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(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()));
}
public ActionResult Edit([Bind(Include = "SOCIEDAD_ID,CAMPO,PORC_AD,PERIODOS,ACTIVO")] CONFDIST_CAT cONFDIST_CAT, string bools)
{
try
{
////CONFDIST_CAT cf = db.CONFDIST_CAT.Where(i => i.SOCIEDAD_ID == cONFDIST_CAT.SOCIEDAD_ID && i.CAMPO == cONFDIST_CAT.CAMPO && i.PERIODOS == cONFDIST_CAT.PERIODOS).FirstOrDefault();
CONFDIST_CAT cf = db.CONFDIST_CAT.Where(i => i.SOCIEDAD_ID == cONFDIST_CAT.SOCIEDAD_ID).FirstOrDefault();
cf.PORC_AD = false;
cf.ACTIVO = true;
cf.CAMPO = cONFDIST_CAT.CAMPO;
cf.PERIODOS = cONFDIST_CAT.PERIODOS;
if (cf.PERIODOS == null)
{
cf.PERIODOS = 1;
}
if (ModelState.IsValid)
{
db.Entry(cf).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details", new { id = cf.SOCIEDAD_ID }));
}
}
catch (Exception e)
{
ViewBag.error = e.ToString();
}
int pagina = 873; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
string u = User.Identity.Name;
//string u = "admin";
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList();
ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList();
ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;;
ViewBag.rol = user.PUESTO.PUESTOTs.Where(a => a.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList();
ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(871) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList();
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".svg";
}
catch
{
//ViewBag.pais = "mx.svg";
//return RedirectToAction("Pais", "Home");
}
Session["spras"] = user.SPRAS_ID;
}
List <bool> lstb = new List <bool>();
lstb.Add(true);
lstb.Add(false);
ViewBag.CAMPO = new SelectList(db.CAMPOZKE24, "CAMPO", "CAMPO", cONFDIST_CAT.CAMPO);
ViewBag.SOCIEDAD_ID = new SelectList(db.SOCIEDADs, "BUKRS", "BUKRS", cONFDIST_CAT.SOCIEDAD_ID);
ViewBag.bools = new SelectList(lstb);
return(View(cONFDIST_CAT));
}
// GET: Det_Aprobs/Create
public ActionResult Create()
{
int pagina = 103; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
string u = User.Identity.Name;
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList();
ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList();
ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;;
ViewBag.rol = user.PUESTO.PUESTOTs.Where(a => a.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList();
ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList();
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".png";
}
catch
{
//ViewBag.pais = "mx.png";
//return RedirectToAction("Pais", "Home");
}
Session["spras"] = user.SPRAS_ID;
}
ViewBag.PUESTOC_ID = new SelectList(db.PUESTOes, "ID", "ID");
ViewBag.PUESTOA_ID = new SelectList(db.PUESTOes, "ID", "ID");
ViewBag.BUKRS = new SelectList(db.SOCIEDADs, "BUKRS", "BUTXT");
return(View());
}
// 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));
}
public ActionResult Index(string vko, string vtw, string kun, string spa, string aa)
{
int pagina = 641; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
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 Create(string vko, string vtw, string kun, string spa)
{
int pagina = 643; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
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 ActionResult Create2(string vko, string vtw, string kun, string spa, Contactoc conC)
{
using (TruequeEntities db = new TruequeEntities())
{
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 }));
}
}
// 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 DateTime getPrimerDia(int ejercicio, int periodo)
{
TruequeEntities db = new TruequeEntities();
DateTime dia;
if (periodo == 1)
{
ejercicio--;
periodo = 13;
}
List <PERIODO445> pp = db.PERIODO445.Where(a => a.EJERCICIO == ejercicio).ToList();
PERIODO445 p = pp.FirstOrDefault(a => a.MES_NATURAL == periodo - 1);
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 decimal getUkursUSD(string waers, string waersusd, out string errorString)
{
decimal ukurs = 0;
errorString = string.Empty;
if (waers != waersusd)
{
using (TruequeEntities db = new TruequeEntities())
{
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);
}
}
}
else
{
ukurs = 1;
}
return(ukurs);
}
public int getPeriodoF(DateTime fecha)
{
TruequeEntities db = new TruequeEntities();
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);
}
// 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());
}
// GET: NOTICIAs/Create
public ActionResult Create()
{
int pagina = 912; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
string u = User.Identity.Name;
//string u = "admin";
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList();
ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList();
ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;;
ViewBag.rol = user.PUESTO.PUESTOTs.Where(a => a.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList();
ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(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 ActionResult CreateA()
{
int pagina = 804; //ID EN BASE DE DATOS
USUARIO user = null;
using (TruequeEntities db = new TruequeEntities())
{
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(801) || 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());
}
// GET: Impuestos/Details/5
public ActionResult Details(string id)
{
int pagina = 742; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
string u = User.Identity.Name;
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList();
ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList();
ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;;
ViewBag.rol = user.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));
}
}
// GET: TALLs
public ActionResult Index()
{
int pagina = 721; //ID EN BASE DE DATOS
int pagina2 = 881;
using (TruequeEntities db = new TruequeEntities())
{
string u = User.Identity.Name;
//string u = "admin";
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList();
ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList();
ViewBag.usuario = user;
ViewBag.rol = user.PUESTO.PUESTOTs.Where(a => a.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina2)).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(pagina2) || 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 tALLs = db.TALLs.Include(t => t.GALL);
return(View(tALLs.ToList()));
}
public ActionResult Create([Bind(Include = "ID,DESCRIPCION,FECHAI,FECHAF,GALL_ID,ACTIVO")] TALL tALL)
{
if (ModelState.IsValid)
{
//TSOPORTE TS = new TSOPORTE();
tALL.FECHAI = DateTime.Today;
tALL.FECHAF = DateTime.MaxValue;
tALL.ACTIVO = true;
db.TALLs.Add(tALL);
db.SaveChanges();
List <SPRA> ss = db.SPRAS.ToList();
foreach (SPRA s in ss)
{
TALLT pt = new TALLT();
pt.TALL_ID = tALL.ID;
pt.SPRAS_ID = s.ID;
pt.TXT50 = tALL.DESCRIPCION;
db.TALLTs.Add(pt);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
int pagina = 723; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
string u = User.Identity.Name;
//string u = "admin";
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList();
ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList();
ViewBag.usuario = user;
ViewBag.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(721) || 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(tALL));
}
public ActionResult Create([Bind(Include = "PAGINA_ID,CAMPO_ID,SPRAS_ID,TEXTOS,ACTIVO")] TEXTO tEXTO)
{
if (ModelState.IsValid)
{
List <SPRA> lan = db.SPRAS.ToList();
foreach (SPRA l in lan)
{
try
{
var obj = db.TEXTOes.Where(a => a.PAGINA_ID.Equals(tEXTO.PAGINA_ID) && a.CAMPO_ID.Equals(tEXTO.CAMPO_ID) && a.SPRAS_ID.Equals(l.ID)).FirstOrDefault();
if (obj == null)
{
TEXTO t = new TEXTO();
t.ACTIVO = true;
t.CAMPO_ID = tEXTO.CAMPO_ID;
t.PAGINA_ID = tEXTO.PAGINA_ID;
t.TEXTOS = tEXTO.TEXTOS;
t.SPRAS_ID = l.ID;
db.TEXTOes.Add(t);
db.SaveChanges();
}
}
catch { }
}
return(RedirectToAction("Index", new { id = tEXTO.PAGINA_ID }));
}
int pagina = 511; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
string u = User.Identity.Name;
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList();
ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList();
ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;;
ViewBag.rol = user.PUESTO.PUESTOTs.Where(a => a.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList();
ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList();
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".png";
}
catch
{
//return RedirectToAction("Pais", "Home");
}
}
//ViewBag.PAGINA_ID = new SelectList(db.CAMPOS, "PAGINA_ID", "DESCRIPCION");
ViewBag.CAMPO_ID = new SelectList(db.CAMPOS.Where(a => a.PAGINA_ID.Equals(tEXTO.PAGINA_ID)), "ID", "ID");
ViewBag.SPRAS_ID = new SelectList(db.SPRAS, "ID", "ID");
ViewBag.Error = "Registro duplicado";
return(View(tEXTO));
}
// GET: Contacto/Delete/5
public ActionResult Delete(int id)
{
using (TruequeEntities db = new TruequeEntities())
{
var con = db.CONTACTOCs.Where(x => x.ID == id).First();
con.ACTIVO = false;
db.SaveChanges();
return(RedirectToAction("Index", new { vko = con.VKORG, vtw = con.VTWEG, kun = con.KUNNR, spa = con.SPART }));
}
}
//public static List<CSP_PRESU_CLIENT_Result> ObtenerPresupuestoCliente(TruequeEntities db, string kunnr, string periodo)
//{
// List<CSP_PRESU_CLIENT_Result> presupuesto = db.Database.SqlQuery<CSP_PRESU_CLIENT_Result>("CSP_PRESU_CLIENT @CLIENTE, @PERIODO",
// new SqlParameter("@CLIENTE", kunnr),
// new SqlParameter("@PERIODO", periodo)).ToList();
// return presupuesto;
//}
public static List <DOCUMENTOP_SP> ObtenerDocumentoP(TruequeEntities db, string spras_id, decimal num_doc, DateTime vigencia_de, DateTime vigencia_al)
{
List <DOCUMENTOP_SP> documentop = db.Database.SqlQuery <DOCUMENTOP_SP>("CPS_LISTA_DOCUMENTOP @NUM_DOC,@SPRAS_ID,@VIGENCIA_DE,@VIGENCIA_AL",
new SqlParameter("@NUM_DOC", num_doc),
new SqlParameter("@SPRAS_ID", spras_id),
new SqlParameter("@VIGENCIA_DE", vigencia_de),
new SqlParameter("@VIGENCIA_AL", vigencia_al)).ToList();
return(documentop);
}
//public RANGO getRango(string TSOL_ID)
//{
// RANGO rango = new RANGO();
// using (TruequeEntities db = new TruequeEntities())
// {
// rango = (from r in db.RANGOes
// join s in db.TSOLs
// on r.ID equals s.RANGO_ID
// where s.ID == TSOL_ID && r.ACTIVO == true
// select r).FirstOrDefault();
// }
// return rango;
//}
//public decimal getSolID(string TSOL_ID)
//{
// decimal id = 0;
// RANGO rango = getRango(TSOL_ID);
// if (rango.ACTUAL > rango.INICIO && rango.ACTUAL < rango.FIN)
// {
// rango.ACTUAL++;
// id = (decimal)rango.ACTUAL;
// }
// return id;
//}
//public decimal getValSoc(string waers, string moneda_id, decimal monto_doc_md, out string errorString)
//{
// decimal val = 0;
// //Siempre la conversión va a la sociedad
// var UKURS = getUkurs(waers, moneda_id, out errorString);
// if (errorString.Equals(""))
// {
// decimal uk = Convert.ToDecimal(UKURS);
// if (UKURS > 0)
// {
// val = uk * Convert.ToDecimal(monto_doc_md);
// }
// }
// return val;
//}
//public decimal getUkurs(string waers, string moneda_id, out string errorString)
//{
// decimal ukurs = 0;
// errorString = string.Empty;
// using (TruequeEntities db = new TruequeEntities())
// {
// try
// {
// //Siempre la conversión va a la sociedad
// var date = DateTime.Now.Date;
// var tcambio = db.TCAMBIOs.Where(t => t.FCURR.Equals(moneda_id) && t.TCURR.Equals(waers) && t.GDATU.Equals(date)).FirstOrDefault();
// if (tcambio == null)
// {
// var max = db.TCAMBIOs.Where(t => t.FCURR.Equals(moneda_id) && t.TCURR.Equals(waers)).Max(a => a.GDATU);
// tcambio = db.TCAMBIOs.Where(t => t.FCURR.Equals(moneda_id) && t.TCURR.Equals(waers) && t.GDATU.Equals(max)).FirstOrDefault();
// }
// ukurs = Convert.ToDecimal(tcambio.UKURS);
// }
// catch (Exception e)
// {
// errorString = "detail: conversion " + moneda_id + " to " + waers + " in date " + DateTime.Now.Date;
// return 0;
// }
// }
// return ukurs;
//}
//public decimal getUkursUSD(string waers, string waersusd, out string errorString)
//{
// decimal ukurs = 0;
// errorString = string.Empty;
// using (TruequeEntities db = new TruequeEntities())
// {
// 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;
//}
public CLIENTE getCliente(string PAYER_ID)
{
CLIENTE payer = new CLIENTE();
using (TruequeEntities db = new TruequeEntities())
{
payer = db.CLIENTEs.Where(c => c.KUNNR.Equals(PAYER_ID)).FirstOrDefault();
}
return(payer);
}
public ActionResult Create([Bind(Include = "SOCIEDAD_ID,PAIS_ID,VKORG,VTWEG,SPART,KUNNR,CONCEPTO_ID,POS,RETENCION_ID,PORC,ACTIVO,TRETENCION_ID")] TAXEOP tAXEOP, string sc, string ld, string kun, string vk, string vtw, string sp, string con)
{
if (ModelState.IsValid)
{
var pa = db.SOCIEDADs.Where(p => p.BUKRS == tAXEOP.SOCIEDAD_ID).Select(o => o.LAND).FirstOrDefault();
var ps = db.TAXEOPs.ToList();
var tx = tAXEOP;
tx.PAIS_ID = pa;
tx.POS = ps[ps.Count - 1].POS + 1;
tx.ACTIVO = true;
db.TAXEOPs.Add(tx);
db.SaveChanges();
return(RedirectToAction("Index", new { sc = tAXEOP.SOCIEDAD_ID, ld = tAXEOP.PAIS_ID, kun = tAXEOP.KUNNR, vk = tAXEOP.VKORG, vtw = tAXEOP.VTWEG, sp = tAXEOP.SPART, con = tAXEOP.CONCEPTO_ID }));
}
int pagina = 863; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
string u = User.Identity.Name;
//string u = "admin";
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList();
ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList();
ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;;
ViewBag.rol = user.PUESTO.PUESTOTs.Where(a => a.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList();
ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(861) || 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;
}
//Para Regresar al Index
ViewBag.sc = sc;
ViewBag.ld = ld;
ViewBag.kun = kun;
ViewBag.vk = vk;
ViewBag.vtw = vtw;
ViewBag.sp = sp;
ViewBag.con = con;
ViewBag.RETENCION_ID = new SelectList(db.RETENCIONs, "ID", "ID");
ViewBag.TRETENCION_ID = new SelectList(db.TRETENCIONs, "ID", "ID");
return(View(tAXEOP));
}
public static string ObtenerTextoMnj(TruequeEntities db, int pagina_id, string campo_id, string user_id)
{
string spras_id = ObtenerSprasId(db, user_id);
string texto = "";
if (db.TEXTOes.Any(a => (a.PAGINA_ID.Equals(pagina_id) && a.SPRAS_ID.Equals(spras_id) && a.CAMPO_ID.Equals(campo_id))))
{
texto = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(pagina_id) && a.SPRAS_ID.Equals(spras_id) && a.CAMPO_ID.Equals(campo_id))).FirstOrDefault().TEXTOS;
}
return(texto);
}
public ActionResult Edit([Bind(Include = "ID,ACTIVO")] PUESTO pUESTO)
{
if (ModelState.IsValid)
{
List <SPRA> ss = db.SPRAS.ToList();
foreach (SPRA s in ss)
{
try
{
PUESTOT p = new PUESTOT();
p.PUESTO_ID = pUESTO.ID;
p.SPRAS_ID = s.ID;
p.TXT50 = Request.Form[s.ID].ToString();
db.Entry(p).State = EntityState.Modified;
db.SaveChanges();
}
catch
{
}
}
db.Entry(pUESTO).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
int pagina = 621; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
string u = User.Identity.Name;
//string u = "admin";
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList();
ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList();
ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;;
ViewBag.rol = user.PUESTO.PUESTOTs.Where(a => a.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(623)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList();
ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList();
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".png";
}
catch
{
//ViewBag.pais = "mx.png";
//return RedirectToAction("Pais", "Home");
}
Session["spras"] = user.SPRAS_ID;
}
return(View(pUESTO));
}
// GET: Flujos
public ActionResult Index()
{
int pagina = 103; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
string u = User.Identity.Name;
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList();
ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList();
ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;;
ViewBag.rol = user.PUESTO.PUESTOTs.Where(a => a.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList();
ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList();
try
{
string p = Session["pais"].ToString();
ViewBag.pais = p + ".png";
}
catch
{
//ViewBag.pais = "mx.png";
//return RedirectToAction("Pais", "Home");
}
Session["spras"] = user.SPRAS_ID;
}
List <DET_AGENTE> dda = db.DET_AGENTE.ToList();
foreach (DET_AGENTE da in dda)
{
string id = da.GAUTORIZACION.USUARIOs.Where(a => a.PUESTO_ID.Equals(da.PUESTOA_ID)).FirstOrDefault().ID;
da.USUARIOA = id;
da.USUARIOC = da.GAUTORIZACION.USUARIOs.Where(a => a.PUESTO_ID.Equals(da.PUESTOC_ID)).FirstOrDefault().ID;
db.Entry(da).State = EntityState.Modified;
db.SaveChanges();
}
//List<USUARIO> uu = db.USUARIOs.ToList();
//foreach(USUARIO u in uu)
//{
// foreach(GAUTORIZACION g in u.GAUTORIZACIONs)
// {
// int i = 0;
// }
//}
var fLUJOes = db.FLUJOes.Include(f => f.DOCUMENTO).Include(f => f.USUARIO).Include(f => f.USUARIO1).Include(f => f.WORKFP);
return(View(fLUJOes.ToList()));
}
// GET: Taxeop/Delete/5
public ActionResult Delete(string sc, string ld, string kun, string vk, string vtw, string sp, string con, string pos, string rid)
{
int pagina = 864; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
string u = User.Identity.Name;
//string u = "admin";
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList();
ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList();
ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;;
ViewBag.rol = user.PUESTO.PUESTOTs.Where(a => a.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList();
ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(861) || 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;
}
if (sc == null && ld == null && kun == null && vk == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
int c = Convert.ToInt32(con);
int ps = Convert.ToInt32(pos);
int r = Convert.ToInt32(rid);
var txp = db.TAXEOPs.Where(t => t.SOCIEDAD_ID == sc && t.PAIS_ID == ld && t.KUNNR == kun && t.VKORG == vk && t.VTWEG == vtw && t.SPART == sp && t.CONCEPTO_ID == c && t.POS == ps && t.RETENCION_ID == r).FirstOrDefault();
if (txp == null)
{
return(HttpNotFound());
}
//Para Regresar al Index
ViewBag.sc = sc;
ViewBag.ld = ld;
ViewBag.kun = kun;
ViewBag.vk = vk;
ViewBag.vtw = vtw;
ViewBag.sp = sp;
ViewBag.con = con;
return(View(txp));
}
public ActionResult Create([Bind(Include = "ID,FECHAI,FECHAF,PATH,USUARIOC_ID,FECHAC,ACTIVO")] NOTICIA nOTICIA)
{
if (ModelState.IsValid)
{
string u = User.Identity.Name;
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
var _p = db.NOTICIAs.Where(x => x.PATH == "/images/" + nOTICIA.PATH).FirstOrDefault();
//si p es null, significa que podemos hacer incersiones
if (_p == null)
{
nOTICIA.FECHAC = DateTime.Now;
nOTICIA.PATH = "/images/" + nOTICIA.PATH;
nOTICIA.USUARIOC_ID = user.ID;
nOTICIA.ACTIVO = true;
db.NOTICIAs.Add(nOTICIA);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
ViewBag.error = "Ya existe un registro con esos datos";
int pagina = 912; //ID EN BASE DE DATOS
using (TruequeEntities db = new TruequeEntities())
{
string u = User.Identity.Name;
//string u = "admin";
var user = db.USUARIOs.Where(a => a.ID.Equals(u)).FirstOrDefault();
ViewBag.permisos = db.PAGINAVs.Where(a => a.ID.Equals(user.ID)).ToList();
ViewBag.carpetas = db.CARPETAVs.Where(a => a.USUARIO_ID.Equals(user.ID)).ToList();
ViewBag.usuario = user; ViewBag.returnUrl = Request.Url.PathAndQuery;;
ViewBag.rol = user.PUESTO.PUESTOTs.Where(a => a.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.Title = db.PAGINAs.Where(a => a.ID.Equals(pagina)).FirstOrDefault().PAGINATs.Where(b => b.SPRAS_ID.Equals(user.SPRAS_ID)).FirstOrDefault().TXT50;
ViewBag.warnings = db.WARNINGVs.Where(a => (a.PAGINA_ID.Equals(pagina) || a.PAGINA_ID.Equals(0)) && a.SPRAS_ID.Equals(user.SPRAS_ID)).ToList();
ViewBag.textos = db.TEXTOes.Where(a => (a.PAGINA_ID.Equals(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", nOTICIA.USUARIOC_ID);
return(View(nOTICIA));
}
public static decimal ObtenerImpuesto(TruequeEntities db, DOCUMENTO D, ref bool esNC, string[] categorias = null)
{
decimal impuesto = 0.0M;
string[] tsolImp = new string[] { "NC", "NCA", "NCAS", "NCAM", "NCASM", "NCS", "NCI", "NCIA", "NCIAS", "NCIS" };
string pais_id = D.PAIS_ID;
if (tsolImp.Contains(D.TSOL_ID))
{
decimal KBETR;
esNC = true;
if (categorias != null)
{
// Se obtiene Id de la categoria
Cadena cad = new Cadena();
string[] auxCategorias = categorias;
int i = 0;
bool esMaterial = false;
foreach (string cat in auxCategorias)
{
string catAux = cad.completaMaterial(cat);
if (!esMaterial)
{
esMaterial = db.MATERIALs.Any(x => x.ID == catAux);
}
if (esMaterial)
{
categorias[i] = db.MATERIALs.First(x => x.ID == catAux).MATERIALGP_ID;
}
i++;
}
}
if ((categorias != null && categorias.Any() && (categorias.Contains("605") || categorias.Contains("207"))) || db.DOCUMENTOPs.Any(x => (x.MATKL == "605" || x.MATKL == "207") && x.NUM_DOC == D.NUM_DOC))
{
KBETR = db.IIMPUESTOes.First(x => x.MWSKZ == "A0").KBETR.Value;
}
else
{
try
{
decimal concecutivo = db.CONPOSAPHs.First(x => x.TIPO_SOL == "NC" && x.SOCIEDAD == D.SOCIEDAD_ID && (x.TIPO_DOC == "YG" || x.TIPO_DOC == "DG")).CONSECUTIVO;
string tax_code = db.CONPOSAPPs.First(x => x.CONSECUTIVO == concecutivo).TAX_CODE;
KBETR = db.IIMPUESTOes.Any(x => x.MWSKZ == tax_code && x.LAND == pais_id) ? db.IIMPUESTOes.First(x => x.MWSKZ == tax_code && x.LAND == pais_id).KBETR.Value : 0.0M;
}
catch { KBETR = 0; }
}
impuesto = (D.MONTO_DOC_MD.Value * KBETR);
}
return(impuesto);
}
public int getEjercicio(DateTime fecha)
{
TruequeEntities db = new TruequeEntities();
List <PERIODO445> pp = db.PERIODO445.Where(a => a.EJERCICIO == fecha.Year).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(fecha.Year);
}
return(p.EJERCICIO + p.SUMA);
}
public static MATERIAL ObtenerMaterial(TruequeEntities db, string user_id, string material_id)
{
string spras_id = ObtenerSprasId(db, user_id);
MATERIAL material = db.MATERIALs.Where(x => x.ID == material_id).FirstOrDefault();
if (material.MATERIALTs.Any(x => x.SPRAS == spras_id))
{
MATERIALT mt = material.MATERIALTs.First(x => x.SPRAS == spras_id);
material.MAKTX = mt.MAKTX;
material.MAKTG = mt.MAKTG;
}
return(material);
}
