/// <summary>
        /// Find By Search criteria
        /// </summary>
        /// <param name="criteria"></param>
        /// <returns></returns>
        public async Task <List <AssignUserCommittee> > Find(AssignUserCommitteeSearchCriteria criteria)
        {
            var result = await _context.AssignUserCommittees.Include(x => x.Committee)
                         .Where(x => x.IsActive.HasValue && x.IsActive.Value &&
                                (x.UserId == criteria.UserId || criteria.UserId == 0) &&
                                (x.CommitteeId == criteria.CommitteeId || criteria.CommitteeId == 0))
                         .OrderBy(x => x.AssignUserCommitteeId)
                         .SortBy(criteria.Sort, criteria.SortDirection)
                         //.Page(criteria.PageNumber, criteria.PageSize)
                         .ToListAsync();

            return(result);
        }
示例#2
0
 /// <summary>
 /// Find User Committees By SearchCriteria
 /// </summary>
 /// <param name="criteria"></param>
 /// <returns></returns>
 public async Task <List <AssignUserCommittee> > Find(AssignUserCommitteeSearchCriteria criteria)
 {
     Check.ArgumentNotNull(nameof(criteria), criteria);
     return(await _assignUserCommitteeServiceQueries.Find(criteria));
 }