ONLINE THEATER BOOKING TICKET BOOKING

A PROJECT REPORT Submitted by

Rashi Hunka & Kanchan Thakuwani

Under the supervision of

Mrs. Padmavati Mam

In partial fulfillment of fourth semester project for the award of the degree of

MASTER OF COMPUTER APPLICATIONS

Department of Computer Applications

BHILAI INSTITUE OF TECHNOLOGY DURG

April 2011

Department of Computer Application, BIT, and DURG

Page 1

Certificate of Completion

This is to certify that the dissertation entitled ONLINE THEATER TICKET BOOKING SYSTEM carried out by RASHI HUNKA & KANCHAN THAKUWANI, student of FOURTH SEMESTER, MASTER OF COMPUTER APPLICATION [2009-2012], of BHILAI INSTITUTE OF TECHNOLOGY, DURG, is hereby accepted and approved as a credible work submitted in the partial fulfillment for the requirement of degree of MCA from CSVTU, BHILAI, Its a bona fide record of the work done by him under my supervision during his MCA fourth semester. The system has been implemented and running successfully.

M.V.Padmavati Project Guide

HOD Department of Computer Application BHILAI INSTITUTE OF TECHNOLOGY, DURG

Department of Computer Application, BIT, and DURG

Page 2

DISSERTATION CERTIFICATE

This is to certify that the dissertation entitled ONLINE THEATER TICKET BOOKING SYSTEM by RASHI HUNKA & KANCHAN THAKUWANI, student of FOURTH SEMESTER, MASTER OF COMPUTER APPLICATION, session [2009-2012], of BHILAI INSTITUTE OF TECHNOLOGY, DURG, affiliated to CHHATTISGARH SWAMI VIVEKANAND TECHNICAL UNIVERSITY, BHILAI, is hereby accepted and approved as a credible work. It is further certified that this work has not been submitted for similar purpose anywhere else. His work has been found satisfactory for the partial fulfillment of the award of the degree of MCA.

Internal Examiner

External Examiner

Department of Computer Application, BIT, and DURG

Page 3

Declaration
We hereby declare that the project work entitled ONLINE THEATER TICKET BOOKING SYSTEM is an authenticated work carried out by me at BIT, DURG under the guidance of Mrs. M.V. Padmavati in the fourth semester for the partial fulfillment of the award of the degree of MASTER OF COMPUTER APPLICATION and this work has not been submitted for similar purpose anywhere else except to Department of Computer Application, BHILAI INSTITUTE OF TECHNOLOGY, DURG, affiliated to CHHATTISGARH SWAMI VIVEKANAND TECHNICAL UNIVERSITY, BHILAI.

Date: Place:

Name and signature of student RASHI HUNKA KANCHAN THAKUWANI

Department of Computer Application, BIT, and DURG

Page 4

Acknowledgement
It is high privilege for me to express my deep sense of gratitude to all those faculty members who helped me in the completion of the project

Rashi Hunka Kanchan Thakuwani

Department of Computer Application, BIT, and DURG

Page 5

Table of Content
1. 1.1 1.1.1 1.1.2 1.2 2. 3.1 3.2 4. 4.1 4.2 4.3 4.4 5. 6. 7. 8. 9. 10. 11. Introduction Abstract of Project Title of the Project Objective Problem Specification/Need of Project Feasibility Study 3. Software Requirement Specifications Introduction Selection of Technology/Specific Requirements Design ER Diagram Data Flow Diagram (0 & 1 Level) Database Input-Output form (Screen Layout) Coding Implementation/Technological Environment Testing & Result Enhancement Limitations Conclusion Bibliography

Department of Computer Application, BIT, and DURG

Page 6

1.

Introduction

1.3

Abstract of Project

As this project is a huge one to maintain. The actual goal is to provide the facilities of complete management and to improve the capability and working progress of user and take out them from hectic paper work. This project not only manages the records and keep details but also generate the reports too.

Department of Computer Application, BIT, and DURG

Page 7

1.3.1

Title of the Project ONLINE THEATER TICKET BOOKING SYSTEM

1.3.2

Objective

As this project is a huge one to maintain. The actual goal is to provide the facilities of complete management and to improve the capability and working progress of user and take out them from hectic paper work. This project not only manages the records and keep details but also generate the reports too.

Department of Computer Application, BIT, and DURG

Page 8

1.4

Problem Specification/Need of Project

1. 2. 3. 4. 5.

Allow customer to book ticket online without wasting the time. Customer can book ticket in advance. User friendly environment. Facility of watching promo. Reduce paper work.

Department of Computer Application, BIT, and DURG

Page 9

2.

Feasibility Study
Three key consideration are involve in the feasibilty analysis: Economic Technical Behavior

Analysis Analysis is the process of that gives the system analyst a complete and through understanding of a system that is necessary prerequisite before proceeding. The first step in analysis is the process of the data gathering. Following source may be used for the collection. Observation Existing Procedure Questionnaires Interviews Data Collection

System Analysis And Design: System analysis and design are the application of the system approach to problem solving,generally using computer.To reconstruct a system the analyst must consider its elements,outputs and inputs,processors,controls,feedback and environment. After identification of the problem and testing its feasibility,we have analyzed the projet closely and gathered the related data from concerned people. We contacted authorized people to collect the student data,subject details of course and teachers assigned.

Department of Computer Application, BIT, and DURG

Page 10

3.
3.1

Software Requirement Specifications

Introduction

The software, Site Explorer is designed for management of web sites from a remote location. Purpose: The main purpose for preparing this document is to give a general insight into the analysis and requirements of the existing system or situation and for determining the operating characteristics of the system. Scope: This Document plays a vital role in the development life cycle (SDLC) and it describes the complete requirement of the system. It is meant for use by the developers and will be the basic during testing phase. Any changes made to the requirements in the future will have to go through formal change approval process.

DEVELOPERS RESPONSIBILITIES OVERVIEW: The developer is responsible for: Developing the system, which meets the SRS and solving all the requirements of the system? Demonstrating the system and installing the system at client's location after the acceptance testing is successful. Submitting the required user manual describing the system interfaces to work on it and also the documents of the system. Conducting any user training that might be needed for using the system.

Maintaining the system for a period of one year after installation

Department of Computer Application, BIT, and DURG

Page 11

3.2 Selection of Technology/Specific Requirements Hardware Requirements: PIV 2.8 GHz Processor and Above RAM 512MB and Above HDD 40 GB Hard Disk Space and Above

Software Requirements: WINDOWS OS (XP / 2000 / 200 Server / 2003 Server) Visual Studio .Net 2005 Enterprise Edition Internet Information Server 5.0 (IIS) Visual Studio .Net Framework (Minimal for Deployment) version 3.5 SQL database server

4.

Design
Page 12

Department of Computer Application, BIT, and DURG

4.5

ER Diagram

Cus-name

date

Thea-name

Movie-name

CUSTOMER

Ticket booki ng date

THEATER

Cus-id

Show-time

category

4.1ER DIAGRAM Department of Computer Application, BIT, and DURG

Page 13

Row_no Cus-id category Cat_name me Select category no_seat Cat_id Cat_name Categorics in theater

Show_id

cus-detail

Cat_detail booking

_id
Mv_name

Theater_detail Avl_seat

Cat_id

Select movie name Show_time Mv_id

Row_no

Mv_detail
Mv_name Start_date Show_promo

Time_detail
Time_code

time

Last_date promo of movie

Promo_detai l
Mv_id

promo

4.6

Data Flow Diagram (0 Level)

Page 14

Department of Computer Application, BIT, and DURG

CUSTOMER

Customer information

Ticket booking

CUSTOMER Ticket booked

4.7

Data Flow Diagram (1 Level)

Page 15

Department of Computer Application, BIT, and DURG

CUSTOMER

1
Customer informati on

cus_detai l

2 mv_detai l
movie informati on

3
Promo informati on

promo_detail

4 thea_deta il
Theater informati on

Cat_detail 5
Cat Informati on

CUSTOMER

4.1

Database
Page 16

Department of Computer Application, BIT, and DURG

TABLE NAME-:Cust_detail

FIELD NAME DATA TYPE

NAME CUSTOMER_ID MODE OF PAYMENT MOVIE ID CATEGORY ROW NO. NO. OF SEATS DATE VARCHAR(50) INTEGER MONEY INTEGER VARCHAR(50) INTEGER INTEGER DATE & TIME

STATUS
PRIMARY KEY NOT NULL FOREIGN KEY FOREIGN KEY FOREIGN KEY NOT NULL NOT NULL

Department of Computer Application, BIT, and DURG

Page 17

TABLE NAME-: THEATER_DETAIL

FIELD NAME DATA TYPE

THEATER ID CATEGORY ROW NO. SEAT AVAILABLE INTEGER VARCHAR(50) INTEGER INTEGER

STATUS
PRIMARY KEY NOT NULL NOT NULL NOT NULL

Department of Computer Application, BIT, and DURG

Page 18

TABLE NAME-: MOVIE_DETAIL

FIELD NAME DATA TYPE

MOVIE ID MOVIE NAME START DATE LAST DATE MOVIE RATE INTEGER VARCHAR(50) DATE &TIME DATE &TIME INTEGER

STATUS
PRIMARY KEY NOT NULL NOT NULL NOT NULL NOT NULL

Department of Computer Application, BIT, and DURG

Page 19

TABLE NAME-: PROMO_DETAIL

FIELD NAME
MOVIE ID MOVIE PROMO

DATA TYPE
INTEGER VARCHAR(50)

STATUS
FOREIGN KEY NOT NULL

Department of Computer Application, BIT, and DURG

Page 20

TABLE NAME-: SHOW_DETAIL

FIELD NAME DATA TYPE

MOVIE ID SHOW TIME INTEGER DATE & TIME

STATUS
PRIMARY KEY NOT NULL

Department of Computer Application, BIT, and DURG

Page 21

TABLE NAME-: CAT_DETAIL

FIELD NAME DATA TYPE

CAT_ ID CAT_NAME INTEGER VARCHAR

STATUS
PRIMARY KEY NOT NULL

4.4

Input-Output form (Screen Layout)

Page 22

Department of Computer Application, BIT, and DURG

1. CUSTOMER DETAIL FORM

2. MOVIE DETAIL FORM

Department of Computer Application, BIT, and DURG

Page 23

3. THEATER DETAIL FORM

Department of Computer Application, BIT, and DURG

Page 24

4. PROMO DETAIL FORM

Department of Computer Application, BIT, and DURG

Page 25

5.

Coding
Page 26

Department of Computer Application, BIT, and DURG

1. CUSTOMER DETAIL FORM

Imports System.Data.SqlClient Partial Class cus_detail Inherits System.Web.UI.Page Public Function chk() As Integer Dim cn As New SqlConnection Dim select1 As String cn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\multiplex.mdf;Integrated Security=True;User Instance=True" select1 = "select max(cus_id) from cus_detail" Dim cmd As New SqlCommand(select1, cn) Dim id As Integer cn.Open() id = cmd.ExecuteScalar cn.Close() Return id End Function Protected Sub Calendar1_SelectionChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles Calendar1.SelectionChanged c_date.Text = Calendar1.SelectedDate.Date End Sub Protected Sub ImageButton1_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImageButton1.Click Calendar1.Visible = True End Sub Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles save.Click Dim cn As New SqlConnection Dim insertstmt As String cn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=D:\asp_pro\App_Data\multiplex.mdf;Integr ated Security=True;Connect Timeout=30;User Instance=True" cn.Open() insertstmt = "insert into cus_detail values('" & c_name.Text & "'," & c_id.Text & ",'" & c_mode.SelectedItem.Text & "','" & c_mn.Text & "','" & c_cat.SelectedItem.Text & "','" & c_rn.SelectedItem.Text & "'," & c_ns.Text & ",'" & Date.Parse(c_date.Text).Date & "','" & c_st.SelectedItem.Text & "')" Dim cmd As New SqlCommand(insertstmt, cn) cmd.ExecuteNonQuery() cn.Close()

End Sub Protected Sub add_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles add.Click Dim id As Integer id = chk()

Department of Computer Application, BIT, and DURG

Page 27

id = id + 1 c_id.Text = id save.Enabled = True End Sub Protected Sub updt_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles updt.Click If Page.IsValid Then Dim cn As New Data.SqlClient.SqlConnection cn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=D:\asp_pro\App_Data\multiplex.mdf;Integr ated Security=True;Connect Timeout=30;User Instance=True" cn.Open() Dim updatestmt As String updatestmt = "update cus_detail set cus_id= " & c_id.Text & ",cus_name='" & c_name.Text & "',date='" & Date.Parse(c_date.Text).Date & "',mode_pay='" & c_mode.Text & "',mv_name='" & c_mn.Text & "',category='" & c_cat.Text & "',row_no=" & c_rn.Text & ",no_seat=" & c_ns.Text & ",show_time=" & c_st.Text & " where cus_id= " & c_id.Text & "" Dim cmd As New Data.SqlClient.SqlCommand(updatestmt, cn) cmd.ExecuteNonQuery() cn.Close() MsgBox("one record updated") End If End Sub Protected Sub show_detail_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles show_detail.Click Dim cn As New Data.SqlClient.SqlConnection cn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=D:\asp_pro\App_Data\multiplex.mdf;Integr ated Security=True;Connect Timeout=30;User Instance=True" cn.Open() Dim selectstmt As String selectstmt = "select * from cus_detail where cus_id=" & c_id.Text Dim cmd As New Data.SqlClient.SqlCommand(selectstmt, cn) Dim reader As Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader If reader.HasRows Then reader.Read() c_id.Text = reader("cus_id") c_name.Text = reader("cus_name") c_date.Text = reader("date") c_st.SelectedItem.Text = reader("show_time") c_mode.SelectedItem.Text = reader("mode_pay") c_mn.SelectedItem.Text = reader("mv_name") c_cat.SelectedItem.Text = reader("category") c_rn.SelectedItem.Text = reader("row_no") c_ns.Text = reader("no_seat") End If reader.Close() cn.Close() End Sub Protected Sub c_date_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles c_date.TextChanged

Department of Computer Application, BIT, and DURG

Page 28

End Sub Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load End Sub Protected Sub Button1_Click1(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cn As New Data.SqlClient.SqlConnection Dim dbreader As String cn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=D:\asp_pro\App_Data\multiplex.mdf;Integr ated Security=True;Connect Timeout=30;User Instance=True" cn.Open() dbreader = "select sum(no_seat) from cus_detail" 'where date='" & Date.Parse(c_date.Text) & "',mv_name='" & c_mn.Text & "',category='" & c_cat.Text & "',row_no=" & c_rn.Text & ",show_time=" & c_st.Text & " )" Dim cmd As New Data.SqlClient.SqlCommand(dbreader, cn) Dim reader As Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader If reader.HasRows Then Dim d As Integer reader.Read() d = reader(0) MsgBox(d) End If Dim c As Integer c = 30 - dbreader TextBox1.Text = c reader.Close() cn.Close() End Sub Protected Sub TextBox1_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged End Sub End Class

8.

Enhancement

Department of Computer Application, BIT, and DURG

Page 29

This project is complete in itself because it is developed according to the demand of an institute and this project will fulfill all its requirements.

But there are some changes of future improvements too in this project and it is good have this possibility of future updation, modifications, because any project with no change of future updation is just useless. In future following improvements which are possible in this project are:1. Compactness of software can be increased. 2. Better security.

9.

Limitations

Department of Computer Application, BIT, and DURG

Page 30

1. High security. 2. Ticket generation. 3. Graphical view of booking of seats. 4. Report generation.

10. Conclusion Department of Computer Application, BIT, and DURG

Page 31

As this project is a huge one to maintain. The actual goal is to provide the facilities of complete management and to improve the capability and working progress of user and take out them from hectic paper work. These projects not only manage the records and keep details.

Department of Computer Application, BIT, and DURG

Page 32