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