public MemoryStream GetFundsTemplate(int year) { string excelTemplate = GetExcelTemplate(ReportType.FundsTemplate); var templateFile = new FileInfo(excelTemplate); ExcelPackage package = new ExcelPackage(templateFile, true); GenerateFundsTemplate(package, _fundService.GetAllFunds(year, DbSource.ALL), year); var stream = new MemoryStream(package.GetAsByteArray()); return(stream); }
public ActionResult Index(YearFilterViewModel filters, int page = 1) { var pagingInfo = new PagingInfo() { PageNumber = page }; var entities = Enumerable.Empty <Fund>(); // keep track of filter across if (filters != null && !filters.IsEmpty) { TempData[FilterDateKey] = filters; } else { if (TempData.Peek(FilterDateKey) != null) { filters = TempData.Peek(FilterDateKey) as YearFilterViewModel; } } if (filters.Year.HasValue) { entities = _fundService.GetAllFunds(filters.Year.Value, filters.DbSource, filters.DisplayName, filters.FundNumber, null, pagingInfo); } var viewmodel = entities.ToMappedPagedList <Fund, FundDetailsViewModel>(pagingInfo); ViewBag.FilterViewModel = filters; ViewBag.AvailableDbSources = new List <SelectListItem>() { new SelectListItem() { Text = DbSource.GC.ToString(), Value = ((int)DbSource.GC).ToString() }, new SelectListItem() { Text = DbSource.DIST.ToString(), Value = ((int)DbSource.DIST).ToString() } }; return(View(viewmodel)); }