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); } }