Web Ware House Specification
Admin Side
Default.apx – for admin login
Home.aspx – for admin home with the options
Category Management
Book/Item management
Specials Management
Change Password
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.
Sneha SnehaPosted Apr 24, 2015, 2:58 AM
ADMIN SIDE
(Admin Login)
Following command will create a new empty table named tblAdmin Login :-
create table tblAdminLogin (AdminLoginUsername varchar(50), AdminPassword nvarchar(max));
Following query will inset the username and password into your table tblAdminLogin :-
Insert into tblAdminLogin (AdminLoginUsername, AdminPassword) values ("Admin","admin12345");
Following query will authenticate the login of an admin :-
Select * from tblAdminLogin where AdminLoginUserName = @Username and AdminPassword=@Password);
here @username and @password are the values of username and password you can mention the textbox names which you used to enter the details.
Following command will change the password of the admin :-
Update tblAdminLogin set AdminPassowrd=@newPassword where AdminLoginUserName="Admin";
By using this query-- create table tablename (column1 datatype (size), column2 datatype(size),...);
you can create new table for all the three
Category Management
Book/Item management and
Specials Management