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