public static void Initialize(ExchangeRatesDBContext context) { try { context.Database.EnsureCreated(); if (context.Currencies.Any()) { return; } var britainCurrency = new Currency { CurrencyName = "Sterling Pound", CurrencyCode = "GBP" }; var australiaCurrency = new Currency { CurrencyName = "Australia Dollar", CurrencyCode = "AUD" }; var americaCurrency = new Currency { CurrencyName = "USA Dollar", CurrencyCode = "USD" }; var euroCurrency = new Currency { CurrencyName = "Euro", CurrencyCode = "EUR" }; var currencies = new Currency[] { britainCurrency, australiaCurrency, americaCurrency, euroCurrency }; foreach (var currency in currencies) { context.Currencies.Add(currency); } context.SaveChanges(); if (context.ExchangeRates.Any()) { return; } var curFor01DecGBPToAUD = new ExchangeRate { Date = new DateTime(2019, 12, 1), FromCurrencyId = 1, ToCurrencyId = 2, Rate = 1.823f }; var curFor01DecGBPToUSA = new ExchangeRate { Date = new DateTime(2019, 12, 1), FromCurrencyId = 1, ToCurrencyId = 3, Rate = 1.114f }; var curFor01DecGBPToEUR = new ExchangeRate { Date = new DateTime(2019, 12, 1), FromCurrencyId = 1, ToCurrencyId = 4, Rate = 1.123f }; var curFor02DecGBPToAUD = new ExchangeRate { Date = new DateTime(2019, 12, 2), FromCurrencyId = 1, ToCurrencyId = 2, Rate = 1.723f }; var curFor02DecGBPToUSA = new ExchangeRate { Date = new DateTime(2019, 12, 2), FromCurrencyId = 1, ToCurrencyId = 3, Rate = 1.123f }; var curFor02DecGBPToEUR = new ExchangeRate { Date = new DateTime(2019, 12, 2), FromCurrencyId = 1, ToCurrencyId = 4, Rate = 1.565f }; var curFor03DecGBPToAUD = new ExchangeRate { Date = new DateTime(2019, 12, 3), FromCurrencyId = 1, ToCurrencyId = 2, Rate = 1.457f }; var curFor03DecGBPToUSA = new ExchangeRate { Date = new DateTime(2019, 12, 3), FromCurrencyId = 1, ToCurrencyId = 3, Rate = 1.144f }; var curFor03DecGBPToEUR = new ExchangeRate { Date = new DateTime(2019, 12, 3), FromCurrencyId = 1, ToCurrencyId = 4, Rate = 1.785f }; var exchangeRates = new ExchangeRate[] { curFor01DecGBPToAUD, curFor01DecGBPToUSA, curFor01DecGBPToEUR, curFor02DecGBPToAUD, curFor02DecGBPToUSA, curFor02DecGBPToEUR, curFor03DecGBPToAUD, curFor03DecGBPToUSA, curFor03DecGBPToEUR }; foreach (var er in exchangeRates) { context.ExchangeRates.Add(er); } context.SaveChanges(); } catch (Exception ex) { throw ex; } }
public AuditLogsController(ExchangeRatesDBContext context) { _context = context; }
public ExchangeRatesController(ExchangeRatesDBContext context, ILogger logger) { _context = context; _logger = logger; }
public CurrenciesController(ExchangeRatesDBContext context) { _context = context; }
public Logger(ExchangeRatesDBContext context) { _context = context; }