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()); } }