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)); }