protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
using (WebhostEntities db = new WebhostEntities())
{
StudentSelectDDL.DataSource = (from student in db.Students
orderby student.LastName, student.FirstName
select new
{
Text = student.FirstName + " " + student.LastName + " (" + student.GraduationYear + ")",
id = student.ID
}).ToList();
StudentSelectDDL.DataTextField = "Text";
StudentSelectDDL.DataValueField = "id";
StudentSelectDDL.DataBind();
FacultySelectDDL.DataSource = (from teacher in db.Faculties
orderby teacher.LastName, teacher.FirstName
select new
{
Text = teacher.FirstName + " " + teacher.LastName,
id = teacher.ID
}).ToList();
FacultySelectDDL.DataTextField = "Text";
FacultySelectDDL.DataValueField = "id";
FacultySelectDDL.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
using (WebhostEntities db = new WebhostEntities())
{
List <int> sids = db.Students.Where(s => s.CourseRequests.Where(cr => cr.TermId == TermId && cr.RequestableCourse.Course.Name.Contains("AP")).Count() > 0).OrderBy(s => s.LastName).ThenBy(s => s.FirstName).Select(s => s.ID).ToList();
StudentSelectDDL.DataSource = StudentListItem.GetDataSource(sids);
StudentSelectDDL.DataTextField = "Text";
StudentSelectDDL.DataValueField = "ID";
StudentSelectDDL.DataBind();
CourseRequestDDL.Enabled = false;
SelectCR.Enabled = false;
ApprovalPanel.Visible = false;
}
}
}
new protected void Page_Init(object sender, EventArgs e)
{
base.Page_Init(sender, e);
// Note to self--FIX THIS LATER!
//CourseRequestAdmin1.Visible = this.user.Permissions.Contains(10) || this.user.Permissions.Contains(13);
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();
if (faculty.Permissions.Where(p => p.AcademicYear.Equals(theTerm.AcademicYearID) && (p.Name.Equals("Administrator") || p.Name.Equals("Comment Admins"))).Count() > 0)
{
CourseRequestAdmin1.Visible = true;
}
else
{
CourseRequestAdmin1.Visible = false;
}
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();
if (SelectedStudentId != -1)
{
StudentSelectDDL.ClearSelection();
StudentSelectDDL.SelectedValue = SelectedStudentId.ToString();
}
}
LoadRequests();
}
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();
}
}
