public bool IsCultureSupported(string cultureCode)
{
LanguageTableAdapter adapter = new LanguageTableAdapter();
MultiLingualData.LanguageDataTable table = adapter.GetLanguageByCulture(cultureCode);
if (table.Count == 0)
{
return(false);
}
return(table[0].enabled);
}
public string GetLanguageCodeByName(string name)
{
LanguageTableAdapter adapter = new LanguageTableAdapter();
MultiLingualData.LanguageDataTable table = adapter.GetLanguageByName(name);
if (table.Count == 0)
{
return(null);
}
return(table[0].code);
}
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 <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 void InitDatabaseSchema()
{
var commands = new string[0];
using (var script = new System.IO.StreamReader(this.GetType().Assembly.GetManifestResourceStream(this.GetType().Assembly.GetName().Name + ".SqlMultiLingual.sql")))
{
commands = script.ReadToEnd().Split(new string[] { "GO" }, StringSplitOptions.RemoveEmptyEntries);
}
using (var adapter = new LanguageTableAdapter())
{
adapter.Connection.Open();
var cmd = adapter.Connection.CreateCommand();
foreach (var command in commands)
{
cmd.CommandText = command;
cmd.ExecuteNonQuery();
}
}
}
