public IEnumerable <Menu> SearchNotAddedInUser(IConnectionHandler connectionHandler, Guid userId, string value) { var predicateBuilder = new PredicateBuilder <Menu>(); var guids = new UserMenuBO().Select(connectionHandler, x => x.MenuId, x => x.UserId == userId, true); if (guids.Any()) { predicateBuilder.And(x => x.Id.NotIn(guids)); } predicateBuilder.And(x => x.Enabled); if (!string.IsNullOrEmpty(value)) { predicateBuilder.And(x => x.Url.Contains(value) || x.Title.Contains(value)); } return(this.OrderBy(connectionHandler, x => x.Title, predicateBuilder.GetExpression())); }