public async Task <ActionResult> AddResult([Bind(Include = "StudentCourseStudentId, StudentCourseCourseId, Grade")] StudentCourseModel studentCourseModel) { if (ModelState.IsValid) { var studentCourse = db.StudentCourses.Where(x => x.StudentCourseCourseId == studentCourseModel.StudentCourseCourseId && x.StudentCourseStudentId == studentCourseModel.StudentCourseStudentId && x.RecordStatus == 1).Single(); studentCourse.Grade = studentCourseModel.Grade; db.Entry(studentCourse).State = EntityState.Modified; if (await db.SaveChangesAsync() > 0) { TempData["Message"] = string.Format("<b>{0}</b> set for <b>{1}</b> enrolled by <b>{2}</b>", studentCourse.Grade, new CourseManager().GetCourseById(studentCourse.StudentCourseCourseId).CourseName, new StudentManager().GetStudentById(studentCourse.StudentCourseStudentId).StudentName); TempData["MessageType"] = "success"; } return(RedirectToAction("add-result")); } ViewBag.StudentCourseStudentId = new SelectList(new StudentManager().GetStudentsOrderByRegNo(), "StudentId", "StudentRegNo"); ViewBag.StudentCourseCourseId = new List <SelectListItem> { new SelectListItem { Value = "", Text = "Select Student Registration No First" } }; ViewBag.Grade = new SelectList(new StudentManager().GetGrades(), "Grade", "Grade"); return(View(studentCourseModel)); }
public bool UnassignCourses() { UoUDBContext db = new UoUDBContext(); foreach (var teacher_course in db.TeacherCourses.Where(x => x.RecordStatus == 1).ToList()) { teacher_course.RecordStatus = 0; db.Entry(teacher_course).State = EntityState.Modified; } foreach (var student_course in db.StudentCourses.Where(x => x.RecordStatus == 1).ToList()) { student_course.RecordStatus = 0; db.Entry(student_course).State = EntityState.Modified; } if (db.SaveChanges() > 0) { return(true); } return(false); }
public bool UnallocateRooms() { UoUDBContext db = new UoUDBContext(); foreach (var classroom in db.RoomAllocations.Where(x => x.RecordStatus == 1).ToList()) { classroom.RecordStatus = 0; db.Entry(classroom).State = EntityState.Modified; } if (db.SaveChanges() > 0) { return(true); } return(false); }