CHAPTER ONE

Introduction

1.1 Introduction:

Nowadays, shopping online is occupying an essential part of shopping, big and small companies or stores need to have its commercial website ,any serious business can`t be improved and reaches all over the world unless it has web site, even most families, clubs and pet snakes do, too.

Having a web site gives people around the world opportunity to know your business or provided services. It can spread your business so fast, therefore you can achieve success. It’s easier for everyone to do shopping online and buy what needed without moving from their home. Also another reason let people buy online, is that one line grocery stores have a wider range of products and various kinds of the same products whereas the online ones don`t have.

1.2 The Project Objectives:

The Online Shopping System (OSS) is a web-based application. The purpose of the application is to automate and facilitate the whole process of shopping. This application fixes the limitation and problems of paper based processes. The main goal to increase the quantity of sales by making the new technology of web pages design more attractive and to search a lot of customers and company to their location. By this system we can advertise and send procure to a lot of customer by sending email.

1.3 The scope of the work is:

The scope of this work is to design, develop, and test the application according to the time table using Microsoft Access database and Visual Studio 2008. In addition, we will need to use Some Designer software to design the interface and system logo and photos.

1.4 Project Organization:

The project is made up of four chapters, besides chapter one (The Introduction and the Objective of the project and finally the project scope) the project is consists of the three chapters are as following:-

• Chapter Two: in this chapter we will talk about an introduction to the project of what is E-shopping with its advantage and disadvantages, and a comparison between e-shopping& traditional shopping.
• Chapter Three: in this chapter we will talk about requirement, use case and graphical user interface (GUI) design, and also coding.
• Chapter Four: in this chapter we will talk finally about the conclusion and future work to our project and how to improve.
  

  Chapter Two

  Online Shopping System (OSS)

  2.1 Introduction:

  This chapter presents E-shopping, E-shopping is an easy way to buy your grocery. It can be very effective for the working mothers since they can do all of their shopping easily, they can do it at any place. Online grocery shopping may have unique foods or equipment that your local grocery store doesn’t have. An online shopping aims at making shopping comfortable and enjoyable process.

  2.2 E-shopping

  E-shopping is an online grocery store that delvers your food supplies. It’s also 24 hour open shopping-shopping considers as the innovative and creative way for shopping. Shopping is no longer needs to waste time and efforts.

  E-shopping is a successful business in the present days, every product should have its own website, it is the best way to find what you need, these web contains all kinds of grocery stores, that provide you all your needs in a shorter time, the price maybe higher to some extinct, but it can`t be disadvantage since prices differ from place to place and between groceries in the same town.

  2.2.1 Advantages:

  E-shopping has various advantages, it widens the range of target customers. It helps people to find what they need by just pressing a button, also they won’t need to drive all the way to the grocery store and deal with traffic and other stuff. Online shopping website serves as the engine for spreading the goods and services.

  2.2.2 Disadvantages:

  E-shopping has its disadvantages which may lack of some targeted quality or these products don`t comply with its promotions. The setup time (first time apply E-shopping) could be one of disadvantage of OSS.

  2.3 Compression:

  The differences between E-shopping and traditional shopping are the following:

  traditional shopping	E-shopping
  You need to carry the purchased products	You needn’t carry the purchased products
  you have to go through the traffic and the parking, experiencing a lot of difficulties	You just click on a button then you deliver what you need.
  You have to deal with the casher line and that always takes time.	Saving time and effort and avoid you dealing with cashers.

  Table (2.1) the differences between E-shopping & traditional shopping

  Chapter Three

  Analysis, Design & Implementation of proposed system

  3.1 Introduction:

  This chapter represents an overview of the system requirements needed to achieve the goals of the study, including description of software requirement, system diagram and use case.

  3.2 System Requirements

  The proposed system needs the following Requirements:

  – Interface Requirements

  The system will be professional in its appearance and it has a user-friendly interface for the user to input the relevant data and obtain the corresponding results.

  – Usability Requirements

  a. Ease of use

  The system will be able to be used quickly and easily. It will be forgiving if an error is made and will ask for confirmation before entering into a timely process.

  b. Ease of learning.

  This system will be easy to learn for a novice user.

  c. Accessibility requirements.

  It is not currently planned to add accessibility to the application (e.g. large font for the visually impaired).

  – Performance Requirements

  a. Speed and latency requirements

  The system will produce a viable Order within a reasonable amount of time and provide feedback on the progress.

  b. Safety critical requirements

  There are not felt to be any safety critical requirements for this system.

  c. Reliability and Availability requirements

  This program will be available either through the web or on a machine.

  e. Robustness requirements

  The program will have sufficient error handling abilities that it will not crash any other part of the system.

  f. Scalability or extensibility requirements

  The program will be able to handle a Sales shop with up to 150 user and customers.

  – PC Requirements

  You will need a PC with an Internet connection. A printer is optional.

  – Software Requirements

  Internet Browser such as Internet Explorer 6.0 and higher or another browser of the same generation is required to access the application.

  – Maintainability and Support Requirements

  a. Maintenance of the system

  New product, category and Vouchers must able to be added by the admin. This system must easily maintainable.

  b. Supportability

  There will be online help and/or a printed manual.

  c. Portability requirements

  The product is expected to run under any operating system that run explorer IE or other web browser and its successors or through a web browser.

  – Security Requirements

  a. Access requirements

  Anyone have ability to enter the system (admin or customer) each one have its own password and user name. The customer can retrieve and create a new orders and the admin can enter new product and can see the customer orders. Each one has its own page.

  b. Integrity requirements

  Wherever possible, system will prevent incorrect data from being introduced and shall protect itself from accidental misuse.

  In the event of lost integrity, complete system (and settings), data, and most recent current Orders will be reloaded from backup source. This may be a manual process analogous to opening a previous copy of a data after system has crashed.

  c. Privacy requirements

  The Customer and Order information will be entered into the program and stored. This program will need to be kept on a PC that has adequate security. The program is not providing security.

  -Cultural and Political Requirements

  The system will not account for holidays or multilingual display.

  3.3 Users of the OSS:

  Potential users of this system are administrators and Customers of OSS. The Customer will enter the required information in the Order form. Also, the admin must fill his form with required information. However, the Customer will register themselves, enter constraints into the software, and build Orders. The administrator will have familiarity with the way the Order should be filled. The Customer will be anywhere from a novice with using computer programs to an expert.

  3.4 The proposed system design

  In the proposed system design the customer will select category of product and after that the system will show him all product under this category. Customer will select the product and also select the wanted quantity and add this product to the cart shopping. The system automatically will show all cart products with their price and quantity and the total for each product and also the net total for all orders. The proposed system consists of the

  • Order Page
  • Register Page
  • Product Page
  • Admin pages
  • Category Pages
  • ASP.NET:

  Prior to the advent of ASP.NET, three main technologies and platforms were available to develop Web applications: ASP, Java Server Pages (JSP), and the open source Web platform commonly referred to as LAMP (Linux plus Apache plus MySQL plus either Perl, Python, or PHP as the Programming language). [5]

  Visual Studio:

  Visual Studio is a container environment that integrates the functionality of multiple visual designers. You have a designer for building Windows applications, one for building Web sites, one for building Windows Communication Foundation (WCF) services, and so on. All items required by your work-such as references, connectors to data sources, folders, and files-are grouped at two levels: solutions and projects. A solution container contains multiple projects, whereas a project container typically stores multiple items. Using these containers, you manage for your solution as a whole or for individual projects. Each item in the project displays its own set of properties though a secondary through a secondary window-the properties window.[6]

  User Function

  1. RegisteredUser : (Customer, Administrator)
  2. Loginsystem (Username & Password)
  3. Customer
  • Fill the Form (with the required Customer Information)
  • Display Old Orders& select one of them to display it’s items
  • Start New Orders & select required product and quantity
  • Fill Payment Details and send order

  4. Administrator

  • Display Product Details and add new products.
  • Display Category list and can add/modify theme.
  • Create, Modify & Display main category.
  • Create Modify & Display payment type.
  • Register new admin employee (CreatesuserID’sfortheadmin and Employeesinordertologin).
  • Change current user password after log in.
  • Display customer orders.
  • Create, Modify & Display Country Information.

  SCHEMA

  Products

  Product_ ID (PK)

  Product_ name

  Product_ Description

  CountryID

  CategoryID

  Unit_ price

  Balance _Qty

  Min_ Level

  Max_ Discount

  Brand_ ID

  Customer

  Customer _ID (PK)

  Customer _Name

  Address

  House _tel

  Mobile _tel

  Work_tel

  Email_1

  Email_2

  Customer _pwd

  Orders

  Order_ID (PK)

  Order _Date

  Customer_ID (FK)

  Payment _Type

  Card_Type

  Card_ Number

  Expiry_Date

  OrderStatus

  Order Details

  Order_ID (FK)

  Product_ID (FK)

  Quantity

  Unit_Price

  Row_Discount

  Payment Type

  Payment_ID (PK)

  Payment_name

  Category

  CategoryID (PK)

  CategoryName

  MainCategoryID (FK)

  MainCategory

  MainCategoryID (PK)

  MainCategoryName

  Country

  CountryID (PK)

  Country Name

  Brand_Tbl

  Brand_ID (PK)

  Brand_Desc

  Table (3.1) Data Base Scheme

  3.5: Use Case Diagram:

  1. The login system used by Customer or administrator:
  2. form filling, displaying Customer Order Information:
  3. Form filling by Customer:
  4. Administrator use cases:

  Brand name DB

  Theuserswillusethe (usecases)asfollows:

  #	Actor	Use Case
  1	RegisteredUser (Customer, Administrator)	Loginsystem (Username & Password)
  2	Customer	Fill the Form (with the required Customer Information)
  3	Customer	Display Old Orders& select one of them to display it’s items
  4	Customer	Start New Orders & select required product and quantity
  5	Customer	Fill Payment Details and send order
  6	Administrator	Display Product Details and add new products
  7	Administrator	Display Category list and can add/modify theme
  8	Administrator	Create, Modify & Display main category
  9	Administrator	Create, Modify & Display payment type
  10	Administrator	Register new admin employee (CreatesuserID’sfortheadmin and Employeesinordertologin)
  11	Administrator	Change current user password after log in
  12	Administrator	Display customer orders
  13	Administrator	Create, Modify & Display Country Information

  Table (3.2) Use Case

  3.6 The proposed system Implementation:

  Cart shopping system is an online system that enables any customer to order his precuts from internet without going to any place. The system is very easy to use and for any one can. In the below system user can select his product in easy way. And the administration can manipulate the product and customer order by easy way. Most of the work is doing by mouse. Administration can change the price in any time and this will not effect on the previous order. System has one page for orders and many pages for administration. The system categories all products under main category and each category divide to another category to facilitate the dealing with the system. This system can be used for any shopping for example Food shopping – Car spare parties shopping – … etc.

  4. Cart Shopping

  Figure 3-4 shows the product list of the selected category and customer can select the required quantity and add the product to shopping cart by clicking on the button “add to Cart”

  5. Product Details

  Figure 3-5 will show the product information to the administration and enable user to add, modify, and delete any product from the system and enable user to update product price

  6. Add new product

  Figure 3-6 will used to add new product to the system and upload the product photo.

  7. Payment Types

  Figure 3-7 will used to enter or delete or modify the payment type.

  8. Main Category

  Figure 3-8 will used to create new main category or update old main category name

  9. Category

  Figure 3-9 will used to create new category or update old category name

  10. Country

  Figure 3-10 will used to create new category or update old category name

  11. Brand Name

  Figure 3-11 will used to create new Brand name or update old Brand name.

  Chapter Four

  Conclusion & Function

  4.1: Conclusion:

  Having an online grocery web site would make other life easier, it would reduce the traffic on the local grocery store, and the buyer will feel comfortable buying from his/her own home.

  These days computer is an important device that is a must have in every house. Computers made our life much easier and practical.

  4.2: Future Work:

  In the future I will improve my web site by adding coupons and wish list so; the buyer can have some of things for free.