public void fillGrid3() { using (var context = new GradebookDataEntities()) { var l2equery = from s in context.Students where s.Email.Contains(searchStudentsTextBox.Text) select s; var s1 = l2equery.ToList(); studentGridView.DataSource = s1; studentGridView.DataBind(); } }
public void fillCourseGridView() { using (var context = new GradebookDataEntities()) { var l2equery = from s in context.Students where s.Email.Contains(searchStudentsTextBox.Text) select s.Courses; var courses = l2equery.FirstOrDefault(); courseGridView.DataSource = courses; courseGridView.DataBind(); } }
public void fillDefault() { using (var context = new GradebookDataEntities()) { var l2equery = from c in context.Courses select c; var courses = l2equery.ToList(); courseGridView.DataSource = courses; courseGridView.DataBind(); } }
protected void initializeStudent() { studentCourseDropDown.Items.Clear(); studentCourseDropDown.Items.Add(new ListItem("--Select--", null)); using(var context = new GradebookDataEntities()) { var query = from c in context.Courses select new { c.CourseID, c.CourseNumber, c.Term, c.Year }; foreach(var course in query) { string courseFormat = String.Format("{0,-10}\t{1,-10}\t{2, 10}", course.CourseID, course.CourseNumber, course.Term, course.Year); studentCourseDropDown.Items.Add(new ListItem(courseFormat,courseFormat)); } } }
protected void checkRole() { using (var context = new GradebookDataEntities()) { var l2equery = (from s in context.Students where s.Email == email select s).FirstOrDefault(); if (l2equery != null) { studentPanel.Visible = true; teacherPanel.Visible = false; studentCourseGridViewFill(); } else { teacherPanel.Visible = true; studentPanel.Visible = false; teacherCourseGridViewFill(); } } }
protected void AddStudentButton_Click(object sender, EventArgs e) { if (AddStudentTextBox.Text != "") { using (var context = new GradebookDataEntities()) { Course course = context.Courses.FirstOrDefault(c => c.CourseNumber == CourseNumberDropDownList.SelectedValue); Student student = context.Students.FirstOrDefault(s => s.Email == AddStudentTextBox.Text); course.Students.Add(student); context.SaveChanges(); var l2equery = from s in context.Students where s.Email.Contains(searchStudentsTextBox.Text) select s.Courses; var courses = l2equery.FirstOrDefault(); courseGridView.DataSource = courses; courseGridView.DataBind(); } } else { string email = studentGridView.Rows[studentGridView.SelectedIndex].Cells[0].Text.ToString(); ; using (var context = new GradebookDataEntities()) { Course course = context.Courses.FirstOrDefault(c => c.CourseNumber == CourseNumberDropDownList.SelectedValue); Student student = context.Students.FirstOrDefault(s => s.Email == email); course.Students.Add(student); context.SaveChanges(); var l2equery = from s in context.Students where s.Email.Contains(searchStudentsTextBox.Text) select s.Courses; var courses = l2equery.FirstOrDefault(); courseGridView.DataSource = courses; courseGridView.DataBind(); } } }
protected bool checkIfStudent() { string studentEmail; using (var context = new GradebookDataEntities()) { var query = (from c in context.Courses from s in c.Students where c.CourseID == courseID && s.Email == User.Identity.Name select s.Email); studentEmail = query.FirstOrDefault(); } if(studentEmail == null) return false; return true; }
protected void loadTeacherCourseStudentGrid() { using (var context = new GradebookDataEntities()) { var query = (from c in context.Courses where c.CourseID == courseID select c.Students).FirstOrDefault(); teacherCourseStudentGrid.DataSource = query; teacherCourseStudentGrid.DataBind(); } }
protected void loadTeacherCourseGradeGrid() { using (var context = new GradebookDataEntities()) { var l2equery = from c in context.Courses where c.CourseID == courseID select c.GradeDistributions; var gradeDistribution = l2equery.FirstOrDefault(); teacherCourseGradeGrid.DataSource = gradeDistribution; teacherCourseGradeGrid.DataBind(); } }
protected void loadTeacherCourseAssignmentGrid() { using (var context = new GradebookDataEntities()) { var query = (from c in context.Courses from grade in c.GradeDistributions from assignment in grade.Assignments where c.CourseID == courseID select new { assignment.Description, assignment.PointsPossible }).ToList(); teacherCourseAssignmentGrid.DataSource = query; teacherCourseAssignmentGrid.DataBind(); } teacherCourseAssignmentGrid.GridLines = GridLines.None; }
protected void getClassName() { string cName; using (var context = new GradebookDataEntities()) { var query = (from c in context.Courses where c.CourseID == courseID select c).FirstOrDefault(); cName = query.CourseNumber.ToString(); ClassLabel.Text = cName; } }
protected bool checkIfTeacher() { string teacherEmail; using (var context = new GradebookDataEntities()) { var query = (from c in context.Courses where c.CourseID == courseID select c.Teacher).FirstOrDefault(); teacherEmail = query.Email; } if (teacherEmail == User.Identity.Name) return true; else return false; }
protected void registerCourseButton_Click(object sender, EventArgs e) { using (var context = new GradebookDataEntities()) { var query = (from t in context.Teachers where t.Email == email select t.TeacherID).FirstOrDefault(); int teacher = Convert.ToInt32(query); string cNumber = CourseNumber.Text; string term = termDropDownList.SelectedValue; int year = Convert.ToInt32(yearDropDownList.SelectedValue); var result = context.AddClass(cNumber,term,year,CourseDescription.Text,query); } teacherCourseGridViewFill(); }
protected void TermDropDownList_SelectedIndexChanged(object sender, EventArgs e) { using (var context = new GradebookDataEntities()) { var l2equery = from c in context.Courses where c.Year >= DateTime.Now.Year && c.Term == TermDropDownList.SelectedValue select c; var courses = l2equery.ToList(); CourseNumberDropDownList.DataSource = courses; CourseNumberDropDownList.DataBind(); } }
protected void studentGridView_SelectedIndexChanged(Object sender, EventArgs e) { string email = studentGridView.Rows[studentGridView.SelectedIndex].Cells[0].Text.ToString(); ; using (var context = new GradebookDataEntities()) { var l2equery = from s in context.Students where s.Email.Contains(email) select s.Courses; var courses = l2equery.FirstOrDefault(); courseGridView.DataSource = courses; courseGridView.DataBind(); } searchStudentsTextBox.Text = email; }
protected void teacherCourseGridViewFill() { using (var context = new GradebookDataEntities()) { var l2equery = from t in context.Teachers where t.Email == email select t.Courses; var teacherCourses = l2equery.FirstOrDefault(); teacherCourseGridView.DataSource = teacherCourses; teacherCourseGridView.DataBind(); } }
protected void studentCourseGridViewFill() { using (var context = new GradebookDataEntities()) { var l2equery = from s in context.Students where s.Email == email select s.Courses; var courses = l2equery.FirstOrDefault(); studentCourseGridView.DataSource = courses; studentCourseGridView.DataBind(); } }
protected void registerStudentCourseButton_Click(object sender, EventArgs e) { if(courseID != 0) using(var context = new GradebookDataEntities()) { Course course = context.Courses.FirstOrDefault(c => c.CourseID == courseID); Student student = context.Students.FirstOrDefault(s => s.Email == email); course.Students.Add(student); context.SaveChanges(); } studentCourseGridViewFill(); }