public static List <Specialty> GetListOfSpecialties()
{
List <Specialty> allSpecialties = new List <Specialty> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM specialties;";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
Specialty newSpecialty = new Specialty();
newSpecialty.SetId(rdr.GetInt32(0));
newSpecialty.SetSpecialtyType(rdr.GetString(1));
allSpecialties.Add(newSpecialty);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allSpecialties);
}
public static Specialty Find(int id)
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM `specialties` WHERE id = '" + id + "';";
var rdr = cmd.ExecuteReader() as MySqlDataReader;
Specialty foundSpecialty = new Specialty();
while (rdr.Read())
{
int stylistId = rdr.GetInt32(0);
string stylistSpecialtyType = rdr.GetString(1);
foundSpecialty.SetId(stylistId);
foundSpecialty.SetSpecialtyType(stylistSpecialtyType);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(foundSpecialty);
}