Gl add dispose to tests

[Chewieez]

Link to Ticket

No direct ticket

Description of Proposed Changes

• Refactored tests to be self contained and create new customers, products, and orders when needed for each test and not rely on any hard coded values.
• Added a method on DatabaseInterface to delete all the tables.
• Called the DeleteTables() function at the end of each test file.

Steps to Test

Outline the steps to test

• Start in your root directory for project
• DELETE TEST DATABASE FILE.

git fetch --all
git checkout gl-AddDisposeToTests
cd bangazon-cli.Tests
dotnet restore
dotnet test

• Confirm that all 23 tests pass without errors.
• Confirm that in test report, where it says Connecting... that there are no errors listed

Impacted Areas in Application

List general components of the application that this PR will affect:

• ActiveCustomerManager_Should.cs
• CustomerManager_Should.cs
• OrderManagerShould.cs
• PaymentTypeManager_Should.cs
• ProductManager_Should.cs
• DatabaseInterface.cs
• ProductManager.cs

Mentions @username

Tag users that need to review this code

Definition of Done

1. The project must be fully documented. This includes the following:
   1. Complete README that documents the steps to install the code, how to install any dependencies, or system configuration needed.
   2. Every class must be documented with purpose, author, and methods.
   3. Every method must be documented with purpose and argument list - which itself must contain a short purpose for each argument.
2. The project must be able to run fully, and without errors, on each teammate's system.
3. Fulfills every requirement. Every line of code has been peer reviewed.
4. For projects that require unit testing, core functionality must be identified and have at least one test for each.

[DreRandaci]

👍

[kimberly-bird]

👍