//saves input to join table public void SetArrivals(ArrivalCity newArrivalCity) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO flights (arrival_city_id, departure_city_id) VALUES (@ArrivalCityId, @DepartureCityId);"; MySqlParameter arrival_city_id = new MySqlParameter(); arrival_city_id.ParameterName = "@ArrivalCityId"; arrival_city_id.Value = newArrivalCity.GetId(); cmd.Parameters.Add(arrival_city_id); MySqlParameter departure_city_id = new MySqlParameter(); departure_city_id.ParameterName = "@DepartureCityId"; departure_city_id.Value = _id; cmd.Parameters.Add(departure_city_id); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public override bool Equals(System.Object otherArrivalCity) { if (!(otherArrivalCity is ArrivalCity)) { return(false); } else { ArrivalCity newArrivalCity = (ArrivalCity)otherArrivalCity; bool idEquality = this.GetId() == newArrivalCity.GetId(); bool nameEquality = this.GetArrivalCityName() == newArrivalCity.GetArrivalCityName(); return(idEquality && nameEquality); } }