// get Student by Id for pdf result
public ResultStudentInfoViewModel GetStudentByIdForPdf(int studentId)
{
Connection.Open();
string query = "SELECT Student.RegNo AS RegNo, Student.Name AS Name, Student.Email AS Email, Department.Name AS Department FROM Student JOIN Department ON Student.DepartmentId = Department.Id WHERE Student.Id = @id";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@id", studentId);
Reader = Command.ExecuteReader();
Reader.Read();
ResultStudentInfoViewModel student = null;
if (Reader.HasRows)
{
student = new ResultStudentInfoViewModel();
student.RegNo = Reader["RegNo"].ToString();
student.StudentName = Reader["Name"].ToString();
student.Email = Reader["Email"].ToString();
student.Department = Reader["Department"].ToString();
}
Reader.Close();
Connection.Close();
return(student);
}
public ActionResult DataShow(int studentId)
{
ResultStudentInfoViewModel studentInfo = studentManager.GetStudentByIdForPdf(studentId);
ViewBag.RegNo = studentInfo.RegNo;
ViewBag.Name = studentInfo.StudentName;
ViewBag.Email = studentInfo.Email;
ViewBag.Department = studentInfo.Department;
ViewBag.Result = studentManager.GetResultByStudentId(studentId);
return(View());
}
