Cosmetic Store Management System Project Report
Cosmetic Store Management System Project Report
Cosmetic Store Management System Project Report
1
Introduction
2
Introduction to Project
I am doing my project on Cosmetic Shop Management. 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.
I finalized to make this project and hence planned to develop this system using Visual
Studio 2008 for front end and SQL as the Back End.
3
GANTT CHART
1. Project Search 1
2. Finalization 2
3. Allocation 3
Investigation of
System
4. Requirements 4
6. System Design 6
7. Program Design 7
8. Program Coding 8
9. Unit Testing 9
System
11. Implementation 11
W1 W2 W3 W4 W5 W6 W7 W8 W9 W10
W11 W12 W13 W14 W15 W16 W17 W18 W19
W20 W21
4
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:
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.
5
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.
Avoid the ‘Hardware approach’ i.e. getting a computer first and then deciding how to use
it.
TECHNICAL FEASIBILITY
ECONOMIC FEASIBILITY
OPERATIONAL FEASIBILITY
ECONOMIC FEASIBILITY
Economic analysis is most frequently used for evaluation of the effectiveness of the system.
More commonly known as cost/benefit analysis the procedure is to determine the benefit and
saving that are expected from a system and compare them with costs, decisions is made to
design and
Implement the system.
6
This part of feasibility study gives the top management the economic justification for the new
system. This is an important input to the management the management, because very often the
top management does not like to get confounded by the various technicalities that bound to be
associated with a project of this kind. A simple economic analysis that gives the actual
comparison of costs and benefits is much more meaningful in such cases.
In the system, the organization is most satisfied by economic feasibility. Because, if the
organization implements this system, it need not require any additional hardware resources as
well as it will be saving lot of time.
TECHNICAL FEASIBILITY
Technical feasibility centers on the existing manual system of the test management process and
to what extent it can support the system.
According to feasibility analysis procedure the technical feasibility of the system is analyzed and
the technical requirements such as software facilities, procedure, inputs are identified. It is also
one of the important phases of the system development activities.
The system offers greater levels of user friendliness combined with greater processing speed.
Therefore, the cost of maintenance can be reduced. Since, processing speed is very high and the
work is reduced in the maintenance point of view management convince that the project is
operationally feasible.
BEHAVIOURAL FEASIBILITY
People are inherently resistant to change and computer has been known to facilitate changes. An
estimate should be made of how strong the user is likely to move towards the development of
computerized system. These are various levels of users in order to ensure proper authentication
and authorization and security of sensitive data of the organization.
7
The prototyping model
The mode is used for developing the “Exam Tool” is the prototyping model.
Prototyping Model is based on the idea of developing an initial implementation, exposing this to
user comment and defining this through many until an adequate system has been developed.
The prototype serves as a basis for writing the specification for a production
quality system. Though the principle purpose of prototyping is to validate
software requirements, software prototype also has other uses.
A prototype system can be used for training users before the formal system has
been delivered.
Prototype can be run back-to-back tests. This reduces the need for tedious manual
checking of test run. The same test is given to both the prototype and the system
8
under test to look for differences in the final results and thereby making necessary
changes. Thus prototype serves as a technique of risk reduction.
The prototype paradigm can be either close ended (throwaway prototyping) or open
ended(evolutionary prototyping). Before selecting closed or open-ended approach, it is
necessary to determine whether the system to be built is suitable for prototyping or not.
This is decided depending on application area, complexity, and customer characteristics
and projects characteristics. Prototyping or evolutionary prototyping. The throwaway is
developed to understand the system requirements while the evolutionary prototype
evolves through a number of versions to the final system.
9
DIAGRAMS
10
CONTEXT LEVEL DIAGRAM
Account Checking
Bill Login
Request for Item Admin
Customer (User)
Payment
Supply of Item
Bill
Login
Staff Supplier
(User)
Request for Item
Customer Record,
Create bills
11
Choice of Product
Bill
Inquiry
Products
Supplier
12
Entity-Relationship Diagram
13
Choice of Product
1/M
1/M 1
1 1/M
Order Customer Suggestions
1 1 1 1
Bill
1/M
Inquiry 0/M
Products
1/M
1
Supplier
Event Table
14
The event table is a table of data that is typically written to the log file for each scenario and also
appears in the Analysis window. The event table contains timing information about specific
events that occur during the scenario.
Customer Ask for Item Customer Create new Customer Sells Person
Registration Bill registered
Sells Person Stock Inquiry Customer Look up Stock details Customer
check Stock
availability of availability
Stock
Customer select Enquiry about Sells selecting Item selected Customer
Item Item Person
Sells Person Check the Staff Look up in Item given Customer
gives Item to Price register
Customer
Produce Bill Quantity Sells Checking the Bill report Customer
report inquiry Person Stock
Customer Ask for Bill Sells checking Data checked Accountant
Checks data Person
Summary of End of day Sells Person Produce Bill Bill summary Admin
Bill report summary report (Owner)
report
System Chart
15
A flowchart that emphasizes the component operations which make up a system.
GENERATES
BILL DATABASE
BILL BILL
CUSTOMER
CUSTOMERDATABASE
CUSTOMER
EMPLOYEE
EMPLOYEEDATABASE
Cosmetic EMPLOYEE
Shop
Management
SHOP
ACCOUNT
PRODUCTS
PRODUCT / SUPPLIER DATABASE
PRODUCTS
Structure chart
16
A Structure Chart (SC) in software engineering and organizational theory is a chart, which
shows the breakdown of the configuration system to the lowest manageable levels.
This chart is used in structured programming to arrange the program modules in a tree structure.
Each module is represented by a box, which contains the module's name. The tree structure
visualizes the relationships between the modules.
Bill details
Reports
Peripherals details
Bill
Order
Details
Customer details
MENU TREE
17
Register
Customer
User Employee
Details
Salary
Bill
Employee
Details
Usecase Diagram
A use case diagram in the Unified Modeling Language (UML) is a type of behavioral diagram
defined by and created from a Use-case analysis. Its purpose is to present a graphical overview
of the functionality provided by a system in terms of actors, their goals (represented as use
cases), and any dependencies between those use cases.
Login
18
Ask For Item Items/ Stock Details
Customer Admin Staff
CUSTOMER DETAILS
19
1.0
Customer
Details
Customer
Customer CUSTOMER
DETAILS Customer Information
1.4
SEARCH
1.1
Customer Customer
ADD
1.2
20
Customer
Customer
UPDATE
1.3
Customer Customer
DELETE
1.4
Customer Customer
SEARCH
1.1
ACCOUNT
ADD
2.0
Order
Details
Order
Bill Order
Order 21
DETAILS
Order Information
2.1 2.2 2.3
2.4
SEARCH
3.0
Product
Details
PRODUCT
Dealer Order PRODUCT e
DETAILS Product
Information
22
3.1 3.2 3.3 3.4 3.5
4) EMPLOYEE DETAILS
7.0
Employee
Details Employee
Employee Employee DETAILS
Employee Information
23
7.1 7.2 7.3
7.4 7.5
SEARCH EDIT
PACKAGE DIAGRAM
Log Management
Subsystem
Forms Used :
25
It is the main form containing
3. Customer
Customer details.
It gives information about the
4. About
software
It contains details about the Last Bill
5. Bill
Generated.
It helps to enter the software if the
6. Login correct login name and password is
entered.
Table Used :
26
It contains data of all the Debits in the
4. Debit
shop .
It contains data of all the Credits in the
5. Credit
shop.
It contains data of all the Salaries
6. Employee Salary
generated for the Employees.
Report List :
2. Employee Salary It gives the report of all the employee salary slips.
Pseudo Code :
27
Naming Convention
28
System Screen
Login Page:
29
MDI Form :
30
Supplier Details:
Profit :
31
Customer Bill :
32
Employee Details :
EMPSalary Slip:
33
Dealer Report :
34
Customer Details Report :
EMP Report :
35
Salary Report :
36
Coding
Login Page :
Imports System.Data.SqlClient
37
Public Class Login
Dim sql = "SELECT username,password FROM Login WHERE username = '" &
UsernameTextBox.Text & "' AND password = '" & PasswordTextBox.Text & "'"
Try
If dr.Read = False Then
MessageBox.Show("Authentication Failed...")
Else
MessageBox.Show("Login Successful...")
MDIParent1.Show()
Me.Hide()
End If
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
End Class
MDI Form :
Imports System.Windows.Forms
Public Class MDIParent1
Private Sub ShowNewForm(ByVal sender As Object, ByVal e As EventArgs)
' Create a new instance of the child form.
Dim ChildForm As New System.Windows.Forms.Form
' Make it a child of this MDI form before showing it.
ChildForm.MdiParent = Me
38
m_ChildFormNumber += 1
ChildForm.Text = "Window " & m_ChildFormNumber
ChildForm.Show()
End Sub
If (SaveFileDialog.ShowDialog(Me) =
System.Windows.Forms.DialogResult.OK) Then
Dim FileName As String = SaveFileDialog.FileName
' TODO: Add code here to save the current contents of the form to
a file.
End If
End Sub
39
End Sub
40
profit.Show()
End Sub
End Class
Bill Report :
Imports System.Data.SqlClient
Imports System.Data
'Imports CrystalDecisions.CrystalReports.Engine
41
Dim cmdAdd2 As New SQLCommand
txt_billid.Text = ""
txt_cname.Text = ""
cmb_pname.Text = ""
txt_price.Text = ""
txt_qty.Text = ""
txt_amt.Text = ""
End Sub
cnnSQL.Open()
Dim dr = cmd.ExecuteReader
While dr.Read()
cmb_pname.Items.Add(dr("product_name"))
End While
dr.Close()
cnnSQL.Close()
btnAdd.Enabled = True
btnSave.Enabled = False
btnReport.Enabled = True
42
End Sub
End If
End If
End Sub
Private Sub txt_cname_keyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles txt_cname.KeyPress
onlyAlphabets(e)
End Sub
cnnSQL.Open()
'MsgBox(cmdDelete.CommandText)
cmdDelete.CommandType = CommandType.Text
cmdDelete.Connection = cnnSQL
cmdDelete.ExecuteNonQuery()
btnAdd.Enabled = False
btnSave.Enabled = True
cnnSQL.Close()
End Sub
43
Private Sub txt_price_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles txt_price.KeyPress
If (Microsoft.VisualBasic.Asc(e.KeyChar) < 48) Or
(Microsoft.VisualBasic.Asc(e.KeyChar) > 57) Then
e.Handled = True
End If
If (Microsoft.VisualBasic.Asc(e.KeyChar) = 8) Then
e.Handled = False
End If
End Sub
cnnSQL.Open()
While dr1.Read()
lbl1.Text = dr1(4)
End While
dr1.Close()
cnnSQL.Close()
End Sub
End Sub
44
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnSave.Click
cnnSQL.Open()
End If
'MsgBox(cmdAdd.CommandText)
cmdAdd.CommandType = CommandType.Text
cmdAdd.Connection = cnnSQL
cmdAdd.ExecuteNonQuery()
cnnSQL.Close()
cnnSQL.Open()
'MsgBox(cmdAdd.CommandText)
cmdAdd1.CommandType = CommandType.Text
cmdAdd1.Connection = cnnSQL
cmdAdd1.ExecuteNonQuery()
cnnSQL.Close()
cnnSQL = New SqlConnection("Data
Source=.\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\Data\Cosmetic.mdf;Integrated Security=True;User
Instance=True;")
45
cnnSQL.Open()
cmdAdd2.CommandText = "INSERT INTO credit (credit_date, credit_amount,
credit_description) VALUES ('" & dtp_billdate.Value & "','" & txt_amt.Text &
"','" & txt_cname.Text & "');"
cmdAdd2.CommandType = CommandType.Text
cmdAdd2.Connection = cnnSQL
cmdAdd2.ExecuteNonQuery()
cnnSQL.Close()
MsgBox("Record Inserted.")
btnSave.Enabled = False
btnReport.Enabled = True
End Sub
46
Exit Sub
Else
Dim q As Integer = Val(txt_qty.Text)
Dim p As Integer = Val(txt_price.Text)
Dim t As Integer = q * p
txt_amt.Text = Val(txt_amt.Text) + t
lblhide.Text = Val(lbl1.Text) - Val(txt_qty.Text)
cnnSQL = New SqlConnection("Data
Source=.\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\Data\Cosmetic.mdf;Integrated Security=True;User Instance=True")
cnnSQL.Open()
cmdSave.CommandText = "UPDATE dealer_order SET quantity = '" &
lbl1.Text & "' WHERE product_name = '" & cmb_pname.Text & "';"
cmdSave.CommandType = CommandType.Text
cmdSave.Connection = cnnSQL
cmdSave.ExecuteNonQuery()
lb_pname.Text = lb_pname.Text + " : " + cmb_pname.Text
End If
End Sub
Private Sub txt_cname_TextChanged(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles txt_cname.TextChanged
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs)
Customer_Bill_Report_Form.Show()
End Sub
Private Sub cmb_pname_SelectedIndexChanged(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles cmb_pname.SelectedIndexChanged
End Sub
End Class
Customer :
Imports System.Data.Sqlclient
Imports System.Data
Public Class customer
Dim cnnSQL As New SQLConnection
Dim cmdSQL As New SQLCommand
Dim cmdAdd As New SQLCommand
Dim cmdSave As New SQLCommand
Dim cmdDelete As New SQLCommand
Dim flag As Integer
Private BS As New BindingSource
Private Sub clear()
txt_id.Text = ""
txt_cname.Text = ""
txt_amt.Text = ""
End Sub
Private Sub customer_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
txt_id.Enabled = False
txt_cname.Enabled = False
txt_amt.Enabled = False
dtp_bill.Enabled = False
Dim ds As New DataSet
47
cnnSQL = New SqlConnection("Data
Source=.\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\Data\Cosmetic.mdf;Integrated Security=True;User Instance=True")
cnnSQL.Open()
Call clear()
Dim Sql = "SELECT * FROM customer"
Dim da = New SqlDataAdapter(Sql, cnnSQL)
da.Fill(ds, "customer")
' Set the Binding Source
BS.DataSource = ds.Tables("customer")
txt_id.DataBindings.Add("Text", BS, "bill_id")
dtp_bill.DataBindings.Add("Text", BS, "bill_date")
txt_cname.DataBindings.Add("Text", BS, "customer_name")
txt_amt.DataBindings.Add("Text", BS, "total_amount")
End Sub
48
Me.Hide()
Me.Close()
End Sub
49
btnSearch.Enabled = True
btnFirst.Enabled = True
btnPrevious.Enabled = True
btnNext.Enabled = True
btnLast.Enabled = True
End Sub
Dealer :
Imports System.Data.Sqlclient
Imports System.Data
Public Class dealer
Dim cnnSQL As New SQLConnection
Dim cmdSQL As New SQLCommand
Dim cmdAdd As New SQLCommand
Dim cmdAdd1 As New SQLCommand
Dim cmdSave As New SQLCommand
Dim cmdDelete As New SQLCommand
Dim flag As Integer
Private BS As New BindingSource
Private Sub clear()
txt_id.Text = ""
txt_pname.Text = ""
txt_price.Text = ""
txt_qty.Text = ""
txt_amt.Text = ""
End Sub
50
btnPrevious.Enabled = False
btnNext.Enabled = False
btnLast.Enabled = False
End Sub
End Sub
If flag = 2 Then
cmdAdd.CommandText = "INSERT INTO dealer_order (order_id,
order_date, product_name, product_price, quantity, total_amount) VALUES ('" &
txt_id.Text & "','" & dtp_order.Value & "','" & txt_pname.Text & "','" &
txt_price.Text & "','" & txt_qty.Text & "','" & txt_amt.Text & "');"
'MsgBox(cmdAdd.CommandText)
cmdAdd.CommandType = CommandType.Text
cmdAdd.Connection = cnnSQL
cmdAdd.ExecuteNonQuery()
cmdAdd1.CommandText = "INSERT INTO debit (debit_date,
debit_amount, debit_description) VALUES ('" & dtp_order.Value & "','" &
txt_amt.Text & "','" & txt_pname.Text & "');"
'MsgBox(cmdAdd.CommandText)
cmdAdd1.CommandType = CommandType.Text
cmdAdd1.Connection = cnnSQL
cmdAdd1.ExecuteNonQuery()
MsgBox("Record Inserted.")
51
Call clear()
btnSave.Text = "Update"
btnAdd.Enabled = True
btnDelete.Enabled = True
btnSearch.Enabled = True
btnFirst.Enabled = True
btnPrevious.Enabled = True
btnNext.Enabled = True
btnLast.Enabled = True
Dim ds As New DataSet
' Make the Connection
cnnSQL = New SqlConnection("Data
Source=.\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\Data\Cosmetic.mdf;Integrated Security=True;User Instance=True")
cnnSQL.Open()
Call clear()
btnSave.Text = "Update"
Dim Sql = "SELECT * FROM dealer_order"
Dim da = New SqlDataAdapter(Sql, cnnSQL)
da.Fill(ds, "dealer_order")
' Set the Binding Source
BS.DataSource = ds.Tables("dealer_order")
End If
If flag = 1 Then
cmdSave.CommandText = "UPDATE dealer_order SET order_date = '" &
dtp_order.Value & "', product_name='" & txt_pname.Text & "', product_price='"
& txt_price.Text & "', quantity='" & txt_qty.Text & "', total_amount='" &
txt_amt.Text & "' WHERE order_id = '" & txt_id.Text & "';"
'MsgBox(cmdSave.CommandText)
cmdSave.CommandType = CommandType.Text
cmdSave.Connection = cnnSQL
cmdSave.ExecuteNonQuery()
MsgBox("Record Updated.")
Call clear()
Dim ds As New DataSet
' Make the Connection
cnnSQL = New SqlConnection("Data
Source=.\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\Data\Cosmetic.mdf;Integrated Security=True;User Instance=True")
cnnSQL.Open()
Call clear()
flag = 1
btnSave.Text = "Update"
Dim Sql = "SELECT * FROM dealer_order"
Dim da = New SqlDataAdapter(Sql, cnnSQL)
da.Fill(ds, "dealer_order")
' Set the Binding Source
BS.DataSource = ds.Tables("dealer_order")
End If
cmdSave.Dispose()
cmdAdd.Dispose()
End Sub
52
If BS.Count = 0 Then
MsgBox("Records are Empty")
End If
BS.MovePrevious()
flag = 1
End Sub
BS.MoveFirst()
flag = 1
End Sub
53
cnnSQL = New SqlConnection("Data
Source=.\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\Data\Cosmetic.mdf;Integrated Security=True;User Instance=True")
cnnSQL.Open()
Call clear()
flag = 1
btnSave.Text = "Update"
Dim Sql = "SELECT * FROM dealer_order"
Dim da = New SqlDataAdapter(Sql, cnnSQL)
da.Fill(ds, "dealer_order")
' Set the Binding Source
BS.DataSource = ds.Tables("dealer_order")
cmdDelete.Dispose()
Else
MsgBox("Enter the required values:" & vbNewLine & "1. Order ID")
End If
cmdSave.Dispose()
End Sub
54
btnNext.Enabled = False
btnLast.Enabled = False
End Sub
Private Sub btnRefresh_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnRefresh.Click
Dim ds As New DataSet
' Make the Connection
cnnSQL = New SqlConnection("Data
Source=.\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\Data\Cosmetic.mdf;Integrated Security=True;User Instance=True")
cnnSQL.Open()
Call clear()
flag = 1
btnSave.Text = "Update"
Dim Sql = "SELECT * FROM dealer_order"
Dim da = New SqlDataAdapter(Sql, cnnSQL)
da.Fill(ds, "dealer_order")
' Set the Binding Source
BS.DataSource = ds.Tables("dealer_order")
btnSave.Enabled = True
btnAdd.Enabled = True
btnDelete.Enabled = True
btnSearch.Enabled = True
btnFirst.Enabled = True
btnPrevious.Enabled = True
btnNext.Enabled = True
btnLast.Enabled = True
End Sub
55
End Sub
Employee Details :
Imports System.Data.Sqlclient
Imports System.Data
Public Class employee_details
txt_id.Text = ""
txt_name.Text = ""
txt_add.Text = ""
txt_no.Text = ""
cmb_designation.Text = ""
txt_salary.Text = ""
End Sub
cnnSQL.Open()
Call clear()
flag = 1
btnSave.Text = "Update"
56
Dim Sql = "SELECT * FROM employee_details"
Dim da = New SqlDataAdapter(Sql, cnnSQL)
da.Fill(ds, "employee_details")
cnnSQL.Open()
Call clear()
flag = 2
btnSave.Text = "Save"
btnNew.Enabled = False
btnDelete.Enabled = False
btnSearch.Enabled = False
btnFirst.Enabled = False
btnPrevious.Enabled = False
btnNext.Enabled = False
btnLast.Enabled = False
End Sub
57
If txt_id.Text = "" Or txt_name.Text = "" Or txt_add.Text = "" Or
txt_no.Text = "" Or cmb_designation.Text = "" Or txt_salary.Text = "" Then
End If
If flag = 2 Then
If txt_id.Text <> "" And txt_name.Text <> "" And txt_add.Text <>
"" And txt_no.Text <> "" And cmb_designation.Text <> "" And txt_salary.Text <>
"" Then
'MsgBox(cmdAdd.CommandText)
cmdAdd.CommandType = CommandType.Text
cmdAdd.Connection = cnnSQL
cmdAdd.ExecuteNonQuery()
MsgBox("Record Inserted.")
Call clear()
btnSave.Text = "Update"
btnNew.Enabled = True
btnDelete.Enabled = True
btnSearch.Enabled = True
btnFirst.Enabled = True
btnPrevious.Enabled = True
btnNext.Enabled = True
btnLast.Enabled = True
cnnSQL.Open()
Call clear()
btnSave.Text = "Update"
58
Dim Sql = "SELECT * FROM employee_details"
Dim da = New SqlDataAdapter(Sql, cnnSQL)
da.Fill(ds, "employee_details")
End If
End If
If flag = 1 Then
If txt_id.Text <> "" And txt_name.Text <> "" And txt_add.Text <>
"" And txt_no.Text <> "" And cmb_designation.Text <> "" And txt_salary.Text <>
"" Then
'MsgBox(cmdSave.CommandText)
cmdSave.CommandType = CommandType.Text
cmdSave.Connection = cnnSQL
cmdSave.ExecuteNonQuery()
MsgBox("Record Updated.")
Call clear()
cnnSQL.Open()
Call clear()
flag = 1
btnSave.Text = "Update"
da.Fill(ds, "employee_details")
59
End If
End If
cmdSave.Dispose()
cmdAdd.Dispose()
End Sub
If BS.Count = 0 Then
MsgBox("Records are Empty")
End If
BS.MovePrevious()
flag = 1
End Sub
If BS.Count = 0 Then
MsgBox("Records are Empty")
End If
BS.MoveNext()
flag = 1
End Sub
If BS.Count = 0 Then
MsgBox("Records are Empty")
End If
BS.MoveLast()
flag = 1
End Sub
If BS.Count = 0 Then
MsgBox("Records are Empty")
End If
60
BS.MoveFirst()
flag = 1
End Sub
cnnSQL.Close()
Me.Hide()
Me.Close()
End Sub
'MsgBox(cmdDelete.CommandText)
cmdDelete.CommandType = CommandType.Text
cmdDelete.Connection = cnnSQL
cmdDelete.ExecuteNonQuery()
MsgBox("Record deleted.")
Call clear()
cnnSQL.Open()
Call clear()
flag = 1
btnSave.Text = "Update"
da.Fill(ds, "employee_details")
61
BS.DataSource = ds.Tables("employee_details")
cmdDelete.Dispose()
Else
End If
cmdSave.Dispose()
End Sub
Try
cnnSQL = New SqlConnection("Data
Source=.\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\Data\Cosmetic.mdf;Integrated Security=True;User Instance=True")
'provider to be used when working with access database
cnnSQL.Open()
cmd.Connection = cnnSQL
txt_id.Text = dr(0)
txt_name.Text = dr(1)
txt_add.Text = dr(2)
txt_no.Text = dr(3)
dtp_dob.Value = dr(4)
dtp_doj.Value = dr(5)
cmb_designation.Text = dr(6)
txt_salary.Text = dr(7)
' loading data into TextBoxes by column index
dr.Close()
Else
MsgBox("Record not found")
End If
Else
MsgBox("Enter search value.")
62
End If
Catch
End Try
btnSave.Enabled = False
btnNew.Enabled = False
btnDelete.Enabled = False
btnSearch.Enabled = False
btnFirst.Enabled = False
btnPrevious.Enabled = False
btnNext.Enabled = False
btnLast.Enabled = False
End Sub
Private Sub cmb_designation_TextChanged(ByVal sender As Object, ByVal e As
System.EventArgs) Handles cmb_designation.TextChanged
End Sub
cnnSQL.Open()
Call clear()
flag = 1
btnSave.Text = "Update"
da.Fill(ds, "employee_details")
63
btnPrevious.Enabled = True
btnNext.Enabled = True
btnLast.Enabled = True
End Sub
Imports System.Data.Sqlclient.SQLException
'Imports CrystalDecisions.CrystalReports.Engine
Imports System.Data
Public Class employee_salary_slip
cmb_id.Text = ""
cmb_month.Text = ""
txt_designation.Text = ""
txt_name.Text = ""
txt_salary.Text = ""
End Sub
64
Private Sub employee_salary_slip_Load(ByVal sender As System.Object, ByVal
e As System.EventArgs) Handles MyBase.Load
cnnSQL.Open()
Dim dr = cmd.ExecuteReader
While dr.Read()
cmb_id.Items.Add(dr("emp_id"))
End While
dr.Close()
cnnSQL.Close()
btnReport.Enabled = True
dtp1.Value = Date.Now
End Sub
Me.Close()
End Sub
Employee_Salary_Report_Form.Show()
Call clear()
End Sub
65
cnnSQL.Open()
End If
'MsgBox(cmdAdd.CommandText)
cmdAdd.CommandType = CommandType.Text
cmdAdd.Connection = cnnSQL
cmdAdd.ExecuteNonQuery()
'MsgBox(cmdAdd.CommandText)
cmdAdd1.CommandType = CommandType.Text
cmdAdd1.Connection = cnnSQL
cmdAdd1.ExecuteNonQuery()
MsgBox("Record Inserted.")
btnReport.Enabled = True
End Sub
cnnSQL.Open()
66
Dim cmd1 = New SqlCommand("select * from employee_details where emp_id
= '" & cmb_id.Text & "' ", cnnSQL)
While dr1.Read()
txt_name.Text = dr1(1)
txt_designation.Text = dr1(6)
txt_salary.Text = dr1(7)
End While
dr1.Close()
cnnSQL.Close()
End Sub
End Class
Profit/Loss Form :
Imports System.Data.Sqlclient
Imports System.Data
Public Class profit
Dim cnnSQL As New SQLConnection
cnnSQL.Open()
67
Dim crd As Integer = cmd1.ExecuteScalar()
txt_credit.Text = crd
cmd1 = Nothing
End Sub
Me.Close()
End Sub
End Class
SYSTEM
IMPLEMENTATION
PHASE
68
TECHNOLOGY USED
69
VISUAL STUDIO CONTROL PANNEL
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
A textbox control, sometimes called an edit field or edit control, displays information entered at design
time, entered by the user, or assigned to the control in code at run time.
When a text box control receives the focus,an insertion point appears in the box. A VB text box
automatically inherits all the conventions of standard windows text box, including cut copy and from
clipboard area.
To display multiple lines of text in a control, set the Multiline property to true.
If a multiple-line Textbox doesn’t have a horizontal scroll bar, text wraps automatically even when the
Textbox is resized. To customize the scroll bar combination on a textbox, set the Scrollbars property.
Command Buttons
A command button is typically used to start an event that performs an action such as closing a form,
moving to a different record, printing a report, and so on. Use the Command Group control to create a set
of command button that you can manipulate individually or as a group.
You can choose a command button by clicking it, and if the Default property is set to true (.T.), by
pressing the ENTER key when the command button is selected. If the Cancel property of the command
button is set to True (.T.) , you can choose the command button by pressing the ESC Key.
70
A combo box control combines the features of a text box and a list box. This control allows the user to
select an item either by typing text into the combo box, or by selecting it from the list.
Combo boxes present a list of choices to the user. If the number of items exceeds what can be displayed
in the combo box, scroll bars will automatically appears on the control. The user can then scroll up and
down or left to right through the list.
Progress Bars
Progress bars gives the user some visual feedback on what’s happening during a time-consuming
operation. they present the user with a color bar that grows in the control to show how the operation is
proceeding usually from 0 to100
Percent. You can use a progress bar when an operation will take some time to finish. The progress bar
Value property determines how much of the control has been filled. The Min and Max properties set
limits of the control.
INTRODUCTION TO SQL
SQL provides users with one of the simplest and most flexible RDBMS solutions on the market
today. Regular users of Microsoft products will enjoy the familiar Windows 'look and feel' as well as the
tight integration with other Microsoft Office family products. If Microsoft Office is your preferred office
software suite then it makes sense to seriously consider Microsoft Access as your database of choice.
FEATURES OF SQL
71
Creating a tabbed dialog box for multiple pages with the tab control.
Setting reference programmatically.
Improving compilation performance
Implementation Phases
Once the System is tested satisfactorily with test data, the installation has to be done. This
entirely new developed system, will remove the existing manual procedure.
USER TRAINING
CONVERSION PHASE
Conversion is the process of changing the old system to the new one.
There are different methods available for conversion.
In our case even though there is no existing or automated system, we are using the phase
in method.
72
The old system is being used along with the new system till the new system can operate
without causing major problem.
This is being done to protect the major loss on the business.
Maintenance
Security:
SSM of 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.
73
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.
TESTING
74
Testing of System
Testing is asset of activities that can be planned in advanced and conducted systematically.
For this reason a template for software testing a set into which we can specific test case design
techniques and testing methods should be defined for the software process.
A strategy for software testing must accommodate low-level test that are necessary to verify that
a small source code segment can be correctly implemented as well as high –level tests that
validate major system functions against customer requirements.
Types of Testing
1. Alpha Testing: -
Testing after code is mostly complete or contains most of the functional and prior to
end user being involved. More often this testing will be performed in house or by an
outside testing firm in close cooperation with the software engineering department.
2. Beta Testing: -
Testing after the product is code complete. Betas are often widely distributed or even
distributed to the public at large in hopes that they will buy the final product when it is
released.
3. Functional Testing: -
Testing two or more modules together with the intent of finding defects, demonstrating
that defects are not present, verifying that the modules performs its intended functions
as stated in the specification and establishing confidence that a program does what it is
supposed do.
4. Configuration Testing: -
75
Testing to determine how well the product works with a broad of the
hardware/peripheral equipment configurations as on the different operating systems and
software.
5. Pilot Testing: -
Testing that involves the users just before actual release to ensure that users become
familiar with the release contents and ultimately accept it. Typically involves many
users, is conducted over a short period of time and is tightly controlled.
7. Software Testing: -
The process of exercising software is with the intent of ensuring that the software
system meets its requirements and the user expectations and doesn’t file in an
unacceptable manner .
8. Security testing: -
Testing of database and network software in order to keep company data and resources
from mistaken/ accidental users, hackers and other malevolent attackers.
9. Installation Testing: -
Testing with the intent of determining if the product will install on a variety of
platforms and how easily it installs .
76
CONCLUSION
Hence an attempt of automating an office application had added to our learning experience.
77