public void AddSpecialty(SpecialtyClass newSpecialty) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT into stylists_specialties(stylist_Id, specialty_Id) VALUES (@stylistId, @specialtyId);"; MySqlParameter stylist_Id = new MySqlParameter(); stylist_Id.ParameterName = "@stylistId"; stylist_Id.Value = _id; cmd.Parameters.Add(stylist_Id); MySqlParameter specialty_Id = new MySqlParameter(); specialty_Id.ParameterName = "@specialtyId"; specialty_Id.Value = newSpecialty.GetId(); cmd.Parameters.Add(specialty_Id); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public override bool Equals(System.Object otherSpecialty) { if (!(otherSpecialty is SpecialtyClass)) { return(false); } else { SpecialtyClass newSpecialty = (SpecialtyClass)otherSpecialty; bool specialtyEquality = (this.GetFeature() == newSpecialty.GetFeature() && this.GetId() == newSpecialty.GetId()); return(specialtyEquality); } }