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