public async Task <IEnumerable <Userd> > GetUsersNotInChallenge(int _ChallengeId, int _clubId) { if (!string.IsNullOrEmpty(Convert.ToString(_ChallengeId)) || !string.IsNullOrEmpty(Convert.ToString(_clubId))) { return(null); } else { UserChallengeEnrollmentProvider _UserChallengeEnrollmentProvider = new Business.UserChallengeEnrollmentProvider(); var userchallenge = await _UserChallengeEnrollmentProvider.GetAll(); ChallengeClubRelationProvider _userChallengeEnrollmentProvider = new ChallengeClubRelationProvider(); var challengeClubRelationship = await _userChallengeEnrollmentProvider.GetAll(); var entity = await GetAll(); var getcheck = ( from u in entity where !(from u1 in userchallenge.Where(a => a.ChallengeId == _ChallengeId) join c1 in challengeClubRelationship.Where(a => a.ClubId == _clubId) on u1.ChallengeClubRelationId equals c1.ChallengeClubRelationId select new { u1.UserId }).Contains(new { UserId = u.UserId }) && u.RoleId == 3 select new Userd { UserId = u.UserId, Name = u.FirstName + " " + u.LastName, UserName = u.UserName, UserRole = u.UserRole.Description } ); if (getcheck.Any()) { return(getcheck.ToList()); } else { var uentity = (from a in entity where a.RoleId == 3 select new Userd { UserId = a.UserId, Name = a.FirstName + " " + a.LastName, UserName = a.UserName, UserRole = a.UserRole.Description }).Distinct(); return(uentity.ToList()); } } }
public int Insert(Enrollment _enrollment) { ChallengeClubRelationProvider _ChallengeClubRelationProvider = new ChallengeClubRelationProvider(); var entity = _ChallengeClubRelationProvider.GetChallengeClubRelationshipSync(_enrollment.ClubId, _enrollment.ChallengeId); _enrollment.ChallengeClubRelationId = entity.ChallengeClubRelationId; UserChallengeEnrollment _userClubEnrollment = new UserChallengeEnrollment(); _userClubEnrollment.UserId = _enrollment.UserId; _userClubEnrollment.ChallengeId = _enrollment.ChallengeId; _userClubEnrollment.ChallengeClubRelationId = _enrollment.ChallengeClubRelationId; return(Insert(_userClubEnrollment)); }