public ActionResult Details(string[] areas, string data, string query, string action) { try { QueryConfig queries = _reportService.GetQueries(); ViewBag.Queries = queries.GetQueries(); var fylker = _registerService.GetFylker(); var kommuner = _registerService.GetKommuner(); ViewBag.fylker = fylker; ViewBag.kommuner = kommuner; Dictionary <string, string> codeList = new Dictionary <string, string>(); codeList = fylker.Union(kommuner).ToDictionary(k => k.Key, v => v.Value); ViewBag.selectedAreas = areas; ViewBag.data = data; var queryConfig = queries.GetQuery(query, data); ViewBag.query = queryConfig; ReportQuery reportQuery = new ReportQuery(); reportQuery.Parameters = new List <ReportQueryParameter>(); reportQuery.QueryName = queryConfig.Value; foreach (string area in areas) { reportQuery.Parameters.Add(new ReportQueryParameter { Name = "area", Value = area }); } reportQuery.Parameters.Add(new ReportQueryParameter { Name = "data", Value = data }); ReportResult result = _reportService.GetQueryResult(reportQuery); if (action == "Excel") { var fileStream = new ExcelReportGenerator().CreateExcelSheet(reportQuery, result, codeList); var fileStreamResult = new FileStreamResult(fileStream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); fileStreamResult.FileDownloadName = "Rapport-" + query + ".xlsx"; return(fileStreamResult); } else { return(View(result)); } } catch (Exception ex) { Log.Error(ex); return(View("Error")); } }
public ActionResult Index() { try { QueryConfig queries = _reportService.GetQueries(); ViewBag.Queries = queries.GetQueries(); ViewBag.fylker = _registerService.GetFylker(); ViewBag.kommuner = _registerService.GetKommuner(); ViewBag.selectedAreas = new string[] {}; } catch (Exception ex) { Log.Error(ex); return(View("Error")); } return(View()); }