public void AddTagTests() { Tag tag = new Tag() { CardId = testCardId, Name = "Testing" }; tag = dal.AddTag(tag); Assert.IsNotNull(tag.Id); Tag manualTag = new Tag(); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM tags WHERE id = @id;", conn); cmd.Parameters.AddWithValue("@id", tag.Id); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { manualTag.Id = Convert.ToInt32(reader["id"]); manualTag.Name = Convert.ToString(reader["tag"]); manualTag.CardId = Convert.ToInt32(reader["card_id"]); } } Assert.AreEqual(tag.Id, manualTag.Id, "id"); Assert.AreEqual(tag.Name, manualTag.Name, "name"); Assert.AreEqual(tag.CardId, manualTag.CardId, "card id"); }
public IActionResult AddTag(Tag newTag) { newTag = tagSqlDAL.AddTag(newTag); Card card = cardSqlDAL.GetCardById(newTag.CardId); return(RedirectToAction("ViewDeck", new { deckId = card.DeckId })); }
public Tag New(Tag newTag) { return(_dal.AddTag(newTag)); }