public Translation GetTranslation(int phraseId, string languageCode)
{
TranslationTableAdapter adapter = new TranslationTableAdapter();
MultiLingualData.TranslationDataTable table = adapter.GetTranslationByPhraseId(phraseId, languageCode);
if (table.Count == 0)
{
return(null);
}
return(MultiLingualHelper.ToTranslationDTO(table[0]));
}
public Phrase GetPhraseByText(string text)
{
PhraseTableAdapter adapter = new PhraseTableAdapter();
MultiLingualData.PhraseDataTable table = adapter.GetPhraseByText(text);
if (table.Count == 0)
{
return(null);
}
return(MultiLingualHelper.ToPhraseDTO(table[0], DefaultLanguageCode));
}
public Translation GetTranslation(int translationId)
{
TranslationTableAdapter adapter = new TranslationTableAdapter();
MultiLingualData.TranslationDataTable table = adapter.GetTranslation(translationId);
if (table.Count == 0)
{
return(null);
}
return(MultiLingualHelper.ToTranslationDTO(table[0]));
}
public Phrase GetPhraseByReferenceId(int referenceId)
{
PhraseTableAdapter adapter = new PhraseTableAdapter();
MultiLingualData.PhraseDataTable table = adapter.GetPhraseByReferenceId(referenceId);
if (table.Count == 0)
{
return(null);
}
return(MultiLingualHelper.ToPhraseDTO(table[0], DefaultLanguageCode));
}
public Language GetLanguageByName(string name)
{
LanguageTableAdapter adapter = new LanguageTableAdapter();
MultiLingualData.LanguageDataTable table = adapter.GetLanguageByName(name);
if (table.Count == 0)
{
return(null);
}
return(MultiLingualHelper.ToLanguageDTO(table[0]));
}
public List <Translation> GetAllTranslationsByLanguage(string languageCode)
{
List <Translation> translations = new List <Translation>();
TranslationTableAdapter adapter = new TranslationTableAdapter();
MultiLingualData.TranslationDataTable table = adapter.GetAllTranslationsByLanguage(languageCode);
foreach (MultiLingualData.TranslationRow row in table)
{
translations.Add(MultiLingualHelper.ToTranslationDTO(row));
}
return(translations);
}
public List <Region> GetAllRegions()
{
List <Region> regions = new List <Region>();
RegionTableAdapter adapter = new RegionTableAdapter();
MultiLingualData.RegionDataTable table = adapter.GetAllRegions();
foreach (MultiLingualData.RegionRow row in table)
{
regions.Add(MultiLingualHelper.ToRegionDTO(row));
}
return(regions);
}
public List <Language> GetAllLanguages()
{
List <Language> langs = new List <Language>();
LanguageTableAdapter adapter = new LanguageTableAdapter();
MultiLingualData.LanguageDataTable table = adapter.GetAllLanguages();
foreach (MultiLingualData.LanguageRow row in table)
{
langs.Add(MultiLingualHelper.ToLanguageDTO(row));
}
return(langs);
}
public Region GetRegion(string regionCode)
{
if (string.IsNullOrEmpty(regionCode))
{
return(new Region());
}
RegionTableAdapter adapter = new RegionTableAdapter();
MultiLingualData.RegionDataTable table = adapter.GetRegion(regionCode);
if (table.Count == 0)
{
return(new Region());
}
return(MultiLingualHelper.ToRegionDTO(table[0]));
}
public Translation UpdateTranslation(int phraseId, string languageCode, string translationText, TranslationStatus status, string updatedBy)
{
TranslationTableAdapter adapter = new TranslationTableAdapter();
MultiLingualData.TranslationDataTable table = adapter.GetTranslationByPhraseId(phraseId, languageCode);
if (table.Count == 0)
{
return(null);
}
MultiLingualData.TranslationRow row = table[0];
row.translationText = translationText;
row.status = (int)status;
row.lastEditedBy = updatedBy;
adapter.Update(row);
return(MultiLingualHelper.ToTranslationDTO(row));
}
public Phrase UpdatePhraseText(int phraseId, string text, string updatedBy)
{
PhraseTableAdapter adapter = new PhraseTableAdapter();
MultiLingualData.PhraseDataTable table = adapter.GetPhrase(phraseId);
if (table.Count == 0)
{
return(null);
}
MultiLingualData.PhraseRow row = table[0];
row.defaultPhrase = text;
row.lastEditedBy = updatedBy;
adapter.Update(row);
UpdateTranslation(row.id, DefaultLanguageCode, text, TranslationStatus.Translated, updatedBy);
return(MultiLingualHelper.ToPhraseDTO(row, DefaultLanguageCode));
}
public string GetPhraseTextByReferenceId(int referenceId, string languageCode)
{
TranslationTableAdapter adapter = new TranslationTableAdapter();
MultiLingualData.TranslationDataTable table = adapter.GetTranslationByReferenceId(referenceId, languageCode);
if (table.Count > 0)
{
Translation tran = MultiLingualHelper.ToTranslationDTO(table[0]);
return(tran.Text);
}
_logger.Error(this.GetType(), "MultiLingual error - could not find translation. referenceId=[{0}] language=[{1}]", referenceId, languageCode);
//get phrase and default text
Phrase phrase = GetPhraseByReferenceId(referenceId);
if (phrase != null)
{
return(phrase.DefaultPhrase);
}
return("");
}
private Dictionary <string, string> BuildTranslationCache()
{
var items = new Dictionary <string, string>();
var translations = new TranslationTableAdapter().GetAllTranslations().Select(t => MultiLingualHelper.ToTranslationDTO(t)).ToArray();
foreach (var phraseReference in new PhraseReferenceTableAdapter().GetAllPhraseReferences())
{
foreach (var phraseTranslation in translations.Where(t => t.PhraseId == phraseReference.phraseId))
{
items.Add(phraseReference.id.ToString() + phraseTranslation.LanguageCode, phraseTranslation.Text);
}
}
if (System.Web.HttpRuntime.Cache != null)
{
int cacheMinutes;
if (!int.TryParse(System.Configuration.ConfigurationManager.AppSettings[""], out cacheMinutes))
{
cacheMinutes = 15;
}
System.Web.HttpRuntime.Cache.Remove("Discover.MultiLingual.SQL.SqlMultiLingual.TranslatedPhrases");
System.Web.HttpRuntime.Cache.Add("Discover.MultiLingual.SQL.SqlMultiLingual.TranslatedPhrases", items, null, DateTime.Now.AddMinutes(cacheMinutes), System.Web.Caching.Cache.NoSlidingExpiration, System.Web.Caching.CacheItemPriority.Normal, null);
}
return(items);
}
