public async Task <RouteUpdateTransactionResponse> Handle(RouteUpdateTransactionRequest request, CancellationToken cancellationToken) { var Route = await RouteRepository.Update( Conversions.FromModelToDTO(request.Route) , cancellationToken); RouteUpdateTransactionResponse response = new RouteUpdateTransactionResponse(); response.Route = Conversions.FromDTOToModel(Route); return(response); }
public ActionResult Edit(Route model) { var _context = new ApplicationDbContext(); model.SinkNodes = _context.SinkNodes.ToList(); if (model.SinkNodes.Count() == 0) { model.SinkNodes = new List <SinkNode>(); } Repo.Update(model); return(View()); }
public bool Update(string primarykey, string columToModify, object newValue) { try { dbConnection.Open(); return(_routeRepository.Update(primarykey, columToModify, newValue)); } catch (System.Exception) { return(false); } finally { dbConnection.Close(); } }
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()); } }