public List <ViewStudentResult> GetAllResults(int id) { SqlConnection connection = new SqlConnection(); connection.ConnectionString = connectionString; SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = "SELECT * FROM VW_StudentResult WHERE StudentRegistrationId='" + id + "'"; connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <ViewStudentResult> _viewStudentResults = new List <ViewStudentResult>(); while (reader.Read()) { ViewStudentResult _viewStudentResult = new ViewStudentResult { CourseCode = reader["Code"].ToString(), CourseName = reader["CourseName"].ToString(), Grade = reader["GradeName"].ToString() }; _viewStudentResults.Add(_viewStudentResult); } reader.Close(); connection.Close(); return(_viewStudentResults); }
internal List <ViewStudentResult> GetAllStudentResult() { connection.ConnectionString = connectionString; string query = "SELECT * FROM StudentResultDetails "; connection.ConnectionString = connectionString; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <ViewStudentResult> studenResultList = new List <ViewStudentResult>(); while (reader.Read()) { ViewStudentResult aStudentResult = new ViewStudentResult(); aStudentResult.StudentId = (int)reader["StudentId"]; aStudentResult.StudentName = reader["StudentName"].ToString(); aStudentResult.RegistrationId = reader["RegistrationId"].ToString(); aStudentResult.StudentEmail = reader["StudentEmail"].ToString(); aStudentResult.DepartmentName = reader["DepartmentName"].ToString(); aStudentResult.CourseId = (int)reader["CourseId"]; aStudentResult.CourseCode = reader["CourseCode"].ToString(); string s = reader["Grade"].ToString(); if (s == "") { aStudentResult.Grade = "Not Graded Yet"; } else { aStudentResult.Grade = s; } aStudentResult.CourseName = reader["CourseName"].ToString(); studenResultList.Add(aStudentResult); } reader.Close(); connection.Close(); return(studenResultList); }