public plane(int idThisPlane, Modele.ORM.type thisType, Modele.ORM.crew thisCrew, Modele.ORM.warehouse thisWarehouse, bool thisStatus)
{
IdPlane = idThisPlane;
Type = thisType;
Crew = thisCrew;
Warehouse = thisWarehouse;
Status = thisStatus;
}
//Select statement
public static Modele.ORM.crew getCrew(int idCrew)
{
Modele.ORM.crew Crew = null;
string query = "SELECT * FROM type where id=@crew;";
//Open connection
ConnexionWorkBench connection = new ConnexionWorkBench();
if (connection.OpenConnection() == true)
{
//Create Command
MySqlCommand cmd = new MySqlCommand(query, connection.GetConnection());
//shield sql injection
cmd.Parameters.AddWithValue("@crew", idCrew);
//Create a data reader and Execute the command
MySqlDataReader dataReader = cmd.ExecuteReader();
//Read the data and store them in the list
while (dataReader.Read())
{
Crew = new Modele.ORM.crew(
dataReader.GetInt32(0),
dataReader.GetInt32(1)
);
}
//close Data Reader
dataReader.Close();
//close Connection
connection.CloseConnection();
//return list to be displayed
return(Crew);
}
else
{
return(Crew);
}
}
