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