public static int Create(UserModel user, EntityDecisionOption option, int votepower)
=> ExecuteScalarInt(
@"INSERT INTO entity_decision_votes(guid, user_id, option_id, votepower)
VALUES (@guid, @user_id, @option_id, @votepower);
SELECT currval('entity_decision_votes_id_seq');"
, new { guid = Guid.NewGuid().ToString(), user_id = user.id, option_id = option.id, votepower }
);
public static EntityDecisionVote Find(UserModel user, EntityDecisionOption option)
=> Connection().Query <EntityDecisionVote>(
"SELECT * FROM entity_decision_votes WHERE user_id = @user_id AND option_id = @option_id LIMIT 1",
new { user_id = user.id, option_id = option.id }
).FirstOrDefault();
