private void ShowArriveTime_Click(object sender, RoutedEventArgs e)
{
ShowArriveTime();
using (AppDbContext db = new AppDbContext())
{
Station station = (Station)ComboBoxStation.SelectedItem;
Station currentStation = db.Stations.Find(station.Id);
AutobusStation autst = db.AutobusStations.Where(p => p.Station.Id == currentStation.Id).First();
Arrive arrive = db.Arrives.Where(p => p.AutobusStationId == autst.Id).First();
MessageBox.Show(arrive.Time);
}
}
private void BusInit()
{
try
{
using (AppDbContext db = new AppDbContext())
{
Autobus bus = new Autobus()
{
Number = 1
};
Station station = new Station()
{
Name = "Вокзал",
};
Station station2 = new Station()
{
Name = "Аранская",
};
Station station3 = new Station()
{
Name = "Пролетарская",
};
Station station4 = new Station()
{
Name = "Мясниковича",
};
Station station5 = new Station()
{
Name = "Автозаводская",
};
bus.Stations.Add(station);
bus.Stations.Add(station2);
bus.Stations.Add(station3);
bus.Stations.Add(station4);
bus.Stations.Add(station5);
Route route = new Route()
{
Name = "Вокзал - ДС Автозаводская"
};
route.Autobuses.Add(bus);
bus.Route = route; //у автобуса есть машрут
AutobusStation autobusStation = new AutobusStation()
{
Autobus = bus,
Station = station
};
AutobusStation autobusStation2 = new AutobusStation()
{
Autobus = bus,
Station = station2
};
AutobusStation autobusStation3 = new AutobusStation()
{
Autobus = bus,
Station = station3
};
AutobusStation autobusStation4 = new AutobusStation()
{
Autobus = bus,
Station = station4
};
AutobusStation autobusStation5 = new AutobusStation()
{
Autobus = bus,
Station = station5
};
Arrive arrive = new Arrive()
{
AutobusStation = autobusStation,
Time = "9:37 9:55 10:21 11:37 13:12"
};
Arrive arrive2 = new Arrive()
{
AutobusStation = autobusStation2,
Time = "9:40 9:57 10:25 11:42 13:17"
};
Arrive arrive3 = new Arrive()
{
AutobusStation = autobusStation3,
Time = "9:45 10:00 10:30 11:47 13:20"
};
Arrive arrive4 = new Arrive()
{
AutobusStation = autobusStation4,
Time = "9:48 10:05 10:35 11:51 13:27"
};
Arrive arrive5 = new Arrive()
{
AutobusStation = autobusStation5,
Time = "9:55 10:10 10:40 11:56 13:33"
};
db.Routes.Add(route);
db.Arrives.Add(arrive);
db.Arrives.Add(arrive2);
db.Arrives.Add(arrive3);
db.Arrives.Add(arrive4);
db.Arrives.Add(arrive5);
db.SaveChanges();
}
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult validationError in ex.EntityValidationErrors)
{
MessageBox.Show("Object: " + validationError.Entry.Entity.ToString());
foreach (DbValidationError err in validationError.ValidationErrors)
{
MessageBox.Show(err.ErrorMessage + " ");
}
}
}
}
