public async Task <ActionResult <IEnumerable <DTOList.GetDTOV2> > > GetCommentV2(double minLon, double minLat, double maxLon, double maxLat) { var GetInfo = await _context.GeoComment2.Include(a => a.Message) .Where(o => (o.Longitude <= maxLon && o.Longitude >= minLon) && (o.Latitude <= maxLat && o.Latitude >= minLat)) .ToListAsync(); List <DTOList.GetDTOV2> DTOV2List = new List <DTOList.GetDTOV2>(); foreach (var item in GetInfo) { DTOList.GetDTOV2 Geo_DTO = new DTOList.GetDTOV2() { Message = new DTOList.MessageDTOV2() { Author = item.Message.Author, Body = item.Message.Body, Title = item.Message.Title }, Latitude = item.Latitude, Longitude = item.Longitude }; DTOV2List.Add(Geo_DTO); } return(DTOV2List); }
public async Task <ActionResult <DTOList.GetDTOV2> > GetCommentV2(int id) { var GetInfo = await _context.GeoComment2.Include(a => a.Message).FirstOrDefaultAsync(o => o.Id == id); DTOList.GetDTOV2 Geo_DTO1 = new DTOList.GetDTOV2() { Message = new DTOList.MessageDTOV2() { Author = GetInfo.Message.Author, Body = GetInfo.Message.Body, Title = GetInfo.Message.Title, }, Latitude = GetInfo.Latitude, Longitude = GetInfo.Longitude }; return(Geo_DTO1); }