public LoginWindowController()
{
userDatabaseController = new UserDatabaseController();
}
public Deck GetDeckById(string deckId)
{
Deck returnDeck = new Deck();
NpgsqlConnection conn = databaseConnection.ConnectToDatabase();
conn.CreateCommand();
NpgsqlCommand command = new NpgsqlCommand("select * from dbdeck where deckid = :value1", conn);
command.Parameters.Add(new NpgsqlParameter("value1", DbType.String));
command.Parameters[0].Value = deckId;
command.Connection = conn;
DataTable result = databaseConnection.ExecuteSelectQuery(command, conn);
if (result != null)
{
UserDatabaseController udc = new UserDatabaseController();
returnDeck.DeckId = deckId;
returnDeck.DeckName = result.Rows[0].ItemArray[1].ToString();
returnDeck.DeckUser = udc.GetUser(result.Rows[0].ItemArray[2].ToString());
conn = databaseConnection.ConnectToDatabase();
conn.CreateCommand();
command = new NpgsqlCommand("select deckid, cardid, cardtodeckid from dbcardtodeck where deckid = :value1", conn);
command.Parameters.Add(new NpgsqlParameter("value1", DbType.String));
command.Parameters[0].Value = deckId;
command.Connection = conn;
result = databaseConnection.ExecuteSelectQuery(command, conn);
if (result != null)
{
for (int i = 0; i < result.Rows.Count; i++)
{
returnDeck.CardList.Add(new Card(result.Rows[i].ItemArray[1].ToString(), result.Rows[i].ItemArray[2].ToString()));
}
}
}
return returnDeck;
}
