/// <summary> /// Saves the record to the SQL database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnSubmit_Click(object sender, RoutedEventArgs e) { Stock stock = new Stock(); if (tbStockExchange.Text != null) { stock.StockExchange = tbStockExchange.Text.ToUpper(); } if (tbStockSymbol.Text != null) { stock.StockSymbol = tbStockSymbol.Text.ToUpper(); } if (dpDate.SelectedDate.Value != null) { stock.Date = dpDate.SelectedDate.Value; } if (tbStockPriceOpen.Text != null) { stock.StockPriceOpen = double.Parse(tbStockPriceOpen.Text); } stock.StockPriceHigh = double.Parse(tbStockPriceHigh.Text); stock.StockPriceLow = double.Parse(tbStockPriceLow.Text); stock.StockPriceClose = double.Parse(tbStockPriceClose.Text); stock.StockVolume = int.Parse(tbStockVolume.Text); stock.StockPriceAdjClose = double.Parse(tbStockPriceAdjClose.Text); sqlRepository.AddRecord(stock); }
/// <summary> /// Locate a file to update records in the SQL Database from CSV file. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private async void MiUpdateSQL_Click(object sender, RoutedEventArgs e) { //List<Stock> stockList = new List<Stock>(); OpenFileDialog fileDialog = new OpenFileDialog(); var result = fileDialog.ShowDialog(); stockList = await csvRepository.ReadCSV(fileDialog.FileName); sqlRepository.AddRecord(stockList); }