public List <EnrollResultInfo> GetResultByStudentId(int studentId)
{
string query = "SELECT * FROM EnrollCoursesInfo WHERE StudentId=@studentId";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@studentId", studentId);
connection.Open();
reader = command.ExecuteReader();
List <EnrollResultInfo> resultList = new List <EnrollResultInfo>();
while (reader.Read())
{
EnrollResultInfo aCourse = new EnrollResultInfo();
aCourse.CourseCode = reader["Code"].ToString();
aCourse.CourseTitle = (reader["Name"]).ToString();
int GradeId = 0;
GradeId = Convert.ToInt32(reader["GradeId"]);
if (GradeId == 0)
{
aCourse.Grade = "Not Graded Yet";
}
if (GradeId > 0)
{
aCourse.Grade = (reader["Grade"]).ToString();
}
resultList.Add(aCourse);
}
connection.Close();
return(resultList);
}
public ActionResult UrlAsPDF(EnrollResultInfo enrollCourse)
{
return(new ActionAsPdf("ResultPdf", enrollCourse)
{
FileName = "Result.pdf"
});
ModelState.Clear();
}
public ActionResult ResultPdf(EnrollResultInfo enrollCourse)
{
List <EnrollResultInfo> resultList = aCourseManager.GetResultByStudentId(enrollCourse.StudentId);
ViewBag.ResultList = resultList;
EnrollResultInfo aStudentInfo = aCourseManager.GetStudentByStudentId(enrollCourse.StudentId);
ViewBag.StudentRegNo = aStudentInfo.RegNo;
ViewBag.Name = aStudentInfo.StudentName;
ViewBag.Email = aStudentInfo.Email;
ViewBag.DepartmentName = aStudentInfo.DepartmentName;
return(View());
}
public EnrollResultInfo GetStudentByStudentId(int studentId)
{
string queryTwo = "SELECT * FROM StudentInfo WHERE Id=@studentId";
SqlCommand commandTwo = new SqlCommand(queryTwo, connection);
commandTwo.Parameters.AddWithValue("@studentId", studentId);
connection.Open();
reader = commandTwo.ExecuteReader();
EnrollResultInfo aCourse = new EnrollResultInfo();
while (reader.Read())
{
aCourse.StudentId = Convert.ToInt32(reader["Id"]);
aCourse.StudentName = (reader["Name"]).ToString();
aCourse.Email = (reader["Email"]).ToString();
aCourse.RegNo = (reader["RegNo"]).ToString();
aCourse.DepartmentName = (reader["DepartmentName"]).ToString();
}
connection.Close();
return(aCourse);
}
