public void Save(MagicCard magicCard)
{
_connection
.GetConnection()
.Execute(
"INSERT INTO Prices ([BotGroupId],[CardId],[BuyPrice],[SellPrice],[OwnedAmount]) " +
"VALUES(@BotGroupId, @Id, @BuyPrice, @SellPrice, @OwnedAmount) ",
magicCard,
_connection.GetTransaction());
}
public MagicCard Get(MagicCard card)
{
return _connection.GetConnection().Query<MagicCard>(
"SELECT CardId as Id, c.CardName as Name, c.CardSet as [Set], c.Premium, 0 as BuyPrice, 0 as SellPrice, " +
"c.CardRarity as Rarity, c.MtgoCardId as MtgoId, 0 as OwnedAmount, c.CardSetNumber, @BotId as BotId, @BotGroupId as BotGroupId " +
"FROM Cards c " +
"WHERE c.MtgoCardId = @MtgoId OR (c.CardName = @Name AND c.CardSet = @Set AND c.Premium = @Premium)",
card,
_connection.GetTransaction())
.Single();
}
public void Update(MagicCard magicCard)
{
_connection
.GetConnection()
.Execute(
"UPDATE Prices " +
"SET BuyPrice = @BuyPrice, " +
"SellPrice = @SellPrice, " +
"OwnedAmount = @OwnedAmount " +
"WHERE BotGroupId = @BotGroupId " +
"AND CardId = @Id",
magicCard,
_connection.GetTransaction());
}
public void WriteToDatabase()
{
using (var connection = IoC.Resolve<IConnection>())
{
connection.BeginTransaction();
foreach (var magicCard in CollectionCards)
{
var dbCard = _magicCardRepository.Get(magicCard);
if (dbCard == null)
{
var card = new MagicCard(magicCard.Name, magicCard.Set, magicCard.Premium, magicCard.Rarity)
{BuyPrice = -1, SellPrice = 999, OwnedAmount = 0};
_magicCardRepository.Save(card);
_priceRepository.Save(card);
}
else
{
_magicCardRepository.Update(magicCard);
}
}
connection.CommitTransaction();
}
}
public void Update(MagicCard magicCard)
{
_connection
.GetConnection()
.Execute(
"UPDATE Cards " +
"SET CardName = @Name, " +
"CardSet = @Set, " +
"CardRarity = @Rarity, " +
"Premium = @Premium, " +
"MtgoCardId = @MtgoId " +
"WHERE CardId = @Id ",
magicCard,
_connection.GetTransaction());
}
public void Save(MagicCard magicCard)
{
_connection
.GetConnection()
.Execute(
"INSERT INTO Cards ([CardName],[CardSet],[CardRarity],[Premium],[MtgoCardId],[CardSetNumber]) " +
"VALUES(@Name, @Set, @Rarity, @Premium, @MtgoId, @CardSetNumber) ",
magicCard,
_connection.GetTransaction());
}