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"));
}
