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
}