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); }