public ActionResult CalculateScheduleLoan(int id = 0, int loantypeid = 0)
{
var result = services.FilterAllLoanSchedule(id, loantypeid);
var stream = new MemoryStream();
int row = 2;
using (var package = new ExcelPackage(stream))
{
var workSheet = package.Workbook.Worksheets.Add("Sheet2");
workSheet.Cells.LoadFromCollection(result, true);
package.Save();
}
string excelname = "LoanShedule.xlsx";
stream.Position = 0;
string excelName = $"LoanSchedule-{DateTime.Now.ToString("yyyyMMddHHmmssfff")}.xlsx";
return(File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelname));
}
public async Task <IActionResult> CalaculateLoanRepayment(int id = 0, int loantypeid = 0)
{
var result = services.FilterAllLoanSchedule(id, loantypeid);
var result2 = services.GetLoan(id, loantypeid);
var result3 = services.getLoanCount(id, loantypeid);
var gh = new LoanRepaymentViewModel();
if (result3 == 0)
{
gh.solly = FilterRecord(result, result3);
return(await generatePdf.GetPdf("Views/LoanRegister/loanRepaymentReport.cshtml", gh));
}
gh.solly = FilterRecord(result, result3);
gh.Name = result2.Name;
gh.Email = result2.Email;
gh.interest = result2.interest;
gh.Tenor = result2.Tenor;
gh.AmountGranted = result2.AmountGranted;
gh.Rank = result2.Rank;
return(await generatePdf.GetPdf("Views/LoanRegister/loanRepaymentReport.cshtml", gh));
}