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