public Security CusipLookup(string cusip)
{
Security security = null;
SecurityMap securityMap = _db.SecurityMaps.FirstOrDefault(s => s.Cusip == cusip);
if (securityMap != null)
{
security = _db.Securities.FirstOrDefault(s => s.SecurityId == securityMap.SecurityId);
}
else
{
UnknownShare unknownShare = _db.UnknownShares.FirstOrDefault(s => s.Cusip == cusip);
if (unknownShare == null)
{
security = StockFinder.CusipLookup(cusip);
}
}
return(security);
}
public Security NameLookup(string name)
{
name = NormaliseSecurityName(name);
SecurityMap securityMap = _db.SecurityMaps.FirstOrDefault(s => s.Name == name);
Security security = null;
if (securityMap != null)
{
security = _db.Securities.FirstOrDefault(s => s.SecurityId == securityMap.SecurityId);
}
else
{
UnknownShare unknownShare = _db.UnknownShares.FirstOrDefault(s => s.NameOfIssuer == name);
if (unknownShare == null)
{
security = StockFinder.NameLookup(name);
}
}
return(security);
}
