How to bind Table data with related filters in IQueryable method

Rishi Tiwari

6y881.NET

I have created this method need to access in my code

This is a my repositoty calss method

public IQueryable GetJobs(string q = "", int pageIndex = 1, int pageCount = 20, JobsSortOptions sortBy = JobsSortOptions.jobId, JobStatus jobStatus = JobStatus.active, JobsSortByDate sortByDate = JobsSortByDate.date)
{
IQueryable jobs = from j in _context.Jobs
select j;
if (!String.IsNullOrEmpty(q))
{
jobs = jobs.Where(j => j.JobTitle.Contains(q)
|| j.JobId.ToString().Contains(q)
|| j.ReqQual.Contains(q));
}
switch (q)
{
case "name_desc":
jobs = jobs.OrderByDescending(j => j.JobId);
break;
case "Date":
jobs = jobs.OrderBy(j => j.JobId);
break;
case "date_desc":
jobs = jobs.OrderByDescending(j => j.OpenDt);
break;
}
//(pageIndex, pageCount)
return jobs;
// var getJobDetails = _context.Jobs.Where(j => j.JobTitle.Contains(q));
//throw new NotImplementedException();
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
hi

your code looking good .But place a break point and also use try catch .so can get the error ,message.

Thanks and regards
Rishi Tiwari6y ago
Hi,

I am Created one repository interface
public interface IJobsRepository
{
IQueryable GetJobs(string q = "", int pageIndex = 1, int pageCount = 20, JobsSortOptions sortBy = JobsSortOptions.jobId, JobStatus jobStatus= JobStatus.active, JobsSortByDate sortByDate= JobsSortByDate.date);
Then I have create one repository class. and i want to implement.
public IQueryable GetJobs(string q = "", int pageIndex = 1, int pageCount = 20, JobsSortOptions sortBy = JobsSortOptions.jobId, JobStatus jobStatus = JobStatus.active, JobsSortByDate sortByDate = JobsSortByDate.date)
{
IQueryable jobs = from j in _context.Jobs
select j;
if (!String.IsNullOrEmpty(q))
{
jobs = jobs.Where(j => j.JobTitle.Contains(q)
|| j.JobId.ToString().Contains(q)
|| j.ReqQual.Contains(q));
}
switch (q)
{
case "name_desc":
jobs = jobs.OrderByDescending(j => j.JobId);
break;
case "Date":
jobs = jobs.OrderBy(j => j.JobId);
break;
case "date_desc":
jobs = jobs.OrderByDescending(j => j.OpenDt);
break;
}
//(pageIndex, pageCount)
return jobs;
// var getJobDetails = _context.Jobs.Where(j => j.JobTitle.Contains(q));
//throw new NotImplementedException();
}
bellow parameters

JobsSortOptions sortBy = JobsSortOptions.jobId, JobStatus jobStatus = JobStatus.active, JobsSortByDate sortByDate = JobsSortByDate.date

Using for shorting created in enums
public enum CandidateSortOptions
{
place,
posted,
appliedFor
}
public enum CandidateStatus
{
active,
rejected,
hire
}
public enum JobsSortOptions
{
jobId, posted, responses
}
public enum JobStatus
{
active, closed, draft
}
public enum JobsSortByDate
{
date
}
Farhan Ahmed6y ago
https://docs.microsoft.com/en-us/aspnet/mvc/overview/older-versions-1/nerddinner/implement-efficient-data-paging#:~:text=Understanding%20IQueryable&text=It%20enables%20powerful%20%22deferred%20execution,of%20to%20implement%20paging%20support.&text=The%20IQueryable%20object%20returned,database%20using%20LINQ%20to%20SQL.
Laxmidhar Sahoo6y ago
Hi

I can not undersatnd the bellow parameters

JobsSortOptions sortBy = JobsSortOptions.jobId, JobStatus jobStatus = JobStatus.active, JobsSortByDate sortByDate = JobsSortByDate.date

Thanks and regards