/// <summary>
/// Adds score and course details to existing student profile
/// </summary>
/// <param name="sId">student id</param>
/// <param name="cId">course id of course taken by student</param>
/// <param name="score">score obtained by student for particular course</param>
public static void AddStudentScore(int sId, int cId, int score)
{
var student = GetStudentByStudentId(sId);
var cs = new CourseScore
{
StudentId = sId,
CourseId = cId,
Score = score
};
db.CourseScores.Add(cs);
db.SaveChanges();
}
public static CourseScore UpdateCourseScore(CourseScore updatedCourseScore)
{
var oldCourseScore =
GetCourseScoreByScoreId(updatedCourseScore.Id);
oldCourseScore.StudentId = updatedCourseScore.StudentId;
oldCourseScore.CourseId = updatedCourseScore.CourseId;
oldCourseScore.Score = updatedCourseScore.Score;
db.SaveChanges();
return(oldCourseScore);
}