private RelatorioAtividades getRelatorio() { var rpt = new RelatorioAtividades(); string contentRootPath = _hostingEnvironment.ContentRootPath; rpt.BasePath = contentRootPath; rpt.PageTitle = "SISTEMA DE CONTROLE DE TCC"; rpt.PageSubTitle = "Coordenação do Bacharelado de Sistemas de Informação - CBSI"; rpt.ImprimirCabecalhoPadrao = true; rpt.ImprimirRodapePadrao = true; return(rpt); }
public ActionResult Preview(int filterSemestre) { RelatorioAtividades rpt = getRelatorio(); string semestre = ""; List <Tcc> tccs = null; List <Banca> bancas = null; if (filterSemestre > 0) { tccs = _context.Tccs.Where(x => x.StatusId == 3).ToList(); bancas = new List <Banca>(); foreach (Tcc tcc in tccs) { tcc.Usuario = _context.Usuario.Where(x => x.Id.Equals(tcc.UsuarioId)).FirstOrDefault(); Banca banca = _context.Banca.Where(x => x.TccId == tcc.TccId && x.TipoUsuarioId == 7).FirstOrDefault(); banca.Usuario = _context.Usuario.Where(x => x.Id.Equals(banca.UsuarioId)).FirstOrDefault(); bancas.Add(banca); } Calendario calendario = _context.Calendario.Where(x => x.CalendarioId == filterSemestre).FirstOrDefault(); if (calendario != null) { semestre = calendario.Ano + "." + calendario.Semestre; } tccs = tccs.Where(x => x.DataApresentacao >= calendario.DataInicio && x.DataApresentacao <= calendario.DataFim).ToList(); var calendarios = _context.Calendario.Select(x => new { Value = x.CalendarioId, Text = string.Format("{0}.{1}", x.Ano, x.Semestre) }).ToList(); //calendarios.Add(new { Value = -1, Text = "Sem data" }); ViewBag.Semestre = new SelectList(calendarios.OrderByDescending(x => x.Text), "Value", "Text", filterSemestre); } else if (filterSemestre == -1) { tccs = tccs.Where(x => x.DataApresentacao == null).ToList(); var calendarios = _context.Calendario.Select(x => new { Value = x.CalendarioId, Text = string.Format("{0}.{1}", x.Ano, x.Semestre) }).ToList(); //calendarios.Add(new { Value = -1, Text = "Sem data" }); ViewBag.Semestre = new SelectList(calendarios.OrderByDescending(x => x.Text), "Value", "Text", filterSemestre); } else { var calendarios = _context.Calendario.Select(x => new { Value = x.CalendarioId, Text = string.Format("{0}.{1}", x.Ano, x.Semestre) }).ToList(); //calendarios.Add(new { Value = -1, Text = "Sem data" }); ViewBag.Semestre = new SelectList(calendarios.OrderByDescending(x => x.Text), "Value", "Text"); } return(File(rpt.GetOutput(tccs, bancas, semestre).GetBuffer(), "application/pdf")); }