/// <summary> /// Gets specification attribute collection /// </summary> /// <returns>Specification attribute collection</returns> public override DBSpecificationAttributeCollection GetSpecificationAttributes() { DBSpecificationAttributeCollection specificationAttributeCollection = new DBSpecificationAttributeCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_SpecificationAttributeLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBSpecificationAttribute specificationAttribute = GetSpecificationAttributeFromReader(dataReader); specificationAttributeCollection.Add(specificationAttribute); } } return(specificationAttributeCollection); }
/// <summary> /// Gets specification attribute collection /// </summary> /// <param name="languageId">Language identifier</param> /// <returns>Specification attribute collection</returns> public override DBSpecificationAttributeCollection GetSpecificationAttributes(int languageId) { var result = new DBSpecificationAttributeCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_SpecificationAttributeLoadAll"); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetSpecificationAttributeFromReader(dataReader); result.Add(item); } } return(result); }
/// <summary> /// Gets specification attribute collection /// </summary> /// <returns>Specification attribute collection</returns> public override DBSpecificationAttributeCollection GetSpecificationAttributes() { DBSpecificationAttributeCollection specificationAttributeCollection = new DBSpecificationAttributeCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_SpecificationAttributeLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBSpecificationAttribute specificationAttribute = GetSpecificationAttributeFromReader(dataReader); specificationAttributeCollection.Add(specificationAttribute); } } return specificationAttributeCollection; }