public SqlModel()
{
connectionString = "Data Source=ANTHONY_PC\\SQLEXPRESS;Initial Catalog=Airport;Integrated Security=True";
session = new SqlConnection(connectionString);
vol = new Vol();
bagage = new Bagage();
}
public List<Bagage> GetBagagesFromVol(int idVol)
{
List<Bagage> list = new List<Bagage>();
try
{
session.Open();
SqlCommand command = new SqlCommand();
command.Connection = session;
command.CommandText = "SELECT * FROM BSM WHERE ID_VOL = " + idVol;
using (SqlDataReader dataReader = command.ExecuteReader())
{
if (dataReader.HasRows)
{
while (dataReader.Read())
{
Bagage bagageTmp = new Bagage();
bagageTmp.idBagage = (int)dataReader["ID_BSM"];
bagageTmp.codeIata = (string)dataReader["CODE_IATA"];
bagageTmp.dateCreation = (DateTime)dataReader["DAT_CRE"];
bagageTmp.itineraire = (string)dataReader["ITI"];
bagageTmp.compagnie = (string)dataReader["CIEE"];
bagageTmp.idVol = (int)dataReader["ID_VOL"];
list.Add(bagageTmp);
}
}
}
session.Close();
}
catch (Exception ex) { Console.WriteLine(ex); }
return list;
}
