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