C# Class SqliteEncoder, chronojump

Inheritance: Sqlite
Show file 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