private static LocaleStringResourceDictionary DBMapping(DBLocaleStringResourceCollection dbCollection) { if (dbCollection == null) { return(null); } LocaleStringResourceDictionary dictionary = new LocaleStringResourceDictionary(); foreach (DBLocaleStringResource dbItem in dbCollection) { LocaleStringResource item = DBMapping(dbItem); dictionary.Add(item.ResourceName.ToLowerInvariant(), item); } return(dictionary); }
/// <summary> /// Gets all locale string resources by language identifier /// </summary> /// <param name="LanguageID">Language identifier</param> /// <returns>Locale string resource collection</returns> public override DBLocaleStringResourceCollection GetAllResourcesByLanguageID(int LanguageID) { DBLocaleStringResourceCollection localeStringResourceCollection = new DBLocaleStringResourceCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_LocaleStringResourceLoadAllByLanguageID"); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, LanguageID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBLocaleStringResource localeStringResource = GetLocaleStringResourceFromReader(dataReader); localeStringResourceCollection.Add(localeStringResource); } } return(localeStringResourceCollection); }
/// <summary> /// Gets all locale string resources by language identifier /// </summary> /// <param name="languageId">Language identifier</param> /// <returns>Locale string resource collection</returns> public override DBLocaleStringResourceCollection GetAllResourcesByLanguageId(int languageId) { var result = new DBLocaleStringResourceCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_LocaleStringResourceLoadAllByLanguageID"); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetLocaleStringResourceFromReader(dataReader); result.Add(item); } } return(result); }
/// <summary> /// Gets all locale string resources by language identifier /// </summary> /// <param name="LanguageID">Language identifier</param> /// <returns>Locale string resource collection</returns> public static LocaleStringResourceDictionary GetAllResourcesByLanguageID(int LanguageID) { string key = string.Format(LOCALSTRINGRESOURCES_ALL_KEY, LanguageID); object obj2 = NopCache.Get(key); if (LocaleStringResourceManager.CacheEnabled && (obj2 != null)) { return((LocaleStringResourceDictionary)obj2); } DBLocaleStringResourceCollection dbCollection = DBProviderManager <DBLocaleStringResourceProvider> .Provider.GetAllResourcesByLanguageID(LanguageID); LocaleStringResourceDictionary localeStringResourceDictionary = DBMapping(dbCollection); if (LocaleStringResourceManager.CacheEnabled) { NopCache.Max(key, localeStringResourceDictionary); } return(localeStringResourceDictionary); }
/// <summary> /// Gets all locale string resources by language identifier /// </summary> /// <param name="LanguageID">Language identifier</param> /// <returns>Locale string resource collection</returns> public override DBLocaleStringResourceCollection GetAllResourcesByLanguageID(int LanguageID) { DBLocaleStringResourceCollection localeStringResourceCollection = new DBLocaleStringResourceCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_LocaleStringResourceLoadAllByLanguageID"); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, LanguageID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBLocaleStringResource localeStringResource = GetLocaleStringResourceFromReader(dataReader); localeStringResourceCollection.Add(localeStringResource); } } return localeStringResourceCollection; }