public JsonResult ViewReportPage(string reportPath, int?page = 0) { var model = this.GetReportViewerModel(Request); model.ViewMode = ReportViewModes.View; model.ReportPath = reportPath; var contentData = ReportServiceHelpers.ExportReportToFormat(model, ReportFormats.Html4_0, page, page); var content = model.Encoding.GetString(contentData.ReportData); if (model.UseCustomReportImagePath && model.ReportImagePath.HasValue()) { content = ReportServiceHelpers.ReplaceImageUrls(model, content); } var jsonResult = Json( new { CurrentPage = contentData.CurrentPage, Content = content, TotalPages = contentData.TotalPages }, new Newtonsoft.Json.JsonSerializerSettings() { ContractResolver = new Newtonsoft.Json.Serialization.DefaultContractResolver() } ); return(jsonResult); }
public JsonResult FindStringInReport(string reportPath, string searchText, int?page = 0) { var model = this.GetReportViewerModel(Request); model.ViewMode = ReportViewModes.View; model.ReportPath = reportPath; return(Json(ReportServiceHelpers.FindStringInReport(model, searchText, page).ToInt32())); }
private void Init() { ReportViewModel = ReportHelper.GetReportViewerModel(this.Request); ReportViewModel.ReportPath = ReportServiceHelpers.AddCharacterStartEnd(_configuration["Report:BitacoraFolder"], true, true, "/") + _configuration["Report:ReportName_Audit_Bitacora"]; // "/DemandaBI/Auditoria/Audit_Bitacora"; ReportViewModel.Title = "Bitácora"; this.ControllerPath = "/Bitacora/ReportBitacora"; ReportViewModel.ControllerPath = this.ControllerPath; }
public void OnGet() { ViewData["Message"] = "Indicadores de demanda de energía"; ReportViewModel = ReportHelper.GetReportViewerModel(this.Request); ReportViewModel.ReportPath = ReportServiceHelpers.AddCharacterStartEnd(_configuration["Report:DemandaFolder"], true, true, "/") + _configuration["Report:ReportName_DashBoardBI"]; // "/DemandaBI/DashBoardBI"; ReportViewModel.Title = "Indicadores de demanda de energía"; }
public ActionResult PrintReport(string reportPath) { var model = this.GetReportViewerModel(Request); model.ViewMode = ReportViewModes.Print; model.ReportPath = reportPath; var contentData = ReportServiceHelpers.ExportReportToFormat(model, ReportFormats.Html4_0); var content = model.Encoding.GetString(contentData.ReportData); content = ReportServiceHelpers.ReplaceImageUrls(model, content); var sb = new System.Text.StringBuilder(); sb.AppendLine("<html>"); sb.AppendLine(" <body>"); //sb.AppendLine($" <img src='data:image/tiff;base64,{Convert.ToBase64String(contentData.ReportData)}' />"); sb.AppendLine($" {content}"); sb.AppendLine(" <script type='text/javascript'>"); sb.AppendLine(" (function() {"); /* * sb.AppendLine(" var beforePrint = function() {"); * sb.AppendLine(" console.log('Functionality to run before printing.');"); * sb.AppendLine(" };"); */ sb.AppendLine(" var afterPrint = function() {"); sb.AppendLine(" window.onfocus = function() { window.close(); };"); sb.AppendLine(" window.onmousemove = function() { window.close(); };"); sb.AppendLine(" };"); sb.AppendLine(" if (window.matchMedia) {"); sb.AppendLine(" var mediaQueryList = window.matchMedia('print');"); sb.AppendLine(" mediaQueryList.addListener(function(mql) {"); sb.AppendLine(" if (mql.matches) {"); //sb.AppendLine(" beforePrint();"); sb.AppendLine(" } else {"); sb.AppendLine(" afterPrint();"); sb.AppendLine(" }"); sb.AppendLine(" });"); sb.AppendLine(" }"); //sb.AppendLine(" window.onbeforeprint = beforePrint;"); sb.AppendLine(" window.onafterprint = afterPrint;"); sb.AppendLine(" }());"); sb.AppendLine(" window.print();"); sb.AppendLine(" </script>"); sb.AppendLine(" </body>"); sb.AppendLine("<html>"); return(Content(sb.ToString(), "text/html")); }
public IActionResult OnGetDemandaDepartamento() { ViewData["Message"] = "DemandaDepartamento"; if (!ModelState.IsValid) { return(Page()); } ReportViewModel = ReportHelper.GetReportViewerModel(this.Request); ReportViewModel.ReportPath = ReportServiceHelpers.AddCharacterStartEnd(_configuration["Report:DemandaFolder"], true, true, "/") + _configuration["Report:ReportName_DemandaDepartamento"]; // "/DemandaBI/DemandaDepartamento"; ReportViewModel.Title = "Demanda por geografía"; return(Page()); }
public IActionResult OnGetDemandaComercialAgente(string agente) { ViewData["Message"] = "DemandaComercialAgente" + " - Agente: " + agente; if (!ModelState.IsValid) { return(Page()); } ReportViewModel = ReportHelper.GetReportViewerModel(this.Request); ReportViewModel.ReportPath = ReportServiceHelpers.AddCharacterStartEnd(_configuration["Report:DemandaFolder"], true, true, "/") + _configuration["Report:ReportName_DemandaComercialAgente"]; // "/DemandaBI/DemandaComercialAgente"; ReportViewModel.Title = "Demanda comercial por agente"; return(Page()); }
public IActionResult OnGetDemandaRealComercialPerdida() { ViewData["Message"] = "DemandaRealComercialPerdida"; if (!ModelState.IsValid) { return(Page()); } ReportViewModel = ReportHelper.GetReportViewerModel(this.Request); ReportViewModel.ReportPath = ReportServiceHelpers.AddCharacterStartEnd(_configuration["Report:DemandaFolder"], true, true, "/") + _configuration["Report:ReportName_DemandaRealComercialPerdida"]; // "/DemandaBI/DemandaRealComercialPerdida"; ReportViewModel.Title = "Demanda real comercial y pérdidas"; return(Page()); }
public IActionResult OnGetBitacoraEstadistica() { ViewData["Message"] = "BitacoraEstadistica"; if (!ModelState.IsValid) { return(Page()); } ReportViewModel = ReportHelper.GetReportViewerModel(this.Request); ReportViewModel.ReportPath = ReportServiceHelpers.AddCharacterStartEnd(_configuration["Report:BitacoraFolder"], true, true, "/") + _configuration["Report:ReportName_Audit_BitacoraEstadisticas"]; // "/DemandaBI/Auditoria/Audit_BitacoraEstadisticas"; ReportViewModel.Title = "Bitácora estadísticas de procesos"; return(Page()); }
public JsonResult Execute(string reportPath, [FromBody] Dictionary <string, string[]> parameters, int page = 0) { try { var model = this.GetReportViewerModel(Request); model.ViewMode = ReportViewModes.View; model.ReportPath = reportPath; if (parameters.Any()) { model.Parameters = parameters; } var contentData = ReportServiceHelpers.ExportReportToFormat(model, ReportFormats.Html4_0, page, page); var content = model.Encoding.GetString(contentData.ReportData ?? new byte[] { }); if (model.UseCustomReportImagePath && model.ReportImagePath.HasValue()) { content = ReportServiceHelpers.ReplaceImageUrls(model, content); } var jsonResult = Json( new { contentData.CurrentPage, content, contentData.Parameters, contentData.TotalPages }, new Newtonsoft.Json.JsonSerializerSettings() { ContractResolver = new Newtonsoft.Json.Serialization.CamelCasePropertyNamesContractResolver() } ); return(jsonResult); } catch (Exception exception) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return(Json(new { ExceptionMessage = exception.Message, })); } }
public FileResult ExportReport(string reportPath, string format) { var model = this.GetReportViewerModel(Request); model.ViewMode = ReportViewModes.Export; model.ReportPath = reportPath; var extension = ""; switch (format.ToUpper()) { case "CSV": format = "CSV"; extension = ".csv"; break; case "MHTML": format = "MHTML"; extension = ".mht"; break; case "PDF": format = "PDF"; extension = ".pdf"; break; case "TIFF": format = "IMAGE"; extension = ".tif"; break; case "XML": format = "XML"; extension = ".xml"; break; case "WORDOPENXML": format = "WORDOPENXML"; extension = ".docx"; break; case "EXCELOPENXML": default: format = "EXCELOPENXML"; extension = ".xlsx"; break; } var contentData = ReportServiceHelpers.ExportReportToFormat(model, format); var filename = reportPath; if (filename.Contains("/")) { filename = filename.Substring(filename.LastIndexOf("/")); filename = filename.Replace("/", ""); } filename = filename + extension; return(File(contentData.ReportData, contentData.MimeType, filename)); }