public static Bank RandomBank(CityArea ca = null)
{
var bank = new Bank();
ca = ca ?? CityArea.RandomAmericanCity();
var bankXml = GetBankXmlElement(ca);
if (bankXml == null)
{
return(bank);
}
var city = bankXml.GetAttribute("city");
var state = bankXml.GetAttribute("us-state");
var name = bankXml.GetAttribute("name");
var abbrev = bankXml.GetAttribute("abbrev");
var rssd = bankXml.GetAttribute("rssd");
bank.BusinessAddress = new PostalAddress
{
CityArea = new UsCityStateZip(new AddressData {
Locality = city, RegionAbbrev = state
})
};
bank.Rssd = new ResearchStatisticsSupervisionDiscount {
Value = rssd
};
bank.RoutingNumber = RoutingTransitNumber.RandomRoutingNumber();
bank.AddName(KindsOfNames.Legal, name);
bank.AddName(KindsOfNames.Abbrev, abbrev);
bank.LoadXrefXmlData();
return(bank);
}
public void TestAddXrefValues()
{
var testXrefId = new Tuple<Type, string>(typeof(NoFuture.Rand.Com.Bank), "BANK OF AMER NA");
var testValues = new RoutingTransitNumber {Value = "000015421"};
var testResult = NoFuture.Rand.Data.Types.XRefGroup.AddXrefValues(testXrefId,testValues, "RoutingNumber");
Assert.IsTrue(testResult);
testXrefId = new Tuple<Type, string>(typeof(NoFuture.Rand.Com.Bank), "A new bank entry");
testValues = new RoutingTransitNumber { Value = "787454541" };
testResult = NoFuture.Rand.Data.Types.XRefGroup.AddXrefValues(testXrefId, testValues, "RoutingNumber");
Assert.IsTrue(testResult);
NoFuture.Util.NfPath.SaveXml(TreeData.XRefXml,
@"C:\Projects\31g\trunk\Code\NoFuture.Tests\Rand\XRefTestRslt.xml");
}
public void TestAddXrefValues()
{
var testXrefId = new Tuple <Type, string>(typeof(NoFuture.Rand.Com.Bank), "BANK OF AMER NA");
var testValues = new RoutingTransitNumber {
Value = "000015421"
};
var testResult = XRefGroup.AddXrefValues(testXrefId, testValues, "RoutingNumber");
Assert.IsTrue(testResult);
testXrefId = new Tuple <Type, string>(typeof(NoFuture.Rand.Com.Bank), "A new bank entry");
testValues = new RoutingTransitNumber {
Value = "787454541"
};
testResult = XRefGroup.AddXrefValues(testXrefId, testValues, "RoutingNumber");
Assert.IsTrue(testResult);
}
public void TestRoutingTransitNumber()
{
var testSubject = RoutingTransitNumber.RandomRoutingNumber();
Assert.IsNotNull(testSubject);
Assert.IsFalse(string.IsNullOrWhiteSpace(testSubject.Value));
Assert.IsFalse(string.IsNullOrWhiteSpace(testSubject.FedDistrictFullName));
Assert.AreEqual(9, testSubject.Value.Length);
System.Diagnostics.Debug.WriteLine(testSubject.Value);
System.Diagnostics.Debug.WriteLine(testSubject.FedDistrictFullName);
testSubject.Value = "053000196";
Assert.AreEqual("05", testSubject.FedDistrict);
Assert.AreEqual("30", testSubject.CheckProcCenter);
Assert.AreEqual("0019", testSubject.AbaInstitutionId);
Assert.AreEqual(6, testSubject.CheckDigit);
}
public void Configure(EntityTypeBuilder <CashAccount> entity)
{
entity.ToTable("CashAccounts", schema: "Finance");
entity.HasKey(e => e.Id);
entity.Property(p => p.Id).HasColumnType("UNIQUEIDENTIFIER").HasColumnName("CashAccountId");
entity.HasMany(p => p.CashAccountTransactions).WithOne().HasForeignKey(p => p.CashAccountId);
entity.Property(p => p.BankName)
.HasConversion(p => p.Value, p => BankName.Create(p))
.HasColumnType("NVARCHAR(50)")
.HasColumnName("BankName")
.IsRequired();
entity.Property(p => p.CashAccountName)
.HasConversion(p => p.Value, p => CashAccountName.Create(p))
.HasColumnType("NVARCHAR(50)")
.HasColumnName("AccountName")
.IsRequired();
entity.Property(p => p.CashAccountNumber)
.HasConversion(p => p.Value, p => CashAccountNumber.Create(p))
.HasColumnType("NVARCHAR(50)")
.HasColumnName("AccountNumber")
.IsRequired();
entity.Property(p => p.RoutingTransitNumber)
.HasConversion(p => p.Value, p => RoutingTransitNumber.Create(p))
.HasColumnType("NCHAR(9)")
.HasColumnName("RoutingTransitNumber")
.IsRequired();
entity.Property(p => p.DateOpened)
.HasConversion(p => p.Value, p => DateOpened.Create(p))
.HasColumnType("datetime2(0)")
.HasColumnName("DateOpened")
.IsRequired();
entity.Property(p => p.UserId)
.HasConversion(p => p.Value, p => UserId.Create(p))
.HasColumnType("UNIQUEIDENTIFIER")
.HasColumnName("UserId")
.IsRequired();
entity.Property(e => e.CreatedDate)
.HasColumnType("datetime2(7)")
.ValueGeneratedOnAdd()
.HasDefaultValueSql("sysdatetime()");
entity.Property(e => e.LastModifiedDate).HasColumnType("datetime2(7)");
}
public async Task ShouldInsert_CashAccount_UsingCashAccountRepo()
{
CashAccount account = new CashAccount
(
CashAccountId.Create(new Guid("1e5b3dcf-9ffd-4671-95ee-373e4ca08804")),
BankName.Create("ABCDEFG Banking & Hair Stylist, Inc."),
CashAccountName.Create("Entertainment"),
CashAccountNumber.Create("12345-678987"),
RoutingTransitNumber.Create("125478991"),
DateOpened.Create(new DateTime(2021, 11, 6)),
UserId.Create(new Guid("660bb318-649e-470d-9d2b-693bfb0b2744"))
);
await _cashAcctRepo.AddAsync(account);
await _unitOfWork.Commit();
var result = await _cashAcctRepo.Exists(account.Id);
Assert.True(result);
}
public async Task ShouldUpdate_CashAccount_UsingCashAccountRepo()
{
CashAccount account = await _cashAcctRepo.GetByIdAsync(new Guid("765ec2b0-406a-4e42-b831-c9aa63800e76"));
account.UpdateBankName(BankName.Create("Test Bank"));
account.UpdateCashAccountName(CashAccountName.Create("Testing Account"));
account.UpdateCashAccountNumber(CashAccountNumber.Create("9876543210"));
account.UpdateRoutingTransitNumber(RoutingTransitNumber.Create("125478991"));
account.UpdateDateOpened(DateOpened.Create(new DateTime(2021, 11, 7)));
account.UpdateUserId(UserId.Create(UserId.Create(new Guid("660bb318-649e-470d-9d2b-693bfb0b2744"))));
await _unitOfWork.Commit();
CashAccount result = await _cashAcctRepo.GetByIdAsync(new Guid("765ec2b0-406a-4e42-b831-c9aa63800e76"));
Assert.Equal("Test Bank", result.BankName);
Assert.Equal("Testing Account", result.CashAccountName);
Assert.Equal("9876543210", result.CashAccountNumber);
Assert.Equal("125478991", result.RoutingTransitNumber);
Assert.Equal(new DateTime(2021, 11, 7), result.DateOpened);
Assert.Equal(new Guid("660bb318-649e-470d-9d2b-693bfb0b2744"), result.UserId);
}
