public void GetFact() { var connection = default(DbConnection); var transaction = default(DbTransaction); try { connection = this._factory.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(IsolationLevel.Serializable); var repository = new MembershipUsersRepository(); var membershipId = long.MaxValue; var userId = long.MaxValue; if (!repository.Create(new MembershipUserEntity() { MembershipID = membershipId, UserID = userId, }, connection, transaction)) { Assert.True(false); } else { /* var gotten = repository.Get(new MembershipUsersCriteria() { MembershipID = membershipId, }, connection, transaction); foreach (var entity in gotten) { var user = new User(new UserEntity() { ID = entity.UserID, }); var found = default(UserEntity); user.Find(out found); Assert.True(0 < found.ID); } */ } } finally { if (transaction != null) { transaction.Rollback(); } if (connection != null) { connection.Close(); } } }
public void CreateFact() { var connection = default(DbConnection); var transaction = default(DbTransaction); try { connection = this._factory.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(IsolationLevel.Serializable); var repository = new MembershipUsersRepository(); long membershipId = long.MaxValue; long userId = long.MaxValue; Assert.True(repository.Create(new MembershipUserEntity() { MembershipID = membershipId, UserID = userId, }, connection, transaction)); } finally { if (transaction != null) { transaction.Rollback(); } if (connection != null) { connection.Close(); } } }
public void DeleteForeighKeyOnMembershipIDFact() { var connection = default(DbConnection); var transaction = default(DbTransaction); try { connection = this._factory.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(); // Memberships var membership = new MembershipEntity() { Name = new Random().Next().ToString(CultureInfo.InvariantCulture), Password = @"password", }; var memberships = new MembershipsRepository(); membership.CreatedOn = KandaRepository.GetUtcDateTime(connection, transaction); var status = MembershipCreateStatus.ProviderError; if (!memberships.Create(membership , connection, transaction, out status)) { Assert.True(!true); } // Users var user = new UserEntity() { /*ID = @"",*/ FamilyName = @"family name", GivenName = @"given name", AdditionalName = @"additional name", Description = @"description", CreatedOn = membership.CreatedOn, Enabled = true, }; var users = new UsersRepository(); if (!users.Create(user, connection, transaction)) { Assert.True(!true); } // MembershipUsers var entity = new MembershipUserEntity() { MembershipID = membership.ID, UserID = user.ID }; var repository = new MembershipUsersRepository(); if (!repository.Create(entity, connection, transaction)) { Assert.True(!true); } // 削除 if (!repository.Delete(new MembershipUsersCriteria() { MembershipID = entity.MembershipID, UserID = entity.UserID, }, connection, transaction)) { Assert.True(!true); } if (!memberships.Delete(entity.MembershipID, connection, transaction)) { Assert.True(!true); } if (!users.Delete(entity.UserID, connection, transaction)) { Assert.True(!true); } Assert.True(true); } finally { if (transaction != null) { transaction.Rollback(); } if (connection != null) { connection.Close(); } } }
public void TrucnateFact() { var connection = default(DbConnection); var transaction = default(DbTransaction); try { connection = this._factory.CreateConnection(); connection.Open(); transaction = connection.BeginTransaction(IsolationLevel.Serializable); var repository = new MembershipUsersRepository(); Assert.True(repository.Truncate(connection, transaction)); } finally { if (transaction != null) { transaction.Rollback(); } if (connection != null) { connection.Close(); } } }