public List <CityEvent> GetAllCityEvents()
{
using (CityDBContext ctx = new CityDBContext())
{
return(ctx.CityEvents.ToList());
}
}
public string GetShoppingCategory(int id)
{
using (CityDBContext ctx = new CityDBContext())
{
return(ctx.CityShoppingCategories
.Where(a => a.CityShoppingCategoryID == id)
.Select(b => b.CityShoppingCategoryName).FirstOrDefault());
}
}
public string GetNeighbourhoodName(int id)
{
using (CityDBContext ctx = new CityDBContext())
{
return(ctx.Neighbourhoods
.Where(a => a.NeighbourhoodID == id)
.Select(b => b.NeighbourhoodName).FirstOrDefault());
}
}
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();
}
public List <CityEvent> GetAllCityEventsFiltered(bool?isDisabledFilter, bool?isChildFilter)
{
using (CityDBContext ctx = new CityDBContext())
{
IEnumerable <CityEvent> events = new List <CityEvent>();
events = ctx.CityEvents;
if (isDisabledFilter.HasValue == true)
{
events = events.Where(b => b.DisabilityAccess == isDisabledFilter);
}
if (isChildFilter.HasValue == true)
{
events = events.Where(c => c.ChildFriendly == isChildFilter);
}
return(events.ToList());
}
}
public BudgetRepository(CityDBContext ctx)
{
_ctx = ctx;
}
public CityMuseumCategoryRepository(CityDBContext _ctx)
{
ctx = _ctx;
}
public CityShoppingRepository(CityDBContext _ctx)
{
ctx = _ctx;
}
public CitySiteRepository(CityDBContext _ctx)
{
ctx = _ctx;
}
public CuisineRepository(CityDBContext ctx)
{
_ctx = ctx;
}
public CityTransportOptionRepository(CityDBContext _ctx)
{
ctx = _ctx;
}
public CityRestaurantRepository(CityDBContext _ctx)
{
ctx = _ctx;
}
public CityEventRepository(CityDBContext _ctx)
{
ctx = _ctx;
}
