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