Objective:

This is an individual assignment aimed to give students the experience to use visual programming language, create simple graphical user interfaces with event-driven programs, develop data connectivity and design reports within an applications environment.

Learning Outcomes covered:

1. Understand visual programming environment and controls

2. Apply visual programming concepts to write event-driven programs

3. Write programs with the support of an integrated development environment

4. Build database applications using ADO.Net

5. Design reports using Crystal Report

Task 1:

Choose one from the given list below and create your own VB.Net Application. Gather information from any company based on your chosen application. When you create your application, make sure to change the company name into your own company name as well as the logo. You have to design your forms appropriately and use different controls (like textbox, listbox, combo box, radio buttons, data grid, date format, etc) in your application. Your application should include the ALL requirements stated below. Any additional features of the application will be awarded with marks appropriately.

Choose any one from the following list of system and ensure to employ the given requirements:

- HR Employee?s Salary Calculation: The application should maintain employee details. The application should allow the user to enter increment (for example: 10% of Basic Pay) for a specific employee then it should automatically calculate the total salary of that particular employee based on employee?s salary and some criteria, which you have to prepare. The current/calculated salary should be stored/updated in the database table. The application should provide an interface that will allow user to evaluate more than one employee at a time and will automatically calculate the total salary of all the employees evaluated. Error message should be displayed if the entered increment is more than 100 and the evaluation process should not be processed/displayed.

- Sales/Order System: The application should maintain details of products/items available. The application should allow user to choose any products/items the customer purchases and should request the user to enter the quantity bought for each product/item being purchased. Upon this process, the stock on hand and total of all purchases should be automatically calculated by the application. The application should provide an interface that will allow user to do multiple product purchases for a single customer and should automatically calculate the overall total to be paid based on the purchased products/items. Error message should be displayed if the quantity bought is greater than the stock and the transaction should not be processed/displayed.

- Library management System: The application should maintain details about the different books in the library. The application should allow user to lend books to students. A student can take only 5 books for a period of 1 month. Upon this process of borrowing/returning books, the available number of books that can be borrowed should be updated and amount to be paid as fine should be automatically calculated. The application should provide an interface that will allow user to borrow multiple books for a single student and should automatically calculate the overall fine to be paid on late submission. Error message should be displayed if the number of books that can be lent is greater than the limit and transaction should not be processed/displayed.

- Car Rental System: The application should maintain details about the cars for rent. The application should allow user to choose from the list of cars for rent and should accept number of days to be rented from the user. The application should automatically calculate the amount to be paid for the rented car based on the entered number of days to be rented and should update the status of that specific/chosen car to "rented". The application should provide an interface that will allow user to process multiple car rentals on a single transaction/customer and should automatically calculate the overall total to be paid on the rented cars. Error message should be displayed if the chosen car to rent is already rented and transaction should not be processed/displayed.

- Hotel Room Reservation: The application should maintain details about the different rooms in the hotel. The application should allow the user to choose from the list of rooms and should accept number of days the room will be reserved. The application should automatically calculate the amount to be paid for the reserved room on the entered number of days to be reserved and should update the availability of the specific/chosen room to "reserved". The application should provide an interface that will allow user to process multiple room reservations on a single transaction/customer and should automatically calculate the overall total to be paid on the reserved rooms. Error message should be displayed if the chosen room is already reserved and transaction should not be processed/displayed.

Requirements:

A. Submit a work proposal for this case study by the end of week 9, which must include:

1. Table columns of the chosen system with at least 2 sample data/records.

2. Understanding on the deliverables - which may include the form designs along with codes (whatever have been completed)

3. Time line for completion of each deliverables.

B. You have to prepare a report/documentation that will include the following:

1. A brief introduction of what your application/system is all about and the scope of your application/system.

2. The screen design with their proper source codes.

C. Create and Design a database in MS Access that will include the following:

1. At least one (1) table with minimum six (6) columns

2. Insert at least 15 appropriate records

D. Create and Design a VB application that will include the following:

1. Connect the created database to your VB application. Database connectivity of transaction form should be through codes.

2. Log in form - create at least 2 different users with different level of access/privileges. The login form should validate the given username and password and will display appropriate messages if invalid data is entered. If valid username and password are entered, a splash screen will be displayed and then the main form/menu will be displayed with all the functionalities/operations that can be performed by the user. A user can have only at most three (3) attempts to login. After three invalid attempts, the application/program should be closed automatically. Password should not be readable.

3. Splash screen - will show the name of your system as well as the logo. Create and design your own company name and logo. This will be displayed only if the entered username and password are valid.

4. Main Menu - a form that will contain all the functionalities/operations a valid user can perform based on his/her level of access/privileges. (e.g. maintenance, transaction or report)

5. Maintenance form - a form where user can add, delete and update records stored in the database. Upon opening the form, all fields should not be enabled to do any changes. When updating a record, a form or an input box can be used to make the changes. There should be a function/procedure to be called in this form while updating records are being done.

6. Transaction form - a form where users can use the records in the database to do some transactions. Transaction activities mentioned earlier in each system requirements needs to be implemented in this form such as calculations, error messages, etc. Make use of message boxes for displaying error messages with regard to your chosen application. Ensure to connect and access your database in doing the transaction.

7. Crystal Report - at least 2 different kinds of report that can be generated from your database through your application. One of the reports should be a parameter report.

8. Export any of the reports to MS Word/MS Excel/Text format.

Task 2:

You have to present and demonstrate your work to your teacher. During presentation, you may be asked to debug code, add and delete records, do transaction, etc.