public void GetCardByDeckIdShouldReturnCorrectCards()
{
List <Card> cards = new List <Card>();
Card card = new Card()
{
Front = "testFront",
Back = "testBack",
CardOrder = 1,
DeckId = testDeckId,
ImageURL = "",
};
cards.Add(card);
dal.AddCardToDeck(card);
card = new Card()
{
Front = "testFront 2",
Back = "testBack 2",
CardOrder = 2,
DeckId = testDeckId,
ImageURL = "",
};
cards.Add(card);
dal.AddCardToDeck(card);
List <Card> result = dal.GetCardsByDeckId(testDeckId);
Assert.AreEqual(cards[0].Front, result[0].Front);
Assert.AreEqual(cards[0].Id, result[0].Id);
Assert.AreEqual(cards[1].Front, result[1].Front);
Assert.AreEqual(cards[1].Id, result[1].Id);
}
public IActionResult UpdateCard(Card updatedCard)
{
Card card = cardSqlDAL.GetCardById(updatedCard.Id);
// Check if new Card Order is within range of valid options
if (updatedCard.CardOrder > cardSqlDAL.GetCardsByDeckId(updatedCard.DeckId).Count || updatedCard.CardOrder < 1)
{
return(View("Error"));
}
if (cardSqlDAL.UpdateCard(updatedCard) == null)
{
if (updatedCard.Front == card.Front &&
updatedCard.Back == card.Back &&
updatedCard.ImageURL == card.ImageURL &&
updatedCard.CardOrder == card.CardOrder)
{
return(RedirectToAction("ViewDeck", new { deckId = updatedCard.DeckId }));
}
else
{
return(View("Error"));
}
}
else
{
return(RedirectToAction("ViewDeck", new { deckId = updatedCard.DeckId }));
}
}
//Deck GetDeckById();
public Deck GetDeckById(int deckId)
{
Deck result = new Deck();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql_GetDeckById, conn);
cmd.Parameters.AddWithValue("@id", deckId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Deck deck = new Deck
{
Id = Convert.ToInt32(reader["id"]),
Name = Convert.ToString(reader["name"]),
DateCreated = Convert.ToDateTime(reader["date_created"]),
PublicDeck = Convert.ToBoolean(reader["is_public"]),
UserId = Convert.ToInt32(reader["users_id"]),
ForReview = Convert.ToBoolean(reader["for_review"]),
Description = Convert.ToString(reader["description"]),
DeckColor = Convert.ToString(reader["color"]),
TextColor = Convert.ToString(reader["text_color"])
};
result = deck;
}
}
result.Cards = cardSqlDAL.GetCardsByDeckId(result.Id);
}
catch (SqlException ex)
{
//Deck deck = new Deck();
}
return(result);
}