// 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()); }