public ActionResult AddRegistration(FormCollection form) { StudentCours sc = new StudentCours(); List <string> displayList = GetDisplayList(); gds = new LMS_GRINDEntities1(); string selectedItem = form["ddCourses"].ToString(); var courseList = gds.Courses.ToList(); int index = GetSelectedIndex(displayList, selectedItem); sc.course_id = courseList[index].course_id; sc.student_id = Name.user_id; // check database for specified course id and student id var ret = (from s in gds.StudentCourses where s.student_id == Name.user_id where s.course_id == sc.course_id select s).Count(); if (ret > 0) { ViewBag.Message = "Could not register for course. You are already registered."; return(ViewRegistration("")); } else { gds.StudentCourses.Add(sc); gds.SaveChanges(); CourseCardList.GenerateStudentCourseList(); ToDoList.GenerateStudentToDoList(); return(RedirectToAction("ReturnToView", "UserAccount", null)); } }
public void DeleteStudentCourse(StudentCours val) { StudentCours result = context.StudentCourses.Find(val.ID); context.YearDegrees.Remove(result.YearDegree); context.StudentCourses.Remove(result); context.SaveChanges(); }
public ActionResult DeleteConfirmed(int id) { StudentCours stu = db.StudentCourses.Find(id); db.StudentCourses.Remove(stu); db.SaveChanges(); return(RedirectToAction("Index")); }
/// <summary> /// Display course details for student /// </summary> /// <param name="id"></param> /// <returns>Display details of the selected course</returns> public ActionResult StudentCourseDetail(int id) { gds = new LMS_GRINDEntities1(); Cours course = gds.Courses.Where(x => x.course_id == id).FirstOrDefault(); int ic_id = gds.InstructorCourses.Where(x => x.course_id == id).Select(x => x.instructor_course_id).FirstOrDefault(); Department department = gds.Departments.Where(x => x.dept_id == course.dept_id).FirstOrDefault(); int instructorId = gds.InstructorCourses.Where(x => x.instructor_course_id == ic_id).Select(x => x.instructor_id).FirstOrDefault(); String instructorFirstName = gds.ulUsers.Where(x => x.ulUser_id == instructorId).Select(x => x.first_name).FirstOrDefault(); String instructorLastName = gds.ulUsers.Where(x => x.ulUser_id == instructorId).Select(x => x.last_name).FirstOrDefault(); CourseCardList.GenerateStudentCourseList(); AssignmentList.GenerateStudentAssignmentList(id); AssignmentList.GenerateThisStudentsSubmissions(Name.user_id); AssignmentList.GenerateThisStudentsSubmissionsForCourse(Name.user_id, ic_id); StudentCours studentCours = gds.StudentCourses.Where(x => (x.course_id == course.course_id) && (x.student_id == Name.user_id)).FirstOrDefault(); // Calculate overall points int maxPoints = 0; int points = 0; double?gradePoints = 0; if (AssignmentList.StudentAssignments.Any()) { foreach (var assignment in AssignmentList.StudentAssignments) { AssignmentList.GenerateThisStudentsSubmissionForAssignment(assignment.AssignmentId); if (AssignmentList.StudentAssignmentSubmission.isGraded) { points += (int)AssignmentList.StudentAssignmentSubmission.Grade; maxPoints += (int)assignment.MaxPoints; } } ViewBag.points = points; ViewBag.maxPoints = maxPoints; // Get letter grade gradePoints = ((double)points / maxPoints) * 100; // Display 2 decimal places gradePoints = Math.Truncate(100 * (double)gradePoints) / 100; if (gradePoints >= 0) { ViewBag.gradePercentage = gradePoints + "%"; // Display percentage } else { ViewBag.gradePercentage = " "; } } AssignmentList.GenerateThisStudentsSubmissionsForCourse(Name.user_id, ic_id); ViewBag.letterGrade = studentCours.letter_grade; // Display letter grade ViewBag.selectedCourse = course; ViewBag.courseDepartment = department; ViewBag.InstructorName = instructorFirstName + " " + instructorLastName; return(View("StudentCourseDetailView")); }
public void AddStudentCourse(DomainModel.BusinessObject.Student student, DomainModel.BusinessObject.GameCoding gameCoding, DomainModel.BusinessObject.Module module) { DatabaseModel.StudentCours studentCourse = new StudentCours(); studentCourse.studentId = student.StudentId; studentCourse.gameCodingId = gameCoding.Id; studentCourse.moduleId = module.Id; _dbx.StudentCourses.Add(studentCourse); _dbx.SaveChanges(); }
public ActionResult Create([Bind(Include = "StudentsID,CoursesID")] StudentCours stuc) { if (ModelState.IsValid) { db.StudentCourses.Add(stuc); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(stuc)); }
public ActionResult Edit([Bind(Include = "StudentsID,CoursesID")] StudentCours stc) { if (ModelState.IsValid) { db.Entry(stc).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(stc)); }
public ActionResult Edit(int StudeneID, int CourseId) { StudentCours stucou = db.StudentCourses.Find(StudeneID, CourseId); if (stucou == null) { return(HttpNotFound()); } ViewBag.StudeneID = new SelectList(db.students, "StudeneID", "StudentName", stucou.StudentsID); ViewBag.CourseID = new SelectList(db.Courses, "CourseId", "CourseName", stucou.CoursesID); return(View(stucou)); }
public ActionResult DeleteCourse(StudentCours val) { try { student_operation.DeleteStudentCourse(val); } catch (Exception) { return(View(val)); } return(RedirectToAction("Index")); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentCours stucou = db.StudentCourses.Find(id); if (stucou == null) { return(HttpNotFound()); } return(View(stucou)); }
public void EditStudentCourse(StudentCours val) { StudentCours result = context.StudentCourses.Find(val.ID); //context.StudentCourses.Attach(result); context.Entry(result).CurrentValues.SetValues(val); if (Int32.Parse(val.YearDegree.Total) >= 100) { val.YearDegree.Total = "100"; } context.Entry(result.YearDegree).CurrentValues.SetValues(val.YearDegree); //context.Entry(val).State = EntityState.Modified; context.SaveChanges(); }
public ActionResult RegisteCourse(StudentCours collection) { try { collection.StudentID = 1; student_operations.RegisterCourse(collection); ViewBag.CourseID = course_operations.GetAllCourses(); } catch (Exception e) { return(View()); } // need to be assigned from session for logged in student return(RedirectToAction("Index")); }
public int RegisterCourse(StudentCours val) { StudentCours added; try { YearDegree deg = new YearDegree(); deg.LectureDegree = "0"; deg.MidtermDegree = "0"; deg.SectionDegree = "0"; deg.Total = "0"; YearDegree yearAdded = context.YearDegrees.Add(deg); context.SaveChanges(); val.YearDegreeID = yearAdded.ID; val.FinalDegree = "0"; added = context.StudentCourses.Add(val); context.SaveChanges(); } catch (Exception exe) { throw; } return(added.ID); }
public ActionResult DetailsCourse(int Id) { StudentCours result = student_operations.GetStudentCourseById(Id); return(View(result)); }
//This method returns all of the submissions by a particular student with the parameter id //Generates a list of StudentAssignmentSubmissionItems public static void GenerateThisStudentsSubmissionsForCourse(int?studentId, int instructorCourseId) { ThisStudentsSubmissions = new List <StudentAssignmentSubmissionItem>(); LMS_GRINDEntities1 gds = new LMS_GRINDEntities1(); int totalPoints = 0; int maxPoints = 0; var query = (from a in gds.Assignments //join ic in gds.InstructorCourses on a.instructor_course_id equals ic.instructor_course_id join sa in gds.StudentAssignments on a.assignment_id equals sa.assignment_id join sc in gds.StudentCourses on sa.student_id equals sc.student_id where sa.student_id == studentId where a.instructor_course_id == instructorCourseId select new { AssignmentGradeId = sa.assignment_grade_id, //AssignmentId = sa.assignment_id, StudentId = sa.student_id, Grade = sa.grade, /*InstructorFeedback = sa.instructor_feedback, * SubmissionDate = sa.submission_date, * TextSubmission = sa.text_submission, * FileSubmission = sa.file_submission,*/ MaxPoints = a.max_points }).ToList(); int i = 0; foreach (var item in query) { ThisStudentsSubmissions.Add(new StudentAssignmentSubmissionItem()); ThisStudentsSubmissions[i].AssignmentGradeId = item.AssignmentGradeId; //ThisStudentsSubmissions[i].AssignmentId = item.AssignmentId; ThisStudentsSubmissions[i].StudentId = item.StudentId; ThisStudentsSubmissions[i].Grade = item.Grade; //ThisStudentsSubmissions[i].MaxPoints = (int)item.MaxPoints; /*ThisStudentsSubmissions[i].SubmissionDate = (DateTime)item.SubmissionDate; * ThisStudentsSubmissions[i].TextSubmission = item.TextSubmission; * ThisStudentsSubmissions[i].FileSubmission = item.FileSubmission; * ThisStudentsSubmissions[i].InstructorFeedback = item.InstructorFeedback;*/ if (item.Grade != null) { ThisStudentsSubmissions[i].isGraded = true; totalPoints += (int)item.Grade; // Total points for all graded assignements maxPoints += (int)item.MaxPoints; // Max points for all graded assignments } else { ThisStudentsSubmissions[i].isGraded = false; } i++; } //Calculate letter grade and save it to database int courseId = gds.InstructorCourses.Where(x => x.instructor_course_id == instructorCourseId).Select(x => x.course_id).FirstOrDefault(); StudentCours studentCours = gds.StudentCourses.Where(x => (x.student_id == studentId) && (x.course_id == courseId)).FirstOrDefault(); double gradePoints = ((double)totalPoints / maxPoints) * 100; gradePoints = Math.Truncate(100 * gradePoints) / 100; String letterGrade = getLetterGrade(gradePoints); studentCours.letter_grade = letterGrade; gds.SaveChanges(); }
public ActionResult EditCourse(StudentCours result) { student_operation.EditStudentCourse(result); return(RedirectToAction("Index")); }