public void GetAllPossiblePartners() { var client = ClientHelper.GetClient(); var request = new GetAllPossiblePartners { CompetitionId = 2 }; var response = client.Get(request); }
public object Get(GetAllPossiblePartners request) { var teamInscriptions = Db.Select <TeamInscription>(s => s.CompetitionId == request.CompetitionId); var users = Db.Select <UserAuth>() .Where(x => x.Id != SessionUserId && x.FirstName != null && x.LastName != null && !teamInscriptions.Any(t => t.Player1Id == x.Id || t.Player2Id == x.Id)) .Select(x => x.ToDto()) .ToList(); //var users = // Db.Select<UserAuth>() // .Where(x => x.Id != SessionUserId && Db.Select<TeamInscription>().All(k => k.CompetitionId != request.CompetitionId || (k.Player1Id != x.Id && k.Player2Id != x.Id))) // .Select(x => x.ToDto()) // .ToList(); var namedUsers = users.Where(x => !string.IsNullOrEmpty(x.FirstName) && !string.IsNullOrEmpty(x.LastName)); return(new UsersResponse { Users = namedUsers.ToList() }); }