private IActionResult generar(int id) { Guid guid = Guid.NewGuid(); _log.RegistrarEvento($"{guid.ToString()}{Environment.NewLine}{Newtonsoft.Json.JsonConvert.SerializeObject(id)}"); ConsultaNotaCompraPorGuiaRecepcionMateriaPrimaIdResponseDTO response = new ConsultaNotaCompraPorGuiaRecepcionMateriaPrimaIdResponseDTO(); try { ConsultaNotaCompraPorGuiaRecepcionMateriaPrimaIdRequestDTO request = new ConsultaNotaCompraPorGuiaRecepcionMateriaPrimaIdRequestDTO(); request.GuiaRecepcionMateriaPrimaId = id; ConsultaImpresionNotaCompraPorGuiaRecepcionMateriaPrimaIdBE item = _notaCompraService.ConsultarImpresionNotaCompraPorGuiaRecepcionMateriaPrimaId(request); List <ConsultaImpresionAdelantoBE> adelantos = _notaCompraService.ConsultarImpresionNotaCompraAdelantosPorGuiaRecepcionMateriaPrimaId(item.NotaCompraId); List <ConsultaImpresionNotaCompraPorGuiaRecepcionMateriaPrimaIdBE> lista = new List <ConsultaImpresionNotaCompraPorGuiaRecepcionMateriaPrimaIdBE>(); lista.Add(item); string mimetype = ""; int extension = 1; var path = $"{this._webHostEnvironment.ContentRootPath}\\Reportes\\NotaCompra.rdlc"; LocalReport lr = new LocalReport(path); Dictionary <string, string> parameters = new Dictionary <string, string>(); lr.AddDataSource("dsNotaCompra", Util.ToDataTable(lista)); lr.AddDataSource("dsAdelanto", Util.ToDataTable(adelantos)); var result = lr.Execute(RenderType.Pdf, extension, parameters, mimetype); return(File(result.MainStream, "application/pdf")); } catch (ResultException ex) { response.Result = new Result() { Success = true, ErrCode = ex.Result.ErrCode, Message = ex.Result.Message }; } catch (Exception ex) { response.Result = new Result() { Success = false, Message = "Ocurrio un problema en el servicio, intentelo nuevamente." }; _log.RegistrarEvento(ex, guid.ToString()); } _log.RegistrarEvento($"{guid.ToString()}{Environment.NewLine}{Newtonsoft.Json.JsonConvert.SerializeObject(response)}"); return(Ok(response)); }
private IActionResult generar(int id) { Guid guid = Guid.NewGuid(); _log.RegistrarEvento($"{guid.ToString()}{Environment.NewLine}{Newtonsoft.Json.JsonConvert.SerializeObject(id)}"); ConsultaNotaCompraPorGuiaRecepcionMateriaPrimaIdResponseDTO response = new ConsultaNotaCompraPorGuiaRecepcionMateriaPrimaIdResponseDTO(); try { ConsultaNotaCompraPorGuiaRecepcionMateriaPrimaIdRequestDTO request = new ConsultaNotaCompraPorGuiaRecepcionMateriaPrimaIdRequestDTO(); request.GuiaRecepcionMateriaPrimaId = id; ConsultaImpresionListaProductoresPorNotaSalidaAlmacenResponseDTO impresionListaProductores = _notaSalidaAlmacenService.ConsultarImpresionListaProductoresPorNotaSalidaAlmacen(id); impresionListaProductores.FechaImpresion = DateTime.Now.ToString("dd/MM/yyyy"); List <ConsultaImpresionListaProductoresPorNotaSalidaAlmacenResponseDTO> reportCabecera = new List <ConsultaImpresionListaProductoresPorNotaSalidaAlmacenResponseDTO>(); reportCabecera.Add(impresionListaProductores); string mimetype = ""; int extension = 1; var path = $"{this._webHostEnvironment.ContentRootPath}\\Reportes\\ListaProductoresPorNotaSalidaAlmacen.rdlc"; LocalReport lr = new LocalReport(path); Dictionary <string, string> parameters = new Dictionary <string, string>(); //TODO: impresionListaProductores lr.AddDataSource("dsCabeceraLP", Util.ToDataTable(reportCabecera, true)); lr.AddDataSource("dsDetalleLP", Util.ToDataTable(impresionListaProductores.ListaProductores)); var result = lr.Execute(RenderType.Pdf, extension, parameters, mimetype); return(File(result.MainStream, "application/pdf")); } catch (ResultException ex) { response.Result = new Result() { Success = true, ErrCode = ex.Result.ErrCode, Message = ex.Result.Message }; } catch (Exception ex) { response.Result = new Result() { Success = false, Message = "Ocurrio un problema en el servicio, intentelo nuevamente." }; _log.RegistrarEvento(ex, guid.ToString()); } _log.RegistrarEvento($"{guid}{Environment.NewLine}{Newtonsoft.Json.JsonConvert.SerializeObject(response)}"); return(Ok(response)); }
public byte[] GenerateReportAsync <T, Y>(string reportName, string dataSourceName, List <T> dataSourceList, List <Y> parameterList) { Dictionary <string, string> param = new Dictionary <string, string>(); string rdlcFilePath = string.Format("{0}\\Reports\\{1}.rdlc", _hostEnvironment.ContentRootPath, reportName); LocalReport report = new LocalReport(rdlcFilePath); report.AddDataSource(dataSourceName, dataSourceList); report.AddDataSource("ParameterList", parameterList); var result = report.Execute(RenderType.Pdf, 1, null, ""); return(result.MainStream); }
public IActionResult Index(IndexPatientReceptionViewModel model) { System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance); List <DataSetsValues> list = _patientReceptionsRepository.GetAllPatientReceptions(model.StartDateTime, model.EndDateTime) .Select(x => new DataSetsValues { PatientFirstName = x.PatientFirstName, DateOfReception = x.DateOfReception, DoctorFirstName = x.DoctorFirstName, DoctorLastName = x.DoctorLastName, DoctorLicenseNumber = x.DoctorLicenseNumber, EmergencyCase = x.EmergencyCase, IsThereMedicalReport = x.IsThereMedicalReport, PatientLastName = x.PatientLastName, PatientReceptionId = x.PatientReceptionId, MedicalReport = string.IsNullOrEmpty(x.MedicalReport) ? "Medical report doesn't exist!" : x.MedicalReport }).ToList(); LocalReport _localReport = new LocalReport("Reports/Report1.rdlc"); _localReport.AddDataSource("DataSet1", list); ReportResult result = _localReport.Execute(RenderType.Pdf); return(File(result.MainStream, "application/pdf")); }
protected virtual void AddDataSources() { foreach (var kvp in DataSources) { LocalReport.AddDataSource(kvp.Key, kvp.Value); } }
/// <summary> /// Render a rdlc (SQL Server Reporting Services) /// </summary> /// <param name="reportPath">Absolute file path</param> /// <param name="exportReportType">Export file extension</param> /// <param name="parameters">Report parameters</param> /// <param name="dataSources">Report datasources</param> /// <returns>Array file contents</returns> public byte[] RenderRdlc(string reportPath, ExportReportType exportReportType, Dictionary <string, string> parameters = null, Dictionary <string, object> dataSources = null) { try { Encoding.RegisterProvider(CodePagesEncodingProvider.Instance); var report = new LocalReport(reportPath); if (dataSources != default) { foreach (var dataSource in dataSources) { report.AddDataSource(dataSource.Key, dataSource.Value); } } var result = report.Execute((RenderType)exportReportType, 1, parameters); return(result.MainStream); } catch (Exception e) { _logger?.Error(e, e.Message); throw; } }
public FileStreamResult ExportInvoiceToPdf(int invoiceId, string fileName = null) { var connectionString = Startup.ConnectionString; var options = new DbContextOptionsBuilder <CustomContext>() .UseSqlServer(connectionString).Options; using (var ctx = new CustomContext(options)) { var invoice = ctx.InvoiceLine .Include(x => x.Product) .Include(x => x.Invoice) .ThenInclude(x => x.Customer) .Include(x => x.Invoice) .ThenInclude(x => x.Company) .Where(x => x.InvoiceId.Equals(invoiceId)) .ToList(); var wwwroot = Startup.WebRootPath; var reportpath = $"{wwwroot}\\reports\\Invoice.rdlc"; var report = new LocalReport(reportpath); report.AddDataSource("InvoiceLine", invoice); var result = report.Execute(RenderType.Pdf, 1, null, ""); var pdf = new FileStreamResult(new MemoryStream(result.MainStream), "application/pdf"); pdf.FileDownloadName = (!string.IsNullOrEmpty(fileName) ? fileName : "Export") + ".pdf"; return(pdf); } }
private IActionResult generar(int id) { Guid guid = Guid.NewGuid(); _log.RegistrarEvento($"{guid}{Environment.NewLine}{JsonConvert.SerializeObject(id)}"); ImpresionOrdenProcesoResponseDTO response = new ImpresionOrdenProcesoResponseDTO(); try { ConsultarImpresionOrdenProcesoRequestDTO request = new ConsultarImpresionOrdenProcesoRequestDTO { OrdenProcesoId = id }; ConsultarImpresionOrdenProcesoResponseDTO resImpresion = ordenProcesoService.ConsultarImpresionOrdenProceso(request); var path = $"{this._webHostEnvironment.ContentRootPath}\\Reportes\\rptOrdenProceso.rdlc"; LocalReport lr = new LocalReport(path); Dictionary <string, string> parameters = new Dictionary <string, string>(); //TODO: impresionListaProductores lr.AddDataSource("dsOrdenProceso", resImpresion.listOrdenProceso.ToList()); lr.AddDataSource("dsDetalleOrdenProceso", resImpresion.listDetalleOrdenProceso.ToList()); var result = lr.Execute(RenderType.Pdf, 1, parameters, ""); return(File(result.MainStream, "application/pdf")); } catch (ResultException ex) { response.Result = new Result() { Success = true, ErrCode = ex.Result.ErrCode, Message = ex.Result.Message }; } catch (Exception ex) { response.Result = new Result() { Success = false, Message = "Ocurrio un problema en el servicio, intentelo nuevamente." }; _log.RegistrarEvento(ex, guid.ToString()); } _log.RegistrarEvento($"{guid}{Environment.NewLine}{JsonConvert.SerializeObject(response)}"); return(Ok(response)); }
public IActionResult GenerarPDFNotaIngreso(int id) { Guid guid = Guid.NewGuid(); _log.RegistrarEvento($"{guid}{Environment.NewLine}{Newtonsoft.Json.JsonConvert.SerializeObject(id)}"); GenerarPDFGuiaRemisionResponseDTO response = _NotaIngresoPlantaService.GenerarPDFGuiaRemisionPorNotaIngreso(id); try { GenerarPDFGuiaRemisionRequestDTO request = new GenerarPDFGuiaRemisionRequestDTO { LoteId = id }; string mimetype = ""; int extension = 1; var path = $"{_webHostEnvironment.ContentRootPath}\\Reportes\\rptNotaIngreso.rdlc"; LocalReport lr = new LocalReport(path); Dictionary <string, string> parameters = new Dictionary <string, string>(); lr.AddDataSource("dsGRCabecera", Util.ToDataTable(response.Cabecera)); lr.AddDataSource("dsGRListaDetalle", Util.ToDataTable(response.listaDetalleGM)); lr.AddDataSource("dsGRDetalle", Util.ToDataTable(response.detalleGM)); var result = lr.Execute(RenderType.Pdf, extension, parameters, mimetype); return(File(result.MainStream, "application/pdf")); } catch (ResultException ex) { response.Result = new Result() { Success = true, ErrCode = ex.Result.ErrCode, Message = ex.Result.Message }; } catch (Exception ex) { response.Result = new Result() { Success = false, Message = "Ocurrio un problema en el servicio, intentelo nuevamente." }; _log.RegistrarEvento(ex, guid.ToString()); } _log.RegistrarEvento($"{guid.ToString()}{Environment.NewLine}{Newtonsoft.Json.JsonConvert.SerializeObject(response)}"); return(Ok(response)); }
public ServiceResult <byte[]> PrintReportSolicitationSubsidyByOrganism(Guid organismId) { var newDirectory = Path.Combine(StaticFilesDirectory, "Reports", "SolicitationSubsidyByOrganism.rdl"); var files = new FileInfo(newDirectory); var notif = new ServiceResult <byte[]>(); if (!files.Exists) { notif.AddError("Error", "El Reporte no fue encontrado."); return(notif); } var rv = new LocalReport(newDirectory); var organismResult = _context.Organisms.FirstOrDefault(x => x.Id == organismId); var solicitation = _context.Report_SolicitationByOrganism(organismId); if (solicitation.Count() > 0) { rv.AddDataSource("ReportSolicitationByUser", new List <SolicitationSubsidyByOrganism>(solicitation)); } else { rv.AddDataSource("ReportSolicitationByUser", new List <SolicitationSubsidyByOrganism>() { new SolicitationSubsidyByOrganism() }); } rv.AddDataSource("OrganismDataSet", new List <Organism>() { organismResult }); rv.AddDataSource("CommonDataSet", new List <ReportDto>() { new ReportDto() { TodayDate = DateTime.Today.ToShortDateString() } }); System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance); var result = rv.Execute(RenderType.Pdf); return(new ServiceResult <byte[]>(result.MainStream)); }
public async Task <IActionResult> Print(ReportingViewModel model, string submit) { DataSet dataSet = new DataSet(); MySqlConnection con = new MySqlConnection("Data Source=localhost;Initial Catalog =ejabeda_habro;user id=root;password=asdf@1234"); var cmd1 = new MySqlCommand(model.Qryname, con); foreach (var paramerte in model.Parameters) { var parm = new MySqlParameter(); if (paramerte.Key.ToLower().Contains("date")) { parm.ParameterName = paramerte.Key; parm.Value = Convert.ToDateTime(paramerte.Value).ToString("yyyy-MM-dd"); } else { parm.ParameterName = paramerte.Key; parm.Value = paramerte.Value; } cmd1.Parameters.Add(parm); } string mimtype = ""; int extension = 1; var path = $"{_webHostEnvironment.WebRootPath}\\Reports\\" + model.ReportPath; LocalReport localReport = new LocalReport(path); var rDs = new DataSet(); var adp = new MySqlDataAdapter(cmd1); adp.Fill(rDs, model.Qryname); localReport.AddDataSource(model.xmlTableName, rDs.Tables[0]); if (submit == "Word") { var result = localReport.Execute(RenderType.Word, extension, model.Parameters, mimtype); return(File(result.MainStream, "application/msword", model.ReportName + ".doc")); } else if (submit == "Excel") { var result = localReport.Execute(RenderType.Excel, extension, model.Parameters, mimtype); return(File(result.MainStream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", model.ReportName + ".xlsx")); } else if (submit == "Pdf") { var result = localReport.Execute(RenderType.Pdf, extension, model.Parameters, mimtype); return(File(result.MainStream, "application/pdf", model.ReportName + ".pdf")); } else { var result = localReport.Execute(RenderType.Pdf, extension, model.Parameters, mimtype); return(File(result.MainStream, "application/pdf")); } }
protected override void AddDataSources() { var inf = typeof(T).GetProperties(); foreach (var p in inf) { if (p.Name != "Template") { LocalReport.AddDataSource(p.Name, p.GetValue(Data)); } } }
public ServiceResult <byte[]> PrintAccountFor(Guid solicitationId) { var newDirectory = Path.Combine(StaticFilesDirectory, "Reports", "Rendición.rdl"); var files = new FileInfo(newDirectory); var notif = new ServiceResult <byte[]>(); if (!files.Exists) { notif.AddError("Error", "El Reporte no fue encontrado."); return(notif); } var solic = _solicitationSubsidyService.GetByIdSubsidy(solicitationId).Response; if (solic == null) { notif.AddError("Error", "La solicitud no existe."); return(notif); } var rv = new LocalReport(newDirectory); rv.AddDataSource("UserDataSet", new List <UserDto>() { solic.User }); rv.AddDataSource("OrganismDataSet", new List <OrganismBaseDto>() { new OrganismBaseDto() { Name = _context.Distributions.FirstOrDefault(x => x.Id == solic.User.DistributionId).Name } }); rv.AddDataSource("DestinationDataSet", solic.Destinies); rv.AddDataSource("ExpenditureDataSet", solic.Expenditures); System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance); var result = rv.Execute(RenderType.Pdf); return(new ServiceResult <byte[]>(result.MainStream)); }
public ServiceResult <byte[]> ExpenditureProcedure() { var newDirectory = Path.Combine(StaticFilesDirectory, "Reports", "Expenditures.rdl"); var files = new FileInfo(newDirectory); var notif = new ServiceResult <byte[]>(); if (!files.Exists) { notif.AddError("Error", "El Reporte no fue encontrado."); return(notif); } var rv = new LocalReport(newDirectory); var solicitation = _context.ExpenditureProcedure(); if (solicitation.Count() > 0) { rv.AddDataSource("ExpenditureDataSet", new List <ExpenditureProcedureDto>(solicitation)); } else { rv.AddDataSource("ExpenditureDataSet", new List <ExpenditureProcedureDto>() { new ExpenditureProcedureDto() }); } rv.AddDataSource("CommonDataSet", new List <ReportDto>() { new ReportDto() { TodayDate = DateTime.Today.ToShortDateString() } }); System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance); var result = rv.Execute(RenderType.Pdf); return(new ServiceResult <byte[]>(result.MainStream)); }
public IActionResult Print() { var studentsData = GetStudentList(); string mimetype = ""; int extension = 1; var path = $"{this._webHostEnvironment.WebRootPath}\\Reports\\Designer\\StudentReport.rdlc"; var header = new ReportHeader() { Logo = $"{this._webHostEnvironment.WebRootPath}\\Images\\Logo\\logo.png", Title = "Student Information by RDLC Reports" }; Dictionary <string, string> parameters = new Dictionary <string, string>(); //parameters.Add("title", "Student Information by RDLC Report"); LocalReport lr = new LocalReport(path); lr.AddDataSource("ReportHeader", header.ToDataTable()); lr.AddDataSource("Students", studentsData); var result = lr.Execute(RenderType.Pdf, extension, parameters, mimetype); return(File(result.MainStream, "application/pdf")); }
public ServiceResult <byte[]> ReportPrintAsync(Guid solicitationId) { var newDirectory = Path.Combine(StaticFilesDirectory, "Reports", "VR_REPORT.rdl"); var files = new FileInfo(newDirectory); var notif = new ServiceResult <byte[]>(); if (!files.Exists) { notif.AddError("Error", "El Reporte no fue encontrado."); return(notif); } var rv = new LocalReport(newDirectory); var solic = _solicitationSubsidyService.GetByIdSubsidy(solicitationId).Response; if (solic == null) { notif.AddError("Error", "La solicitud no existe"); return(notif); } var destiny = _destinyService.Get_DestiniesProcedure(solicitationId).Response; var images = _solicitationSubsidyService.SolicitationApprovedBySupervisorId(solicitationId, solic.UserId).Response; //var TotalLetter = _context.GetLetterNumberTotalSolicitationAsync(solic.Total.ToString(), ","); rv.AddDataSource("SolicitationDTODataSet", new List <FindByIdSolicitationSubsidyDto>() { solic }); rv.AddDataSource("UserDataSet", new List <UserDto>() { solic.User }); rv.AddDataSource("Destination", destiny); rv.AddDataSource("SignSupervisorImage", new List <UrlSignHolograph>() { images }); rv.AddDataSource("DestinationDataSet", solic.Destinies); rv.AddDataSource("ExpenditureDataSet", solic.Expenditures); rv.AddDataSource("Common", new List <ReportDto>() { new ReportDto() { TodayDate = DateTime.Today.ToString("d") } }); System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance); var result = rv.Execute(RenderType.Pdf); return(new ServiceResult <byte[]>(result.MainStream)); }
public IActionResult Export() { var studentsData = GetStudentList(); string mimetype = ""; int extension = 1; var path = $"{this._webHostEnvironment.WebRootPath}/Reports/Designer/StudentReport.rdlc"; Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("title", "Student Information by RDLC Report"); LocalReport lr = new LocalReport(path); lr.AddDataSource("Students", studentsData); var result = lr.Execute(RenderType.Excel, extension, parameters, mimetype); return(File(result.MainStream, "application/msexcel", "Export.xls")); }
public byte[] GenerateReportAsync(string reportName, DataTable t) { string fileDirPath = Assembly.GetExecutingAssembly().Location.Replace("smarthometec_API.dll", string.Empty); string rdlcFilePath = string.Format("{0}reportes\\{1}.rdlc", fileDirPath, reportName); Encoding.RegisterProvider(CodePagesEncodingProvider.Instance); Encoding.GetEncoding("windows-1252"); LocalReport report = new LocalReport(rdlcFilePath); Debug.WriteLine("llego aca"); report.AddDataSource("DataSet1", t); var result = report.Execute(GetRenderType("pdf")); return(result.MainStream); }
public IActionResult FirstCommunion() { var dt = new DataTable(); dt = GetFirstCommunionInfo(); int extension = 1; var path = $"{this._webHostEnv.WebRootPath}\\Reports\\FirstCommunion.rdlc"; LocalReport localReport = new LocalReport(path); localReport.AddDataSource("dsFirstCommunion", dt); var result = localReport.Execute(RenderType.Pdf, extension); return(File(result.MainStream, "application/pdf")); }
public IActionResult Index() { LocalReport _localReport = new LocalReport("Reports/Report1.rdlc"); List <Report1VM> podaci = GetMatches(_context); DataSet ds = new DataSet(); _localReport.AddDataSource("DataSet1", podaci); Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("ReportSastavio", HttpContext.User.Identity.Name); ReportResult result = _localReport.Execute(RenderType.Pdf, parameters: parameters); return(File(result.MainStream, "application/pdf")); }
public IActionResult Print() { var dt = new DataTable(); dt = GetEmployeeList(); string mimetype = ""; int extension = 1; var path = $"{this._webHostEnvironment.WebRootPath}\\Reports\\rptEmployee.rdlc"; Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("prm", "RDLC Report"); LocalReport localReport = new LocalReport(path); localReport.AddDataSource("dsEmployee", dt); var result = localReport.Execute(RenderType.Pdf, extension, parameters, mimetype); return(File(result.MainStream, "application/pdf")); }
public IActionResult Export() { var dt = new DataTable(); dt = GetEmployeeList(); string mimetype = ""; int extension = 1; var path = $"{this._webHostEnvironment.WebRootPath}\\Reports\\Employees.rdlc"; Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("prm", "RDLC report (Set as parameter)"); LocalReport lr = new LocalReport(path); lr.AddDataSource("dsEmployee", dt); var result = lr.Execute(RenderType.Excel, extension, parameters, mimetype); return(File(result.MainStream, "application/msexcel", "Export.xls")); }
public IActionResult Index() { var user = _signInManager.UserManager.GetUserAsync(User); Korisnik korisnik = ctx.Korisnik.Where(x => x.UserId.Equals(user.Result.Id)).FirstOrDefault(); LocalReport lrp = new LocalReport("Report/Report.rdlc"); List <ReportVM> podaci = getNarudzbe(ctx, _signInManager, User); lrp.AddDataSource("DataSet1", podaci); Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("Korisnik", korisnik.Ime + " " + korisnik.Prezime); ReportResult res = lrp.Execute(RenderType.Pdf, parameters: parameters); return(File(res.MainStream, "application/pdf")); }
// please not this just for demo and test purpos method and need enhancement // it's not support subreports // we can find one better than this public async Task <IActionResult> GenerateReport() { #region generate report using DataTable //var dt = new DataTable(); //dt.Columns.Add("FullName"); //dt.Columns.Add("Email"); //dt.Columns.Add("DateOfBirth"); //dt.Columns.Add("Gender"); //dt.Columns.Add("Department"); //var employeeList = new List<Employee>(); //await employeeRepository.GetEmployees(); //DataRow dr; //foreach (var emp in employeeList) //{ // dr = dt.NewRow(); // dr["FullName"] = $"{emp.FirstName}{emp.LastName} "; // dr["Email"] = emp.Email; // dr["Gender"] = emp.Gender; // dr["Department"] = emp.Department.DepartmentName; // dr["DateOfBirth"] = emp.DateOfBrith; // dt.Rows.Add(dr); //} #endregion var employeeList = await employeeRepository.GetDepartmentsEmployeesAsSP(); var departments = await departmentRepository.GetDepartments(); //var employeeList = await employeeRepository.GetEmployeesAsSP(); string mimeType = ""; int extenstion = 1; //var path = $"{_webHostEnvironment.WebRootPath}\\Reports\\EmployeeReport.rdlc"; var path = $"{_webHostEnvironment.WebRootPath}\\Reports\\EmployeesPerDepartmentReport.rdlc"; Dictionary <string, string> parameters = new Dictionary <string, string>(); //parameters.Add("param", "Blazor RDLC Report"); LocalReport localReport = new LocalReport(path); //localReport.AddDataSource("dsDepartment", departments); localReport.AddDataSource("dsEmployeesPerDepartment", employeeList); var result = localReport.Execute(RenderType.Pdf, extenstion, parameters, mimeType); return(File(result.MainStream, "application/pdf")); }
public IActionResult Get() { string mimtype = ""; int extension = 1; var _reportPath = @"Reports\testeReport.rdlc"; LocalReport localReport = new LocalReport(_reportPath); //Dados System.Data.DataTable dt = new System.Data.DataTable(); dt.Clear(); dt.Columns.Add("Id", typeof(int)); dt.Columns.Add("Name", typeof(string)); dt.Rows.Add(1, "Paulo"); dt.Rows.Add(2, "Jose"); localReport.AddDataSource("DataSet1", dt); //Parametros do relatório var reportParams = new Dictionary <string, string>(); //reportParams.Add("Key1", "value1"); //reportParams.Add("Key2", "value2"); if (reportParams != null && reportParams.Count > 0)// if you use parameter in report { List <ReportParameter> reportparameter = new List <ReportParameter>(); foreach (var record in reportParams) { reportparameter.Add(new ReportParameter()); } } //Geração do arquivo System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance); var result = localReport.Execute(RenderType.Pdf, extension, parameters: reportParams); byte[] file = result.MainStream; Stream stream = new MemoryStream(file); return(File(stream, "application/pdf", "testeReport.pdf")); }
public IActionResult GenerarPDFAnticipo(int id) { Guid guid = Guid.NewGuid(); _log.RegistrarEvento($"{guid}{Environment.NewLine}{JsonConvert.SerializeObject(id)}"); //ES MOMENTANEO SE DEBE ELIMINAR GenerarPDFAnticipoResponseDTO response = _AnticipoService.GenerarPDF(id); try { string mimetype = ""; int extension = 1; var path = $"{_webHostEnvironment.ContentRootPath}\\Reportes\\rptAnticipo.rdlc"; LocalReport lr = new LocalReport(path); Dictionary <string, string> parameters = new Dictionary <string, string>(); lr.AddDataSource("dsAnticipo", Util.ToDataTable(response.resultado)); var result = lr.Execute(RenderType.Pdf, extension, parameters, mimetype); return(File(result.MainStream, "application/pdf")); } catch (ResultException ex) { response.Result = new Result() { Success = true, ErrCode = ex.Result.ErrCode, Message = ex.Result.Message }; } catch (Exception ex) { response.Result = new Result() { Success = false, Message = "Ocurrio un problema en el servicio, intentelo nuevamente." }; _log.RegistrarEvento(ex, guid.ToString()); } _log.RegistrarEvento($"{guid}{Environment.NewLine}{JsonConvert.SerializeObject(response)}"); return(Ok(response)); }
public IActionResult DailyReport() { var dt = _stationXRepo.FindAll(); string mimetype = ""; int extension = 1; var path = $@"{this._webHostEnvironment.WebRootPath}\Reports\DailyReport.rdlc"; Dictionary <string, string> param = new Dictionary <string, string>(); param.Add("param", "Station Pusat Daily Reports"); LocalReport localReport = new LocalReport(path); localReport.AddDataSource("dsStationX", dt); var result = localReport.Execute(RenderType.Pdf, extension, param, mimetype); return(File(result.MainStream, "application/pdf")); }
public byte[] GenerateReportAsync(string reportName, string reportType, string dsName = null, object reportList = null) { string fileDirPath = Assembly.GetExecutingAssembly().Location.Replace("ReportApi.dll", string.Empty); string rdlcFilePath = $"{fileDirPath}ReportFiles\\{reportName}.rdlc"; var parameters = new Dictionary <string, string>(); Encoding.RegisterProvider(CodePagesEncodingProvider.Instance); Encoding.GetEncoding("windows-1252"); var report = new LocalReport(rdlcFilePath); if (dsName != null && reportList != null) { report.AddDataSource(dsName, reportList); } var result = report.Execute(GetRenderType(reportType), 1, parameters); return(result.MainStream); }
public byte[] GenerateReportAsync(string reportName, DataTable datos, string nombre, string apellido1, string apellido2) { string fileDirPath = Assembly.GetExecutingAssembly().Location.Replace("smarthometec_API.dll", string.Empty); string rdlcFilePath = string.Format("{0}reportes\\{1}.rdlc", fileDirPath, reportName); Dictionary <string, string> parameters = new Dictionary <string, string>(); Encoding.RegisterProvider(CodePagesEncodingProvider.Instance); Encoding.GetEncoding("windows-1252"); LocalReport report = new LocalReport(rdlcFilePath); Debug.WriteLine("llego aca"); report.AddDataSource("DataSet1", datos); parameters.Add("nombre", nombre + " " + apellido1 + " " + apellido2); var result = report.Execute(GetRenderType("pdf"), 1, parameters); return(result.MainStream); }
public IActionResult Index() { LocalReport _localReport = new LocalReport("Reporti/Report1.rdlc"); List <Report1Model> podaci = getStudenti(_db); DataSet ds = new DataSet(); _localReport.AddDataSource("DataSet1", podaci); Dictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("ReportSastavio", HttpContext.LogiraniKorisnik().ImePrezime); //ReportResult result = _localReport.Execute(RenderType.ExcelOpenXml, parameters: parameters); //return File(result.MainStream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); ReportResult result = _localReport.Execute(RenderType.Pdf, parameters: parameters); return(File(result.MainStream, "application/pdf")); }