Welcome, new Bangazonians, to the engineering team here at bangazon.com! Our niche platform connects home aquarium enthusiasts to be able to buy and sell products like fish tanks, filters, fish food, pumps, accessories, etc.

Our immediate need for an application is an internal tool that can be used by our customer service team and our human resources team.

Your team has been assigned to build out a .NET Web API that makes each resource in the Bangazon database available to application developers throughout the rest of the engineering department.

1. Products
2. Product types
3. Customers
4. Orders
5. Payment types
6. Employees
7. Computers
8. Training programs
9. Departments

Pro tip: You do not need to make a Controller for the join tables (i.e. EmployeeTraining), because those aren't resources.

The front end team has been given a prototype API to help them implement a React web application. The prototype is built similar to JSON Server and not a actual long-term solution for persisting and retrieving data. We need your team to build a production ready API to replace the prototype.

If you complete all tickets in your backlog, you should have the following endpoints implemented.

Your front end developers are expecting data back from your API that looks exactly like what's listed below. If the properties don't match, the client application will break. NOTE Don't worry about any differences in dummy data the prototype uses vs the data in your database. The only thing that is important is that the shape of each resource should match exactly.

To see examples from the prototype API you can use this base URL:

https://bangazon-prototype-api.herokuapp.com/

🔥🔥 Check in with your lead developer, product owner, or scrum master if you have any questions 🔥🔥

* Order objects that have a payment method that isn't NULL are considered complete and processed. An order that does not have a payment type would be considered a user's shopping cart. A user can have only one shopping cart, and therefore will only have a maximum of one Order record in the database with a NULL payment type at a given time.

** To purchase an order, update the Order object's userPaymentId property

First, you need to plan. The official SQL script for creating the database is already in this repository (see below). Before you start coding, take a moment and look at the SQL script and build a Bangazon ERD using dbdiagram.io. Once your team agrees that the ERD is complete, you must get it approved by your lead developer before you begin writing code for the API.

Next, you need to author the Models needed for your API. Make sure that each model has the approprate foreign key relationship defined on it, either with a custom type or an List<T> to store many related things. For example, a ProductType has many Productss associated with it, and therefore you will want a property of List<Product> on the ProductType model.

You will be using the Official Bangazon SQL file to create your database. Create the database using Visual Studio.

Now it's time to build the controllers that handle GET, POST, PUT, and DELETE operations on each resource. Make sure you read, and understand, the requirements in the issue tickets.

{
    "id": 1575559407787,
    "active": true,
    "createdDate": "2019-08-25T00:00:00.000Z",
    "firstName": "Nathanael",
    "lastName": "Laverenz",
    "address": "401 Nunya Business Dr",
    "city": "Herman",
    "state": "New York",
    "email": "n.lav@sbcglobal.net",
    "phone": "6151237584"
}

{
    "id": 1575559407733,
    "active": true,
    "createdDate": "2019-08-25T00:00:00.000Z",
    "firstName": "Kimble",
    "lastName": "Peskett",
    "address": "508 Loop Cir",
    "city": "Nashville",
    "state": "Tennessee",
    "email": "peskykimble@hotmail.com",
    "phone": "5671234567",
    "products": [
        {
            "id": 15755594079866,
            "productTypeId": 1575501970047,
            "customerId": 1575559407733,
            "price": 76.91,
            "description": "morbi ut odio cras mi pede malesuada in imperdiet et commodo",
            "title": "Passat",
            "dateAdded": "2019-08-25T00:00:00.000Z"
        },
        {
            "productTypeId": 1575559407749,
            "customerId": 1575559407733,
            "price": 79.92,
            "description": "semper rutrum nulla nunc purus phasellus in felis donec semper sapien a libero",
            "title": "Santa Fe",
            "dateAdded": "2019-09-25T00:00:00.000Z",
            "id": 1575669305071
        }
    ]
}

{
    "id": 15755594079867,
    "productTypeId": 1575501970045,
    "customerId": 1575559407755,
    "price": 62.54,
    "description": "pede ullamcorper augue a suscipit nulla elit ac nulla sed",
    "title": "Murciélago LP640",
    "dateAdded": "2018-12-25T00:00:00.000Z"
}

{
    "id": 1575501974871,
    "name": "Mastercard",
    "active": true
}

{
    "id": 1575501978463,
    "customerId": 1575559407787,
    "paymentTypeId": 1575501974871,
    "acctNumber": "2234 56789 0123",
    "active": true
}

{
    "id": 1575559407665,
    "customerId": 1575559407787,
    "userPaymentId": null
}

{
    "customerId": 1575559407787,
    "productId": 1575501970208
}

{
    "id": 1575501970045,
    "name": "Accessories"
}

{
    "id": 1575501974624,
    "firstName": "Adam",
    "lastName": "Sheaffer",
    "departmentId": 1575559403192,
    "isSupervisor": false,
    "computerId": 1575566566333,
    "email": "iamtheboss@bangazon.com",
    "computer": {
        "id": 1575566566333,
        "purchaseDate": "2016-01-01T23:28:56.782Z",
        "decomissionDate": null,
        "make": "Apple",
        "model": "Macbook Pro"
    }
}

{
    "id": 1575559403194,
    "name": "Accounting",
    "budget": 1230000
}

{
    "id": 1575566566333,
    "purchaseDate": "2016-01-01T23:28:56.782Z",
    "decomissionDate": null,
    "make": "Apple",
    "model": "Macbook Pro"
}

{
    "id": 1575559403194,
    "name": "GIS Application",
    "startDate": "2018-09-25T00:00:00.000Z",
    "endDate": "2018-10-05T00:00:00.000Z",
    "maxAttendees": 45
}

{
    "productTypeId": 1575501970829,
    "productType": "Filters",
    "totalRevenue": 158.64
}