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(); } }
private Group FindBy(String SQL) { dbMaster.OpenConnection(); Group group = null; try { MySqlCommand command = dbMaster.GetConnection().CreateCommand(); command.CommandText = SQL; command.ExecuteNonQuery(); using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { group = new Group(Convert.ToInt32(reader["id"]), reader["id_vk"].ToString()); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } dbMaster.CloseConnection(); return group; }