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