protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
using (WebhostEntities db = new WebhostEntities())
{
int year = DateRange.GetCurrentAcademicYear();
DormSelector.DataSource = db.Dorms.Where(d => d.AcademicYearId == year).ToList();
DormSelector.DataTextField = "Name";
DormSelector.DataValueField = "id";
DormSelector.DataBind();
DormHeadSelector.DataSource = (from faculty in db.Faculties
orderby faculty.LastName, faculty.FirstName
select new
{
Name = faculty.FirstName + " " + faculty.LastName,
id = faculty.ID
}).ToList();
DormHeadSelector.DataTextField = "Name";
DormHeadSelector.DataValueField = "id";
DormHeadSelector.DataBind();
}
}
}
protected void DormSelector_SelectedIndexChanged(object sender, EventArgs e)
{
using (WebhostEntities db = new WebhostEntities())
{
Dorm dorm = db.Dorms.Where(d => d.id == DormId).Single();
DormHeadSelector.ClearSelection();
DormHeadSelector.SelectedValue = Convert.ToString(dorm.DormHeadId);
DormParentSelector.Clear();
DormParentSelector.AddFaculty(dorm.DormParents.Select(f => f.ID).ToList());
StudentSelector.Clear();
StudentSelector.AddStudent(dorm.Students.Select(s => s.ID).ToList());
}
}