public override int CreateBagage(MyAirportAGM.Entities.BagageDefinition bag)
{
try
{
using (SqlConnection cnx = new SqlConnection(strcnx))
{
SqlCommand cmd = new SqlCommand(commandCreateBagage, cnx);
SqlCommand cmd2 = new SqlCommand(commandCreateBagageParticularite, cnx);
cmd.Parameters.AddWithValue("@codei", bag.CodeIata);
cmd.Parameters.AddWithValue("@compagnie", bag.Compagnie);
cmd.Parameters.AddWithValue("@ligne", bag.Ligne);
cmd.Parameters.AddWithValue("@itineraire", bag.Itineraire);
cmd.Parameters.AddWithValue("@jourExploitation", bag.JourExploitation);
cmd.Parameters.AddWithValue("@classe", bag.ClasseBagage);
if (bag.Continuation==true)
{
cmd.Parameters.AddWithValue("@continuation", 'Y');
}
else
{
cmd.Parameters.AddWithValue("@continuation", 'N');
}
cnx.Open();
cmd.ExecuteNonQuery();
if (bag.Rush == true)
{
cmd2.Parameters.AddWithValue("@codei", bag.CodeIata);
cmd2.Parameters.AddWithValue("@rush", 15);
cmd2.ExecuteNonQuery();
}
cnx.Close();
return 1;
}
}
catch
{
return 0;
}
//throw new NotImplementedException();
}
public int CreateBagage(MyAirportAGM.Entities.BagageDefinition bag)
{
return MyAirportAGM.Model.Factory.Model.CreateBagage(bag);
}
public override int CreateBagage(MyAirportAGM.Entities.BagageDefinition bag)
{
throw new NotImplementedException();
}
public abstract int CreateBagage(MyAirportAGM.Entities.BagageDefinition bag);
