public void AddAirlineService(AirlineService newAirlineService)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO airline_services_flights (airline_services_id, flights_id) VALUES (@AirlineServiceId, @FlightId);", conn);
SqlParameter airlineServiceIdParameter = new SqlParameter();
airlineServiceIdParameter.ParameterName = "@AirlineServiceId";
airlineServiceIdParameter.Value = newAirlineService.GetId();
cmd.Parameters.Add(airlineServiceIdParameter);
SqlParameter flightIdParameter = new SqlParameter();
flightIdParameter.ParameterName = "@FlightId";
flightIdParameter.Value = this.GetId();
cmd.Parameters.Add(flightIdParameter);
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
public override bool Equals(System.Object otherAirlineService)
{
if (!(otherAirlineService is AirlineService))
{
return(false);
}
else
{
AirlineService newAirlineService = (AirlineService)otherAirlineService;
bool idEquality = this.GetId() == newAirlineService.GetId();
bool nameEquality = this.GetName() == newAirlineService.GetName();
return(idEquality && nameEquality);
}
}