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"));
}
