public List <DB_ExchangeRate> Map_ExchangeRates_ToDBModelList(ExchangeRates exchangeRates)
{
List <DB_ExchangeRate> result = new List <DB_ExchangeRate>();
string[] countryCodes = ConfigurationManager.AppSettings["CountryCodesToRecord"].Split(';');
if (countryCodes.Contains("GB"))
{
result.Add(Return_GBPExchangeRate_ToModel());
}
foreach (ExchangeRate _exchangeRate in exchangeRates.Exchange_Rates)
{
if (countryCodes.Contains(_exchangeRate.To_Country_Code))
{
DB_ExchangeRate _newExchangeRate = new DB_ExchangeRate()
{
FROM_COUNTRY_CODE = _exchangeRate.From_Country_Code,
FROM_CURRENCY = _exchangeRate.From_Currency_Code,
TO_COUNTRY_CODE = _exchangeRate.To_Country_Code,
TO_CURRENCY = _exchangeRate.To_Currency_Code,
EFFECTIVE_DATE = exchangeRates.Effective_Date,
EXCHANGE_RATE = _exchangeRate.Rate_of_Exchange,
LAST_UPDATE_USR_ID = "HMRC_Update"
};
result.Add(_newExchangeRate);
}
}
return(result);
}
private DB_ExchangeRate Return_GBPExchangeRate_ToModel()
{
DateTime effectiveDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0);
DB_ExchangeRate result = new DB_ExchangeRate()
{
FROM_COUNTRY_CODE = "GB",
TO_COUNTRY_CODE = "GB",
FROM_CURRENCY = "GBP",
TO_CURRENCY = "GBP",
EFFECTIVE_DATE = effectiveDate,
EXCHANGE_RATE = 1,
LAST_UPDATE_USR_ID = "HMRC_Update",
};
return(result);
}
