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,StartTime,EndTime,Comment,WymiaryId 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"); int?wymiaryId = getInt32(reader, "WymiaryId"); if (wymiaryId.HasValue) { Log.WriteInfo("TrainingDay has wymiary id={0}", wymiaryId.Value); SizeEntry sizeEntry = new SizeEntry(); sizeEntry.Wymiary = importWymiar(oldConnection, wymiaryId.Value); day.AddEntry(sizeEntry); //session.SaveOrUpdate(sizeEntry); } importStrengthTraining(day, oldTrainingDayId, getDateTime(reader, "StartTime"), getDateTime(reader, "EndTime"), day.Comment, oldConnection); day.Save(); Log.WriteInfo("TrainingDay saved"); } Log.WriteInfo("TrainingDay import complete"); }