Small web application that let user create and assigned memo to work groups.
-
Home page by user
-
Moderator page(CRUD operation on the DB)
-
Adding a custom pdf file to the memo
-
Creating reports
A complete project using microsoft ASP.NET core MVC that used C# and a SQL microsoft server for the database. The UI is made in Razor(.cshtml), a mix of C# and web base technologie.(html, css, bootstrap, javascrip)
ASP.NET core propose a librairy name EntityFramework that easily link your Models with the database. Using EntityFramework will save alot of time bypassing the SQL request process. Also, making modification to your model is easy with the usage of migration.
Its based on the basic MVC model and use the URL as a routing mechanism. Eatch controller as differents views, the basic routing would look like this. If you have a controller name PizzaController you would make a 'Pizza' folder inside of the 'View' folder. Inside of the controller you would have different function call that have the same name of the views. For exemple : LocalHost1234/Pizza/Index, LocalHsot1234/Pizza/List. Inside the controller you tell witch model will be used inside of the view.
EntityFramework connect to your BD using a connectionString and base on the model that you assign inside of the DbContext, it will create a migration that can be easily upload to your database when modification need to be done. Its basicly drop the whole db and remake it with the modification that you have done.
I created a service layer so that the controllers dont directly called the DB.
-
ASP.NET CORE https://learn.microsoft.com/en-us/aspnet/core/?view=aspnetcore-8.0
-
Bootstrap https://getbootstrap.com/docs/5.3/getting-started/introduction/
-
MicrosoftSql https://learn.microsoft.com/en-us/sql/?view=sql-server-ver16
-
EntityFrameWork https://learn.microsoft.com/en-us/ef/
dotnet ef migrations add MigrationName
dotnet ef database update
dotnet ef migrations remove
dotnet ef migrations list<