public List <ViewCourseFromStudentDepartmentName> GetAllCourseFromStudentDepartmentNames(int studentId)
{
List <ViewCourseFromStudentDepartmentName> viewCourseFromStudentDepartment = new List <ViewCourseFromStudentDepartmentName>();
Query = "SELECT * FROM ViewCourseFromStudentDepartmentMenu where StudentId='" + studentId + "'";
Command.CommandText = Query;
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
ViewCourseFromStudentDepartmentName aViewStudentDepartmentName = new ViewCourseFromStudentDepartmentName();
aViewStudentDepartmentName.CourseId = Convert.ToInt32(Reader["CourseId"]);
aViewStudentDepartmentName.CourseName = Reader["CourseName"].ToString();
aViewStudentDepartmentName.DepartmentId = Convert.ToInt32(Reader["DepartmentId"]);
aViewStudentDepartmentName.StudentId = Convert.ToInt32(Reader["StudentId"]);
aViewStudentDepartmentName.StudentDepartmentId = Convert.ToInt32(Reader["StudentDepartmentId"]);
viewCourseFromStudentDepartment.Add(aViewStudentDepartmentName);
}
Reader.Close();
Connection.Close();
return(viewCourseFromStudentDepartment);
}
public List <ViewCourseFromStudentDepartmentName> GetAllCourseFromStudentDepartmentNames(int studentId)
{
SqlConnection connection = new SqlConnection(connectionString);
List <ViewCourseFromStudentDepartmentName> viewCourseFromStudentDepartment = new List <ViewCourseFromStudentDepartmentName>();
string Query = "SELECT * FROM ViewCourseFromStudentDepartmentName where StudentId='" + studentId + "'";
SqlCommand Command = new SqlCommand(Query, connection);
connection.Open();
SqlDataReader Reader = Command.ExecuteReader();
while (Reader.Read())
{
ViewCourseFromStudentDepartmentName aViewStudentDepartmentName = new ViewCourseFromStudentDepartmentName();
aViewStudentDepartmentName.CourseId = Convert.ToInt32(Reader["CourseId"]);
aViewStudentDepartmentName.CourseName = Reader["CourseName"].ToString();
aViewStudentDepartmentName.DepartmentId = Convert.ToInt32(Reader["DepartmentId"]);
aViewStudentDepartmentName.StudentId = Convert.ToInt32(Reader["StudentId"]);
viewCourseFromStudentDepartment.Add(aViewStudentDepartmentName);
}
Reader.Close();
connection.Close();
return(viewCourseFromStudentDepartment);
}
