Design and Development of an Online Store using .Net Framework and SQL Server Database

This report discusses the design and development of an online store using .Net framework and SQL server database. It covers product description, design pattern, implementation, testing and debugging. The project includes a web business endeavor website page that might be connected to buy books on the net. The front-end is ASP.NET[C#] and the back-end is SQL. The report also includes data dictionary and output screenshots.

INTERNET SYSTEM
DEVELOPMENT

Table of Contents
1. Introduction.......................................................................................................................................2
2. Product Description...........................................................................................................................2
3. Design and Development...................................................................................................................2
4. Implementation..................................................................................................................................4
4.1 Data dictionary..........................................................................................................................4
4.2 Output Screenshots....................................................................................................................6
5. Testing..............................................................................................................................................15
6. Conclusion........................................................................................................................................16
References................................................................................................................................................16
Appendix 1...............................................................................................................................................17
Appendix 2...............................................................................................................................................19
1

1. Introduction
The main objective of the project is to design and develop an online store using .Net
framework and SQL server database. In this report we will discuss about product description, the
design patter and implementation technologies will be discussed in detail. The testing and
debugging of this project will be provided.
2. Product Description
An online shop is a virtual store on the web where clients can examine the rundown and
pick results of interest. The picked things may be amassed in a purchasing crate (Vezir OĞUZ,
2018). At checkout time, the issues in the acquiring crate might be included as a demand. Round
at that point, more records could be anticipated to finish the substitute. Ordinarily, the buyer
could be requested to fill or pick a charging address, a transportation adapt to, and transport
option, and portion records, for instance, Visa number. An email see is sent to the client while
the demand is about (Alsharief, 2017).
3. Design and Development
Title of the Project: - Online Shopping
Project Description: - The user can purchase any item an on line store is
available for The user 24 hours. Many shopping website
are available in market, it save lots of time which other
people west in shopping at places like mall shopping
street in market and other places. In this technical
everything is getting on line education, on line banking
etc., so why not shopping.
Platform: - Front-end:- ASP.NET[C#]
Back-end:- SQL
Hardware Requirement:
-
Minimum: - 512 MB RAM
80 GB Hard-Disk
2

Pentium-4 or equivalent Processor
Software Requirement: - Visual Studio – 2012
SQL Server – 2012
Figure 1 Architecture of Project development
In this project, the client is provided with a web business endeavor website page that
might be connected to buy books on the net. To execute this as a web utility we connected
ASP.net in light of the fact that the
Advancement (Frederick, 2011). ASP.net has a few purposes of enthusiasm, for instance,
updated execution, adaptability, worked in assurance and ease. MySQL wind up used as back-
quit database since it's miles a champion among the greatest surely understood open supply
databases, and it gives brief insights get to, simple set up request and ease.
A better than average buying crate arrangement must be ran with smooth to catch
shopping lot programming method of reasoning. It should be useful for the buyer to look the
substance in their truck and to can possibly clear or add things to their truck (Kim and Martinez,
2012). The purchasing container utility delineated on this wander offers various features that are
expected to make the customer more noteworthy pleasing.
3

4. Implementation
The main objective of this activity is to collect an online standby. On the moment that the
buyer sorts inside the URL of the store in adapt to field of this framework, a web Server is come
to get the asked for measurements. In the .net Framework, IIS is going roughly as the net Server.
The web server is doing the process of getting the HTTP request and taking the request and to
reestablish the request into a HTTP response. The main component is IIS (Internet Information
System) and it helps to provide accessing authority to the HTTP request. So that the request
message will be sent to Web server. So this approach is essential for adapt to the request and
proceed further responses. The webserver takes the decision for all the HTTP requests given by
client. The decision is based on the development of the requested lookup. Firstly the web server
looks up the list. If the request is present in its history it will send the immediate response.
Otherwise, it will search and provide the information asked by the client.
4.1 Data dictionary
Order table
Column Name Data type Allow nulls Description
Serial no. numeric No Primary key
Amount numeric No Amount of order
Username varchar No Fk(user.username)
Reviews
Column Name Data type Allow nulls Description
Revieweid varchar No Primary key
review varchar No Product review
Username varchar No Fk(user.username)
Productid numeric No Fk(product.productid)
Product_category
Column Name Data type Allow nulls Description
4

Productid numeric No Primary key
Productname varchar No Product name
Productdescription varchar No Product description
Productshortdescription varchar No Product short
description
Price numeric No Price
Category varchar No Category
Productiamage varchar No Product image
Productiamagethumb varchar No Product image thumb
Product_category
Column Name Data type Allow nulls Description
Categoryid numeric No Primary key
Category varchar No Product category
Shopping_cart
Column Name Data type Allow nulls Description
Shopingid numeric No Primary key
Productno numeric No Product no
Userid numeric No Fk(user.username)
Salesstatus varchar No Sales status
Qty numeric No Quantity
User_table
Column Name Data type Allow nulls Description
Id numeric No Primary key
Username varchar No Username
Password varchar No Password
Emailid varchar No Email id
5

Address varchar No Address
Name varchar No Name
Idnumber numeric No Id number
usertype varchar No Admin/normal user
4.2 Output Screenshots
Home Page
Registration Page
6

New user registration is completed.
Login Page
7

User Panel
In user control panel, the user can edit their personal details.
The user can search for items as given below.
8

If the user wishes to buy the product, they can add them into cart.
After adding into cart, the message will be displayed as given in the screenshot.
9

View Shopping Cart items
Contractors’ details
10

Administrator Panel
They can edit information as given below.
11

The administrator can maintain all the orders and sales as given below.
12

The administrator can add new item in the website.
13

They can edit item details and manage them.
They can view, read and delete the reviews given by users.
14

After the software implementation is finished, the last increment is investigating and
experimenting with. for instance, outside of anyone's ability to see the administrator might need
to set an essential class and subcategory, and after that place a thing in the angle manage module,
and the system will start whether this thing exchange is productive or not. Inside the event that
inside the front-stop site shows regularly, it infers this question has been viably exchanged, and
the buyer can examine this protest inside the concerning class.
5. Testing
Program testing includes logical errors and syntaxes. All the outputs had been tested. The
actual output has been compared with the expected output and the tests had been a success. It
includes checking of all user requirements to be completed. Here the system is tested with the
time to check whether the system is working as per requirements or not. Weather the system
responds negatively on feeding wrong data or not.
When wrong User is entered, no action is taken. The below screenshot shows that the
Testing result.
15

6. Conclusion
To achieve the design and implementation of online store web application development,
the C#.NET is used as front end and SQL server database is used as backend. To represent the
database and tables, Data model and Process model were designed based on the specification
given in the requirements. The website is built up and then testing and debugging has been
carried out by verification and validation process. After each test results the site is modified
according to the client’s feedback and requirement. Thus the online store web application is
developed to make easy shopping for customers without any conflicts.
References
Alsharief, R. (2017). Saudi Consumers Attitudes Towards Online Shopping. International
Journal of Online Marketing, 7(1), pp.16-36.
Frederick, D. (2011). Online Shopping – a New Shopping Trend (an Opinion Study). Indian
Journal of Applied Research, 3(11), pp.60-62.
Kim, S. and Martinez, B. (2012). Fashion consumer groups and online shopping at private sale
sites. International Journal of Consumer Studies, 37(4), pp.367-372.
16

Vezir OĞUZ, G. (2018). The influence of virtual store atmosphere, online shopping satisfaction
and perceived risk in online shopping on intention to continue online shopping. Social Sciences
Studies Journal, 4(17), pp.1452-1458.
Appendix 1
How to create the application
After opening the Visual Studio 2012, you can see the below shown window. In this we
need to choose, File-> New -> Website.
Then we have to choose, visual C# -> ASP.NET Empty Website. And then we have to
give the project name as ‘Online Shopping’. Then the ‘OK’ button is clicked.
17

The project Editor Window will be opened. Then in the Solution Explorer, right click,
then choose, Add-> Add New Item is clicked.
Then the below window will be opened. The name of the web form will be given. Then
the ‘Add’ button is clicked.
18

Appendix 2
How to run the Application
After developing coding part, right click on the Solution Explorer -> Online Shopping.
Then we have to choose Build Website. So that all the web pages of the project will be compiled.
19

After compilation of the project, the build message will become successful.
To run the application, we need to choose the run button ‘Google Chrome’ (The available
browser). It will start running the application on Browser.
20

21