public double FindTeamVotes(int questionID, string teamName) { using (DB_YoungEnterpriseContext databaseContext = GetConnection()) { double result = 0; var voteAnswer = databaseContext.TblVoteAnswer .Where(va => va.FldQuestion.FldQuestionId == questionID && va.FldVote.FldTeamName == teamName ) .FirstOrDefault(); if (voteAnswer == null) { result = 0; } else { databaseContext.Entry(voteAnswer).Reference(va => va.FldVote).Load(); result = voteAnswer.FldVote.FldPoints; } return(result); } }
public TblVote FindJudgePairVotes(int questionID, int judgePairId, string teamName) { using (DB_YoungEnterpriseContext databaseContext = GetConnection()) { TblVote result = null; var voteAnswer = databaseContext.TblVoteAnswer .Where(va => va.FldQuestion.FldQuestionId == questionID && va.FldVote.FldJudgePairId == judgePairId && va.FldVote.FldTeamName == teamName ) .FirstOrDefault(); if (voteAnswer == null) { result = null; } else { databaseContext.Entry(voteAnswer).Reference(va => va.FldVote).Load(); result = voteAnswer.FldVote; } return(result); } }