public ViewStudentModel GetStudentInfoWithDeptName(int studentId) { string query = "SELECT * FROM GetStudentInfoWithDeptName WHERE Id = '" + studentId + "'"; Command = new SqlCommand(query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); ViewStudentModel aStudentModel = null; if (Reader.HasRows) { aStudentModel = new ViewStudentModel(); Reader.Read(); aStudentModel.StudentId = (int)Reader["Id"]; aStudentModel.DepartmentId = (int)Reader["DepartmentId"]; aStudentModel.StudentName = Reader["Name"].ToString(); aStudentModel.DeptName = Reader["DeptName"].ToString(); aStudentModel.Email = Reader["Email"].ToString(); } Reader.Close(); Connection.Close(); return(aStudentModel); }
public List <ViewStudentModel> GetCourseName(int studentId) { string query = "SELECT * FROM GetCourseName WHERE StudentId = '" + studentId + "'"; Command = new SqlCommand(query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); List <ViewStudentModel> courses = new List <ViewStudentModel>(); while (Reader.Read()) { ViewStudentModel aStudentModel = new ViewStudentModel(); aStudentModel.StudentId = (int)Reader["StudentId"]; aStudentModel.CourseId = (int)Reader["CourseId"]; aStudentModel.CourseName = Reader["CourseName"].ToString(); courses.Add(aStudentModel); } Reader.Close(); Connection.Close(); return(courses); }
public ActionResult ViewStudent(long studentid) { StudentViewer student_viewer = new StudentViewer(); var model = new ViewStudentModel(); //TODO return(View(model)); }