public int DoDepartment(OleDbDataReader dr, DbContext db)
{
int count = 0;
while (dr.Read()) // read per record/row from a table/sheet
{
BranchOffice b = _branchOfficeService.GetObjectByName(dr.GetString(2)); // column 2 = branch name
Department obj = new Department
{
Code = dr.GetString(0),
Name = dr.GetString(1),
BranchOfficeId = b.Id,
};
if (!_departmentService.CreateObject(obj, _branchOfficeService).Errors.Any())
{
count++;
Division d = new Division
{
Code = obj.Code,
Name = obj.Name,
DepartmentId = obj.Id,
};
_divisionService.CreateObject(d, _departmentService);
}
;
}
return(count);
}
