public void InstanceEntitiesFromExcelSampleOne()
{
var mainEntityInstance = new MainEntity();
var helper = new Xls2ObjectHelper();
var appDir = AppDomain.CurrentDomain.BaseDirectory;
var assemblyFileName = Path.Combine(appDir, AssemblySampleFolder, sampleAssemblyNAme);
var assemblyStream = File.Open(assemblyFileName, FileMode.Open, FileAccess.Read);
helper.LoadAssembly(assemblyStream);
var excelSampleOneStream = File.Open(Path.Combine(appDir, ExcelSamplesFolder, ExcelsampleOneName), FileMode.Open);
var importSettingsFileName = Path.Combine(appDir, ImportSettingsFolder, ExcelSampleOneMainEntitySettingsName);
var importSettingsFileStream = File.Open(importSettingsFileName, FileMode.Open, FileAccess.Read);
var list = helper.GetObjectsFromExcel(excelSampleOneStream, importSettingsFileStream);
var castedList = new List <MainEntity>();
foreach (var entity in list)
{
var castedEntity = new MainEntity();
castedEntity.MainEntityId = entity.MainEntityId;
castedEntity.StringFieldSample = entity.StringFieldSample;
castedEntity.DateTimeFieldSample = entity.DateTimeFieldSample;
castedList.Add(castedEntity);
}
excelSampleOneStream.Close();
importSettingsFileStream.Close();
assemblyStream.Close();
Assert.AreEqual(castedList.Count, 3);
Assert.AreEqual(castedList[2].StringFieldSample, "you need to load");
}
public void ValidateBlankMainEntitySettingsCreation()
{
var instance = new MainEntity();
var helper = new Xls2ObjectHelper();
string blankMainEntityImportSettings = helper.CreateImportSettingsJsonByClass(instance, 2, null);
var appDir = AppDomain.CurrentDomain.BaseDirectory;
var blankMainEntityImportSettingsFileContent = File.ReadAllText(Path.Combine(appDir, "ImportSettingsFiles", "BlankMainEntityJsonSettingsSample.json"));
Assert.AreEqual(blankMainEntityImportSettingsFileContent, blankMainEntityImportSettings);
}
