public static List <Specialty> GetAll()
{
List <Specialty> specialties = new List <Specialty> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM Specialty;";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
Specialty specialty = new Specialty();
specialty.SetValuesFromReader(rdr);
specialties.Add(specialty);
}
rdr.Close();
foreach (var specialty in specialties)
{
specialty.PopulateStylists(conn);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(specialties);
}