private MyTraining importMyTraining(Guid guid, Profile profie, SqlCeConnection oldConnection)
{
if (myTrainings.ContainsKey(guid))
{
return(MyTraining.GetById(myTrainings[guid]));
}
Log.WriteInfo("Importing MyTraining id={0}", guid);
SqlCeCommand cmd = new SqlCeCommand();
cmd.Connection = oldConnection;
cmd.CommandText = string.Format("SELECT Id,StartDate,EndDate,GlobalId,EntryType,ProfileId,TrainingEnd,PercentageCompleted,Name FROM MyTraining WHERE GlobalId='{0}'", guid);
var reader = cmd.ExecuteReader();
Log.WriteInfo("MyTraining reader executed");
if (reader.Read())
{
MyTraining myTraining = new MyTraining();
myTraining.Name = getString(reader, "Name");
var endDate = getDateTime(reader, "EndDate");
var startDate = getDateTime(reader, "StartDate").Value;
var trainingEnd = (TrainingEnd)getInt32(reader, "TrainingEnd").Value;
myTraining.SetData(startDate, endDate, trainingEnd);
myTraining.EntryType = getString(reader, "EntryType");
myTraining.ProfileId = profie.Id;
myTraining.PercentageCompleted = getInt32(reader, "PercentageCompleted");
myTraining.CreateAndFlush();
myTrainings.Add(guid, myTraining.Id);
return(myTraining);
}
return(null);
}
