public void Test_AddAndGetMembers()
        {
            //arrange
            var meetingRepository = new MeetingsRepository(
                _connectionString,
                new UsersRepository(_connectionString),
                new PlacesRepository(_connectionString)
                );

            var user1 = TestHelper.GenerateTestUser();
            var user2 = TestHelper.GenerateTestUser();
            var owner = TestHelper.GenerateTestUser();
            meetingRepository.UsersRepository.Create(user1);
            meetingRepository.UsersRepository.Create(user2);
            meetingRepository.UsersRepository.Create(owner);

            var place = TestHelper.GenerateTestPlace();
            meetingRepository.PlacesRepository.Create(place);

            var meeting = new Meeting
            {
                Id = Guid.NewGuid(),
                Title = "title",
                Place = place,
                Owner = owner
            };
            meetingRepository.Create(meeting);
            //act
            meetingRepository.AddMember(meeting.Id, user1.Id);
            meetingRepository.AddMember(meeting.Id, user2.Id);
            var members = meetingRepository.GetMembers(meeting.Id);
            //asserts
            Assert.IsTrue(members.Count() == 3);
        }
        public void Test_DeleteMember()
        {
            //arrange
            var meetingRepository = new MeetingsRepository(
                _connectionString,
                new UsersRepository(_connectionString),
                new PlacesRepository(_connectionString)
                );

            var user1 = TestHelper.GenerateTestUser(Guid.NewGuid());
            meetingRepository.UsersRepository.Create(user1);

            var owner = TestHelper.GenerateTestUser(Guid.NewGuid());
            meetingRepository.UsersRepository.Create(owner);

            var place = TestHelper.GenerateTestPlace(Guid.NewGuid());
            meetingRepository.PlacesRepository.Create(place);

            var meeting = new Meeting
            {
                Id = Guid.NewGuid(),
                Title = "title",
                Place = place,
                Owner = owner
            };
            meetingRepository.Create(meeting);

            meetingRepository.AddMember(meeting.Id, user1.Id);
            //act
            meetingRepository.DeleteMember(meeting.Id, user1.Id);
            //assert
            var members = meetingRepository.GetMembers(meeting.Id);
            Assert.IsFalse(members.Contains(user1));
        }