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