public void DeleteCurrentExchRatesFromDb(ExchangeRateToUsdCurrentRepository _exchangeRateToUsdCurrentRepository)
{
var exchRates = _exchangeRateToUsdCurrentRepository.GetAll();
foreach (var rate in exchRates)
{
_exchangeRateToUsdCurrentRepository.Remove(rate.Id);
}
}
static void Main(string[] args)
{
DbContextOptionsBuilder dbContextOptionsBuilder = new DbContextOptionsBuilder();
var connection = dbContextOptionsBuilder
.UseSqlServer("Server=(localdb)\\MSSQLLocalDB;Database=SpaceWeb;Trusted_Connection=True");
SpaceDbContext spaceDbContext = new SpaceDbContext(connection.Options);
ExchangeRateToUsdCurrentRepository exchangeRateToUsdCurrentRepository =
new ExchangeRateToUsdCurrentRepository(spaceDbContext);
ExchangeAccountHistoryRepository exchangeAccountHistoryRepository =
new ExchangeAccountHistoryRepository(spaceDbContext);
ExchangeRateToUsdHistoryRepository exchangeRateToUsdHistoryRepository =
new ExchangeRateToUsdHistoryRepository(spaceDbContext);
var configExpression = new MapperConfigurationExpression();
var mapperConfiguration = new MapperConfiguration(configExpression);
var mapper = new Mapper(mapperConfiguration);
var contextAccessor = new HttpContextAccessor();
TransactionBankRepository transactionBankRepository = new TransactionBankRepository(spaceDbContext);
var bankAccountRepository = new BankAccountRepository(spaceDbContext, mapper, contextAccessor, transactionBankRepository);
var userRepository = new UserRepository(spaceDbContext, bankAccountRepository);
IUserService userService = new UserService(userRepository, contextAccessor);
var currencyService =
new CurrencyService(userService,
exchangeRateToUsdCurrentRepository,
exchangeAccountHistoryRepository,
exchangeRateToUsdHistoryRepository,
mapper);
var currentDate = DateTime.Now;
while (true)
{
if ((currentDate.Minute % 3) == 0)
{
currencyService.MoveCurrentExchangesDbToHistoryDb(exchangeRateToUsdCurrentRepository, exchangeRateToUsdHistoryRepository, mapper);
currencyService.DeleteCurrentExchRatesFromDb(exchangeRateToUsdCurrentRepository);
currencyService.PutCurrentExchangeRatesToDb(
exchangeRateToUsdCurrentRepository,
currencyService.GetExchangeRates());
Console.Write($"Current exchanges update for History DB at {currentDate}");
Thread.Sleep(3 * 59 * 1000); // 59 - because updating exchanges takes ~ 1 second and timer gets a displacement.
}
currentDate = DateTime.Now;
currentDate = currentDate.AddSeconds(-currentDate.Second);
}
}
public void MoveCurrentExchangesDbToHistoryDb(ExchangeRateToUsdCurrentRepository _exchangeRateToUsdCurrentRepository,
ExchangeRateToUsdHistoryRepository _exchangeRateToUsdHistoryRepository, Mapper _mapper)
{
var exchCurrentRates = _exchangeRateToUsdCurrentRepository.GetAll();
foreach (var exchCurrRate in exchCurrentRates)
{
//var exchRateHistory = _mapper.Map<ExchangeRateToUsdHistory>(exchCurrRate);
//exchRateHistory.ExchRateDate = DateTime.Now;
//_exchangeRateToUsdHistoryRepository.Save(exchRateHistory);
var exchRateHistory = new ExchangeRateToUsdHistory
{
Currency = exchCurrRate.Currency,
TypeOfExch = exchCurrRate.TypeOfExch,
ExchRate = exchCurrRate.ExchRate,
ExchRateDate = GetDateWithNullSecAndMillisec()
};
_exchangeRateToUsdHistoryRepository.Save(exchRateHistory);
}
}
public void PutCurrentExchangeRatesToDb(ExchangeRateToUsdCurrentRepository _exchangeRateToUsdCurrentRepository,
GottenCurrency exchangeRates)
{
var exchangeRateDb = new ExchangeRateToUsdCurrent
{
Currency = Currency.BYN,
TypeOfExch = TypeOfExchange.Buy,
ExchRate = Convert.ToDecimal(exchangeRates.USD_in, new CultureInfo("en-US"))
};
_exchangeRateToUsdCurrentRepository.Save(exchangeRateDb);
exchangeRateDb = new ExchangeRateToUsdCurrent
{
Currency = Currency.BYN,
TypeOfExch = TypeOfExchange.Sell,
ExchRate = Convert.ToDecimal(exchangeRates.USD_out, new CultureInfo("en-US"))
};
_exchangeRateToUsdCurrentRepository.Save(exchangeRateDb);
exchangeRateDb = new ExchangeRateToUsdCurrent
{
Currency = Currency.USD,
TypeOfExch = TypeOfExchange.Buy,
ExchRate = 1
};
_exchangeRateToUsdCurrentRepository.Save(exchangeRateDb);
exchangeRateDb = new ExchangeRateToUsdCurrent
{
Currency = Currency.USD,
TypeOfExch = TypeOfExchange.Sell,
ExchRate = 1
};
_exchangeRateToUsdCurrentRepository.Save(exchangeRateDb);
exchangeRateDb = new ExchangeRateToUsdCurrent
{
Currency = Currency.EUR,
TypeOfExch = TypeOfExchange.Buy,
ExchRate = Convert.ToDecimal(exchangeRates.USD_in, new CultureInfo("en-US"))
/ Convert.ToDecimal(exchangeRates.EUR_in, new CultureInfo("en-US"))
};
_exchangeRateToUsdCurrentRepository.Save(exchangeRateDb);
exchangeRateDb = new ExchangeRateToUsdCurrent
{
Currency = Currency.EUR,
TypeOfExch = TypeOfExchange.Sell,
ExchRate = Convert.ToDecimal(exchangeRates.USD_out, new CultureInfo("en-US"))
/ Convert.ToDecimal(exchangeRates.EUR_out, new CultureInfo("en-US"))
};
_exchangeRateToUsdCurrentRepository.Save(exchangeRateDb);
exchangeRateDb = new ExchangeRateToUsdCurrent
{
Currency = Currency.GBP,
TypeOfExch = TypeOfExchange.Buy,
ExchRate = Convert.ToDecimal(exchangeRates.USD_in, new CultureInfo("en-US"))
/ Convert.ToDecimal(exchangeRates.GBP_in, new CultureInfo("en-US"))
};
_exchangeRateToUsdCurrentRepository.Save(exchangeRateDb);
exchangeRateDb = new ExchangeRateToUsdCurrent
{
Currency = Currency.GBP,
TypeOfExch = TypeOfExchange.Sell,
ExchRate = Convert.ToDecimal(exchangeRates.USD_out, new CultureInfo("en-US"))
/ Convert.ToDecimal(exchangeRates.GBP_out, new CultureInfo("en-US"))
};
_exchangeRateToUsdCurrentRepository.Save(exchangeRateDb);
exchangeRateDb = new ExchangeRateToUsdCurrent
{
Currency = Currency.PLN,
TypeOfExch = TypeOfExchange.Buy,
ExchRate = Convert.ToDecimal(exchangeRates.USD_in, new CultureInfo("en-US"))
/ Convert.ToDecimal(exchangeRates.PLN_in, new CultureInfo("en-US"))
* 10
};
_exchangeRateToUsdCurrentRepository.Save(exchangeRateDb);
exchangeRateDb = new ExchangeRateToUsdCurrent
{
Currency = Currency.PLN,
TypeOfExch = TypeOfExchange.Sell,
ExchRate = Convert.ToDecimal(exchangeRates.USD_out, new CultureInfo("en-US"))
/ Convert.ToDecimal(exchangeRates.PLN_out, new CultureInfo("en-US"))
* 10
};
_exchangeRateToUsdCurrentRepository.Save(exchangeRateDb);
Console.WriteLine();
}
