Website Online Shopping Cart

TABLE OF CONTENTS 1. Problem Definition 03 2. Customer Requirement Specification (CRS) 04 3. Scope of the Work (in brief) 05 4. Architecture and Design of the Project 06 5. Data Flow Diagram 07 6. Entity Relationship (ER) Diagram 15 7. Entity and Properties 16 8. Database Design / Structure 21 9. Task Sheet 28 10. Checklist of Validations 29 11. Submission Checklist 30 12. User Guide 31 13. Setup Guide 84 WEBSITE ONLINE SHOPPING CART I. PROBLEM DEFINITION After reading the project specification, the developer states the scope of the project very briefly. This is referred to as the problem definition. Queries related to the system can be one or more of the following: How will a customer search for products? How will multiple buyers purchase the same product? How to validate a purchase request? How can the payment process be made secure? How to implement approval of requests? What kind of reports can be generated for the management? How is the promotion service for buyers? How can the customers contact with the manufacturer? How to offer a suggestion? How to have an account for the customers? II. CUSTOMER REQUIREMENT SPECIFICATION (CRS) Client: Web site User Business/ Project Objective: (can address organization/ business overview, products, concerns, and expectation from the system) Create a Web site named www.anqshop.com using ASP.NET and MS SQL Server 2005. The Web site authenticates the existing user by his user name and password. The Web site has a registration page where a new user can enter his personal details in the given fields. The user details get stored in the database and the database containing details of existing users gets updated. After the user is authenticated, the list of available products along with the manufacturer’s standard is displayed. The user can select any product to see the detail of it. The Web site contains a form that allows the user to purchase the selected product by placing an order. For any queries or suggestions, the user can interact with the Web site coordinator through the feed back. Inputs provided by the Client: Inputs for the Web-based application Outputs from the Web-based application Process involved in the Web-based application Expected delivery dates List of deliverables Data Constraints/ Triggers/ Validation Tables Hardware and OS Requirements: Pentium IV CPU 2.80 GHz 512 MB of RAM or higher Hard disk requirement: Minimum 4 GB Windows XP or higher Software Requirements: IIS 4.0 or higher Internet Explorer 6.0 or higher SQL Server 2005 Visual Studio 2005 ASP.NET 2.0 Microsoft .Net Framework 2.0 or higher Window Installer 3.1 or higher Scope of the Work (in brief): Depending on the decision taken by the company or firm, following are the requirements based on which the Web site needs to be developed: * Customer: Registration of new users and log into the website. Manage account oneself: change password, change personal information. View orders oneself. View products, categories and detail of them. Place an order through the web. Search the products, make payments and choose shipping method. Send feedback to ask or make opinions. Add product to shopping cart. Know statistics of the website. * Administrator: Manage website such as: order, employee, customer, products, categories, Shipping and payment, FAQs,… View, Update, Insert, Delete and Search. III. ARCHITECTURE AND DESIGN OF THE PROJECT The application will be made of a Web-based distributed three-tier architecture to support multiple user transactions at the same time. Web-Based Distributed 3-Tier Architecture of the Project SQL Server 2005 User interface with HTML and ASPX pages C# (Code-behind) files containing business logic IV. DATA FLOW DIAGRAM The flow of data in the application is shown by the various data flow diagrams. The most basic data flow diagram is the Context diagram. It shows the basic flow of data in to and out of the system. Customer Employee Context Diagram – anqshop.com DFD Level 1 – anqshop.com DFD Level 1 – anqshop.com DFD Level 2 – anqshop.com DFD Level 2 – anqshop.com DFD Level 2 – anqshop.com DFD Level 2 – anqshop.com DFD Level 2 – anqshop.com V. ENTITY RELATIONSHIP DIAGRAM (ERD) Entity Relationship Diagram (ERD) ERD – anqshop.com Entities and Properties VI. DATABASE DESIGN/STRUCTURE TABLE DESIGN TABLE PRODUCTS Field Name Data Type Null Key Description ProductID Varchar(20) No PK Store the ID of the product ManufactureID Int No FK Store the ID of the manufacturer ProductName nvarchar(100) No Store the name of the product CategoryID varchar(10) No FK Store the ID of the category UnitPrice money No Store the price of each unit product in the same category Image nvarchar(50) No Store the image of the product Description nvarchar(Max) Yes Store the description of the product Discount narchar(50) Yes Store the discount of the product UnitInStock Int No Store the number of the unit product in stock QuantityPerUnit varchar(50) No Store the quantity of each unit product IsShow Bit No The product is showed or not TimeAdd Datetime Yes Store the date when the product is added. TABLE PAYMENTMETHOD Field Name Data Type Null Key Description PaymentID Int No PK Store the ID of the payment method MethodsName varchar(50) No Store the name of the method TABLE SHIPPING Field Name Data Type Null Key Description ShipingID varchr(20) No PK Store the ID of the shipping ShippingName nvarchar(50) No Store the name of the shipping Price money No Store the price of each type of the shipping TABLE ORDERDETAIL Field Name Data Type Null Key Description OrderID varchar(20) No PK Store the ID of the order ProductID varchar(20) No PK Store the ID of the product Price money No Store the price of each order Quantity int No Store the quantity of each product which the customer buys Discount Int Yes Store the discount of the order. TABLE MANUFACTURERS Field Name Data Type Null Key Description ManufactureID Int No PK Store the ID of the manufacturer ManufactureName nvarchar(100) No Store the name of the manufacturer Address nvarchar(100) No Store the address of the manufacturer Email varchar(50) No Store the email of the manufacturer Phone varchar(50) No Store the phone number of the manufacturer TABLE CATEGORIES Field Name Data Type Null Key Description CategoryID varchar(10) No PK Store the ID of the category CategoryName nvarchar(50) No Store the name of the category Image nvarchar(50) No Store the image of the category Description varchar(MAX) No Store the description of the category IsShow Bit Yes Store the category is showed or not TABLE FEEDBACKS Field Name Data Type Null Key Description FeedbackID Int No PK Store the ID of the feedback NickName nvarchar(50) No Store the nickname of the user who offers a suggestion DatePost datetime No Store the date when the user sends a feedback FeedbackContent nvarchar(MAX) No Store the content of the feedback Email nvarchar(50) No Store the email of the user who sends a feedback Reply Nvarchar(MAX) Yes Store the content of the reply TABLE ORDER Field Name Data Type Null Key Description OrderID varchar(50) No PK Store the ID of the order UserName varchar(50) No FK Store the name of the customer who buys the products PaymentID int No FK Store the ID of the payment method OrderDate datetime No Store the date when the customer orders RequiredDate datetime No Store the date when the customer requires to delivery the products ShippedDate datetime No Store the date when the products were deliveried Status bit No Store the status of the order ShipName nvarchar(50) No Store the name of the person who deliveries products. ShipAddress varchar(50) No Store the address to be deliveried ShippingID Int No FK Store the ID of the shipping CreditCardNo varchar(50) Yes Store the number of the credit card if the customer wants to delivery by Credit card TABLE EMPLOYEES Field Name Data Type Null Key Description UserName varchar(50) No PK Store the nick name of the employee Password varchar(50) No Store the password of the employee FullName nvarchar(100) No Store the full name of the employee Address nvarchar(100 No Store the address of the employee Email varchar(50) No Store the email of the employee Phone varchar(50) No Store the phone number of the employee Birthday datetime No Store the birthday of the employee HireDate datetime No Store the date when the employee was hired IsAdmin bit No The employee is an admin or not TABLE CUSTOMERS Field Name Data Type Null Key Description UserName varchar(50) No PK Store the nickname of the customer Password varchar(50) No Store the password of the customer FullName nvarchar(100) No Store the full name of the customer Address nvarchar(100 No Store the address of the customer Email varchar(50) No Store the email of the customer Phone varchar(50) No Store the phone number of the customer Bithday datetime No Store the birthday of the customer VII. TASK SHEET Project Ref. No Project Title Activity Plan Prepared By Data of Preparation of Activity Plan Sr.No Task Actual Start Date Actual Days Team Member Names Status 1 Analyse and create a plan to develop application Online Shopping Cart 07-23-09 3 An, Quang, Ngoc Completed 2 Design database Online Shopping Cart 07-26-09 4 An, Quang, Ngoc Completed 3 Web site design Online Shopping Cart 07-30-09 6 An, Quang, Ngoc Completed 4 Discuss all about what we have done Online Shopping Cart 08-05-09 2 An, Quang, Ngoc Completed 5 Connect to Database, display infomation Online Shopping Cart 08-07-09 7 An, Quang, Ngoc Completed 6 Write code to complete functions Online Shopping Cart 08-14-09 4 An, Quang, Ngoc Completed 7 Test Online Shopping Cart 08-18-09 2 An, Quang, Ngoc Completed 8 Discuss all and edit to complete code,interface.. Online Shopping Cart 08-21-09 1 An, Quang, Ngoc Completed VIII. CHECKLIST OF VALIDATIONS Option Validation Can a new user who gets registered, enter the Web site affter logging in? Yes Do all the links navigate to the correct Web pagers? Yes Does the Web site’s functionality resolve the client problem, and satisfy his needs? Yes Has the hardware and software been correctly chosen? Yes IX. SUBMISSION CHECKLIST Sr. No Particulars Yes No NA Comments 1 Are the users able to enter the Web site after validation is performed on the UserID and Password? Yes 2 Are the users able to enter the Web site after getting registered? Yes 3 Do all the Web page contents are devoid of spelling mistakes? Yes 4 Is the user able to purchase the book which has been selected? Yes 5 Is the Web site user – friendly? Yes Tested on Internet Explorer and Firefox X. USER GUIDE A. Customer Best Seller Main Part Copyright Statistics Search Shopping Cart Categories Banner Sign Up – Sign In Menu This is the “Home” page, the first page when you run this website. In the “Sign Up – Sign In” part, when you click “Sign Up”, it will appear the “Sign Up” page to register user for this website, when you click “Sign In”, it will appear the “Sign In” page to login to this website. In the “Menu” part, include in: Home Page: link to “Home.aspx” page New Products: link to “Product.aspx” page to show the new products Specials: link to “Product.aspx” page to show the special products My Account: link to “MyAccount.aspx” page FAQs: link to “FAQs.aspx” page Contact Us: link to “ContactUs.aspx” page In the “Banner” part, it shows our website’s banner. In the “Categories” part, it displays the categories which this website sells. In the “Shopping Cart” part, it displays shopping cart of the customers. In the “Search” part, it is used to searching the product which the customer wants to find. In the “Best Seller” part, it shows the products which the customers buy the most. In the “Statistics” part, it is used to totaling up the accessed turns. In the “Copyright” part, it shows copyright of the ANQ Shop. In the “Main Part”, it shows the main content of the website. This is “New Product” page. It will appear when you click “New Product” on menu bar. It shows the new products include in the images, prices of the new products and the “Add To Cart” hyperlink. When you click “Add To Cart” hyperlink, that product will be added to your shopping cart. The “Quantity” and “Amount” in the “Shopping Cart” part will be changed following the products you add to cart. Quantity: the number of the products you add to cart. Amount: the total price of that products you added. If there are a lot of products, you can click “>” lead to next page, “>>” lead to last page, “<” lead to the previous page, “<<” lead to the first page. This is the “Specials” page when you click “Specials” on the menu bar. It shows the products which is discounted. You can see the images, prices of the products and you can “add to cart” the product you like. If there are a lot of products, you can click “>” lead to next page, “>>” lead to last page, “<” lead to the previous page, “<<” lead to the first page. This is “My Account” Page, when you click the “My Account” on the menu but you haven’t logged in. This is the “FAQs” page when you click “FAQs” on the menu bar. It shows all the FAQs of the customers who access the website. Below that, that is the part which you send your feedback. Your Name: type your full name. This is the field which is required. If you don’t type your full name in that, it will warn error. Your Email: type your email. This is the field which is required. If you don’t type your email in that, it will warn error. You write your question: type your question in that. This is the field which is required too. If you don’t type your question here, it will warn error. Input Code you see: You type the numbers which you see in the image above. You must type correct, if not or you don’t type that, it will warn error. “Send” button: When you fill fully the informations above and you want to send it, you click the “Send” button. “Cancel” button: When you fill fully or not fully the informations above but you don’t want to send it, you click the “Cancel” button to cancel this process. This is the “Contact Us” page when you click “Contact Us” on the menu bar. This is the “Sign Up” page when you click “Sign Up” on the “Sign Up- Sign In” part. User Name: you type the nickname you want when you log into this website. This is the required field, so you must type your user name. If not, it will warn error. Password: you type the password you want to log into this website. This is the required field, so you must type your password. If not, it will warn error. Confirm Password: you type the password , it must be similar to the “Password” above. If not, it will warn error. This is the required field, so you must type your confirm password. If not, it will warn error. Full Name: you type your full name here. This is the required field, so you must type your full name. If not, it will warn error. Address: you type your address here. This is the required field, so you must type your address. If not, it will warn error. Email: you type your email here. This is the required field, so you must type your email. If not, it will warn error. Phone: you type your phone number here. This is the required field, so you must type your phone number. If not, it will warn error. Birthday: you type your birthday here. This is not the required field, so you don’t need type your birthday. But if you type your birthday, you must type the format date correctly following that “MM/dd/yyyy”. It means you type the month first, then the day and the last, it is year. You type incorrectly the birthday, it will warn error. The checkbox “You agree to ANQ Terms”: you check it, if not it will warn error. After you fill fully all of the informations above, you click “Sign Up” button if you want to sign up. Otherwise, you click “Cancel” button to cancel this process. This is the “Sign in” page when you click “Sign In” in the “Sign Up – Sign In” part. User Name: you type your user name when you sign up for this website. This is the required field, so you must type your user name. If not, it will warn error. Password: you type your password when you sign up for this website. This is the required field, so you must type your password. If not, it will warn error. The checkbox “Remember me”: you check it if you want this website remembers you for the next access turn. Otherwise, you don’t check it. The hyperlink “I forgot my password”: you click here when you forgot your password and you want to get your old password. Ex: User Name: customer Password: 123456 After you fill fully all informations above, you click “Sign In” button to log into this site. If not, you click “Cancel” to cancel this process. This is the “Forgot password” page when you click “I forgot my password” hyperlink. Type “User Name” and “Email” then click “Get Password” button to get your old password. Your old password will be sent to your email. User Name and Email are the required fields, so you must type them, if not, it will warn error. This is the page after you logged in successfully. In the top, right of the page, it will be changed. It will show your full name and has 2 hyperlink: Change my account: link to the page which allow you to change your account information. Sign out: it makes you sign out this website. After you click it, it comes back the Sign in page This is the “My Shopping Cart” page when you click “My Shopping Cart” hyperlink. If you want to edit quantity of the products in your shopping cart, you alter the quantity textbox and then click “Update” button. If you want to delete some product in your shopping cart, you click “delete” link in the last of the row. If you want to clear all products in your shopping cart, you click “Clear” button When you login, the “Check out” button will appear, if not, it is disabled. This is the “My Shopping Cart” page when you click “My Shopping Cart” hyperlink and you logged in. The “Check Out” button will appear and you click it to place an order. After you click “Check Out” button, it will appear this page, you type require date when you want the products are deliveried in. You choose payment method. If you choose “Credit Card” , after you click “Next” , it will appear the page for you to type the credit card number, otherwise, it won’t appear. After all, click “Next” if you want to continue, otherwise, click “Cancel” to cancel this process. This is the page for you to type the credit card number if you choose “Credit Cart” payment method. You must enter your credit card number. It is a required field, so if you don’t type, it will warn error. Then click “Next” to continue, otherwise, click “Previous” to come back the previous page. This is the page for you to choose Shipping Method. You choose Shipping Method and the price will appear following the Shipping Method. You type the name of the received person and the address of the received person. They are the required fields so if you don’t type, it will warn error. Then click “Next” to continue, otherwise, click “Previous” to come back the previous page. This is the last page of the “Check Out” process. You just check all the information. Then click “Finish” to complete this process or you click “Cancel” to cancel this process, or you click “Previous” to come back the previous page. This is the page after you click “Finish” button. This is the “Search” part, it has 2 types of searching: Advance Se