public async Task <ActionResult <IEnumerable <v2GetDTO> > > GetgeoMessages(double minLon, double maxLon, double minLat, double maxLat)
{
var geoDB = await _context.geoMessagesV2.Include(a => a.Message).Where(
o => (o.longitude <= maxLon && o.longitude >= minLon) && (o.latitude <= maxLat && o.latitude >= minLat))
.ToListAsync();
List <v2GetDTO> listGeoDTO = new List <v2GetDTO>();
foreach (var item in geoDB)
{
v2GetDTO geoDTO = new v2GetDTO()
{
latitude = item.latitude,
longitude = item.longitude,
Message = new v2MessageDTO()
{
Author = item.Message.Author,
Body = item.Message.Body,
Title = item.Message.Title
}
};
listGeoDTO.Add(geoDTO);
}
return(listGeoDTO);
}
public async Task <ActionResult <v2GetDTO> > GetgeoMessages(int id)
{
var geoDB = await _context.geoMessagesV2.Include(a => a.Message).FirstOrDefaultAsync(o => o.Id == id);
v2GetDTO geoDTO = new v2GetDTO()
{
latitude = geoDB.latitude,
longitude = geoDB.longitude,
Message = new v2MessageDTO()
{
Author = geoDB.Message.Author,
Body = geoDB.Message.Body,
Title = geoDB.Message.Title
}
};
return(geoDTO);
}
