public CountVote CalculateVoteCount(int postID)
{
CountVote coutnvote = null;
const string sql = "SELECT SUM(CASE WHEN IsUp=1 THEN 1 ELSE 0 END) UpVotes, SUM(CASE WHEN IsUp=0 THEN 1 ELSE 0 END) DownVotes FROM pf_PostVote WHERE PostID = @PostID GROUP BY PostID";
var count = 0;
_sqlObjectFactory.GetConnection().Using(c => c.Command(sql)
.AddParameter("@PostID", postID)
.ExecuteReader()
.ReadOne(r => coutnvote = new CountVote {
Votes = r.GetInt32(0), DownVotes = r.GetInt32(1)
}));
return(coutnvote);
}
public CountVote GetVoteCount(int postID)
{
CountVote coutnvote = null;
const string sql = "SELECT Votes,DownVotes FROM pf_Post WHERE PostID = @PostID";
var votes = 0;
_sqlObjectFactory.GetConnection().Using(c => c.Command(sql)
.AddParameter("@PostID", postID)
.ExecuteReader()
.ReadOne(r => coutnvote = new CountVote {
Votes = r.GetInt32(0), DownVotes = r.GetInt32(1)
}));
return(coutnvote);
}
