public IEnumerable <Crime> GetCrimes(SearchCrimesRequest request) { try { var client = new MongoClient(_connectionString); var db = client.GetDatabase(request.Db); if (request == null || String.IsNullOrWhiteSpace(request.SearchCollection)) { return(new List <Crime>()); } var collection = db.GetCollection <Crime>(request.SearchCollection); var data = collection.Find(_ => _.PrimaryType == request.PrimaryType && _.Latitude != null && _.Latitude != "" && _.Longitude != null && _.Year == request.Year && _.Longitude != "").ToList(); return(data); } catch (Exception ex) { Debug.WriteLine(ex.ToString()); return(new List <Crime>()); } }
public ActionResult <IEnumerable <Crime> > Get(string type, string year) { var request = new SearchCrimesRequest() { PrimaryType = type, Year = year, Db = _config.Value.Database }; IEnumerable <Crime> result = new CrimeDB(_config.Value.DatabaseServer).GetCrimes(request); return(Ok(result)); }