protected void LoadData() { int tid = this.AdminMasqueradeTeacherId > -1 ? this.AdminMasqueradeTeacherId : this.user.ID; using (WebhostEntities db = new WebhostEntities()) { Term theTerm = db.Terms.Where(t => t.id == termId).Single(); Faculty faculty = db.Faculties.Where(f => f.ID == tid).Single(); StudentSelectDDL.DataSource = StudentListItem.GetDataSource(faculty.Students.Where(s => s.isActive && s.GraduationYear >= theTerm.AcademicYearID).Select(s => s.ID).ToList()); StudentSelectDDL.DataTextField = "Text"; StudentSelectDDL.DataValueField = "ID"; StudentSelectDDL.DataBind(); SeniorProjectPanel.Visible = false; SeniorProjectCB.Checked = false; English1DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 2 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); English1DDL.DataTextField = "Text"; English1DDL.DataValueField = "CourseId"; English1DDL.DataBind(); English2DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 2 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); English2DDL.DataTextField = "Text"; English2DDL.DataValueField = "CourseId"; English2DDL.DataBind(); History1DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 3 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); History1DDL.DataTextField = "Text"; History1DDL.DataValueField = "CourseId"; History1DDL.DataBind(); History2DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 3 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); History2DDL.DataTextField = "Text"; History2DDL.DataValueField = "CourseId"; History2DDL.DataBind(); Science1DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 0 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); Science1DDL.DataTextField = "Text"; Science1DDL.DataValueField = "CourseId"; Science1DDL.DataBind(); Science2DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 0 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); Science2DDL.DataTextField = "Text"; Science2DDL.DataValueField = "CourseId"; Science2DDL.DataBind(); Science3DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 0 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); Science3DDL.DataTextField = "Text"; Science3DDL.DataValueField = "CourseId"; Science3DDL.DataBind(); Math1DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 4 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); Math1DDL.DataTextField = "Text"; Math1DDL.DataValueField = "CourseId"; Math1DDL.DataBind(); Math2DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 4 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); Math2DDL.DataTextField = "Text"; Math2DDL.DataValueField = "CourseId"; Math2DDL.DataBind(); Art1DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 9 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); Art1DDL.DataTextField = "Text"; Art1DDL.DataValueField = "CourseId"; Art1DDL.DataBind(); Art2DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 9 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); Art2DDL.DataTextField = "Text"; Art2DDL.DataValueField = "CourseId"; Art2DDL.DataBind(); Art3DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 9 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); Art3DDL.DataTextField = "Text"; Art3DDL.DataValueField = "CourseId"; Art3DDL.DataBind(); WorldLang1DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 5 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); WorldLang1DDL.DataTextField = "Text"; WorldLang1DDL.DataValueField = "CourseId"; WorldLang1DDL.DataBind(); WorldLang2DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 5 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); WorldLang2DDL.DataTextField = "Text"; WorldLang2DDL.DataValueField = "CourseId"; WorldLang2DDL.DataBind(); Tech1DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 1 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); Tech1DDL.DataTextField = "Text"; Tech1DDL.DataValueField = "CourseId"; Tech1DDL.DataBind(); Tech2DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 1 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList()); Tech2DDL.DataTextField = "Text"; Tech2DDL.DataValueField = "CourseId"; Tech2DDL.DataBind(); } }