public void updateStockPriceVolume(double quantity, QuoteDataModel quote)
{
//See note above: want to use existing connection
MarketSummary marketSummaryDal = new MarketSummary(_internalConnection, _internalADOTransaction);
marketSummaryDal.updateStockPriceVolume(quantity, quote);
return;
}
/// <summary>
/// Converts from service data contract model class to a UI Model class for quick HTML display in ASPX pages.
/// </summary>
private QuoteDataUI convertQuoteToUI(QuoteDataModel quote)
{
if (quote != null)
return new QuoteDataUI(quote.symbol, quote.companyName, quote.volume, quote.price, quote.open, quote.low, quote.high, quote.change);
else return null;
}
public QuoteDataModel getQuoteForUpdate(string symbol)
{
try
{
SqlParameter parm1 = new SqlParameter(PARM_SYMBOL, SqlDbType.VarChar, 10);
parm1.Value = symbol;
SqlDataReader rdr = SQLHelper.ExecuteReaderSingleRowSingleParm(_internalConnection, _internalADOTransaction, CommandType.Text, SQL_SELECT_QUOTE, parm1);
QuoteDataModel quote = null;
if (rdr.HasRows)
{
rdr.Read();
quote = new QuoteDataModel(rdr.GetString(0), rdr.GetString(1), rdr.GetDouble(2), rdr.GetDecimal(3), rdr.GetDecimal(4), rdr.GetDecimal(5), rdr.GetDecimal(6), rdr.GetDouble(7));
}
rdr.Close();
return quote;
}
catch
{
throw;
}
}
public MarketSummaryDataModelWS getMarketSummaryData()
{
try
{
decimal TSIA = (decimal)SQLHelper.ExecuteScalarNoParm(_internalConnection,_internalADOTransaction, CommandType.Text,SQL_SELECT_MARKETSUMMARY_TSIA);
decimal openTSIA = (decimal)SQLHelper.ExecuteScalarNoParm(_internalConnection,_internalADOTransaction,CommandType.Text,SQL_SELECT_MARKETSUMMARY_OPENTSIA);
double totalVolume = (double)SQLHelper.ExecuteScalarNoParm(_internalConnection,_internalADOTransaction,CommandType.Text,SQL_SELECT_MARKETSUMMARY_VOLUME);
SqlDataReader rdr = SQLHelper.ExecuteReaderNoParm(_internalConnection,_internalADOTransaction,CommandType.Text,SQL_SELECT_MARKETSUMMARY_GAINERS);
List<QuoteDataModel> topgainers = new List<QuoteDataModel>();
List<QuoteDataModel> toplosers = new List<QuoteDataModel>();
int i = 0;
while (rdr.Read() && i++<5)
{
QuoteDataModel quote = new QuoteDataModel(rdr.GetString(0), rdr.GetString(1), rdr.GetDouble(2), rdr.GetDecimal(3), rdr.GetDecimal(4), rdr.GetDecimal(5), rdr.GetDecimal(6), rdr.GetDouble(7));
topgainers.Add(quote);
}
rdr.Close();
rdr = SQLHelper.ExecuteReaderNoParm(_internalConnection,_internalADOTransaction,CommandType.Text,SQL_SELECT_MARKETSUMMARY_LOSERS);
i = 0;
while (rdr.Read() && i++ < 5)
{
QuoteDataModel quote = new QuoteDataModel(rdr.GetString(0), rdr.GetString(1), rdr.GetDouble(2), rdr.GetDecimal(3), rdr.GetDecimal(4), rdr.GetDecimal(5), rdr.GetDecimal(6), rdr.GetDouble(7));
toplosers.Add(quote);
}
rdr.Close();
MarketSummaryDataModelWS marketSummaryData = new MarketSummaryDataModelWS(TSIA, openTSIA, totalVolume, topgainers, toplosers);
return marketSummaryData;
}
catch
{
throw;
}
}
public void updateStockPriceVolume(double Quantity, QuoteDataModel quote)
{
try
{
SqlParameter[] updatestockpriceparm = GetUpdateStockPriceVolumeParameters();
decimal priceChangeFactor = StockTraderUtility.getRandomPriceChangeFactor(quote.price);
decimal newprice = quote.price * priceChangeFactor;
if (newprice < quote.low)
quote.low = newprice;
if (newprice > quote.high)
quote.high = newprice;
updatestockpriceparm[0].Value = (decimal)newprice;
updatestockpriceparm[1].Value = (float)Quantity;
updatestockpriceparm[2].Value = quote.symbol;
updatestockpriceparm[3].Value = quote.low;
updatestockpriceparm[4].Value = quote.high;
SQLHelper.ExecuteNonQuery(_internalConnection, _internalADOTransaction, CommandType.Text, SQL_UPDATE_STOCKPRICEVOLUME, updatestockpriceparm);
return;
}
catch
{
throw;
}
}