/// <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);
}
