/// <summary> Populates the translation / language support object for translating common UI terms </summary>
/// <param name="Translations"> Translations object to populate from the database </param>
/// <param name="Tracer"> Trace object keeps a list of each method executed and important milestones in rendering</param>
/// <returns> TRUE if successful, otherwise FALSE </returns>
/// <remarks> This calls the 'SobekCM_Get_Translation' stored procedure </remarks>
public static bool Populate_Translations(Language_Support_Info Translations, Custom_Tracer Tracer)
{
if (Tracer != null)
{
Tracer.Add_Trace("Engine_Database.Populate_Translations", String.Empty);
}
try
{
// Create the database agnostic reader
EalDbReaderWrapper readerWrapper = EalDbAccess.ExecuteDataReader(DatabaseType, Connection_String, CommandType.StoredProcedure, "SobekCM_Get_Translation");
// Pull out the database reader
DbDataReader reader = readerWrapper.Reader;
// Clear the translation information
Translations.Clear();
while (reader.Read())
{
Translations.Add_French(reader.GetString(1), reader.GetString(2));
Translations.Add_Spanish(reader.GetString(1), reader.GetString(3));
}
// Close the reader (which also closes the connection)
readerWrapper.Close();
// Return the first table from the returned dataset
return true;
}
catch (Exception ee)
{
Last_Exception = ee;
if (Tracer != null)
{
Tracer.Add_Trace("Engine_Database.Populate_Translations", "Exception caught during database work", Custom_Trace_Type_Enum.Error);
Tracer.Add_Trace("Engine_Database.Populate_Translations", ee.Message, Custom_Trace_Type_Enum.Error);
Tracer.Add_Trace("Engine_Database.Populate_Translations", ee.StackTrace, Custom_Trace_Type_Enum.Error);
}
return false;
}
}
