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;
}
