/// <summary> /// Method to allot students to a room in the current allotment /// </summary> /// <param name="db">The database</param> private void AllotStudentsToRoom(ExamRoomAllocationEntities db) { List <Student> students = db.Students .Where(x => x.Exams.Where(y => y.Id == Exam.Id).Count() != 0 && x.RoomStudents.Where(y => y.exam_id == Exam.Id).Count() == 0) .OrderBy(x => x.DepartmentId) .Take(NumberOfStudents) .ToList(); foreach (var student in students) { db.RoomStudents.Add(new RoomStudent { Room_Id = Room.Id, Student_Id = student.Id, Session_Id = Exam.SessionId, exam_id = Exam.Id }); } db.SaveChanges(); }
/// <summary> /// Method to add the exam to the room /// </summary> /// <param name="db">The database</param> private void AllotExamToRoom(ExamRoomAllocationEntities db) { Room.Exams.Add(Exam); db.Entry(Exam).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); }