protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { using (WebhostEntities db = new WebhostEntities()) { StudentNameCBX.DataSource = (from student in db.Students where student.isActive orderby student.LastName, student.FirstName select new { Text = student.FirstName + " " + student.LastName + " (" + student.GraduationYear + ")", id = student.ID }).ToList(); StudentNameCBX.DataTextField = "Text"; StudentNameCBX.DataValueField = "id"; StudentNameCBX.DataBind(); // Preload Current Block. AllDayCB.Checked = false; MorningOnlyCB.Checked = false; AfternoonOnlyCB.Checked = false; EveningCB.Checked = false; Dictionary <DateRange, int> BlockTimes = DateRange.BlockIdsByTime(DateTime.Today); List <int> blockIds = BlockTimes.Values.ToList(); BlocksCBL.DataSource = (from block in db.Blocks where blockIds.Contains(block.id) select block).ToList(); BlocksCBL.DataTextField = "Name"; BlocksCBL.DataValueField = "id"; BlocksCBL.DataBind(); foreach (DateRange dr in BlockTimes.Keys) { if (dr.Contains(DateTime.Now)) { BlocksCBL.ClearSelection(); BlocksCBL.SelectedValue = Convert.ToString(BlockTimes[dr]); break; } } } } }
protected void SelectDateBtn_Click(object sender, EventArgs e) { DateTime date = DateRange.GetDateTimeFromString(DateInput.Text); Dictionary <DateRange, int> BlockTimes = DateRange.BlockIdsByTime(date); using (WebhostEntities db = new WebhostEntities()) { List <int> blockIds = BlockTimes.Values.ToList(); BlocksCBL.DataSource = (from block in db.Blocks where blockIds.Contains(block.id) select block).ToList(); BlocksCBL.DataTextField = "Name"; BlocksCBL.DataValueField = "id"; BlocksCBL.DataBind(); } }