BusBooking/Admin_bus.aspx at master · brabbit61/BusBooking · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Admin_bus.aspx.cs" Inherits="Admin_bus" %>

<asp:Content runat="server" ID="content2" ContentPlaceHolderID="ContentPlaceHolder2" >
    <asp:HyperLink ID="HyperLink1" SkinID="categories" runat="server" NavigateUrl="~/Admin_bus.aspx" >All Buses</asp:HyperLink>   |
    <asp:HyperLink ID="HyperLink2" SkinID="categories" runat="server" NavigateUrl="~/Admin_booking.aspx">All Bookings</asp:HyperLink>
</asp:Content>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:Panel runat="server" CssClass="left" Height="600px">
     <asp:Label ID="Label4" runat="server" Text="Add Details for a new bus:" Font-Bold="true" Font-Size="X-Large" style="z-index: 1; left: 29px; top: 8px; position: absolute; height: 20px;" EnableTheming="false" />
        <br/>
        <asp:Label ID="Label5" runat="server" Text="Bus ID: " Font-Size="Medium" Font-Bold="true" style="z-index: 1; left: 69px; top: 63px; position: absolute"  /><asp:TextBox ID="id" runat="server" style="position: absolute; top:60px; left: 186px; height: 22px; margin-top: 0px;" EnableTheming="false"></asp:TextBox>
        <asp:RequiredFieldValidator ValidationGroup="Insert" ForeColor="Red" ID="RequiredFieldValidator1" runat="server" ControlToValidate="id" ErrorMessage="*Bus ID is required" style="z-index: 1; left: 75px; top: 44px; position: absolute"></asp:RequiredFieldValidator>
        <br/>
        <asp:Label ID="Label6" runat="server" Text="Company:" Font-Size="Medium" Font-Bold="true" style="z-index: 1; left: 72px; top: 111px; position: absolute"  /><asp:TextBox ID="company" runat="server" style="position: absolute; top: 105px; left: 187px; height: 22px;" EnableTheming="false"></asp:TextBox>
        <asp:RequiredFieldValidator ValidationGroup="Insert" ForeColor="Red" ID="RequiredFieldValidator2" runat="server" ControlToValidate="company" ErrorMessage="*Company is required" style="z-index: 1; left: 76px; top: 95px; position: absolute"></asp:RequiredFieldValidator>
        <br/>
        <asp:Label ID="Label7" runat="server" Text="From: " Font-Size="Medium" Font-Bold="true" style="z-index: 1; left: 74px; top: 157px; position: absolute; height: 20px; width: 50px" /><asp:TextBox ID="source" runat="server"  style="position: absolute; top: 151px; left: 186px; height: 22px;" EnableTheming="false"></asp:TextBox>
        <asp:RequiredFieldValidator ValidationGroup="Insert" ForeColor="Red" ID="RequiredFieldValidator3" runat="server" ControlToValidate="source" ErrorMessage="*Source city is required" style="z-index: 1; left: 75px; top: 140px; position: absolute"></asp:RequiredFieldValidator>
        <br/>
        <asp:Label ID="Label1" runat="server" Text="To: " Font-Size="Medium" Font-Bold="true" style="z-index: 1; left: 77px; top: 208px; position: absolute; width: 27px"  /><asp:TextBox ID="destination" runat="server" style="position: absolute; top: 200px; left: 186px; height: 22px;" EnableTheming="false"></asp:TextBox>
        <asp:RequiredFieldValidator ValidationGroup="Insert" ForeColor="Red" ID="RequiredFieldValidator4" runat="server" ControlToValidate="destination" ErrorMessage="*Destination city is required" style="z-index: 1; left: 76px; top: 190px; position: absolute; height: 15px; width: 138px"></asp:RequiredFieldValidator>
        <br/>
        <asp:Label ID="Label2" runat="server" Text="Time: " Font-Size="Medium" Font-Bold="true" style="z-index: 1; left: 79px; top: 256px; position: absolute"  />
        <asp:RequiredFieldValidator ValidationGroup="Insert" ForeColor="Red" ID="RequiredFieldValidator5" runat="server" ControlToValidate="time" ErrorMessage="*Time is required" style="z-index: 1; left: 77px; top: 240px; position: absolute"></asp:RequiredFieldValidator>
        <br/>
        <asp:Label ID="Label3" runat="server" Text="Number of seats: " Font-Size="Medium" Font-Bold="true" style="z-index: 1; left: 82px; top: 316px; position: absolute"  /><asp:TextBox ID="num_seats" runat="server" style="position: absolute; top: 312px; left: 186px; height: 22px;" EnableTheming="false"></asp:TextBox>
        <asp:RequiredFieldValidator ValidationGroup="Insert" ForeColor="Red" ID="RequiredFieldValidator6" runat="server" ControlToValidate="num_seats" ErrorMessage="*Number of seats is required" style="z-index: 1; left: 83px; top: 296px; position: absolute"></asp:RequiredFieldValidator>
        <asp:Label ID="Label9" runat="server" Text="Date: " Font-Size="Medium" Font-Bold="true" style="z-index: 1; left: 85px; top: 368px; position: absolute; height: 20px"  />
        <br/>
        <asp:Calendar ID="Calendar1" runat="server" style="z-index: 1; left: 177px; top: 375px; position: absolute; height: 151px; width: 178px"></asp:Calendar>
        <br/>
        <asp:ImageButton ValidationGroup="Insert" ID="signup" OnClick="signup_Click" runat="server" ImageUrl="~/signup.jpg" style="z-index: 1; top: 522px; position: absolute; height: 23px; width: 115px; right: 266px" EnableTheming="false"/>
        <asp:DropDownList ID="time" runat="server" style="z-index: 1; left: 185px; top: 254px; position: absolute; height: 17px; width: 193px" />
        <asp:ValidationSummary ID="ValidationSummary1" ValidationGroup="Insert" runat="server" style="z-index: 1; left: -9px; top: 409px; position: absolute; height: 28px; width: 400px" />
    </asp:Panel>

         <asp:Panel ID="Panel3" runat="server" CssClass="center">
        <asp:Image ID="Image1" ImageUrl="~/line.jpg" runat="server"  Height="400px" Width="5px" />
    </asp:Panel>
         <asp:Panel ID="Panel1" runat="server" CssClass="center">
        <asp:Image ID="Image2" ImageUrl="~/line.jpg" runat="server"  Height="600px" Width="5px" />
    </asp:Panel>
    <asp:Panel ID="Panel2" runat="server" CssClass="right" Height="600px" >
        <asp:Label ID="Label8" runat="server" Text="Information about all the buses stored in the database:" Font-Size="X-Large" font-bold="true" Font-Underline="true" ></asp:Label>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" AllowPaging="true" PageSize="10" AutoGenerateDeleteButton="true" AutoGenerateEditButton="true"
                    Font-Size ="Large" DataSourceID="SqlDataSource1" EnablePersistedSelection ="true" AllowSorting="true" DataKeyNames="BusID" AlternatingRowStyle-BackColor="LightBlue" BorderStyle="Dashed" style="z-index: 1; left: 15px; top: 70px; position: absolute; height: 325px; width: 781px">
                <columns>
                <asp:BoundField DataField="BusID" HeaderText="Bus ID" SortExpression="BusID"/>
                <asp:BoundField DataField="Company" HeaderText="Company" SortExpression="Company" />
                <asp:BoundField DataField="Source" HeaderText="From" SortExpression ="Source" />
                <asp:BoundField DataField="Destination" HeaderText="To"  SortExpression ="Destination"/>
                <asp:BoundField DataField="Date" HeaderText="Date"  SortExpression ="Date"/>
                <asp:BoundField DataField="Time" HeaderText="Time of Departure" SortExpression="Time"/>
                <asp:BoundField DataField="Seats" HeaderText="Number of Seats" SortExpression ="Seats"/>
                </columns>
         </asp:GridView>


        <br/>
    </asp:Panel>

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ProviderName="System.Data.SqlClient" ConnectionString="<%$ connectionStrings:bus %>"
         SelectCommand ="select * from Buses"
         DeleteCommand ="delete from Buses where BusID = @BusID"
         UpdateCommand ="update Buses set Company = @Company, Source = @Source, Destination=@Destination, Date=@Date,Time=@Time,Seats=@Seats where BusID = @BusID">

        <DeleteParameters>
            <asp:ControlParameter Name ="BusID" ControlID="GridView1" />
        </DeleteParameters>

    </asp:SqlDataSource>
</asp:Content>