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")); }
// 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())); }