public AdminWindow() { InitializeComponent(); db = new FlightManagmentContext(); Refreshh(); var routesid = ( from pass in db.RoutePass select pass).ToList(); foreach (var elem in routesid) { fk.Items.Add(elem.PK_Route); depPoint.Items.Add(elem.DeparturePoint); depDate.Items.Add(elem.DepartureDate); arrPoint.Items.Add(elem.ArrivalPoint); arrDate.Items.Add(elem.ArrivalDate); fk_edit.Items.Add(elem.PK_Route); } var lastindex = from index in db.Flights select index; pk.Text = (lastindex.ToList().Last().PK_Flight + 1).ToString(); }
public MainWindow() { InitializeComponent(); db = new FlightManagmentContext(); _listBoxItemFlight = new ObservableCollection <FlightTable>( (from flights in db.Flights join Routes in db.RoutePass on flights.FK_Route equals Routes.PK_Route select new FlightTable { PK_Flight = flights.PK_Flight, FK_Route = flights.FK_Route, SeatCount = flights.SeatCount, DeparturePoint = Routes.DeparturePoint, ArrivalPoint = Routes.ArrivalPoint, DepartureDate = Routes.DepartureDate, ArrivalDate = Routes.ArrivalDate })); DB.ItemsSource = _listBoxItemFlight; DB.Items.Refresh(); }