public class Activity extends DBPersist
Marketing Activity
Copyright: Copyright (c) KnowGate 2009
Modifier and Type | Field and Description |
---|---|
static short |
ClassId |
Constructor and Description |
---|
Activity() |
Activity(JDCConnection oConn,
java.lang.String sGuActivity)
Create Activity and load fields from database.
|
Modifier and Type | Method and Description |
---|---|
ActivityAttachment |
addAttachment(JDCConnection oConn,
java.lang.String sGuWriter,
java.lang.String sDirPath,
java.lang.String sFileName,
boolean bDeleteOriginalFile)
Add an Attachment to an Activity
|
ActivityAttachment |
addAttachment(JDCConnection oConn,
java.lang.String sGuWriter,
java.lang.String sDirPath,
java.lang.String sFileName,
java.lang.String sDescription,
boolean bDeleteOriginalFile)
Add an Attachment to an Activity
|
boolean |
delete(JDCConnection oConn)
Delete Activity.
|
Address |
getAddress()
Get address of Activity.
|
ActivityAudience[] |
getAudience(JDCConnection oConn) |
int |
getConfirmedAudienceCount(JDCConnection oConn) |
int |
getNotConfirmedAudienceCount(JDCConnection oConn) |
int |
getRefusedAudienceCount(JDCConnection oConn) |
int |
getTotalAudienceCount(JDCConnection oConn) |
boolean |
load(JDCConnection oConn,
java.lang.Object[] PKVals)
Load the internal value set from a register at a database table
|
boolean |
load(JDCConnection oConn,
java.lang.String sGuActivity)
Load the internal value set from a register at a database table
|
boolean |
removeAttachment(JDCConnection oConn,
int iPgAttachment)
Remove attachment
|
boolean |
store(JDCConnection oConn)
Store a register at database representing this instance of DBPersist
Insertions and updates : The store method automatically manages
register insertions and updates.
|
allcaps, allcaps, clear, clone, columns, containsKey, containsValue, entrySet, exists, get, get, getAuditClassName, getCreationDate, getDate, getDate, getDateFormated, getDateShort, getDateTime, getDateTime24, getDecimal, getDecimalFormated, getDecimalFormated, getDouble, getDoubleFormated, getFloat, getFloatFormated, getInt, getIntArray, getInteger, getIntegerArray, getIntervalPart, getItemMap, getItems, getMoney, getPrimaryKey, getShort, getSQLDate, getSQLTime, getString, getStringHtml, getStringNull, getTable, getTable, getTime, getTimeOfDay, getTimestamp, isEmpty, isNull, iterator, keySet, parseXML, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, putAll, putAll, remove, remove, replace, replace, replace, replace, replace, replace, replace, replace, setAuditTransact, setAuditUser, setCreationDate, setPrimaryKey, size, toLowerCase, toUpperCase, toXML, toXML, toXML, values
public static final short ClassId
public Activity()
public Activity(JDCConnection oConn, java.lang.String sGuActivity) throws java.sql.SQLException
oConn
- Database ConnectionsGuActivity
- Activity GUIDjava.sql.SQLException
public Address getAddress()
Get address of Activity.
Activity must has been previously loaded before trying to get its Addresspublic int getConfirmedAudienceCount(JDCConnection oConn) throws java.sql.SQLException
java.sql.SQLException
public int getNotConfirmedAudienceCount(JDCConnection oConn) throws java.sql.SQLException
java.sql.SQLException
public int getRefusedAudienceCount(JDCConnection oConn) throws java.sql.SQLException
java.sql.SQLException
public int getTotalAudienceCount(JDCConnection oConn) throws java.sql.SQLException
java.sql.SQLException
public ActivityAudience[] getAudience(JDCConnection oConn) throws java.sql.SQLException
java.sql.SQLException
public boolean load(JDCConnection oConn, java.lang.Object[] PKVals) throws java.sql.SQLException
DBPersist
Load the internal value set from a register at a database table
public boolean load(JDCConnection oConn, java.lang.String sGuActivity) throws java.sql.SQLException
DBPersist
Load the internal value set from a register at a database table
public boolean store(JDCConnection oConn) throws java.sql.SQLException
DBPersist
Store a register at database representing this instance of DBPersist
Insertions and updates : The store method automatically manages register insertions and updates. If the stored object already exists at database then it is updated, if it does not exists then it is inserted. A primary key violation error is never thrown so ther is no need to call delete() method before re-writing an existing object.
NULL fields : All values not set calling put() methods for DBPersist
will be assumed to be NULL. If a not nullable field is not set then an
SQLException will be raised.
On storing an already existing object all values will we overwrited,
so is a DBPersist is not fully loaded before storing it, values not set
by calling put() methods that already were present at database will be lost.
public boolean delete(JDCConnection oConn) throws java.sql.SQLException
Delete Activity.
The delete step by step is as follows:public ActivityAttachment addAttachment(JDCConnection oConn, java.lang.String sGuWriter, java.lang.String sDirPath, java.lang.String sFileName, java.lang.String sDescription, boolean bDeleteOriginalFile) throws java.sql.SQLException, java.lang.NullPointerException, java.io.FileNotFoundException, java.lang.Exception
oConn
- JDCConnectionsGuWriter
- String GUID of user (from k_users table) who is uploading the attachmentsDirPath
- String Physical path (directory) where file to be attached ir locatedsFileName
- String Name of file to be attachedsDescription
- String File Description (up to 254 characters)bDeleteOriginalFile
- boolean true if original file must be deleted after being attachedjava.sql.SQLException
java.lang.NullPointerException
java.io.FileNotFoundException
java.lang.Exception
public ActivityAttachment addAttachment(JDCConnection oConn, java.lang.String sGuWriter, java.lang.String sDirPath, java.lang.String sFileName, boolean bDeleteOriginalFile) throws java.sql.SQLException, java.lang.NullPointerException, java.io.FileNotFoundException, java.lang.Exception
oConn
- JDCConnectionsGuWriter
- String GUID of user (from k_users table) who is uploading the attachmentsDirPath
- String Physical path (directory) where file to be attached ir locatedsFileName
- String Name of file to be attachedbDeleteOriginalFile
- boolean true if original file must be deleted after being attachedjava.sql.SQLException
java.lang.NullPointerException
java.io.FileNotFoundException
java.lang.Exception
public boolean removeAttachment(JDCConnection oConn, int iPgAttachment) throws java.sql.SQLException
oConn
- JDCConnectioniPgAttachment
- intjava.sql.SQLException
java.lang.NullPointerException