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); } }