/// <summary>
/// Returns a FriendRequestsViewModel with a list of all accepted friends for the current browsing user
/// </summary>
/// <returns></returns>
public FriendRequestsViewModel acceptedFriendsToViewModel()
{
//get the user id who is browsing
int userId = _myHelper.getBrowsingUserId();
//get all the friend request which involve him and a status of accepted
var acceptedFriends = _database.Query<UmbBook.pocos.FriendRequest>("SELECT * FROM FriendRequests WHERE RequestingUserId =@0 AND accepted=@1 OR TargetUserId = @0 AND accepted=@1", userId.ToString(), "true");
FriendRequestsViewModel acceptedFriendsToViewModel = new FriendRequestsViewModel();
//let's get the imember objects for each and store it in the
foreach (var item in acceptedFriends)
{
//because we got 2 ids , but are just interested in either one of them (not the user himself
int userIdToAdd;
if (item.RequestingUserId == userId)
{
userIdToAdd = item.TargetUserId;
}
else
{
userIdToAdd = item.RequestingUserId;
}
acceptedFriendsToViewModel.friendRequests.Add(_memberService.GetById(userIdToAdd));
}
return acceptedFriendsToViewModel;
}
public FriendRequestsViewModel RenderFriendRequests()
{
//get the user id who is browsing
int userId = _myHelper.getBrowsingUserId();
//get all the friend request which involve him and a status of not accepted
var friendRequests = _database.Query<UmbBook.pocos.FriendRequest>("SELECT * FROM FriendRequests WHERE TargetUserId = @0 AND accepted = @1", userId.ToString(), "false");
FriendRequestsViewModel incomcingFriendRequests = new FriendRequestsViewModel();
//let's get the imember objects for each and store it in the
foreach (var item in friendRequests)
{
incomcingFriendRequests.friendRequests.Add(_memberService.GetById(item.RequestingUserId));
}
return incomcingFriendRequests;
}