public IActionResult Index(int pageNumber = 1, AccountPayrollFilterViewModel filter = default(AccountPayrollFilterViewModel))
{
var pagingInfo = new PagingInfo()
{
PageNumber = pageNumber
};
var results =
_accountPayrollRepository
.GetAll(filter.FirstName, filter.LastName, filter.SSN, filter.MinDate, filter.MaxDate, filter.EmployeeNumber, out int resultCount, pageNumber,
AppSettings.PageSize)
.ToList();
pagingInfo.Total = resultCount;
ViewBag.FilterViewModel = filter;
return(View(results.ToMappedPagedList <AccountPayroll, AccountPayrollViewModel>(pagingInfo)));
}
public MemoryStream GetAccountPayroll(string firstName, string lastName, decimal sSN, DateTime?minDate, DateTime?maxDate, decimal employeeNumber, out int resultCount, int pageNumber = 1, int pageSize = 50)
{
string excelTemplate = GetExcelTemplate(ReportType.AccountPayroll);
var templateFile = new FileInfo(excelTemplate);
ExcelPackage package = new ExcelPackage(templateFile, true);
GenerateAccountPayrollReportExcel(
package,
_accountPayrollRepository.GetAll(firstName, lastName, sSN, minDate, maxDate, employeeNumber, out resultCount, pageNumber, pageSize)
.ToList());
var stream = new MemoryStream(package.GetAsByteArray());
return(stream);
}