* @param stageCollection A Collection of DDNameValues.
* @see com.centraview.common.DDNameValue
*/
private void updateStages(Collection stageCollection)
{
CVDal cvdl = new CVDal(dataSource);
try {
if (stageCollection != null) {
StringBuffer stringBuffer = new StringBuffer();
Iterator it = stageCollection.iterator();
while (it.hasNext()) {
DDNameValue sourceObject = (DDNameValue) it.next();
// System.out.println("[DEBUG] [AppSettingsEJB]: sourceObject: " +
// sourceObject.toString());
if (sourceObject.getName() != null && sourceObject.getId() == -1) {
// create a new Source Record
cvdl.setSqlQueryToNull();
cvdl.setSqlQuery("INSERT INTO salesstage (Name) VALUES (?)");
cvdl.setString(1, sourceObject.getName());
cvdl.executeUpdate();
int newId = cvdl.getAutoGeneratedKey();
stringBuffer.append(newId);
} // end of if statement (sourceObject.getName() != null ...
else if (sourceObject.getName() != null) {
// update the existing Source Record
cvdl.setSqlQueryToNull();
cvdl.setSqlQuery("UPDATE salesstage SET Name = ? WHERE SalesStageID = ?");
cvdl.setString(1, sourceObject.getName());
cvdl.setInt(2, sourceObject.getId());
cvdl.executeUpdate();
stringBuffer.append(sourceObject.getId());
} // end of else if statement (sourceObject.getName() != null)
if (stringBuffer.length() > 0 && it.hasNext()) {
stringBuffer.append(", ");
}
} // end of while loop (it.hasNext())
if (stringBuffer.length() > 0) {
cvdl.setSqlQueryToNull();
cvdl.setSqlQuery("DELETE FROM salesstage WHERE SalesStageID NOT IN (" + stringBuffer + ")");
cvdl.executeUpdate();
} // end of if statement (stringBuffer.length() > 0)
} // end of if statement (sourceValues != null)
} // end of try block
catch (Exception e) {
logger.error("[updateStages]: Exception", e);
} finally {
cvdl.destroy();
} // end of finally block
} // end of updateStages method