CustomExchangeTableInfoProvider

Top  Previous  Next

This class works with exchange rates. It uses the CMS.Ecommerce.ExchangeTableInfo class.

 

object GetExchangeTableInfo(int exchangeTableId) returns the ExchangeTableInfo object selected by given table ID.
object GetExchangeTableInfo(string tableName) - returns the ExchangeTableInfo object selected by given table name.
void SetExchangeTableInfo(object exchangeTable) updates the exchange table record based on given ExchangeTableInfo object data. If ExchangeTableID is set, updates the record, else inserts a new one.
void DeleteExchangeTableInfo(int exchangeTableId) deletes the exchange table.
DataSet GetRatesByTableID(int tableId) returns the DataSet of exchange rates for given table ID.
void DeleteRateByRateId(int currencyId, int tableId) - deletes specified currency exchange rate from exchange table.
void SetRateByRateId(int rateId, int CurrencyId, double rateValue, int tableId) sets the specified rate value.
object GetLastValidExchangeTableInfo() returns ExchangeTableInfo object that was last valid.
double ApplyExchangeRate(double value, double exchangeRate) applies the exchange rate to the given price. By default resulting_price = original_price / exchange_rate.
DataSet GetExchangeTables() returns the DataSet of all the exchange tables. See database reference for column details.
DataSet GetExchangeTables(string where, string orderBy) returns the DataSet of exchange tables selected with given condition and order.