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