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 stylistid = new MySqlParameter();
stylistid.ParameterName = "@StylistId";
stylistid.Value = _id;
cmd.Parameters.Add(stylistid);
MySqlParameter specialty_id = new MySqlParameter();
specialty_id.ParameterName = "@SpecialtyId";
specialty_id.Value = newSpecialty.GetSpecialtyId();
cmd.Parameters.Add(specialty_id); //.GetId()
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.GetSpecialtyId() == newSpecialty.GetSpecialtyId());
bool nameEquality = (this.GetSpecialtyName() == newSpecialty.GetSpecialtyName());
return(idEquality && nameEquality);
}
}
public override bool Equals(System.Object otherSpecialty)
{
if (!(otherSpecialty is Specialty))
{
return(false);
}
else
{
Specialty newSpecialty = (Specialty)otherSpecialty;
bool areNamesEqual = this.GetSpecialtyName().Equals(newSpecialty.GetSpecialtyName());
bool areIdsEqual = this.GetSpecialtyId().Equals(newSpecialty.GetSpecialtyId());
return(areNamesEqual && areIdsEqual);
}
}
public void AddSpecialty(Specialty newSpecialty)
{
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"INSERT INTO stylists_specialties (stylist_id, specialty_id)
VALUES (@stylistId, @specialtyId);";
cmd.Parameters.Add(new MySqlParameter("@stylistId", this._stylistId));
cmd.Parameters.Add(new MySqlParameter("@specialtyId", newSpecialty.GetSpecialtyId()));
cmd.ExecuteNonQuery();
conn.Close();
if (conn != null)
{
conn.Dispose();
}
}