public List <SimpleTranslation> LoadTextRepository()
{
SqlCommand sqlCommand = null;
var translationList = new List <SimpleTranslation>();
try
{
// Searching all repository
sqlCommand = new SqlCommand("SELECT * FROM TEXT_TRANSLATIONS ORDER BY DOM_ELEMENT_ID");
DataSet dataSet = SQLOperation.ExecuteSQLCommandWithResult(sqlCommand);
SimpleTranslation simpleTranslation = new SimpleTranslation();
int contRows = 0;
do
{
// Running all content, and build the repository.
if (simpleTranslation.DOMElementID != dataSet.Tables[0].Rows[contRows]["DOM_ELEMENT_ID"].ToString())
{
if (simpleTranslation.DOMElementID != null)
{
//Save the last translation repository
translationList.Add(simpleTranslation);
}
simpleTranslation = new SimpleTranslation();
simpleTranslation.DOMElementID = dataSet.Tables[0].Rows[contRows]["DOM_ELEMENT_ID"].ToString();
}
// Now, set the translation
if (dataSet.Tables[0].Rows[contRows]["IDIOM"].ToString() == "PT")
{
simpleTranslation.PortugueseContent = dataSet.Tables[0].Rows[contRows]["TRANSLATION"].ToString();
}
else
{
simpleTranslation.EnglishContent = dataSet.Tables[0].Rows[contRows]["TRANSLATION"].ToString();
}
contRows++;
} while (contRows < dataSet.Tables[0].Rows.Count);
//Save the last translation repository
translationList.Add(simpleTranslation);
// With the translation repository complete, generate the JSON format
return(translationList);
}
catch (Exception e) // Em qualquer caso de erro, retornar nulo.
{
return(null);
}
finally
{
// In all errors, return null
sqlCommand.Dispose();
}
}
// Use this for initialization
void Awake()
{
string filePath = (Application.dataPath + "/").Replace("/", "\\");
string fileName = "Translation.xml";
Debug.Log(filePath + fileName);
translation = new SimpleTranslation(filePath, fileName, "english");
//translation = new SimpleTranslation(filePath, fileName);
Debug.Log(translation.GetLanguages()[0]);
translation.SetLanguage(language.ToString());
}