// Update all trade and iterate over them.
public static long ViewAllAfterUpdate(Event xepEvent)
{
// Create and execute query using EventQuery
String sqlQuery = "SELECT * FROM myApp.Trade WHERE purchaseprice > ? ORDER BY stockname, purchaseDate";
EventQuery <Trade> xepQuery = xepEvent.CreateQuery <Trade>(sqlQuery);
xepQuery.AddParameter("0"); // find stocks purchased > $0/share (all)
long startTime = DateTime.Now.Ticks;
xepQuery.Execute();
// Iterate through and write names of stocks using EventQueryIterator
Trade trade = xepQuery.GetNext();
while (trade != null)
{
trade.stockName = "NYSE-" + trade.stockName;
xepQuery.UpdateCurrent(trade);
Console.WriteLine(trade.stockName + "\t" + trade.purchasePrice + "\t" + trade.purchaseDate);
trade = xepQuery.GetNext();
}
long totalTime = DateTime.Now.Ticks - startTime;
xepQuery.Close();
return(totalTime / TimeSpan.TicksPerMillisecond);
}
