Project Detail

Description

Hi,

I need help with GraniteDS and SEAM framework. This problem requires that you understand FLEX, GraniteDS and SEAM. Only bid on this project if you actually understand these and can solve my project.

I have two tables in a mysql database (InnoDB) they are room and room_booking.
I have reverse engineered my mysql database using Seam-Gen and set up correctly a server to work with graniteds.

My server as a zip file is at http://www.orsa-studio.com/outsource.zip, this is a standard seam server set up from seamgen and configured to work with a mysql database called restaurant. Also graniteds is added to it and it builds via the ant build file. The database sql creation file is included in the zip.

My client application is not supplied as it is complex, a screenshot of what I want is included in the zip file as screen1.jpg. The services config for client is as follows (very standard).

<?xml version="1.0" encoding="UTF-8"?>
<services-config>
<!-- The following for the PHP server -->
<services>
<service id="granite-service"
class="flex.messaging.services.RemotingService"
messageTypes="flex.messaging.messages.RemotingMessage">
<!--
! Use "seamFactory" and "my-graniteamf" for "person" destination (see below).
!-->
<destination id="seam">
<channels>
<channel ref="my-graniteamf"/>
</channels>
<properties>
<factory>seamFactory</factory>
</properties>
</destination>
</service>
</services>
<channels>
<channel-definition id="my-graniteamf"
class="mx.messaging.channels.AMFChannel">
<endpoint
uri="http://127.0.0.1:8080/gnserver/graniteamf/amf"
class="flex.messaging.endpoints.AMFEndpoint" />
</channel-definition>
</channels>
<!-- The following for the Java Granite-DS server -->
<factories>
<factory id="seamFactory" class="org.granite.tide.seam.SeamServiceFactory"/>
</factories>
</services-config>

Note also the generate.as3 in the ant file generates the as3 to a fixed directory.

What I need is that a FLEX (or Adobe AIR) client program is developed that can Create, Read, Update and Delete correctly the room's. The screen must look like screen1.jpg, of course the colors and styles are not important, only the logic of the program.
It should use correct use of SEAM conversation to do the update so that it keeps the database records in a extended persistance context, it should not need to do a merge() on the update() as the object should still be attached.

When the user presses Add Bookings button, it should create a random number of associated bookings (table room_booking) with the room and display them in the table below. When the user presses save button, save the room and its bookings. When user clicks on a room, show its bookings.

Explain how it works and provide example client program, use best practice so that I can copy the same style of code for all my future work on this project.

Thanks, Philip