COSMETIC SHOP MANAGEMENT

SYSTEM

BY
Amna Ali
2016-ag-8357

Thesis submitted in partial fulfillment of

the requirements for the degree of

BACHOLAR OF SCIENCE
IN
COMPUTER SCIENCE

UNIVERSITY OF AGRICULTURE FAISALABAD

SUBCAMPUS BUREWALA-VEHARI.

June 2019
 DECLARATION

The work reported in this project was carried out by us under the supervision of Sir
Shakeel, University of Agriculture Faisalabad Subcampus Burewala-Vehari.

I hereby declare that the “Cosmetic Shop Management System” and the contents
of project is the product of our own research. I further declare that this work has not been
submitted for award of any other degree / diploma. The University may take action if the
information provided is found inaccurate at any stage.

Signature of the Student:

Registration No.: 2016-ag-8357

 CERTIFICATE BY THE PROJECT SUPERVISOR

This is to certify that Amna Ali Registration No. 2016-ag-8357 have successfully
completed the final project named as: Cosmetic Shop Management System, at the
Department of Computer Science, University of Agriculture Faisalabad subcampus
Burewala-vehari, to fulfill the partial requirement of the degree of BS (CS).

Internal Examiner
Name: Mr Shakeel

Signature:

External Examiner

Name:

Signature:

Principal
University of Agriculture
Faisalabad Subcampus
Burewala-vehari
Coordinator Projects:
 STATEMENT OF SUBMISSION

This is to certify that Amna Ali Registration No. 2016-ag-8357 has successfully completed
the semester project named as: Cosmetic Shop management System , at the Univeristy of
Agriculture Faisalabad Subsampus Burewala-vehari, to fulfill the partial requirement of the
degree of BS (CS).

Project Supervisor,
Designation Project Examiner
University of Agriculture Faisalabad Designation
Subcampus Burewala-Vehari.
 Acknowledgement

Firstly I am thankful to ALLAH ALMIGHTY who blessed me with knowledge to complete this
project with HIS mercy. I truly acknowledge the cooperation and help make by Name of Mr
Shakeel, teacher of University of Agricuture Faisalabad Subcampus Burewala-Vehari for
his help and guidance throughout this project. He has been a constant source of guidance
throughout the course of this project. I am also thankful to my friends and family especially my
father Syed Ajaz Ali Naqvi whose silent support led me to complete my project.

Amna Ali

rd
Date: May, 23 , 2019
 Summary

All the modules of Cosmetic system had developed already but the “Cosmetic Shop
Management System” is still working manually. I want to computerize it.
Cosmetic Shop Management system is a complete solution for managing a shop, in other words,
an enhanced tool that assists in organizing the day-to-day activites if a Shop.

There is a need of an application for efficient management and handling customer orders.

This Cosmetic Shop Management system keeps every record which is required for Staff, Admin,
Stock and Customer of that Shop and by reducing paperwork. This application is used for
keeping the information of Admin, Dealer, Customer, Purchasing and Stock. These records are
stored in the databasebwith security.
Your data be a secure and onlu authorized person can take the copy of data.
This Project is developed in Visual Studio 2013 using SQL Server.
 INDEX

Sr. No.
Title

1.
Introduction

2.
Limitations of Present System
3.
Proposed System:
a. Proposed System
b. Benefits of proposed system
c. Feasibility Study

5.
System Documentation :

a. Context Level Diagram

b. Entity Relationship Diagram

c. DFD

d. Use case Diagram

e. Sequence Diagram

f. Class Diagram
6.
System Preview
7.
Coding Preview
8.
System Implementation
9.
Conclusion
 Introduction

With tremendous increase in technology, information technology is a fast developing field.

Technology which is in vogue today might become redundant tomorrow. This ever changing scenario
makes it possible to provide the latest and most modern IT solutions to various business and institutions.

I am doing my project on Cosmetic Shop Management System. There is the need for efficient
management of a network based system for handling customer orders.

This project is an endeavor to provide a solution to this. The proposed system enables an
administrator to keep track of customer orders and maintaining records of the customers. He can view the
submitted requirements made by the customer. He can also view the reports generated by him and can
also sent approvals or rejections instantly.

Thus the project is a sincere effort in simplifying the task of administrators in an easily
usable format.

I finalized to make this project and hence planned to develop this system using Visual Studio
2013 for front end and SQL as the Back End.
LIMITATION OF THE PRESENT SYSTEM:

Before starting the project we have to study its limitations and objective some of them
are:-
 All the processes of this management are done manually in the form of paper work and
the records are stored in the registers. In such cases there are frequent chances of data
redundancy and data is ease to lose.
 All the introductions related to the patients and others printed on the papers, this activity
generates the chances of data lost.
 All the bills structures are done by hand written; sometimes it produces mistakes in
calculation.
 This system is very time consuming and require lost of manpower

PROPOSED SYSTEM:

Objective is to overcome the major limitation of the existing enabling effective management of
the customer details thereby improving the performance.

 With improved computerization being involved in the maintenance of customer details,

error and inconsistencies can be kept.
 Easy retrieval of data will be made possible by finding techniques.
 Validation of data will ensure only accurate, valid and complete data is stored in the
database.
 Proper monitoring of the processes from customer registration to activation. Report
generation will help make it easy to analyze the performance at the Bank.
 This will be much less time consuming comparing to existing system.

ADVANTAGES OF PROPOSED SYSTEM :

 With improved computerization being involved in the maintenance of Patient, Doctors,
and Staff details. Error and inconsistencies can be kept at per.

 Validation of data will be ensure only accurate valid and complete data stored in the
database.
 Easy retrieval or data will be made possible by finding techniques.

 Report generation will help made its easy to analyze the performance or clinic
Administration.
OBJECTIVE AND SCOPE OF PROPOSED SYSTEM:

 The objectives of the proposed system are to overcome the major limitation of existing
system enabling effective management of the customer details thereby improving the
performance of SHOP ADMINISTRTION.

 The system will store all the basic data processing needs the shop management.

Feasibility study
A feasibility study is undertaken to determine to the possibility or probability of either
improving the existing system or developing a completely new system. It helps to obtain the
overview of the problem and to get a rough assessment of whether other feasible solution exists.

NEEDS FOR FEASIBILITY STUDY:

The feasibility study is needed for following things:-

 Answer the questions whether a new system is to be installed or not?

 Determine the potential of the existing system.

 Improve the existing system.

 Know what should be embedded in the new system.

 Define the problems and objectives involved.

 Avoid costly repairs at later stage when system is implemented.

 Avoid crash implementation of the new system.

 Avoid the ‘Hardware approach’ i.e. getting a computer first and then deciding how to use
it.
 Context Level DIAGRAM

Context Level Diagram:

Account
Bill Login
Checking
Request for Item Admin (User)
Customer

Man. Login Details

Supply of Item
Payment Cosmetic Shop
Management
System
Payment

Supply of
Item
Login Bill
Staff (User) Supplier

Request for Item

Customer Record,
Create bills
 ENTITY RELTIONSHIP DIAGRAM (ERD)

Entity-Relationship Diagram

 An ERD is a model that identifies the concepts or entities that exist in a system and the
relationships between those entities.
ERD for Cosmetic Shop Management System

1/M
Choice
of
Produ
1/M 1
1
Customer 1/M
Order
1
1 1
Suggestions

B
ill

Searching 0/M

Products

1/M

1
Supplier
 Usecase Diagram

Login

Items/ Stock Details

Ask For Item

Customer Admin
Staff

Login Details Bill Details

Stock Details Account Details

 Data Flow Diagram (DFD)

A data flow diagram (DFD) is a graphical representation of the "flow" of data

through an information system. DFDs can also be used for thevisualization of data processing (structured
design).

CUSTOMER DETAILS

1.0

Customer Details

Customer Customer
CUSTOMER DETAILS
Customer Information

1.1 1.2 1.3

ADD UPDATE DELETE

1.4

SEARCH
 1.1

Customer Customer

ADD

1.2
Customer
Customer
UPDATE

1.3

Customer Customer

DELETE

1.4
Customer Customer

SEARCH
 2) BILL ORDER DETAILS

2.0

Order
Details
Bill Order Order
Order DETAILS
Order Information

2.1 2.2 2.3

ADD UPDATE DELETE

2.4

SEARCH
 3.DEALER / PRODUCT DETAILS

3.0

Product Details

PRODUCT
Dealer Order PRODUCT DETAILS e
Product Informati on

3.1 3.2 3.3 3.4 3.5

ADD UPDATE DELETE SEARCH EDIT

 4) EMPLOYEE DETAILS

7.0

Employee Details
Employee
Employee
Employee DETAILS
Employee Information

7.1 7.2 7.3

ADD UPDATE DELETE

7.4 7.5

SEARCH EDIT
Forms Used :

Sr.No. FORM-NAME DESCRIPTION

It is the main form. It contains all

1. MDI
the menu items.
It is the main form containing
2. Product
Product details.
It is the main form containing
3. Customer
Customer details.
It helps to enter the software if the
4. Login correct login name and password is
entered.

5. Splash It is start-up form.

6. Employee Details It gives details about the Employees.

Report List :

SR.NO REPORT NAME DESCRIPTION

1. Purchasing It gives the report of Purchasing Cosmetics.

2. Dealer Information It gives the report of all the dealer information.

3. Stock It gives the report of all stock.

 System Preview:

Splash Screen:

User Login Form:

User Home Page:

Admin Home Page:
Purchasing Form:

Change Password:
Sales Form:

RDLC Report of Purchase Cosmetics & Dealer Info.:

 Coding:

SplashScreen Coding:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace Cosmetics_System
{
public partial class SplashScreen : Form
{
public SplashScreen()
{
InitializeComponent();
}

private void timer1_Tick(object sender, EventArgs e)

{
progressBar1.Increment(1);
label1.Text = progressBar1.Value.ToString()+"%";
if(progressBar1.Value==100)
{
timer1.Stop();
}

}
}

Login:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Cosmetics_System
{
public partial class login : Form
 {
SqlConnection con = new SqlConnection(@"Data
Source=(LocalDB)\v11.0;AttachDbFilename=E:\BSCS\6th semester\Visual
Programming\Cosmetics System\Cosmetics System\Cosmetics System\
CosmeticSystem.mdf;Integrated Security=True");
public login()
{
InitializeComponent();

private void login_Load(object sender, EventArgs e)

{
if(con.State==ConnectionState.Open)
{
con.Close();
}
con.Open();
}

private void button1_Click(object sender, EventArgs e)

{
int i=0;
SqlCommand cmd=con.CreateCommand();
cmd.CommandType=CommandType.Text;
cmd.CommandText="select * from admin where username='"+textBox1.Text+"' and
password='"+textBox2.Text+"'";
cmd.ExecuteNonQuery();
DataTable dt=new DataTable();
SqlDataAdapter da=new SqlDataAdapter(cmd);
da.Fill(dt);
i=Convert.ToInt32(dt.Rows.Count.ToString());
if(i==0)
{
MessageBox.Show("This username password does not match");
}
else
{
this.Hide();
Home mdi=new Home();
mdi.Show();
}
}
private void button2_Click(object sender, EventArgs e)
{

Hide();
UserLogin ad = new UserLogin();
ad.Show();
}
}
}
Purchase Form:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Cosmetics_System
{
public partial class purchase : Form
{
SqlConnection con=new SqlConnection(@"Data Source=(LocalDB)\
v11.0;AttachDbFilename=E:\BSCS\6th semester\Visual Programming\
Cosmetics System\Cosmetics System\Cosmetics System\
CosmeticSystem.mdf;Integrated Security=True");
public purchase()
{
InitializeComponent();
}

private void purchase_Load(object sender, EventArgs e)

{
if(con.State==ConnectionState.Open)
{
con.Close();
}
con.Open();
dg();
fill_cosmetic_name();
fill_dealer_name();
}
public void fill_cosmetic_name()
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select *from cosmetic_name";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach(DataRow dr in dt.Rows)
{
comboBox1.Items.Add(dr["cosmetic_name"].ToString());
}
}
public void fill_dealer_name()
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
 cmd.CommandText = "select *from dealer_info";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
comboBox2.Items.Add(dr["dealer_name"].ToString());
}
}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)

{
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select *from cosmetic_name where
cosmetic_name='"+comboBox1.Text+"'";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
label4.Text = dr["unit"].ToString();
}
}

private void textBox2_Leave(object sender, EventArgs e)

{
textBox3.Text =Convert.ToString(Convert.ToInt32(textBox1.Text) *
Convert.ToInt32(textBox2.Text));
}

private void button1_Click(object sender, EventArgs e)

{
try
{
if (this.comboBox1.Text.Trim() == "")
{
MessageBox.Show("Enter Cosmetic Name.......");
comboBox1.Focus();
}
else if (this.textBox1.Text.Trim() == "")
{
MessageBox.Show("Enter Cosmetic Quantity.....");
textBox1.Focus();
}
else if (this.textBox2.Text.Trim() == "")
{
MessageBox.Show("Enter Cosmetic Price");
textBox2.Focus();
}
else if (this.textBox3.Text.Trim() == "")
{
MessageBox.Show("Enter Total....");
 textBox3.Focus();
}
else if (this.dateTimePicker1.Text.Trim() == "")
{
MessageBox.Show("Enter your Purchasing date....");
dateTimePicker1.Focus();
}
else if (this.comboBox2.Text.Trim() == "")
{
MessageBox.Show("Please Select Dealer Name....");
comboBox2.Focus();
}
else if (this.comboBox3.Text.Trim() == "")
{
MessageBox.Show("Please Select Purchase Type....");
comboBox3.Focus();
}
else if (this.dateTimePicker2.Text.Trim() == "")
{
MessageBox.Show("Enter your Expiry date......");
dateTimePicker2.Focus();
}
else if (this.textBox4.Text.Trim() == "")
{
MessageBox.Show("Enter Profit....");
textBox4.Focus();
}
else
{
int i;
SqlCommand cmd1 = con.CreateCommand();
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = "select *from stock where cosmetic_name='" +
comboBox1.Text + "'";
cmd1.ExecuteNonQuery();
DataTable dt1 = new DataTable();
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
da1.Fill(dt1);
i = Convert.ToInt32(dt1.Rows.Count.ToString());
if (i == 0)
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into purchase_master values('" + comboBox1.Text
+ "','" + textBox1.Text + "','" + label4.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','"
+ dateTimePicker1.Value.ToString("dd-MM-yyyy") + "','" + comboBox2.Text + "','" +
comboBox3.Text + "','" + dateTimePicker2.Value.ToString("dd-MM-yyyy") + "','" +
textBox4.Text + "')";
cmd.ExecuteNonQuery();

SqlCommand cmd3 = con.CreateCommand();

cmd3.CommandType = CommandType.Text;
cmd3.CommandText = "insert into stock values('" + comboBox1.Text + "','" +
textBox1.Text + "','" + label4.Text + "')";
cmd3.ExecuteNonQuery();
 }
else
{
SqlCommand cmd2 = con.CreateCommand();
cmd2.CommandType = CommandType.Text;
cmd2.CommandText = "insert into purchase_master values('" + comboBox1.Text
+ "','" + textBox1.Text + "','" + label4.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','"
+ dateTimePicker1.Value.ToString("dd-MM-yyyy") + "','" + comboBox2.Text + "','" +
comboBox3.Text + "','" + dateTimePicker2.Value.ToString("dd-MM-yyyy") + "','" +
textBox4.Text + "')";
cmd2.ExecuteNonQuery();

SqlCommand cmd5 = con.CreateCommand();

cmd5.CommandType = CommandType.Text;
cmd5.CommandText = "update stock set cosmetic_qty=cosmetic_qty+ '" +
textBox1.Text + "' where cosmetic_name='" + comboBox1.Text + "'";
cmd5.ExecuteNonQuery();
}

dg();
MessageBox.Show("Record Inserted Successfully********");
}

}
catch(Exception ex)
{
MessageBox.Show("Error Occured..." + ("\n\r" + ex.Message));
}
}
public void dg()
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select *from purchase_master";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
}

private void button2_Click(object sender, EventArgs e)

{
int id;
id = Convert.ToInt32(dataGridView1.SelectedCells[0].Value.ToString());
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "delete from purchase_master where id='" + id + "'";
cmd.ExecuteNonQuery();
dg();
}

private void button3_Click(object sender, EventArgs e)

 {
try
{
SqlCommand cmd;
int msg;
int id;
id = Convert.ToInt32(dataGridView1.SelectedCells[0].Value.ToString());

string q1 = "update purchase_master set cosmetic_name='" +

comboBox1.SelectedItem.ToString() + "', cosmetic_qty='" + textBox1.Text + "',
cosmetic_unit='" + label4.Text + "',cosmetic_price='" + textBox2.Text + "',cosmetic_total='" +
textBox3.Text + "',purchase_date='" + dateTimePicker1.Value.ToString("dd-MM-yyyy") +
"',purchase_party_name='" + comboBox2.SelectedItem.ToString() + "',purchase_type='" +
comboBox3.SelectedItem.ToString() + "',expirydate='" + dateTimePicker2.Value.ToString("dd-
MM-yyyy") + "',profit='" + textBox4.Text + "' where id='" + id + "'";
cmd = new SqlCommand(q1, con);
msg = cmd.ExecuteNonQuery();
if (msg == 1)
{
MessageBox.Show("Updated Successfully....");
dg();

}
catch (Exception ex)
{
MessageBox.Show("Error Occured" + ("\n\r" + ex.Message));

}
}

private void button6_Click(object sender, EventArgs e)

{
Hide();
Home hm = new Home();
hm.Show();
}

private void btn_search_Click(object sender, EventArgs e)

{
SqlConnection con = new SqlConnection(@"Data
Source=(LocalDB)\v11.0;AttachDbFilename=E:\BSCS\6th semester\Visual
Programming\Cosmetics System\Cosmetics System\Cosmetics System\
CosmeticSystem.mdf;Integrated Security=True");
string query = "select *from purchase_master where cosmetic_name like @name +'%'";
SqlDataAdapter sda = new SqlDataAdapter(query, con);
sda.SelectCommand.Parameters.AddWithValue("@name", searchtb.Text.Trim());
DataTable dt = new DataTable();
sda.Fill(dt);
dataGridView1.DataSource = dt;
}

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)

{
 int selectedRow = e.RowIndex;
DataGridViewRow row = dataGridView1.Rows[selectedRow];
comboBox1.Text = row.Cells[1].Value.ToString();
textBox1.Text = row.Cells[2].Value.ToString();
label4.Text = row.Cells[3].Value.ToString();
textBox2.Text = row.Cells[4].Value.ToString();
textBox3.Text = row.Cells[5].Value.ToString();
dateTimePicker1.Text =row.Cells[6].Value.ToString();
comboBox2.Text = row.Cells[7].Value.ToString();
comboBox3.Text = row.Cells[8].Value.ToString();
dateTimePicker2.Text = row.Cells[9].Value.ToString();
textBox4.Text = row.Cells[10].Value.ToString();

}
}

SYSTEM IMPLEMENTATION

TECHNOLOGY USED

I HAVE DONE THE PROJECT IN VISUAL STUDIO 2013 & mySQL

INTRODUCTION TO VISUAL STUDIO 2013

VISUAL STUDIO has been used to develop the front end for this application.
It is a structured programming language and complete application development tool for the Microsoft
windows operating System. It is not just a language it’s an integrated development environment (IDE) in
which you develop, run , test and debug your applications.
Visual Studio provides help for the easy development of excellent GUI’s (Graphical user
interfaces). It is an efficient interaction environment for designing forms and windows.
Programming in Visual Studio is event-driven, which means the flow of the application will
depend on the way the user interacts with it. In Visual Studio you can quickly design the visual elements
of any new programming project.
Your program’s interface may include the familiar controls that windows users already know how
to operate such as command buttons, option ,lists ,textbox ,and scroll bars. With just few mouse actions,
you can add any combination of these controls to a program. As a result, the design tasks that used to
require many hours of detailed programming effort could be completed in minutes.
Besides, connection to any type of database can achieve with the help of its Active-X Data
Objects Data Connector .ADODC allows you to connect to databases, retrieve data from them or insert
data with very little effort.

VISUAL STUDIO CONTROL PANEL

For the creating application we use controls like text box controls, check box controlled and each control
has unique properties. There are 9 controls as follows.

1. Textbox control
2. Command buttons
3. Status Bar
4. Combo Box control
 5. DT Picker control
6. Tab Strip
7. Progress Bar

FEATURES OF SQL

 New object, properties, methods and other language elements.

 Accessing the intranet or Internet from your application
 Creating custom objects with class modules.
 Using new features in the module window.
 Using the object browser as a reference for objects of their members.
 Setting reference programmatically.
 Improving compilation performance

Security:
 Cosmetic Shop Management System makes use of security in the form of User ID’s and Passwords.
 In order to use this system, the administrator has to enter his password. The password entered by the
administrator is compared with the one in the database and if it matches then the application precedes
it to open.
 At no point in time the administrator can recover his password if he forgets it. However it is
recommended that the administrator change his /her password in the database.
 For security purposes it is recommended that the administrator change his password every 2 weeks.
 Besides this on the backend system makes use of SQL, which is very secure DBMS. At all point in
the DBMS checks the username and password before making a connection. If the username and
passwords match then the connection is allowed else it is not allowed.

Conclusion:
The demand of Visual Studio for application is increasing day by day in Software industry, due to high
expectations of client companies.

Hence an attempt of automating an office application had added to our learning experience.

It has also helped in adopting an analytical approach to solving and made us realize that system
development is a step by step process, Indeed it was a great learning experience.