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);
}
}
}
