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));
}
