public List <Tutor> Get_All_Tutors()
{
List <Tutor> tutors = new List <Tutor>();
Tutor tutor = new Tutor();
try
{
con.OpenCon();
com = new SqlCommand("SELECT * FROM Tutors", con.GetCon());
SqlDataReader rdr = com.ExecuteReader();
while (rdr.Read())
{
tutor = new Tutor();
tutor.setAddress(rdr["Address"].ToString());
tutor.setFirstName(rdr["First_Name"].ToString());
tutor.setID(rdr["ID"].ToString());
tutor.setLastName(rdr["Last_Name"].ToString());
tutor.setnumOfHours(Convert.ToInt32(rdr["Hours"].ToString()));
tutor.setPassword(rdr["Password"].ToString());
tutor.setUserName(rdr["User_Name"].ToString());
tutors.Add(tutor);
}
rdr.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
con.CloseCon();
return(tutors);
}
