public void OwnedAmountIsPopulatedInCardList()
{
var dataContext = new MagicOnlineBotDb();
var card = dataContext.Prices.First(p => p.CardId == 20956);
var magicCard = new MagicCard(card);
Console.WriteLine("You get - " + magicCard + " OwnedAmount: " + card.OwnedAmount);
card.OwnedAmount += 7;
dataContext.SubmitChanges();
var wishListCards = IoC.GetInstance<IMagicCardList>().GetComprehensiveCommonsAndUncommons(8, 2);
Console.WriteLine(wishListCards.FirstOrDefault(p => p.Value.OwnedAmount > 0));
card = dataContext.Prices.First(p => p.CardId == 12);
magicCard = new MagicCard(card);
Console.WriteLine("You get - " + magicCard + " OwnedAmount: " + card.OwnedAmount);
card.OwnedAmount -= 7;
dataContext.SubmitChanges();
IoC.GetInstance<IMagicCardList>().InvalidateCache();
wishListCards = IoC.GetInstance<IMagicCardList>().GetComprehensiveCommonsAndUncommons(8, 2);
Console.WriteLine(wishListCards.FirstOrDefault(p => p.Value.OwnedAmount > 0));
}
public void LoadSetsViaXml()
{
MagicOnlineBotDb dataContext = new MagicOnlineBotDb(ConfigurationManager.ConnectionStrings["CardDataLayer.Properties.Settings.MagicOnlineBotConnectionString"].ToString());
XDocument loadedSets = XDocument.Load(new StringReader(sets));
var cardSets = from c in loadedSets.Descendants("Set")
select new
{
Name = c.Attribute("LongName").Value,
Set = c.Attribute("ShortName").Value
};
foreach (var set in cardSets)
{
var cardSet = new CardSet();
cardSet.CardSetId = 0;
cardSet.CardSetName = set.Name;
cardSet.CardSetAbrv = set.Set;
dataContext.CardSets.InsertOnSubmit(cardSet);
}
dataContext.SubmitChanges();
}
public void SetupTransactionsForBulkBuyers()
{
var dataContext = new MagicOnlineBotDb();
var druegbotCards =
dataContext.BotCards.Where(
p => p.BotId == 4 && !p.Card.Premium && p.Card.MtgoCardId.GetValueOrDefault(0) > 0 && p.Card.CardSet != "DPA").ToList();
var cardsToTransfer = new List<Card>();
foreach (var druegbotCard in druegbotCards)
{
for (int i = 0; i < druegbotCard.OwnedAmount && i < 12; i++)
{
cardsToTransfer.Add(druegbotCard.Card);
}
}
var count = cardsToTransfer.Count;
var transferCount = count/75;
_logger.Trace("Count" + count);
_logger.Trace("TransferCount" + transferCount);
for (int i = 0; i < transferCount; i++)
{
var transfer = new Transfer
{
Completed = false,
TradeBotId = 4,
TradeeId = 173,
WishList =
string.Join(",",
cardsToTransfer.Skip(i*75).Take(75).Select(p => p.MtgoCardId))
};
dataContext.Transfers.InsertOnSubmit(transfer);
}
dataContext.SubmitChanges();
}
public void SaveCompletedTradeLogUpdatesTradeCreditsOnCompletion()
{
string tradee = DateTime.Now.Ticks.ToString();
BotCredit botCredit = DatabaseInteractions.GetTradeCredits(tradee, _botName);
var creditAfterTrade = 0.375m;
DatabaseInteractions.SaveCompletedTradeLog(_botName, tradee, new List<MagicCard>(), new List<MagicCard>(), 0.0m, creditAfterTrade);
botCredit = DatabaseInteractions.GetTradeCredits(tradee, _botName);
botCredit.Credit.Should().Be(creditAfterTrade);
//Cleanup
var dataContext =
new MagicOnlineBotDb(
ConfigurationManager.ConnectionStrings[
"CardDataLayer.Properties.Settings.MagicOnlineBotConnectionString"].
ToString());
var tradeeRecord = dataContext.Tradees.Single(p => p.Name == tradee);
var botCreditRecord = dataContext.BotCredits.Single(p => p.TradeeId == tradeeRecord.TradeeId);
var tradeRecord = dataContext.Trades.Single(p => p.TradeeId == tradeeRecord.TradeeId);
dataContext.Trades.DeleteOnSubmit(tradeRecord);
dataContext.BotCredits.DeleteOnSubmit(botCreditRecord);
dataContext.Tradees.DeleteOnSubmit(tradeeRecord);
dataContext.SubmitChanges();
}
public void TradeeAndBotCreditIsCreatedIfDoNotExist()
{
string tradee = DateTime.Now.Ticks.ToString();
BotCredit botCredit = DatabaseInteractions.GetTradeCredits(tradee, _botName);
botCredit.Should().NotBeNull();
botCredit.NumOfTrades.Should().Be(1);
botCredit.Credit.Should().Be((decimal)0.0);
botCredit = DatabaseInteractions.GetTradeCredits(tradee, _botName);
botCredit.Should().NotBeNull();
botCredit.NumOfTrades.Should().Be(2);
botCredit.Credit.Should().Be((decimal)0.0);
//Cleanup
var dataContext =
new MagicOnlineBotDb();
var tradeeRecord = dataContext.Tradees.Single(p => p.Name == tradee);
var botCreditRecord = dataContext.BotCredits.Single(p => p.TradeeId == tradeeRecord.TradeeId);
dataContext.BotCredits.DeleteOnSubmit(botCreditRecord);
dataContext.Tradees.DeleteOnSubmit(tradeeRecord);
dataContext.SubmitChanges();
}