public static void Calc(Stream stream, Action <ExcelPackage> assertAction)
{
var importer = new ConstructionImport(stream);
importer.Import();
using (var excel = new ExcelPackage(stream))
{
ProcessInExcel(excel);
assertAction?.Invoke(excel);
}
}
public static void CalcAndExportExcel(string fileName)
{
var originalFileName = fileName;
var savingFileName = Path.Combine(Path.GetDirectoryName(fileName),
Path.GetFileName(fileName).Replace(".xlsx", "") + "_Processed.xlsx");
var importer = new ConstructionImport(originalFileName);
importer.Import();
using (var excel = new ExcelPackage(new FileInfo(originalFileName)))
{
ProcessInExcel(excel);
excel.SaveAs(new FileInfo(savingFileName));
}
}
public void Construction()
{
BusinessValue();
BusinessFeatureImport();
ConstructionValue();
ImportAndValidate("Construction.xlsx", stream =>
{
var importer = new ConstructionImport(stream);
importer.Import();
var data = Context.Constructions.First();
Assert.AreEqual(1, data.ConstructionValueId);
Assert.AreEqual(201, data.BusinessFeatureId);
Assert.AreEqual(7, data.Ds);
//todo fix all asserts
Assert.AreEqual(importer.RowCount, 4);
Assert.AreEqual(Context.Constructions.Count(), 3);
});
}