public List <Card> GetCardsByDeckId(int deckId) { List <Card> result = new List <Card>(); try { using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(sql_GetCardsByDeckId, conn); cmd.Parameters.AddWithValue("@deckId", deckId); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Card card = new Card { Id = Convert.ToInt32(reader["id"]), Front = Convert.ToString(reader["front"]), Back = Convert.ToString(reader["back"]), ImageURL = Convert.ToString(reader["img"]), DeckId = Convert.ToInt32(reader["deck_id"]), CardOrder = Convert.ToInt32(reader["card_order"]) }; card.Tags = tagSqlDAL.GetTagsForCard(card.Id); result.Add(card); } } } catch (SqlException ex) { result = new List <Card>(); } return(result); }
public void GetTagsForCardTests() { Tag tag = new Tag() { CardId = testCardId, Name = "Testing" }; dal.AddTag(tag); List <Tag> results = dal.GetTagsForCard(testCardId); Assert.AreEqual(1, results.Count); Assert.AreEqual(tag.Name, results[0].Name); Assert.AreEqual(tag.CardId, results[0].CardId); }