Package com.cin.translators

Examples of com.cin.translators.DataTranslator

148
149
150
151
152
153
154
155
156
    List<OccupationDTO> theOccupation = null;
   
    Query query = manager.createQuery("SELECT obj from Occupation obj");
   
    List<?> result = query.getResultList();
    DataTranslator aTranslator = new DataTranslator();
    aTranslator.translateToOccupationDTO(result);
    return theOccupation;
  }
View Full Code Here
344
345
346
347
348
349
350
351
352
353
354
      query.append(" i.industrycode =  " + aIndCode);
      query.append(" AND o.occupationcode =  " + aOccCode);
      isCriteria = true;
    } 
    Query queryObj = manager.createQuery(query.toString());
    DataTranslator aTranslator = new DataTranslator();
   
    List<UserDTO> result = aTranslator.translateToUserDTO(queryObj.getResultList());
   
    return result;
  }
View Full Code Here
354
355
356
357
358
359
360
361
362
  }
 
  public List<StateAbbvDTO> findAllStates() {
    Query query = manager.createQuery(
        "SELECT state  from StateAbbv state");
    DataTranslator aTranslator = new DataTranslator();
    List<StateAbbvDTO> result = aTranslator.translateToState(query.getResultList());
    return result;
  }
View Full Code Here
392
393
394
395
396
397
398
399
400
  String aQuery = "select o from Ziptable o where o.statename = :statename " ;
    Query aQueryObject = manager.createQuery(aQuery);
    aQueryObject.setParameter("statename", stateAbbv);
 
  List<?> theZipDetails = aQueryObject.getResultList();
    DataTranslator aTranslator = new DataTranslator();
  return aTranslator.translateToZipDTO(theZipDetails);

}
View Full Code Here
415
416
417
418
419
420
421
422
423
public List<UserDTO> findUserForZip(int pZip)  {
 
  String aQuery = "select o from Userrecord o where o.zip =  '" + pZip + "' " ;
  Query aQueryObject = manager.createQuery(aQuery);
  DataTranslator aTranslator = new DataTranslator();
  List<?> theUserDetails = aQueryObject.getResultList();
  return aTranslator.translateToUserDTO(theUserDetails);
}
View Full Code Here
611
612
613
614
615
616
617
618
619
620
621
  public UserDTO checkUserExistence(GenericRequest pRequest) {
    // TODO: this can't be right
    UserDTO uDto = new UserDTO();
   
    DataTranslator aTranslator = new DataTranslator();

    if ((uDto = userFactory.findUserBySsn(pRequest.getUser().getSsn())) == null)
    {    System.out.println("Failed to authenticate: SSN not found");
    return null ;
    }
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
    String aMarital = pDTO.getMaritalStatus();
    if( aMarital != null ){
      aMarital = aMarital.trim();
    }
   
    DataTranslator aTranslator = new DataTranslator();
    StringBuilder aQuery = new StringBuilder();
    aQuery.append("SELECT u ");
    aQuery.append("FROM Userrecord u LEFT JOIN u.job j LEFT JOIN j.occupation o LEFT JOIN u.education e ");
       
    if(aZipCode != null && aZipCode.trim().length() > 0) {
      aQuery.append(" WHERE ");
      aQuery.append("u.zip = '" + aZipCode + "' ");
      isSet = true;
    }

    if (anEducation != null && anEducation.trim().length() > 0) {
      if (isSet) {
        aQuery.append(" AND ");
      } else {
        aQuery.append(" WHERE ");
      }
     
      aQuery.append(" UPPER(TRIM( e.education )) like '%" + anEducation.toUpperCase() + "%' ");
      isSet = true;
    }
    if(anOccupation != null && anOccupation.trim().length() > 0 ) {
      int anOccupationCode = this.findOccupationCode(anOccupation);
      if(isSet) {
        aQuery.append(" AND " );
      } else {
        aQuery.append(" WHERE ");
      }
     
      aQuery.append(" o.occupationcode = " + anOccupationCode + " ");
      isSet = true;
    }
    if(aMarital != null && aMarital.trim().length() > 0) {
      if(isSet) {
       
        aQuery.append(" AND " );
      }
      else {
        aQuery.append(" WHERE ");
      }
     
      aQuery.append(" UPPER(TRIM( u.marital )) like '%" + aMarital.toUpperCase() + "%' ");
      isSet = true;
    }
   
    Query aQueryObject = manager.createQuery(aQuery.toString());
    Collection<?> theUserDetails = aQueryObject.getResultList();
    return aTranslator.translateToUserDTO(theUserDetails);
  }
View Full Code Here
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
    }
    return 0;
  }

  public List<UserDTO> findUsersByCode(int pIndCode,int pOccCode) {
    DataTranslator aTranslator = new DataTranslator();
    String selectString = "select u from Userrecord u ";
    StringBuilder whereString = null;
 
   
    if(pOccCode > 0) {
      whereString = new StringBuilder();
      whereString.append("where u.job.occupation.occupationcode = :occupationCode ");
    }

    if(pIndCode > 0) {
      if(whereString == null) {
        whereString = new StringBuilder();
        whereString.append(" where " );
      } else {
        whereString.append(" and ");
      }
     
      whereString.append("u.job.industry.industrycode = :industryCode ");
    }
   
    if( whereString == null ){
      return null;
    }
    Query aQueryObject = manager.createQuery(selectString + whereString.toString());
    if( pOccCode > 0){
      aQueryObject.setParameter("occupationCode", pOccCode);
    }
    if( pIndCode > 0){
      aQueryObject.setParameter("industryCode", pIndCode);
    }
    List<?> theUserDetails = aQueryObject.getResultList();
    return aTranslator.translateToUserDTO(theUserDetails);
  }
View Full Code Here
303
304
305
306
307
308
309
310
311
  }
 
  public List<ZipDTO> findZipForState(String pState){
    String aQuery = "select o from Ziptable o where o.statename =  '" + pState + "' " ;
      Query aQueryObject = manager.createQuery(aQuery);
    DataTranslator aTranslator = new DataTranslator();
    List<?> theZipDetails = aQueryObject.getResultList();
    return aTranslator.translateToZipDTO(theZipDetails);
  }
View Full Code Here
320
321
322
323
324
325
326
327
328
    else {
     
      aQuery = aQuery + " = '" + pZip + "'";
    }
    Query aQueryObject = manager.createQuery(aQuery);
    DataTranslator aTranslator = new DataTranslator();
    List<?> theUserDetails = aQueryObject.getResultList();
    return aTranslator.translateToUserDTO(theUserDetails);
  }
View Full Code Here
TOP

Related Classes of com.cin.translators.DataTranslator

  • com.cin.dto.EmploymentStatusDTO
  • com.cin.dto.OccupationDTO
  • com.cin.dto.StateAbbvDTO
  • com.cin.dto.UserDTO
  • com.cin.dto.ZipDTO
  • com.cin.ejb.transactionejb.TransactionEJB
  • com.cin.ejb.transactionejb.UserFactoryEJB
  • com.cin.service.CensusInsuranceService
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.