public static List <StylistSpecialty> GetAll()
{
List <StylistSpecialty> allStylistSpecialties = new List <StylistSpecialty> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM stylists_specialties;";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
int id = rdr.GetInt32(0);
int stylistId = rdr.GetInt32(1);
int specialtyId = rdr.GetInt32(2);
StylistSpecialty newStylistSpecialty = new StylistSpecialty(stylistId, specialtyId, id);
allStylistSpecialties.Add(newStylistSpecialty);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allStylistSpecialties);
}
public override bool Equals(System.Object otherStylistSpecialty)
{
if (!(otherStylistSpecialty is StylistSpecialty))
{
return(false);
}
else
{
StylistSpecialty newStylistSpecialty = (StylistSpecialty)otherStylistSpecialty;
bool idEquality = (this.GetId() == newStylistSpecialty.GetId());
bool stylistIdEquality = this.GetStylistId().Equals(newStylistSpecialty.GetStylistId());
bool specialtyIdEquality = this.GetSpecialtyId().Equals(newStylistSpecialty.GetSpecialtyId());
return(idEquality && specialtyIdEquality);
}
}