public void Edit(STATION station)
{
STATION tempStation = dBase.STATIONS.Where(x => x.Station_ID == station.Station_ID).First();
tempStation.Station_Description = station.Station_Description;
dBase.SaveChanges();
}
// seleciona os ônibus que passam na estação
public IEnumerable<StationBus> SelectStationBus(BUS bus, STATION station)
{
return from station_bus in dBase.STATION_BUSES
join stations in dBase.STATIONS on station_bus.Stations_Fk equals stations.Station_ID
join buses in dBase.BUS on station_bus.Buses_FK equals buses.Bus_ID
where stations.Station_ID == station.Station_ID
where buses.Bus_ID == bus.Bus_ID
select new StationBus { Station = stations, Bus = buses };
}
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 void addStation(Placemark placemark, SharpKml.Dom.Point point, DbGeography coordinates)
{
STATION station = new STATION();
station.Station_Description = placemark.Name;
station.Station_Coordinates = coordinates;
DBStation db = new DBStation(context);
db.Add(station);
}
public void Add(STATION station)
{
dBase.STATIONS.Add(station);
dBase.SaveChanges();
}
