public void Delete(Legalities legalities) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "delete from legalities where id = @id"; sqlCommand.Parameters.AddWithValue("@id", legalities.Id); Db.Execute(sqlCommand); }
public List <Legalities> SelectAll() { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "select * from legalities"; SqlDataReader sqlDataReader = Db.Select(sqlCommand); List <Legalities> listLegalities = new List <Legalities>(); if (sqlDataReader.HasRows) { while (sqlDataReader.Read()) { Legalities legalities = new Legalities(); legalities.Id = (Int32)sqlDataReader["id"]; legalities.Standard = (String)sqlDataReader["standard"]; legalities.Future = (String)sqlDataReader["future"]; legalities.Historic = (String)sqlDataReader["historic"]; legalities.Pioneer = (String)sqlDataReader["pioneer"]; legalities.Modern = (String)sqlDataReader["modern"]; legalities.Legacy = (String)sqlDataReader["legacy"]; legalities.Pauper = (String)sqlDataReader["pauper"]; legalities.Vintage = (String)sqlDataReader["vintage"]; legalities.Penny = (String)sqlDataReader["penny"]; legalities.Commander = (String)sqlDataReader["commander"]; legalities.Brawl = (String)sqlDataReader["brawl"]; legalities.Duel = (String)sqlDataReader["duel"]; legalities.Oldschool = (String)sqlDataReader["oldschool"]; listLegalities.Add(legalities); } sqlDataReader.Read(); return(listLegalities); } else { return(null); } }
public void Update(Legalities legalities) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "update legalities set " + "standard = @standard, " + "future = @future, " + "historic = @historic, " + "pioneer = @pioneer, " + "modern = @modern, " + "legacy = @legacy, " + "pauper = @pauper, " + "vintage = @vintage, " + "penny = @penny, " + "commander = @commander, " + "brawl = @brawl, " + "duel = @duel, " + "oldschool = @oldschool " + "where id = @id"; sqlCommand.Parameters.AddWithValue("@id", legalities.Id); sqlCommand.Parameters.AddWithValue("@standard", legalities.Standard); sqlCommand.Parameters.AddWithValue("@future", legalities.Future); sqlCommand.Parameters.AddWithValue("@historic", legalities.Historic); sqlCommand.Parameters.AddWithValue("@pioneer", legalities.Pioneer); sqlCommand.Parameters.AddWithValue("@modern", legalities.Modern); sqlCommand.Parameters.AddWithValue("@legacy", legalities.Legacy); sqlCommand.Parameters.AddWithValue("@pauper", legalities.Pauper); sqlCommand.Parameters.AddWithValue("@vintage", legalities.Vintage); sqlCommand.Parameters.AddWithValue("@penny", legalities.Penny); sqlCommand.Parameters.AddWithValue("@commander", legalities.Commander); sqlCommand.Parameters.AddWithValue("@brawl", legalities.Brawl); sqlCommand.Parameters.AddWithValue("@duel", legalities.Duel); sqlCommand.Parameters.AddWithValue("@oldschool", legalities.Oldschool); Db.Execute(sqlCommand); }
public Legalities SelectById(Int32 id) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "select * from legalities where id = @id"; sqlCommand.Parameters.AddWithValue("@id", id); SqlDataReader sqlDataReader = Db.Select(sqlCommand); Legalities legalities = new Legalities(); if (sqlDataReader.HasRows) { sqlDataReader.Read(); legalities.Id = (Int32)sqlDataReader["id"]; legalities.Standard = (String)sqlDataReader["standard"]; legalities.Future = (String)sqlDataReader["future"]; legalities.Historic = (String)sqlDataReader["historic"]; legalities.Pioneer = (String)sqlDataReader["pioneer"]; legalities.Modern = (String)sqlDataReader["modern"]; legalities.Legacy = (String)sqlDataReader["legacy"]; legalities.Pauper = (String)sqlDataReader["pauper"]; legalities.Vintage = (String)sqlDataReader["vintage"]; legalities.Penny = (String)sqlDataReader["penny"]; legalities.Commander = (String)sqlDataReader["commander"]; legalities.Brawl = (String)sqlDataReader["brawl"]; legalities.Duel = (String)sqlDataReader["duel"]; legalities.Oldschool = (String)sqlDataReader["oldschool"]; return(legalities); } else { return(null); } }
public void Insert(Legalities legalities) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "insert into legalities (standard, future, historic, pioneer, modern, legacy, pauper, vintage, penny, commander, brawl, duel, oldschool) " + "values (@standard, @future, @historic, @pioneer, @modern, @legacy, @pauper, @vintage, @penny, @commander, @brawl, @duel, @oldschool)"; sqlCommand.Parameters.AddWithValue("@standard", legalities.Standard); sqlCommand.Parameters.AddWithValue("@future", legalities.Future); sqlCommand.Parameters.AddWithValue("@historic", legalities.Historic); sqlCommand.Parameters.AddWithValue("@pioneer", legalities.Pioneer); sqlCommand.Parameters.AddWithValue("@modern", legalities.Modern); sqlCommand.Parameters.AddWithValue("@legacy", legalities.Legacy); sqlCommand.Parameters.AddWithValue("@pauper", legalities.Pauper); sqlCommand.Parameters.AddWithValue("@vintage", legalities.Vintage); sqlCommand.Parameters.AddWithValue("@penny", legalities.Penny); sqlCommand.Parameters.AddWithValue("@commander", legalities.Commander); sqlCommand.Parameters.AddWithValue("@brawl", legalities.Brawl); sqlCommand.Parameters.AddWithValue("@duel", legalities.Duel); sqlCommand.Parameters.AddWithValue("@oldschool", legalities.Oldschool); Db.Execute(sqlCommand); }
public ConvertCard ConvertScryCard(Card scryCard) { var completeCard = new ConvertCard { ScryId = scryCard.Id, OracleId = scryCard.OracleId, OracleText = scryCard.OracleText, Power = scryCard.Power, Loyalty = scryCard.Loyalty, Toughness = scryCard.Toughness, Name = scryCard.Name, Lang = scryCard.Lang, ReleasedAt = scryCard.ReleasedAt, Uri = scryCard.Uri?.ToString(), ScryfallUri = scryCard.ScryfallUri?.ToString(), Layout = scryCard.Layout, HighresImage = scryCard.HighresImage, ManaCost = scryCard.ManaCost, Cmc = scryCard.Cmc, TypeLine = scryCard.TypeLine, Reserved = scryCard.Reserved, Foil = scryCard.Foil, Nonfoil = scryCard.Nonfoil, Oversized = scryCard.Oversized, Promo = scryCard.Promo, Reprint = scryCard.Reprint, Variation = scryCard.Variation, Set = scryCard.Set, SetName = scryCard.SetName, SetType = scryCard.SetType, SetUri = scryCard.ScryfallSetUri?.ToString(), SetSearchUri = scryCard.SetSearchUri?.ToString(), ScryfallSetUri = scryCard.ScryfallSetUri?.ToString(), RulingsUri = scryCard.RulingsUri?.ToString(), PrintsSearchUri = scryCard.PrintsSearchUri?.ToString(), CollectorNumber = (long)Convert.ToDouble(scryCard.CollectorNumber), Digital = scryCard.Digital, Rarity = scryCard.Rarity, CardBackId = scryCard.CardBackId, Artist = scryCard.Artist, IllustrationId = scryCard.IllustrationId, BorderColor = scryCard.BorderColor, Frame = scryCard.Frame, FullArt = scryCard.FullArt, Textless = scryCard.Textless, Booster = scryCard.Booster, StorySpotlight = scryCard.StorySpotlight, EdhrecRank = scryCard.EdhrecRank, MultiverseIds = scryCard.MultiverseIds, Colors = scryCard.Colors, ColorIdentity = scryCard.ColorIdentity, Games = scryCard.Games, ArtistIds = scryCard.ArtistIds }; List <ConvertCardFace> cardFaces = new List <ConvertCardFace>(); List <CardFace> scryCardFaces = scryCard.CardFaces; if (scryCardFaces != null) { foreach (var cardFace in scryCardFaces) { ConvertCardFace completeCardFace = new ConvertCardFace { Object = cardFace.Object, Name = cardFace.Name, PrintedName = cardFace.PrintedName, ManaCost = cardFace.ManaCost, Loyalty = cardFace.Loyalty, Power = cardFace.Power, FlavorText = cardFace.FlavorText, TypeLine = cardFace.TypeLine, PrintedTypeLine = cardFace.PrintedTypeLine, OracleText = cardFace.OracleText, PrintedText = cardFace.PrintedText, Artist = cardFace.Artist, ArtistId = cardFace.ArtistId, }; CardFaceImageUris scryCardFaceImageUris = cardFace.CardFaceImageUris; if (scryCardFaceImageUris != null) { ConvertCardCardFaceImageUris imageUris = new ConvertCardCardFaceImageUris { Small = scryCardFaceImageUris.Small?.ToString(), Normal = scryCardFaceImageUris.Normal?.ToString(), Large = scryCardFaceImageUris.Large?.ToString(), Png = scryCardFaceImageUris.Png?.ToString(), ArtCrop = scryCardFaceImageUris.ArtCrop?.ToString(), BorderCrop = scryCardFaceImageUris.BorderCrop?.ToString() }; completeCardFace.CardFaceImageUris = imageUris; } cardFaces.Add(completeCardFace); } } completeCard.CardFaces = cardFaces; Legalities scryCardLegalities = scryCard.Legalities; if (scryCardLegalities != null) { ConvertCardLegalities completeLegalities = new ConvertCardLegalities { Standard = scryCardLegalities.Standard, Future = scryCardLegalities.Future, Historic = scryCardLegalities.Historic, Pioneer = scryCardLegalities.Pioneer, Modern = scryCardLegalities.Modern, Legacy = scryCardLegalities.Legacy, Pauper = scryCardLegalities.Pauper, Vintage = scryCardLegalities.Vintage, Penny = scryCardLegalities.Penny, Commander = scryCardLegalities.Commander, Brawl = scryCardLegalities.Brawl, Duel = scryCardLegalities.Duel, Oldschool = scryCardLegalities.Oldschool }; completeCard.Legalities = completeLegalities; } Prices scryCardPrices = scryCard.Prices; if (scryCardPrices != null) { ConvertCardPrices completePrices = new ConvertCardPrices { Usd = scryCardPrices.Usd?.ToString(), UsdFoil = scryCardPrices.UsdFoil?.ToString(), Eur = scryCardPrices.Eur?.ToString(), Tix = scryCardPrices.Tix?.ToString() }; completeCard.Prices = completePrices; } RelatedUris scryCardRelatedUris = scryCard.RelatedUris; if (scryCardRelatedUris != null) { ConvertCardRelatedUris completeRelatedUris = new ConvertCardRelatedUris { Gatherer = scryCardRelatedUris.Gatherer?.ToString(), TcgplayerDecks = scryCardRelatedUris.TcgplayerDecks?.ToString(), Edhrec = scryCardRelatedUris.Edhrec?.ToString(), Mtgtop8 = scryCardRelatedUris.Mtgtop8?.ToString() }; completeCard.RelatedUris = completeRelatedUris; } ImageUris scryCardImageUris = scryCard.ImageUris; if (scryCardImageUris != null) { ConvertCardImageUris completeImageUris = new ConvertCardImageUris { Small = scryCardImageUris.Small?.ToString(), Normal = scryCardImageUris.Normal?.ToString(), Large = scryCardImageUris.Large?.ToString(), Png = scryCardImageUris.Png?.ToString(), ArtCrop = scryCardImageUris.ArtCrop?.ToString(), BorderCrop = scryCardImageUris.BorderCrop?.ToString() }; completeCard.ImageUris = completeImageUris; } PurchaseUris scryCardPurchaseUris = scryCard.PurchaseUris; if (scryCardPurchaseUris != null) { ConvertCardPurchaseUris completePurchaseUris = new ConvertCardPurchaseUris { Tcgplayer = scryCardPurchaseUris.Tcgplayer?.ToString(), Cardmarket = scryCardPurchaseUris.Cardmarket?.ToString(), Cardhoarder = scryCardPurchaseUris.Cardhoarder?.ToString() }; completeCard.PurchaseUris = completePurchaseUris; } return(completeCard); }
internal void LinkCardLists(Card scryCard, Guid userCardId) { using (var db = new SqlConnection(_connectionString)) { var multiverseIds = scryCard.MultiverseIds; if (multiverseIds != null) { foreach (var multiverseId in multiverseIds) { var sql = @"INSERT INTO [MultiverseIds] ( [CardId], [MultiverseId] ) VALUES ( @cardId, @multiverseId )"; var parameters = new { CardId = userCardId, MultiverseId = multiverseId }; db.Execute(sql, parameters); } } var colors = scryCard.Colors; if (colors != null) { foreach (var color in colors) { var sql = @"INSERT INTO [Colors] ( [CardId], [Color] ) VALUES ( @cardId, @color )"; var parameters = new { CardId = userCardId, Color = color }; db.Execute(sql, parameters); } } var colorIdentity = scryCard.ColorIdentity; if (colorIdentity != null) { foreach (var colorId in colorIdentity) { var sql = @"INSERT INTO [ColorIdentity] ( [CardId], [Color] ) VALUES ( @cardId, @color )"; var parameters = new { CardId = userCardId, Color = colorId }; db.Execute(sql, parameters); } } var games = scryCard.Games; if (games != null) { foreach (var game in games) { var sql = @"INSERT INTO [Games] ( [CardId], [Game] ) VALUES ( @cardId, @game )"; var parameters = new { CardId = userCardId, Game = game }; db.Execute(sql, parameters); } } var artistIds = scryCard.ArtistIds; if (artistIds != null) { foreach (var artistId in artistIds) { var sql = @"INSERT INTO [ArtistIds] ( [CardId], [ArtistId] ) VALUES ( @cardId, @artistId )"; var parameters = new { CardId = userCardId, ArtistId = artistId }; db.Execute(sql, parameters); } } var cardFaces = scryCard.CardFaces; if (cardFaces != null) { foreach (var cardFace in cardFaces) { var sql = @"INSERT INTO [CardFace] ( [CardId], [Object], [Name], [PrintedName], [ManaCost], [Loyalty], [Power], [FlavorText], [TypeLine], [PrintedTypeLine], [OracleText], [PrintedText], [Artist], [ArtistId], [IllustrationId] ) VALUES ( @cardId, @object, @name, @printedName, @manaCost, @loyalty, @power, @flavorText, @typeLine, @printedTypeLine, @oracleText, @printedText, @artist, @artistId, @illustrationId )"; var parameters = new { CardId = userCardId, Object = cardFace.Object, Name = cardFace.Name, PrintedName = cardFace.PrintedName, ManaCost = cardFace.ManaCost, Loyalty = cardFace.Loyalty, Power = cardFace.Power, FlavorText = cardFace.FlavorText, TypeLine = cardFace.TypeLine, PrintedTypeLine = cardFace.PrintedTypeLine, OracleText = cardFace.OracleText, PrintedText = cardFace.PrintedText, Artist = cardFace.Artist, ArtistId = cardFace.ArtistId, IllustrationId = cardFace.IllustrationId }; db.Execute(sql, parameters); } } if (cardFaces != null) { var sql = @"SELECT * FROM [CardFace] WHERE [CardId] = @cardId"; var dbCardFaces = db.Query <CompleteCardFace>(sql, new { CardId = userCardId })?.AsList(); if (dbCardFaces != null) { var i = 0; foreach (var cardFace in dbCardFaces) { if (cardFace != null) { if (scryCard.CardFaces[i] != null) { CardFaceImageUris CFImages = scryCard.CardFaces[i].CardFaceImageUris; //CardFaceImageUris CFImages = new CardFaceImageUris(); // CFImages = cardFaceImageUris; if (CFImages != null) { var cardFaceImageUriSql = @"INSERT INTO [CardFaceImageUris] ( [CardFaceId], [Small], [Normal], [Large], [Png], [ArtCrop], [BorderCrop] ) VALUES ( @cardFaceId, @small, @normal, @large, @png, @artCrop, @borderCrop )"; var cardFaceParams = new { CardFaceId = cardFace.Id, Small = CFImages.Small?.ToString(), Normal = CFImages.Normal?.ToString(), Large = CFImages.Large?.ToString(), Png = CFImages.Png?.ToString(), ArtCrop = CFImages.ArtCrop?.ToString(), BorderCrop = CFImages.BorderCrop?.ToString() }; db.Execute(cardFaceImageUriSql, cardFaceParams); i++; } } } } } } Legalities legalities = scryCard.Legalities; if (legalities != null) { var legalitiesSql = @"INSERT INTO [Legalities] ( [CardId], [Standard], [Future], [Historic], [Pioneer], [Modern], [Legacy], [Pauper], [Vintage], [Penny], [Commander], [Brawl], [Duel], [Oldschool] ) VALUES ( @cardId, @standard, @future, @historic, @pioneer, @modern, @legacy, @pauper, @vintage, @penny, @commander, @brawl, @duel, @oldschool )"; var legalitiesParameters = new { CardId = userCardId, Standard = legalities.Standard, Future = legalities.Future, Historic = legalities.Historic, Pioneer = legalities.Pioneer, Modern = legalities.Modern, Legacy = legalities.Legacy, Pauper = legalities.Pauper, Vintage = legalities.Vintage, Penny = legalities.Penny, Commander = legalities.Commander, Brawl = legalities.Brawl, Duel = legalities.Duel, Oldschool = legalities.Oldschool, }; db.Execute(legalitiesSql, legalitiesParameters); } Prices prices = scryCard.Prices; if (prices != null) { var pricesSql = @"INSERT INTO [Prices] ( [CardId], [Usd], [UsdFoil], [Eur], [Tix] ) VALUES ( @cardId, @usd, @usdFoil, @eur, @tix )"; var pricesParameters = new { CardId = userCardId, Usd = prices.Usd?.ToString(), UsdFoil = prices.UsdFoil?.ToString(), Eur = prices.Eur?.ToString(), Tix = prices.Tix?.ToString() }; db.Execute(pricesSql, pricesParameters); } RelatedUris relatedUris = scryCard.RelatedUris; if (relatedUris != null) { var relatedUrisSql = @"INSERT INTO [RelatedUris] ( [CardId], [Gatherer], [TcgplayerDecks], [Edhrec], [Mtgtop8] ) VALUES ( @cardId, @gatherer, @tcgplayerDecks, @edhrec, @mtgtop8 )"; var relatedUrisParameters = new { CardId = userCardId, Gatherer = relatedUris.Gatherer?.ToString(), TcgplayerDecks = relatedUris.TcgplayerDecks?.ToString(), Edhrec = relatedUris.Edhrec?.ToString(), Mtgtop8 = relatedUris.Mtgtop8?.ToString() }; db.Execute(relatedUrisSql, relatedUrisParameters); } ImageUris imageUris = scryCard.ImageUris; if (imageUris != null) { var imageUrisSql = @"INSERT INTO [ImageUris] ( [CardId], [Small], [Normal], [Large], [Png], [ArtCrop], [BorderCrop] ) VALUES ( @cardId, @small, @normal, @large, @png, @artCrop, @borderCrop )"; var imageUriParameters = new { CardId = userCardId, Small = imageUris.Small?.ToString(), Normal = imageUris.Normal?.ToString(), Large = imageUris.Large?.ToString(), Png = imageUris.Png?.ToString(), ArtCrop = imageUris.ArtCrop?.ToString(), BorderCrop = imageUris.BorderCrop?.ToString() }; db.Execute(imageUrisSql, imageUriParameters); } PurchaseUris purchaseUris = scryCard.PurchaseUris; if (purchaseUris != null) { var purchaseUrisSql = @"INSERT INTO [PurchaseUris] ( [CardId], [Tcgplayer], [Cardmarket], [Cardhoarder] ) VALUES ( @cardId, @tcgplayer, @cardmarket, @cardhoarder )"; var puchaseUriParameters = new { CardId = userCardId, Tcgplayer = purchaseUris.Tcgplayer?.ToString(), Cardmarket = purchaseUris.Cardmarket?.ToString(), Cardhoarder = purchaseUris.Cardhoarder?.ToString() }; db.Execute(purchaseUrisSql, puchaseUriParameters); } } }