public List <PersonalizedFriendsDomain> GetFriendsOfFriendsReviews(PersonalizedFriendRequest model, string userId)
{
List <PersonalizedFriendsDomain> ListPersonalizedDomain = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Followers_SelectFriendsOfFriendsReviewedPlacesWithProfile"
, inputParamMapper : delegate(SqlParameterCollection paramcollection)
{
paramcollection.AddWithValue("@UserId", userId);
paramcollection.AddWithValue("@FriendRecursionLevel", model.FriendRecursionLevel);
paramcollection.AddWithValue("@CurrentPage", model.CurrentPage);
paramcollection.AddWithValue("@ItemsPerPage", model.ItemsPerPage);
paramcollection.AddWithValue("@UserSelected", model.selectedId);
}, map : delegate(IDataReader reader, short set)
{
PersonalizedFriendsDomain p = new PersonalizedFriendsDomain();
int startingIndex = 0;
p.placesId = reader.GetSafeInt32(startingIndex++);
p.Name = reader.GetSafeString(startingIndex++);
p.Description = reader.GetSafeString(startingIndex++);
p.PhoneNumber = reader.GetSafeString(startingIndex++);
p.Website = reader.GetSafeString(startingIndex++);
p.MediaId = reader.GetSafeInt32(startingIndex++);
p.LocationId = reader.GetSafeInt32(startingIndex++);
p.CategoryId = reader.GetSafeInt32(startingIndex++);
p.Slug = reader.GetSafeString(startingIndex++);
p.CityId = reader.GetSafeInt32(startingIndex++);
p.Price = reader.GetSafeInt32(startingIndex++);
p.UserId = reader.GetSafeString(startingIndex++);
p.FriendLevel = reader.GetSafeInt32(startingIndex++);
p.Url = reader.GetSafeString(startingIndex++);
p.Address1 = reader.GetSafeString(startingIndex++);
p.City = reader.GetSafeString(startingIndex++);
p.State = reader.GetSafeString(startingIndex++);
p.ZipCode = reader.GetSafeString(startingIndex++);
p.Latitude = reader.GetSafeDecimal(startingIndex++);
p.Longitude = reader.GetSafeDecimal(startingIndex++);
p.userName = reader.GetSafeString(startingIndex++);
p.profileMediaId = reader.GetSafeInt32(startingIndex++);
p.profileUrl = reader.GetSafeString(startingIndex++);
if (ListPersonalizedDomain == null)
{
ListPersonalizedDomain = new List <PersonalizedFriendsDomain>();
}
ListPersonalizedDomain.Add(p);
});
return(ListPersonalizedDomain);
}
public HttpResponseMessage getNetworkPlaces([FromUri] PersonalizedFriendRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
string userId = UserService.GetCurrentUserId();
List <PersonalizedFriendsDomain> FriendsOfFriends = PersonalizedService.GetFriendsOfFriendsReviews(model, userId);
ItemsResponse <PersonalizedFriendsDomain> newitemResponse = new ItemsResponse <PersonalizedFriendsDomain>();
newitemResponse.Items = FriendsOfFriends;
return(Request.CreateResponse(HttpStatusCode.OK, newitemResponse.Items));
}
