Introduction
Online Ticket Booking process is one of the major aspects of the modern world.
This is a simple ticket booking system I have developed for .NET programmer who wants to see a booked ticket information.
Using this system, you will learn how to make a simple ticket book application which allows the user to view booked and available seat for the particular user.
Background
The basic idea before developing the script is to allow the user to check information about seat availability.
Using the Code
Create Database (TicketBooking
)
Create table in SQL Server:
CREATE TABLE BookedTickets
(
id int IDENTITY (1,1) NOT NULL,
SeatNo nchar (10) NULL,
Status bit NULL
);
Insert some data into the BookedTicket
table.
INSERT INTO BookedTickets(SeatNo,Status) VALUES ('A13','True');
INSERT INTO BookedTickets(SeatNo,Status) VALUES ('A14','True');
Code
Now select Seat Number from the BookedTickets
table:
string query = @"SELECT SeatNo FROM BookedTickets WHERE (Status='True')";
SqlDataAdapter adapter = new SqlDataAdapter(query, con);
DataTable dt = new DataTable();
adapter.Fill(dt);
for(int i = 0; i < dt.Rows.Count; i++)
{
getSeat = getSeat + "" + dt.Rows[i][0].ToString().Trim() + " ";
}
Check whether seat is booked / available
and generate seat:
protected string checkSeat(string sitting)
{
try
{
string [] words = getSeat.Split(' ');
foreach (string word in words)
{
try
{
if (sitting.Equals(word))
{
chair = "<img id='" + sitting + "'
alt='Booked' src='images/chair/R_chair.gif'/>";
return chair;
}
else
chair = "<img id='" + sitting + "'
alt='Unbooked' onclick=\"seat('" + sitting +"')\"
src='images/chair/G_chair.gif' style='cursor:pointer;'/>";
}
catch (ArgumentOutOfRangeException) { }
}
}
catch (NullReferenceException)
{
chair = "<img id='" + sitting + "' alt='Unbooked'
onclick=\"seat('" + sitting + "')\"
src='images/chair/G_chair.gif' style='cursor:pointer;'/>";
}
return chair;
}
Andan H M
M Tech (CSE)
Amrita School of Engineering,Bangalore
India