public void Save(IConnection connection)
{
if (BotCardId == 0)
{
connection
.GetConnection()
.Execute(
"INSERT INTO BotCards ([BotId],[CardId],[OwnedAmount]) " +
"VALUES(@BotId, @CardId, @OwnedAmount) ",
this,
connection.GetTransaction());
}
else
{
connection
.GetConnection()
.Execute(
"UPDATE BotCards " +
"SET [BotId] = @BotId," +
"[CardId] = @CardId," +
"[OwnedAmount] = @OwnedAmount " +
"WHERE BotCardId = @BotCardId ",
this,
connection.GetTransaction());
}
}
public void Save(IConnection connection)
{
connection
.GetConnection()
.Execute(
"INSERT INTO [TradeDetail] ([TradeId],[CardId],[NumberOfCard],[Price],[Buying]) " +
"VALUES(@TradeId, @CardId, @NumberOfCard, @Price, @Buying) ",
this,
connection.GetTransaction());
}
public void Save(IConnection connection)
{
connection
.GetConnection()
.Execute(
"INSERT INTO TradeeCards ([TradeeId],[CardId],[NumberOfCard],[FoundAt]) " +
"VALUES(@TradeeId, @CardId, @NumberOfCard, @FoundAt) ",
this,
connection.GetTransaction());
}
public void Save(IConnection connection)
{
if (Id == 0)
{
connection
.GetConnection()
.Execute(
"INSERT INTO Cards ([CardName],[CardSet],[CardRarity],[Premium],[MtgoCardId],[CardSetNumber]) " +
"VALUES(@Name, @Set, @Rarity, @Premium, @MtgoId, @CardSetNumber) ",
this,
connection.GetTransaction());
connection
.GetConnection()
.Execute(
"INSERT INTO Prices ([BotGroupId],[CardId],[BuyPrice],[SellPrice],[OwnedAmount]) " +
"VALUES(@BotGroupId, @Id, @BuyPrice, @SellPrice, @OwnedAmount) ",
this,
connection.GetTransaction());
}
else
{
connection
.GetConnection()
.Execute(
"UPDATE Cards " +
"SET CardName = @Name, " +
"CardSet = @Set, " +
"CardRarity = @Rarity, " +
"Premium = @Premium, " +
"MtgoCardId = @MtgoId " +
"WHERE CardId = @Id ",
this,
connection.GetTransaction());
connection
.GetConnection()
.Execute(
"UPDATE Prices " +
"SET BuyPrice = @BuyPrice, " +
"SellPrice = @SellPrice, " +
"OwnedAmount = @OwnedAmount " +
"WHERE BotGroupId = @BotGroupId " +
"AND CardId = @Id",
this,
connection.GetTransaction());
}
}
