ToDo List manager allows users to register using email and then login to add ToDos with Description, Due date and Priority, and the ability to edit, delete and mark a ToDo as completed.
Design Patterns
Domain Driven Design pattern is used to implement the backend which can be seen in the implementation of different layers, the use of Single Responsiblity Principle, the Repository pattern even when we are using EF and CQRS for Domain Model's abstraction from the outside world. Domain Driven Design helps immensely in case of maintaining large and evolutionary projects.
Architecture
Backend is developed in C# using the .NET Framework and utilizes:
- ASP.NET Web Api for providing RESTful architecture
- Entity Framework as ORM
- Ninject as the dependency resolver
- Microsoft Identity for handling users and account
- OWIN(Katana) pipeline as the interface between the web application and web server.
Frontend is created as a .NET Core project, and uses AngularJS to create a Single-Page-Application. Grunt copy tasks are used to copy the javascript files to the wwwroot folder as soon as they are added or updated.
Prerequisites
Visual Studio 2017
MySql Community Server 5.7 (Having MySql Workbench installed too is a plus)
How to Run
Database:
Even though EF Code first is being used, the database structure is dumped as a .sql file which needs to be imported. The reason for this is that having the database created with every run is risky in production environments which can result in data loss. Thus, having a backup file and loading it manually is the right approach in my opinion. To do that:
- Create a new database using WorkBench or the command line
- Open MySql WorkBench
- Log in with the root account. Create one if this is the first time you are logging in.
- Click Server --> Data Import. Choose the database to import to. Locate the sql dump in the solution: Backend/Data/MySql/create.sql.
- Click Import. The sql dump will be imported, and the database is all set to be used.
- The connection string for the application is located inside Backend/Common/ToDoApp.Common.WebHost project, inside web.config file with the name "MySql". The username and password can be changed. The account credentials that the application is using are testuser:Wired987#, so either change the credentials in the web.config or create a user with these credentials in MySql. This can be done in Myql WorkBench by going to Server -> Users & Privileges and creating a new user.
- Allow 'MaintenanceAdmin' Priviliges to this user. This can be done in MySql WorkBench by going to Server -> Users & Privileges, click on the desired user and then select the Administrative Roles tab.
Backend:
- Right click on the Solution and choose 'Restore Nuget Packages'
- Once the packages are restored, right click the project Backend/Common/ToDoApp.Common.WebHost -> Debug -> Start New Instance.
Frontend:
- Click Views --> Other Windows --> Task Runner Explorer.
- Once the task runner explorer window appears, you should be able to see GruntFile.js -> Alias Tasks -> Default. Right click on Default and select Run.
- Right click the project Frontend/ToDoApp.Frontend, Debug -> Start New Instance.
A new window will appear with the login screen and is ready to register new users, log them in and have new ToDos created.