public static Grade GetSummerPracticum(Student s) { Grade grade = null; using (var connection = DbConn.GetConnection()) { connection.Open(); SqlCommand selectCommand = new SqlCommand("mcftacademics.dbo.SelectSummerPracticumByStudentId", connection); selectCommand.CommandType = System.Data.CommandType.StoredProcedure; selectCommand.Parameters.AddWithValue("@studentId", s.Id); //execute the sql statement SqlDataReader reader = selectCommand.ExecuteReader(); //loop through the resultset if (reader.Read()) { grade = GradeDAL.GradeFromRow(reader); } } return(grade);//return the grade }
// moved from StudentDAL internal static List <Grade> GetGradesForStudent(Student student) { List <Grade> grades = new List <Grade>(); Grade grade = null; using (var connection = DbConn.GetConnection()) { connection.Open(); SqlCommand selectCommand = new SqlCommand("mcftacademics.dbo.SelectStudentGradeById2", connection); selectCommand.CommandType = System.Data.CommandType.StoredProcedure; selectCommand.Parameters.AddWithValue("@studentId", student.Id); SqlDataReader reader = selectCommand.ExecuteReader(); while (reader.Read()) { grade = GradeDAL.GradeFromRow(reader); grades.Add(grade); } } return(grades); }
internal static Grade GetGradesForStudentInCourse(Course course, Student student) { Grade grade = null; using (var connection = DbConn.GetConnection()) { connection.Open(); SqlCommand selectCommand = new SqlCommand("mcftacademics.dbo.SelectGradeByCourseAndStudent", connection); selectCommand.CommandType = System.Data.CommandType.StoredProcedure; selectCommand.Parameters.AddWithValue("@courseId", course.Id); selectCommand.Parameters.AddWithValue("@studentId", student.Id); //execute the sql statement SqlDataReader reader = selectCommand.ExecuteReader(); //loop through the resultset if (reader.Read()) { grade = GradeDAL.GradeFromRow(reader, course); } } return(grade);//return the grade }