Son Do
Dec 31, 2016
  3687
(1 votes)

EPiServer Commerce: updating currency exchange rates automatically

Simple exchange rates updater automatically.


Why we need update exchange rates automatically

Currency exchange rates are changed everyday or hourly. This is quite important, our commerce site also need to update them to correct product price, shipping cost, ... more often.

How can we do

- Currency exchange rates source: in this sample, I used source from http://fixer.io/ - it's free and simple. You can chose whatever source if you feel trust.

- We have EPiServer schedule job - this is called and run in the background at preset time intervals (for more information, you can go here). So we could write a schedule job to update our task.

Step by step

Step 1: In your project site, create a class, name it as ExchangeRatesUpdateJob.cs.

This class will inherit from ScheduleJobBase.


[ScheduledPlugIn(
    DisplayName = "Exchange Rates update job",
    Description = "This job update exchange rates.")]
public class ExchangeRatesUpdateJob : ScheduledJobBase
{
    public override string Execute()
    {
        return "Exchange Rate update Job was finished.";
    }
}

This class is same as document I mentioned above.

Step 2: using CurrencyManager to update Exchange rates.


[ScheduledPlugIn(
    DisplayName = "Exchange Rates update job",
    Description = "This job update exchange rates.")]
public class ExchangeRatesUpdateJob : ScheduledJobBase
{
    [NonSerialized]
    private static readonly ILogger _log = LogManager.GetLogger(typeof(ExchangeRatesUpdateJob));
        
    public override string Execute()
    {
        string message = string.Empty;
        int records = UpdateExchangeRate(out message);
        return $"{records.ToString()} currencies were updated. {message}. Exchange Rate update Job was finished.";
    }
        
    private static int UpdateExchangeRate(out string message)
    {
        message = string.Empty;
        _log.Information("Starting to update exchange rate job.");
        var processedCurrency = 0;
        var dto = CurrencyManager.GetCurrencyDto();
            
        var currencyCodeIdMapping = dto.Currency.ToDictionary(c => c.CurrencyCode, c => c.CurrencyId);

        try
        {
            foreach (var code in currencyCodeIdMapping.Keys)
            {
                int fromCurrencyId;
                currencyCodeIdMapping.TryGetValue(code, out fromCurrencyId);

                try
                {
                    var uri = $"http://api.fixer.io/latest?base={code}";
                    using (var client = new WebClient())
                    {
                        var json = client.DownloadString(uri);
                        dynamic d = JObject.Parse(json);

                        DateTime exchangeDate = d.date; 

                        foreach (var rate in d.rates)
                        {
                            string toCurrencyCode = rate.Name;
                            int toCurrencyId;
                            if (currencyCodeIdMapping.TryGetValue(toCurrencyCode, out toCurrencyId))
                            {

                                var currencyRate = dto.CurrencyRate.NewCurrencyRateRow();
                                currencyRate.FromCurrencyId = fromCurrencyId;
                                currencyRate.ToCurrencyId = toCurrencyId;

                                currencyRate.EndOfDayRate = currencyRate.AverageRate = rate.Value;
                                currencyRate.CurrencyRateDate = exchangeDate;
                                currencyRate.ModifiedDate = DateTime.Now;
                                dto.CurrencyRate.AddCurrencyRateRow(currencyRate);
                                currencyRate.AcceptChanges();
                            }
                        }

                        dto.CurrencyRate.AcceptChanges();
                    }
                }
                catch (Exception ex)
                {
                    message += "Cannot update currency {code}. ";
                    _log.Error("Cannot update currency {code}.", ex);
                    continue;
                }

                dto.AcceptChanges();
                processedCurrency++;
                _log.Information($"{code} rates were updated");
            }
        }
        catch (Exception ex)
        {
            _log.Error("The job could not be completed. ", ex);
        }
        return processedCurrency;
    }
}

Step 3: rebuild solution, reset your site to add our new Schedule job to system.

Navigate to CMS/Admin menu, we will see our schedule job in left panel.

Exchange rates schedule job

Click on Start Manually to get first exchange rates.

Step 4: Set Active = true, in this sample, we will set schedule run everyday in 12.00 am.

Setting Exchange rates schedule job

So our job was FINISHED and this job will update exchange rates everyday to our site :)

You could download this file from my github.

Hope this post help your works.

/Son Do

Dec 31, 2016

Comments

valdis
valdis Jan 1, 2017 07:45 PM

Hi,

Nice. I would add my 2 cents:

1) you can (from v 10.3) inject ILogger interface in job via constructor injection

2) I would refactor so that *actual* exchange rate logic in somewhere outside - in some service or whatever, and scheduled job acts only as shell, as triggering mechanism that will call that service. This could make it easier to create unit/integration tests.

Jeroen Stemerdink
Jeroen Stemerdink Jan 2, 2017 10:11 AM

Hi Son, I actually created a NuGet package for this about a year ago, with two services/providers, Fixer and CurrencyLayer.

You could also use a different service by creating a different provider, see my post from last year for instructions how to do that.

Son Do
Son Do Jan 3, 2017 01:30 AM

@Valdis: thanks, I will update sample code for this.

@Jeroen: great to see your post and your github repo (y). You wrote out what I plan to do, this makes me feel good with currency area. Thank you.

Please login to comment.
Latest blogs
PageCriteriaQueryService builder with Blazor and MudBlazor

This might be a stupid idea but my new years resolution was to do / test more stuff so here goes. This razor component allows users to build and...

Per Nergård (MVP) | Feb 10, 2025

Enhancing Optimizely CMS Multi-Site Architecture with Structured Isolation

The main challenge of building an Optimizely CMS website is to think about its multi site capabilities up front. Making adjustment after the fact c...

David Drouin-Prince | Feb 9, 2025 | Syndicated blog

How to: set access right to folders

Today I stumped upon this question Solution for Handling File Upload Permissions in Episerver CMS 12, and there is a simple solution for that Using...

Quan Mai | Feb 7, 2025 | Syndicated blog

Poking around in the new Visual Builder and the SaaS CMS

Early findings from using a SaaS CMS instance and the new Visual Builder grids.

Johan Kronberg | Feb 7, 2025 | Syndicated blog

Be careful with your (order) notes

This happened a quite ago but only now I have had time to write about it. Once upon a time, I was asked to look into a customer database (in a big...

Quan Mai | Feb 5, 2025 | Syndicated blog

Imagevault download picker

This open source extension enables you to download images as ImageData with ContentReference from the ImageVault picker. It serves as an alternativ...

Luc Gosso (MVP) | Feb 4, 2025 | Syndicated blog