/// <summary>Updates a stock entry</summary>
public string UpdateStockEntry(StockEntry stock)
{
string serverResponse;
SQLStockRepository stockRepo = new SQLStockRepository();
serverResponse = stockRepo.UpdateStockEntry(stock);
return(serverResponse);
}
public void UpdateStockEntryTest()
{
SQLStockRepository stockRepo = new SQLStockRepository();
StockEntry stockUpdate = new StockEntry();
stockUpdate.ID = 1;
stockUpdate.Exchange = "NYSE";
stockUpdate.Symbol = "AEA";
stockUpdate.Date = DateTime.Parse("13/1/2010");
stockUpdate.Volume = 205500;
stockUpdate.PriceOpen.Amount = 4.42m;
stockUpdate.PriceClose.Amount = 4.42m;
stockUpdate.PriceCloseAdjusted.Amount = 4.42m;
stockUpdate.PriceHigh.Amount = 4.42m;
stockUpdate.PriceLow.Amount = 4.42m;
string actual = stockRepo.UpdateStockEntry(stockUpdate);
Assert.AreEqual(1, actual);
}
/// <summary>Occurs when a value in the StockEntriesBound collection is changed</summary>
private void StockEntriesBound_ItemPropertyChanged(object sender, PropertyChangedEventArgs e)
{
try
{
LoggingService.Log("Collection property changed", "Log.txt");
StockEntry stockChanged = new StockEntry();
SQLStockRepository stockRepo = new SQLStockRepository();
string serverResponse;
uint stockID;
stockChanged = sender as StockEntry;
if (stockChanged.ID == 0)
{
//Insert stock
serverResponse = stockRepo.AddStockEntry(stockChanged);
if (uint.TryParse(serverResponse, out stockID))
{
stockChanged.ID = stockID;
serverResponse = "Stock entry inserted with ID of " + stockID;
}
}
else
{
//Update stock
serverResponse = stockRepo.UpdateStockEntry(stockChanged);
}
Messages.Items.Insert(0, serverResponse);
}
catch (Exception ex)
{
Messages.Items.Insert(0, ex.Message);
LoggingService.Log(ex, "Log.txt");
}
}