com.knowgate.training
Class AcademicCourse

java.lang.Object
  com.knowgate.dataobjs.DBPersist
      com.knowgate.training.AcademicCourse

All Implemented Interfaces:

java.io.Serializable, java.util.Map

public class AcademicCourse
extends DBPersist

Academic Course Instance

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from interface java.util.Map

java.util.Map.Entry<K,V>

Field Summary

static short

ClassId

Fields inherited from class com.knowgate.dataobjs.DBPersist

AllVals, sAuditCls, sAuditUsr, sTransactId

Constructor Summary

AcademicCourse()

AcademicCourse(JDCConnection oConn, java.lang.String sGuACourse)

Method Summary

boolean	active()
void	convertConfirmedBookingsToAlumni(JDCConnection oConn)
int	countAlumni(JDCConnection oConn)
int	countBookings(JDCConnection oConn)
int	countConfirmedBookings(JDCConnection oConn)
int	countPaidBookings(JDCConnection oConn)
int	countWaitingBookings(JDCConnection oConn)
boolean	delete(JDCConnection oConn) Delete a register from database The deleted register will be the one matching this DBPersist primary key, as set at constructor or load() method.
static boolean	delete(JDCConnection oConn, java.lang.String sGuACourse)
AcademicCourseBooking[]	getActiveBookings(JDCConnection oConn)
AcademicCourseBooking[]	getAllBookings(JDCConnection oConn)
AcademicCourseAlumni[]	getAlumni(JDCConnection oConn)
AcademicCourseBooking[]	getCancelledBookings(JDCConnection oConn)
AcademicCourseBooking[]	getConfirmedBookings(JDCConnection oConn)
Contact[]	getContacts(JDCConnection oConn)
Course	getCourse(JDCConnection oConn)
AcademicCourseBooking[]	getPaidBookings(JDCConnection oConn)
Subject[]	getSubjects(JDCConnection oConn)
AcademicCourseBooking[]	getUnconfirmedBookings(JDCConnection oConn)
AcademicCourseBooking[]	getUnpaidBookings(JDCConnection oConn)
AcademicCourseBooking[]	getWaitingBookings(JDCConnection oConn)
int	maxAlumni()
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.
java.lang.String	toXML(JDCConnection oConn, java.lang.String sIdent, java.lang.String sDelim) Get complete dump in XML This method gets a full XML dump of an academic course, including its base course, subjects and bookings

Methods inherited from class com.knowgate.dataobjs.DBPersist

allcaps, allcaps, changelog, clear, clone, containsKey, containsValue, entrySet, exists, get, get, getAuditClassName, getCreationDate, getDate, getDateFormated, getDateShort, getDateTime, getDateTime24, getDecimal, getDecimalFormated, getDecimalFormated, getDouble, getDoubleFormated, getFloat, getFloatFormated, getInt, getInteger, getIntervalPart, getItemMap, getItems, getMoney, getShort, getSQLDate, getSQLTime, getString, getStringHtml, getStringNull, getTable, getTable, getTableName, getTime, getTimeOfDay, getTimestamp, getUIdFromName, isEmpty, isNull, iterator, keySet, load, load, parseXML, 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, size, toLowerCase, toUpperCase, toXML, toXML, toXML, toXML, values

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.util.Map

equals, hashCode

Field Detail

ClassId

public static final short ClassId

See Also:

Constant Field Values

Constructor Detail

AcademicCourse

public AcademicCourse()

AcademicCourse

public AcademicCourse(JDCConnection oConn,
                      java.lang.String sGuACourse)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

active

public boolean active()

countAlumni

public int countAlumni(JDCConnection oConn)
                throws java.sql.SQLException,
                       java.lang.IllegalStateException

Throws:

java.sql.SQLException

java.lang.IllegalStateException

countBookings

public int countBookings(JDCConnection oConn)
                  throws java.sql.SQLException,
                         java.lang.IllegalStateException

Throws:

java.sql.SQLException

java.lang.IllegalStateException

countConfirmedBookings

public int countConfirmedBookings(JDCConnection oConn)
                           throws java.sql.SQLException,
                                  java.lang.IllegalStateException

Throws:

java.sql.SQLException

java.lang.IllegalStateException

countPaidBookings

public int countPaidBookings(JDCConnection oConn)
                      throws java.sql.SQLException,
                             java.lang.IllegalStateException

Throws:

java.sql.SQLException

java.lang.IllegalStateException

countWaitingBookings

public int countWaitingBookings(JDCConnection oConn)
                         throws java.sql.SQLException,
                                java.lang.IllegalStateException

Throws:

java.sql.SQLException

java.lang.IllegalStateException

maxAlumni

public int maxAlumni()

store

public boolean store(JDCConnection oConn)
              throws java.sql.SQLException

Description copied from class: 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.

Overrides:

store in class DBPersist

Parameters:

oConn - Database Connection

Returns:

boolean true if register was stored for the first time, false if register already existed.

Throws:

java.sql.SQLException

delete

public boolean delete(JDCConnection oConn)
               throws java.sql.SQLException

Description copied from class: DBPersist

Delete a register from database

The deleted register will be the one matching this DBPersist primary key, as set at constructor or load() method.

Overrides:

delete in class DBPersist

Parameters:

oConn - Database connection

Returns:

true if register was successfully erased, false if not.

Throws:

java.sql.SQLException

getContacts

public Contact[] getContacts(JDCConnection oConn)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getAlumni

public AcademicCourseAlumni[] getAlumni(JDCConnection oConn)
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getAllBookings

public AcademicCourseBooking[] getAllBookings(JDCConnection oConn)
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getActiveBookings

public AcademicCourseBooking[] getActiveBookings(JDCConnection oConn)
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getCancelledBookings

public AcademicCourseBooking[] getCancelledBookings(JDCConnection oConn)
                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getConfirmedBookings

public AcademicCourseBooking[] getConfirmedBookings(JDCConnection oConn)
                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getUnconfirmedBookings

public AcademicCourseBooking[] getUnconfirmedBookings(JDCConnection oConn)
                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

getWaitingBookings

public AcademicCourseBooking[] getWaitingBookings(JDCConnection oConn)
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getPaidBookings

public AcademicCourseBooking[] getPaidBookings(JDCConnection oConn)
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getUnpaidBookings

public AcademicCourseBooking[] getUnpaidBookings(JDCConnection oConn)
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getCourse

public Course getCourse(JDCConnection oConn)
                 throws java.sql.SQLException,
                        java.lang.NullPointerException

Throws:

java.sql.SQLException

java.lang.NullPointerException

getSubjects

public Subject[] getSubjects(JDCConnection oConn)
                      throws java.sql.SQLException,
                             java.lang.NullPointerException

Throws:

java.sql.SQLException

java.lang.NullPointerException

convertConfirmedBookingsToAlumni

public void convertConfirmedBookingsToAlumni(JDCConnection oConn)
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

toXML

public java.lang.String toXML(JDCConnection oConn,
                              java.lang.String sIdent,
                              java.lang.String sDelim)
                       throws java.sql.SQLException

Get complete dump in XML

This method gets a full XML dump of an academic course, including its base course, subjects and bookings

Throws:

java.sql.SQLException

delete

public static boolean delete(JDCConnection oConn,
                             java.lang.String sGuACourse)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException