//Search Exams
public List <Exam> GetExamBySearch(ExamSearchCriteria criteria)
{
IQueryable <Exam> exams = db.Exams.Where(c => c.IsDeleted == false).AsQueryable();
if (!string.IsNullOrEmpty(criteria.Topic))
{
exams = exams.Where(c => c.Topic.ToLower().Contains(criteria.Topic.ToLower()));
}
if (criteria.OrganizationId > 0)
{
exams = exams.Where(c =>
c.OrganizationId.ToString().ToLower().Contains(criteria.OrganizationId.ToString().ToLower()));
}
if (criteria.CourseId > 0)
{
exams = exams.Where(c =>
c.CourseId.ToString().ToLower().Contains(criteria.CourseId.ToString().ToLower()));
}
if (criteria.ExamTypeId > 0)
{
exams = exams.Where(c =>
c.ExamTypeId.ToString().ToLower().Contains(criteria.ExamTypeId.ToString().ToLower()));
}
return(exams.ToList());
}
//Index with Search Exam
public ActionResult Index(ExamSearchCriteria model)
{
var exams = _examManager.GetExamBySearch(model);
if (exams == null)
{
exams = new List <Exam>();
}
model.OrganizationListItem = GetOrganizationList();
model.ExamTypeListItem = GetAllExamTypes();
model.Exams = exams;
return(View(model));
}
//Search Exam
public List <Exam> GetExamBySearch(ExamSearchCriteria criteria)
{
List <Exam> exams = _examRepository.GetExamBySearch(criteria);
return(exams);
}
