Client Forms

 

AddMember

UpdateMember

SellingItem

SearchItem

Member

ViewBidHistory

ViewSubmittedItems

ShippingSchedule

GetDeliveryDate

BiddingPage

ItemDetails

 

Administrator Forms

 

UserAdmin

ViewUserDetails

ItemAdmin

UpdateItemDetails

 

Database

Diagram

 

 

Screen Captures

 

indexpage

admin

bidding

adminitem

member

 

AddMember.asp

1) Description Of Form:
This form allows the registration of new members. The form will check through the information keyed in by the user. On successful registration, member info will be written into the database, else the form will prompt the user for the correct information.

 

 2) Fields:

 

Field Name

Valid Data Range

Remarks

1.

User ID

Any non-null value

Must be included

2.

Password

Any non-null value (max length is 8)

Must be included

3.

Confirmation of Password

Any non-null value (max length is 8)

Must be included

4.

Name

Any non-null value

Must be included

5.

Nationality

Any choice from the list

 Can be Null

6.

NRIC

Any non-null value

Must be included

7.

Date of Birth

Any date from the list

Can be Null

8.

Address

Any value

Can be Null

9.

Postal Code

Any value

Can be Null

10.

Contact (home)

Any non-null value (max length is 8)

Must be included

11.

Contact (office)

Any value (max length is 8)

Can be Null

12.

Contact (hp)

Any value (max length is 8)

Can be Null

13.

Contact (fax)

Any value (max length is 8)

Can be Null

14.

Email Address

Any non-null value

Must be included

15.

Occupation

Any choice from list

Can be Null

16.

Credit Card Type

Any choice from list

Must be included

17.

Credit Card Number

Any non-null value

Must be included

18.

Credit Card Expiry Date

Any date from list

Must be included

 

3) Processes:   

 

Action

Trigger

Description

1.

Submit info into database

Clicking the 'Submit' button

The member information will be added into the Member Table in the database once the validation is successful.

 

4) Outputs:

    i)  Error Cases:

        When any of the below fields is invalid. The form will display an error message telling the user where the error(s) is/are.

            1.         User ID is not entered
           
2.         Password is not entered
            3.        
Confirmation of password is not done
            4.        
Different inputs for password and password confirmation.
            5.        
User Name is not entered
            6.        
NRIC is not entered
            7.        
Contact Number (home) is not entered
            8.        
Email Address is not entered
            9.        
Credit Card Number is not entered
            10.       
The bank status of the user does not meet the requirement to join as a member

    ii) Success Cases

        A successful registration message will be displayed.

 

5) Notes:

    On successfully registration, the new member will be able to use his user ID and password immediately to log in to the eAuction page.

 


 

 

::return to top:::

UpdateMember.asp

1) Description Of Form:
This form allows the updating of personal particulars of existing members. The form will check through the information keyed in by the user. After validation, the new member info will be updated into the database.

 

 2) Fields:

 

Field Name

Valid Data Range

Remarks

1.

Name

Any non-null value

Must be included

2.

Nationality

Any choice from the list

 Can be Null

3.

NRIC

Any non-null value

Must be included

4.

Date of Birth

Any date from the list

Can be Null

5.

Address

Any value

Can be Null

6.

Postal Code

Any value

Can be Null

7.

Contact (home)

Any non-null value (max length is 8)

Must be included

8.

Contact (office)

Any value (max length is 8)

Can be Null

9.

Contact (hp)

Any value (max length is 8)

Can be Null

10.

Contact (fax)

Any value (max length is 8)

Can be Null

11.

Email Address

Any non-null value

Must be included

12.

Occupation

Any choice from list

Can be Null

13.

Credit Card Type

Any choice from list

Must be included

14.

Credit Card Number

Any non-null value

Must be included

15.

Credit Card Expiry Date

Any date from list

Must be included

 

3) Processes:   

 

Action

Trigger

Description

1.

Submit info into database

Clicking the 'Submit' button

The new member information will be updated into the Member Table in the database once the validation is successful.

 

 4) Outputs:

    i)  Error Cases:

        When any of the below fields is invalid. The form will display an error message telling the user where the error(s) is/are.


            1.        
User Name is not entered
            2.        
NRIC is not entered
            3.        
Contact Number (home) is not entered
            4.        
Email Address is not entered
            5.        
Credit Card Number is not entered
            6.        
The bank status of the user does not meet the requirement to join as a member

    ii) Success Cases

        A message on successful updating will be displayed.

 

5) Notes:

    On successfully updating of personal particulars, the member will be guided back to the main member page of the eAuction website so that he/she can continue in his tour.

 


 

::return to top:::

SellingItem.asp

1) Description Of Form:
This form allows members to submit a new item for bidding. On successful submit, the item will only be available for bidding once the administrator approved on the status of the item through the Admin pages.

 

2) Fields:

 

Field Name

Valid Data Range

Remarks

1.

Name Of Item

Any non-null values

 
2. Description Any values Can be Null
3. Start Bid Value Any numeric values  
4. Category Any values from the list  
5. Color Any color values/description Can be Null
6. Made In Country Any values from the list  
7. Material Any values Can be Null
8. Login ID Valid member's Login ID Will appear only if member not login
9. Password Valid password for the above Login ID Will appear only if member not login

 

3) Processes:   

 

Action

Trigger

Description

1.

Submit item into database

Clicking the 'Submit' button

The item information will be added into the Item Table in the database once the validation is successful.
2. Clear the field values Clicking the 'Reset' button The current field values will be cleared.

   

4) Outputs:

    i)  Error Cases:

        When any of the above fields is invalid. The form will display an error message telling the user where the error(s) is/are.

 

    ii) Success Cases

        A Item added success message will be displayed.

 

5) Notes:

    On successfully added into the database, the item will not be available for bidding until the administrator has approved the status of the    item and set a bidding date/time.

 


 

::return to top:::

SearchItem.asp

1) Description Of Form:
This form allows visitors to search for items in the database. Fields search are Item Name, Description, Category, Color, Material and made in country.

 

2) Fields:

 

Field Name

Valid Data Range

Remarks

1.

Keyword

Any values

Can be Null

 

3) Processes:   

 

Action

Trigger

Description

1.

Search Item from the database

Clicking the 'Search' button

The form will search the database for any item based on fields: Item Name, Description, Category, Color, Material and made in country. 

   

4) Outputs:

    i)  Nothing found

        Nothing will be displayed

 

    ii) Anything found

        A table of all the items found will be displayed

 



::return to top:::

Member.asp

1) Description Of Form:
This form allows members to to login into the Member's Page.

 

2) Fields:

 

Field Name

Valid Data Range

Remarks

1.

Login ID

Valid Member's Login ID

 
2. Password Valid password for the above Login ID  

 

3) Processes:   

 

Action

Trigger

Description

1.

Login Member

Clicking the 'Login' button

The member will be redirected to the Member Main page where he/she can edit his/her information or view his/her bidding status.

   

4) Outputs:

    i)  Error Cases:

        When any of the above fields is invalid. The form will display an error message telling the user where the error(s) is/are.

 

    ii) Success Cases

        The member will be redirected to the Member Main page.
 



::return to top:::

ViewBidHistory.asp

1) Description Of Form:
This form allows members to their bidding history sort in orders of items.

 

2) Fields:

 

Field Name

Valid Data Range

Remarks

1.

Select Item

Any values from the list  

 

3) Processes:   

 

Action

Trigger

Description

1.

Display Item bid History

Clicking the 'Submit' button

The bidding history of the member for the item selected will be displayed.

   

4) Outputs:

    i)  No Bidding History:

        No combo box will be displayed.

 

    ii) Success Cases

        The bidding history of the member for the item selected will be displayed.

 


 

::return to top:::

ViewSubmittedItems.asp

1) Description Of Form:
This form allows members to view all the items they have submitted for bidding.

 

2) Fields:

 

Field Name

Valid Data Range

Remarks

1.

Select Item

Any values from the list  

 

3) Processes:   

 

Action

Trigger

Description

1.

Display Item bid History

Clicking the 'Submit' button

The Item submitted and bidding history will be displayed.

   

4) Outputs:

    i)  No Bidding History:

        No combo box will be displayed.

 

    ii) Success Cases

        The Item submitted and its bidding history of the member for the item selected will be displayed.

 


 

::return to top:::

ShippingSchedule.asp

1) Description Of Form:
This form allows members to view all the items they have submitted for bidding.

 

2) Fields:

 

Field Name

Valid Data Range

Remarks

1.

Select Item

Any values from the list  

 

3) Processes:   

 

Action

Trigger

Description

1.

Display Item bid History

Clicking the 'Submit' button

The Item's Delivery Schedule will be displayed.

   

4) Outputs:

    i)  No Bidding History:

        No combo box will be displayed.

 

    ii) No Delivery Date

        The link 'Set Delivery Schedule' will be displayed. On clicking the link, the GetDeliveryDate.asp form will pop-up to allow the user to set the delivery
        schedule.

 

    iii) Success Cases

        The link with the delivery schedule date/time will be displayed. On clicking the link, the GetDeliveryDate.asp form will pop-up to allow the user to modify   
        the delivery schedule.

 


 

::return to top:::

GetDeliveryDate.asp

1) Description Of Form:
This form allows members to set/modify the delivery schedule of the items they have successfully bidded.

 

2) Fields:

 

Field Name

Valid Data Range

Remarks

1.

Delivery Date Day

Any values from the list Any dates from the combinations of the values of the combo boxes selected from the left with the following checks:
- The date must be a valid date.
- The selected date must not be passed.
- The old delivery schedule must not be passed.

2.

Delivery Date Month

Any values from the list

3.

Delivery Date Year

Any values from the list

4.

Delivery Date Hour

Any values from the list

5.

Delivery Date Minute

Any values from the list

6.

Delivery Date AM/PM

Any values from the list

 

3) Processes:   

 

Action

Trigger

Description

1.

Set/Update Delivery Schedule

Clicking the 'Submit' button

The delivery schedule for the item will be updated into the database.

   

4) Outputs:

    i)  Error Date selected:

        An error message will be displayed.

 

    ii) Delivery Schedule Date/Time modified success

        On success, the GetDeliveryDate.asp form will closed and the delivery schedule page will be refreshed to show the latest delivery schedules.

 


 

::return to top:::

BiddingPage.asp

1) Description Of Form:
This form allows listing items that are available for bidding in brief summary according to the category they belong to.

 

2) Fields:

 

Field Name

Remarks

1.

ID of Item

 
2.

Name Of Item

 
3. Description  
4. Start Bid Value  
5. Time Left Time left to bidding start time

 

3) Processes:   

 

Action

Trigger

Description

1.

Opening of itemDetails.asp in a new window

Click on thumb nail or name of item

Viewing of details of selected item

   

4) Notes:

    No thumb nail picture will be shown if picture of item is not available.

 


 

::return to top:::

ItemDetails.asp

1) Description Of Form:
This form allows viewing of the details of selected item.

 

2) Fields:

 

Field Name

Remarks

1.

ID of Item

 
2.

Name Of Item

 
3. Description  
4. Start Bid Value  
5. Category  
6. Made In  
7. Submitted on  
8. Bidding Day  

 

3) Processes:   

 

Action

Trigger

Description

1.

Opening of full size image in a new window which will resize automatically

Click on picture(if any)

Viewing of full sized image.

   

4) Notes:

    No viewing of full sized image if picture of item is not available.

 


 

::return to top:::

UserAdmin.asp

1) Description Of Form:
This form allows the administrator to admin the members in the database.

 

2) Processes:   

 

Action

Trigger

Description

1.

View user details

Clicking the Login ID of the Member

The ViewUserDetails.asp form will pop-up.

   

3) Outputs:

    i) Success Cases

        The ViewUserDetails.asp will be shown.

 


::return to top:::

ViewUserDetails.asp

1) Description Of Form:
This form allows the administrators to view:

            a) User Details

            b) View Item submitted by user

            c) Reset User Password to '12345'.

 

2) Processes:   

 

Action

Trigger

Description

1.

Reset User Password

Clicking the 'Reset Password' button

The member password will be reset to '12345'.
2. View Item Submitted Clicking the 'View Item Submitted' button The items submitted by the member will be displayed.
3. View User Details Clicking the 'View User Details' button The member details will be displayed.

   


::return to top:::

ItemAdmin.asp

1) Description Of Form:
This form allows administrator to admin the Items in the database.

 

2) Fields:

 

Field Name

Valid Data Range

Remarks

1.

Display

Any value from the list

These combo boxes are sorting criteria for the items to be displayed.
2. Category

Any value from the list

3. Sort By

Any value from the list

 

3) Processes:   

 

Action

Trigger

Description

1.

Display sorted items

Clicking the 'Submit' button

The items which fulfill the above combo boxes will be displayed.
2. View/Update/Delete item details Clicking the item name (1st column) from the item table The updateItemDetails.asp form will pop-up.

   

4) Outputs:

    i)  No items found

        No records will be display in the item table.

 

    ii) Items found

        All items found will be displayed.
 


 

::return to top:::

UpdateItemDetails.asp

1) Description Of Form:
This form allows administrator to view/update/delete items in the database.

 

2) Fields:

 

Field Name

Valid Data Range

Remarks

1.

Name Of Item

Any non-null values

 
2. Description Any values Can be Null
3. Start Bid Value Any numeric values  
4. Category Any values from the list  
5. Color Any color values/description Can be Null
6. Made In Country Any values from the list  
7. Material Any values Can be Null
8. Item Status Any option from the 3 option boxes  
9. Bidding Date/Time Any Valid Date/Time value  

 

3) Processes:   

 

Action

Trigger

Description

1.

Update item details

Clicking the 'Update' button

The item details will be updated into the database
2. Delete item Clicking the 'Delete' button The item will be deleted from the database

   

4) Outputs:

    i)  Update failed

        Error message will be displayed.

 

    ii) Update success

        New item details will be displayed.

   

    iii) Delete failed

        Error message will be shown.
        Note: delete will failed if item has been bided by another member.

 

    iv) Delete success

        Item deleted success message will be displayed. The ItemAdmin.asp form will be refreshed.
 

  Home | About us | Contact us
  Copyright © 2003 Tan Siang Cheng. All rights reserved.
1