public ImageUris SelectById(Int32 id) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "select * from image_uris where id = @id"; sqlCommand.Parameters.AddWithValue("@id", id); SqlDataReader sqlDataReader = Db.Select(sqlCommand); ImageUris imageUris = new ImageUris(); if (sqlDataReader.HasRows) { sqlDataReader.Read(); imageUris.Id = (Int32)sqlDataReader["id"]; imageUris.Small = (String)sqlDataReader["small"]; imageUris.Normal = (String)sqlDataReader["normal"]; imageUris.Large = (String)sqlDataReader["large"]; imageUris.Png = (String)sqlDataReader["png"]; imageUris.ArtCrop = (String)sqlDataReader["art_crop"]; imageUris.BorderCrop = (String)sqlDataReader["border_crop"]; return(imageUris); } else { return(null); } }
public List <ImageUris> SelectAll() { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "select * from image_uris"; SqlDataReader sqlDataReader = Db.Select(sqlCommand); List <ImageUris> listImageUris = new List <ImageUris>(); if (sqlDataReader.HasRows) { while (sqlDataReader.Read()) { ImageUris imageUris = new ImageUris(); imageUris.Id = (Int32)sqlDataReader["id"]; imageUris.Small = (String)sqlDataReader["small"]; imageUris.Normal = (String)sqlDataReader["normal"]; imageUris.Large = (String)sqlDataReader["large"]; imageUris.Png = (String)sqlDataReader["png"]; imageUris.ArtCrop = (String)sqlDataReader["art_crop"]; imageUris.BorderCrop = (String)sqlDataReader["border_crop"]; listImageUris.Add(imageUris); } sqlDataReader.Read(); return(listImageUris); } else { return(null); } }
public void Delete(ImageUris imageUris) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "delete from image_uris where id = @id"; sqlCommand.Parameters.AddWithValue("@id", imageUris.Id); Db.Execute(sqlCommand); }
public void Insert(ImageUris imageUris) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "insert into image_uris (small, normal, large, png, art_crop, border_crop) values (@small, @normal, @large, @png, @art_crop, @border_crop)"; sqlCommand.Parameters.AddWithValue("@small", imageUris.Small); sqlCommand.Parameters.AddWithValue("@normal", imageUris.Normal); sqlCommand.Parameters.AddWithValue("@large", imageUris.Large); sqlCommand.Parameters.AddWithValue("@png", imageUris.Png); sqlCommand.Parameters.AddWithValue("@art_crop", imageUris.ArtCrop); sqlCommand.Parameters.AddWithValue("@border_crop", imageUris.BorderCrop); Db.Execute(sqlCommand); }
public void Update(ImageUris imageUris) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "update image_uris set small = @small, normal = @normal, large = @large, png = @png, art_crop = @art_crop, border_crop = @border_crop where id = @id"; sqlCommand.Parameters.AddWithValue("@id", imageUris.Id); sqlCommand.Parameters.AddWithValue("@small", imageUris.Small); sqlCommand.Parameters.AddWithValue("@normal", imageUris.Normal); sqlCommand.Parameters.AddWithValue("@large", imageUris.Large); sqlCommand.Parameters.AddWithValue("@png", imageUris.Png); sqlCommand.Parameters.AddWithValue("@art_crop", imageUris.ArtCrop); sqlCommand.Parameters.AddWithValue("@border_crop", imageUris.BorderCrop); 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); } } }