public ActionResult Index(RequirementSearchViewModel vm)
{
Func <IQueryable <Requirement>, IQueryable <Requirement> > requirementFilter = q =>
{
q = q.Include(r => r.Category).Include(r => r.Source);
if (vm.AssignedToUserId.HasValue)
{
q = q.Where(r => r.AssignedToUserId == vm.AssignedToUserId.Value);
}
if (vm.SourceId.HasValue)
{
q = q.Where(r => r.SourceId == vm.SourceId.Value);
}
if (vm.CategoryId.HasValue)
{
q = q.Where(r => r.CategoryId == vm.CategoryId.Value);
}
if (vm.Status.HasValue)
{
q = q.Where(r => r.RequirementStatus == vm.Status.Value);
}
if (!string.IsNullOrEmpty(vm.Title))
{
q = q.Where(r => r.Title.Contains(vm.Title));
}
if (vm.StartDate.HasValue)
{
q = q.Where(r => r.CreatedOn >= vm.StartDate.Value);
}
if (vm.EndDate.HasValue)
{
q = q.Where(r => r.CreatedOn <= vm.EndDate.Value);
}
return(q);
};
vm.Requirements = _requirementRepository.SearchPage(requirementFilter, o => o.OrderByDescending(c => c.CreatedOn), vm.GetPageNo(), vm.PageSize);
return(View(vm));
}