Esempio n. 1
0
        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);
        }