private void GetDataFromDbButton_Click(object sender, RoutedEventArgs e) { var cbrDbContext = new CbrDb(); cbrDbContext.OpenConnection(_dbConnectionString); CurrenciesGrid.ItemsSource = cbrDbContext.GetAllValuteAsList(); cbrDbContext.CloseConnection(); }
private bool SaveDataToDb(IEnumerable <CurrencyRateModel> currencyRate) { var cbrDbContext = new CbrDb(); cbrDbContext.OpenConnection(_dbConnectionString); if (!cbrDbContext.CleanCurrencyRateTable()) { cbrDbContext.CloseConnection(); return(false); } if (currencyRate.Any(valute => !cbrDbContext.InsertCurrencyRate(valute))) { cbrDbContext.CloseConnection(); return(false); } cbrDbContext.CloseConnection(); return(true); }