private void ReloadTables()
{
using (WebhostEntities db = new WebhostEntities())
{
Section section = db.Sections.Where(sec => sec.id == SectionID).Single();
RemoveTeacherDDL.DataSource = (from teacher in section.Teachers
orderby teacher.LastName, teacher.FirstName
select new
{
Name = teacher.FirstName + " " + teacher.LastName,
ID = teacher.ID
}).ToList();
RemoveTeacherDDL.DataTextField = "Name";
RemoveTeacherDDL.DataValueField = "ID";
RemoveTeacherDDL.DataBind();
StudentTable.Rows.Clear();
StudentGroupSelector1.AddStudent(section.Students.OrderBy(st => st.LastName).ThenBy(st => st.FirstName).Select(s => s.ID).ToList());
foreach (Student student in section.Students.OrderBy(st => st.LastName).ThenBy(st => st.FirstName))
{
TableRow row = new TableRow();
TableCell cell = new TableCell();
cell.Text = String.Format("{0} {1}", student.FirstName, student.LastName);
row.Cells.Add(cell);
StudentTable.Rows.Add(row);
}
}
}
protected void CreateBtn_Click(object sender, EventArgs e)
{
PermissionId = -1;
PermissionNameInput.Text = "";
NotesInput.Text = "";
FacultyGroupSelector1.Clear();
StudentGroupSelector1.Clear();
}
