public Card getCardById(string cardId)
{
Card returnCard = new Card(cardId);
NpgsqlConnection conn = databaseConnection.ConnectToDatabase();
conn.CreateCommand();
NpgsqlCommand command = new NpgsqlCommand("select * from dbcard where cardid = :value1", conn);
command.Parameters.Add(new NpgsqlParameter("value1", DbType.String));
command.Parameters[0].Value = cardId;
command.Connection = conn;
DataTable result = databaseConnection.ExecuteSelectQuery(command, conn);
if (result != null)
{
returnCard = dataTableToCardList(result).ToArray()[0];
}
return returnCard;
}
public bool AddCardToDeck(Card card, Deck deck)
{
NpgsqlConnection conn = databaseConnection.ConnectToDatabase();
conn.CreateCommand();
NpgsqlCommand command = new NpgsqlCommand("insert into dbcardtodeck(deckid, cardid) values(:value1, :value2)", conn);
command.Parameters.Add(new NpgsqlParameter("value1", DbType.String));
command.Parameters.Add(new NpgsqlParameter("value2", DbType.String));
command.Parameters[0].Value = card.CardId;
command.Parameters[1].Value = deck.DeckId;
command.Connection = conn;
if (databaseConnection.ExecuteChangeQuery(command, conn))
{
return true;
}
return false;
}
public void addCardToDeck(Card card, Deck deck)
{
deckDatabaseController.AddCardToDeck(card, deck);
}
public void removeCardFromDeck(Card card, Deck deck)
{
}