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