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