HOW TO MAKE AN WEB BOOKING ONLINE BOOKING ,ONLINE SEAT, BOOK BOOKING, VEHICLE ONLINE BOOK CODING SOURCE,VISUAL STUDIO VEHICLE ONLINE BOOKING CODING

  THIS IS PROJECT FOR THOSE STUDENT WHO HAVE KNOWLEDGE ABOUT PROGRAMMING

IT IS NOT DIFFICULT AND DO NOT NEED ANY EXPERIENCE  BUT IF NEW STUDENT   GET PROBLEM SO START FROM  OUR BASIC COURSE PAGE WHICH IS UPDATED DAILY  ......

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:

Hide   Copy Code

CREATE TABLE  BookedTickets
(
    id int IDENTITY (1,1) NOT NULL,
    SeatNo nchar (10) NULL,
    Status bit NULL
); 

Insert some data into the BookedTicket table.

Hide   Copy Code

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:

Hide   Copy Code

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:

Hide   Shrink   Copy Code

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;
 }