public static void writeException(int code, Exception innerException, string stackTrace, params object[] parameters)
{
citylifedb8_blContext db = new citylifedb8_blContext();
ErrorCode theErrorCode = db.ErrorCode.SingleOrDefault(aRecord => aRecord.Code == code);
if (theErrorCode != null)
{
//This error code already exists in the DB.
theErrorCode.LastOccurenceDate = DateTime.Now;
theErrorCode.OccurenceCount++;
}
else
{
//The error code does not exist - create it
theErrorCode = new ErrorCode()
{
Code = code, Message = ErrorCodeCollection.message(code),
LastOccurenceDate = DateTime.Now, OccurenceCount = 1
};
db.ErrorCode.Add(theErrorCode);
}
db.SaveChanges();
//check if the same error message exists in the error message table
string formattedMessage = AppException.formatMessage(code, parameters);
ErrorMessage theErrorMessage = (from anErrorMessage in theErrorCode.ErrorMessages
where anErrorMessage.FormattedMessage == formattedMessage &&
anErrorMessage.StackTrace == stackTrace
select anErrorMessage).FirstOrDefault(); //actually we expect only a single record to be found
if (theErrorMessage != null)
{
//Such an exact error message already exists - increment the counter
theErrorMessage.LastOccurenceDate = DateTime.Now;
theErrorMessage.OccurenceCount++;
}
else
{
//such exact error message does not exist - add it
theErrorMessage = new ErrorMessage()
{
ErrorCodeCode = theErrorCode.Code,
FormattedMessage = formattedMessage,
LastOccurenceDate = DateTime.Now,
OccurenceCount = 1,
StackTrace = stackTrace,
};
db.ErrorMessage.Add(theErrorMessage);
}
db.SaveChanges();
}
public AppException(int code, Exception innerException, params object[] parameters) : base(AppException.formatMessage(code, parameters),
innerException)
{
writeException(code, innerException, this.StackTrace, parameters);
}
/// <summary>
/// perform a translation operation to the target languagewhich was defined in the constructor. If the translation key does not exist
/// creates a record in the translation key table, and also a record in the translation table for the English text. So default English
/// translation will be created immediately. This translation can later be changed.
/// </summary>
/// <param name="translationKey">the translation key which needs to be translated</param>
/// <param name="lineNumber">the line number in the code where the translate method was last called. Note that
/// if the same key is requested in more than one place in the code - the DB will only save the last call</param>
/// <param name="filePath">the file path where the method was last called</param>
/// <returns>the translation in the required language. If translation was not found in the required language -
/// will try to return the translation in the default language. Otherwise will return the trnaslation key
/// itself. If "show asterisks" is set - then will reutnr the translation key with surounded with asterisks</returns>
public string translate(string translationKey,
[CallerLineNumber] int lineNumber = 0,
[CallerFilePath] string filePath = null)
{
if (translationKey == null)
{
AppException.writeException(120, null, Environment.StackTrace);
return("");
}
using (citylifedb8_blContext db = new citylifedb8_blContext())
{
TranslationKey theTranslationKey = db.TranslationKey.SingleOrDefault(record => record.TransKey == translationKey);
if (theTranslationKey == null)
{
//the translation key does not exist. Add it to the translation key table and add the
//same text to the translation text as English text
theTranslationKey = new TranslationKey()
{
TransKey = translationKey, IsUsed = true, FilePath = filePath, LineNumber = lineNumber
};
db.TranslationKey.Add(theTranslationKey);
db.SaveChanges();
Language english = db.Language.Single(a => a.LanguageCode == "EN");
Translation theEnglishTranslation = new Translation()
{
LanguageLanguageCode = english.LanguageCode, TranslationKey = theTranslationKey, Message = translationKey
};
db.Translation.Add(theEnglishTranslation);
db.SaveChanges();
if (_noTranslation == "showAsterisks")
{
//return the translation key surrounded by asterisks for QA
string translated = '*' + translationKey + '*';
return(translated);
}
else
{
//assuming "defaultLanguage" - but since there is no translation at all for this key - return the key without asterisks
return(translationKey);
}
}
else
{
//The translation key exists -
if (theTranslationKey.LineNumber != lineNumber || theTranslationKey.FilePath != filePath)
{
//The file path or the line number where the call was performed has changed. Assuming it is because we added some lines of
//code, or refactored the code - update the file path tne line number
theTranslationKey.LineNumber = lineNumber;
theTranslationKey.FilePath = filePath;
db.SaveChanges();
}
//check if we have translation in the desired language
Translation theTranslation = db.Translation.SingleOrDefault(record => record.TranslationKey.Id == theTranslationKey.Id &&
record.LanguageLanguageCode == _targetLanguageCode);
if (theTranslation != null)
{
//the translation exists in the target language - return it
return(theTranslation.Message);
}
else
{
//The translation does not exist in the target language
if (_noTranslation == "showAsterisks")
{
//In this case we need to return the translation key with asterisks
return('*' + translationKey + '*');
}
else
{
//assuming _noTranslation is "defaultLanguage" - look for translation in the default language
theTranslation = db.Translation.SingleOrDefault(record => record.TranslationKey.Id == theTranslationKey.Id &&
record.LanguageLanguageCode == _defaultLanguageCode);
if (theTranslation != null)
{
//translation exists - return it
return(theTranslation.Message);
}
else
{
//no translation exists even in the default language - return the translation key (without asterisks)
return(translationKey);
}
}
}
}
}
}