public IEnumerable <StudentCourse> UpdateScore(Guid courseId, CourseScoreViewModel scoreData)
{
var dbStudentCourses = db.StudentCourses.Where(sc => sc.CourseId.Equals(courseId));
foreach (var updateData in scoreData.StudentScoreData)
{
foreach (var dbData in dbStudentCourses)
{
if (dbData.StudentId == updateData.Key)
{
dbData.Score = updateData.Value;
dbData.LastModifiedDate = DateTime.Now.ToString("yyyy/MM/dd");
dbData.LastModifiedBy = scoreData.Modifier;
}
}
}
db.SaveChanges();
return(db.StudentCourses.Where(sc => sc.CourseId.Equals(courseId)).ToList());
}
// GET: Scores
public async Task <IActionResult> Index(int?id) // Passing in courseId
{
var scores = from score in _scoreContext.Score
select score;
if (!id.HasValue)
{
scores = scores.Where(score => score.CourseId == id);
}
var courses = from course in _courseContext.Course
select course;
CourseScoreViewModel vm = new CourseScoreViewModel
{
Scores = await scores.ToListAsync(),
Course = await courses.FirstOrDefaultAsync()
};
return(View(vm));
}
public IEnumerable <StudentCourse> UpdateScore([FromRoute] Guid id, [FromBody] CourseScoreViewModel scoreData)
{
return(repo.UpdateScore(id, scoreData));
}
