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;

        }
예제 #2
0
        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);
        }
예제 #3
0
        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));
            }
        }
예제 #4
0
 public IEnumerable <Exam> Filter(ExamFilterModel filterModel)
 {
     return(examRepository.Filter(filterModel));
 }
예제 #5
0
 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);
 }