public UploadEncoderDataFullObject(int uniqueId, int personId, int stationId, int exerciseId,
string laterality, string resistance, UploadEncoderDataObject uo)
{
this.uniqueId = uniqueId;
this.personId = personId;
this.stationId = stationId;
this.exerciseId = exerciseId;
this.laterality = laterality;
this.resistance = resistance;
this.uo = uo;
}
public static List <UploadEncoderDataFullObject> SelectTempEncoder(bool dbconOpened)
{
openIfNeeded(dbconOpened);
dbcmd.CommandText = "SELECT * FROM " + tableEncoder + " ORDER BY uniqueID";
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
SqliteDataReader reader = dbcmd.ExecuteReader();
List <UploadEncoderDataFullObject> l = new List <UploadEncoderDataFullObject>();
while (reader.Read())
{
UploadEncoderDataObject uo = new UploadEncoderDataObject(
Convert.ToInt32(reader[6]), //repetitions
Convert.ToInt32(reader[7]), //numBySpeed
Convert.ToInt32(reader[8]), //lossBySpeed
reader[9].ToString(), //rangeBySpeed
reader[10].ToString(), //vmeanBySpeed
reader[11].ToString(), //vmaxBySpeed
reader[12].ToString(), //pmeanBySpeed
reader[13].ToString(), //pmaxBySpeed
Convert.ToInt32(reader[14]), //numByPower
Convert.ToInt32(reader[15]), //lossByPower
reader[16].ToString(), //rangeByPower
reader[17].ToString(), //vmeanByPower
reader[18].ToString(), //vmaxByPower
reader[19].ToString(), //pmeanByPower
reader[20].ToString() //pmaxByPower
);
UploadEncoderDataFullObject o = new UploadEncoderDataFullObject(
Convert.ToInt32(reader[0]), //uniqueID
Convert.ToInt32(reader[1]), //personID
Convert.ToInt32(reader[2]), //stationID
Convert.ToInt32(reader[3]), //exerciseID
reader[4].ToString(), //laterality
reader[5].ToString(), //resistance
uo);
l.Add(o);
}
reader.Close();
closeIfNeeded(dbconOpened);
return(l);
}