EJB 2.1 Database Mapping - CMS Project Dialog

1) Open the ejb-jar.xml file
    Select the ProjectInvolmenet bean
    Create new CMP field and save
    This will modify the ProjectInvolvement and ProjectInvolvementBean classes

2) Change the IDE to Data perspective and open data models
    Select ProjectInvolvement in the dbo,
    Right click and select 'Add Data Object' and 'Column'
    Insert the Name and data type

3) Open the Map.mapxmi
     Select the ProjectInvolvement from the Top Left Enterprise Beans Section
     Expand the node and select new column added
     select 'Create and map database elements from EJB elements.

    This will create and map Enterprise bean property with the tables
     
    
   

MS Report server configurations:

This is highlevel steps how to confifure MS reportserver:

1) Login to the database:
     This can be done in two ways:
         Windows authantication.
          Database authantication

2) Create or restore the database.

3)  Open the MS Reporting Services Configuration Manager.

     3.1) Hit the 'Web Service URL' and change the SSL certificate to 'WMSVC'
     3.2) Hit the 'Report Manager URL' and try to login to the report services.

4) On the report server console, create new datasource:
   
    4.1) Connect using "Credentials stored securely in the report server:" by giving the user crated in
           MS SQL server.
 
   4.2)  This user needs to be created in MS SQL server.

•  In the MS SQL Management Studio go to Security Logins: and create user eg rwmp_v3.3
• Define the database you want to connect and generate reports
• Assign the admin role to the user- In the Server roles tab
• Map the database you want to connect : In the Server Mapping tab.

   4.3)  Hit the 'Test Connection'



   4.4) Create new folder for the reports

   4.5) Deploy reports.

   4.6) Click the manage option of the deployed report.
          In the Data source tab, select the shared datasource which you have created in step 4



   4.7)  Click the report and 'View Report' button  to see the report is being rendered properly.

  Allways give admin user to start services:
    Tomcat server
    

         

Create java doc

I have created java documentation for the OTA services module. Therefore, anyone wish to create hotel reservation application either mobile or web, can use the documentation and create their own implementation easily.

The documentation is available in OTA mobile module.

Android Notifications

OTA services notifies to OTA mobile client when the hotel customer has made a reservation and visited to the hotel.
When hotel customer arrives to the hotel hotel user has updated the reservation that customer has arrived to the hotel and later when hotel customer departs from hotel again hotel user updates the reservation. At this moment, OTA services notifies to the android mobile (OTA mobile) that you have visited to this hotel and you have experience with it. Therefore, OTA mobile customer can give his feed back about the hotel. By this way, we can grantee that feedbacks given are dubious.

Front end Validation

I have used built in spring form validations to do the validations such as mandatory fields, password standards etc.
 

Ajax implementation for quick search

Ajax is used in several places in OTA site,

1. For the OTA admin, search new hotels added recently. therefore admin can easily go through the data and verify it. Other than this, all the user information are loaded to the OTA site via AJAX calls.
2. In order to quickly search the hotel information, AJAX is used for several search categories.

Google Map API implementation

To search the hotels and add hotels for a particular location, it would be easy for used to do it via Google Map API.

I have used Google Geo coding and reverse Geo coding to implement this functionality.
When user clicks on Map to enter hotel information, it will to the add hotel window which populates the location data implicitly (Province district and regional area).

As well as, when hotel customer wants to search hotels on particular area, by clicking on Google Map will give the all the registered hotels in that area. Incorporating Google Map API helps the user to do the reservations and add their hotel information.