MessageBoardApi.Solution: A C# repository from julienfullstack

What Is This?

This is an example repo corresponding to multiple lessons within the LearnHowToProgram.com walkthrough on creating an ASP.NET Core API in Section 6: Building an API. Later we create an ASP.NET Core MVC app.

This project is called the "Cretaceous Park API", while the client is called the "Cretaceous Park Client".

There are multiple branches in this repo that are described more below.

Finally, this project was scaffolded using dotnet new.

How To Run This Project

Install Tools

Install the tools that are introduced in this series of lessons on LearnHowToProgram.com.

If you have not already, install the dotnet-ef tool by running the following command in your terminal:

dotnet tool install --global dotnet-ef --version 6.0.0

Set Up and Run Project

Clone this repo.
Open the terminal and navigate to this project's production directory called "MessageBoardApi".
Within the production directory "MessageBoardApi", create two new files: appsettings.json and appsettings.Development.json.
Within appsettings.json, put in the following code. Make sure to replacing the uid and pwd values in the MySQL database connection string with your own username and password for MySQL. For the LearnHowToProgram.com lessons, we always assume the uid is root and the pwd is epicodus.

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Port=3306;database=cretaceous_api;uid=root;pwd=epicodus;"
  }
}

Within appsettings.Development.json, add the following code:

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Trace",
      "Microsoft.AspNetCore": "Information",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  }
}

Create the database using the migrations in the Cretaceous Park API project. Open your shell (e.g., Terminal or GitBash) to the production directory "MessageBoardApi", and run dotnet ef database update. You may need to run this command for each of the branches in this repo.
- To optionally create a migration, run the command dotnet ef migrations add MigrationName where MigrationName is your custom name for the migration in UpperCamelCase. To learn more about migrations, visit the LHTP lesson Code First Development and Migrations.
Within the production directory "MessageBoardApi", run dotnet watch run --launch-profile "MessageBoardApi-Production" in the command line to start the project in production mode with a watcher.
To optionally further build out this project in development mode, start the project with dotnet watch run in the production directory "MessageBoardApi".
Use your program of choice to make API calls. In your API calls, use the domain http://localhost:5000. Keep reading to learn about all of the available endpoints.

Testing the API Endpoints

You are welcome to test this API via Postsman, curl, or the ASP.NET Core MVC frontend "Cretaceous Park Client" create to work with this API.

If you want to use the Cretaceous Park Client, an ASP.NET Core MVC application, follow the setup instructions in the README of this repo.

Available Endpoints

GET http://localhost:5000/api/Posts/
GET http://localhost:5000/api/Posts/{id}
Posts http://localhost:5000/api/Posts/
PUT http://localhost:5000/api/Posts/{id}
DELETE http://localhost:5000/api/Posts/{id}

Note: {id} is a variable and it should be replaced with the id number of the Posts you want to GET, PUT, or DELETE.

Optional Query String Parameters for GET Request

GET requests to http://localhost:5000/api/Posts/ can optionally include query strings to filter or search Posts.

Parameter	Type	Required	Description
GroupId	String	not required	Returns Posts with a matching GroupId value
name	String	not required	Returns Posts with a matching name value
minimumAge	Number	not required	Returns Posts that have an DateTime value that is greater than or equal to the specified minimumAge value

The following query will return all Posts with a GroupId value of "Dinosaur":

GET http://localhost:5000/api/Posts?GroupId=dinosaur

The following query will return all Posts with the name "Matilda":

GET http://localhost:5000/api/Posts?name=matilda

The following query will return all Posts with an DateTime of 10 or older:

GET http://localhost:5000/api/Posts?minimumAge=10

You can include multiple query strings by separating them with an &:

GET http://localhost:5000/api/Posts?GroupId=dinosaur&minimumAge=10

Additional Requirements for Posts Request

When making a Posts request to http://localhost:5000/api/Posts/, you need to include a body. Here's an example body in JSON:

{
  "GroupId": "Tyrannosaurus Rex",
  "name": "Elizabeth",
  "DateTime": 8
}

Additional Requirements for PUT Request

When making a PUT request to http://localhost:5000/api/Posts/{id}, you need to include a body that includes the Posts's UserId property. Here's an example body in JSON:

{
  "UserId": 1,
  "GroupId": "Tyrannosaurus Rex",
  "name": "Lizzy",
  "DateTime": 9
}

And here's the PUT request we would send the previous body to:

http://localhost:5000/api/Posts/1

Notice that the value of UserId needs to match the id number in the URL. In this example, they are both 1.

Available Branches

1_setup_and_seeding: This branch includes the code we added after working through the following lessons:

2_crud_functionality: This branch includes the code we added after working through the following lessons:

3_query_strings: This branch includes the code we added after working through the following lesson:

https://www.learnhowtoprogram.com/c-and-net/building-an-api/adding-parameters-to-a-get-request-to-support-query-strings

There are other lessons in this series, but the rest are not implemented in this example repo:

julienfullstack/MessageBoardApi.Solution