public static List <Patient> GetAll()
{
List <Patient> allPatients = new List <Patient> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM patients;";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
int patientId = rdr.GetInt32(0);
string patientName = rdr.GetString(1);
string patientBirthday = rdr.GetDateTime(2).ToString("MM/dd/yyyy");
Patient newPatient = new Patient(patientName, patientBirthday);
newPatient.SetId(patientId);
allPatients.Add(newPatient);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allPatients);
}
