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