public async Task <List <Database.SupplierRequest> > FetchSupplierReport(SupplierReportViewModel supplierReportViewModel)
{
DateTime startDate = Convert.ToDateTime(supplierReportViewModel.StartDate);
DateTime endDate = Convert.ToDateTime(supplierReportViewModel.EndDate);
return(await context.SupplierRequest.Where(x => x.IsActive.Value && !x.IsDeleted && (x.CreatedOn >= startDate && x.CreatedOn <= endDate)).Include(x => x.SuplierTypeRequest).Include(x => x.RequestTypeMaster).Include(x => x.SupplierRequestApprovalLog).ThenInclude(x => x.RoleApprovalMaster).ThenInclude(x => x.Role).Include(x => x.SupplierRequestCategoryMapping).ThenInclude(x => x.CategoryMaster).OrderByDescending(x => x.SupplierRequestId).ToListAsync());
}
public IActionResult FetchSupplierReport(SupplierReportViewModel supplierReportViewModel)
{
if (ModelState.IsValid)
{
return(RedirectToAction("FetchSupplierReportData", supplierReportViewModel));
}
return(View("SupplierReportList", supplierReportViewModel));
}
public async Task <List <Database.SupplierRequest> > FetchSupplierReport(SupplierReportViewModel supplierReportViewModel)
{
return(await this._context.SupplierRequest.FetchSupplierReport(supplierReportViewModel));
}
public async Task <IActionResult> FetchSupplierReportData(SupplierReportViewModel supplierReportViewModel)
{
supplierReportViewModel.SupplierRequests = await this.supplierRequest.FetchSupplierReport(supplierReportViewModel);
return(View("SupplierReportList", supplierReportViewModel));
}
public IActionResult SupplierReport()
{
SupplierReportViewModel supplierReportViewModel = new SupplierReportViewModel();
return(View("SupplierReportList", supplierReportViewModel));
}
