public void AddSpecialty(Specialty newSpecialty) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO specialties_stylists (specialty_id, stylist_id) VALUES (@SpecialId, @StyleId);"; MySqlParameter special_id = new MySqlParameter(); special_id.ParameterName = "@SpecialId"; special_id.Value = newSpecialty.GetId(); cmd.Parameters.Add(special_id); MySqlParameter style_id = new MySqlParameter(); style_id.ParameterName = "@StyleId"; style_id.Value = _id; cmd.Parameters.Add(style_id); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public override bool Equals(System.Object otherSpecialty) { if (!(otherSpecialty is Specialty)) { return(false); } else { Specialty newSpecialty = (Specialty)otherSpecialty; bool idEquality = (this.GetId() == newSpecialty.GetId()); bool nameEquality = (this.GetName() == newSpecialty.GetName()); return(idEquality && nameEquality);; } }