Online Auto-Service Reservations

From Wiki

Contents 1 Brief description 2 Storing the information in Database 3 Advanced activities 4 Implementation Requirements 5 References

Brief description

There are many auto-services that provide online reservations in Germany. The Online Auto-Service Reservations is a Web application that allows clients to search for a particular Auto-Service that is previously registered and to use its services. The application has two layers:

• the GUI layer (JSP);
• the business layer (JBoss Application).

The client can do a Web search for a service by its name or by its address (or city). As response, the application returns a list with all available services based on the above mentioned search criteria. By clicking an item from the list, the client can view some details about the service. The client has also the possibility to see a calendar with busy/available time slots of the chosen service. Further two actions are available:

• make a reservation for a free interval of time i.e. a time-slot (10:10 - 11:00);
• the client can cancel an already existing reservation.

When accessing the service the client can perform the following actions:

• register for a new account;
• login/logout from his account;
• modify his personal data;
• do/cancel a reservation;
• see a history of his reservations;
• delete his account.

The auto-service owner can effectuate the following operations:

• register for an account;
• login/logout from his account;
• modify the auto-service data;
• approve/abort a reservation;
• see a history of all reservations for a specified time period;
• delete his account.

Storing the information in Database

The following data must be stored for a registered user: name, user id, address, city, country, email, phone. A possible entry is:

name: Adam Smith
user id: 1214
address: Berliner Strasse Nr. 14
city: Cottbus
country: Germany
email: adam@smith.de
phone: 017944452256

In a similar manner, for an auto-service the following data must be stored: auto service id, name, address, city, email, phone. A possible entry is:

auto service id: 5576
name: Auto-Teilung
address: Karl Strasse Nr. 22
city: Cottbus
email: office@teilung.de
phone: 0355435612

For storing the client reservations, here is a possible list of : auto service id, user id, start date and hour, details (plain text). A possible entry is:

auto service id: 5576
user id: 1214
start date and hour: 20.10.2008 12:10
details: car painting

Advanced activities

The following activities must be available:

• The service owner can cancel a reservation with no less than one day before. In this case, the client will be announced via an e-mail about the cancellation. Supplementary, he can receive data about a new reservation (the reservation is rescheduled);
• The service can deny a reservation, and in this situation it must provide a justification;
• The client can cancel the reservation with no less than 5 hours before the scheduled time;
• Additionally, the standard price must be shown for standard auto-problems;
• Google Calendar^[1] can be used for reservations scheduling.

Implementation Requirements

• The application business should run on any compliant EBJ3 application server (JSR220)such as JBoss AS.
• The Web tier should use JSP Documents.
• The database support is either MySQL or JBoss Hibernate.

References

1. ↑ [Google Calendar]