public static List <ExamAdministrator> GetInstitutions() { // contains all the Ids List <ExamAdministrator> institutions = new List <ExamAdministrator>(); // for each retrieved line from db ExamAdministrator institution; // create connection using (SqlConnection connection = Invigulus.GetConnection()) { // create SELECT command string query = "SELECT DISTINCT InstitutionName FROM ExamAdministrator "; using (SqlCommand cmd = new SqlCommand(query, connection)) { connection.Open(); // execute the command and process results using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { institution = new ExamAdministrator(); institution.InstitutionName = (string)dr["InstitutionName"]; institutions.Add(institution); } } // automatically data reader closes and gets recycled } } // object automatically closed and recycled return(institutions); }
public static List <ExamAdministrator> GetAdministrators() { // contains all the Ids List <ExamAdministrator> admins = new List <ExamAdministrator>(); // for each retrieved line from db ExamAdministrator admin; // create connection using (SqlConnection connection = Invigulus.GetConnection()) { // create SELECT command string query = "SELECT DISTINCT AdministratorID, u.UserID, LastName, FirstName, Email, InstitutionName FROM Exam ex " + "RIGHT JOIN ExamAdministrator adm ON ex.Administrator = adm.AdministratorID " + "INNER JOIN _User u ON adm.UserID = u.UserID"; using (SqlCommand cmd = new SqlCommand(query, connection)) { connection.Open(); // execute the command and process results using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { admin = new ExamAdministrator(); admin.AdministratorID = (int)dr["AdministratorID"]; admin.UserID = (int)dr["UserID"]; admin.FirstName = (string)dr["FirstName"]; admin.LastName = (string)dr["LastName"]; admin.Email = (string)dr["Email"]; admin.InstitutionName = (string)dr["InstitutionName"]; admins.Add(admin); } } // automatically data reader closes and gets recycled } } // object automatically closed and recycled return(admins); }