public void AddTrail(Trail newTrail) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO hikers_trails (hiker_id, trail_id) VALUES (@hikerId, @trailId);"; MySqlParameter trailId = new MySqlParameter(); trailId.ParameterName = "@trailId"; trailId.Value = newTrail.GetId(); cmd.Parameters.Add(trailId); MySqlParameter hikerId = new MySqlParameter(); hikerId.ParameterName = "@hikerId"; hikerId.Value = this._id; cmd.Parameters.Add(hikerId); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public override bool Equals(System.Object otherTrail) { if (!(otherTrail is Trail)) { return(false); } else { Trail newTrail = (Trail)otherTrail; bool idEquality = this.GetId() == newTrail.GetId(); bool nameEquality = this.GetName() == newTrail.GetName(); bool difficultyEquality = this.GetDifficulty() == newTrail.GetDifficulty(); bool waterfallsEquality = this.GetWaterfalls() == newTrail.GetWaterfalls(); bool summitsEquality = this.GetSummits() == newTrail.GetSummits(); bool streamsEquality = this.GetStreams() == newTrail.GetStreams(); bool mountainViewsEquality = this.GetMountainViews() == newTrail.GetMountainViews(); bool meadowsEquality = this.GetMeadows() == newTrail.GetMeadows(); bool lakesEquality = this.GetLakes() == newTrail.GetLakes(); bool locationEquality = this.GetLocation() == newTrail.GetLocation(); return(idEquality && nameEquality && difficultyEquality && waterfallsEquality && summitsEquality && streamsEquality && mountainViewsEquality && lakesEquality && meadowsEquality && locationEquality); } }