public static cg_cms_Pages_Info getCmsPageByName(string pageName, string IetfLanguageTag) { caval_goEntities db = new caval_goEntities(); if (IetfLanguageTag == null) IetfLanguageTag = System.Threading.Thread.CurrentThread.CurrentCulture.IetfLanguageTag; var pageInfo = (from ppg in db.cg_cms_Pages where ppg.Name.ToLower() == pageName.ToLower() from l in db.cg_Languages where l.SystemLocale.ToLower() == IetfLanguageTag.ToLower() from pi in ppg.cg_cms_Pages_Info where pi.LanguageId == l.LanguageId select pi).FirstOrDefault(); if (pageInfo == null) { var defaultCulture = ConfigurationManager.AppSettings["defaultLocale"]; System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo(defaultCulture); pageInfo = (from ppg in db.cg_cms_Pages where ppg.Name.ToLower() == pageName.ToLower() from l in db.cg_Languages where l.SystemLocale.ToLower() == cultureInfo.IetfLanguageTag.ToLower() from pi in ppg.cg_cms_Pages_Info where pi.LanguageId == l.LanguageId select pi).FirstOrDefault(); } if (pageInfo == null) pageInfo = new cg_cms_Pages_Info(); return pageInfo; }
public static string getLangVersion(string input, string IetfLanguageTag) { caval_goEntities db = new caval_goEntities(); string output = input; if (IetfLanguageTag == null) IetfLanguageTag = System.Threading.Thread.CurrentThread.CurrentCulture.IetfLanguageTag; var langTranslate = (from l in db.cg_Languages where l.SystemLocale.ToLower() == IetfLanguageTag.ToLower() from lt in l.cg_LanguageTranslations where lt.Original == input select lt).FirstOrDefault(); if (langTranslate == null) { var defaultCulture = ConfigurationManager.AppSettings["defaultLocale"]; System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo(defaultCulture); langTranslate = (from l in db.cg_Languages where l.SystemLocale.ToLower() == cultureInfo.IetfLanguageTag.ToLower() from lt in l.cg_LanguageTranslations where lt.Original == input select lt).FirstOrDefault(); } if (langTranslate != null) { output = langTranslate.Translated; } return output; }