public List <Specialty> GetSpecialtys()
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT specialtys.* FROM stylists
JOIN specialtys_stylists ON (stylists.id = specialtys_stylists.stylist_id)
JOIN specialtys ON (specialtys_stylists.specialty_id = specialtys.id)
WHERE stylists.id = @StylistId;";
MySqlParameter stylistIdParameter = new MySqlParameter();
stylistIdParameter.ParameterName = "@StylistId";
stylistIdParameter.Value = _id;
cmd.Parameters.Add(stylistIdParameter);
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
List <Specialty> stylists = new List <Specialty> {
};
while (rdr.Read())
{
int specialtyId = rdr.GetInt32(0);
string specialtyName = rdr.GetString(1);
Specialty foundSpecialty = new Specialty(specialtyName, specialtyId);
stylists.Add(foundSpecialty);
}
rdr.Dispose();
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(stylists);
}
