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();
     }
 }
Ejemplo n.º 2
0
        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();
            }
        }