public StudenResultViewModel GetAllStudentInfoByStudentId(int studentId)
{
string query = "select StudentName,Email,Code FROM Student INNER JOIN Departments ON Student.DepartmentId=Departments.DeptId AND StudentId=@StudentId";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@StudentId", studentId);
Connection.Open();
Reader = Command.ExecuteReader();
Reader.Read();
StudenResultViewModel aStudenResult = new StudenResultViewModel();
if (Reader.HasRows)
{
aStudenResult.StudentName = Reader["StudentName"].ToString();
aStudenResult.Email = Reader["Email"].ToString();
aStudenResult.DeptCode = Reader["Code"].ToString();
}
Reader.Close();
Connection.Close();
return(aStudenResult);
}
public JsonResult GetAllInfoByStudentId(int studentId)
{
StudenResultViewModel studentinfo = aEnrollCourseManager.GetAllStudentInfoByStudentId(studentId);
return(Json(studentinfo, JsonRequestBehavior.AllowGet));
}
