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 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); }