public void AddRouteInStops(int stopId, int routeId) { RouteStopEntity routeStop = new RouteStopEntity { RouteId = routeId, StopId = stopId }; if (routeStop != GetRouteStop(stopId, routeId)) { _context.RoutesStops.Add(routeStop); _context.SaveChanges(); } }
public RouteStopEntity GetRouteStop(int stopId, int routeId) { RouteStopEntity routesStops = _context.RoutesStops .Where(x => x.RouteId == routeId && x.StopId == stopId) .Select(x => new RouteStopEntity { RouteId = routeId, StopId = stopId }).SingleOrDefault(); return(routesStops); }
public static RoutesStops ToDomainRouteStop(this RouteStopEntity routeStop) { if (routeStop != null) { return(new RoutesStops { StopId = routeStop.StopId, RouteId = routeStop.RouteId }); } else { return(null); } }
public void Delete(int id) { using var transaction = _context.Database.BeginTransaction(); try { RouteStopEntity routeStop = _context.RoutesStops.FirstOrDefault(item => item.StopId == id); if (routeStop != null) { _context.RoutesStops.Remove(routeStop); } StopEntity route = _context.Stops.FirstOrDefault(item => item.StopId == id); _context.Stops.Remove(route); _context.SaveChanges(); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); } }