void importTrainingDays(int oldProfileId, Profile newProfile, SqlCeConnection oldConnection)
{
Log.WriteInfo("Importing training days for profile id {0}, name{1}", newProfile.Id, newProfile.Name);
SqlCeCommand cmd = new SqlCeCommand();
cmd.Connection = oldConnection;
cmd.CommandText = "SELECT ID,TrainingDate,Comment FROM TrainingDay WHERE ProfileId=" + oldProfileId;
var reader = cmd.ExecuteReader();
Log.WriteInfo("TrainingDay reader executed");
while (reader.Read())
{
int oldTrainingDayId = getInt32(reader, "ID").Value;
DateTime date = getDateTime(reader, "TrainingDate").Value;
Log.WriteInfo("Training day id={0},TrainingDate={1}", oldTrainingDayId, date);
TrainingDay day = new TrainingDay(date);
day.ProfileId = newProfile.Id;
day.Comment = getString(reader, "Comment");
importA6w(day, newProfile, oldTrainingDayId, oldConnection);
importStrengthTraining(day, oldTrainingDayId, oldConnection);
importSizes(day, oldTrainingDayId, oldConnection);
day.CreateAndFlush();
if (day.IsEmpty)
{
day.Delete();
}
Log.WriteInfo("TrainingDay saved");
}
Log.WriteInfo("TrainingDay import complete");
}
