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