public async Task <IEnumerable <HeytourJob> > GetJobs(JobsFilterParameters filter)
{
/* var jobs = new List<HeytourJob>()
*
* {
* {new HeytourJob { Id = 1, IsActive = true, Title = "Fu Er Dai", Location="Watchtower, Washington", Company ="QUORDATE", Email="*****@*****.**", Industry="Rich", JobDesc="Veniam laborum veniam commodo veniam nisi commodo. Culpa elit qui deserunt adipisicing ad dolor proident laboris adipisicing tempor eu. Elit do non occaecat exercitation ullamco deserunt. Aliquip labore consectetur elit id. Voluptate cupidatat dolore eiusmod labore eu. Consectetur ipsum mollit tempor eiusmod id ipsum sit.", Picture="https://picsum.photos/300/301", PostedOn=DateTime.Parse("2020-12-11T04:48:37") } },
* {new HeytourJob { Id = 2, IsActive = true, Title = "Project Engineer", Location="Concho, Oregon", Company ="TROPOLIS", Email="*****@*****.**", Industry="Engineering", JobDesc="Pariatur enim labore dolore aliqua voluptate non eiusmod dolor quis quis. Fugiat labore enim laborum labore aliqua occaecat minim ut. Reprehenderit est reprehenderit consectetur do. Nisi qui sint quis culpa velit ea. Commodo veniam sit laborum ipsum in. Cupidatat ullamco voluptate elit et exercitation amet sunt et exercitation voluptate in in nisi velit.", Picture="https://picsum.photos/300/302", PostedOn=DateTime.Parse("2020-12-11T05:43:37") } },
* {new HeytourJob { Id = 3, IsActive = true, Title = "Corporate Advisory", Location="Cliff, Federated States Of Micronesia", Company ="ACIUM", Email="*****@*****.**", Industry="Finance", JobDesc="Proident sit nulla id Lorem laboris qui irure occaecat. Labore eu minim fugiat nisi ea sunt velit pariatur officia consectetur ea proident veniam tempor. Elit do cupidatat dolor elit.", Picture="https://picsum.photos/300/303", PostedOn=DateTime.Parse("2020-10-07T08:11:37") } },
* {new HeytourJob { Id = 4, IsActive = false, Title = "Senior Software Engineer", Location="Websterville, Virgin Islands", Company ="ANDERSHUN", Email="*****@*****.**", Industry="IT", JobDesc="Nostrud in fugiat consequat et voluptate pariatur aliquip in quis velit eiusmod. Do in commodo aliquip id exercitation veniam sunt. Nulla dolore ipsum elit veniam ut et et veniam aliqua. Ea Lorem veniam proident aliqua elit elit eiusmod sunt in elit nisi sint.", Picture="https://picsum.photos/300/304", PostedOn=DateTime.Parse("2020-11-12T02:44:00") } },
* {new HeytourJob { Id = 5, IsActive = false, Title = "Marketing Executive", Location="Clarence, Indiana", Company ="QUARMONY", Email="*****@*****.**", Industry="Marketing", JobDesc="Sunt exercitation duis nostrud culpa Lorem adipisicing deserunt fugiat pariatur ipsum laboris consequat quis velit. Ea commodo anim Lorem laborum cupidatat deserunt aliqua. Adipisicing velit nostrud ipsum proident id consequat aliquip nisi eu nostrud dolor. Culpa nulla sunt aliquip do voluptate ex elit elit commodo nostrud occaecat proident amet. Esse commodo consectetur est labore esse duis sunt labore nulla culpa cillum culpa ex sint. Enim fugiat proident laboris magna laboris est excepteur labore ad non labore ut.", Picture="https://picsum.photos/300/305", PostedOn=DateTime.Parse("2020-05-21T05:47:12") } },
* {new HeytourJob { Id = 6, IsActive = true, Title = "Test Analyst", Location="Sattley, Pennsylvania", Company ="UNQ", Email="*****@*****.**", Industry="IT", JobDesc="Officia incididunt ad id laborum aliqua laboris labore amet irure duis et ex consequat elit. Dolore ut consectetur eiusmod deserunt laborum non consectetur magna est incididunt nisi eu magna eiusmod. Do ad dolore adipisicing consectetur incididunt veniam sit cillum. Ullamco exercitation Lorem eiusmod esse minim Lorem veniam aliquip culpa.", Picture="https://picsum.photos/300/306", PostedOn=DateTime.Parse("2020-12-12T04:19:40") } },
* {new HeytourJob { Id = 7, IsActive = false, Title = "Teacher Aide", Location="Hoagland, Oklahoma", Company ="CAXT", Email="*****@*****.**", Industry="Education", JobDesc="Ea nostrud reprehenderit dolore magna duis Lorem qui deserunt ipsum nisi nulla voluptate non. Sunt id reprehenderit nulla officia consequat aute incididunt ut excepteur occaecat excepteur incididunt. Voluptate non nostrud enim proident incididunt commodo culpa enim incididunt ut est sint labore magna. Ipsum aliqua consectetur nostrud laborum minim velit.", Picture="https://picsum.photos/300/307", PostedOn=DateTime.Parse("2020-12-13T02:43:09") } },
* }; */
//这些query方法是数据库直接还给结果 ,jobs是table
var query = _jobDbContext.Jobs;
if (filter.IsActive.HasValue)
{
query.Where(j => j.IsActive == filter.IsActive);
}
if (filter.PostedOn != default)
{
query.Where(j => j.PostedOn > filter.PostedOn);
}
if (!string.IsNullOrWhiteSpace(filter.Title))
{
query.Where(j => j.Title.Contains(filter.Title));
}
var jobs = await query.ToListAsync();
return(jobs);
}
[HttpGet] //api/heytour
public async Task <ActionResult <IEnumerable <Heytour> > > GetJobsList(
[FromQuery] JobsFilterParameters parameters
)
{
var jobs = await _jobService.GetJobsList(parameters);
return(jobs.ToList());
}
[HttpGet] //api/jobs
public async Task <ActionResult <IEnumerable <HeytourJob> > > GetJobsList(
//[FromQuery] JobsFilterParameters parameters
)
{
_ = DateTime.TryParse(HttpContext.Request.Query["postedon"].ToString(), out DateTime postedOn);
var filter = new JobsFilterParameters
{
IsActive = HttpContext.Request.Query["isActive"].ToString() == "true",
PostedOn = postedOn,
Title = HttpContext.Request.Query["title"].ToString()
};
var jobs = await _jobService.GetJobsList(filter);
return(jobs.ToList());
}
//然后在 GetJobsList方法内部使用这个依赖
public async Task <IEnumerable <Heytour> > GetJobsList(JobsFilterParameters parameters)
{
IEnumerable <Heytour> jobs = null;
var joblist = _jobRepo.GetJobs();
if (parameters.IsActive.HasValue)
{
jobs = joblist.Where(m => m.IsActive == parameters.IsActive.Value).ToList();
}
else
{
jobs = joblist;
}
return(jobs);
}
//然后在 GetJobsList方法内部使用这个依赖
public async Task <IEnumerable <HeytourJob> > GetJobsList(JobsFilterParameters parameters)
{
/*IEnumerable<HeytourJob> jobs = null;
* if (parameters.IsActive.HasValue)
* {
* jobs = await Task.Run(() => _jobRepo.GetJobs().Where(x => x.IsActive == parameters.IsActive).ToList());
*
* }
* else if (parameters.PostedOn.HasValue)
* {
* jobs = await Task.Run(() => _jobRepo.GetJobs().Where(x => x.PostedOn == parameters.PostedOn).ToList());
* }
* else
* {
* jobs= await Task.Run(() => _jobRepo.GetJobs().ToList());
* }*/
var jobs = await _jobRepo.GetJobs(parameters);
return(jobs);
}