/* Código referente ao cadastro dos Ônibus juntamente com suas Rotas.
É feito um join da rota do ônibus com as estações em que ele passa. Portanto, DEVE ser feito o
cadastro das estações de ônibus ANTES de adicionar a rota.
É realizado um insert nas tabelas BUSES, ROUTES e STATION_BUSES */
private bool addBusRoutes(KmlFile kml)
{
BUS bus = new BUS();
ROUTE route = new ROUTE();
DBRoute dbRoute = new DBRoute(context);
DBStation dbStation = new DBStation(context);
route.BUS = bus;
StringBuilder sb = new StringBuilder("LINESTRING (");
bus.Bus_Description = Methods.getBusDescription(kml);
bool hasStation = false;
foreach (var folder in kml.Root.Flatten().OfType<Folder>())
{
if (folder.Flatten().OfType<SharpKml.Dom.LineString>().Any())
{
DBStation_Bus dbStationBus = new DBStation_Bus(context);
foreach (var placemark in folder.Flatten().OfType<SharpKml.Dom.Placemark>())
{
parseLineString(placemark, sb); // grava a rota do onibus
hasStation = parsePoint(placemark, dbStationBus, dbStation, bus, route, hasStation); // grava as estacoes que o onibus passa
}
}
}
if (!hasStation)
{
string message = "The stations this bus pass by are not in the database. Please insert the stations first, then the bus route";
Methods.DisplayMessage(lblMessage, message, Color.Red);
throw new Exception(message);
}
route.Route_Coordinates = DbGeography.LineFromText(sb.Replace(',', ')', sb.Length - 1, 1).ToString(), 4326);
dbRoute.Add(route);
return true;
}
private void fillRecommendedBuses(DbGeography coordinatesReference, Teste_OnibusContext context, STATION selectedStation, int distance)
{
List<BUS> recommendedBus = new List<BUS>();
DBStation_Bus dbStationBus = new DBStation_Bus(context);
// seleciona os ônibus que passam na estação a menos de DISTANCE metros do ponto de referência
var stationsNear = dbStationBus.SelectStationsNear(distance, coordinatesReference);
foreach (var station in stationsNear)
{
// para cada ônibus que passa no ponto de refência, verifica se ele também passa na estação em que o usuário está
var busInStation = dbStationBus.SelectStationBus(station.BUS, selectedStation);
foreach (var item in busInStation)
{
if (!recommendedBus.Contains(item.Bus)) // se passar, recomenda ele para o usuário
recommendedBus.Add(item.Bus);
}
}
cboBuses.DataSource = recommendedBus.Select(x => x.Bus_Description).ToList();
}
private bool parsePoint(Placemark placemark, DBStation_Bus dbStationBus, DBStation dbStation, BUS bus, ROUTE route, bool hasStation)
{
foreach (var lineString in placemark.Flatten().OfType<SharpKml.Dom.Point>())
{
IList<STATION> stationsNear = dbStation.SelectStationsNear(50,
Methods.ConvertLatLonToDbGeography(lineString.Coordinate.Longitude, lineString.Coordinate.Latitude));
foreach (var station in stationsNear)
{
STATION_BUSES stationBus = new STATION_BUSES();
stationBus.STATION = station;
stationBus.BUS = bus;
dbStationBus.AddStation_Buses_Route(route, stationBus);
hasStation = true;
}
}
return hasStation;
}
