public void ImportExcelToPersonnelTest() { IExcelImporter impoerter = new ExcelPersonnelNameImporter(); ExcelStructreTable tbl = impoerter.GetTableTemplate(); var exelUrlWithWrongGroupids = "D:\\temp\\work\\personnel - Copy.xlsx"; Stream stream = File.OpenRead(exelUrlWithWrongGroupids); tbl.Confirmed = true; impoerter.ImportExcel(stream, tbl); impoerter.ValidateModels(); var WorkGroupscount = 0; var personnelcount = 0; using (var db = new EngineContext()) { WorkGroupscount = db.WorkGroups.Count(); personnelcount = db.Personnels.Count(); } impoerter.Save(); // آیا ذخیره می کند using (var db = new EngineContext()) { Assert.True(WorkGroupscount <= db.WorkGroups.Count()); Assert.True(personnelcount <= db.Personnels.Count()); WorkGroupscount = db.WorkGroups.Count(); personnelcount = db.Personnels.Count(); } impoerter.Save(); // باید اگر دوباره ذخیره کردیم ، باید اپدییت کند و جدید ذخیره نکند using (var db = new EngineContext()) { Assert.True(WorkGroupscount == db.WorkGroups.Count()); Assert.True(personnelcount == db.Personnels.Count()); } }
public void ImportExcelToPersonnelTestWrongFileStructure() { try { IExcelImporter impoerter = new ExcelPersonnelNameImporter(); ExcelStructreTable tbl = impoerter.GetTableTemplate(); var exelUrl = "D:\\temp\\work\\wrong.xlsx"; Stream stream = File.OpenRead(exelUrl); impoerter.ImportExcel(stream, tbl); Assert.True(false); } catch (ExcelImporterException E) { Assert.True(true); } }
public void ImportExcelToBiometryDataTestNotConfirmed() { IExcelImporter impoerter = new ExcelPersonnelNameImporter(); ExcelStructreTable tbl = impoerter.GetTableTemplate(); var exelUrl = "D:\\temp\\work\\personnel.xlsx"; Stream stream = File.OpenRead(exelUrl); impoerter.ImportExcel(stream, tbl); try { impoerter.ValidateModels(); Assert.True(false); } catch (ExcelImporterException e) { Assert.True(true); } }
public void ImportExcelToPersonnelWrongGroupIds() { IExcelImporter impoerter = new ExcelPersonnelNameImporter(); ExcelStructreTable tbl = impoerter.GetTableTemplate(); var exelUrlWithWrongGroupids = "D:\\temp\\work\\personnel.xlsx"; Stream stream = File.OpenRead(exelUrlWithWrongGroupids); tbl.Confirmed = true; impoerter.ImportExcel(stream, tbl); try { impoerter.ValidateModels(); Assert.True(false); } catch (ExcelImporterException e) { Assert.True(true); } }