public IEnumerable<Exam> Filter(ExamFilterModel fillterModel) { var result = context.Exams.ToList(); if (fillterModel.CreateBy != null && !"".Equals(fillterModel.CreateBy)) { result = result.Where(s => s.CreateBy.Equals(fillterModel.CreateBy)).ToList(); } if (fillterModel.TimeTest > 0) { result = result.Where(s => s.Tests != null && s.Tests.Where(t => t.TestTime == fillterModel.TimeTest).Count() > 0).ToList(); } //if (fillterModel.CreateAt != null) //{ // result = result.Where(s => s.CreateAt == fillterModel.CreateAt).ToList(); //} if (fillterModel.QuestionNumber > 0) { result = result.Where(s => s.QuestionNumber == fillterModel.QuestionNumber).ToList(); } if (fillterModel.Status >= 0) { var flag = fillterModel.Status == 1 ? true : false; result = result.Where(s => s.Status == flag).ToList(); } return result; }
public ServiceResponse <List <Exam> > GetExams(ExamFilterModel filter) { var response = new ServiceResponse <List <Exam> >(); response.IsSucceeded = true; response.RecordsTotal = ExamRepository.ListQueryable.Count(); response.RecordsFiltered = ExamRepository.ListQueryable.AddSearchFilters(filter).Count(); response.Result = ExamRepository.ListQueryable.AddSearchFilters(filter).AddOrderAndPageFilters(filter).ToList(); return(response); }
public IActionResult GetExams(ExamFilterModel model) { try { var result = _ExamService.GetExams(model); if (result.IsSucceeded) { return(Ok(result.Result)); } return(BadRequest(result.ErrorMessage)); } catch (Exception e) { return(BadRequest(e.Message)); } }
public IEnumerable <Exam> Filter(ExamFilterModel filterModel) { return(examRepository.Filter(filterModel)); }
public static IQueryable <Exam> AddSearchFilters(this IQueryable <Exam> input, ExamFilterModel filter) { if (filter != null) { if (filter.Term?.Length > 0) { input = input.Where(x => x.ExamName.Contains(filter.Term)); } } return(input); }