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