//ADDS A SPECIALTY TO A STYLIST
public void AddSpecialty(Specialty 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("@StylistId", _id);
cmd.Parameters.Add(stylist_id);
MySqlParameter specialty_id = new MySqlParameter("@SpecialtyId", newSpecialty.GetId());
cmd.Parameters.Add(specialty_id);
cmd.ExecuteNonQuery();
conn.Close();
if (conn != null)
{
conn.Dispose();
}
}