/// <summary>
/// Get stocks by words start with the name and exchange Id.
/// </summary>
/// <param name="name">The words start with name</param>
/// <param name="exchangeId">exchange Id
/// possible value:
/// 1.ASX
/// 2.NYSE
/// 3.NASDAQ
/// 4.AMSE
/// </param>
/// <param name="count">set the count of the items</param>
/// <returns></returns>
public static IList <Stock> GetStockSymbols(string name, int exchangeId, int count)
{
using (WijMarket.Models.EntityClass.StockContext context = new EntityClass.StockContext())
{
var caseInfo = from info in context.StockEntitys
where (info.StockCode.StartsWith(name) || info.StockName.Contains(name)) &&
info.ExchangeId == exchangeId
orderby info.StockCode
select new Stock
{
Name = info.StockName,
Symbol = info.StockCode
};
return(caseInfo.Take(count).ToList <Stock>());
}
}
/// <summary>
/// Get stocks by words start with the name and exchange Id.
/// </summary>
/// <param name="name">The words start with name</param>
/// <param name="exchangeId">exchange Id
/// possible value:
/// 1.ASX
/// 2.NYSE
/// 3.NASDAQ
/// 4.AMSE
/// </param>
/// <param name="count">set the count of the items</param>
/// <returns></returns>
public static IList<Stock> GetStockSymbols(string name, int exchangeId, int count)
{
using (WijMarket.Models.EntityClass.StockContext context = new EntityClass.StockContext())
{
var caseInfo = from info in context.StockEntitys
where (info.StockCode.StartsWith(name) || info.StockName.Contains(name))
&& info.ExchangeId == exchangeId
orderby info.StockCode
select new Stock
{
Name = info.StockName,
Symbol = info.StockCode
};
return caseInfo.Take(count).ToList<Stock>();
}
}