public void CRUD_Test()
{
var repositoryContext = new RepositoryContext();
Account testAccount = TestEntities.GetTestAccount(
1,
Guid.Parse("F341B4FB-4CC3-4FDB-B7CF-8DCD45365341"),
"AccAddr");
try
{
// delete test account
TestDataCleaner.DeleteTestAccount(repositoryContext, testAccount.AccountId);
// create account
repositoryContext.AccountRepository.Upsert(testAccount);
// create
AccountAddress expectedAccountAddress = TestEntities.GetTestAccountAddress(1, testAccount.AccountId);
repositoryContext.AccountAddressRepository.Upsert(expectedAccountAddress);
// read
AccountAddress actualAccountAddress =
repositoryContext.AccountAddressRepository.Get(expectedAccountAddress.AccountId);
Assert.NotNull(actualAccountAddress);
Assert.True(EntityComparer.AreAccountAddressEqual(expectedAccountAddress, actualAccountAddress));
// update
AccountAddress expectedAccountAddressNew = TestEntities.GetTestAccountAddress(
2,
expectedAccountAddress.AccountId);
repositoryContext.AccountAddressRepository.Upsert(expectedAccountAddressNew);
Assert.AreEqual(expectedAccountAddress.AccountId, expectedAccountAddressNew.AccountId);
AccountAddress actualAccountAddressNew =
repositoryContext.AccountAddressRepository.Get(expectedAccountAddressNew.AccountId);
Assert.NotNull(actualAccountAddressNew);
Assert.True(
EntityComparer.AreAccountAddressEqual(expectedAccountAddressNew, actualAccountAddressNew));
// delete
repositoryContext.AccountRepository.Delete(expectedAccountAddress.AccountId);
// read by id
actualAccountAddress =
repositoryContext.AccountAddressRepository.Get(expectedAccountAddress.AccountId);
Assert.Null(actualAccountAddress);
}
finally
{
// delete test account
TestDataCleaner.DeleteTestAccount(repositoryContext, testAccount.AccountId);
repositoryContext.Dispose();
}
}
public void CRUD_Test()
{
var repositoryContext = new RepositoryContext();
Account expectedAccount = TestEntities.GetTestAccount(
1,
Guid.Parse("B2A4DF0B-B0B4-46E6-A308-6DFB79909CD3"),
"AccOld");
try
{
// delete test account
TestDataCleaner.DeleteTestAccount(repositoryContext, expectedAccount.AccountId);
// create
repositoryContext.AccountRepository.Upsert(expectedAccount);
// read by id
Account actualAccount = repositoryContext.AccountRepository.Get(expectedAccount.AccountId);
Assert.IsNotNull(actualAccount);
Assert.IsTrue(EntityComparer.AreAccountEqual(expectedAccount, actualAccount));
if (expectedAccount.AccountGuid.HasValue)
{
// read by guid
actualAccount = repositoryContext.AccountRepository.Get(expectedAccount.AccountGuid.Value);
Assert.IsNotNull(actualAccount);
Assert.IsTrue(EntityComparer.AreAccountEqual(expectedAccount, actualAccount));
}
int?actualAccountId;
if (expectedAccount.AccountGuid.HasValue)
{
// read id by guid
actualAccountId = repositoryContext.AccountRepository.GetId(expectedAccount.AccountGuid.Value);
Assert.AreEqual(expectedAccount.AccountId, actualAccountId);
}
// read id by account number
actualAccountId = repositoryContext.AccountRepository.GetId(expectedAccount.AccountNumber);
Assert.AreEqual(expectedAccount.AccountId, actualAccountId);
// update
Account expectedAccountNew =
TestEntities.GetTestAccount(2, expectedAccount.AccountGuid.Value, "AccNew");
repositoryContext.AccountRepository.Upsert(expectedAccountNew);
Assert.AreEqual(expectedAccount.AccountId, expectedAccountNew.AccountId);
Account actualAccountNew = repositoryContext.AccountRepository.Get(expectedAccountNew.AccountId);
Assert.IsNotNull(actualAccountNew);
Assert.IsTrue(EntityComparer.AreAccountEqual(expectedAccountNew, actualAccountNew));
// delete
repositoryContext.AccountRepository.Delete(expectedAccount.AccountId);
// read by id
actualAccount = repositoryContext.AccountRepository.Get(expectedAccount.AccountId);
Assert.IsNull(actualAccount);
if (expectedAccount.AccountGuid.HasValue)
{
// read by guid
actualAccount = repositoryContext.AccountRepository.Get(expectedAccount.AccountGuid.Value);
Assert.IsNull(actualAccount);
// read id by guid
actualAccountId = repositoryContext.AccountRepository.GetId(expectedAccount.AccountGuid.Value);
Assert.IsNull(actualAccountId);
}
// read id by account number
actualAccountId = repositoryContext.AccountRepository.GetId(expectedAccount.AccountNumber);
Assert.IsNull(actualAccountId);
}
finally
{
// delete test account
TestDataCleaner.DeleteTestAccount(repositoryContext, expectedAccount.AccountId);
repositoryContext.Dispose();
}
}
public void CRUD_Test()
{
var repositoryContext = new RepositoryContext();
Account testAccount = TestEntities.GetTestAccount(
1,
Guid.Parse("579526DD-D75C-46E2-8A30-A1D3828F92A5"),
"UserOld");
try
{
// delete test account
TestDataCleaner.DeleteTestAccount(repositoryContext, testAccount.AccountId);
// create account
repositoryContext.AccountRepository.Upsert(testAccount);
// create
User expectedUser = TestEntities.GetTestUser(
1,
Guid.Parse("86641E45-CB9C-4CC3-93EB-E6D26FDC91BE"),
"User",
testAccount.AccountId);
repositoryContext.UserRepository.Upsert(expectedUser);
// read by id
User actualUser = repositoryContext.UserRepository.Get(expectedUser.UserId);
Assert.NotNull(actualUser);
Assert.True(EntityComparer.AreUserEqual(expectedUser, actualUser));
// read by guid
if (expectedUser.UserGuid.HasValue)
{
actualUser = repositoryContext.UserRepository.Get(expectedUser.UserGuid.Value);
Assert.NotNull(actualUser);
Assert.True(EntityComparer.AreUserEqual(expectedUser, actualUser));
}
// read by logon name
actualUser = repositoryContext.UserRepository.Get(expectedUser.LogonName);
Assert.NotNull(actualUser);
Assert.True(EntityComparer.AreUserEqual(expectedUser, actualUser));
int?actualUserId;
// read id by guid
if (expectedUser.UserGuid.HasValue)
{
actualUserId = repositoryContext.UserRepository.GetId(expectedUser.UserGuid.Value);
Assert.Equal(expectedUser.UserId, actualUserId);
}
// read id by logon name
actualUserId = repositoryContext.UserRepository.GetId(expectedUser.LogonName);
Assert.Equal(expectedUser.UserId, actualUserId);
// update
User expectedUserNew = TestEntities.GetTestUser(
2,
expectedUser?.UserGuid.Value ?? null,
"UserNew",
expectedUser.AccountId);
repositoryContext.UserRepository.Upsert(expectedUserNew);
Assert.Equal(expectedUser.UserId, expectedUserNew.UserId);
User actualUserNew = repositoryContext.UserRepository.Get(expectedUserNew.UserId);
Assert.NotNull(actualUserNew);
Assert.True(EntityComparer.AreUserEqual(expectedUserNew, actualUserNew));
// delete
repositoryContext.UserRepository.Delete(expectedUserNew.UserId);
// read by id
actualUser = repositoryContext.UserRepository.Get(expectedUserNew.UserId);
Assert.Null(actualUser);
if (expectedUserNew.UserGuid.HasValue)
{
// read by guid
actualUser = repositoryContext.UserRepository.Get(expectedUserNew.UserGuid.Value);
Assert.Null(actualUser);
}
// read by logon name
actualUser = repositoryContext.UserRepository.Get(expectedUser.LogonName);
Assert.Null(actualUser);
if (expectedUserNew.UserGuid.HasValue)
{
// read id by guid
actualUserId = repositoryContext.UserRepository.GetId(expectedUserNew.UserGuid.Value);
Assert.Null(actualUserId);
}
// read id by logon name
actualUserId = repositoryContext.UserRepository.GetId(expectedUserNew.LogonName);
Assert.Null(actualUserId);
// test by account
// create users
var expectedUsers = new List <User>
{
TestEntities.GetTestUser(
1,
Guid.Parse("5B446BFB-7BCF-4A49-84EA-EB8D738F11DF"),
"User1",
testAccount.AccountId),
TestEntities.GetTestUser(
2,
Guid.Parse("EC15A8F5-941B-4C46-8EDA-83CD5B42E482"),
"User2",
testAccount.AccountId)
};
foreach (User user in expectedUsers)
{
repositoryContext.UserRepository.Upsert(user);
}
// read by account
List <User> actualUsers = repositoryContext.UserRepository.GetByAccount(testAccount.AccountId);
Assert.Equal(expectedUsers.Count, actualUsers.Count);
foreach (User user in expectedUsers)
{
actualUser = actualUsers.Single(ar => ar.UserGuid == user.UserGuid);
Assert.True(EntityComparer.AreUserEqual(user, actualUser));
}
// delete by account
repositoryContext.UserRepository.DeleteByAccount(testAccount.AccountId);
// read by account
actualUsers = repositoryContext.UserRepository.GetByAccount(testAccount.AccountId);
Assert.Empty(actualUsers);
}
finally
{
// delete test account
TestDataCleaner.DeleteTestAccount(repositoryContext, testAccount.AccountId);
repositoryContext.Dispose();
}
}
public void CRUD_Test()
{
var repositoryContext = new RepositoryContext();
Account testAccount = TestEntities.GetTestAccount(
1,
Guid.Parse("DA8306F8-B255-4737-925C-AACCA7EB2B87"),
"UserRole");
try
{
// delete test account
TestDataCleaner.DeleteTestAccount(repositoryContext, testAccount.AccountId);
// create account
repositoryContext.AccountRepository.Upsert(testAccount);
// create account roles
AccountRole testAccountRole1 = TestEntities.GetTestAccountRole(
1,
Guid.Parse("FFDEA1D7-78BA-414C-8A7B-A3B09A50DDF2"),
testAccount.AccountId,
"UserRole1");
repositoryContext.AccountRoleRepository.Upsert(testAccountRole1);
AccountRole testAccountRole2 = TestEntities.GetTestAccountRole(
2,
Guid.Parse("B0775CA4-7339-4127-BDF3-440B85F71AC5"),
testAccount.AccountId,
"UserRole2");
repositoryContext.AccountRoleRepository.Upsert(testAccountRole2);
// create user
User testUser = TestEntities.GetTestUser(
1,
Guid.Parse("EE837AA8-D3B8-47D4-B5DF-23E389BCFBA4"),
"UserRole",
testAccount.AccountId);
repositoryContext.UserRepository.Upsert(testUser);
// create
UserRole expectedUserRole = TestEntities.GetTestUserRole(
testUser.UserId,
testAccountRole1.AccountRoleId);
repositoryContext.UserRoleRepository.Add(expectedUserRole);
// read
UserRole actualUserRole = repositoryContext.UserRoleRepository.Get(
expectedUserRole.UserId,
expectedUserRole.AccountRoleId);
Assert.NotNull(actualUserRole);
Assert.True(EntityComparer.AreUserRoleEqual(expectedUserRole, actualUserRole));
// delete
repositoryContext.UserRoleRepository.Delete(expectedUserRole.UserId, expectedUserRole.AccountRoleId);
// read
actualUserRole = repositoryContext.UserRoleRepository.Get(
expectedUserRole.UserId,
expectedUserRole.AccountRoleId);
Assert.Null(actualUserRole);
// test by user
// create user roles
var expectedUserRoles = new List <UserRole>
{
TestEntities.GetTestUserRole(testUser.UserId, testAccountRole1.AccountRoleId),
TestEntities.GetTestUserRole(testUser.UserId, testAccountRole2.AccountRoleId)
};
foreach (UserRole userRole in expectedUserRoles)
{
repositoryContext.UserRoleRepository.Add(userRole);
}
// read by user
List <UserRole> actualUserRoles = repositoryContext.UserRoleRepository.Get(testUser.UserId);
Assert.AreEqual(expectedUserRoles.Count, actualUserRoles.Count);
foreach (UserRole userRole in expectedUserRoles)
{
actualUserRole =
actualUserRoles.Single(
ur => ur.UserId == userRole.UserId && ur.AccountRoleId == userRole.AccountRoleId);
Assert.True(EntityComparer.AreUserRoleEqual(userRole, actualUserRole));
}
// delete by user
repositoryContext.UserRoleRepository.Delete(testUser.UserId);
// read by user
actualUserRoles = repositoryContext.UserRoleRepository.Get(testUser.UserId);
Assert.IsEmpty(actualUserRoles);
}
finally
{
// delete test account
TestDataCleaner.DeleteTestAccount(repositoryContext, testAccount.AccountId);
repositoryContext.Dispose();
}
}
public void CRUD_Test()
{
var repositoryContext = new RepositoryContext();
Account testAccount = TestEntities.GetTestAccount(
1,
Guid.Parse("64651A7C-CB82-4F45-92CA-397AD8519D75"),
"AccRole");
try
{
// delete test account
TestDataCleaner.DeleteTestAccount(repositoryContext, testAccount.AccountId);
// create account
repositoryContext.AccountRepository.Upsert(testAccount);
// create
AccountRole expectedAccountRole = TestEntities.GetTestAccountRole(
1,
Guid.Parse("7B46F4DD-1E5E-47F9-ADBB-A37A60B1BAB2"),
testAccount.AccountId,
"AccRoleOld");
repositoryContext.AccountRoleRepository.Upsert(expectedAccountRole);
// read by id
AccountRole actualAccountRole =
repositoryContext.AccountRoleRepository.Get(expectedAccountRole.AccountRoleId);
Assert.NotNull(actualAccountRole);
Assert.True(EntityComparer.AreAccountRoleEqual(expectedAccountRole, actualAccountRole));
if (expectedAccountRole.AccountRoleGuid.HasValue)
{
// read by guid
actualAccountRole =
repositoryContext.AccountRoleRepository.Get(expectedAccountRole.AccountRoleGuid.Value);
Assert.NotNull(actualAccountRole);
Assert.True(EntityComparer.AreAccountRoleEqual(expectedAccountRole, actualAccountRole));
}
int?actualAccountRoleId;
if (expectedAccountRole.AccountRoleGuid.HasValue)
{
// read id by guid
actualAccountRoleId =
repositoryContext.AccountRoleRepository.GetId(expectedAccountRole.AccountRoleGuid.Value);
Assert.AreEqual(expectedAccountRole.AccountRoleId, actualAccountRoleId);
}
// read id by account id and role name
actualAccountRoleId = repositoryContext.AccountRoleRepository.GetId(
expectedAccountRole.AccountId,
expectedAccountRole.RoleName);
Assert.AreEqual(expectedAccountRole.AccountRoleId, actualAccountRoleId);
// update
AccountRole expectedAccountRoleNew = TestEntities.GetTestAccountRole(
2,
expectedAccountRole?.AccountRoleGuid.Value ?? null,
expectedAccountRole.AccountId,
"AccRoleNew");
expectedAccountRoleNew.AccountRoleGuid = expectedAccountRole.AccountRoleGuid;
repositoryContext.AccountRoleRepository.Upsert(expectedAccountRoleNew);
Assert.AreEqual(expectedAccountRole.AccountRoleId, expectedAccountRoleNew.AccountRoleId);
AccountRole actualAccountRoleNew =
repositoryContext.AccountRoleRepository.Get(expectedAccountRoleNew.AccountRoleId);
Assert.NotNull(actualAccountRoleNew);
Assert.True(EntityComparer.AreAccountRoleEqual(expectedAccountRoleNew, actualAccountRoleNew));
// delete
repositoryContext.AccountRoleRepository.Delete(expectedAccountRoleNew.AccountRoleId);
// read by id
actualAccountRole = repositoryContext.AccountRoleRepository.Get(expectedAccountRoleNew.AccountRoleId);
Assert.Null(actualAccountRole);
if (expectedAccountRoleNew.AccountRoleGuid.HasValue)
{
// read by guid
actualAccountRole =
repositoryContext.AccountRoleRepository.Get(expectedAccountRoleNew.AccountRoleGuid.Value);
Assert.Null(actualAccountRole);
// read id by guid
actualAccountRoleId =
repositoryContext.AccountRoleRepository.GetId(expectedAccountRoleNew.AccountRoleGuid.Value);
Assert.Null(actualAccountRoleId);
}
// read id by account id and role number
actualAccountRoleId = repositoryContext.AccountRoleRepository.GetId(
expectedAccountRoleNew.AccountId,
expectedAccountRoleNew.RoleName);
Assert.Null(actualAccountRoleId);
// test by account
// create account roles
var expectedAccountRoles = new List <AccountRole>
{
TestEntities.GetTestAccountRole(
1,
Guid.Parse("AF8F597E-82A3-4184-932D-6AA31DA4E6F2"),
testAccount.AccountId,
"AccRole1")
};
foreach (AccountRole accountRole in expectedAccountRoles)
{
repositoryContext.AccountRoleRepository.Upsert(accountRole);
}
// read by account
var actualAccountRoles = new List <AccountRole>
{
repositoryContext.AccountRoleRepository.GetByAccount(testAccount.AccountId)
};
Assert.AreEqual(expectedAccountRoles.Count, actualAccountRoles.Count);
foreach (AccountRole accountRole in expectedAccountRoles)
{
actualAccountRole =
actualAccountRoles.Single(ar => ar.AccountRoleGuid == accountRole.AccountRoleGuid);
Assert.True(EntityComparer.AreAccountRoleEqual(accountRole, actualAccountRole));
}
// delete by account
repositoryContext.AccountRoleRepository.DeleteByAccount(testAccount.AccountId);
// read by account
actualAccountRoles = new List <AccountRole>
{
repositoryContext.AccountRoleRepository.GetByAccount(testAccount.AccountId)
};
Assert.IsEmpty(actualAccountRoles);
}
finally
{
// delete test account
TestDataCleaner.DeleteTestAccount(repositoryContext, testAccount.AccountId);
repositoryContext.Dispose();
}
}
