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