Example #1
0
        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);
        }
Example #2
0
        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);
        }