Пример #1
0
        public async Task <IActionResult> Create(
            [Bind("FkItemidItem,FkPointidPoint,Quantity")] ItemPointMap itemPointMap)
        {
            if (!ModelState.IsValid)
            {
                AddSelectListToViewData();
                return(View(itemPointMap));
            }
            try
            {
                Points point = new Points();
                point.Latitude         = (decimal)(double)TempData["lat"];
                point.Longitude        = (decimal)(double)TempData["lng"];
                point.FkUseridUser     = HttpContext.Session.GetInt32("userId") ?? -1;
                point.FkRegionidRegion = HttpContext.Session.GetInt32("regionId") ?? -1;
                point.Date             = DateTime.Now;
                int pointId = _context.Add(point).Entity.IdPoint;
                await _context.SaveChangesAsync();

                itemPointMap.FkPointidPoint           = pointId;
                itemPointMap.FkPointidPointNavigation = point;
                _context.Add(itemPointMap);
                await _context.SaveChangesAsync();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
                throw;
            }
            return(RedirectToAction(nameof(Index), "Home"));
        }
Пример #2
0
        // GET: Home
        public ActionResult Index()
        {
            MockUser();
            string markers = "[";

            foreach (Points point in _context.Points
                     .Include(i => i.FkUseridUserNavigation)
                     .Include(i => i.ItemPointMap)
                     .ThenInclude(map => map.FkItemidItemNavigation).ToList())
            {
                markers += "{";
                ItemPointMap itemPointMap = point.ItemPointMap.First(i => i.FkPointidPoint == point.IdPoint);
                Users        user         = point.FkUseridUserNavigation;
                string       itemName     = itemPointMap.FkItemidItemNavigation.Name;
                int          itemQuantity = itemPointMap.Quantity ?? default(int);
                markers += string.Format("'title': '{0}',", itemName);
                markers += string.Format("'lat': '{0}',", point.Latitude);
                markers += string.Format("'lng': '{0}',", point.Longitude);
                string description = "<h3>" + itemName + "</h3>";
                description += "<p><b>Quantity:</b> " + itemQuantity + "</p>";
                description += "<p><b>Date:</b> " + String.Format("{0:dd MMM yyyy}", point.Date) + "</p>";
                description += "<p><b>Created by:</b> " + user.Nickname + "</p>";
                markers     += string.Format("'description': '{0}'", description);
                markers     += "},";
            }
            markers        += "];";
            ViewBag.Markers = markers;
            return(View(_context.Regions.First()));
        }