@Transactional(readOnly=false ,rollbackFor=Exception.class)
 public void replaceEmployeeIDForDuplicateTCKNO(Employee employee) {
  
  Query query=null;
  int rowCount;
  List<Employee> list = getAllDuplicate(employee);
  for (Employee emp : list) {
  
   if(!emp.equals(employee)){
    
   query =entityManager.createNativeQuery("update LMS_ABSENCE a SET a.EMPLOYEE_ID =:employeeID where a.EMPLOYEE_ID =:exchangeEmpID")
     .setParameter("employeeID", employee.id)
     .setParameter("exchangeEmpID", emp.id);
     rowCount= query.executeUpdate();
     System.out.println("LMS_ABSENCE Rows affected:  " +rowCount);

   query =entityManager.createNativeQuery("update LMS_ASSIGNMENT asa SET asa.EMPLOYEE_ID =:employeeID where asa.EMPLOYEE_ID =:exchangeEmpID")
     .setParameter("employeeID", employee.id)
     .setParameter("exchangeEmpID", emp.id);
     rowCount= query.executeUpdate();
     System.out.println("LMS_ASSIGNMENT Rows affected: " +rowCount);