public void RecordVote(int commentid, byte vote, int userid)
{
// check to see whether we already have this vote
var thevote = DB.CommentVotes.SingleOrDefault(v =>
v.CommentId == commentid &&
v.UserId == userid
);
if (thevote != null)
{
// update the sucker
thevote.Vote = vote;
}
else
{
// create new one
thevote = new CommentVote()
{
CommentId = commentid,
Date = DateTime.Now,
UserId = userid,
Vote = vote
};
DB.CommentVotes.InsertOnSubmit(thevote);
}
DB.SubmitChanges();
}
private void detach_CommentVotes(CommentVote entity)
{
this.SendPropertyChanging();
entity.User = null;
}
private void attach_CommentVotes(CommentVote entity)
{
this.SendPropertyChanging();
entity.User = this;
}
partial void DeleteCommentVote(CommentVote instance);
partial void UpdateCommentVote(CommentVote instance);
partial void InsertCommentVote(CommentVote instance);
