public CFCrmMemoDataBuff readBuff(CFSecurityAuthorization Authorization, CFCrmMemoDataPKey PKey) {
final String S_ProcName = "readBuff";
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_read_memodata( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " ) }";
if (stmtReadBuffByPKey == null) {
stmtReadBuffByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByPKey.setLong(argIdx++, TenantId);
stmtReadBuffByPKey.setLong(argIdx++, MemoId);
resultSet = stmtReadBuffByPKey.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 void deleteMemoDataByIdIdx(
CFSecurityAuthorization Authorization, CFCrmMemoDataPKey argKey) {
deleteMemoDataByIdIdx(Authorization, argKey.getRequiredTenantId(), argKey.getRequiredMemoId());
}
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);
}
}