public void deleteFeeDetailByTenantIdx(CFSecurityAuthorization Authorization, long TenantId) {
final String S_ProcName = "deleteFeeDetailByTenantIdx";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql = "exec sp_delete_feedtl_by_tenantidx ?, ?, ?, ?, ?" + ", " + "?";
if (stmtDeleteByTenantIdx == null) {
stmtDeleteByTenantIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByTenantIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByTenantIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByTenantIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByTenantIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByTenantIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByTenantIdx.setLong(argIdx++, TenantId);
Object stuff = null;
boolean moreResults = stmtDeleteByTenantIdx.execute();
while (stuff == null) {
try {
moreResults = stmtDeleteByTenantIdx.getMoreResults();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
if (moreResults) {
try {
stuff = stmtDeleteByTenantIdx.getResultSet();
} catch (SQLException e) {
}
} else if (-1 == stmtDeleteByTenantIdx.getUpdateCount()) {
break;
}
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFCrmContactListBuff lockBuff(
CFSecurityAuthorization Authorization, CFCrmContactListPKey PKey) {
final String S_ProcName = "lockBuff";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
long TenantId = PKey.getRequiredTenantId();
long ContactListId = PKey.getRequiredContactListId();
String sql =
"SELECT * FROM "
+ schema.getLowerDbSchemaName()
+ ".sp_lock_ctclst( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtLockBuffByPKey == null) {
stmtLockBuffByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtLockBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtLockBuffByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtLockBuffByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtLockBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtLockBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtLockBuffByPKey.setLong(argIdx++, TenantId);
stmtLockBuffByPKey.setLong(argIdx++, ContactListId);
resultSet = stmtLockBuffByPKey.executeQuery();
if (resultSet.next()) {
CFCrmContactListBuff buff = unpackContactListResultSetToBuff(resultSet);
if (resultSet.next()) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(getClass(), S_ProcName, "Did not expect multi-record response");
}
return (buff);
} else {
return (null);
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFSecurityTSecGroupBuff[] readBuffByTenantVisIdx(
CFSecurityAuthorization Authorization, long TenantId, boolean IsVisible) {
final String S_ProcName = "readBuffByTenantVisIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql = "exec sp_read_tsecgrp_by_tenantvisidx ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?";
if (stmtReadBuffByTenantVisIdx == null) {
stmtReadBuffByTenantVisIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByTenantVisIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByTenantVisIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByTenantVisIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByTenantVisIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByTenantVisIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByTenantVisIdx.setLong(argIdx++, TenantId);
if (IsVisible) {
stmtReadBuffByTenantVisIdx.setString(argIdx++, "Y");
} else {
stmtReadBuffByTenantVisIdx.setString(argIdx++, "N");
}
resultSet = stmtReadBuffByTenantVisIdx.executeQuery();
List<CFSecurityTSecGroupBuff> buffList = new LinkedList<CFSecurityTSecGroupBuff>();
while (resultSet.next()) {
CFSecurityTSecGroupBuff buff = unpackTSecGroupResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecurityTSecGroupBuff[] retBuff = new CFSecurityTSecGroupBuff[buffList.size()];
Iterator<CFSecurityTSecGroupBuff> iter = buffList.iterator();
while (iter.hasNext()) {
retBuff[idx++] = iter.next();
}
return (retBuff);
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public void deleteContactListByUDescrIdx(
CFSecurityAuthorization Authorization, long argTenantId, String argDescription) {
final String S_ProcName = "deleteContactListByUDescrIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"SELECT "
+ schema.getLowerDbSchemaName()
+ ".sp_delete_ctclst_by_udescridx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ) as DeletedFlag";
if (stmtDeleteByUDescrIdx == null) {
stmtDeleteByUDescrIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByUDescrIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByUDescrIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByUDescrIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByUDescrIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByUDescrIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByUDescrIdx.setLong(argIdx++, argTenantId);
stmtDeleteByUDescrIdx.setString(argIdx++, argDescription);
resultSet = stmtDeleteByUDescrIdx.executeQuery();
if (resultSet.next()) {
boolean deleteFlag = resultSet.getBoolean(1);
if (resultSet.next()) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(getClass(), S_ProcName, "Did not expect multi-record response");
}
} else {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected 1 record result set to be returned by delete, not 0 rows");
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public void deleteISOTimezone(
CFSecurityAuthorization Authorization, CFSecurityISOTimezoneBuff Buff) {
final String S_ProcName = "deleteISOTimezone";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
short ISOTimezoneId = Buff.getRequiredISOTimezoneId();
final String sql = "CALL sp_delete_isotz( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )";
if (stmtDeleteByPKey == null) {
stmtDeleteByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByPKey.setShort(argIdx++, ISOTimezoneId);
stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision());
;
resultSet = stmtDeleteByPKey.executeQuery();
if (resultSet.next()) {
int deleteFlag = resultSet.getInt(1);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
} else {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected 1 record result set to be returned by delete, not 0 rows");
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFCrmMemoDataBuff[] readBuffByMemoDataCtcIdx(
CFSecurityAuthorization Authorization, long TenantId, long ContactId) {
final String S_ProcName = "readBuffByMemoDataCtcIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"{ call sp_read_memodata_by_memodatactcidx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ) }";
if (stmtReadBuffByMemoDataCtcIdx == null) {
stmtReadBuffByMemoDataCtcIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByMemoDataCtcIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByMemoDataCtcIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByMemoDataCtcIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByMemoDataCtcIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByMemoDataCtcIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByMemoDataCtcIdx.setLong(argIdx++, TenantId);
stmtReadBuffByMemoDataCtcIdx.setLong(argIdx++, ContactId);
resultSet = stmtReadBuffByMemoDataCtcIdx.executeQuery();
List<CFCrmMemoDataBuff> buffList = new LinkedList<CFCrmMemoDataBuff>();
if (resultSet != null) {
while (resultSet.next()) {
CFCrmMemoDataBuff buff = unpackMemoDataResultSetToBuff(resultSet);
buffList.add(buff);
}
}
int idx = 0;
CFCrmMemoDataBuff[] retBuff = new CFCrmMemoDataBuff[buffList.size()];
Iterator<CFCrmMemoDataBuff> iter = buffList.iterator();
while (iter.hasNext()) {
retBuff[idx++] = iter.next();
}
return (retBuff);
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public void deleteISOCountryLanguage(
CFSecurityAuthorization Authorization, CFSecurityISOCountryLanguageBuff Buff) {
final String S_ProcName = "deleteISOCountryLanguage";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
short ISOCountryId = Buff.getRequiredISOCountryId();
short ISOLanguageId = Buff.getRequiredISOLanguageId();
String sql =
"call "
+ schema.getLowerDbSchemaName()
+ ".sp_delete_iso_cntrylng( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtDeleteByPKey == null) {
stmtDeleteByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByPKey.setShort(argIdx++, ISOCountryId);
stmtDeleteByPKey.setShort(argIdx++, ISOLanguageId);
stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision());
;
stmtDeleteByPKey.executeUpdate();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFAccFeeDetailBuff lockBuff(
CFSecurityAuthorization Authorization, CFAccFeeDetailPKey PKey) {
final String S_ProcName = "lockBuff";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
long TenantId = PKey.getRequiredTenantId();
long FeeDetailId = PKey.getRequiredFeeDetailId();
String sql = "exec sp_lock_feedtl ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?";
if (stmtLockBuffByPKey == null) {
stmtLockBuffByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtLockBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtLockBuffByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtLockBuffByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtLockBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtLockBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtLockBuffByPKey.setLong(argIdx++, TenantId);
stmtLockBuffByPKey.setLong(argIdx++, FeeDetailId);
resultSet = stmtLockBuffByPKey.executeQuery();
if (resultSet.next()) {
CFAccFeeDetailBuff buff = unpackFeeDetailResultSetToBuff(resultSet);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
return (buff);
} else {
return (null);
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFCrmContactListBuff readBuffByUDescrIdx(
CFSecurityAuthorization Authorization, long TenantId, String Description) {
final String S_ProcName = "readBuffByUDescrIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"SELECT * FROM "
+ schema.getLowerDbSchemaName()
+ ".sp_read_ctclst_by_udescridx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtReadBuffByUDescrIdx == null) {
stmtReadBuffByUDescrIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByUDescrIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUDescrIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByUDescrIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByUDescrIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUDescrIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByUDescrIdx.setLong(argIdx++, TenantId);
stmtReadBuffByUDescrIdx.setString(argIdx++, Description);
resultSet = stmtReadBuffByUDescrIdx.executeQuery();
if (resultSet.next()) {
CFCrmContactListBuff buff = unpackContactListResultSetToBuff(resultSet);
if (resultSet.next()) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(getClass(), S_ProcName, "Did not expect multi-record response");
}
return (buff);
} else {
return (null);
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFCrmMemoDataBuff readBuffByIdIdx(
CFSecurityAuthorization Authorization, long TenantId, long MemoId) {
final String S_ProcName = "readBuffByIdIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"{ call sp_read_memodata_by_ididx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " ) }";
if (stmtReadBuffByIdIdx == null) {
stmtReadBuffByIdIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByIdIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByIdIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByIdIdx.setLong(argIdx++, TenantId);
stmtReadBuffByIdIdx.setLong(argIdx++, MemoId);
resultSet = stmtReadBuffByIdIdx.executeQuery();
if ((resultSet != null) && resultSet.next()) {
CFCrmMemoDataBuff buff = unpackMemoDataResultSetToBuff(resultSet);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
return (buff);
} else {
return (null);
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFSecurityISOTimezoneBuff[] readBuffByOffsetIdx(
CFSecurityAuthorization Authorization, short TZHourOffset, short TZMinOffset) {
final String S_ProcName = "readBuffByOffsetIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
final String sql =
"CALL sp_read_isotz_by_offsetidx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )";
if (stmtReadBuffByOffsetIdx == null) {
stmtReadBuffByOffsetIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByOffsetIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByOffsetIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByOffsetIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByOffsetIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByOffsetIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByOffsetIdx.setShort(argIdx++, TZHourOffset);
stmtReadBuffByOffsetIdx.setShort(argIdx++, TZMinOffset);
resultSet = stmtReadBuffByOffsetIdx.executeQuery();
List<CFSecurityISOTimezoneBuff> buffList = new LinkedList<CFSecurityISOTimezoneBuff>();
while (resultSet.next()) {
CFSecurityISOTimezoneBuff buff = unpackISOTimezoneResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecurityISOTimezoneBuff[] retBuff = new CFSecurityISOTimezoneBuff[buffList.size()];
Iterator<CFSecurityISOTimezoneBuff> iter = buffList.iterator();
while (iter.hasNext()) {
retBuff[idx++] = iter.next();
}
return (retBuff);
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFSecurityISOCountryLanguageBuff[] readAllBuff(CFSecurityAuthorization Authorization) {
final String S_ProcName = "readAllBuff";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"call " + schema.getLowerDbSchemaName() + ".sp_read_iso_cntrylng_all( ?, ?, ?, ?, ? )";
if (stmtReadAllBuff == null) {
stmtReadAllBuff = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadAllBuff.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadAllBuff.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
try {
resultSet = stmtReadAllBuff.executeQuery();
} catch (SQLException e) {
if (e.getErrorCode() != 1329) {
throw e;
}
resultSet = null;
}
List<CFSecurityISOCountryLanguageBuff> buffList =
new LinkedList<CFSecurityISOCountryLanguageBuff>();
while ((resultSet != null) && resultSet.next()) {
CFSecurityISOCountryLanguageBuff buff = unpackISOCountryLanguageResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecurityISOCountryLanguageBuff[] retBuff =
new CFSecurityISOCountryLanguageBuff[buffList.size()];
Iterator<CFSecurityISOCountryLanguageBuff> iter = buffList.iterator();
while (iter.hasNext()) {
retBuff[idx++] = iter.next();
}
return (retBuff);
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public void deleteFeeDetailByIdIdx(
CFSecurityAuthorization Authorization, long argTenantId, long argFeeDetailId) {
final String S_ProcName = "deleteFeeDetailByIdIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"begin call "
+ schema.getLowerDbSchemaName()
+ ".dl_feedtlbyididx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ); end";
if (stmtDeleteByIdIdx == null) {
stmtDeleteByIdIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByIdIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByIdIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByIdIdx.setLong(argIdx++, argTenantId);
stmtDeleteByIdIdx.setLong(argIdx++, argFeeDetailId);
int rowsUpdated = stmtDeleteByIdIdx.executeUpdate();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public void createFeeDetail(CFSecurityAuthorization Authorization, CFAccFeeDetailBuff Buff) {
final String S_ProcName = "createFeeDetail";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
long TenantId = Buff.getRequiredTenantId();
long FeeId = Buff.getRequiredFeeId();
String Description = Buff.getRequiredDescription();
BigDecimal AmountCharged = Buff.getRequiredAmountCharged();
Connection cnx = schema.getCnx();
String sql =
"exec sp_create_feedtl ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?";
if (stmtCreateByPKey == null) {
stmtCreateByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtCreateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtCreateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtCreateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtCreateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtCreateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtCreateByPKey.setString(argIdx++, "FEDT");
stmtCreateByPKey.setLong(argIdx++, TenantId);
stmtCreateByPKey.setLong(argIdx++, FeeId);
stmtCreateByPKey.setString(argIdx++, Description);
stmtCreateByPKey.setBigDecimal(argIdx++, AmountCharged);
resultSet = stmtCreateByPKey.executeQuery();
if (resultSet.next()) {
CFAccFeeDetailBuff createdBuff = unpackFeeDetailResultSetToBuff(resultSet);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
Buff.setRequiredTenantId(createdBuff.getRequiredTenantId());
Buff.setRequiredFeeId(createdBuff.getRequiredFeeId());
Buff.setRequiredFeeDetailId(createdBuff.getRequiredFeeDetailId());
Buff.setRequiredDescription(createdBuff.getRequiredDescription());
Buff.setRequiredAmountCharged(createdBuff.getRequiredAmountCharged());
Buff.setRequiredRevision(createdBuff.getRequiredRevision());
Buff.setCreatedByUserId(createdBuff.getCreatedByUserId());
Buff.setCreatedAt(createdBuff.getCreatedAt());
Buff.setUpdatedByUserId(createdBuff.getUpdatedByUserId());
Buff.setUpdatedAt(createdBuff.getUpdatedAt());
} else {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected a single-record response, " + resultSet.getRow() + " rows selected");
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
/**
* Release the prepared statements.
*
* <p>When the schema changes connections, the prepared statements have to be released because
* they contain connection-specific information for most databases.
*/
public void releasePreparedStatements() {
final String S_ProcName = "releasePreparedStatements";
S_sqlSelectFeeDetailDistinctClassCode = null;
S_sqlSelectFeeDetailBuff = null;
if (stmtReadBuffByPKey != null) {
try {
stmtReadBuffByPKey.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
}
stmtReadBuffByPKey = null;
}
if (stmtLockBuffByPKey != null) {
try {
stmtLockBuffByPKey.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
}
stmtLockBuffByPKey = null;
}
if (stmtCreateByPKey != null) {
try {
stmtCreateByPKey.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
}
stmtCreateByPKey = null;
}
if (stmtUpdateByPKey != null) {
try {
stmtUpdateByPKey.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
}
stmtUpdateByPKey = null;
}
if (stmtDeleteByPKey != null) {
try {
stmtDeleteByPKey.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
}
stmtDeleteByPKey = null;
}
if (stmtReadAllBuff != null) {
try {
stmtReadAllBuff.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtReadAllBuff = null;
}
}
if (stmtReadBuffByTenantIdx != null) {
try {
stmtReadBuffByTenantIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtReadBuffByTenantIdx = null;
}
}
if (stmtReadBuffByFeeIdx != null) {
try {
stmtReadBuffByFeeIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtReadBuffByFeeIdx = null;
}
}
if (stmtDeleteByTenantIdx != null) {
try {
stmtDeleteByTenantIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtDeleteByTenantIdx = null;
}
}
if (stmtDeleteByFeeIdx != null) {
try {
stmtDeleteByFeeIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtDeleteByFeeIdx = null;
}
}
if (stmtReadBuffByTenantIdx != null) {
try {
stmtReadBuffByTenantIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtReadBuffByTenantIdx = null;
}
}
if (stmtReadBuffByFeeIdx != null) {
try {
stmtReadBuffByFeeIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtReadBuffByFeeIdx = null;
}
}
}
public CFSecurityISOCountryLanguageBuff readBuffByIdIdx(
CFSecurityAuthorization Authorization, short ISOCountryId, short ISOLanguageId) {
final String S_ProcName = "readBuffByIdIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"call "
+ schema.getLowerDbSchemaName()
+ ".sp_read_iso_cntrylng_by_ididx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtReadBuffByIdIdx == null) {
stmtReadBuffByIdIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByIdIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByIdIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByIdIdx.setShort(argIdx++, ISOCountryId);
stmtReadBuffByIdIdx.setShort(argIdx++, ISOLanguageId);
try {
resultSet = stmtReadBuffByIdIdx.executeQuery();
} catch (SQLException e) {
if (e.getErrorCode() != 1329) {
throw e;
}
resultSet = null;
}
if ((resultSet != null) && resultSet.next()) {
CFSecurityISOCountryLanguageBuff buff = unpackISOCountryLanguageResultSetToBuff(resultSet);
if ((resultSet != null) && resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
return (buff);
} else {
return (null);
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public void updateContactList(CFSecurityAuthorization Authorization, CFCrmContactListBuff Buff) {
final String S_ProcName = "updateContactList";
ResultSet resultSet = null;
try {
long ContactListId = Buff.getRequiredContactListId();
long TenantId = Buff.getRequiredTenantId();
String Description = Buff.getRequiredDescription();
int Revision = Buff.getRequiredRevision();
Connection cnx = schema.getCnx();
String sql =
"select * from "
+ schema.getLowerDbSchemaName()
+ ".sp_update_ctclst( ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtUpdateByPKey == null) {
stmtUpdateByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtUpdateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtUpdateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtUpdateByPKey.setString(argIdx++, "CTL");
stmtUpdateByPKey.setLong(argIdx++, ContactListId);
stmtUpdateByPKey.setLong(argIdx++, TenantId);
stmtUpdateByPKey.setString(argIdx++, Description);
stmtUpdateByPKey.setInt(argIdx++, Revision);
resultSet = stmtUpdateByPKey.executeQuery();
if (resultSet.next()) {
CFCrmContactListBuff updatedBuff = unpackContactListResultSetToBuff(resultSet);
if (resultSet.next()) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(getClass(), S_ProcName, "Did not expect multi-record response");
}
Buff.setRequiredDescription(updatedBuff.getRequiredDescription());
Buff.setRequiredRevision(updatedBuff.getRequiredRevision());
} else {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected a single-record response, " + resultSet.getRow() + " rows selected");
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public void updateISOCountryLanguage(
CFSecurityAuthorization Authorization, CFSecurityISOCountryLanguageBuff Buff) {
final String S_ProcName = "updateISOCountryLanguage";
ResultSet resultSet = null;
try {
short ISOCountryId = Buff.getRequiredISOCountryId();
short ISOLanguageId = Buff.getRequiredISOLanguageId();
int Revision = Buff.getRequiredRevision();
Connection cnx = schema.getCnx();
String sql =
"call "
+ schema.getLowerDbSchemaName()
+ ".sp_update_iso_cntrylng( ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtUpdateByPKey == null) {
stmtUpdateByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtUpdateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtUpdateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtUpdateByPKey.setString(argIdx++, "ISCL");
stmtUpdateByPKey.setShort(argIdx++, ISOCountryId);
stmtUpdateByPKey.setShort(argIdx++, ISOLanguageId);
stmtUpdateByPKey.setInt(argIdx++, Revision);
try {
resultSet = stmtUpdateByPKey.executeQuery();
} catch (SQLException e) {
if (e.getErrorCode() != 1329) {
throw e;
}
resultSet = null;
}
if ((resultSet != null) && resultSet.next()) {
CFSecurityISOCountryLanguageBuff updatedBuff =
unpackISOCountryLanguageResultSetToBuff(resultSet);
if ((resultSet != null) && resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
Buff.setRequiredRevision(updatedBuff.getRequiredRevision());
} else {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected a single-record response, " + resultSet.getRow() + " rows selected");
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public void createMemoData(CFSecurityAuthorization Authorization, CFCrmMemoDataBuff Buff) {
final String S_ProcName = "createMemoData";
if ("MMOD".equals(Buff.getClassCode())
&& (!schema.isTenantUser(Authorization, Buff.getRequiredTenantId(), "CreateMemoData"))) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Permission denied -- User not part of TSecGroup CreateMemoData");
}
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
try {
Connection cnx = schema.getCnx();
long TenantId = Buff.getRequiredTenantId();
long MemoId = Buff.getRequiredMemoId();
long ContactId = Buff.getRequiredContactId();
String Memo = Buff.getRequiredMemo();
int Revision = 1;
String sql =
"INSERT INTO "
+ schema.getLowerDbSchemaName()
+ "..MemoData( "
+ "forcesynclock, "
+ "createdby, "
+ "createdat, "
+ "updatedby, "
+ "updatedat, "
+ "tenantid, "
+ "memoid, "
+ "contactid, "
+ "memo"
+ ", revision )"
+ "VALUES ( "
+ "0, "
+ " ?, "
+ " getdate(), "
+ " ?, "
+ " getdate(), "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "1 )";
if (stmtCreateByPKey == null) {
stmtCreateByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtCreateByPKey.setString(argIdx++, Authorization.getSecUserId().toString());
stmtCreateByPKey.setString(argIdx++, Authorization.getSecUserId().toString());
stmtCreateByPKey.setLong(argIdx++, TenantId);
stmtCreateByPKey.setLong(argIdx++, MemoId);
stmtCreateByPKey.setLong(argIdx++, ContactId);
stmtCreateByPKey.setString(argIdx++, Memo);
int rowsAffected = stmtCreateByPKey.executeUpdate();
if (rowsAffected != 1) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected 1 row to be affected by insert, not " + rowsAffected);
}
Buff.setRequiredRevision(Revision);
String sqlAuditCreated =
"INSERT INTO "
+ schema.getLowerDbSchemaName()
+ "..MemoData_h( auditclusterid, "
+ " auditsessionid, "
+ " auditstamp"
+ ", "
+ "tenantid"
+ ", "
+ "memoid"
+ ", "
+ "contactid"
+ ", "
+ "memo"
+ ", "
+ " revision, "
+ " auditaction ) "
+ "SELECT ?, ?, sysdatetime()"
+ ", "
+ "mmod.tenantid"
+ ", "
+ "mmod.memoid"
+ ", "
+ "mmod.contactid"
+ ", "
+ "mmod.memo"
+ ", "
+ " mmod.revision, "
+ " 0"
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..MemoData AS mmod "
+ " WHERE "
+ "mmod.tenantid = ? "
+ "AND mmod.memoid = ? ";
if (stmtAuditCreatedByPKey == null) {
stmtAuditCreatedByPKey = cnx.prepareStatement(sqlAuditCreated);
}
argIdx = 1;
stmtAuditCreatedByPKey.setLong(argIdx++, Authorization.getSecClusterId());
stmtAuditCreatedByPKey.setString(argIdx++, Authorization.getSecSessionId().toString());
stmtAuditCreatedByPKey.setLong(argIdx++, TenantId);
stmtAuditCreatedByPKey.setLong(argIdx++, MemoId);
int rowsAudited = stmtAuditCreatedByPKey.executeUpdate();
if (rowsAudited != 1) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected 1 row to be affected by audit via insert-selected, not " + rowsAffected);
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
}
public CFCrmMemoDataBuff lockBuff(CFSecurityAuthorization Authorization, CFCrmMemoDataPKey PKey) {
final String S_ProcName = "lockBuff";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
long TenantId = PKey.getRequiredTenantId();
long MemoId = PKey.getRequiredMemoId();
String sql = "{ call sp_lock_memodata( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " ) }";
if (stmtLockBuffByPKey == null) {
stmtLockBuffByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtLockBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtLockBuffByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtLockBuffByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtLockBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtLockBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtLockBuffByPKey.setLong(argIdx++, TenantId);
stmtLockBuffByPKey.setLong(argIdx++, MemoId);
stmtLockBuffByPKey.execute();
boolean moreResults = true;
resultSet = null;
while (resultSet == null) {
try {
moreResults = stmtLockBuffByPKey.getMoreResults();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
if (moreResults) {
try {
resultSet = stmtLockBuffByPKey.getResultSet();
} catch (SQLException e) {
}
} else if (-1 == stmtLockBuffByPKey.getUpdateCount()) {
break;
}
}
if ((resultSet != null) && resultSet.next()) {
CFCrmMemoDataBuff buff = unpackMemoDataResultSetToBuff(resultSet);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
return (buff);
} else {
return (null);
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
/**
* Release the prepared statements.
*
* <p>When the schema changes connections, the prepared statements have to be released because
* they contain connection-specific information for most databases.
*/
public void releasePreparedStatements() {
final String S_ProcName = "releasePreparedStatements";
S_sqlSelectContactListDistinctClassCode = null;
S_sqlSelectContactListBuff = null;
if (stmtReadBuffByPKey != null) {
try {
stmtReadBuffByPKey.close();
} catch (SQLException e) {
}
stmtReadBuffByPKey = null;
}
if (stmtReadBuffAll != null) {
try {
stmtReadBuffAll.close();
} catch (SQLException e) {
}
stmtReadBuffAll = null;
}
if (stmtLockBuffByPKey != null) {
try {
stmtLockBuffByPKey.close();
} catch (SQLException e) {
}
stmtLockBuffByPKey = null;
}
if (stmtCreateByPKey != null) {
try {
stmtCreateByPKey.close();
} catch (SQLException e) {
}
stmtCreateByPKey = null;
}
if (stmtUpdateByPKey != null) {
try {
stmtUpdateByPKey.close();
} catch (SQLException e) {
}
stmtUpdateByPKey = null;
}
if (stmtDeleteByPKey != null) {
try {
stmtDeleteByPKey.close();
} catch (SQLException e) {
}
stmtDeleteByPKey = null;
}
if (stmtDeleteByIdIdx != null) {
try {
stmtDeleteByIdIdx.close();
} catch (SQLException e) {
}
stmtDeleteByIdIdx = null;
}
if (stmtDeleteByTenantIdx != null) {
try {
stmtDeleteByTenantIdx.close();
} catch (SQLException e) {
}
stmtDeleteByTenantIdx = null;
}
if (stmtDeleteByUDescrIdx != null) {
try {
stmtDeleteByUDescrIdx.close();
} catch (SQLException e) {
}
stmtDeleteByUDescrIdx = null;
}
if (stmtReadAllBuff != null) {
try {
stmtReadAllBuff.close();
} catch (SQLException e) {
}
stmtReadAllBuff = null;
}
if (stmtReadBuffByIdIdx != null) {
try {
stmtReadBuffByIdIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByIdIdx = null;
}
if (stmtReadBuffByTenantIdx != null) {
try {
stmtReadBuffByTenantIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByTenantIdx = null;
}
if (stmtReadBuffByUDescrIdx != null) {
try {
stmtReadBuffByUDescrIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByUDescrIdx = null;
}
}
public void updateMemoData(CFSecurityAuthorization Authorization, CFCrmMemoDataBuff Buff) {
final String S_ProcName = "updateMemoData";
if ("MMOD".equals(Buff.getClassCode())
&& (!schema.isTenantUser(Authorization, Buff.getRequiredTenantId(), "UpdateMemoData"))) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Permission denied -- User not part of TSecGroup UpdateMemoData");
}
try {
Connection cnx = schema.getCnx();
long TenantId = Buff.getRequiredTenantId();
long MemoId = Buff.getRequiredMemoId();
long ContactId = Buff.getRequiredContactId();
String Memo = Buff.getRequiredMemo();
int Revision = Buff.getRequiredRevision();
CFCrmMemoDataPKey pkey = schema.getFactoryMemoData().newPKey();
pkey.setRequiredTenantId(Buff.getRequiredTenantId());
pkey.setRequiredMemoId(Buff.getRequiredMemoId());
CFCrmMemoDataBuff readBuff = lockBuff(Authorization, pkey);
if (readBuff == null) {
throw CFLib.getDefaultExceptionFactory()
.newStaleCacheDetectedException(
getClass(),
S_ProcName,
"Attempted to update record which could not be locked/found",
schema.getLowerDbSchemaName() + "..memodata",
pkey);
}
int oldRevision = readBuff.getRequiredRevision();
if (oldRevision != Revision) {
throw CFLib.getDefaultExceptionFactory()
.newCollisionDetectedException(getClass(), S_ProcName, Buff);
}
int newRevision = Revision + 1;
String sql =
"UPDATE "
+ schema.getLowerDbSchemaName()
+ "..MemoData "
+ "SET "
+ "tenantid = ?"
+ ", "
+ "memoid = ?"
+ ", "
+ "contactid = ?"
+ ", "
+ "memo = ?"
+ ", "
+ "updatedby = ?, "
+ "updatedat = sysdatetime() "
+ ", revision = ? "
+ " WHERE "
+ "tenantid = ? "
+ "AND "
+ "memoid = ? "
+ "AND "
+ "revision = ? ";
if (stmtUpdateByPKey == null) {
stmtUpdateByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtUpdateByPKey.setLong(argIdx++, TenantId);
stmtUpdateByPKey.setLong(argIdx++, MemoId);
stmtUpdateByPKey.setLong(argIdx++, ContactId);
stmtUpdateByPKey.setString(argIdx++, Memo);
stmtUpdateByPKey.setString(argIdx++, Authorization.getSecUserId().toString());
stmtUpdateByPKey.setInt(argIdx++, newRevision);
stmtUpdateByPKey.setLong(argIdx++, TenantId);
stmtUpdateByPKey.setLong(argIdx++, MemoId);
stmtUpdateByPKey.setInt(argIdx++, Revision);
;
int rowsAffected = stmtUpdateByPKey.executeUpdate();
if (rowsAffected != 1) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected 1 row to be affected by update, not " + rowsAffected);
}
Buff.setRequiredRevision(newRevision);
String sqlAuditUpdated =
"INSERT INTO "
+ schema.getLowerDbSchemaName()
+ "..MemoData_h( auditclusterid, "
+ " auditsessionid, "
+ " auditstamp"
+ ", "
+ "tenantid"
+ ", "
+ "memoid"
+ ", "
+ "contactid"
+ ", "
+ "memo"
+ ", "
+ " revision, "
+ " auditaction ) "
+ "SELECT ?, ?, sysdatetime()"
+ ", "
+ "mmod.tenantid"
+ ", "
+ "mmod.memoid"
+ ", "
+ "mmod.contactid"
+ ", "
+ "mmod.memo"
+ ", "
+ " mmod.revision, "
+ " 1 "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..MemoData AS mmod "
+ " WHERE "
+ "mmod.tenantid = ? "
+ "AND mmod.memoid = ? ";
if (stmtAuditUpdatedByPKey == null) {
stmtAuditUpdatedByPKey = cnx.prepareStatement(sqlAuditUpdated);
}
argIdx = 1;
stmtAuditUpdatedByPKey.setLong(argIdx++, Authorization.getSecClusterId());
stmtAuditUpdatedByPKey.setString(argIdx++, Authorization.getSecSessionId().toString());
stmtAuditUpdatedByPKey.setLong(argIdx++, TenantId);
stmtAuditUpdatedByPKey.setLong(argIdx++, MemoId);
int rowsAudited = stmtAuditUpdatedByPKey.executeUpdate();
if (rowsAudited != 1) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected 1 row to be affected by audit via insert-selected, not " + rowsAffected);
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
}
public void updateISOTimezone(
CFSecurityAuthorization Authorization, CFSecurityISOTimezoneBuff Buff) {
final String S_ProcName = "updateISOTimezone";
if ("ITZN".equals(Buff.getClassCode()) && (!schema.isSystemUser(Authorization))) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Permission denied -- only system user can modify ISOTimezone data");
}
ResultSet resultSet = null;
try {
short ISOTimezoneId = Buff.getRequiredISOTimezoneId();
String Iso8601 = Buff.getRequiredIso8601();
String TZName = Buff.getRequiredTZName();
short TZHourOffset = Buff.getRequiredTZHourOffset();
short TZMinOffset = Buff.getRequiredTZMinOffset();
String Description = Buff.getRequiredDescription();
boolean Visible = Buff.getRequiredVisible();
int Revision = Buff.getRequiredRevision();
Connection cnx = schema.getCnx();
final String sql =
"CALL sp_update_isotz( ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtUpdateByPKey == null) {
stmtUpdateByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtUpdateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtUpdateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtUpdateByPKey.setString(argIdx++, "ITZN");
stmtUpdateByPKey.setShort(argIdx++, ISOTimezoneId);
stmtUpdateByPKey.setString(argIdx++, Iso8601);
stmtUpdateByPKey.setString(argIdx++, TZName);
stmtUpdateByPKey.setShort(argIdx++, TZHourOffset);
stmtUpdateByPKey.setShort(argIdx++, TZMinOffset);
stmtUpdateByPKey.setString(argIdx++, Description);
if (Visible) {
stmtUpdateByPKey.setString(argIdx++, "Y");
} else {
stmtUpdateByPKey.setString(argIdx++, "N");
}
stmtUpdateByPKey.setInt(argIdx++, Revision);
resultSet = stmtUpdateByPKey.executeQuery();
if (resultSet.next()) {
CFSecurityISOTimezoneBuff updatedBuff = unpackISOTimezoneResultSetToBuff(resultSet);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
Buff.setRequiredIso8601(updatedBuff.getRequiredIso8601());
Buff.setRequiredTZName(updatedBuff.getRequiredTZName());
Buff.setRequiredTZHourOffset(updatedBuff.getRequiredTZHourOffset());
Buff.setRequiredTZMinOffset(updatedBuff.getRequiredTZMinOffset());
Buff.setRequiredDescription(updatedBuff.getRequiredDescription());
Buff.setRequiredVisible(updatedBuff.getRequiredVisible());
Buff.setRequiredRevision(updatedBuff.getRequiredRevision());
} else {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected a single-record response, " + resultSet.getRow() + " rows selected");
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public void updateTSecGroup(CFSecurityAuthorization Authorization, CFSecurityTSecGroupBuff Buff) {
final String S_ProcName = "updateTSecGroup";
ResultSet resultSet = null;
try {
long TenantId = Buff.getRequiredTenantId();
int TSecGroupId = Buff.getRequiredTSecGroupId();
String Name = Buff.getRequiredName();
boolean IsVisible = Buff.getRequiredIsVisible();
int Revision = Buff.getRequiredRevision();
Connection cnx = schema.getCnx();
String sql =
"exec sp_update_tsecgrp ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?";
if (stmtUpdateByPKey == null) {
stmtUpdateByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtUpdateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtUpdateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtUpdateByPKey.setString(argIdx++, "TGRP");
stmtUpdateByPKey.setLong(argIdx++, TenantId);
stmtUpdateByPKey.setInt(argIdx++, TSecGroupId);
stmtUpdateByPKey.setString(argIdx++, Name);
if (IsVisible) {
stmtUpdateByPKey.setString(argIdx++, "Y");
} else {
stmtUpdateByPKey.setString(argIdx++, "N");
}
stmtUpdateByPKey.setInt(argIdx++, Revision);
resultSet = stmtUpdateByPKey.executeQuery();
if (resultSet.next()) {
CFSecurityTSecGroupBuff updatedBuff = unpackTSecGroupResultSetToBuff(resultSet);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
Buff.setRequiredName(updatedBuff.getRequiredName());
Buff.setRequiredIsVisible(updatedBuff.getRequiredIsVisible());
Buff.setRequiredRevision(updatedBuff.getRequiredRevision());
} else {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected a single-record response, " + resultSet.getRow() + " rows selected");
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public void deleteFeeDetailByIdIdx(
CFSecurityAuthorization Authorization, long TenantId, long FeeDetailId) {
final String S_ProcName = "deleteFeeDetailByIdIdx";
try {
Connection cnx = schema.getCnx();
String sql = "exec sp_delete_feedtl ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?";
if (stmtDeleteByPKey == null) {
stmtDeleteByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByPKey.setLong(argIdx++, TenantId);
stmtDeleteByPKey.setLong(argIdx++, FeeDetailId);
Object stuff = null;
boolean moreResults = stmtDeleteByPKey.execute();
while (stuff == null) {
try {
moreResults = stmtDeleteByPKey.getMoreResults();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
if (moreResults) {
try {
stuff = stmtDeleteByPKey.getResultSet();
} catch (SQLException e) {
}
} else if (-1 == stmtDeleteByPKey.getUpdateCount()) {
break;
}
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
}
/**
* Release the prepared statements.
*
* <p>When the schema changes connections, the prepared statements have to be released because
* they contain connection-specific information for most databases.
*/
public void releasePreparedStatements() {
final String S_ProcName = "releasePreparedStatements";
S_sqlSelectISOTimezoneDistinctClassCode = null;
S_sqlSelectISOTimezoneBuff = null;
if (stmtReadBuffByPKey != null) {
try {
stmtReadBuffByPKey.close();
} catch (SQLException e) {
}
stmtReadBuffByPKey = null;
}
if (stmtReadAllBuff != null) {
try {
stmtReadAllBuff.close();
} catch (SQLException e) {
}
stmtReadAllBuff = null;
}
if (stmtLockBuffByPKey != null) {
try {
stmtLockBuffByPKey.close();
} catch (SQLException e) {
}
stmtLockBuffByPKey = null;
}
if (stmtCreateByPKey != null) {
try {
stmtCreateByPKey.close();
} catch (SQLException e) {
}
stmtCreateByPKey = null;
}
if (stmtUpdateByPKey != null) {
try {
stmtUpdateByPKey.close();
} catch (SQLException e) {
}
stmtUpdateByPKey = null;
}
if (stmtDeleteByPKey != null) {
try {
stmtDeleteByPKey.close();
} catch (SQLException e) {
}
stmtDeleteByPKey = null;
}
if (stmtDeleteByIdIdx != null) {
try {
stmtDeleteByIdIdx.close();
} catch (SQLException e) {
}
stmtDeleteByIdIdx = null;
}
if (stmtDeleteByOffsetIdx != null) {
try {
stmtDeleteByOffsetIdx.close();
} catch (SQLException e) {
}
stmtDeleteByOffsetIdx = null;
}
if (stmtDeleteByUTZNameIdx != null) {
try {
stmtDeleteByUTZNameIdx.close();
} catch (SQLException e) {
}
stmtDeleteByUTZNameIdx = null;
}
if (stmtDeleteByIso8601Idx != null) {
try {
stmtDeleteByIso8601Idx.close();
} catch (SQLException e) {
}
stmtDeleteByIso8601Idx = null;
}
if (stmtReadAllBuff != null) {
try {
stmtReadAllBuff.close();
} catch (SQLException e) {
}
stmtReadAllBuff = null;
}
if (stmtReadBuffByIdIdx != null) {
try {
stmtReadBuffByIdIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByIdIdx = null;
}
if (stmtReadBuffByOffsetIdx != null) {
try {
stmtReadBuffByOffsetIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByOffsetIdx = null;
}
if (stmtReadBuffByUTZNameIdx != null) {
try {
stmtReadBuffByUTZNameIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByUTZNameIdx = null;
}
if (stmtReadBuffByIso8601Idx != null) {
try {
stmtReadBuffByIso8601Idx.close();
} catch (SQLException e) {
}
stmtReadBuffByIso8601Idx = null;
}
}
/**
* Release the prepared statements.
*
* <p>When the schema changes connections, the prepared statements have to be released because
* they contain connection-specific information for most databases.
*/
public void releasePreparedStatements() {
S_sqlSelectISOCountryLanguageDistinctClassCode = null;
S_sqlSelectISOCountryLanguageBuff = null;
if (stmtReadBuffByPKey != null) {
try {
stmtReadBuffByPKey.close();
} catch (SQLException e) {
}
stmtReadBuffByPKey = null;
}
if (stmtLockBuffByPKey != null) {
try {
stmtLockBuffByPKey.close();
} catch (SQLException e) {
}
stmtLockBuffByPKey = null;
}
if (stmtCreateByPKey != null) {
try {
stmtCreateByPKey.close();
} catch (SQLException e) {
}
stmtCreateByPKey = null;
}
if (stmtUpdateByPKey != null) {
try {
stmtUpdateByPKey.close();
} catch (SQLException e) {
}
stmtUpdateByPKey = null;
}
if (stmtDeleteByPKey != null) {
try {
stmtDeleteByPKey.close();
} catch (SQLException e) {
}
stmtDeleteByPKey = null;
}
if (stmtDeleteByIdIdx != null) {
try {
stmtDeleteByIdIdx.close();
} catch (SQLException e) {
}
stmtDeleteByIdIdx = null;
}
if (stmtDeleteByCountryIdx != null) {
try {
stmtDeleteByCountryIdx.close();
} catch (SQLException e) {
}
stmtDeleteByCountryIdx = null;
}
if (stmtDeleteByLanguageIdx != null) {
try {
stmtDeleteByLanguageIdx.close();
} catch (SQLException e) {
}
stmtDeleteByLanguageIdx = null;
}
if (stmtReadAllBuff != null) {
try {
stmtReadAllBuff.close();
} catch (SQLException e) {
}
stmtReadAllBuff = null;
}
if (stmtReadBuffByIdIdx != null) {
try {
stmtReadBuffByIdIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByIdIdx = null;
}
if (stmtReadBuffByCountryIdx != null) {
try {
stmtReadBuffByCountryIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByCountryIdx = null;
}
if (stmtReadBuffByLanguageIdx != null) {
try {
stmtReadBuffByLanguageIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByLanguageIdx = null;
}
}