public IActionResult Index(int pageNumber = 1, VenderWarrentFilterViewModel filter = default(VenderWarrentFilterViewModel))
{
var pagingInfo = new PagingInfo()
{
PageNumber = pageNumber
};
var results =
_accountPayableRepository
.GetAll(filter.VendorId, filter.Name, filter.Representative, filter.MinPayDate, filter.MaxPayDate, out int resultCount, pageNumber,
AppSettings.PageSize)
.ToList();
pagingInfo.Total = resultCount;
ViewBag.FilterViewModel = filter;
return(View(results.ToMappedPagedList <VenderWarrent, VenderWarrentViewModel>(pagingInfo)));
}
public MemoryStream GetAccountsPayable(string vendorId, string name, string representative, DateTime?minPayDate, DateTime?maxPayDate, out int resultCount, int pageNumber = 1, int pageSize = 50)
{
string excelTemplate = GetExcelTemplate(ReportType.AccountPayable);
var templateFile = new FileInfo(excelTemplate);
ExcelPackage package = new ExcelPackage(templateFile, true);
GenerateAccountPayableReportExcel(package, _accountPayableRepository.GetAll(
vendorId, name, representative, minPayDate, maxPayDate, out resultCount, pageNumber, pageSize).ToList());
var stream = new MemoryStream(package.GetAsByteArray());
return(stream);
}
