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 FileResult Descargar(int idLayout) { try { Models.PresupuestoModels carga = new Models.PresupuestoModels(); string archivo = db.LAYOUT_CARGA.FirstOrDefault(x => x.ID == idLayout).RUTA; string nombre = "", contentyp = ""; carga.contDescarga(archivo, ref contentyp, ref nombre); return(File(archivo, contentyp, nombre)); } catch (Exception e) { Log.ErrorLogApp(e, "Layout", "Descargar"); return(null); } }
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)); } ; }
// GET: Correos public ActionResult Index(decimal id, bool?mail) //B20180803 MGC Correos { var dOCUMENTO = db.DOCUMENTOes.Where(x => x.NUM_DOC == id).FirstOrDefault(); var flujo = db.FLUJOes.Where(x => x.NUM_DOC == id).OrderByDescending(o => o.POS).Select(s => s.POS).ToList(); ViewBag.Pos = flujo[0]; ViewBag.url = "http://localhost:64497"; ViewBag.url = "http://192.168.1.77"; ViewBag.url = Request.Url.AbsoluteUri.Replace(Request.Url.AbsolutePath, ""); //ViewBag.miles = dOCUMENTOes.PAI.MILES;//LEJGG 090718 //ViewBag.dec = dOCUMENTOes.PAI.DECIMAL;//LEJGG 090718 FormatosC fc = new FormatosC(); ViewBag.monto = fc.toShow((decimal)dOCUMENTO.MONTO_DOC_MD, dOCUMENTO.PAI.DECIMAL) + " " + dOCUMENTO.MONEDA_ID; if (mail == null) { mail = true; } //B20180803 MGC Correos............ string mailv = ""; if (mail != null) { if (mail == true) { mailv = "X"; } } ViewBag.mail = mailv; //B20180803 MGC Correos............ //B20180803 MGC Presupuesto............ Models.PresupuestoModels carga = new Models.PresupuestoModels(); ViewBag.ultMod = carga.consultarUCarga(); dOCUMENTO.PAI = db.PAIS.Where(a => a.LAND.Equals(dOCUMENTO.PAIS_ID)).FirstOrDefault(); if (dOCUMENTO.PAI != null) { ViewBag.miles = dOCUMENTO.PAI.MILES; //LEJGG 090718 ViewBag.dec = dOCUMENTO.PAI.DECIMAL; //LEJGG 090718 } CLIENTE_MOD cli = new CLIENTE_MOD(); cli = SelectCliente(dOCUMENTO.PAYER_ID); ViewBag.kunnr = cli.KUNNR + "-" + cli.NAME1; ViewBag.vtweg = cli.VTWEG; Services.FormatosC format = new FormatosC(); PRESUPUESTO_MOD presu = new PRESUPUESTO_MOD(); presu = getPresupuesto(dOCUMENTO.PAYER_ID); decimal pcanal = 0; try { pcanal = Convert.ToDecimal(presu.P_CANAL) / 1; } catch (Exception) { } decimal pbanner = 0; try { pbanner = Convert.ToDecimal(presu.P_BANNER) / 1; } catch (Exception) { } decimal pcc = 0; try { pcc = Convert.ToDecimal(presu.PC_C) / 1 * -1; } catch (Exception) { } decimal pca = 0; try { pca = Convert.ToDecimal(presu.PC_A) / 1 * -1; } catch (Exception) { } decimal pcp = 0; try { pcp = Convert.ToDecimal(presu.PC_P) / 1 * -1; } catch (Exception) { } decimal pct = 0; try { pct = Convert.ToDecimal(presu.PC_T) / 1 * -1; } catch (Exception) { } decimal consu = 0; try { consu = Convert.ToDecimal(presu.CONSU) / 1; } catch (Exception) { } ViewBag.pcan = format.toShowG(pcanal, dOCUMENTO.PAI.DECIMAL); ViewBag.pban = format.toShowG(pbanner, dOCUMENTO.PAI.DECIMAL); ViewBag.pcc = format.toShowG(pcc, dOCUMENTO.PAI.DECIMAL); ViewBag.pca = format.toShowG(pca, dOCUMENTO.PAI.DECIMAL); ViewBag.pcp = format.toShowG(pcp, dOCUMENTO.PAI.DECIMAL); ViewBag.pct = format.toShowG(pct, dOCUMENTO.PAI.DECIMAL); ViewBag.consu = format.toShowG(consu, dOCUMENTO.PAI.DECIMAL); SOLICITUD_MOD sol = new SOLICITUD_MOD(); if (dOCUMENTO.DOCUMENTO_REF == null) { sol = getSolicitud("0.00", dOCUMENTO.MONTO_DOC_MD + "", dOCUMENTO.PAI.DECIMAL); } else { sol = getSolicitud(dOCUMENTO.DOCUMENTO_REF + "", dOCUMENTO.MONTO_DOC_MD + "", dOCUMENTO.PAI.DECIMAL); } ViewBag.S_IMPA = sol.S_IMPA; ViewBag.S_IMPB = sol.S_IMPB; ViewBag.S_IMPC = sol.S_IMPC; ViewBag.S_MONTOA = sol.S_MONTOA; ViewBag.S_MONTOB = sol.S_MONTOB; ViewBag.S_MONTOP = sol.S_MONTOP; ViewBag.S_NUM = sol.S_NUM; ViewBag.S_REMA = sol.S_REMA; ViewBag.rema_color = ""; if (format.toNum(sol.S_REMA, dOCUMENTO.PAI.MILES, dOCUMENTO.PAI.DECIMAL) < 0) { ViewBag.rema_color = "#F44336 !important"; } ViewBag.S_RET = sol.S_RET; ViewBag.S_TOTAL = sol.S_TOTAL; //B20180803 MGC Presupuesto............ return(View(dOCUMENTO)); }