Online Computer Sales
Online Computer Sales
Online Computer Sales
A Project Report
Submitted in partial Fulfillment of the Requirement for the Award of the
By
MAHARASHTRA
2018 – 2019
1
CERTIFICATE
This is to certify that the project entitled “ONLINE COMPUTER SALE”, is bonafied work of MRIGANK
MANOHAR GOSWAMI bearing submitted in Partial fulfillment of the requirement for
the award of degree of
BACHELOR OF SCIENCE IN INFORMATION TECNOLOGY FROM UNIVERSITY OF MUMBAI
External Examiner
2
ABSTRACT
This document serves as the proposal for the online computer shop
Project .This project offers you the online computer shop managements
system . It’s a online computer shop. There are different kinds of product
in this shop. Such as…………..
(i) Desktop computer
(ii) Laptop
(iii) Speakers
(iv) Accessories
(v) Different types of networking Product(Wireless, an)etc.
(vi) Computer Networking
(vii) Hardware
(viii) Software
Keywords:-
Easy, secure solution, online accessibility, professional terms, standards,
abbreviations, feasibility, assumptions, requirements, test plan, source
code.
3
ACKNOWLEDGEMENT
I would like to take the opportunity to express my sincere thanks
to my guide SHRUSHA CHAWHAN,
Assistant Professor, Department of Information Technology,
KONARK IDEAL COLLEGE OF SCIENCE AND COMMERCE, Kalyan
(East) for his invaluable support and guidance throughout my
project work. Without his kind guidance & support this was not
possible.
I hereby declare that the project entitled, “ONLINE COMPUTER SALE", done at Kalyan (East) , has not
been in any case duplicate to submit to any other University for the award of any degree. To the best
of my Knowledge other than me, no one has submitted to any other university.
The project is done in Partial fulfillment of the requirements for the award of degree of
BACHELOR OF SCIENCE (INFORMATION TECNOLOGY) to be submitted as final semester project as part of
our curriculum.
5
TABLE OF CONTENTS
Certificate………………………………………………2
Abstract ..................................................................................................... 3
Acknowledgement .................................................................................... 4
Declaration ................................................................................................ 5
1 INTRODUCTION ...................................................................................... 9
1.1 Background
1.2 Objectives
1.3 Purpose, Scope,
1.4 1.3.1Purpose
1.4.2 Scope
1.5 Applicability
1.6 Achievements
1.6 Organisation of Report....................................................................................................... ...................
4. Gant char…………………………………………………20
7. CHAPTER 4………………………………………………….31
4.1 systemdesign
4.2 data design
8.source code:…………………………………………………35
10.website pages………………………………………………….57
12.cart page………………………………………………………….69
13.contact us……………………………………………………….70
14.FAQ……………………………………………………………….74
20.SECURITY ISSUE………………………………………105
21.PROJECT TESTING…………………………………….105
22. BIBLIOGHRAPHY………………………………………107
8
CCHAPTER 1
INTRODUCTION
Online COMPUTER SALE is a form of electronic commerce which allows consumers to
directly buy goods or services from a seller over the Internet using a web browser.
Consumers find a product of interest by visiting the website of the retailer directly or by
searching among alternative vendors using a shopping search engine, which displays the
same product's availability and pricing at different e-retailers. As of 2016, customers can
shop online using a range of different computers and devices, including desktop
computers, laptops, tablet computers and smartphones. n online shop evokes the physical
analogy of buying products or services at a regular "bricks-and-mortar" retailer or shopping
center; the process is called business-to-consumer (B2C) online shopping. When an online
store is set up to enable businesses to buy from another businesses, the process is
called business-to-business (B2B) online shopping
1.1 Background
This project deals with the development of a Software Requirements Specification (SRS)
document that specifies what an ONLINE COMPUTER SALES system should and should not do.
The SRS document is divided into five sections namely
1. System Objectives
This section lists all the goals and objectives of the system categorized based on the
viewpoint of the ONLINE COMPUTER SALE and the customer. These are higher-level
goals which are somewhat broad in nature. They help in a top-down development of the
SRS.
2. System Context
This section clearly depicts the environment and boundaries of the ARS and the entities
with which it interacts. It helps us see how the system fits into the existing scheme of things.
What the system will do by itself and what it expects other entities to do is clearly
delineated.
9
1.2 Objective:
More than most, in the computer industry, it’s critical to stay up with the latest in technology. As far
as budget allows, purchase the latest equipment that is vital in your industry of choice, such as
servers that are large enough to accommodate customers of a significant size. In addition, training
plays a key role in staying on the cutting edge. Computer companies cannot afford to know only the
software from last year. They must stay on top of new developments in software and share that with
their customers.
If you’ve ever had a computer hard drive crash on the eve of a big business meeting, you know how
important timely services are to a computer business. Since computers are even more than
machines for business and now hold most of the personal information and memories of its users,
turning situations around successfully and quickly is vital to success. A goal for a business in the
computer industry is to be on call 24/7 and known for quick turnaround.
Marketing is key to running a thriving computer business. Competition may be tough in some areas
so computer service providers must look for non-traditional ways of advertising their businesses, on
top of the more traditional means. Keeping in mind the audience is also a good strategy. For
example, if a business focuses on web design, volunteering to help maintain a church’s or a
daycare’s website could attract unexpected clients.
One way to keep customers happy is giving them options. Hiring people to take on excess
workloads is one way to make sure you can always meet clients' needs. It is pivotal knowing the
moment to give up short-term income by hiring more help, in order to grow the organization. When
you do decide to bring in more employees full-time, be sure to hire well and train well the first time.
10
1.3 Purpose, Scope, and Applicability:
1.3.1 Purpose:
Admin level:
1. Login (using username, email and password).
2. Entry product.
3. Update and delete product.
4. Check the user registration and user mostly view of the product (by system).
5. No Time limitation for each user
6. Admin user can give privilege to operator to operation insert update and delete but not see
admin work
7.
User level:
1. Registration for every user.
2. Viewing product and details with user requirement.
3. User can comment of this product only a user can comment one time for specific product.
4. User can choose the product with category and subcategory
5. Registered user can see product and apply for the product to buy other non registered user only
see the product details but not apply for new products
1.3.2 Scope:
11
1.3.3 Applicability:
Payroll calculations
Budgeting
Sales analysis
Financial forecasting
Banking
ATM machines which are completely automated are making it even easier for
customers to deal with banks.
12
Education
13
1.5 Organization of Report
This is a project work undertaken in context of partial fulfillment of B.Sc.IT. I have tried
my best to make the complicated process of online computer sale System as simple as
possible using Structured & Modular technique & Menu oriented interface.
I have tried to design the software in such a way that user may not have any difficulty in
using this system & further expansion is possible without Much Efforts. Even though I
cannot claim that this work to be entirely exhaustive, the main purpose of my exercise is
perform each Employee‟s activity in computerized way rather than manually which is time
consuming.
In today‟s world computer system is one of the integral part of our life. Computers have
made the life and lifestyle of corporate world common man ease to a great extend.
The use of software in corporate world has made the functioning of the organization smooth
and efficient. Due to this the industry is able to keep the track of its progress and maintain
the records. These Records Can be easily accessed and thus help the organization to know
its functioning & track the success & failure of the processes. This helps the organization
to grow.
14
CHAPTER 2
SURVEY OF TECHNOLOGIES
The rest of the document deals about all the main features of this software each will its purpose
and its main functions. It also gives details about the interface with other products and related
functionality of each product.
Operational: This layer comprises database, service registry and applications approach. Service
Components: One or more independent components can be integrated to develop a service.
Services: The complexity of the services can be varies. Some of the developed services are required
to be combined to perform the whole process or operations. Business Process: The developed
services should be reusable to cater the business operations. Presentation: This layer is where the
user will invoke all the published services.
The main objective of this project is to design and develop an ONLINE COMPUTER
SHOPPING System.
This system will be implemented in Net Beans IDE 8.2 will act as the database.
The main motivation for the project comes from my interest to learn new technologies,
like Mysql and Oracle.
Creating a web-based online application would give me more experience using these
technologies.
Database design was also one of my major objectives for choosing this project.
15
Language version
Java 8 has possibly the fastest adoption rate of any new version to date. This is likely due
to long-awaited modern language features such as lambda expressions that cut down on
some of the verbosity that Java is often criticized for. The performance increases are a big
deal too.
While new Java apps and primary apps are written in Java 8 now, a good amount of
existing Java apps are still Java 7 or 6.
I won‟t wade into the Java EE vs. Spring competition, because the stats on that are
always in dispute, but they appear to be fairly close in user numbers. About a third of
developers using either one also use the other simultaneously.
NetBeans:
Eclipse and Netbeans is a free and open source. Eclipse is well known for its large
community and wealth of plugins (they're easy to write), which make the platform
endlessly extensible but slow to load and cumbersome at times. Netbeans differentiates
itself by coming with things such as Maven and Git integration out of box. IntelliJ has the
performance and polish of a commercial product. It has both free and paid versions.
16
Feautures of this Project:
Database:
Your database choice is a lot more context-dependent than many of the other tools here.
Depending on the app you‟re building, you might need a light key-value store as well as a
massive columnar database. For most applications, relational databases still get the job
done, and that‟s why you see two relational databases at the top of the Java tooling
world.
Oracle is one of the few commercial products in this article, which means it has a lot of
“enterprise” features. MySQL or even SQLite are strong choices if you‟re looking for
open source.
MySQL:
17
CHAPTER 3
There are many online computer shop managements system but the systems need
internet connection to use remotely of any location. Many of the system can be down
several times for heavy load. But there is no such a system which is only related to
the user’s need. The interfaces of these systems are complicated to the users. Even
the coding of those products is much harder.
02. Admin login form Full Privilege admin can do any action
03. User Registered & User registered and login this system
Login form
04. Product details & User see the product details of update
there Updates
05. Products category User can choose which type of product are need of user
10. User Comments of One user can give one comment for one product they cannot
the product comment twice for 1 product
11. Login Registered user can login this sytem
18
Future Enhancement
19
3. GANTT CHART
A Gantt chart is bar Chart that Represent the tasks and activities of the project schedule.
in a Gantt chart the horizontal bar chart depicts project tasks against a calendar. each bar
represent a named project task.
It offers the advantage of clearly showing overlapping tasks that is the tasks can be
performed at the same time. Given is the Gantt chart that describes the project schedule
and its activities
1 2 3 4 1 2 3 4 1 2 3 4
Planning
Requirement
gathering
Analysis
Design
20
3.3 Software and Hardware Requirements
Hardware Requirements
Software Requirements
21
1. Communication Interfaces
There is an LAN used for communication among the different client systems to be used.
2. Memory Constraints
The system would require disk space of 10 GB and a 256 MB HDD and 64 MB RAM for client
systems.
3. Operation
The users can first make a order in a particular website for a particular date and time. The system
provides the customer with a pin code which gives him access to either make any changes in his
order or cancel order. These must also be back up of data to enable any easy recovery from any
features.
22
3.4 Preliminary Product Description
The rest of the document deals about all the main features of this software each will its
purpose and its main functions. It also gives details about the interface with other products
and related functionality of each product.
1. System Interfaces
a. The client systems should be able to share the data available in the data base through
the network connection.
2. User Interfaces
a. The screen formats and menu structure should be in such a way that even have users
will find it easy to use. The product must be use-friendly and very inter- active. The
functionality provided by the system like displaying error messages should adapt
itself to the different users of the software.
23
3.5 Conceptual Models
This was a description of the proposed system in terms of a set of integrated ideas and
concepts about what it should do, behave, and look like, that will be understandable by the
users in the manner intended.
1.ER Diagram
24
25
DATA FLOW DIAGRAM
A data flow diagram (DFD) is a graphical representation of the "flow" of data through
an information system.
DFDs can also be used for the visualization of data processing (structured design).
It views a system as a function that transform the input into desired output .
SYMBOLS:
26
DATA FLOW DIAGRAM:
LEVEL 0:
User
Cancellation
LEVEL 1(a):
Accept the
User
details
customer
the file Database
27
LEVEL 1(b):
Accept the
User
details
Passenger
the file Database
LEVEL 2:
Read Passenger
User details
Display in
tabular form
28
2. Class diagram:
A class diagram is an illustration of the relationships and source code dependencies among classes in the
Unified Modelling Language (UML). In this context, a class defines the methods and variables in
an object which is a specific entity in a program or the unit of code representing that entity. Class
diagrams are useful in all forms of object-oriented programming (OOP).
29
PACKAGE DIAGRAM:
Package diagram is UML Structure diagrams which shows packages and dependencies between the
packages.
Model diagrams allow to show different views of a system, for example, as multi-layered (aka multi-
tiered) application - multi-layered application model.
The following nodes and edges are typically drawn in a package diagram: package, package able
element, dependency, element import, package import, package and merge.
30
CHAPTER 4
SYSTEM DESIGN
This showed the application of system theory to product development by defining the architecture,
components, modules, interfaces and data for a system to satisfy specified requirements. The goal
of design phase was not just to produce a design for the system; instead it was to find the best
possible design within the limitations imposed by the requirements and the physical as well as the
social development in which the system was to operate Stair, (1996).The system design process
was divided into logical, conceptual and physical design in Logical design; the logical model of
the system was developed indicating all the vital steps the system development went through.
Here, the researcher used case tools like flow charts and data flow diagrams. Conceptual design
was a description of the proposed system in terms of a set of integrated ideas and concepts about
what it should do, behave, and look like, that was understandable by the users in the manner
intended. The Physical design was the physical realization of logical design. Tables, forms and
reports were created and relationships defined among these tables and security constrains set
during the physical design the researcher translated the expected sachems into actual database
structures. In here the researcher achieved his third objective.
31
DATA DESIGN
Schema design:
Gender Varchar(1)
Contact Varchar(14)
Status Varchar(40)
32
Table Name: Product:
Field Type Extra
Id(PK) Int(12) Auto_increment
Name Varchar(12)
Description Varchar(60)
Price Float(10, 6)
Sub-category******
Category******
SubcategoryId(Fk)
References
Subcategory[Id]
Unit*****
Unitid(FK) Int(12)
References Unit[Id]
Vat Float(4,4)
Picture Varchar(40)
Discount float(6,6)
Stock Float(6,6)
33
Table Name: Purchase:
Delivery Varchar(40)
Date DateTime
Purchaseid(FK)(PK) Int(12)
References
Purchase[Id]
Quantity Float(8, 6)
34
SOURCE CODE:
MASTER PAGE:
<!DOCTYPE html>
<html>
<head runat="server">
<title></title>
<link href="../CSS/bootstrap.min.css" rel="stylesheet" />
<script src="../Scripts/jquery.min.js"></script>
<script src="../Scripts/bootstrap.min.js"></script>
<link href="../CSS/StyleSheet.css" rel="stylesheet" />
</head>
<body>
<style type="text/css">
</style>
<div class="row">
<div class="col-lg-12">
<div class="top-heading">
Contact Us on 9874563210
35
Email Id :- m@gmail.com
</div>
</ul>
</li>
<li><a href="../AboutUs.aspx">About Us</a></li>
<li><a href="../FAQ.aspx">F.A.Q.</a></li>
<li><a href="../ContactUs.aspx">Contact Us</a></li>
</ul>
</div>
</nav>
</div>
</div>
<div class="row">
<div class="col-lg-12">
</div>
</div>
<div class="row">
<div class="col-sm-12">
<form id="form1" runat="server">
<div>
<asp:ContentPlaceHolder ID="ContentPlaceHolder1"
runat="server">
</asp:ContentPlaceHolder>
37
</div>
</form>
</div>
</div>
</div>
</body>
</html>
OFFICE PAGE:
<!DOCTYPE html>
<html>
<head runat="server">
<title></title>
<asp:ContentPlaceHolder ID="head" runat="server">
</asp:ContentPlaceHolder>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-lg-12">
<h2 class="company-name">M Computers Sales and Services </h2>
38
</div>
</div>
<div class="row">
<div class="col-sm-2">
<table class="table table-hover">
<tr>
<td><a href="../Office/Mouse.aspx">Mouse</a></td>
</tr>
<tr>
<td><a href="../Office/Keyboard.aspx">Keyboard</a></td>
</tr>
<tr>
<td><a href="../Office/Monitor.aspx">Monitor</a></td>
</tr>
<tr>
<td><a href="../Office/Desktop.aspx">DeskTop</a></td>
</tr>
<tr>
<td><a href="../Office/Laptops.aspx">Laptops</a></td>
</tr>
</table>
</div>
<div class="col-sm-10">
<form id="form1" runat="server">
<div>
<asp:ContentPlaceHolder ID="ContentPlaceHolder1"
runat="server">
</asp:ContentPlaceHolder>
</div>
</form>
</div>
</div>
</div>
</body>
</html>
39
PRODUCT SOURCE CODE:
Desktop:
<table class="table">
<tr>
<td>Name</td>
<td>
<asp:Label ID="txtName" runat="server" Text="Label"></asp:Label>
</td>
<td>
</td>
</tr>
<tr>
<td>Price</td>
<td>
<asp:TextBox ID="txtPrice" runat="server"></asp:TextBox></td>
<td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2"
ControlToValidate="txtPrice" runat="server" ErrorMessage="Price
Required"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>Upload File</td>
<td>
<asp:FileUpload ID="file1" runat="server" />
</td>
<td></td>
40
</tr>
<tr>
<td>Brand</td>
<td>
<asp:DropDownList ID="ddBrand"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Operating System</td>
<td>
<asp:DropDownList ID="ddOS" runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Hardisk</td>
<td>
<asp:DropDownList ID="ddHardDisk"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Processor Brand</td>
<td>
<asp:DropDownList ID="ddProcessorBrand"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Processor Type</td>
<td>
<asp:DropDownList ID="ddProcessor"
runat="server"></asp:DropDownList>
</td>
41
<td></td>
</tr>
<tr>
<td>RAM Type</td>
<td>
<asp:DropDownList ID="ddRamType"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Ram Capacity</td>
<td>
<asp:DropDownList ID="ddRamCapacity" runat="server"
AutoPostBack="True"
>DownList>
</td>
<td></td>
</tr>
<tr>
<td> </td>
<td>
<asp:Button ID="btnSubmit" runat="server" Text="Submit"
CssClass="btn-default" /><br />
<asp:Label ID="lbMessage" runat="server" Text="Label"></asp:Label>
</td>
<td></td>
</tr>
</table>
42
<asp:GridView ID="dg" runat="server" AutoGenerateColumns="false"
CssClass="table table-bordered table-hover">
<Columns>
<asp:BoundField DataField="Id" HeaderText="ID" />
<asp:BoundField DataField="Name" HeaderText="Name"/>
<asp:BoundField DataField="Price" HeaderText="Price"/>
<asp:BoundField DataField="ProcessorName" HeaderText="Processor"/>
<asp:BoundField DataField="BrandName" HeaderText="Brand"/>
<asp:BoundField DataField="OperatingSystemName" HeaderText="OS" />
<asp:BoundField DataField="HardDiskName" HeaderText="HardDisk"/>
<asp:BoundField DataField="RamTypeName" HeaderText="RAM
TYPE"/>
<asp:BoundField DataField="RamCapacityName" HeaderText="RAM
CAPACITY"/>
</Columns>
</asp:GridView>
</asp:Content>
43
KEYBOARD:
<%@ Page Title="" Language="C#" MasterPageFile="~/Masters/Office.master"
AutoEventWireup="true" CodeFile="KeyBoard.aspx.cs"
Inherits="Office_KeyBoard" %>
<h2>Keyboard Entry</h2>
<table class="table">
<tr>
<td>Name</td>
<td>
<asp:TextBox ID="txtName" runat="server" ReadOnly="True"
Width="350px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1"
ControlToValidate="txtName" runat="server" ErrorMessage="Name
Required"></asp:RequiredFieldValidator>
</td>
<td>
</td>
</tr>
<tr>
<td>Price</td>
<td>
<asp:TextBox ID="txtPrice" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2"
ControlToValidate="txtPrice" runat="server" ErrorMessage="Price
Required"></asp:RequiredFieldValidator>
</td>
<td>
</td>
</tr>
<tr>
<td>Upload File</td>
<td>
<asp:FileUpload ID="file1" runat="server" />
44
</td>
<td></td>
</tr>
<tr>
<td>Brand</td>
<td>
<asp:DropDownList ID="ddBrand"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Interface</td>
<td>
<asp:DropDownList ID="ddInterface" runat="server"
AutoPostBack="True"
>List>
</td>
<td></td>
</tr>
<tr>
<td> </td>
<td>
<asp:Button ID="btnSubmit" runat="server" Text="Submit"
CssClass="btn-default" /><br />
<asp:Label ID="lbMessage" runat="server" Text="Label"></asp:Label>
</td>
<td></td>
</tr>
</table>
</Columns>
</asp:GridView>
</asp:Content>
46
LAPTOP:
<%@ Page Title="" Language="C#" MasterPageFile="~/Masters/Office.master"
AutoEventWireup="true" CodeFile="LapTops.aspx.cs"
Inherits="Office_LapTops" %>
<h2>Laptop Entry</h2>
<table class="table">
<tr>
<td>Name</td>
<td>
<asp:TextBox ID="txtName" runat="server"></asp:TextBox></td>
<td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1"
ControlToValidate="txtName" runat="server" ErrorMessage="Name
Required"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>Price</td>
<td>
<asp:TextBox ID="txtPrice" runat="server"></asp:TextBox></td>
<td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2"
ControlToValidate="txtPrice" runat="server" ErrorMessage="Price
Required"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>Upload File</td>
<td>
<asp:FileUpload ID="file1" runat="server" />
</td>
<td></td>
</tr>
47
<tr>
<td>Brand</td>
<td>
<asp:DropDownList ID="ddBrand"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Screen Size</td>
<td>
<asp:DropDownList ID="ddScreenSize"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Operating System</td>
<td>
<asp:DropDownList ID="ddOS" runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Hardisk</td>
<td>
<asp:DropDownList ID="ddHardDisk"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Processor Brand</td>
<td>
<asp:DropDownList ID="ddProcessorBrand"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
48
<td>Processor Type</td>
<td>
<asp:DropDownList ID="ddProcessor"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Touch Screen</td>
<td>
<asp:DropDownList ID="ddTouchScreen"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>RAM Type</td>
<td>
<asp:DropDownList ID="ddRamType"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Ram Capacity</td>
<td>
<asp:DropDownList ID="ddRamCapacity"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td> </td>
<td>
49
<asp:Button ID="btnSubmit" runat="server" Text="Submit"
CssClass="btn-default" /><br />
<asp:Label ID="lbMessage" runat="server" Text="Label"></asp:Label>
</td>
<td></td>
</tr>
</table>
</Columns>
</asp:GridView>
</asp:Content>
50
MONITOR:
<%@ Page Title="" Language="C#" MasterPageFile="~/Masters/Office.master"
AutoEventWireup="true" CodeFile="Monitor.aspx.cs" Inherits="Office_Monitor"
%>
<h2>Monitor Entry</h2>
<table class="table">
<tr>
<td>Name</td>
<td>
<asp:Label ID="txtName" runat="server"></asp:Label>
</td>
<td>
</td>
</tr>
<tr>
<td>Price</td>
<td>
<asp:TextBox ID="txtPrice" runat="server"></asp:TextBox></td>
<td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2"
ControlToValidate="txtPrice" runat="server" ErrorMessage="Price
Required"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>Upload File</td>
<td>
<asp:FileUpload ID="file1" runat="server" />
</td>
<td></td>
</tr>
<tr>
<td>Brand</td>
51
<td>
<asp:DropDownList ID="ddBrand"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Display Size</td>
<td>
<asp:DropDownList ID="ddDisplaySize"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Screen Resolution</td>
<td>
<asp:DropDownList ID="ddScreenResolution"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Connectivity</td>
<td>
<asp:DropDownList ID="ddConnectivity" runat="server"
AutoPostBack="True"
>ownList>
</td>
<td></td>
</tr>
<tr>
<td></td>
<td>
52
<asp:Button ID="btnSubmit" runat="server" Text="Submit"
CssClass="btn-default" /><br />
<asp:Label ID="lbMessage" runat="server" Text="Label"></asp:Label>
</td>
<td></td>
</tr>
</table>
</asp:GridView>
</asp:Content>
53
MOUSE:
<%@ Page Title="" Language="C#" MasterPageFile="~/Masters/Office.master"
AutoEventWireup="true" CodeFile="Mouse.aspx.cs" Inherits="Office_Mouse"
%>
<h2>Mouse Entry</h2>
<table class="table">
<tr>
<td>Name</td>
<td>
<asp:Label ID="txtName" runat="server"></asp:Label>
</td>
<td>
</td>
</tr>
<tr>
<td>Price</td>
<td>
<asp:TextBox ID="txtPrice" runat="server"></asp:TextBox></td>
<td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2"
ControlToValidate="txtPrice" runat="server" ErrorMessage="Price
Required"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>Upload File</td>
<td>
<asp:FileUpload ID="file1" runat="server" />
</td>
<td></td>
</tr>
<tr>
<td>Brand</td>
54
<td>
<asp:DropDownList ID="ddBrand"
runat="server"></asp:DropDownList>
</td>
<td></td>
</tr>
<tr>
<td>Interface</td>
<td>
<asp:DropDownList ID="ddInterface" runat="server"
AutoPostBack="True"
>List>
</td>
<td></td>
</tr>
<tr>
<td> </td>
<td>
<asp:Button ID="btnSubmit" runat="server" Text="Submit"
CssClass="btn-default" /><br />
<asp:Label ID="lbMessage" runat="server" Text="Label"></asp:Label>
</td>
<td></td>
</tr>
</table>
</Columns>
</asp:GridView>
</asp:Content>
56
WEBSITE PAGES
DEFAULT PAGE:
<%@ Page Title="" Language="C#"
MasterPageFile="~/Masters/MasterPage.master" AutoEventWireup="true"
CodeFile="Default.aspx.cs" Inherits="_Default" %>
57
<div class="item ">
<div class="row">
<div class="col-sm-4">
<img src="Images/Slider/Hp%20Keyboard.jpg" />
</div>
<div class="col-sm-8">
<ul>
<li>Model Number KM-206W</li>
<li>2.4 GHz Wireless Technology, Hot Keys, Noiseless Keys,
Reliable Wireless, Smooth, Responsive Cursor Control, Compact and Sleek
Design</li>
<li>Battery Type Alkaline</li>
<li>Weight 560 g</li>
<li>1 Year Limited Brand Warranty</li>
</ul>
</div>
</div>
</div>
58
<div class="item ">
<div class="row">
<div class="col-sm-4">
<img src="Images/Slider/Lenovo%20Mouse.jpg" />
</div>
<div class="col-sm-8">
<ul>
<li>Model Name 1000</li>
<li>System Requirements Windows 7, 8, 10</li>
<li>Sales Package 1 HP Wired Mouse 1000, Product Notice,
Warranty Card, Quick Start Guide</li>
<li>Color Black</li>
</ul>
</div>
</div>
</div>
<br />
<br />
<br />
<div class="row">
<div class="col-sm-3">
<img src="Images/Slider/fRONTEC%20nINJA.jpg" class="img-
thumbnail" />
</div>
<div class="col-sm-3">
<img src="Images/Slider/Monitor.jpg" class="img-thumbnail"/>
</div>
<div class="col-sm-3">
<img src="Images/Slider/Laptop.jpg" class="img-thumbnail" />
</div>
<div class="col-sm-3">
<img src="Images/Slider/Lenovo%20Mouse.jpg" class="img-thumbnail" />
</div>
60
</div>
</asp:Content>
LOGIN PAGE:
<%@ Page Language="C#" AutoEventWireup="true"
CodeFile="Login.aspx.cs" Inherits="Login" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.login-container {
margin-top: 5%;
margin-bottom: 5%;
}
.login-form-1 {
padding: 5%;
box-shadow: 0 5px 8px 0 rgba(0, 0, 0, 0.2), 0 9px
26px 0 rgba(0, 0, 0, 0.19);
}
.login-form-1 h3 {
61
text-align: center;
color: #333;
}
.login-form-2 {
padding: 5%;
background: #0062cc;
box-shadow: 0 5px 8px 0 rgba(0, 0, 0, 0.2), 0 9px
26px 0 rgba(0, 0, 0, 0.19);
}
.login-form-2 h3 {
text-align: center;
color: #fff;
}
.login-container form {
padding: 10%;
}
.btnSubmit {
width: 50%;
border-radius: 1rem;
padding: 1.5%;
62
border: none;
cursor: pointer;
}
.login-form-1 .btnSubmit {
font-weight: 600;
color: #fff;
background-color: #0062cc;
}
.login-form-2 .btnSubmit {
font-weight: 600;
color: #0062cc;
background-color: #fff;
}
.login-form-2 .ForgetPwd {
color: #fff;
font-weight: 600;
text-decoration: none;
}
.login-form-1 .ForgetPwd {
color: #0062cc;
63
font-weight: 600;
text-decoration: none;
}
</style>
</head>
<body>
<div class="container login-container">
<div class="row">
<div class="col-md-6 login-form-1">
<h3>Login </h3>
<form runat="server">
<div class="form-group">
<asp:TextBox ID="txtUser"
runat="server" class="form-control"
placeholder="Your Email *"></asp:TextBox>
64
</div>
<div class="form-group">
<asp:TextBox ID="txtPassword"
TextMode="Password" runat="server" class="form-
control" placeholder="password"></asp:TextBox>
</div>
<div class="form-group">
<asp:Button ID="btnSubmit"
class="btnSubmit" runat="server" Text="Login"
/>
</div>
<div class="form-group">
<%--<a href="#"
class="ForgetPwd">Forget Password?</a>--%>
</div>
</form>
</div>
<%-- <div class="col-md-6 login-form-2">
<h3>Login for Form 2</h3>
<form>
<div class="form-group">
<input type="text" class="form-control"
placeholder="Your Email *" value="" />
65
</div>
<div class="form-group">
<input type="password" class="form-
control" placeholder="Your Password *" value="" />
</div>
<div class="form-group">
<input type="submit" class="btnSubmit"
value="Login" />
</div>
<div class="form-group">
</body>
</html>
66
11.ABOUT US:
</style>
<div class="aboutus">
Welcome to M & M Computer Services, your number one source for
all things Laptops, Desktops and Acceories . We're dedicated to giving
you the very best of Laptops, with a focus on [three characteristics, ie:
dependability, customer service and uniqueness.]
Founded in 1999 by Mayank & Mrigank, M & M has come a long way
from its beginnings in a Dombivali West. When Mayank * Mrigank first
started out, there passion for drove him to provide services for laptops
67
and Desktops including sales and services and gave him the impetus to
turn hard work and inspiration into to a booming online store. We now
serve customers all over Mumbai, and are thrilled to be a part of the eco-
friendly wing of the hardware industry.
Sincerely,<br />
Name Mayank & Mrigank CEO & Founder
</div>
</asp:Content>
68
12.CART PAGE:
</asp:Content>
69
13.CONTACT US PAGE:
<%@ Page Title="" Language="C#"
MasterPageFile="~/Masters/MasterPage.master"
AutoEventWireup="true" CodeFile="ContactUs.aspx.cs"
Inherits="ContactUs" %>
<style type="text/css">
.bloc_left_price {
color: #c01508;
text-align: center;
font-weight: bold;
font-size: 150%;
}
.category_block li:hover {
background-color: #007bff;
}
.category_block li:hover a {
color: #ffffff;
}
.category_block li a {
color: #343a40;
}
70
.add_to_cart_block .price {
color: #c01508;
text-align: center;
font-weight: bold;
font-size: 200%;
margin-bottom: 0;
}
.add_to_cart_block .price_discounted {
color: #343a40;
text-align: center;
text-decoration: line-through;
font-size: 140%;
}
.product_rassurance {
padding: 10px;
margin-top: 15px;
background: #ffffff;
border: 1px solid #6c757d;
color: #6c757d;
}
.product_rassurance .list-inline {
margin-bottom: 0;
text-transform: uppercase;
text-align: center;
}
.reviews_product .fa-star {
color: gold;
71
}
.pagination {
margin-top: 20px;
}
footer {
background: #343a40;
padding: 40px;
}
footer a {
color: #f8f9fa !important
}
</style>
<div class="container">
<div class="row">
<div class="col-sm-8">
<div class="card">
<div class="card-header bg-primary text-white"><i class="fa
fa-envelope"></i> Contact us.
</div>
<div class="card-body">
<div class="form-group">
<label for="name">Name</label>
<input type="text" class="form-control" id="name"
aria-describedby="emailHelp" placeholder="Enter name" required>
</div>
<div class="form-group">
<label for="email">Email address</label>
<input type="email" class="form-control" id="email"
aria-describedby="emailHelp" placeholder="Enter email" required>
<small id="emailHelp" class="form-text text-
72
muted">We'll never share your email with anyone else.</small>
</div>
<div class="form-group">
<label for="message">Message</label>
<textarea class="form-control" id="message" rows="6"
required></textarea>
</div>
<div class="mx-auto">
<button type="submit" class="btn btn-primary text-
right">Submit</button></div>
</div>
</div>
</div>
<div class="col-sm-4">
<div class="card bg-light mb-3">
<div class="card-header bg-success text-white text-
uppercase"><i class="fa fa-home"></i> Address</div>
<div class="card-body">
<p>Unit No 101</p>
<p>Parvati Plaza</p>
<p>Dombiwali West</p>
<p>Email : m@gmail.com</p>
<p>Mobile. 9999999999</p>
</div>
</div>
</div>
</div>
</div>
</asp:Content>
73
14.FAQ PAGE:
<%@ Page Title="" Language="C#"
MasterPageFile="~/Masters/MasterPage.master"
AutoEventWireup="true" CodeFile="FAQ.aspx.cs" Inherits="FAQ"
%>
<ul>
<li>Upgrade to Windows XP, Vista or 7. There is nothing
that can be done to eliminate lockups and freezes from Windows 95, 98
and ME.</li>
<li>If you have a Windows XP system that exhibits the
problems listed above, it is most likely having a hardware problem. Our
technicians use the manufacturers diagnostics tools to accurately identify
failing or unreliable components and can replace them.</li>
<li>Have the motherboard visually inspected for bulging
and leaking capacitors.</li>
<li>Check CPU and power supply fans; stuck and failed
fans cause overheating and errors.</li>
<li>Check and test the SMART status on hard drives to
determine if the drive is developing errors.</li>
</ul>
</div>
</div>
</div>
76
</div>
</asp:Content>
77
15.MY ORDERS PAGE:
78
16.REGISTER PAGE:
<%@ Page Title="" Language="C#"
MasterPageFile="~/Masters/MasterPage.master"
AutoEventWireup="true" CodeFile="Register.aspx.cs"
Inherits="Register" %>
<div class="panel-heading">Registration</div>
<div class="panel-body">
<table>
<tr>
<td class="tblCol-1">Name</td>
<td>
</td>
</tr>
<tr>
<td>City</td>
<td>
<asp:TextBox ID="txtCity" runat="server"
></asp:TextBox>
</td>
</tr>
<tr>
<td>Password</td>
<td>
<asp:TextBox ID="txtPassword" TextMode="Password"
runat="server" ></asp:TextBox>
</td>
80
</tr>
</table>
</div>
</asp:Content>
81
17.MASTER PAGE IMAGE:
LOGIN PAGE:
82
ADMIN PAGE:
83
ADMIN LOGIN PAGE 2
84
18.DATA INTEGRITY AND CONSTRAINTS:
Data integrity
Global Distribution Systems The primary sources of information for travel management reporting are
the Global Distribution systems (GDS). These systems were developed as ordering systems for the
online system and little consideration was given to the need for producing management reports.
Therefore, there are several problems with the GDS as the provider of quality information.
While transferring data between two databases, the developer accidentally tries to insert the
data into the wrong table.
While transferring data between two databases, the network went down.
A user tries to delete a record in a table, but another table is referencing that record as part of
a relationship.
A user tries to update a primary key value when there‟s already a foreign key in a related
table pointing to that value.
A developer forgets that he‟s on a production system and starts entering test data directly into
the database.
A hacker hacks into the network and drops the database (i.e. deletes it and all its data).
85
Types of Data Integrity
In the database world, data integrity is often placed into the following types:
Entity integrity
Referential integrity
Domain integrity
User-defined integrity
Entity Integrity
Entity integrity defines each row to be unique within its table. No two rows can be the same.
To achieve this, a primary key can be defined. The primary key field contains a unique identifier
– no two rows can contain the same unique identifier.
Referential Integrity
Referential integrity is concerned with relationships. When two or more tables have a relationship,
we have to ensure that the foreign key value matches the primary key value at all times. We don‟t
want to have a situation where a foreign key value has no matching primary key value in the primary
table. This would result in an orphaned record.
So referential integrity will prevent users from:
Adding records to a related table if there is no associated record in the primary table.
Changing values in a primary table that result in orphaned records in a related table.
Deleting records from a primary table if there are matching related records.
86
Domain Integrity
Domain integrity concerns the validity of entries for a given column. Selecting the appropriate data
type for a column is the first step in maintaining domain integrity. Other steps could include, setting
up appropriate constraints and rules to define the data format and/or restricting the range of
possible values.
User-Defined Integrity
User-defined integrity allows the user to apply business rules to the database that aren‟t covered
by any of the other three data integrity types
Constraints enforce limits to the data or type of data that can be inserted/updated/deleted from a table.
The whole purpose of constraints is to maintain the data integrity during an update/delete/insert into a
table. In this tutorial we will learn several types of constraints that can be created in RDBMS.
Types of constraints
NOT NULL
UNIQUE
DEFAULT
CHECK
Key Constraints – PRIMARY KEY, FOREIGN KEY
Domain constraints
Mapping constraints
87
4.3 Procedural Design
88
4.3.1 Logic Diagrams:
ACTIVITY DIAGRAM
Activity diagram is another important diagram in UML to describe the dynamic aspects of the
system. Activity diagram is basically a flowchart to represent the flow from one activity to
another activity. The activity can be described as an operation of the system.
The control flow is drawn from one operation to another. This flow can be sequential, branched,
or concurrent. Activity diagrams deal with all type of flow control by using different elements
such as fork, join, etc
89
90
ACTIVITY DIAGRAM FOR SEARCHING PRODUCT:
user administrator
display the
enter the interface
details
if valid
yes
no
display the
details
display error
message
91
ACTIVITY DIAGRAM FOR SELECTING THE PRODUCT:
92
ACTIVITY DIAGRAM FOR PLACING ORDER:
93
ACTIVITY DIAGRAM FOR CANCEL PRODUCT:
94
SEQUENCE DIAGRAM:
1: start interface()
3: send details()
4: retreive details()
5: send details()
6: check validity()
95
Sequence diagram for searching PRODUCTS:
96
Sequence diagram for login system:
1: start interface()
3: send details()
4: retreive details()
5: send details()
6: check validity()
97
Sequence diagram for searching Computer products:
1: start interface()
98
5 Sequence diagram for cancelling order:
6
7
8
10
11
12
99
12.3.1 Data Structures:
Diagram shows object interactions organized around the objects and their links to each other. A
collaboration diagram contains:
Messages shown as text and an arrow that points from the client to the supplier Message
labels in collaboration diagrams:
Messages on a collaboration diagram are represented by a set of symbols that are the same as those
used in a sequence diagram, but with some additional elements to show sequencing and recurrence
as these cannot be inferred from the structure of the diagram. Each message label includes the
message signature and also a sequence number that reflects call nesting, iteration, branching,
concurrency and synchronization within the interaction.
A predecessor is a list of sequence numbers of the messages that must occur before the current
message can be enabled. This permits the detailed specification of branching pathways. The
message with the immediately preceding sequence number is assumed to be the predecessor by
default, so if an interaction has no alternative pathways the predecessor list may be omitted without
any ambiguity. The syntax for a predecessor is as follows:
The 'l' at the end of this expression indicates the end of the list and is only included when an explicit
predecessor is shown.
Guard conditions are written in Object Constraint Language (OCL), and are only shown where the
enabling of a message is subject to the defined condition. A guard condition may be used to
represent the synchronization of different threads of control.
100
A sequence-expression is a list of integers separated by dots ('.') optionally followed by a name (a
single letter), optionally followed by a recurrence term and terminated by a colon. A sequence-
expression has the following syntax:
In this expression integer represents the sequential order of the message. This may be nested within
a loop or a branch construct.
The name of a sequence-expression is used to differentiate two concurrent messages since these
are given the same sequence number.
Recurrence reflects either iterative or conditional execution and its syntax is as follows:
Branching: „[„condition-clause‟],
Iteration: „* “[„iteration-clause „ ]‟
101
19. Algorithms Design:
ordeing ()
1. Ask user to enter number of passenger Name, according the amount of seats number that
enter, store and display in thE SYSTEM()
(e.g. if user enter 2 seats ,ask user enter 2 BUYER name, 2 PRODUCTS location that user
choice(1A,2C))
Void Seat ()
Void records ()
102
12.4 USER INTERFACE DESIGN:
Use case diagrams are usually referred to as behavior diagrams used to describe a set of actions
(use cases) that some system or systems (subject) should or can perform in collaboration with one
or more external users of the system (actors). Each use case should provide some observable and
valuable result to the actors or other stakeholders of the system.UML 2.0 to 2.4 specifications also
described use case diagram as a specialization of a class diagram, and class diagram is a structure
diagram.Use case diagrams are in fact twofold - they are both behavior diagrams, because they
describe behavior of the system, and they are also structure diagrams - as a special case of class
diagrams where classifiers are restricted to be either actors or use cases related to each other
with associations.
103
20. Security Issues:
The protection of computer based resources that include hardware, software, data, procedures
and people against unauthorized use or natural Disaster is known as System Security.
Installing the software necessary for project took some time for me. I couldn‟t find the Visual
Studio .NET 2010 CD and the Windows XP professional CD for a reasonable price online. I
finally found the software that I needed from the CIS department. I also had some problems
configuring the IIS server. A lot of research and hard work has helped me figure out the
problem.
104
21.PROJECT TESTING
Unit Testing:-
Validation Testing:-
In this requirements established as part of software requirements analysis are validated
against the software that has been constructed. Validation testing provides final
Assurance that software meets all functional, behavioral and performance requirements.
Validation can be define in many ways but a simple definition is that validation
succeeds when software Function in a manner that can be reasonably by the customer.
2. Configuration review
3. Alpha and Beta testing (conducted by end user)
System Testing:-
System testing is actually a series different test whose primary purpose is to full
exercise the computer base system .Where the software and other system elements are
tested as whole .To test computer software ,we spiral out along streamlines that
broadens the scope of testing with each turn.
The last higher-order testing step falls outside the boundary of software Engineering and
in to the broader context of computer system engineering. Software, once validated, must
be combining with order system elements (e.g. hardware, people, and databases). System
testing verifies that all the elements Mesh properly and that overall system
function/performance is achieved.
1. Recovery Testing
2. Security Testing
Stress Testing
105
22.BIBLIOGRAPHY
www.google.
Com
www.amaz
on.com
www.flipka
rt.com
www.newe
gg.com
Thanking you,
106