Exemple #1
0
        public void LoadSeats()
        {
            SeatAvailable.Clear();
            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = CONNECTION_STRING;
                conn.Open();

                SqlCommand command = conn.CreateCommand();
                command.CommandText = @"SELECT * FROM Seat";

                SqlDataAdapter daSeats = new SqlDataAdapter();
                DataSet        dsSeats = new DataSet();

                daSeats.SelectCommand = command;
                daSeats.Fill(dsSeats, "Seats");

                foreach (DataRow row in dsSeats.Tables["Seats"].Rows)
                {
                    Seat seat = new Seat();

                    seat.Id         = (int)row["Id"];
                    seat.SeatLabel  = (string)row["SeatLabel"];
                    seat.SeatClass  = (EClass)row["SeatClass"];
                    seat.SeatState  = (bool)row["SeatState"];
                    seat.AirplaneId = (string)row["AirplaneId"];
                    seat.Active     = (bool)row["Active"];

                    SeatAvailable.Add(seat);
                }
            }
        }
Exemple #2
0
        public ObservableCollection <Seat> SeatsEconomy(int rowNum, int colNum, int input)
        {
            ObservableCollection <Seat> seatE = new ObservableCollection <Seat>();

            for (int i = 0; i < SeatLabels(rowNum, colNum).Count; i++)
            {
                if (i >= input)
                {
                    Seat seatEconomy = new Seat();
                    seatEconomy.SeatLabel = SeatLabels(rowNum, colNum)[i];
                    seatEconomy.SeatClass = EClass.ECONOMY;
                    seatEconomy.SeatState = true;
                    seatEconomy.Active    = false;
                    seatE.Add(seatEconomy);
                    SeatAvailable.Add(seatEconomy);
                }
            }
            return(seatE);
        }
Exemple #3
0
        public ObservableCollection <Seat> SeatsBusiness(int rowNum, int colNum, int input)
        {
            ObservableCollection <Seat> seatB = new ObservableCollection <Seat>();

            for (int i = 0; i < SeatLabels(rowNum, colNum).Count; i++)
            {
                if (i < input)
                {
                    Seat seat = new Seat();
                    seat.SeatLabel = SeatLabels(rowNum, colNum)[i];
                    seat.SeatClass = EClass.BUSINESS;
                    seat.SeatState = true;
                    seat.Active    = false;
                    seatB.Add(seat);
                    SeatAvailable.Add(seat);
                }
            }
            return(seatB);
        }