public static BsonDocument BsonWatchlist(string login, string name) { User user = null; string collectionName = "watchlists"; StocksDB stocksDB = new StocksDB(); user = GetUserRecord(stocksDB, login); IMongoCollection <BsonDocument> collection = stocksDB.GetCollection <BsonDocument>(collectionName); var filter = Builders <BsonDocument> .Filter.Empty; var docs = collection.Find <BsonDocument>(filter).ToList(); foreach (var doc in docs) { if (doc.Contains("Name")) { System.Diagnostics.Debug.WriteLine(doc["Name"]); if (doc["Name"].AsString.ToUpper() == name.ToUpper()) { return(doc); } } } return(null); }
public static List <ASXListedCompany> FindCompaniesByCode(string match, int top = 0) { List <ASXListedCompany> companies = null; StocksDB stocksDB = new StocksDB(); string collectionName = "ASXListedCompanies"; var collection = stocksDB.GetCollection <ASXListedCompany>(collectionName); string regex = string.Concat("/", match, "/i"); var filter = Builders <ASXListedCompany> .Filter.Regex("Code", regex); try { companies = collection.Find <ASXListedCompany>(filter).Limit(top).ToList <ASXListedCompany>(); } catch (Exception e) { Console.Write(e); } return(companies); }