UNIVERSITY OF VINH
INSTITUTE OF ENGINEERING AND TECHNOLOGY

SPECIALIZED PROJECTS
PROGRAM FOR SALES MANAGEMENT IN C#
PROGRAMMING LANGUAGE

TEACHER: TS. Trần Xuân Sang
STUDENT: Hồ Văn Cường
ID: 18574802010178
CLASS: 59K CNTT_CLC

Nghệ An, 6/2021


SPECIALIZED PROJECTS

Sales Manager
TABLE OF CONTENTS

INTRODUCE......................................................................................................2
1.1. Description of the problem.......................................................................3
1.2. Subject specification..................................................................................3
CHAPTER 2. SYSTEM SURVEY AND ANALYSIS......................................5
2.1. ANALYSIS OF TOPIC REQUIREMENTS................................................5
2.1.1. FUNCTION.............................................................................................5
2.1.2. REQUIREMENTS..................................................................................5
2.2. SYSTEM ANALYSIS AND DESIGN.......................................................6
2.2.1. SITUATION SURVEY AND NEW SYSTEM BUILDING....................6
2.2.2. SYSTEM ANALYSIS.............................................................................6
CHAPTER III. BUILDING MODELS – SCHEDULE..................................10

3.1. BUILD MODELS.....................................................................................10
3.1.1. Solutions................................................................................................10
3.1.2. SALES PROFIT DATABASE...............................................................10
3.2. Design the theme.......................................................................................15
3.2.1. Login form.............................................................................................15
3.2.2. Main form...............................................................................................16
3.2.3. Category form........................................................................................17
3.2.4. Customers form......................................................................................17
3.2.5. Suppliers form........................................................................................18
3.2.6. Staff form...............................................................................................19
3.2.7. Products form.........................................................................................19
3.2.8. Pass form................................................................................................20
3.2.9. Invoice form...........................................................................................21
3.2.12. Inventory form......................................................................................21
3.2.13. Revenue form:......................................................................................22
CONCLUDE...................................................................................................23
RESEARCH PAPERS...................................................................................24

Page 1


SPECIALIZED PROJECTS

Sales Manager

INTRODUCE

Nowadays, people's lives are developing day by day, leading to increased
shopping and trading needs of people. The management work of large and small
grocery store owners is more and more difficult and complicated. There are many

software solutions offered to solve this problem, but it is expensive and difficult to
apply to small and medium-sized stores.
Through research, learning from teachers and friends about sales management
solutions combined with the actual survey process on many stores, I would like to
come up with a sales solution for small and medium stores. Hopefully this product
can help managers control the entire business process of their store.
Therefore, I have implemented the project "BUILDING A SALES
MANAGEMENT PROGRAM" for an ABC grocery store.
With the enthusiastic guidance of Mr. Trần Xuân Sang, I have completed this
project report. Although we have tried our best to learn, analyze, design and install
the system, it is inevitable that there will be shortcomings. I look forward to
receiving your understanding and suggestions. Thank you sincerely.
Performed by Student : Ho Van Cuong
Student ID: 18574802010178
Class : K59-CLC-IT
Nghe An , June 6, 2021

Page 2


SPECIALIZED PROJECTS

Sales Manager

CHAPTER 1. OVERVIEW
1.1. Description of the problem
Sales management in enterprises is an important job, requiring the
Management department to conduct many complex operations.
The application of IT has brought a new breakthrough for sales management,
helping businesses capture information about goods, supplies, customer

information, and the status of orders... in a way. accurate and timely. From there,
managers can make the right plans and decisions, reduce costs and increase
competitiveness, and improve production and business results.
1.2. Subject specification
Sales management software must support the management of information for
businesses trading in goods and services ... automate the process of managing goods
and materials, reducing labor costs, and increasing the accuracy of orders and
provide prompt service to customers. It was developed with the aim of promptly
meeting all functions from import, export, inventory, goods arrangement
management, revenue, order management... in order to increase production and
business efficiency. for Business.
The management department of a ceramic shop has full control over the
system, some employees take on other tasks such as selling, importing goods,
recording information about customers, suppliers and customers. printing invoices.
Each type of goods that the company is allowed to trade usually includes
many items. Each item is identified by item name, unit of measure, suggested price
and assigned a code called item code for easy tracking. Shop owners, in addition to
capturing the market, also have to monitor the sales situation of their goods to do
business effectively. At the same time, receive a summary inventory report to see
which items are still below the allowable threshold, then propose to management
for a solution, possibly selling at a discount to recover capital for trading other
items.
Page 3


SPECIALIZED PROJECTS

Sales Manager

When the store buys goods, they have to carry out procedures for

warehousing. Each time the warehouse is imported, an import invoice is generated.
Each import invoice only deals with the import of goods from one supplier and is
made by an employee and is responsible for checking the quantity and quality of
imported goods. On the entry form, the supplier's code and name are clearly written
for easy tracking later; code and full name of the store employee responsible for
stocking the same items, quantity, expiry date, date of stocking, purchase unit price
and the corresponding amount. Import work happens every day when goods are
purchased.
When selling goods to customers, an invoice is issued. Invoices are issued by
only one employee and only for one customer. The invoice includes information
about item code, quantity, unit price, discount rate and total amount sold.
At the end of the month, the manager will make statistics of the items to
summarize the revenue and check the business situation of the store.

Page 4


SPECIALIZED PROJECTS

Sales Manager
CHAPTER 2.

SYSTEM SURVEY AND ANALYSIS
2.1. ANALYSIS OF TOPIC REQUIREMENTS
* THEME NAME “Building a sales management program”
2.1.1. FUNCTION
This is a sales management program that helps users manage their stores well.
Has the following functions:
- Allow to update rows in the database.
- Displays a list of items by category.

- Display the goods the customer has selected to buy.
- Display customer information
- Manage orders
- Updating goods, manufacturers, product types, ....
- Order processing.
- Statistics of customers who buy during the day, in a period of time
2.1.2. REQUIREMENTS
a. Equipment and software
- MySQL database management system
- Install Visual Studio 2019...
b. Systematic program requirements are as follows:
- The owner of the application has the right to control all activities of
the system. This person is provided with a username and password to log
into the system to perform his/her functions:
- Function to update, edit, delete items, types of goods, manufacturers,
customers, employees .... (must control the system). It requires precision.

Page 5


SPECIALIZED PROJECTS

Sales Manager

- Receive payment, check, issue invoices for customer orders. Display
orders.
- Statistics by date, time period.
In addition to the above functions, the chapter must be designed so that it is
easy to understand, the interface is easy to use, beautiful and easy for users to
manipulate.

2.2. SYSTEM ANALYSIS AND DESIGN
2.2.1. SITUATION SURVEY AND NEW SYSTEM BUILDING
* After the survey, I have grasped the following information:
- Customer management: Each customer can manage the following
information: full name, address, phone number, Date of birth and gender.
- Management of goods: goods code, name of goods, import price, selling
price, quantity, image, details, code of goods, name of goods.
- Manufacturer management: manufacturer code, manufacturer name,
representative, phone number, email.
- Employee management: full name, address, phone number, date of birth and
gender

2.2.2. SYSTEM ANALYSIS
-

Build functional hierarchy chart. Data Flow Diagram: We build the data flow
chart as follows

Page 6


SPECIALIZED PROJECTS

Sales Manager

SALE MANAGEMENT PROGRAM

Figure 2.1 function hierarchy chart

-


Functional hierarchy diagram of the Admin job

Fi
gure 2.2 Diagram of business functions Admin

Page 7


SPECIALIZED PROJECTS

-

Sales Manager

hierarchy diagram of warehouse management

Figure 2.3 Functional chart of warehouse management

-

Functional hierarchy diagram of the Sales operation

Page 8


SPECIALIZED PROJECTS

Sales Manager


Figure 2.4 Functional chart of sales .
-

Algorithm add, edit, delete

Figure 2.5 Block diagram add, edit, delete a field

Page 9


SPECIALIZED PROJECTS

Sales Manager

CHAPTER III. BUILDING MODELS – SCHEDULE

3.1. BUILD MODELS
3.1.1. Solutions

Figure 3.1 Diagrams model

3.1.2. SALES PROFIT DATABASE
-

The Users table stores the list of users. Table of fields:

Page 10


SPECIALIZED PROJECTS


Stt

column

Sales Manager

datatypes

meaning

int

User's

name
1

UserID (PK)

Automated Code
2

FullName

nvarchar(55)

Username and
surname


-

3

UserName

nvarchar(50)

User name

4

Password

nvarchar(150)

password

The Customers table stores a list of customers. The table contains the
following fields:

Stt

column name

datatypes

meaning

1


CustomerID

int

Automated

(PK)
2

customer code
CustomerName

nvarchar(50)

Customer
name

3

Sex

nvarchar(10)

Sex

4

Address


nvarchar(250)

Customer's
address

5

Phone

nvarchar(15)

Customer
phone

6
-

BirthDay

nvarchar(15)

Date of birth

The Categories table stores the type of goods. The table contains the
following fields:

St

column name


datatypes

meaning

Page 11


SPECIALIZED PROJECTS

Sales Manager

t
1

CategoryID(PK)

int

Commodity code

2

CategoryName

nvarchar(50)

Name of goods

3


Description

nvarchar(250

Note

)

-

The Suppliers table stores a list of suppliers of goods. The table contains the
following fields:

Stt

column name

datatypes

meaning

1

SupplierID(PK)

int

Supplier code

2


CompanyName

nvarchar(100)

Company
Name

3

ContactName

nvarchar(50)

Contact Name

4

Address

nvarchar(250)

Company
address

-

5

Phone


nvarchar(11)

Contact phone

6

Email

nvarchar(50)

email address

The Products table stores product details. The table contains the following
fields:

St

column name

datatypes

meaning

1

CategoryID

int


Commodity code

2

SupplierID (FK)

int

Supplier code

3

ProductID(PK)

int

Commodity

t
(FK)

codes

Page 12


SPECIALIZED PROJECTS

Sales Manager


4

ProductName

nvarchar(150)

Product Name

5

Quantity

float

Quantity

5

Importprice

float

Import price

6

Price

float


Price

7

Description

nvarchar(MAX)

Note

8

Image

Nvarchar(MAX

Images

date

Expiration Date

)
9

-

ExpirationDate

The Orders table stores purchase invoices. Table of fields:


Stt

column name

datatypes

meaning

1

CustemerID

int

Customer's code

2

OrderID (PK)

int

Code orders

3

StaffID (FK)

int


Employee code

4

OrderDate

datetime

Order Date

5

TotalAmount

float

Total Amount

(FK)

-

The OrderDetails table stores order details. The table contains the following
fields:

St

column name


datatypes

meaning

t

Page 13


SPECIALIZED PROJECTS

Sales Manager

1

OrderID (FK)

int

Code orders

2

DetailID (PK)

int

order detail code

3


ProductID

int

Product code

4

Quantity

float

Quantity

5

UnitPrice

float

Unit Price

6

Sale

float

Sale %


7

IntoMoney

float

Into Money

(FK)

-

The Staff table stores a list of employees. Table of fields:

Stt

column

datatypes

meaning

name
1

StaffID (PK)

int


Employee code

2

StaffName

nvarchar(50)

Staff Name

3

Sex

Nvarchar(10)

Sex

4

Address

nvarchar(250)

Address

5

Phone


nvarchar(11)

Contact phone

6

Birthday

datetime

Right of birth

7

Pass

Nvarchar(150)

password

3.2. Design the theme
3.2.1. Login form
- Form name: frmLogin
Sales staff need to log in to be able to access the general management page of
the store. If the login is not successful, the system will report an error and cannot
access the general management page.

Page 14



SPECIALIZED PROJECTS

Sales Manager

Figure 3.2 login form design

3.2.2. Main form
- Form name: frmMenu
Here, the owner or the employee can manipulate to select the function to do
his job.

Page 15


SPECIALIZED PROJECTS

Sales Manager

Figure 3.3 Menu form design

3.2.3. Category form
- Form name: UsCategory
Here, users who log in step 2 into the system can manage, add, edit, and delete
items. The manager cannot add or edit items with the same name as the data already
in the shop. In addition, the manager can search for product type name easily
through the search bar.

Page 16



SPECIALIZED PROJECTS

Sales Manager

Figure 3.4 Category form design

3.2.4. Customers form
- Form name: UsCustomers
Here, users who log into the system can manage, add, edit, and delete items.
The manager cannot add or edit customers that match the data already in the shop.
In addition, the manager can search for customers easily through the search bar.

Figure 3.5 Customers form design

Page 17


SPECIALIZED PROJECTS

Sales Manager

3.2.5. Suppliers form
- Form name: UsSuppliers
Here, users who log into the system can manage, add, edit, and delete items.
Managers cannot add or edit companies with existing data in the shop. In addition,
managers can search for suppliers easily through the search bar.

Figure 3.6 Suppliers form design

3.2.6. Staff form

- Form name: UsStaff
Here, users who log into the system can manage, add, edit, and delete items.
Managers cannot add or edit Employees that match data already in the shop. In
addition, managers can search for Employees easily through the search bar.

Page 18


SPECIALIZED PROJECTS

Sales Manager

Figure 3.7 Staff form design

3.2.7. Products form
- Form name: frmProducts
Here, users who log into the system can manage, add, edit, and delete items.
The manager cannot add or edit products that match the data already in the shop. In
addition, managers can search for products easily through the search bar.

Figure 3.9 Prpoducts form design

Page 19


SPECIALIZED PROJECTS

Sales Manager

3.2.8. Pass form

- Form name: UsPass
Here, users who log into the system can change their login password

Figure 3.10 Pass form design

3.2.9. Invoice form
- Form name: UsInvoice
Here, users who log in to the system can manage and add orders, Managers
cannot edit orders when the data is saved in the shop. In addition, the manager can
search for orders easily through the search bar.

Page 20


SPECIALIZED PROJECTS

Sales Manager

Figure 3.11 Invoice form design

3.2.12. Inventory form
- Form name: UsInventory
Here, users logged into the system can manage inventory easily through the
search bar.

Figure 3.12 Inventory form design
3.2.13. Revenue form:
- Form name: frmRevenue

Page 21



SPECIALIZED PROJECTS

Sales Manager

Here, users who log into the system can manage the store's revenue according
to the conditions that the management wants.

Figure 3.13 : Revenue form design

CONCLUDE
On the basis of studying knowledge from the ".NET Technology" textbook of
Teacher Hoang Huu Viet and some related documents, I carried out the topic "Sales
Management" and achieved the following results:
- Completed the objectives and tasks set out by a management system
program, with the same functions as the design analysis system described above.
- Build a complete program that can be applied in practice.
I would like to express my sincere thanks to Professor “Trần Xuân Sang” for
helping us to complete this thesis.
Due to limited qualifications and time, defects are inevitable. We look forward
to receiving the suggestions of teachers, teachers and friends to make the work more
complete.
Page 22


SPECIALIZED PROJECTS

Sales Manager


RESEARCH PAPERS

[1] />
Page 23