public ActionResult JournalVoucherReport() { var viewmodel = new ReportFiltersViewModel(); viewmodel.MonthlyReportRules = _journalVoucherRuleService.GetAll(); viewmodel.MonthlyImportExceptionRule = _monthlyImportExceptionRuleService.GetAll(); return(View(viewmodel)); }
public ActionResult JournalVoucherReport(ReportFiltersViewModel viewmodel) { if (ModelState.IsValid) { if (viewmodel.ExcelFile != null && viewmodel.ExcelFile.ContentLength > 0) { SaveUploadedFile(viewmodel.ExcelFile, Server.MapPath("~/Uploads/WarrantReport/")); viewmodel.MonthlyImportExceptionRule = _monthlyImportExceptionRuleService.GetAll(); MemoryStream stream = _journalVoucherReportUseCase.Execute(viewmodel.ExcelFile.InputStream, viewmodel.Date.Value.Year, viewmodel.MonthlyImportExceptionRule); return(File(stream, Constants.ExcelFilesMimeType, string.Format(Constants.JournalVoucherReportExcelFileName, viewmodel.Date.Value.Year))); } } return(View(viewmodel)); }
public ActionResult GenerateReportTest(ReportFiltersViewModel rep) { string SQL = "SELECT " + "l.nome AS Localidade, " + "i.patrimonio AS Patrimonio, " + "c.nome AS Categoria, " + "s.nome AS Status " + "FROM " + "localidade l INNER JOIN item i on l.id = i.localidade " + "INNER JOIN item_categoria c ON c.id = i.categoria " + "INNER JOIN item_status s ON s.id = i.status"; string WHERE = " "; bool GotBeforeFilter = false; if (rep.LOC.ID > 0 || rep.ITEMCAT.ID > 0 || rep.STA.Id > 0) { WHERE += " WHERE "; if (rep.LOC.ID > 0) { WHERE += " l.id = " + rep.LOC.ID; GotBeforeFilter = true; } if (rep.ITEMCAT.ID > 0) { if (GotBeforeFilter) { WHERE += " AND "; } WHERE += " c.id = " + rep.ITEMCAT.ID; GotBeforeFilter = true; } if (rep.STA.Id > 0) { if (GotBeforeFilter) { WHERE += " AND "; } WHERE += " s.id = " + rep.STA.Id; } } string ORDER = " ORDER BY 1,3,4"; // implementar opção para o usuário escolher via DropDownList SQL += WHERE + ORDER; List <string> fields = new List <string>(); fields.Add("Localidade"); fields.Add("Patrimonio"); fields.Add("Categoria"); fields.Add("Status"); Relatorio rel = new Relatorio( SQL, 4, fields, "Itens", "Listagem de itens", "" ); return(rel.GenerateReport()); }