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("")));
}
public ActionResult Index(string cpt, string excel, string select, string anioconsu, string periodoconsu, string cambio)
{
try
{
if (Session["sociedad"].ToString() != select)
{
cambio = null;
periodoconsu = null;
anioconsu = null;
}
if (periodoconsu == "")
{
periodoconsu = null;
}
}
catch (Exception)
{
}
Session["sociedad"] = select;
Session["cambio"] = cambio;
Session["periodoconsu"] = periodoconsu;
Session["anioconsu"] = anioconsu;
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();
DatosPresupuesto presu = new DatosPresupuesto();
ViewBag.ultMod = carga.consultarUCarga();
ViewBag.anio = "20" + carga.consultaAnio();
ViewBag.chkcpt = cpt;
presu = carga.consultarDatos(select, anioconsu, periodoconsu, cambio, cpt, excel, Server.MapPath("~/pdfTemp/"));
if (excel != null)
{
return(File(Server.MapPath("~/pdfTemp/Presupuesto.xlsx"), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Presupuesto.xlsx"));
}
else
{
return(View(presu));
}
;
}