protected void Page_Init(object sender, EventArgs e)
{
using (WebhostEntities db = new WebhostEntities())
{
int id = ((BasePage)Page).user.ID;
Faculty faculty = db.Faculties.Where(fac => fac.ID == id).Single();
List <int> depts = faculty.Departments.Select(d => d.id).ToList();
DepartmentDDL.DataSource = DepartmentListItem.GetDataSource(depts);
DepartmentDDL.DataTextField = "Text";
DepartmentDDL.DataValueField = "ID";
DepartmentDDL.DataBind();
}
}
/// <summary>
/// Get a Datasource List for use in Web Controls.
///
/// DataTextField = "Text"
/// DataValueField = "Id"
///
/// Invalid IDs are dropped without notification.
///
/// </summary>
/// <param name="actids">List of RequestableCourse.id</param>
/// <returns></returns>
public static List <DepartmentListItem> GetDataSource(List <int> actids)
{
List <DepartmentListItem> items = new List <DepartmentListItem>();
foreach (int id in actids)
{
DepartmentListItem item = new DepartmentListItem(id);
if (item.ID != -1)
{
items.Add(item);
}
}
return(items);
}
public void Initialize()
{
using (WebhostEntities db = new WebhostEntities())
{
List <int> depts = new List <int>();
foreach (RequestableCourse rc in db.RequestableCourses.Where(r => r.TermId == TermId).ToList())
{
if (!depts.Contains(rc.Course.DepartmentID))
{
depts.Add(rc.Course.DepartmentID);
}
}
DeptDDL.DataSource = DepartmentListItem.GetDataSource(depts);
DeptDDL.DataTextField = "Text";
DeptDDL.DataValueField = "ID";
DeptDDL.DataBind();
//DeptDDL.SelectedIndex = 0;
}
}