public async Task <IActionResult> GetReportJobSeeker([FromQuery] JobSeekerReport jsReport) { var result = await repo.GetJobSeekerReport(jsReport); if (result != null) { return(Ok(result)); } return(BadRequest("Error in saving employee")); }
// Get job-seeker report public async Task <IEnumerable <JobSeeker> > GetJobSeekerReport(JobSeekerReport jsReport = null) { if (jsReport.Education == "education" && jsReport.Sector == "sector" && jsReport.State == "state" && jsReport.Type == "type") { var resultAll = context.JobSeekers.Where(j => j.IsCreated >= jsReport.StartDate && j.IsCreated <= jsReport.FinishDate); return(resultAll); } if (jsReport.Education != null && jsReport.Sector == "sector" && jsReport.State == "state" && jsReport.Type == "type") { var resultAll = context.JobSeekers.Where(j => j.minEduLvl == jsReport.Education); return(resultAll); } if (jsReport.Education == "education" && jsReport.Sector != null && jsReport.State == "state" && jsReport.Type == "type") { var resultAll = context.JobSeekers.Where(j => j.Sector == jsReport.Sector); return(resultAll); } if (jsReport.Education == "education" && jsReport.Sector == "sector" && jsReport.State != null && jsReport.Type == "type") { var resultAll = context.JobSeekers.Where(j => j.State == jsReport.State); return(resultAll); } if (jsReport.Education == "education" && jsReport.Sector == "sector" && jsReport.State == "state" && jsReport.Type != null) { var resultAll = context.JobSeekers.Where(j => j.Type == jsReport.Type); return(resultAll); } var result = await context.JobSeekers.Where( j => j.minEduLvl == jsReport.Education && j.Sector == jsReport.Sector && j.State == jsReport.State && j.Type == jsReport.Type && j.IsCreated >= jsReport.StartDate && j.IsCreated <= jsReport.FinishDate ).ToListAsync(); return(result); }