public QueryResult ListOpenJobPost(JobPostQueryParamArg jobPostQueryParamArg, QueryParamArg queryParamArg)
{
return
(ModelManagementContext()
.JobPosts.Where(
t =>
t.IsActive == "Y" &&
(string.IsNullOrEmpty(jobPostQueryParamArg.Sex) || t.Sex == jobPostQueryParamArg.Sex) &&
(string.IsNullOrEmpty(jobPostQueryParamArg.JobLocation) ||
t.JobLocation == jobPostQueryParamArg.JobLocation) &&
(jobPostQueryParamArg.AgeFrom == null || t.AgeFrom >= jobPostQueryParamArg.AgeFrom) &&
(jobPostQueryParamArg.AgeThru == null || t.AgeThru <= jobPostQueryParamArg.AgeThru) &&
(jobPostQueryParamArg.HeightFrom == null || t.HeightFrom >= jobPostQueryParamArg.HeightFrom) &&
(jobPostQueryParamArg.HeightThru == null || t.HeightThru <= jobPostQueryParamArg.HeightThru) &&
(jobPostQueryParamArg.JobLocations.Count == 0 ||
jobPostQueryParamArg.JobLocations.Contains(t.JobLocationGeoId)) &&
(string.IsNullOrEmpty(jobPostQueryParamArg.StatusId) ||
jobPostQueryParamArg.StatusId == t.StatusId) &&
(string.IsNullOrEmpty(queryParamArg.SearchText) ||
t.JobTitle.Contains(queryParamArg.SearchText) ||
t.JobDescription.Contains(queryParamArg.SearchText)))
.QueryResultList <JobPostListModel>(queryParamArg));
}
public ListOpenJobPostQuery()
{
JobPostQueryParamArg = new JobPostQueryParamArg();
}