public async Task Should_CorrectlyParseXlsFile_When_FileIsValid()
{
var parser = new PolishTreasuryBondsAccountStateXlsFileParser();
var result = await parser.ParseFile(validExcelFilePath);
Assert.AreEqual(3, result.Count);
Assert.AreEqual("COI1115", result[0].EmissionCode);
Assert.AreEqual(3, result[0].AvailableBonds);
Assert.AreEqual(0, result[0].BlockedBonds);
Assert.AreEqual(300m, result[0].NominalValue);
Assert.AreEqual(301.24m, result[0].CurrentValue);
Assert.AreEqual(new DateTime(2020, 10, 3), result[0].BuyoutDate);
Assert.AreEqual("COI0417", result[1].EmissionCode);
Assert.AreEqual(2, result[1].AvailableBonds);
Assert.AreEqual(0, result[1].BlockedBonds);
Assert.AreEqual(200m, result[1].NominalValue);
Assert.AreEqual(256.54m, result[1].CurrentValue);
Assert.AreEqual(new DateTime(2019, 3, 4), result[1].BuyoutDate);
Assert.AreEqual("COI0417", result[2].EmissionCode);
Assert.AreEqual(5, result[2].AvailableBonds);
Assert.AreEqual(1, result[2].BlockedBonds);
Assert.AreEqual(600m, result[2].NominalValue);
Assert.AreEqual(683.23m, result[2].CurrentValue);
Assert.AreEqual(new DateTime(2019, 3, 5), result[2].BuyoutDate);
}
public void Should_AcceptXlsExtension()
{
var parser = new PolishTreasuryBondsAccountStateXlsFileParser();
Assert.IsTrue(parser.IsExtensionProcessable(".xls"));
Assert.IsTrue(parser.IsExtensionProcessable(".XLS"));
Assert.IsTrue(parser.IsExtensionProcessable(".Xls"));
Assert.IsTrue(parser.IsExtensionProcessable("xls"));
Assert.IsTrue(parser.IsExtensionProcessable("XLS"));
Assert.IsTrue(parser.IsExtensionProcessable("Xls"));
Assert.IsFalse(parser.IsExtensionProcessable("tmp"));
Assert.IsFalse(parser.IsExtensionProcessable(".tmp"));
}
public async Task Should_CorrectlyParseIkeXlsFile_When_FileIsValid()
{
var parser = new PolishTreasuryBondsAccountStateXlsFileParser();
var result = await parser.ParseFile(validIkeExcelFilePath);
Assert.AreEqual(4, result.Count);
Assert.AreEqual("EDO1230", result[0].EmissionCode);
Assert.AreEqual(1, result[0].AvailableBonds);
Assert.AreEqual(0, result[0].BlockedBonds);
Assert.AreEqual(100m, result[0].NominalValue);
Assert.AreEqual(100.51m, result[0].CurrentValue);
Assert.AreEqual(new DateTime(2030, 12, 16), result[0].BuyoutDate);
Assert.AreEqual("EDO0131", result[1].EmissionCode);
Assert.AreEqual(3, result[1].AvailableBonds);
Assert.AreEqual(0, result[1].BlockedBonds);
Assert.AreEqual(300m, result[1].NominalValue);
Assert.AreEqual(301.11m, result[1].CurrentValue);
Assert.AreEqual(new DateTime(2031, 1, 16), result[1].BuyoutDate);
}
