sreepathy s prabhu

sreepathy s prabhu

  • NA
  • 217
  • 101k

database help

Apr 24 2015 2:18 AM

Web Ware House Specification

can anybody help for database table
 
  1. Admin Side

Default.apx – for admin login

Home.aspx – for admin home with the options

  1. Category Management

  2. Book/Item management

  3. Specials Management

  4. Change Password

  5. Logout



2 Client Side

Default.aspx Page

This is the login Screen. The registered users can login through this screen. New Users can sign up to the site by filling in the new registration form. There is a provision to retrieve the password, in case the user forgets it.

Home.aspx Page

On successful login, the users land to Home page. The site is built around the use of master pages, all which share a common title, menu, and search features. A book search is the basic navigation technique. A couple of ways of looking for books is provided: viewing a list of books within particular book-type categories and keyword searches for book titles, descriptions, or author names. A visitor arriving at this page is assigned a unique order number to identify this shopper.

Search.aspx Page

When the visitor clicks on a category or submits a search word, transfer is made to the Search.aspx page. The search routines produce a listing all of the books in a chosen category or all the books that match a search criterion. Links are provided for additional details about a book and its purchase on the Details.aspx page.

Details.aspx Page

Full information about a book is displayed on this page. It receives a book identification from the Search.aspx page to call up the information from the database. A button is provided for adding this book to the shopping cart by writing a record to the ShopCart table of the BooksDB database.



ShopCart.aspx Page

The shopping cart page is accessible at any time from the common menu. It lists a customer's shopping cart items stored in the ShopCart table. Opportunity is provided to change item quantities or to delete items. When the visitor is ready to purchase the books, a link is made to the CreditCheck.aspx page for order checkout.





CreditCheck.aspx Page

This page simulates a credit card processing service. It is provided with a merchant ID, a customer ID, the total amount of the order, and a return URL as the destination for returning credit processing information. The page returns an order approval and customer information that is collected.



OrderCapture.aspx Page

This page receives the return information from the credit card processing service and issues an email confirmation to the customer. Transfer is then made to the SalesOrder.aspx page.

SalesOrder.aspx Page

This page displays the final sales order for the customer to confirm the sale and print a copy. The shopping cart is emptied and a new order number is assigned for additional shopping


Specials





Change Password, Logout options also to be included.


Answers (1)