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