private DBProductVariantAttributeValueLocalized GetProductVariantAttributeValueLocalizedFromReader(IDataReader dataReader) { var item = new DBProductVariantAttributeValueLocalized(); item.ProductVariantAttributeValueLocalizedId = NopSqlDataHelper.GetInt(dataReader, "ProductVariantAttributeValueLocalizedID"); item.ProductVariantAttributeValueId = NopSqlDataHelper.GetInt(dataReader, "ProductVariantAttributeValueID"); item.LanguageId = NopSqlDataHelper.GetInt(dataReader, "LanguageID"); item.Name = NopSqlDataHelper.GetString(dataReader, "Name"); return(item); }
/// <summary> /// Gets localized product variant attribute value by product variant attribute value id and language id /// </summary> /// <param name="productVariantAttributeValueId">Product variant attribute value identifier</param> /// <param name="languageId">Language identifier</param> /// <returns>Localized product variant attribute value</returns> public override DBProductVariantAttributeValueLocalized GetProductVariantAttributeValueLocalizedByProductVariantAttributeValueIdAndLanguageId(int productVariantAttributeValueId, int languageId) { DBProductVariantAttributeValueLocalized item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariantAttributeValueLocalizedLoadByProductVariantAttributeValueIDAndLanguageID"); db.AddInParameter(dbCommand, "ProductVariantAttributeValueID", DbType.Int32, productVariantAttributeValueId); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { item = GetProductVariantAttributeValueLocalizedFromReader(dataReader); } } return(item); }
/// <summary> /// Update a localized product variant attribute value /// </summary> /// <param name="productVariantAttributeValueLocalizedId">Localized product variant attribute value identifier</param> /// <param name="productVariantAttributeValueId">Product variant attribute value identifier</param> /// <param name="languageId">Language identifier</param> /// <param name="name">Name text</param> /// <returns>Localized product variant attribute value</returns> public override DBProductVariantAttributeValueLocalized UpdateProductVariantAttributeValueLocalized(int productVariantAttributeValueLocalizedId, int productVariantAttributeValueId, int languageId, string name) { DBProductVariantAttributeValueLocalized item = null; Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariantAttributeValueLocalizedUpdate"); db.AddInParameter(dbCommand, "ProductVariantAttributeValueLocalizedID", DbType.Int32, productVariantAttributeValueLocalizedId); db.AddInParameter(dbCommand, "ProductVariantAttributeValueID", DbType.Int32, productVariantAttributeValueId); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId); db.AddInParameter(dbCommand, "Name", DbType.String, name); if (db.ExecuteNonQuery(dbCommand) > 0) { item = GetProductVariantAttributeValueLocalizedById(productVariantAttributeValueLocalizedId); } return(item); }