protected void Page_Init(object sender, EventArgs e) { using (WebhostEntities db = new WebhostEntities()) { List <int> ids = db.Faculties.OrderBy(f => f.LastName).ThenBy(f => f.FirstName).Select(f => f.ID).ToList(); FacultySelector.DataSource = FacultyListItem.GetDataSource(ids); FacultySelector.DataTextField = "Text"; FacultySelector.DataValueField = "ID"; FacultySelector.DataBind(); } }
public static List <FacultyListItem> GetDataSource(List <int> ids) { List <FacultyListItem> items = new List <FacultyListItem>(); foreach (int id in ids) { FacultyListItem item = new FacultyListItem(id); if (item.ID != -1) { items.Add(item); } } return(items); }
protected void LoadTable() { using (WebhostEntities db = new WebhostEntities()) { SelectedTable.Rows.Clear(); if (GroupIds.Count == 0) { RemoveBtn.Visible = false; RemoveList.Visible = false; return; } foreach (int id in GroupIds) { Faculty faculty = db.Faculties.Where(f => f.ID == id).Single(); TableRow row = new TableRow(); TableCell cell = new TableCell(); Label lbl = new Label() { Text = String.Format("{0} {1}", faculty.FirstName, faculty.LastName) }; cell.Controls.Add(lbl); row.Cells.Add(cell); SelectedTable.Rows.Add(row); } RemoveList.Visible = true; RemoveBtn.Visible = true; /* RemoveList.DataSource = (from faculty in db.Faculties.Where(f => GroupIds.Contains(f.ID)) * orderby faculty.LastName, faculty.FirstName * select new * { * Name = faculty.FirstName + " " + faculty.LastName, * ID = faculty.ID * }).ToList();*/ RemoveList.DataSource = FacultyListItem.GetDataSource(GroupIds); RemoveList.DataTextField = "Text"; RemoveList.DataValueField = "ID"; RemoveList.DataBind(); } }