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