public void ToLap_ShouldSetIntensityToActive()
{
// Arrange
Interval interval = new Interval();
// Act
ActivityLap lap = interval.ToLap();
// Assert
Assert.AreEqual(Intensity.Active, lap.Intensity);
}
public void ToLap_ShouldSetTriggerMethodToManual()
{
// Arrange
Interval interval = new Interval();
// Act
ActivityLap lap = interval.ToLap();
// Assert
Assert.AreEqual(TriggerMethod.Manual, lap.TriggerMethod);
}
public ActivityLap ToLap()
{
ActivityLap lap = new ActivityLap();
lap.StartTime = StartTime;
lap.TotalTimeSeconds = TotalElapsedTime;
lap.DistanceMeters = TotalDistance;
lap.AverageHeartRateBpm = new HeartRateInBeatsPerMinute()
{
Value = (byte)AverageHeartRate
};
lap.Intensity = Intensity.Active;
lap.TriggerMethod = TriggerMethod.Manual;
return(lap);
}
void Export()
{
string selectedFile = FileService.SaveFileDialog();
if (!string.IsNullOrEmpty(selectedFile))
{
OutputFilePath = selectedFile;
}
if (!string.IsNullOrEmpty(OutputFilePath))
{
DbProviderFactory fact = DbProviderFactories.GetFactory("System.Data.SQLite");
using (SQLiteConnection cnn = (SQLiteConnection)fact.CreateConnection())
{
cnn.ConnectionString = "Data Source=" + FilePath;
cnn.Open();
SQLiteCommand command = new SQLiteCommand(
"SELECT PK_IntervalId, StartTime, TotalElapsedTime, TotalDistance, AverageStrokeRate, AverageHeartRate, AverageSpeed, TotalStrokeCount FROM Intervals" +
" WHERE FK_SessionId = @sessionId", cnn);
SQLiteParameter sessionParam = new SQLiteParameter("sessionId", System.Data.DbType.Int32);
sessionParam.Value = SelectedSession.Id;
command.Parameters.Add(sessionParam);
SQLiteCommand dataRecordCommand = new SQLiteCommand(
"SELECT dr.PK_DataRecordId, dr.ElapsedTime, dr.Latitude, dr.Longitude, dr.SpeedGps, dr.SpeedImpeller, dr.DistanceGps, dr.DistanceImpeller, dr.StrokeRate, dr.HeartRate," +
" osd.Power, osd.CatchAngle, osd.FinishAngle, osd.PositionOfMaxForce, osd.AverageHandleForce, osd.MaxHandleForce, osd.Slip, osd.Wash, osd.RealWorkPerStroke" +
" FROM DataRecords dr LEFT OUTER JOIN OarlockStrokeData osd ON osd.PK_OarlockStrokeRecordId = (SELECT PK_OarlockStrokeRecordId FROM OarlockStrokeData WHERE FK_DataRecordId = dr.PK_DataRecordId LIMIT 1)" +
" WHERE dr.FK_IntervalId = @intervalId AND dr.Type = 0", cnn); // Type filtered to 0 to just pick up strokes
SQLiteParameter intervalParam = new SQLiteParameter("intervalId", System.Data.DbType.Int32);
dataRecordCommand.Parameters.Add(intervalParam);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int id = (int)(long)reader[0];
DateTime startTime = NKDateTimeConverter.NKToClr((long)reader[1]);
int totalElapsedTime = (int)(long)reader[2];
int totalDistance = (int)(long)reader[3];
double strokeRate = Convert.ToDouble((long)reader[4]) / 2;
int averageHeartRate = reader.IsDBNull(5) ? 0 : (int)(long)reader[5];
double speed = Convert.ToDouble((long)reader[6]) / 100;
int totalStrokeCount = (int)(long)reader[7];
Interval interval = new Interval(id, startTime, totalElapsedTime, totalDistance, strokeRate, averageHeartRate, speed, totalStrokeCount);
intervalParam.Value = interval.Id;
SQLiteDataReader dataRecordReader = dataRecordCommand.ExecuteReader();
while (dataRecordReader.Read())
{
DataRecord record = new DataRecord();
record.ElapsedTime = (int)(long)dataRecordReader[1];
record.Latitude = (double)dataRecordReader[2];
record.Longitude = (double)dataRecordReader[3];
record.SpeedGps = Convert.ToDouble((long)dataRecordReader[4]) / 100;
record.SpeedImpeller = Convert.ToDouble((long)dataRecordReader[5]) / 100;
record.DistanceGps = (int)(long)dataRecordReader[6];
record.DistanceImpeller = (int)(long)dataRecordReader[7];
record.StrokeRate = Convert.ToDouble((long)dataRecordReader[8]) / 2;
record.HeartRate = (int)(long)dataRecordReader[9];
record.Power = dataRecordReader.IsDBNull(10) ? 0 : Convert.ToDouble((long)dataRecordReader[10]) / 10;
record.CatchAngle = dataRecordReader.IsDBNull(11) ? 0 : (int)(long)dataRecordReader[11];
record.FinishAngle = dataRecordReader.IsDBNull(12) ? 0 : (int)(long)dataRecordReader[12];
record.MaxForceAngle = dataRecordReader.IsDBNull(13) ? 0 : (int)(long)dataRecordReader[13];
record.AvgHandleForce = dataRecordReader.IsDBNull(14) ? 0 : Convert.ToDouble((long)dataRecordReader[14]) / 10;
record.MaxHandleForce = dataRecordReader.IsDBNull(15) ? 0 : Convert.ToDouble((long)dataRecordReader[15]) / 10;
record.SlipAngle = dataRecordReader.IsDBNull(16) ? 0 : (int)(long)dataRecordReader[16];
record.WashAngle = dataRecordReader.IsDBNull(17) ? 0 : (int)(long)dataRecordReader[17];
record.WorkPerStroke = dataRecordReader.IsDBNull(18) ? 0 : Convert.ToDouble((long)dataRecordReader[18]) / 10;
interval.DataRecords.Add(record);
}
SelectedSession.Intervals.Add(interval);
}
reader.Close();
}
Activity activity = new Activity()
{
Id = SelectedSession.StartTime, Sport = Sport.Other
};
activity.Creator = new Device()
{
Name = "SpeedCoach GPS"
};
foreach (Interval interval in SelectedSession.Intervals)
{
ActivityLap lap = interval.ToLap();
// TODO: Cadence/Stroke Rate (type conversion)
double maxSpeed = 0;
byte maxHeartRate = 0;
foreach (DataRecord record in interval.DataRecords)
{
Trackpoint trackpoint = record.ToTrackpoint(lap.StartTime);
if (trackpoint.HeartRateBpm.Value > maxHeartRate)
{
maxHeartRate = trackpoint.HeartRateBpm.Value;
}
switch (SelectedSession.SpeedInput)
{
case SpeedInput.Gps:
if (record.SpeedGps > maxSpeed)
{
maxSpeed = record.SpeedGps;
}
break;
case SpeedInput.Impeller:
if (record.SpeedImpeller > maxSpeed)
{
maxSpeed = record.SpeedImpeller;
}
break;
}
lap.Track.Add(trackpoint);
}
lap.MaximumSpeed = maxSpeed;
lap.MaximumHeartRateBpm = new HeartRateInBeatsPerMinute()
{
Value = maxHeartRate
};
activity.Lap.Add(lap);
}
TrainingCenterDatabase tcd = new TrainingCenterDatabase();
tcd.Activities.Activity.Add(activity);
using (XmlWriter writer = XmlWriter.Create(OutputFilePath))
{
(new XmlSerializer(typeof(TrainingCenterDatabase))).Serialize(writer, tcd);
}
}
}
