public static void AddEdgesToDatabase(IEnumerable <MTR.BusinessLogic.Common.POCO.StopRouteStopEdge> edgeList)
{
using (var db = new EF_GtfsDbContext())
{
foreach (var edge in edgeList)
{
var source = db.Stops.First(s => s.Id == edge.StopId);
var destination = db.Stops.First(s => s.Id == edge.nextStopId);
var route = db.Routes.First(r => r.Id == edge.RouteId);
db.StopEdges.Add(new EF_StopRouteStopEdge {
SourceStop = source,
ViaRoute = route,
DestinationStop = destination
});
}
db.SaveChanges();
}
}
public static void AddEdgesToDatabase(IEnumerable<MTR.BusinessLogic.Common.POCO.StopRouteStopEdge> edgeList)
{
using (var db = new EF_GtfsDbContext())
{
foreach (var edge in edgeList)
{
var source = db.Stops.First(s => s.Id == edge.StopId);
var destination = db.Stops.First(s => s.Id == edge.nextStopId);
var route = db.Routes.First(r => r.Id == edge.RouteId);
db.StopEdges.Add(new EF_StopRouteStopEdge {
SourceStop = source,
ViaRoute = route,
DestinationStop = destination
});
}
db.SaveChanges();
}
}
public static void UpdateStopGroups(IEnumerable <MTR.BusinessLogic.Common.POCO.StopGroup> groups)
{
using (var db = new EF_GtfsDbContext())
{
var allStops = db.Stops.ToList();
int i = 0;
foreach (var sg in groups)
{
i++;
foreach (var stop in sg.GetStops())
{
var subject = allStops.First(db_stop => db_stop.Id == stop.DbId);
subject.GroupId = i;
Console.WriteLine("stop.DbId = " + stop.DbId + " | group = " + i + " --> subject.GroupId = " + subject.GroupId);
}
}
db.SaveChanges();
}
}
public static void UpdateStopGroups(IEnumerable<MTR.BusinessLogic.Common.POCO.StopGroup> groups)
{
using (var db = new EF_GtfsDbContext())
{
var allStops = db.Stops.ToList();
int i = 0;
foreach (var sg in groups)
{
i++;
foreach (var stop in sg.GetStops()) {
var subject = allStops.First(db_stop => db_stop.Id == stop.DbId);
subject.GroupId = i;
Console.WriteLine("stop.DbId = " + stop.DbId + " | group = " + i + " --> subject.GroupId = " + subject.GroupId);
}
}
db.SaveChanges();
}
}