protected void LoadAdminPanel(WebhostEntities db, Faculty teacher, int curTerm)
{
PingBtn.Visible = false;
if (teacher.Permissions.Where(p => p.Name.Contains("Admin") && p.AcademicYear == DateRange.GetCurrentAcademicYear()).Count() > 0)
{
PingBtn.Visible = true;
TeacherSelect.DataSource = FacultyListItem.GetDataSource(db.Faculties.Where(f => f.isActive).OrderBy(f => f.LastName).ThenBy(f => f.FirstName).Select(f => f.ID).ToList());
TeacherSelect.DataTextField = "Text";
TeacherSelect.DataValueField = "ID";
TeacherSelect.DataBind();
StudentSelect.DataSource = StudentListItem.GetDataSource(db.Students.Where(s => s.isActive).OrderBy(f => f.LastName).ThenBy(f => f.FirstName).Select(s => s.ID).ToList());
StudentSelect.DataTextField = "Text";
StudentSelect.DataValueField = "ID";
StudentSelect.DataBind();
}
else if (db.Departments.Where(d => d.DeptHeadId == teacher.ID).Count() > 0)
{
List <int> facids = new List <int>();
Term term = db.Terms.Find(curTerm);
foreach (Department dept in teacher.Departments.ToList())
{
foreach (Section section in term.Sections.Where(s => s.Course.DepartmentID == dept.id).ToList())
{
foreach (Faculty t in section.Teachers.ToList())
{
if (!facids.Contains(t.ID))
{
facids.Add(t.ID);
}
}
}
}
TeacherSelect.DataSource = FacultyListItem.GetDataSource(facids);
TeacherSelect.DataTextField = "Text";
TeacherSelect.DataValueField = "ID";
TeacherSelect.DataBind();
StudentSelect.DataSource = StudentListItem.GetDataSource(teacher.Students.Where(s => s.isActive).Select(s => s.ID).ToList());
StudentSelect.DataTextField = "Text";
StudentSelect.DataValueField = "ID";
StudentSelect.DataBind();
}
else
{
TeacherSelect.DataSource = FacultyListItem.GetDataSource(new List <int>()
{
user.ID
});
TeacherSelect.DataTextField = "Text";
TeacherSelect.DataValueField = "ID";
TeacherSelect.DataBind();
StudentSelect.DataSource = StudentListItem.GetDataSource(teacher.Students.Where(s => s.isActive).Select(s => s.ID).ToList());
StudentSelect.DataTextField = "Text";
StudentSelect.DataValueField = "ID";
StudentSelect.DataBind();
}
}
new protected void Page_Init(object sender, EventArgs e)
{
base.Page_Init(sender, e);
StudentCreditReport1.ReadOnly = true;
StudentCreditReport1.Visible = false;
if (!user.IsTeacher)
{
Response.Redirect("~/Home.aspx");
}
using (WebhostEntities db = new WebhostEntities())
{
Faculty faculty = db.Faculties.Find(user.ID);
if (faculty == null)
{
LogError("Could not locate faculty id {0}", user.ID);
Response.Redirect("~/Home.aspx");
}
AdviseeSelectCB.DataSource = StudentListItem.GetDataSource(faculty.Students.Where(s => s.isActive).Select(s => s.ID).ToList());
AdviseeSelectCB.DataTextField = "Text";
AdviseeSelectCB.DataValueField = "ID";
AdviseeSelectCB.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
using (WebhostEntities db = new WebhostEntities())
{
StudentSelector.DataSource = StudentListItem.GetDataSource(db.Students.Where(s => s.isActive).OrderBy(s => s.LastName).ThenBy(s => s.FirstName).Select(s => s.ID).ToList());
StudentSelector.DataTextField = "Text";
StudentSelector.DataValueField = "ID";
StudentSelector.DataBind();
}
}
}
new protected void Page_Init(object sender, EventArgs e)
{
base.Page_Init(sender, e);
using (WebhostEntities db = new WebhostEntities())
{
StudentComboBox.DataSource = StudentListItem.GetDataSource(
db.Students.Where(s => s.isActive).OrderBy(s => s.GraduationYear).ThenBy(s => s.LastName).ThenBy(s => s.FirstName).Select(s => s.ID).ToList());
StudentComboBox.DataTextField = "Text";
StudentComboBox.DataValueField = "ID";
StudentComboBox.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
using (WebhostEntities db = new WebhostEntities())
{
List <int> sids = db.Students.Where(s => s.CourseRequests.Where(cr => cr.TermId == TermId && cr.RequestableCourse.Course.Name.Contains("AP")).Count() > 0).OrderBy(s => s.LastName).ThenBy(s => s.FirstName).Select(s => s.ID).ToList();
StudentSelectDDL.DataSource = StudentListItem.GetDataSource(sids);
StudentSelectDDL.DataTextField = "Text";
StudentSelectDDL.DataValueField = "ID";
StudentSelectDDL.DataBind();
CourseRequestDDL.Enabled = false;
SelectCR.Enabled = false;
ApprovalPanel.Visible = false;
}
}
}
new protected void Page_Init(object sender, EventArgs e)
{
base.Page_Init(sender, e);
using (WebhostEntities db = new WebhostEntities())
{
Faculty faculty = db.Faculties.Find(user.ID);
if (faculty == null)
{
LogError("Could not locate faculty id {0}", user.ID);
Response.Redirect("~/Home.aspx");
}
StudentComboBox.DataSource = StudentListItem.GetDataSource(faculty.Students.Where(s => s.isActive).Select(s => s.ID).ToList());
StudentComboBox.DataTextField = "Text";
StudentComboBox.DataValueField = "ID";
StudentComboBox.DataBind();
}
}
new protected void Page_Init(object sender, EventArgs e)
{
base.Page_Init(sender, e);
// Note to self--FIX THIS LATER!
//CourseRequestAdmin1.Visible = this.user.Permissions.Contains(10) || this.user.Permissions.Contains(13);
int tid = this.AdminMasqueradeTeacherId > -1 ? this.AdminMasqueradeTeacherId : this.user.ID;
using (WebhostEntities db = new WebhostEntities())
{
Term theTerm = db.Terms.Where(t => t.id == termId).Single();
Faculty faculty = db.Faculties.Where(f => f.ID == tid).Single();
if (faculty.Permissions.Where(p => p.AcademicYear.Equals(theTerm.AcademicYearID) && (p.Name.Equals("Administrator") || p.Name.Equals("Comment Admins"))).Count() > 0)
{
CourseRequestAdmin1.Visible = true;
}
else
{
CourseRequestAdmin1.Visible = false;
}
StudentSelectDDL.DataSource = StudentListItem.GetDataSource(faculty.Students.Where(s => s.isActive && s.GraduationYear >= theTerm.AcademicYearID).Select(s => s.ID).ToList());
StudentSelectDDL.DataTextField = "Text";
StudentSelectDDL.DataValueField = "ID";
StudentSelectDDL.DataBind();
if (SelectedStudentId != -1)
{
StudentSelectDDL.ClearSelection();
StudentSelectDDL.SelectedValue = SelectedStudentId.ToString();
}
}
LoadRequests();
}
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);
}
}
}
}
// GET: Student
public ActionResult Index()
{
var model = new StudentListItem[0];
return(View(model));
}
protected void LoadData()
{
int tid = this.AdminMasqueradeTeacherId > -1 ? this.AdminMasqueradeTeacherId : this.user.ID;
using (WebhostEntities db = new WebhostEntities())
{
Term theTerm = db.Terms.Where(t => t.id == termId).Single();
Faculty faculty = db.Faculties.Where(f => f.ID == tid).Single();
StudentSelectDDL.DataSource = StudentListItem.GetDataSource(faculty.Students.Where(s => s.isActive && s.GraduationYear >= theTerm.AcademicYearID).Select(s => s.ID).ToList());
StudentSelectDDL.DataTextField = "Text";
StudentSelectDDL.DataValueField = "ID";
StudentSelectDDL.DataBind();
SeniorProjectPanel.Visible = false;
SeniorProjectCB.Checked = false;
English1DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 2 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
English1DDL.DataTextField = "Text";
English1DDL.DataValueField = "CourseId";
English1DDL.DataBind();
English2DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 2 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
English2DDL.DataTextField = "Text";
English2DDL.DataValueField = "CourseId";
English2DDL.DataBind();
History1DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 3 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
History1DDL.DataTextField = "Text";
History1DDL.DataValueField = "CourseId";
History1DDL.DataBind();
History2DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 3 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
History2DDL.DataTextField = "Text";
History2DDL.DataValueField = "CourseId";
History2DDL.DataBind();
Science1DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 0 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
Science1DDL.DataTextField = "Text";
Science1DDL.DataValueField = "CourseId";
Science1DDL.DataBind();
Science2DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 0 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
Science2DDL.DataTextField = "Text";
Science2DDL.DataValueField = "CourseId";
Science2DDL.DataBind();
Science3DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 0 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
Science3DDL.DataTextField = "Text";
Science3DDL.DataValueField = "CourseId";
Science3DDL.DataBind();
Math1DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 4 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
Math1DDL.DataTextField = "Text";
Math1DDL.DataValueField = "CourseId";
Math1DDL.DataBind();
Math2DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 4 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
Math2DDL.DataTextField = "Text";
Math2DDL.DataValueField = "CourseId";
Math2DDL.DataBind();
Art1DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 9 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
Art1DDL.DataTextField = "Text";
Art1DDL.DataValueField = "CourseId";
Art1DDL.DataBind();
Art2DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 9 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
Art2DDL.DataTextField = "Text";
Art2DDL.DataValueField = "CourseId";
Art2DDL.DataBind();
Art3DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 9 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
Art3DDL.DataTextField = "Text";
Art3DDL.DataValueField = "CourseId";
Art3DDL.DataBind();
WorldLang1DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 5 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
WorldLang1DDL.DataTextField = "Text";
WorldLang1DDL.DataValueField = "CourseId";
WorldLang1DDL.DataBind();
WorldLang2DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 5 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
WorldLang2DDL.DataTextField = "Text";
WorldLang2DDL.DataValueField = "CourseId";
WorldLang2DDL.DataBind();
Tech1DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 1 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
Tech1DDL.DataTextField = "Text";
Tech1DDL.DataValueField = "CourseId";
Tech1DDL.DataBind();
Tech2DDL.DataSource = CourseListItem.GetDataSource(theTerm.AcademicYear.Courses.Where(c => c.DepartmentID == 1 && (theTerm.Name.Equals("Fall") || c.LengthInTerms == 1)).OrderBy(c => c.Name).Select(c => c.id).ToList());
Tech2DDL.DataTextField = "Text";
Tech2DDL.DataValueField = "CourseId";
Tech2DDL.DataBind();
}
}
