public ActionResult Create([Bind(Include = "ID,CityName,VisitDate,Country,Fare")] CityModel cityModel) { if (ModelState.IsValid) { db.cities.Add(cityModel); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cityModel)); }
public void setUpDB() { var options = new DbContextOptionsBuilder <CityDBContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()) .Options; _ctx = new CityDBContext(options); _ctx.Budgets.Add(new Domain.Budget { BudgetID = 1, BudgetName = "TestBudget" }); _ctx.CityEvents.Add(new Domain.CityEvent { CityEventID = 1, CityEventName = "TestEventOneDisabilityAccess", DisabilityAccess = true }); _ctx.CityEvents.Add(new Domain.CityEvent { CityEventID = 2, CityEventName = "TestEventTwoChildFriendly", ChildFriendly = true }); _ctx.CityMuseums.Add(new Domain.CityMuseum { CityMuseumID = 1, CityMuseumName = "TestMuseumOneDisabilityAccess", DisabilityAccess = true }); _ctx.CityMuseums.Add(new Domain.CityMuseum { CityMuseumID = 2, CityMuseumName = "TestMuseumTwoChildFriendly", ChildFriendly = true }); _ctx.CityRestaurants.Add(new Domain.CityRestaurant { CityRestaurantID = 1, CityRestaurantName = "TestRestaurantOneChildFriendly", ChildFriendly = true }); _ctx.CityRestaurants.Add(new Domain.CityRestaurant { CityRestaurantID = 2, CityRestaurantName = "TestRestaurantTwoGlutenFree", GlutenFree = true }); _ctx.CitySites.Add(new CitySite { CitySiteID = 1, CitySiteName = "SiteOneChildFriendly", ChildFriendly = true }); _ctx.CitySites.Add(new CitySite { CitySiteID = 2, CitySiteName = "SiteTwoDisabilityAccess", DisabilityAccess = true }); _ctx.CityShops.Add(new CityShopping { CityShoppingID = 1, CityShoppingName = "ShopOneChildFriendly", ChildFriendly = true }); _ctx.CityShops.Add(new CityShopping { CityShoppingID = 2, CityShoppingName = "ShopTwoDisabilityAccess", DisabilityAccess = true }); _ctx.Cuisines.Add(new Cuisine { CuisineID = 1, CuisineName = "CuisineNameTestName" }); _ctx.SaveChanges(); }