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