How to bind Table data with related filters in IQueryable method

Question

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(); }

Farhan Ahmed · Answer

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 Sahoo · Answer

Hi I can not undersatnd the bellow parameters JobsSortOptions sortBy = JobsSortOptions.jobId, JobStatus jobStatus = JobStatus.active, JobsSortByDate sortByDate = JobsSortByDate.date Thanks and regards

Laxmidhar Sahoo · Answer

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 Tiwari · Answer

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 }