Page 290 - IT-802_class_12
P. 290

9.   While browsing commodities on the website, buyers may wish to buy some commodities at a later point of time. At
           this point, he may add certain commodities to the wish list. For achieving this, function insert_wish of class WishList
           may be invoked. Also, the buyer may want to delete certain commodities from the wish list. This may be achieved
           using function delete_wish. At later point in time, buyer may view his wishlist using function display_wishlist.

          package shopping_application;

          public class WishList
          public void insert_wish (Stringwish_tuple[])

               //Add functionally to insert a row of wish named

               //wish tuple

               //SQL command to be used: insert
          public void delete_wish (int wish_id, string wish)

               //Add functionally to delete a wish of buyer with id //buyer id
               //SQL command to be used: delete

          public void display_wish (int buyer_id)

               //Add functionally to display wish list of buyer with id

               //buyer id
               //SQL command to be used: select
        10. When a buyer adds commodities to be purchased in the shopping cart, he has to go through a series of events.



                             Add items in shopping cart




                                              Select Buy option



                                                           Provide your details
                                                          (or login into account)



                                                                      Choose payment option
                                                                    (Make payment if not cash on
                                                                            delivery)

        11.  In case, if the customer is not already logged in, he is asked to login or to enter his details. After that, he may
            choose to pay through any of the available payment modes. All the details of payment are stored in table PAYMENT
            using function insert_payment of class Payment. In case, the customer wants to opt for cash on delivery, attribute
            Payment_date is set to the date on which the product is delivered.

            package shopping_application;

            public class payment

            { public void insert_payment (String payment_tup1eC] )

          288   Touchpad Information Technology-XII
   285   286   287   288   289   290   291   292   293   294   295