public IActionResult SearchMembershipPrivileges([FromQuery] MembershipPrivilegesSearchModel searchModel) { try { var result = _membershipPrivilegeService.SearchMembershipPrivileges(searchModel); return(Ok(result)); } catch (Exception ex) { return(BadRequest(ex.StackTrace.ToString())); } }
public IPagedList <MembershipPrivilegesViewModel> SearchMembershipPrivileges(MembershipPrivilegesSearchModel searchModel) { try { //var sortString = !string.IsNullOrEmpty(searchModel.SortString) ? model.SortString : "CreatedDate DESC"; var query = _dbConfigContext.AqmembershipDiscountPrivileges.Where(x => !x.Deleted && (string.IsNullOrEmpty(searchModel.Name) || x.Name.ToLower().Contains(searchModel.Name.ToLower())) && (searchModel.EffectiveDate == null || (x.EffectiveDate >= searchModel.EffectiveDate && (x.EffectiveEndDate <= searchModel.EffectiveDate || x.EffectiveEndDate == null))) && (searchModel.Role == null || x.RoleFid == searchModel.Role)).OrderByDescending(a => a.EffectiveDate) .Select(c => new MembershipPrivilegesViewModel { ID = c.Id, Name = c.Name, EffectiveDate = c.EffectiveDate, EffectiveEndDate = c.EffectiveEndDate }); return(new PagedList <MembershipPrivilegesViewModel>(query, searchModel.PageIndex, searchModel.PageSize)); } catch { throw; } }