this page will be together with other pages on http://music.mcprogramming.net/pages/


so use the same style sheet for the html


for this page i need a flash program that will connect to a sql server or to a web service and a back office that will work together with the back office i have now


so first ill tell you what i want in the back office which needs to be done in asp.net , then ill tell you what i need on this page that needs to be done in flash

Back Office


i already have in my back office a place to upload CDs and tracks so you will need to add a place to make track packages


when adding a package admin will fill out this info

package name


package sort


package image


package active


after that admin will need to apply tracks to the package each track has a field that says how long this track plays so with each track the admin adds it will need to calculate the total length of all tracks and add it to the package table and show it to the admin


there are going to be a lot of tracks so it has to be a easy way for admin to search for one to apply, cant be just a list of all tracks


you will need to make like a filter by album and category and then select the ones to apply


also when applying a track admin will need to set a sort order for the track

1 track can be assigned to multiple packages and 1 package can have multiple tracks, so here is how the tables should look

RadioPackage Table should have the flowing fields

PackageID


PackageName


PackageSort


PackageImage


PackageActive


PackageLength


NowPlayingID


StartedPlaying

RadioPackageToTracks Table should have the flowing fields

ID


PackageID


TrackID


SortOrder


NowPlayingID and StartedPlaying in RadioPackage will be used by the flash program to save which track in the Package is now playing and when this track started

Flash Program


this flash program needs to connect to the sql database and cant pass parameters in the source i don't want the user to see in the source where the tracks are hosted or any connection to it


so you can make the flash connect to the database or to a web service and here is what it has to do


on top where it says "Select your station" the user will have a list of all Packages it will show the Package Image and Package name in the sort order


when a user selects a Package it should start playing the track thats now playing (saved in the RadioPackage table in the NowPlayingID field)


if this is the first time someone plays this package then start with the first track and save the id to NowPlayingID and the time started to StartedPlaying


and it has to play track after track and when finish all tracks start again and every track it starts playing save the id to NowPlayingID and the time started to StartedPlaying


now when a other user selects the same Package start with the track thats now playing and if the track started 2 minutes ago then start the track play back in the middle of the track 2 minutes in the track,


if it started 10 minutes ago and the track is only 50 minutes long then start with the next track and update the id to NowPlayingID and the time started to StartedPlaying

by NOW PLAYING: show the track thats now playing


display the album photo , track name, artist name, album name

by Recently Played: show previous tracks from this package played


display the album photo , artist name, track name

if its the first track in the package then show the last 10 tracks from the package

all album photos should be a link opening a new browser to http://www.zingels.com/pages/Album.aspx?Album=35 where 35 it should be the AlbumID


(you can see now how it will look here http://music.mcprogramming.net/pages/Album.aspx?Album=35 )

and make sure the design looks the same as the pdf and make sure it is the same size as other pages on http://music.mcprogramming.net/pages/

--------------------------------------------------

i can give you all the source to the the back office that i already have now and a copy of the database