public List <Specialty> GetSpecialties(string orderBy = "id", string order = "ASC")
{
List <Specialty> specialties = new List <Specialty>()
{
};
DB.OpenConnection();
DB.SetCommand(@"SELECT * FROM " + _tableRelational + " WHERE stylistId=@thisId ORDER BY " + orderBy + " " + order + ";");
DB.AddParameter("@thisId", _id);
MySqlDataReader rdr = DB.ReadSqlCommand();
while (rdr.Read())
{
Specialty newSpeciality = Specialty.Find(rdr.GetInt32(1));
specialties.Add(newSpeciality);
}
DB.CloseConnection();
return(specialties);
}
