public void ValveValuesShouldBeLikeInTheExcel() { //var mapper = new UnitMapper(); List <Valve> valves = new List <Valve>(); List <string> messages = null; string file = "3Rows.xlsx"; string sheetName = "Valve"; var sheet = ExcelWorker.ReadExcel(PathHelper.TestPath(file), sheetName, messages); UnitMapper.AssignValue(valves, sheet, messages); var expected = new List <Valve>() { new Valve { Id = 1, ItemType = "Butterfly valve", Operation = "Manual", Size = 50, ConnectionType = "Wafer", Supplier = "MVV", Manufacturer = "MVV 5.21", UnitPrice = 13 }, new Valve { Id = 2, ItemType = "Butterfly valve", Operation = "Manual", Size = 65, ConnectionType = "Wafer", Supplier = "MVV", Manufacturer = "VAG cerex", UnitPrice = 114 } }; valves.Should().BeEquivalentTo(expected); }
public void EquipmentValuesShouldBeLikeInTheExcel() { //var mapper = new UnitMapper(); List <Equipment> equipments = new List <Equipment>(); List <string> messages = null; string file = "3Rows.xlsx"; string sheetName = "Equipment"; var sheet = ExcelWorker.ReadExcel(PathHelper.TestPath(file), sheetName, messages); UnitMapper.AssignValue(equipments, sheet, messages); var expected = new List <Equipment>() { new Equipment { Id = 1, ItemType = "Blower", Capacity = 25, Pressure = 650, PowerConsumption = 55, Manufacturer = "Kubicek", Model = "80B", UnitPrice = 35000 }, new Equipment { Id = 2, ItemType = "Blower", Capacity = 30, Pressure = 600, PowerConsumption = 60, Manufacturer = "Kubicek", Model = "85B", UnitPrice = 40000 } }; equipments.Should().BeEquivalentTo(expected); }