private void CalculateScore() { Vote vote = Vote.Select(String.Format("USERACCOUNTID = {0} AND FILEID = {1}", _userAccount.Id.ToSqlFormat(), _file.Id)).FirstOrDefault(); int positiveVotes = Vote.Count(String.Format("FILEID = {0} AND VOTETYPE = 'Y'", _file.Id.ToSqlFormat())); int negativeVotes = Vote.Count(String.Format("FILEID = {0} AND VOTETYPE = 'N'", _file.Id.ToSqlFormat())); Debug.WriteLine("{0} - {1}", positiveVotes, negativeVotes); if (vote != null) { bool currentVote = vote.Type; if (currentVote) { View.LabelScore.ForeColor = Color.Green; } else { View.LabelScore.ForeColor = Color.Red; } } View.LabelScore.Text = (positiveVotes - negativeVotes).ToString(); }