public void DeleteSetAndAssociatedCards(Set set)
{
var setId = ExecuteScalarValueQuery<long>(setSchemaBuilder.BuildSelectQuery(new[] {nameof(Set.SetId)},
setSchemaBuilder.CreateCondition(nameof(Set.Code), ConditionOperator.Equals, set),
1));
ExecuteNonQuery(setSchemaBuilder.BuildDeleteQuery(
setSchemaBuilder.CreateCondition(nameof(Set.SetId), ConditionOperator.Equals, set)));
ExecuteNonQuery(cardSchemaBuilder.BuildDeleteQuery(
cardSchemaBuilder.CreateCondition(nameof(Card.Set), ConditionOperator.Equals, set)));
}
public IEnumerable <CollectedCard> GetCollection()
{
return(ExecuteReader(collectionSchema.BuildSelectQuery(new[]
{
nameof(CollectedCard.Id),
nameof(CollectedCard.Name),
nameof(CollectedCard.CardQuality),
nameof(CollectedCard.Foil),
nameof(CollectedCard.MultiverseId),
nameof(CollectedCard.SetCode),
nameof(CollectedCard.SetName),
}),
reader =>
{
var id = reader.GetString(0);
var name = reader.GetString(1);
var cardQuality = (CardQuality)reader.GetInt32(2);
var foil = reader.GetBoolean(3);
var multiverseId = reader.GetInt32(4);
var setCode = reader.GetString(5);
var setName = reader.GetString(6);
return new CollectedCard(id,
name,
cardQuality,
foil,
multiverseId,
setCode,
setName);
}));
}
