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