public void addAirline(Airline_company.Airline_company airline)
{
string query = "INSERT INTO AIRLINE_COMPANY (name, country, address, telephone, email) VALUES ('" + airline.Name + "', '" + airline.Country + "', '" + airline.Address + "', '" + airline.Telephone + "', '" + airline.Email + "')";
if (this.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
this.CloseConnection();
}
}
internal void editAirline(Airline_company.Airline_company airline)
{
string query = "UPDATE airline_company SET name='" + airline.Name + "', country='" + airline.Country + "', address='" + airline.Address + "', telephone='" + airline.Telephone + "', email='" + airline.Email + "' WHERE id=" + airline.Id;
if (this.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = query;
cmd.Connection = connection;
cmd.ExecuteNonQuery();
this.CloseConnection();
}
}
public Airline_company.Airline_company getAirlineDataModification(int id)
{
string query = "SELECT * FROM AIRLINE_COMPANY WHERE id='" + id + "'";
Airline_company.Airline_company airline = null;
if (this.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader data = cmd.ExecuteReader();
if (data.HasRows)
{
data.Read();
airline = new Airline_company.Airline_company(data.GetString(1), data.GetString(2), data.GetString(3), data.GetString(4), data.GetString(5));
return(airline);
}
data.Close();
this.CloseConnection();
}
return(null);
}