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. |
|