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);;
}
}
