C# Class SqliteEncoder, chronojump

Inheritance: Sqlite

ファイルを表示 Open project: GNOME/chronojump Class Usage Examples

Public Methods

Method	Description
DeleteSignalCurveWithCurveID ( bool dbconOpened, int curveID ) : void
FindCurveInSignal ( string signalFile, string curveFile ) : int
Insert ( bool dbconOpened, EncoderSQL, es ) : int
Insert1RM ( bool dbconOpened, int personID, int sessionID, int exerciseID, double load1RM ) : int
InsertExercise ( bool dbconOpened, string name, int percentBodyWeight, string ressistance, string description, string speed1RM ) : void
LoadEncoderConfiguration ( ) : EncoderConfiguration
Select ( bool dbconOpened, int uniqueID, int personID, int sessionID, Constants, encoderGI, int exerciseID, string signalOrCurve, EncoderSQL, ecconSelect, bool onlyActive, bool orderIDascendent ) : ArrayList
Select1RM ( bool dbconOpened, int personID, int sessionID, int exerciseID, bool returnPersonNameAndExerciseName ) : ArrayList
SelectCompareIntersession ( bool dbconOpened, Constants, encoderGI, int exerciseID, int personID ) : ArrayList
SelectEncoderExercises ( bool dbconOpened, int uniqueID, bool onlyNames ) : ArrayList
SelectEncoderRowsOfAnExercise ( bool dbconOpened, int exerciseID ) : ArrayList
SelectSessionOverviewReps ( bool dbconOpened, Constants, encoderGI, int sessionID ) : ArrayList
SelectSessionOverviewSets ( bool dbconOpened, Constants, encoderGI, int sessionID ) : ArrayList
SelectSignalCurve ( bool dbconOpened, int signalID, int curveID, double msStart, double msEnd ) : ArrayList
SignalCurveInsert ( bool dbconOpened, int signalID, int curveID, int msCentral ) : void
SqliteEncoder ( ) : System
Update ( bool dbconOpened, EncoderSQL, es ) : void
Update ( bool dbconOpened, EncoderSQL, es, SqliteCommand dbcmdTr ) : void
UpdateExercise ( bool dbconOpened, string nameOld, string name, int percentBodyWeight, string ressistance, string description, string speed1RM ) : void
UpdateTransaction ( ArrayList data, string checkboxes ) : int

Protected Methods

Method	Description
addEncoderFreeExercise ( ) : void
addEncoderInclinedExercises ( ) : void
addEncoderJumpExercise ( ) : void
createTable1RM ( ) : void
createTableEncoder ( ) : void
createTableEncoderExercise ( ) : void
createTableEncoderSignalCurve ( ) : void
initializeTableEncoderExercise ( ) : void
putEncoderExerciseAnglesAt90 ( ) : void
removeEncoderExerciseAngles ( ) : void

Private Methods

Method	Description
addURLpath ( string url ) : string
fixOSpath ( string url ) : string
removeURLpath ( string url ) : string
update ( bool dbconOpened, EncoderSQL, es, SqliteCommand mycmd ) : void

Method Details

DeleteSignalCurveWithCurveID() public static method

public static DeleteSignalCurveWithCurveID ( bool dbconOpened, int curveID ) : void
dbconOpened	bool
curveID	int
return	void

FindCurveInSignal() public static method

public static FindCurveInSignal ( string signalFile, string curveFile ) : int
signalFile	string
curveFile	string
return	int

Insert() public static method

public static Insert ( bool dbconOpened, EncoderSQL, es ) : int
dbconOpened	bool
es	EncoderSQL,
return	int

Insert1RM() public static method

public static Insert1RM ( bool dbconOpened, int personID, int sessionID, int exerciseID, double load1RM ) : int
dbconOpened	bool
personID	int
sessionID	int
exerciseID	int
load1RM	double
return	int

InsertExercise() public static method

public static InsertExercise ( bool dbconOpened, string name, int percentBodyWeight, string ressistance, string description, string speed1RM ) : void
dbconOpened	bool
name	string
percentBodyWeight	int
ressistance	string
description	string
speed1RM	string
return	void

LoadEncoderConfiguration() public static method

public static LoadEncoderConfiguration ( ) : EncoderConfiguration
return	EncoderConfiguration

Select() public static method

public static Select ( bool dbconOpened, int uniqueID, int personID, int sessionID, Constants, encoderGI, int exerciseID, string signalOrCurve, EncoderSQL, ecconSelect, bool onlyActive, bool orderIDascendent ) : ArrayList
dbconOpened	bool
uniqueID	int
personID	int
sessionID	int
encoderGI	Constants,
exerciseID	int
signalOrCurve	string
ecconSelect	EncoderSQL,
onlyActive	bool
orderIDascendent	bool
return	ArrayList

Select1RM() public static method

public static Select1RM ( bool dbconOpened, int personID, int sessionID, int exerciseID, bool returnPersonNameAndExerciseName ) : ArrayList
dbconOpened	bool
personID	int
sessionID	int
exerciseID	int
returnPersonNameAndExerciseName	bool
return	ArrayList

SelectCompareIntersession() public static method

public static SelectCompareIntersession ( bool dbconOpened, Constants, encoderGI, int exerciseID, int personID ) : ArrayList
dbconOpened	bool
encoderGI	Constants,
exerciseID	int
personID	int
return	ArrayList

SelectEncoderExercises() public static method

public static SelectEncoderExercises ( bool dbconOpened, int uniqueID, bool onlyNames ) : ArrayList
dbconOpened	bool
uniqueID	int
onlyNames	bool
return	ArrayList

SelectEncoderRowsOfAnExercise() public static method

public static SelectEncoderRowsOfAnExercise ( bool dbconOpened, int exerciseID ) : ArrayList
dbconOpened	bool
exerciseID	int
return	ArrayList

SelectSessionOverviewReps() public static method

public static SelectSessionOverviewReps ( bool dbconOpened, Constants, encoderGI, int sessionID ) : ArrayList
dbconOpened	bool
encoderGI	Constants,
sessionID	int
return	ArrayList

SelectSessionOverviewSets() public static method

public static SelectSessionOverviewSets ( bool dbconOpened, Constants, encoderGI, int sessionID ) : ArrayList
dbconOpened	bool
encoderGI	Constants,
sessionID	int
return	ArrayList

SelectSignalCurve() public static method

public static SelectSignalCurve ( bool dbconOpened, int signalID, int curveID, double msStart, double msEnd ) : ArrayList
dbconOpened	bool
signalID	int
curveID	int
msStart	double
msEnd	double
return	ArrayList

SignalCurveInsert() public static method

public static SignalCurveInsert ( bool dbconOpened, int signalID, int curveID, int msCentral ) : void
dbconOpened	bool
signalID	int
curveID	int
msCentral	int
return	void

SqliteEncoder() public method

public SqliteEncoder ( ) : System
return	System

Update() public static method

public static Update ( bool dbconOpened, EncoderSQL, es ) : void
dbconOpened	bool
es	EncoderSQL,
return	void

Update() public static method

public static Update ( bool dbconOpened, EncoderSQL, es, SqliteCommand dbcmdTr ) : void
dbconOpened	bool
es	EncoderSQL,
dbcmdTr	Mono.Data.Sqlite.SqliteCommand
return	void

UpdateExercise() public static method

public static UpdateExercise ( bool dbconOpened, string nameOld, string name, int percentBodyWeight, string ressistance, string description, string speed1RM ) : void
dbconOpened	bool
nameOld	string
name	string
percentBodyWeight	int
ressistance	string
description	string
speed1RM	string
return	void

UpdateTransaction() public static method

public static UpdateTransaction ( ArrayList data, string checkboxes ) : int
data	ArrayList
checkboxes	string
return	int

addEncoderFreeExercise() protected static method

protected static addEncoderFreeExercise ( ) : void
return	void

addEncoderInclinedExercises() protected static method

protected static addEncoderInclinedExercises ( ) : void
return	void

addEncoderJumpExercise() protected static method

protected static addEncoderJumpExercise ( ) : void
return	void

createTable1RM() protected static method

protected static createTable1RM ( ) : void
return	void

createTableEncoder() protected static method

protected static createTableEncoder ( ) : void
return	void

createTableEncoderExercise() protected static method

protected static createTableEncoderExercise ( ) : void
return	void

createTableEncoderSignalCurve() protected static method

protected static createTableEncoderSignalCurve ( ) : void
return	void

initializeTableEncoderExercise() protected static method

protected static initializeTableEncoderExercise ( ) : void
return	void

putEncoderExerciseAnglesAt90() protected static method

protected static putEncoderExerciseAnglesAt90 ( ) : void
return	void

removeEncoderExerciseAngles() protected static method

protected static removeEncoderExerciseAngles ( ) : void
return	void