internal void addAirplane(Airplane.Airplane airplane)
{
string query = "INSERT INTO AIRPLANE (name, number_of_seats, airline_company_id) VALUES ('" + airplane.Name + "', '" + airplane.Number_of_seats + "', '" + airplane.Airline_company_id + "')";
if (this.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
this.CloseConnection();
}
}
internal void editAirplane(Airplane.Airplane airplane)
{
string query = "UPDATE airplane SET name='" + airplane.Name + "', number_of_seats='" + airplane.Number_of_seats + "', airline_company_id='" + airplane.Airline_company_id + "' WHERE id=" + airplane.Id;
if (this.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = query;
cmd.Connection = connection;
cmd.ExecuteNonQuery();
this.CloseConnection();
}
}
public Airplane.Airplane getAirplaneName(string name)
{
string query = "SELECT * FROM AIRPLANE WHERE name='" + name + "'";
Airplane.Airplane airplane = null;
if (this.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader data = cmd.ExecuteReader();
if (data.HasRows)
{
data.Read();
airplane = new Airplane.Airplane(data.GetInt32(0), data.GetString(1), data.GetInt32(2), data.GetInt32(3));
return(airplane);
}
data.Close();
this.CloseConnection();
}
return(null);
}
public List <Airplane.Airplane> getAllAirplanes()
{
List <Airplane.Airplane> listOfAirplanes = new List <Airplane.Airplane>();
string query = "SELECT * FROM airplane";
if (this.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader data = cmd.ExecuteReader();
Airplane.Airplane airplane;
if (data.HasRows)
{
while (data.Read())
{
airplane = new Airplane.Airplane(data.GetInt32(0), data.GetString(1), data.GetInt32(2), data.GetInt32(3));
listOfAirplanes.Add(airplane);
}
}
data.Close();
this.CloseConnection();
}
return(listOfAirplanes);
}
