Help with asp.net cinema application

.NET
1

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.:slight_smile:

Im working in asp.net C#
Any Help?

2

How many screens does the cinema have? Even if it has only one screen you’ll want to build in the capability to handle more then one screen. You should also consider when doing the GUI that some people might be using a smart phone when making bookings

3

The cinema just has one screen and about smart phones there no need for this. I’m not going to put on commercially because I still need to improve my ASP.NET skills so this is my first challenge I known what I need to do its just I’m not fully familiar with the general tag and Microsoft Visual Web Studios.

4

What Ive just done so far is created two tables used grid view to display the results I’m trying to hyperlink into a popup window the 2nd column results of the table called “times” but I don’t know how to do that ?

code is bellow:

<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
    CodeFile="films.aspx.cs" Inherits="_Default" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <h2>
        Welcome to FILms Listing!!!!!!
    </h2>
    <p>
        Bellow are the listing for the films currently availble to watch!!!
        &nbsp;<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
            DataKeyNames="ID" DataSourceID="SqlDataSource1"
            EmptyDataText="There are no data records to display.">
            <Columns>
                <asp:CommandField ShowSelectButton="True" />
                <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False"
                    ReadOnly="True" SortExpression="ID" />
                <asp:BoundField DataField="Film Title" HeaderText="Film Title"
                    SortExpression="Film Title" />
                <asp:BoundField DataField="Description" HeaderText="Description"
                    SortExpression="Description" />
                <asp:BoundField DataField="Show Dates" HeaderText="Show Dates"
                    SortExpression="Show Dates" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
            SelectCommand="SELECT * FROM [listings]"></asp:SqlDataSource>
        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False"
            DataKeyNames="ID" DataSourceID="SqlDataSource2"
            EmptyDataText="There are no data records to display.">
            <Columns>
                <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False"
                    ReadOnly="True" SortExpression="ID" />
                <asp:BoundField DataField="Showing Dates" HeaderText="Showing Dates"
                    SortExpression="Showing Dates" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server"
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
            SelectCommand="SELECT * FROM [times] WHERE ([ID] = @ID)">
            <SelectParameters>
                <asp:ControlParameter ControlID="GridView1" Name="ID"
                    PropertyName="SelectedValue" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
    </p>
    <p>
        &nbsp;</p>
    <p>
        You can also find <a href="http://go.microsoft.com/fwlink/?LinkID=152368&amp;clcid=0x409"
            title="MSDN ASP.NET Docs">documentation on ASP.NET at MSDN</a>.
    </p>
</asp:Content>