public void Add_Route() { string routeName = "Test Route to Add"; // Add to database using (ThamesClipperContext ctx = new ThamesClipperContext()) { RouteRepository routeRepository = new RouteRepository(ctx); routeRepository.Add(new Route { Name = routeName, TimeTable = new TimeTable { Name = "TimeTable to add" } }); routeRepository.SaveChanges(); } // Check that it is there using (ThamesClipperContext ctx = new ThamesClipperContext()) { List<Route> routes = ctx.Routes.Where(route => route.Name == routeName).ToList(); Assert.AreEqual(1, routes.Count()); } }
public void Delete_Route_By_Route() { string routeName = "Test Route to Delete"; // Add to database using (ThamesClipperContext ctx = new ThamesClipperContext()) { RouteRepository routeRepository = new RouteRepository(ctx); Route route = new Route { Name = routeName, TimeTable = new TimeTable { Name = "TimeTable" } }; route.Schedules = new List<Schedule>() { new Schedule { Route = route, Pier = new Pier { Name = "Pier" }, Time = new TimeSpan(1, 0, 0) } }; routeRepository.Add(route); routeRepository.SaveChanges(); } // Find and delete it using (ThamesClipperContext ctx = new ThamesClipperContext()) { List<Route> routes = ctx.Routes.Where(route => route.Name == routeName).ToList(); Assert.AreEqual(1, routes.Count()); RouteRepository routeRepository = new RouteRepository(ctx); routeRepository.Delete(routes[0]); routeRepository.SaveChanges(); } // Check that nothing is there using (ThamesClipperContext ctx = new ThamesClipperContext()) { List<Route> routes = ctx.Routes.Where(route => route.Name == routeName).ToList(); Assert.AreEqual(0, routes.Count()); } }
public void Update_Route() { string routeName = "Test Route to Update"; string routeNameUpdated = "Test Route Updated"; // Add to database using (ThamesClipperContext ctx = new ThamesClipperContext()) { RouteRepository routeRepository = new RouteRepository(ctx); routeRepository.Add(new Route { Name = routeName, TimeTable = new TimeTable { Name = "TimeTable" } }); routeRepository.SaveChanges(); } // Find and update it using (ThamesClipperContext ctx = new ThamesClipperContext()) { List<Route> routes = ctx.Routes.Where(route => route.Name == routeName).ToList(); Assert.AreEqual(1, routes.Count()); RouteRepository routeRepository = new RouteRepository(ctx); routes[0].Name = routeNameUpdated; routeRepository.Update(routes[0]); routeRepository.SaveChanges(); } // Check that the new name is there using (ThamesClipperContext ctx = new ThamesClipperContext()) { List<Route> routes = ctx.Routes.Where(route => route.Name == routeNameUpdated).ToList(); Assert.AreEqual(1, routes.Count()); } }