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