public async Task <IEnumerable <ReportResponseDto> > GetReportsAsync(ApplicationSearchFilterDto filter) { var reports = await this.dbContext .Applications .FilterApplications(filter) .ProjectTo <ReportResponseDto>(this.mapper.ConfigurationProvider) .OrderBy(x => x.FirstName) .ToListAsync(); return(reports); }
public async Task <IActionResult> ExportExcel([FromQuery] ApplicationSearchFilterDto filter) { var reports = await this.reportService.GetReportsAsync(filter); return(this.ConvertToExcel(reports)); }
public async Task <IEnumerable <ReportResponseDto> > GetReports([FromQuery] ApplicationSearchFilterDto filter) { return(await this.reportService.GetReportsAsync(filter)); }
public static IQueryable <Application> FilterApplications(this IQueryable <Application> applications, ApplicationSearchFilterDto filter) { if (!string.IsNullOrEmpty(filter.FirstName)) { applications = applications.Where(app => app.FirstName.ToLower().Contains(filter.FirstName.ToLower())); } if (!string.IsNullOrEmpty(filter.LastName)) { applications = applications.Where(app => app.LastName.ToLower().Contains(filter.LastName.ToLower())); } if (!string.IsNullOrEmpty(filter.City)) { applications = applications.Where(app => app.City.ToLower().Contains(filter.City.ToLower())); } if (!string.IsNullOrEmpty(filter.Municipality)) { applications = applications.Where(app => app.Municipality.ToLower().Contains(filter.Municipality.ToLower())); } if (!string.IsNullOrEmpty(filter.Region)) { applications = applications.Where(app => app.Region.ToLower().Contains(filter.Region.ToLower())); } if (filter.Status.HasValue) { applications = applications.Where(app => app.Status == filter.Status.Value); } return(applications); }
public async Task <IActionResult> ExportExcel([FromQuery] ApplicationSearchFilterDto filter) { var applications = await this.appService.GetAllApplicationsAsync(filter); return(this.ConvertToExcel(applications)); }
public async Task <IEnumerable <ApplicationResponseDto> > GetApplications([FromQuery] ApplicationSearchFilterDto filter) { return(await this.appService.GetAllApplicationsAsync(filter)); }