Scribd
Upload
40 views5 pages

Assignment 02 RentingCarManagement V5

This document outlines an assignment to build a Windows Forms application for managing car rentals. The application will allow users to perform CRUD operations on customer, car, and rental data stored in an SQL Server database. It will use Entity Framework and the repository pattern to abstract data access. The application will have authentication for administrators and customers. Administrators can access all functions while customers can view and manage their own profiles and rental histories. Main functions include customer, car, and rental management with searching on cars. The solution will comprise class library projects for business objects, data access, and repositories along with a Windows Forms project for the user interface.

Uploaded by

đệ huynh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
40 views5 pages

Assignment 02 RentingCarManagement V5

This document outlines an assignment to build a Windows Forms application for managing car rentals. The application will allow users to perform CRUD operations on customer, car, and rental data stored in an SQL Server database. It will use Entity Framework and the repository pattern to abstract data access. The application will have authentication for administrators and customers. Administrators can access all functions while customers can view and manage their own profiles and rental histories. Main functions include customer, car, and rental management with searching on cars. The solution will comprise class library projects for business objects, data access, and repositories along with a Windows Forms project for the user interface.

Uploaded by

đệ huynh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 5

Assignment 02 – Fall 2023 HCM

Building a Car Renting Management Application with


Windows Forms

1. Introduction
Imagine you're an employee of a product retailer named FUCarRenting. Your manager has
asked you to develop a Windows Forms application for customer management, cartoon
management, and car renting management. The application has a default account whose email is
“admin@FUCarRentingManagement.com” and password is “@@admin@@” that stored in
the appsettings.json.

The application has to support adding, viewing, modifying, and removing items—a standardized
usage action verb better known as Create, Read, Update, Delete (CRUD) and Search. This
assignment explores creating an application using Windows Forms with .NET Core, C#, and
ADO.NET / Entity Framework. The MS SQL Server database will be created to persist the data
and it will be used for reading and managing data.

2. Assignment Objectives
In this assignment, you will:

 Use the Visual Studio.NET to create Windows Forms and Class Library (.dll) projects.
 Develop MDI (Multiple Document Interface) application using WinForms.
 Perform CRUD actions using ADO.NET and Entity Framework Core
 Use LINQ to query and sort data
 Apply passing data in WinForms application
 Apply 3-layers architecture to develop an application
 Apply MPV (Model-Presenter-View) pattern in WinForms application
 Apply Repository pattern and Singleton pattern in a project

1|Page
 Add CRUD and searching actions to WinForms application.
 Apply to validate data type for all fields
 Run the project and test the WinForms actions.

3. Database Design

A car will belong to only one manufacturer and only one supplier.

A customer can make renting transaction in this system many times. A renting transaction will
have one or many car information. A car information will belong to many renting transactions.

2|Page
4. Main Functions
 Member (Admin/Customer) authentication by Email and Password. If the user is
“Admin” (get from appsettings.json file) then allows to perform all actions, otherwise,
the customer (get from the Customer table in database) is allowed to view/create/update
the profile and view their transactions history.
 Customer management, Car management, and Renting management: Read, Create,
Update and Delete actions. Creating and Updating actions must be performed by popup
dialog. One renting transaction will have many car with difference time (start/end); one
car will have in many renting transaction.
 Search car by ID, name (by keyword of CarName), CarRentingPricePerDay.
 Create a report statistics sales by the period from StartDate to EndDate, and sort the
results in descending order.

5. Guidelines
Activity 01: Build a solution

Create a Blank Solution named Ass02Solution_ClassCode_StudentName that includes Class


Library Project: DataAccessObjects, BusinessObjects, Repositories, and a Windows Forms
project named CarRentingManagementWinApp_StudentName

Step 01. Open the Visual Studio .NET application and create a Blank solution named
Ass02Solution_ClassCode_StudentName

Step 02. Create a Class Library project named BusinessObjects

Step 03. Repeat Step 02 to create a DataAccessObjects project.

Step 04. Repeat Step 02 to create a Repositories project.

Step 05. Create a Windows Forms project named


CarRentingManagementWinApp_StudentName
Step 06. Create folders and add classes to the projects as follows:

3|Page
Activity 02: Develop BusinessObjects project

Activity 03: Develop DataAccessObjects project

4|Page
Activity 04: Develop Repositories project

Activity 05: Develop CarRentingManagementWinApp_StudentName project

Step 01. Add the project reference to Repositories projects


Step 02. Design UI forms and write codes to perform functions
Hints: Use MenuStrip, ToolStrip, StatusStrip on the MDI form (frmMain form)

Activity 06: Run the WinForms project and test all actions

5|Page

You might also like