public void Checkout_Find_3()
{
Checkout newCheckout = new Checkout("2017/05/1", 1, 1);
Book newBook = new Book("Old Man and the Sea", 4);
newBook.Save();
newCheckout.Save(newBook);
Checkout foundCheckout = Checkout.Find(newCheckout.GetId());
Assert.Equal(newCheckout, foundCheckout);
}
public static void Return(int id)
{
SqlConnection conn = DB.Connection();
conn.Open();
if (Checkout.Find(id).GetDueDate() != "Returned")
{
SqlCommand copyCmd = new SqlCommand("UPDATE books SET copies = @BookCopies WHERE id = @BookId;", conn);
copyCmd.Parameters.Add(new SqlParameter("@BookCopies", (Book.Find(Checkout.Find(id).GetBookId()).GetCopies() + 1)));
copyCmd.Parameters.Add(new SqlParameter("@BookId", Checkout.Find(id).GetBookId()));
copyCmd.ExecuteNonQuery();
}
SqlCommand cmd = new SqlCommand("UPDATE checkouts SET due_date = 'Returned' WHERE id=@CheckoutId;", conn);
cmd.Parameters.Add(new SqlParameter("@CheckoutId", id));
cmd.ExecuteNonQuery();
DB.CloseSqlConnection(conn);
}
