//Select statement
public static void insertFlight(Modele.ORM.plane APlane, string longdatetimeD, string longdatetimeA)
{
int seat = APlane.Type.NbSeatingPlaces;
int idPlane = APlane.IdPlane;
//Open connection
ConnexionWorkBench connection = new ConnexionWorkBench();
if (connection.OpenConnection() == true)
{
string query = "INSERT INTO flight ( id_Plane, Available_Places, Hours_Departure,Hours_Arrival)" +
" VALUES( @idPlane,@seat, @HoursD,@HoursA)";
//Create Command
MySqlCommand cmd = new MySqlCommand(query, connection.GetConnection());
//shield injection
cmd.Parameters.AddWithValue("@seat", seat);
cmd.Parameters.AddWithValue("@idPlane", idPlane);
cmd.Parameters.AddWithValue("@HoursD", longdatetimeD);
cmd.Parameters.AddWithValue("@HoursA", longdatetimeA);
//Execute the command
cmd.ExecuteNonQuery();
//close Connection
connection.CloseConnection();
}
else
{
MessageBox.Show("Connexion failed !");
}
}
public flight(int thisId, Modele.ORM.plane thisPlane, int thisAvailablePlaces, DateTime thisHoursDeparture, DateTime thisHoursArrival)
{
Id = thisId;
Plane = thisPlane;
AvailablePlaces = thisAvailablePlaces;
HoursDeparture = thisHoursDeparture;
HoursArrival = thisHoursArrival;
}
//Select statement
public static ObservableCollection <Modele.ORM.plane> getPlanes()
{
ObservableCollection <Modele.ORM.plane> Planes = new ObservableCollection <Modele.ORM.plane>();
string query = "SELECT * FROM plane;";
//Open connection
ConnexionWorkBench connection = new ConnexionWorkBench();
if (connection.OpenConnection() == true)
{
//Create Command
MySqlCommand cmd = new MySqlCommand(query, connection.GetConnection());
//Create a data reader and Execute the command
MySqlDataReader dataReader = cmd.ExecuteReader();
//Read the data and store them in the list
while (dataReader.Read())
{
int idplane = dataReader.GetInt32(0);
Modele.ORM.type Type = Modele.ORM.type.GetType(dataReader.GetInt32(1));
Modele.ORM.crew Crew;
if (dataReader[2] != DBNull.Value)
{
Crew = Modele.ORM.crew.GetCrew(dataReader.GetInt32(2));
}
else
{
Crew = null;
}
Modele.ORM.warehouse Warehouse = Modele.ORM.warehouse.GetWarehouse(dataReader.GetInt32(3));
bool status = dataReader.GetBoolean(4);
Modele.ORM.plane Plane = new Modele.ORM.plane(idplane, Type, Crew, Warehouse, status);
Planes.Add(Plane);
}
//close Data Reader
dataReader.Close();
//close Connection
connection.CloseConnection();
//return list to be displayed
return(Planes);
}
else
{
return(Planes);
}
}
private void InsertFlightClick(object sender, RoutedEventArgs e)
{
string longdatetimeD = DateD.SelectedDate.Value.ToString("yyyy/MM/dd") + " " + HourD.SelectedTime.Value.ToShortTimeString();
string longdatetimeA = DateA.SelectedDate.Value.ToString("yyyy/MM/dd") + " " + HourA.SelectedTime.Value.ToShortTimeString();
Modele.ORM.plane APlane = Plane.SelectedItem as Modele.ORM.plane;
//test récupération valeur
//MessageBox.Show("L'avion : "+APlane.IdPlane.ToString()+" a une date de départ = " + longdatetimeA + " Date arrivé = "+ longdatetimeA);
vue.insertFlight(APlane, longdatetimeD, longdatetimeA);
gridFlights.ItemsSource = vue.getFlights();
this.ModalAddFlight.Visibility = Visibility.Collapsed;
}
//Select statement
public static ObservableCollection <Modele.ORM.flight> getFlights()
{
ObservableCollection <Modele.ORM.flight> Flights = new ObservableCollection <Modele.ORM.flight>();
string query = "SELECT * FROM flight;";
//Open connection
ConnexionWorkBench connection = new ConnexionWorkBench();
if (connection.OpenConnection() == true)
{
//Create Command
MySqlCommand cmd = new MySqlCommand(query, connection.GetConnection());
//Create a data reader and Execute the command
MySqlDataReader dataReader = cmd.ExecuteReader();
//Read the data and store them in the list
while (dataReader.Read())
{
int idvol = dataReader.GetInt32(0);
Modele.ORM.plane Plane = Modele.ORM.plane.getPlane(dataReader.GetInt32(1));
int freePlaces = dataReader.GetInt32(2);
DateTime hoursDeparture = dataReader.GetDateTime(3);
DateTime hoursArrival = dataReader.GetDateTime(3);
Modele.ORM.flight Flight = new Modele.ORM.flight(idvol, Plane, freePlaces, hoursDeparture, hoursArrival);
Flights.Add(Flight);
}
//close Data Reader
dataReader.Close();
//close Connection
connection.CloseConnection();
//return list to be displayed
return(Flights);
}
else
{
return(Flights);
}
}
//public void deletePlane(int idPlane)
//{
// Modele.ORM.plane.deletePlane(idPlane);
//}
public void insertFlight(Modele.ORM.plane APlane, string longdatetimeD, string longdatetimeA)
{
Modele.ORM.flight.insertFlight(APlane, longdatetimeD, longdatetimeA);
}
public static void insertFlight(Modele.ORM.plane APlane, string longdatetimeD, string longdatetimeA)
{
Modele.DAL.Request.FlightRequest.insertFlight(APlane, longdatetimeD, longdatetimeA);
}