Help with asp.net cinema application

[spiderd]

Hi
If your its not too much trouble can you help me with my asp.net coding. Basically what Im trying to do is to create a cinema application which allows customers to choose the available list of films.

Also each film list should include film title, description, dates of showing (links) and each link should show the times for the particular date.

Once the showing is selected the users should be able to select where they want to sit from the GUI.

Results should be displayed (dates,times and selected seats) submit button added which says "Your details have been submitted to us".

Ok a bit of a mouth full the way I would execute this is I want all this is in one page and the GUI to show in a pop up window the results should be displayed and a message saying "your details have been sent to us thank you."

What Ive done so far is made the tables called "listing" with columns "ID, Film Title, Description, Showing Dates" and the table called "times" with columns "ID, times".

So far Ive used grid view to allowed the user to select one row from listings table and in turn the times table would pop up and show the available times for that date by using a simple where clause. However in the listings table how do I just make it show the date only its coming up with the date and time, and in the times table how do I make it only show the time its again coming up with the date and time. Also I need to hyperlink the 2nd column in the times table to a pop window where my GUI will be displayed.

And lastly I have no idea on how to create the seating GUI that allows the use to select what seats they want to book and then display all the results (dates,times and selected seats) and allow a submit button to show "You details have been submitted." I just need a simple GUI not an impressive one.

Im working in asp.net C#
Any Help?

[alykins]

This is a really hard post to answer- what part is broken that you need fixed? To give advice as to how to present it woth no knowledge of the code base or database would be similar to me saying I have a project that send messages to users on machines and I have the code to store the machines and their online status and I want to know how best to display the little images of the online machines. ? I even confused myself with that; not do-able.

A short blind answer/shot-in-the-dark would be bind some custom object to the databse and then give it a skin that gets painted to the GUI. But I have no clue if your code is set up to do something like that.

[spiderd]

alykins I understand what you mean to get started on my second grid view displaying the data from the sql table called "times" I'm trying to have the entries in the 2nd column hyper-linked and to a popup window which will contain the GUI.

So basically the user clicks on any of the entries in the second column and a pop up windows showup.

How do i come about doing this ?

[alykins]

I have to go for now- can follow up with you tomorrow- in the mean time. What you want to do is make a templatecontrol creating an anchor wrapper and then what you would need to do is foreach the gridview column[1].Items and apply that control to it. You may even be able to just do gridview1.columns[1].templatecontrol = youtemplatecontrol

I have never toyed with it so I can't "from the hip" answer this; so I'll follow up w/ you tomorrow

Edit: But see if you can get it working in the meantime with that info :P

[spiderd]

I dont get it what do you mean templatecontrol i know there are controllers in asp.net but how actually do what you said sry im rather new to this

[alykins]

I think I gave wrong link- sorry. I am working on a demo for you- but for some reason I do not have the <asp: TemnplateColumn> available to me, so it will ahve to wait till I find out why... but in the mean time this page will walk you through doing it- see if you can use their example.

[alykins]

ugh- have you gotten anywhere with this? I am not familiar with that web UI gridview and it's proving to be a pain in the *; I can keep trying to help, but if you've figured it out already then I won't keep at it.

[spiderd]

OKi Ive got really far now Ive basically made the tables and grid view to display all the results, and Ive made the GUI by using image map making a simple image of cinema seat plan and adding rectangular hotspots then giving the post back value to display the seat number.

I want to add a color to when ever the user moves the mouse over the hotspot like a inactive world map kinda thing. Ive found this jQuery plugin called mapster:

http://www.outsharked.com/imagemapster/

how I have no I idea how to implement it into my coding. How to add the plugin to Visual Studio and how do I use the tags extra.

Also the last final thing I need to do is when the user clicks on the seat hotspot it displays the message in a label I want the message to display in a message box that come up my code currently is:

PHP Code:

protected void ImageMap1_Click(object sender, ImageMapEventArgs e)
    {
        Label1.Text = ("YOU CAN DO IT!!! Well done you have booked") + e.PostBackValue.ToString();
    }