/// <summary>
/// Converts from service data contract model class to a UI Model class for quick HTML display in ASPX pages.
/// </summary>
private Trade.StockTraderWebApplicationModelClasses.MarketSummaryDataUI convertMarketSummaryDataToUI(MarketSummaryDataModelWS data)
{
List<QuoteDataUI> quoteGainers = new List<QuoteDataUI>();
List<QuoteDataUI> quoteLosers = new List<QuoteDataUI>();
for (int i = 0; i < data.topGainers.Count; i++)
{
QuoteDataModel quote = (QuoteDataModel)data.topGainers[i];
quoteGainers.Add((convertQuoteToUI(quote)));
}
for (int i = 0; i < data.topLosers.Count; i++)
{
QuoteDataModel quote = (QuoteDataModel)data.topLosers[i];
quoteLosers.Add((convertQuoteToUI(quote)));
}
return new MarketSummaryDataUI(data.TSIA, data.openTSIA, data.volume, quoteGainers, quoteLosers, data.summaryDate);
}
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;
}
}