Created
August 6, 2022 17:08
-
-
Save nedgrady/e9c50d57bad50ba8ad3fd98506a73a0a to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[Test] | |
public void ExcelExportCapturesTransactionTimestamp() | |
{ | |
var transaction = new Transaction | |
{ | |
Timestamp = DateTime.UtcNow | |
}; | |
var transcationExportBuilderUnderTest = new TransactionExportBuilder(); | |
transcationExportBuilderUnderTest.AddTransaction(transaction); | |
var excelExport = transcationExportBuilderUnderTest.BuildExcelFile(); | |
var actualTimestamp = | |
(DateTime)excelExport | |
.GetWorkbook("Export") | |
.GetColumn("Timestamp") | |
.GetDataInCellAtRow(1); | |
// Assert on the different date parts to avoid rounding errors when converting to an excel date. | |
Assert.AreEqual(transaction.Timestamp.Date, actualTimestamp.Date); | |
Assert.AreEqual(transaction.Timestamp.Hour, actualTimestamp.Hour); | |
Assert.AreEqual(transaction.Timestamp.Minute, actualTimestamp.Minute); | |
Assert.AreEqual(transaction.Timestamp.Second, actualTimestamp.Second); | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment