public byte[] HistoricoAcademico(int pIdUsuario) { if (autenticacao == null || !(segurancaAutenticacao.AutenticaUsuario(autenticacao))) { throw new Exception("Usuário não autenticado pelo sistema."); } using (RelatorioHistoricoAcademico relHisAcad = new RelatorioHistoricoAcademico()) { relHisAcad.RegistrarLog(); var DadosGerais = relHisAcad.ConsultarHistoricoAcademicoDadosGerais(pIdUsuario); var lstCursos = relHisAcad.ConsultaHistoricoAcademicoCursos(pIdUsuario); var lstSGTC = relHisAcad.ConsultaHistoricoAcademicoSGTC(pIdUsuario); var lstExtracurricular = relHisAcad.ConsultarHistoricoAcademicoExtracurricular(pIdUsuario); var lstPrograma = relHisAcad.ConsultarHistoricoAcademicoPrograma(pIdUsuario); var lstTrilha = relHisAcad.ConsultarHistoricoAcademicoTrilha(pIdUsuario); ReportViewer rv = new ReportViewer(); Assembly assembly = Assembly.LoadFrom(_binPath + "\\Sebrae.Academico.Reports.dll"); Stream stream = assembly.GetManifestResourceStream("Sebrae.Academico.Reports.HistoricoAcademico.rptHistoricoAcademico.rdlc"); rv.LocalReport.LoadReportDefinition(stream); rv.LocalReport.DataSources.Clear(); rv.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", DadosGerais)); rv.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", lstCursos)); rv.LocalReport.DataSources.Add(new ReportDataSource("DataSet3", lstTrilha)); rv.LocalReport.DataSources.Add(new ReportDataSource("DataSet4", lstPrograma)); rv.LocalReport.DataSources.Add(new ReportDataSource("DataSet5", lstExtracurricular)); rv.LocalReport.DataSources.Add(new ReportDataSource("DataSet6", lstSGTC)); rv.LocalReport.Refresh(); return(rv.LocalReport.Render("PDF")); } }
private void GerarRelatorioHistoricoAcademico(int pIdUsuario) { using (RelatorioHistoricoAcademico relHisAcad = new RelatorioHistoricoAcademico()) { var DadosGerais = relHisAcad.ConsultarHistoricoAcademicoDadosGerais(pIdUsuario); var lstCursos = relHisAcad.ConsultaHistoricoAcademicoCursos(pIdUsuario); var lstExtracurricular = relHisAcad.ConsultarHistoricoAcademicoExtracurricular(pIdUsuario); var lstPrograma = relHisAcad.ConsultarHistoricoAcademicoPrograma(pIdUsuario); var lstTrilha = relHisAcad.ConsultarHistoricoAcademicoTrilha(pIdUsuario); RelatoriosHelper.GerarReportViewerHistoricoAcademicoPDF("HistoricoAcademico.rptHistoricoAcademico.rdlc", DadosGerais, lstCursos, lstTrilha, lstPrograma, lstExtracurricular); } }