void IterateThroughSet(string setName) { var cards = DatabaseManager.GetAllCardsForSet(setName); foreach (DataRow card in cards.Rows) { var name = card[3].ToString(); var stringID = card[17].ToString(); var multiverseID = -1; if (!String.IsNullOrWhiteSpace(stringID)) { multiverseID = Int32.Parse(stringID); } double timeLastUpdated = double.Parse(card[23].ToString()); GetImageForCard(0); if (PriceOldEnoughToUpdate(timeLastUpdated) || float.Parse(card[19].ToString()) < 0 || float.Parse(card[21].ToString()) < 0) { UpdatePriceOfCard(name, setName); } if (multiverseID != -1) { GetImageForCard(multiverseID); } } }
void UpdateCardInSet(string set, JObject setData) { DatabaseManager.LockSet(set.Replace("'", "''")); var cardList = DatabaseManager.GetAllCardsForSet(set.Replace("'", "''")); var json = setData["prints"]; foreach (var card in json) { var id = card["id"].ToString(); var name = card["name"].ToString(); var cardObject = GetMTGStocksData(id); var cardData = ParseCardData(cardObject, set); var prices = GetPriceFromData(cardData); DatabaseManager.UpdatePrice(name, set, prices["price"], false); DatabaseManager.UpdatePrice(name, set, prices["foilPrice"], true); } Logger.LogActivity("Updated price of cards in set:" + set); DatabaseManager.UnlockSet(set.Replace("'", "''")); }