C# Class SqlitePersonSession, chronojump

Inheritance: Sqlite
Mostra file Open project: GNOME/chronojump Class Usage Examples

Public Methods

Method Description
DeletePersonFromSessionAndTests ( string sessionID, string personID ) : void
Insert ( bool dbconOpened, string uniqueID, int personID, int sessionID, double height, double weight, int sportID, int speciallityID, int practice, string comments ) : int
PersonExistsInPS ( bool dbconOpened, int personID ) : bool
PersonSelectExistsInSession ( int myPersonID, int mySessionID ) : bool
Select ( bool dbconOpened, int personID, int sessionID ) : PersonSession,
Select ( int personID, int sessionID ) : PersonSession,
SelectAttribute ( bool dbconOpened, int personID, int sessionID, string attribute ) : double
SelectAttribute ( int personID, string attribute ) : double
SelectCurrentSessionPersons ( int sessionID, bool returnPersonAndPSlist ) : ArrayList
SqlitePersonSession ( ) : System
Update ( PersonSession, ps ) : void
UpdateAttribute ( int personID, int sessionID, string attribute, double attrValue ) : void

Protected Methods

Method Description
createTable ( string tableName ) : void

Method Details

DeletePersonFromSessionAndTests() public static method

public static DeletePersonFromSessionAndTests ( string sessionID, string personID ) : void
sessionID string
personID string
return void

Insert() public static method

public static Insert ( bool dbconOpened, string uniqueID, int personID, int sessionID, double height, double weight, int sportID, int speciallityID, int practice, string comments ) : int
dbconOpened bool
uniqueID string
personID int
sessionID int
height double
weight double
sportID int
speciallityID int
practice int
comments string
return int

PersonExistsInPS() public static method

public static PersonExistsInPS ( bool dbconOpened, int personID ) : bool
dbconOpened bool
personID int
return bool

PersonSelectExistsInSession() public static method

public static PersonSelectExistsInSession ( int myPersonID, int mySessionID ) : bool
myPersonID int
mySessionID int
return bool

Select() public static method

public static Select ( bool dbconOpened, int personID, int sessionID ) : PersonSession,
dbconOpened bool
personID int
sessionID int
return PersonSession,

Select() public static method

public static Select ( int personID, int sessionID ) : PersonSession,
personID int
sessionID int
return PersonSession,

SelectAttribute() public static method

public static SelectAttribute ( bool dbconOpened, int personID, int sessionID, string attribute ) : double
dbconOpened bool
personID int
sessionID int
attribute string
return double

SelectAttribute() public static method

public static SelectAttribute ( int personID, string attribute ) : double
personID int
attribute string
return double

SelectCurrentSessionPersons() public static method

public static SelectCurrentSessionPersons ( int sessionID, bool returnPersonAndPSlist ) : ArrayList
sessionID int
returnPersonAndPSlist bool
return ArrayList

SqlitePersonSession() public method

public SqlitePersonSession ( ) : System
return System

Update() public static method

public static Update ( PersonSession, ps ) : void
ps PersonSession,
return void

UpdateAttribute() public static method

public static UpdateAttribute ( int personID, int sessionID, string attribute, double attrValue ) : void
personID int
sessionID int
attribute string
attrValue double
return void

createTable() protected method

protected createTable ( string tableName ) : void
tableName string
return void