public List <CatCard> GetAllCards()
{
List <CatCard> returnCards = new List <CatCard>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT id, img_url, fact, caption FROM catcards", conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CatCard cc = GetCatCardFromReader(reader);
returnCards.Add(cc);
}
}
}
catch (SqlException)
{
throw;
}
return(returnCards);
}
public CatCard GetCard(int id)
{
CatCard returnCard = null;
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT id, img_url, fact, caption FROM catcards WHERE id = @card_id", conn);
cmd.Parameters.AddWithValue("@card_id", id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows && reader.Read())
{
returnCard = GetCatCardFromReader(reader);
}
}
}
catch (SqlException)
{
throw;
}
return(returnCard);
}
public CatCard SaveCard(CatCard cardToSave)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO catcards (img_url, fact, caption) VALUES (@img_url, @fact, @caption)", conn);
cmd.Parameters.AddWithValue("@img_url", cardToSave.ImgUrl);
cmd.Parameters.AddWithValue("@fact", cardToSave.CatFact);
cmd.Parameters.AddWithValue("@caption", cardToSave.Caption);
cmd.ExecuteNonQuery();
cmd = new SqlCommand("SELECT @@IDENTITY", conn);
int newId = Convert.ToInt32(cmd.ExecuteScalar());
cardToSave.CatCardId = newId;
return(cardToSave);
}
}
catch (SqlException)
{
throw;
}
}
public ActionResult <CatCard> GetRandomCat()
{
CatCard card = new CatCard();
card.CatFact = catFactService.GetFact().Text;
card.ImgUrl = catPicService.GetPic().File;
return(card);
}
public ActionResult <CatCard> SaveCard(CatCard card)
{
if (card.CatCardId == null)
{
return(BadRequest());
}
CatCard added = cardDAO.SaveCard(card);
return(Created($"/Card/{added.CatCardId}", added));
}
public ActionResult <CatCard> FindCard(int id)
{
CatCard c = cardDAO.GetCard(id);
if (c == null)
{
return(NotFound("Card not found"));
}
return(Ok(c));
}
public ActionResult Delete(int id)
{
CatCard card = cardDAO.GetCard(id);
if (card == null)
{
return(NotFound("Card does not exist"));
}
cardDAO.RemoveCard(id);
return(NoContent());
}
public ActionResult <CatCard> UpdateCatCard(int id, CatCard changedCard)
{
if (cardDAO.GetCard(id) != null)
{
if (changedCard.CatCardId == id)
{
return(Ok(cardDAO.UpdateCard(changedCard)));
}
}
return(NotFound());
}
private CatCard GetCatCardFromReader(SqlDataReader reader)
{
CatCard c = new CatCard()
{
CatCardId = Convert.ToInt32(reader["id"]),
ImgUrl = Convert.ToString(reader["img_url"]),
CatFact = Convert.ToString(reader["fact"]),
Caption = Convert.ToString(reader["caption"])
};
return(c);
}
public ActionResult <Boolean> UpdateCatCard(int id, CatCard card)
{
CatCard location = cardDAO.GetCard(id);
if (location == null)
{
return(NotFound($"CatCard id {id} doesn't exist"));
}
bool result = cardDAO.UpdateCard(card);
return(result);
}
public ActionResult <CatCard> GetRandomCard()
{
CatCard card = cardDAO.GetRandomCatCard();
if (card == null)
{
return(NotFound());
}
else
{
return(Ok(card));
}
}
public ActionResult <CatCard> GetRandomCard()
{
CatFact fact = catFactService.GetFact();
CatPic pic = catPicService.GetPic();
CatCard card = new CatCard()
{
CatFact = fact.Text,
ImgUrl = pic.File
};
return(card);
}
public ActionResult <CatCard> GetKittyCat(int id)
{
CatCard card = cardDAO.GetCard(id);
if (card != null)
{
return(Ok(card));
}
else
{
return(NotFound());
}
}
public ActionResult <CatCard> CreateRandomCard()
{
CatCard c = new CatCard();
CatPic pic = catPicService.GetPic();
CatFact fact = catFactService.GetFact();
//create pic and fact objects
if (fact == null || pic == null)//fact or pic == null; status code 500
{
return(StatusCode(500));
}
c.CatFact = fact.Text;
c.ImgUrl = pic.File;
return(Ok(c));
}
public ActionResult <CatCard> UpdateCard(int Id, CatCard catCard)
{
CatCard existing = cardDAO.GetCard(Id);
if (existing == null)
{
return(NotFound("Card not found"));
}
bool result = cardDAO.UpdateCard(catCard);
if (result)
{
return(Ok(cardDAO.GetCard(Id)));
}
return(null);
}
public CatCard GetRandomCatCard()
{
CatFact fact = GetFact();
CatPic pic = GetPic();
if (fact == null || pic == null)
{
return(null);
}
CatCard card = new CatCard()
{
CatFact = fact.Text,
ImgUrl = pic.File
};
return(card);
}
public ActionResult <CatCard> GetRandomCatCard()
{
try
{
CatFact fact = catFactService.GetFact();
CatPic pic = catPicService.GetPic();
CatCard card = new CatCard()
{
CatFact = fact.Text,
ImgUrl = pic.File
};
return(Ok(card));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public ActionResult <CatCard> GetRandomCard()
{
CatFactService serviceFact = new CatFactService();
CatPicService servicePic = new CatPicService();
CatCard card = new CatCard();
CatFact fact = serviceFact.GetFact();
CatPic pic = servicePic.GetPic();
if (fact == null || pic == null)
{
return(StatusCode(500));
}
card.CatFact = fact.Text;
card.ImgUrl = pic.File;
return(Ok(card));
}
public bool UpdateCard(CatCard updatedCard)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("UPDATE catcards SET img_url = @img_url, fact = @fact, caption = @caption WHERE id = @card_id", conn);
cmd.Parameters.AddWithValue("@img_url", updatedCard.ImgUrl);
cmd.Parameters.AddWithValue("@fact", updatedCard.CatFact);
cmd.Parameters.AddWithValue("@caption", updatedCard.Caption);
cmd.Parameters.AddWithValue("@card_id", updatedCard.CatCardId);
int rowsAffected = cmd.ExecuteNonQuery();
return(rowsAffected > 0);
}
}
catch (SqlException)
{
throw;
}
}
/// <summary>
/// Update the properties of the card in the DB.
/// </summary>
/// <param name="updatedCard">New values to save into the DB</param>
/// <returns>True if the update succeeded</returns>
public bool UpdateCard(CatCard updatedCard)
{
throw new NotImplementedException();
}
public CatCard AddCard(CatCard catCard)
{
return(cardDAO.SaveCard(catCard));
}
public bool UpdateCard(CatCard catCard)
{
return(cardDAO.UpdateCard(catCard));
}
public ActionResult <CatCard> SaveCard(CatCard incomingCard)
{
CatCard newCard = cardDAO.SaveCard(incomingCard);
return(Created("/api/cards/" + newCard.CatCardId, newCard));
}
public CatCard SaveCard(CatCard newCard)
{
return(cardDAO.SaveCard(newCard));
}
/// <summary>
/// Saves a new card to the database in the user's collection
/// </summary>
/// <param name="addedCard">The new card to add</param>
/// <returns>The added card</returns>
public CatCard AddCard(CatCard addedCard)
{
throw new NotImplementedException();
}
