private ScryfallCard FetchRandomCard()
{
ScryfallCard card;
try
{
System.Threading.Thread.Sleep(100);
string responseContent = string.Empty;
HttpResponseMessage response = client.GetAsync("cards/random").Result;
response.EnsureSuccessStatusCode();
responseContent = response.Content.ReadAsStringAsync().Result;
card = ScryfallCard.FromJson(responseContent);
SqlCeCommand cmd = new SqlCeCommand("SELECT * FROM CARD WHERE [id] like \'" + card.id + "\'", db.connection);
SqlCeDataAdapter da = new SqlCeDataAdapter(cmd);
DataTable result = new DataTable();
da.Fill(result);
if (result.Rows.Count == 0)
{
card.SaveToDB(db);
}
}
catch (Exception ex)
{
throw;
}
return(card);
}
public ScryfallCard FetchCardByID(string text)
{
System.Threading.Thread.Sleep(100);
ScryfallCard retval = new ScryfallCard();
HttpResponseMessage response;
string responseContent = string.Empty;
response = client.GetAsync("cards/" + text).Result;
response.EnsureSuccessStatusCode();
responseContent = response.Content.ReadAsStringAsync().Result;
retval = ScryfallCard.FromJson(responseContent);
return(retval);
}
private ScryfallCard FetchNamedCardExact(string text)
{
ScryfallCard retval = null;
try
{
System.Threading.Thread.Sleep(100);
string responseContent = string.Empty;
HttpResponseMessage response;
SqlCeCommand cmd = new SqlCeCommand("SELECT * FROM CARD WHERE name = \'" + text.Replace("\'", "\'\'") + "\'", db.connection);
SqlCeDataAdapter da = new SqlCeDataAdapter(cmd);
DataTable result = new DataTable();
da.Fill(result);
if (result.Rows.Count > 1)
{
Console.WriteLine(String.Format("Card {0} has more than one record!!!", text));
}
else if (result.Rows.Count != 0)
{
Console.WriteLine(String.Format("card {0} exists in DB", text));
//retval = ScryfallCard.LoadFromDB(result.Rows[0]);
retval = ScryfallCard.LoadCardFromDatarow(result.Rows[0]);
}
else
{
response = client.GetAsync("cards/named?exact=" + text).Result;
response.EnsureSuccessStatusCode();
responseContent = response.Content.ReadAsStringAsync().Result;
retval = ScryfallCard.FromJson(responseContent);
retval.SaveToDB(db);
}
}
catch (Exception ex)
{
retval = null;
throw;
}
return(retval);
}