/// <summary>
/// Update a localized checkout attribute
/// </summary>
/// <param name="checkoutAttributeLocalizedId">Localized checkout attribute identifier</param>
/// <param name="checkoutAttributeId">Checkout attribute identifier</param>
/// <param name="languageId">Language identifier</param>
/// <param name="name">Name text</param>
/// <param name="textPrompt">Text prompt</param>
/// <returns>Checkout attribute content</returns>
public override DBCheckoutAttributeLocalized UpdateCheckoutAttributeLocalized(int checkoutAttributeLocalizedId,
int checkoutAttributeId, int languageId, string name, string textPrompt)
{
DBCheckoutAttributeLocalized item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_CheckoutAttributeLocalizedUpdate");
db.AddInParameter(dbCommand, "CheckoutAttributeLocalizedID", DbType.Int32, checkoutAttributeLocalizedId);
db.AddInParameter(dbCommand, "CheckoutAttributeID", DbType.Int32, checkoutAttributeId);
db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId);
db.AddInParameter(dbCommand, "Name", DbType.String, name);
db.AddInParameter(dbCommand, "TextPrompt", DbType.String, textPrompt);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetCheckoutAttributeLocalizedById(checkoutAttributeLocalizedId);
}
return(item);
}
/// <summary>
/// Gets localized checkout attribute by id
/// </summary>
/// <param name="checkoutAttributeLocalizedId">Localized checkout attribute identifier</param>
/// <returns>Checkout attribute content</returns>
public override DBCheckoutAttributeLocalized GetCheckoutAttributeLocalizedById(int checkoutAttributeLocalizedId)
{
DBCheckoutAttributeLocalized item = null;
if (checkoutAttributeLocalizedId == 0)
{
return(item);
}
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_CheckoutAttributeLocalizedLoadByPrimaryKey");
db.AddInParameter(dbCommand, "CheckoutAttributeLocalizedID", DbType.Int32, checkoutAttributeLocalizedId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetCheckoutAttributeLocalizedFromReader(dataReader);
}
}
return(item);
}