public static int Create(EntityDecision decision, string title, int order = 0)
=> ExecuteScalarInt(
@"INSERT INTO entity_decision_options(guid, decision_id, title, ""order"")
VALUES (@guid, @decision_id, @title, @order);
SELECT currval('entity_decision_options_id_seq');"
, new { guid = Guid.NewGuid().ToString(), decision_id = decision.id, title, order }
);
public static List <EntityDecisionOption> CreateMany(ushort amount, DecisionModel decision = null)
{
var result = new List <EntityDecisionOption>();
for (ushort i = 0; i < amount; i++)
{
result.Add(Create(decision));
}
return(result);
}
public static EntityDecisionOption[] Find(EntityDecision decision)
=> Connection().Query <EntityDecisionOption>(
"SELECT * FROM entity_decision_options WHERE decision_id = @decision_id LIMIT 10",
new { decision_id = decision.id }
).ToArray();
public static EntityDecisionOption Create(DecisionModel decision = null)
{
decision ??= EntityDecisionFaker.Create();
return(EntityDecisionOptionRepository.Create(decision, "option " + Rand.RandomString()));
}