public void AddStylist(StylistClass newStylist) { 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 = newStylist.GetId(); cmd.Parameters.Add(stylist_Id); MySqlParameter specialty_Id = new MySqlParameter(); specialty_Id.ParameterName = "@specialtyId"; specialty_Id.Value = _id; cmd.Parameters.Add(specialty_Id); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public override bool Equals(System.Object otherStylist) { if (!(otherStylist is StylistClass)) { return(false); } else { StylistClass newStylist = (StylistClass)otherStylist; bool stylistEquality = (this.GetName() == newStylist.GetName() && this.GetPhoneNumber() == newStylist.GetPhoneNumber() && this.GetId() == newStylist.GetId()); return(stylistEquality); } }