/// <summary>
/// List clients
/// </summary>
/// <param name="userID"></param>
public void List(string userID, int childUID)
{
LearningStoryList = new List <LearningStory>();
using (var connection = new MySqlConnection(ConnectionString.GetConnectionString()))
{
var commandString = string.Format(
" SELECT " +
FieldString() +
" FROM LearningStory " +
" WHERE IsVoid = 'N' " +
" AND FKChildUID = @FKChildUID " +
" ORDER BY UID ASC "
);
using (var command = new MySqlCommand(
commandString, connection))
{
command.Parameters.AddWithValue("@FkChildUID", childUID);
connection.Open();
try
{
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
var client = new LearningStory();
LoadObject(reader, client, false);
LearningStoryList.Add(client);
}
}
}
catch (Exception ex)
{
string error = ex.ToString();
LogFile.WriteToTodaysLogFile(ex.ToString(), userID, "", "Client.cs");
}
}
}
}
/// <summary>
/// Load object
/// </summary>
/// <param name="reader"></param>
/// <param name="learningStory"></param>
private static void LoadObject(MySqlDataReader reader, LearningStory learningStory, bool includeOutcome)
{
learningStory.UID = Convert.ToInt32(reader[FieldName.UID]);
learningStory.FKChildUID = Convert.ToInt32(reader[FieldName.FKChildUID]);
learningStory.FKRoomCode = reader[FieldName.FKRoomCode] as string;
learningStory.FKEducatorUID = Convert.ToInt32(reader[FieldName.FKEducatorUID]);
learningStory.Date = Convert.ToDateTime((reader[FieldName.Date]));
learningStory.Story = reader[FieldName.Story] as string;
learningStory.AnalysisOfLearning = reader[FieldName.AnalysisOfLearning] as string;
learningStory.ExtensionOfLearning = reader[FieldName.ExtensionOfLearning] as string;
learningStory.ParentsComments = reader[FieldName.ParentsComments] as string;
// -----------------------------------------------------------------------------------------
learningStory.UpdateDateTime = Convert.ToDateTime((reader[FieldName.UpdateDateTime]));
learningStory.UserIdUpdatedBy = reader[FieldName.UserIdUpdatedBy] as string;
learningStory.CreationDateTime = Convert.ToDateTime((reader[FieldName.CreationDateTime]));
learningStory.UserIdCreatedBy = reader[FieldName.UserIdCreatedBy] as string;
learningStory.RecordVersion = Convert.ToInt32(reader[FieldName.RecordVersion]);
learningStory.IsVoid = reader[FieldName.IsVoid] as string;
learningStory.child = new Child();
learningStory.child.UID = learningStory.FKChildUID;
learningStory.child.Read();
learningStory.educator = new Educator();
learningStory.educator.UID = learningStory.FKEducatorUID;
learningStory.educator.Read();
// Loading outcomes, practices and principles
//
if (includeOutcome)
{
learningStory.LearningOutcomes = LearningStoryItem.ListItem(learningStory.UID, "LESI");
learningStory.Principles = LearningStoryItem.ListItem(learningStory.UID, "PRIN");
learningStory.Practices = LearningStoryItem.ListItem(learningStory.UID, "PRAC");
}
}
