public void Test_Mapping_With_Some_Incorrect_Arbitrary_Labels()
{
//arrange
var headerCol = new InputPoco()
{
Title = "Content",
ReportDate = "Date",
ContractID = "report_type",
Territory = "Territorities",
Fee = "Total"
};
var input = new List <InputPoco> {
new InputPoco
{
Title = "Movie I",
ReportDate = DateTime.Now.Date.ToString(),
ContractID = "xox",
Territory = "DE",
Fee = (2.99m).ToString()
}
};
var workbook = CreateTestWorkbook(headerCol, input);
var sheet = workbook.GetSheetAt(0);
var header = sheet.GetRow(0);
SimpleExcelMapper <LabeledPoco> simpleMapper = new SimpleExcelMapper <LabeledPoco>();
List <LabeledPoco> result = simpleMapper.Map(sheet).ToList();
var expectedResult = new LabeledPoco
{
Title = "Movie I",
ReportDate = DateTime.Now.Date,
ContractID = "xox",
Territory = "DE",
Fee = 2.99m
};
result.First().Title.ShouldBe(expectedResult.Title);
result.First().ReportDate.ShouldBe(expectedResult.ReportDate);
result.First().ContractID.ShouldNotBe(expectedResult.ContractID);
result.First().Territory.ShouldNotBe(expectedResult.Territory);
result.First().Fee.ShouldBe(expectedResult.Fee);
}
public void Test_Generic_Mapping()
{
//arrange
var headerCol = new InputPoco()
{
Title = "Title",
ReportDate = "Date",
ContractID = "ContractId",
Territory = "Territory",
Fee = "Fee"
};
var input = new List <InputPoco> {
new InputPoco
{
Title = "Movie I",
ReportDate = DateTime.Now.Date.ToString(),
ContractID = "xox",
Territory = "DE",
Fee = (2.99m).ToString()
}
};
var workbook = CreateTestWorkbook(headerCol, input);
var sheet = workbook.GetSheetAt(0);
var header = sheet.GetRow(0);
SimpleExcelMapper <LabeledPoco> simpleMapper = new SimpleExcelMapper <LabeledPoco>();
List <LabeledPoco> result = simpleMapper.Map(sheet).ToList();
var expectedResult = new LabeledPoco
{
Title = "Movie I",
ReportDate = DateTime.Now.Date,
ContractID = "xox",
Territory = "DE",
Fee = 2.99m
};
result.Count().ShouldBe(1);
result.First().Title.ShouldBe(expectedResult.Title);
result.First().ReportDate.ShouldBe(expectedResult.ReportDate);
result.First().ContractID.ShouldBe(expectedResult.ContractID);
result.First().Territory.ShouldBe(expectedResult.Territory);
result.First().Fee.ShouldBe(expectedResult.Fee);
}
