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()
});
}
