public int GetTotalPoints(int courseID, int compID)
{
CourseInfo cInfo = new CourseInfo();
var CompScores = from cs in db.CompScores
join cp in db.CompPlayers on cs.CompPlayerID equals cp.CompPlayerID
join pr in db.Profiles on cp.UserID equals pr.UserID
join ur in db.Users on pr.UserID equals ur.UserID
where cs.CompID == compID && cs.CourseID == courseID && pr.HomeClubID == courseID
select new { cs.TotalPoints, cs.TeeColour, cs.SSS, cp.CompPlayerID };
int totalPoints = 0;
foreach (var item in CompScores)
{
totalPoints += Convert.ToInt32(item.TotalPoints) - (cInfo.GetCoursePar(courseID, item.TeeColour) - Convert.ToInt32(item.SSS));
}
return(totalPoints);
}
