Project Overview:

Project Objective:

In this project, you will develop a Home Services Management System that can be used by home services

companies to offer plumbing, electrical, painting, etc., and for individuals to be able to request certain

service and track it$.$ The system will include features such as authentication and authorization, service

creation, request assignment, tracking, notifications, dashboard, and more.

The system will have a Windows Forms application and an ASP.NET Core MVC application, both of which

will use a shared database and Entity Framework Core models.

IDE: Visual Studio $2022$ Language: Visual C# $(.$NET Core$).$NET: $6$

Business Scenario:

A new company which offers home maintenance services wants to take their service requests processes

online to streamline the service pricing $($which is usually based on fixed pricing for each service type$),$

service offerings, service requests, and tracking for its clients.

The company managers want to create and manage service categories, manage services, receive service

requests from their clients, allocate staff to work on them, and track their progress.

Team members need to view the service requests assigned to them, update their status, and manage

request$-$related comments and documents.

$($Note: manage usually includes fu

$**$Database $($using Microsoft SQL Server$)$

Task $1$: Design and Implement the Database and Data Access Layer using Class Library & EF Core

Learning outcomes assessed:

$$ Use object$-$oriented techniques to design and implement custom database entity classes

$$ Manage a multi$-$tier application which uses custom entity classes to access and manipulate a

database

$$ Propose an appropriate technology for a particular problem

To build a comprehensive Task Management System, you need to design your entities in a way that

satisfies the requirements of the project.

$***$The picture attached to the question is a Suggested not a full answer.

You can follow either Database First or Code First approaches. In either case, make sure your database is

well$-$designed, normalized, and includes auto$-$incremented primary keys, foreign keys, and correct

relationships between tables.

For the user and role entities, you can design your own tables ensuring no passwords are stored in clear

text. The recommended approach, however, is to use $.$NET Membership tables and use it to authenticate

users on both your desktop and web applications.

Class Library project:

To develop the data access layer, create a Class Library project. The class library should model the

database and allow access to it through Entity Framework Core Object$-$Relational Mapping Framework

$($OR$/$M$).$

Your Class Library should include:

$1.$ Domain Classes with database tables mapping, annotated properties, and navigational properties.

$2.$ Database Context with database connection that acts as a gateway to the Database.

Page $5$ of $14$

$3.$ DBSet collections which act as Database Tables.

$***********$I want a Database First approach.