public void AddTagListTests()
{
List <Tag> tags = new List <Tag>();
Tag tag = new Tag()
{
CardId = testCardId,
Name = "Testing"
};
tags.Add(tag);
tag = new Tag()
{
Name = "Testing 2",
CardId = testCardId
};
tags.Add(tag);
tags = dal.AddTagList(tags);
List <Tag> manualTagList = new List <Tag>();
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM tags WHERE card_id = @id;", conn);
cmd.Parameters.AddWithValue("@id", testCardId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Tag t = new Tag();
t.Id = Convert.ToInt32(reader["id"]);
t.Name = Convert.ToString(reader["tag"]);
t.CardId = Convert.ToInt32(reader["card_id"]);
manualTagList.Add(t);
}
}
Assert.AreEqual(tags[0].Id, manualTagList[0].Id, "id");
Assert.AreEqual(tags[0].Name, manualTagList[0].Name, "name");
Assert.AreEqual(tags[0].CardId, manualTagList[0].CardId, "card id");
Assert.AreEqual(tags[1].Id, manualTagList[1].Id, "id 2");
Assert.AreEqual(tags[1].Name, manualTagList[1].Name, "name 2");
Assert.AreEqual(tags[1].CardId, manualTagList[1].CardId, "card id 2");
}
public Card AddCardToDeck(Card card)
{
Card output = card;
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql_AddCardToDeck, conn);
cmd.Parameters.AddWithValue("@front", card.Front);
cmd.Parameters.AddWithValue("@back", card.Back);
cmd.Parameters.AddWithValue("@img", card.ImageURL);
cmd.Parameters.AddWithValue("@card_order", card.CardOrder);
cmd.Parameters.AddWithValue("@deck_id", card.DeckId);
try
{
output.Id = (int)cmd.ExecuteScalar();
if (output.Tags != null)
{
foreach (var tag in output.Tags)
{
tag.CardId = output.Id;
}
}
else
{
output.Tags = new List <Tag>();
}
tagSqlDAL.AddTagList(output.Tags);
}
catch (Exception e)
{
output = new Card();
}
}
return(output);
}
public void AddTags(TagAPIViewModel newTags)
{
tagSqlDAL.AddTagList(newTags.Tags);
}
