public static List <Student> GetAll()
{
List <Student> allStudents = new List <Student> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM student;";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
Student newStudent = new Student();
newStudent.SetId(rdr.GetInt32(0));
newStudent.SetName(rdr.GetString(1));
newStudent.SetDate(rdr.GetDateTime(2));
allStudents.Add(newStudent);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allStudents);
}
public static Student Find(int check)
{
Student ret = new Student();
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM student where id = " + check + ";";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
rdr.Read();
if (rdr.IsDBNull(0) == false)
{
ret.SetId(rdr.GetInt32(0));
ret.SetName(rdr.GetString(1));
ret.SetDate(rdr.GetDateTime(2));
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(ret);
}