// GET: CrimeHistories/Create public ActionResult Create() { var weapons = _db.Weapons.Select(w => new SelectListItem { Text = w.Type, Value = w.Id.ToString() }).ToList(); var crimeTypes = _db.CrimeTypes.Select(c => new SelectListItem() { Text = c.Name, Value = c.Id.ToString() }).ToList(); var cities = _db.Cities.Select(c => new SelectListItem { Text = c.Name, Value = c.Id.ToString(), }).ToList(); var officers = _db.Users.Select(o => new SelectListItem() { Text = o.UserName, Value = o.Id, }).ToList(); var crimeViewModel = new CrimeHistoryViewModel() { Weapons = weapons, CrimeTypes = crimeTypes, Cities = cities, Officers = officers, }; return(View(crimeViewModel)); }
public async Task <ActionResult> Create([Bind(Exclude = "Id")] CrimeHistory crimeHistory) { crimeHistory.FkOfficerId = crimeHistory.Officer.Id; crimeHistory.City = _db.Cities.Find(crimeHistory.City.Id); crimeHistory.CrimeType = _db.CrimeTypes.Find(crimeHistory.CrimeType.Id); crimeHistory.Officer = _db.Users.Find(crimeHistory.FkOfficerId); crimeHistory.Weapon = _db.Weapons.Find(crimeHistory.Weapon.Id); crimeHistory.FkWeaponId = crimeHistory.Weapon.Id; if (ModelState.IsValid) { _db.CrimeHistories.Add(crimeHistory); await _db.SaveChangesAsync(); return(RedirectToAction("Index")); } var weapons = _db.Weapons.Select(w => new SelectListItem { Text = w.Type, Value = w.Id.ToString() }).ToList(); var crimeTypes = _db.CrimeTypes.Select(c => new SelectListItem() { Text = c.Name, Value = c.Id.ToString() }).ToList(); var cities = _db.Cities.Select(c => new SelectListItem { Text = c.Name, Value = c.Id.ToString(), }).ToList(); var officers = _db.Users.Select(o => new SelectListItem() { Text = o.UserName, Value = o.Id, }).ToList(); var crimeViewModel = new CrimeHistoryViewModel() { Weapons = weapons, CrimeTypes = crimeTypes, Cities = cities, Officers = officers, }; return(View(crimeViewModel)); }