asp net due date tracker
1.0.0
The goal of this assignment is meant for me to master ASP.NET Web Application (Model-View-Controller) and to use MVC to create a CRUD application. I have created a tool that keep track of book(s) checked out and returned to the library.
Throughout this exercise, I have successfully executed several concepts related to ASP.NET Web Application MVC:
The use of scaffold Author.cs model with MVC Controller with Views, using Entity Framework(EF) to create AuthorController.cs and Author Views. The views scaffolded are Create.cshtml, Delete.cshtml, Details.cshtml, Edit.cshtml, and Index.cshtml.
The creation of model context, LibraryContext.cs from scratch. I completed and created relational database between author and book using EF migrations within NuGet Package Manager Console.
The creation of BookController.cs from scratch using empty MVC controller class.
The creation of BookController and Views() from scratch using empty controller files.
The customization of views within cshtml type files.
The creation of customized Exceptions as ValidationExceptions.csto generate custom Exception messages.
The use of LINQ to conduct queries.
$ git clone https://github.com/jia-von/asp-net-due-date-tracker.git $ cd asp-net-library-due-date-tracker-day-1-jia-von $ cd Library $ start devenv Library.sln
Use the NuGet Package Manager to install packages:
Entity Framework ASP.NET Core Design.
Entity Framework Pomelo Entity Framework Core.
Entity Framework ASP.Net Core SqlServer.
PM> dotnet add package Microsoft.EntityFrameworkCore.Design PM> dotnet add package Pomelo.EntityFrameworkCore.MySQL PM> dotnet add package Microsoft.EntityFrameworkCore.SqlServer
Initiate initial migration to create a database with data seeded.
PM> dotnet ef migrations add InitialCreation PM> dotnet ef update database
The result of successful database migration and update is shown below in PHPMyAdmin localhost with the database name mvc_library.
| Author Table | Book Table |
|---|---|
 |  |
Start the Debugging tool within Visual Studio 2019.
A browser will autmatically open to show a view of the database.
| Create View | List View |
|---|---|
 |  |
| Details View | Author Index View |
|---|---|
 |  |
Note: AuthorController Index() view was created using scaffold, MVC Controller with Views, using Entity Framework.
