protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (TermId == -1) { TermId = DateRange.GetCurrentOrLastTerm(); } using (WebhostEntities db = new WebhostEntities()) { int year = DateRange.GetCurrentAcademicYear(); int termid = Import.GetCurrentOrLastTerm(); Term term = db.Terms.Where(t => t.id == termid).Single(); TermSelectDDL.ClearSelection(); TermSelectDDL.SelectedValue = term.Name; } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { using (WebhostEntities db = new WebhostEntities()) { Faculty currentUser = db.Faculties.Where(f => f.ID == this.user.ID).Single(); List <int> advisees = currentUser.Students.Where(s => s.isActive).Select(s => s.ID).ToList(); int year = DateRange.GetCurrentAcademicYear(); int currentTerm = DateRange.GetCurrentOrLastTerm(); AcademicYear ay = db.AcademicYears.Where(y => y.id == year).Single(); AdviseeSelectDDL.DataSource = StudentListItem.GetDataSource(advisees); AdviseeSelectDDL.DataTextField = "Text"; AdviseeSelectDDL.DataValueField = "ID"; AdviseeSelectDDL.DataBind(); if (advisees.Contains(SelectedAdvisee)) { AdviseeSelectDDL.ClearSelection(); AdviseeSelectDDL.SelectedValue = Convert.ToString(SelectedAdvisee); } else { SelectedAdvisee = Convert.ToInt32(AdviseeSelectDDL.SelectedValue); } TermSelectDDL.DataSource = TermListItem.GetDataSource(ay.Terms.Select(t => t.id).ToList()); TermSelectDDL.DataTextField = "Text"; TermSelectDDL.DataValueField = "ID"; TermSelectDDL.DataBind(); TermSelectDDL.ClearSelection(); TermSelectDDL.SelectedValue = Convert.ToString(SelectedTerm); Student selectedAdvisee = currentUser.Students.Where(s => s.ID == SelectedAdvisee).Single(); List <MiniComment> comments = new List <MiniComment>(); foreach (StudentComment comment in selectedAdvisee.StudentComments.Where(c => c.CommentHeader.TermIndex == SelectedTerm).ToList()) { comments.Add(new MiniComment() { id = comment.id, className = comment.CommentHeader.Section.Course.Name }); } if (comments.Count == 0) { ClassSelectDDL.Enabled = false; } else { ClassSelectDDL.Enabled = true; ClassSelectDDL.DataSource = comments; ClassSelectDDL.DataTextField = "className"; ClassSelectDDL.DataValueField = "id"; ClassSelectDDL.DataBind(); if (SelectedComment != -1) { ClassSelectDDL.ClearSelection(); ClassSelectDDL.SelectedValue = Convert.ToString(SelectedComment); } else { SelectedComment = Convert.ToInt32(ClassSelectDDL.SelectedValue); } AdviseeCommentViewer.LoadComment(SelectedComment); } } } }