private DBProductAttributeLocalized GetProductAttributeLocalizedFromReader(IDataReader dataReader) { var item = new DBProductAttributeLocalized(); item.ProductAttributeLocalizedId = NopSqlDataHelper.GetInt(dataReader, "ProductAttributeLocalizedID"); item.ProductAttributeId = NopSqlDataHelper.GetInt(dataReader, "ProductAttributeID"); item.LanguageId = NopSqlDataHelper.GetInt(dataReader, "LanguageID"); item.Name = NopSqlDataHelper.GetString(dataReader, "Name"); item.Description = NopSqlDataHelper.GetString(dataReader, "Description"); return(item); }
/// <summary> /// Gets localized product attribute by product attribute id and language id /// </summary> /// <param name="productAttributeId">Product attribute identifier</param> /// <param name="languageId">Language identifier</param> /// <returns>Product attribute content</returns> public override DBProductAttributeLocalized GetProductAttributeLocalizedByProductAttributeIdAndLanguageId(int productAttributeId, int languageId) { DBProductAttributeLocalized item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductAttributeLocalizedLoadByProductAttributeIDAndLanguageID"); db.AddInParameter(dbCommand, "ProductAttributeID", DbType.Int32, productAttributeId); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { item = GetProductAttributeLocalizedFromReader(dataReader); } } return(item); }
/// <summary> /// Update a localized product attribute /// </summary> /// <param name="productAttributeLocalizedId">Localized product attribute identifier</param> /// <param name="productAttributeId">Product attribute identifier</param> /// <param name="languageId">Language identifier</param> /// <param name="name">Name text</param> /// <param name="description">Description text</param> /// <returns>Product attribute content</returns> public override DBProductAttributeLocalized UpdateProductAttributeLocalized(int productAttributeLocalizedId, int productAttributeId, int languageId, string name, string description) { DBProductAttributeLocalized item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductAttributeLocalizedUpdate"); db.AddInParameter(dbCommand, "ProductAttributeLocalizedID", DbType.Int32, productAttributeLocalizedId); db.AddInParameter(dbCommand, "ProductAttributeID", DbType.Int32, productAttributeId); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId); db.AddInParameter(dbCommand, "Name", DbType.String, name); db.AddInParameter(dbCommand, "Description", DbType.String, description); if (db.ExecuteNonQuery(dbCommand) > 0) { item = GetProductAttributeLocalizedById(productAttributeLocalizedId); } return(item); }