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