com.aspc.Layers.aspc_app.Member.commands

Class AddOnlineMemberCommand

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.Layers.aspc_app.Member.commands.AddOnlineMemberCommand

All Implemented Interfaces:

CommandBuildResultsPlugin

public class AddOnlineMemberCommand
extends SQLCommand

Syntax

  ADD_ONLINE_MEMBER
                          PASSWORD member_password
                          TITLE member_title
                          NAME member_name
                          [MIDDLE_NAME member_middle_name]
                          SURNAME member_surname
                           DOB member_dob
                           [GENDER member_gender]
                           ADDRESS member_address
                           SUBURB member_suburb
                           STATE member_state               
                           POSTCODE member_postCode
                           [COUNTRY member_country]
                           [PHONE member_phone]
                           [MOBILE member_mobile]
                           [EMAIL member_email]
                           [EMAIL_SECONDARY member_email_secondary]
                           OCCUPATION member_occupation
                           [SUB_OCCUPATION member_suboccupation]
                           [OTHER_OCCUPATION member_otheroccupation]
                           STATUS_CATEGORY member_statusCategory
                           PAYMENT_FREQUENCY member_paymentFrequency
                           PAYMENT_TYPE member_paymentType
                           PAYMENT_AUTOMATIC  member_paymentAuto
                           [DD_ACNT_NAME member_ddAcountName]
                           [DD_ACNT_BSB member_ddAcountBSB]
                           [DD_ACNT_NUMBER member_ddAcountNumber]
                           [DD_INSTITUTE member_ddAInstitude]
                           [DD_BRANCH member_ddBranch]
                           [PD_EMPLOYER_CODE member_employerCode]
                           [PD_CEO_PIN member_pinNumber]
                           [WORKPLACE_CODE member_workplaceCode]
                           [INSTITUTE_TEACHERS_REGISTERED member_instituteTeachersRegistered]
                           [INSTITUTE_TEACHERS_NUMBER member_instituteTeachersNumber]
                           [INSTITUTE_TEACHERS_LEVEL member_instituteTeachersLevel]
                           [FIRST_YEAR member_firstYear]
                           [PAYMENT_AMOUNT member_paymentAmount]
                           [EWAY_TOKEN member_eWayToken]
                           [TQI_NUMBER tqiNumber]
                           [ATSI atsi]
                           [EMAIL_RENEWALS emailRenewals]
                           [PAY_DATE payDate]
  

THREAD MODE: SINGLE THREADED command

Since:

15 Mar 2012

Author:

Liam

Field Summary

Fields inherited from class com.aspc.commander.sql.SQLCommand

CURSOR_SIZE

Constructor Summary

Constructors

Constructor and Description
AddOnlineMemberCommand(Connection connection, Pattern pattern) Constructor

Method Summary

Modifier and Type	Method and Description
protected void	execute(Parser p) execute the command.
java.lang.String	getColumnName(int col) the column name
java.lang.String	getColumnType(int col) get the column type
int	getOnlineContactsToday(MutableDataSource mds, int maxRows) Get Online Contacts Today
java.lang.String	getRecordID(int row) We are at the last row when we return null for the record ID.
java.lang.Object	getValue(int row, int col) The value for this column/row

Methods inherited from class com.aspc.commander.sql.SQLCommand

appendResult, appendResult, getCursorName, getRecordKey, isExecuteOnly

Methods inherited from class com.aspc.commander.Command

execute, extMakeThreadName, getConnection, getPattern, getRawTitle, getTitle, makeThreadName, recordCall, setTitle

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.aspc.commander.sql.results.CommandBuildResultsPlugin

getRawTitle

Constructor Detail

AddOnlineMemberCommand

public AddOnlineMemberCommand(Connection connection,
                              Pattern pattern)

Constructor

Parameters:

connection -

pattern -

Method Detail

execute

protected void execute(Parser p)
                throws java.lang.Exception

execute the command.

Specified by:

execute in class Command

Parameters:

p - The parser

Throws:

java.lang.Exception - A serious problem

getColumnName

public java.lang.String getColumnName(int col)

the column name

Parameters:

col - the column

Returns:

the name

getColumnType

public java.lang.String getColumnType(int col)

Description copied from interface: CommandBuildResultsPlugin

get the column type

Parameters:

col - the column

Returns:

the value

getRecordID

public java.lang.String getRecordID(int row)

Description copied from interface: CommandBuildResultsPlugin

We are at the last row when we return null for the record ID. All rows must have a unique ID. Nothing else is assumed about a record ID other than it is unique and will return the same value at a later time.

Parameters:

row - the row to use

Returns:

the value

getValue

public java.lang.Object getValue(int row,
                                 int col)

Description copied from interface: CommandBuildResultsPlugin

The value for this column/row

Parameters:

row - the row to use

col - the column

Returns:

the value

getOnlineContactsToday

public int getOnlineContactsToday(MutableDataSource mds,
                                  int maxRows)
                           throws java.lang.Exception

Get Online Contacts Today

Parameters:

mds - mds

maxRows - maxRows

Returns:

the value

Throws:

java.lang.Exception - exception