public void InsertToGroup(User user, List<String> listVkIdFriends) { int i = 1; UserMapper userMapper = new UserMapper(); ListFriendsMapper listFriendsMapper = new ListFriendsMapper(); List<ListFriends> listFriends = new List<ListFriends>(); FriendsMapper friendsMapper = new FriendsMapper(); foreach (var vkIdFriend in listVkIdFriends) { ListFriends listFriend = new ListFriends(user.GetId(), friendsMapper.FindByVkId(vkIdFriend).GetId()); listFriends.Add(listFriend); } foreach (var friend in listFriends) { GroupMapper groupMapper = new GroupMapper(); Friend friendObj = friendsMapper.FindById(friend.GetIdFriend()); String VkId = friendObj.GetVkId(); List<String> listgroup = vkClient.GroupsList(VkId); List<Group> groupsFriend = new List<Group>(); ; List<GroupsFriends> GroupsFriendses = new List<GroupsFriends>(); int idFriend = friendsMapper.FindByVkId(friendObj.GetVkId()).GetId(); GroupsFriendsMapper groupsFriendsMapper = new GroupsFriendsMapper(); Group group = null; foreach (var vkidGroup in listgroup) { group = new Group(vkidGroup); groupsFriend.Add(group); } groupMapper.Insert(groupsFriend); foreach (var vkidGroup in listgroup) { GroupsFriends groupsFriends = new GroupsFriends(idFriend, groupMapper.FindByVkId(vkidGroup).GetId()); GroupsFriendses.Add(groupsFriends); } groupsFriendsMapper.Insert(GroupsFriendses); Console.WriteLine("--------------------Friend number {0}", i); i++; listgroup.Clear(); } }
public void InsertToUsers() { User user = new User(vkClient.GetId(URL), vkClient.GetName(URL).ElementAt(0), vkClient.GetName(URL).ElementAt(1)); UserMapper userMapper = new UserMapper(); TokenMapper tokenMapper = new TokenMapper(); userMapper.Insert(user); tokenMapper.Insert(this.user); }
public void InsertToListFriends() { UserMapper userMapper = new UserMapper(); FriendsMapper friendsMapper = new FriendsMapper(); ListFriendsMapper listFriendsMapper = new ListFriendsMapper(); User user = userMapper.FindByVkId(vkClient.GetId(URL)); List<String> listFriends = vkClient.FriendsList(vkClient.GetId(URL)); InsertToFriends(listFriends); List<ListFriends> ListFriendses = new List<ListFriends>(); foreach (var vkidFriend in listFriends) { Friend friend = friendsMapper.FindByVkId(vkidFriend); ListFriendses.Add(new ListFriends(user.GetId(), friend.GetId())); } listFriendsMapper.Insert(ListFriendses); }