project with documentaion

7/31/2019 Project With Documentaion

1/76

ARIHANT COLLEGE OF COMPUTERS AND TECHNOLOGYBALAGHAT(M.P.)

SESSION 2009-2010SYNOPSIS

ON

ELECTRONIC MUSIC WORLD

Submitted in

Partial fulfillment of the requirement for the degree of

Bachelor of computer application

Submitted to

ARIHANT COLLEGE OF COMPUTERS AND TECHNOLOGY

BALAGHAT(M.P.)

GUIDED BY: SUBMITTED BY

Mr. MAHESH KUMAR RINKEY BHATIA

(Master Of Computer Applications)


2/76

DECLARATION

We hereby declare that work which is being presented in the Minor

Project entitled ELECTRONIC MUSIC WORLD is in partial fulfillment

of the requirement for the award of BACHELOR OF COMPUTER

APPLICATION. The work has been carried out at ARIHANT

COLLEGE OF COMPUTERS AND TECHNOLOGY BALAGHAT

(M.P.) and is an authentic record of our own work carried under the

guidance of Mr. MAHESH KUMAR M.C.A from JEC JABALPUR .

The matter embodied in this major Project has not been submitted by us

for the award of any other degree.

RINKEY BHATIA


3/76

ACKNOWLEDGEMENT

We feel extremely exhilarated to have completed this projectunder the invaluable guidance of Mr. mahesh kumar, our project

guides from the department of computer application in SECT

COLLEGE OF PROFESSIONAL EDUCATION, BHOPAL. We wish to

thank them for discussing the problems critically and providing concrete

suggestions. Their positive, undying optimism and constant supervision

made it possible to bring out this work in the present shape.

We acknowledge our sincere thanks to Mr. mahehsh kumar,Head Of Department, M.C.A, SECT COLLEGE OF PROFESSIONAL

EDUCATION , BHOPAL for providing us with facets from his wisdom

and also for providing facilities and directions that enabled us to

complete this work successfully.

We also thank each and every faculty member of Department of

M.C.A ,SECT COLLEGE OF PROFESSIONAL EDUCATION

BHOPAL, for their cooperation during all stages of work.We also thank our colleagues for providing critical views

regarding various phases in the project.

AMIT PAITHANKAR

RAVINDRA PAL

TABLE OF CONTENTS

Page No:


4/76

Abstract of the Project...6

Hardware and Software Requirements .....7

Non-functional requirements.8Why .NET??? ....10

ASP.NET..16

Requirement Analysis.....21

ER- Diagram ...22

System Analysis .....23

Coding...25

Screen Shots of GUI47

Goals.61

Benefits62

Limitations63

References64

Abstract

IntroductionThe aim of the project is to save the time and money, as it

is prepare for online Seat Reservation of Movie can give

better opportunity to booking seat from anywhere.

Motivation


5/76

We planned to make some common tasks that every user

does on his/her computer (opening/ closing programs,

editing texts, calculating) possible not only by mouse/

keyboard but also by voice.

BackgroundEvery speech recognition application consists of :

an engine that translates waves into text a list of speech commands

Needless to say that as the grammar increases the

probability of misinterpretations grows.We will try to keep the grammar as small as possible

without loosing information. The grammar format is

explained latter.

Hardware And Software Requirement

H/W REQUIREMENT : RAM 512MB,40 GB HDD,

Processor 2.4.


6/76

O.S REQUIREMENT : Windows Xp/2000

BACKEND USED : SQLSERVER 2000.

PLATFORM USED : .Net Framework 2005

LANGUAGE USED : ASP.Net(C#).

Non-Functional Requirements

a)Compatibility:

The Program is fully compatible with Windows 2000/XP

Operating System, that is it will only run under the

mentioned above operating systems. But is able to operatewith any king of operating system as long as the destined


7/76

operating system has TCP/IP protocol installed in his

system. It only needs a machine with TCP/IP protocol

installed on it.

b)Reliability:

The program is highly reliable as it handles all types of

error that can come during the operation of the program. It

handles the data rate variation, bandwidth management

and buffer overflow types of problems.

c)Security :As the connection is point to point to point, there is not

much worry of the security. The program only transfers the

audio data to the destination system. The data before

sending is first encoded using encoding scheme and then

compressed using compression algorithm. Then only data

is sent to the destination machine.


8/76

The destination machine receive the compressed data, it

decompress it and then decode it using the same encoded

algorithm.

d)Resource Utilization :

the system utilizes the resources like modem, line

bandwidth and the ports of the two systems. During the

audio/video data transfer the resource utilization is full and

at the peek of it when the transfer is continuous.

Why .NET???

Overview of .Net framework:


9/76

Benefits Of .Net Framework:

Based on Web standard and practices Designed using unified application models Easy for developers to use Extensible Classes

The .Net framework was designed to meet the following goals:

Based on Web standards and practices.

Visual Basic C++ C# Perl

XML Web Services User Interface

ADO .NET : DATA & XML

Common Language Runtime

.NET framework Class Librar

WIN 32

Message COM+ WMIIIS

J#

.NET framework

Windows API

VB Forms ASPMFC / ATL

Visual Basic C++ C# Perl

XML Web Services User Interface

ADO .NET : DATA & XML

Common Language Runtime

.NET framework Class Librar

WIN 32

Message COM+ WMIIIS

J#


10/76

The .Net framework fully support the existing internet

technologies, including Hypertext Markup Language (HTML) ,

XML, SOAP , extensible style sheet Language for transformation

(XSLT), XML path language (X PATH), and other Web standards.

The .Net framework favors loosely connected, stateless XML Web

services.

Designed using unified application models

The functionality of a .Net class is available from any .Net

compatible language or programming model.

Easy for Developers to UseIn the .Net framework, code is organized in hierarchical

namespaces and classes. The .Net framework provides a common

type system, referred to as the unified type system, which is used by

any .Net compatible language. In the unified type system, all

languages elements are objects. There are no variant types, there is

only one string type, and all string data is Unicode

Extensible ClassesThe hierarchy of the .Net framework is not hidden from the

developer. You can access and extend .Net classes (unless they are

sealed) through inheritance. You can also implement cross

language inheritance.

ASP.NET is the platform that will use to create Web Application

and Web Services that run under IIS. It provides high level ofconsistency across Web Application Development.

As you can clearly see, .NET is not just for creating web

application but for almost all kinds of applications that you find

under Windows.


11/76

Features of .NET

Now that we know some basics of .NET, let us see what makes .NET

a wonderful platform for developing modern applications.

Rich Functionality out of the box.NET framework provides a rich set of functionality out of the

box. It contains hundreds of classes that provide variety of

functionality ready to use in your applications. This means that

as a developer you need not go into low level details of many

operations such as file IO, network communication and so on.

Easy development of web applicationsASP.NET is a technology available on .NET platform for

developing dynamic and data driven web applications.

ASP.NET provides an event driven programming model (similar

to that simplify development of web pages (now called as web

forms) with complex user interface. ASP.NET server controls

provide advanced user interface elements (like calendar and

grids) that save lot of coding from programmers side.

OOPs SupportThe advantages of Object Oriented programming are well

known. .NET provides a fully object oriented environment. The

philosophy of .NET isObject is mother of all. Languageslike ASP.NET now support many of the OO features that were

lacking traditionally. Even primitive types like integer and

characters can be treated as objectssomething not available

even in OO languages like C++.

Multi-Language SupportGenerally enterprises have varying skill sets. For example, a

company might have people with skills in Visual Basic, C++,

and Java etc. It is an experience that whenever a new languageor environment is invented existing skills are outdated. This


12/76

naturally increases cost of training and learning curve. .NET

provides something attractive in this area. It supports multiple

languages. This means that if you have skills in C++, you need

not throw them but just mould them to suit .NET environment.

Currently four languages are available right out of the box

namelyVisual Basic.NET, C# (pronounced as C-sharp),

Jscript.NET and Managed C++ (a dialect of Visual C++). There

are many vendors that are working on developing language

compilers for other languages (20+ language compilers are

already available). The beauty of multi language support lies in

the fact that even though the syntax of each language is

different, the basic capabilities of each language remain at par

with one another.

Multi-Device SupportModern lift style is increasingly embracing mobile and wireless

devices such as PDAs, mobiles and handheld PCs. . . .NET

provides promising platform for programming such devices.

.NET Compact Framework and Mobile Internet Toolkit are step

ahead in this direction.

Automatic memory managementWhile developing applications developers had to develop an eye

on system resources like memory. Memory leaks were major

reason in failure of applications. .NET takes this worry away

from developer by handling memory on its own. The garbage

collector takes care of freeing unused objects at appropriate

intervals.

Compatibility with COM and COM+Before the introduction of .NET, COM was the de-facto

standard for componentized software development. Companies

have invested lot of money and efforts in developing COM

components and controls. The good news isyou can still use

COM components and ActiveX controls under .NET. Thisallows you to use your existing investment in .NET applications.


13/76

.NET still relies on COM+ for features like transaction

management and object pooling. In fact it provides enhanced

declarative support for configuring COM+ application right

from your source code. Your COM+ knowledge still remains as

a valuable asset.

No more DLL HellIf you have worked with COM components, you probably are

aware of DLL hell. DLL conflicts are a common fact in COM

world. The main reason behind this was the philosophy of COM

one version of component across machine. Also, COMcomponents require registration in the system registry. .NET

ends this DLL hell by allowing applications to use their owncopy of dependent DLLs. Also, .NET components do not

require any kind of registration in system registry.

Strong XML supportNow days it is hard to find a programmer who is unaware of

XML. XML has gained such a strong industry support that

almost all the vendors have released some kind of upgrades or

patches to their existing software to make it XML compatible.Currently, .NET is the only platform that has built with XML

right into the core framework. .NET tries to harness power of

XML in every possible way. In addition to providing support for

manipulating and transforming XML documents, .NET provides

XML web services that are based on standards like HTTP, XML

and SOAP.

Ease of deployment and configurationDeploying windows applications especially that used COM

components were always been a tedious task. Since .NET does

not require any registration as such, much of the deployment is

simplified. This makes XCOPY deployment viable.

Configuration is another area where .NETespeciallyASP.NETshines over traditional languages. The configuration


14/76

is done via special files having special XML vocabulary. Since,

most of the configuration is done via configuration files, there is

no need to sit in front of actual machine and configure the

application manually. This is more important for web

applications; simply converting to FTP new configuration file

makes necessary changes.

SecurityWindows platform was always criticized for poor security

mechanisms. Microsoft has taken great efforts to make .NET

platform safe and secure for enterprise applications. Features

such as type safety, code access security and role based

authentication make overall application more robust and secure.

ASP.NET:


15/76

The ASP .NET programming language was introduced with the

.NET Framework. It represents a milestone in the area of

programming language development. Even though the genesis of the

new ASP .NET language represents the most innovative, modern, and

event in most areas the preferred .NET programming language.

ASP.NET was introduced to combine the key values of ASP.NET and

C++. Whereas ASP.NET had ease of use and high developer

productivity, C++ represented the ultimate flexibility and control.

ASP .NET merges the two; it is relatively simpler than C++ (no

pointers, templates, and so on), and it has all the nice object-oriented

features of C++ and the ease of use of Visual Basic.

No more specific memory allocation is required, as everythingis "garbage collected" by the common runtime. In various ways, ASP

.NET has gained wide developer support as well. However, whereas

C++ is intended to be a platform-neutral programming language

compiling into byte code and then executed on a virtual machine, ASP

.NET programs are compiled (like all .NET programming languages)

into MSIL (Microsoft Intermediate Language) and, like all

applications, are ultimately converted into machine code before

execution.

ASP .NET follows a code-focused model, targeted for developers

who like the simplicity of a modern programming language but

typically prefer to write programs by hand instead of generating them

with wizards. This enables easier reuse because the code is relatively

easier to understand by other developers using it. Key highlights of

the ASP.NET programming language are the following:

Ease of ASP.NET with the power of most C++ features Similar programming language syntax for VB Support for all CLR data types Pass by reference and value for parameters Inheritance Polymorphism Dynamic binding


16/76

XML-based documentation, using special comments Integration with Visual Studio .NET for rapid development

ASP .NET classes are stored in .CS files. After you have saved the

preceding program in a file, let's say Hello World. You can compile

the program into a .NET executable. You will need to include the

.NET Framework SDK's bin folder in your PATH variable. If you

have installed Visual Studio .NET, you have a shortcut under Visual

Studio .NET Tools called Visual Studio .NET 2003 Command

Prompt. This shortcut initializes all the environment variables and

provides access to the command-line compilers as well.

ASPc HelloWorld.aspx

Now enter HelloWorld.exe to run the application, and you should see

"Hello World in ASP .NET " echoed on the screen.

Comments:

ASP.NET provides a couple of ways to introduce comments in a

program; the two most popular are the traditional single-linecomments (). In addition, ASP.NET provides XML-based comments

that can be used to create XML documentation from a set of code

files. These XML files can then be processed with an XSLT (XML

Style sheet Language) to convert into online HTML documentation,

and so on.

Data Types:

Table 1 describes how the ASP .NET types are mapped into thecorresponding .NET Framework types. In a true sense, the ASP .NET

keywords are really a compact representation for the .NET type.


17/76

Table 1 ASP .NET Data Types

ASP .NET Type Corresponding .NET Framework Type

Boolean System. Boolean

byte, sbyte System. Byte, System. SByte

Char System. Char

Decimal, double,

single

System. Decimal, System. Double, System. Single

short, ushort, int,

uint, long, ulong

System.Int16, System.UInt16, System.Int32,

System.UInt32, System.Int64, /ystem.UInt64

Object System. Object

String System. String

Enumerations:

ASP .NET provides the enumerations programming construct,

which provides a human-readable form of a series of related constant

values.

Structures

Structures are simply an aggregation of value types and are

allocated on the stack and not on the heap. Structures are useful for

passing a logical and related set of data values. Structures don't

support inheritance but can implement interfaces..


18/76

Classes

Classes, on the other hand, are reference types and hence are

allocated on the heap. Classes provide object-oriented constructs such

as encapsulation, polymorphism, and inheritance.

Inheritance

Classes provide inheritance capability, which allows the derived

class to inherit the functionality of a base class and potentially

override some of the methods. A class definition consists of

constructors and destructors, members, methods, properties, and

events. (You will learn more about events later in this section.) Unlike

the Java programming language, in ASP .NET all methods that are

overridden must be marked as virtual in the base class. This operator

provides runtime validation if an object is of a particular type. For

instance, the following program will return that a Full Person object is

always a Person.

Interfaces

ASP .NET provides the concept of interfaces. Interfaces really

represent a signature of what needs to be implemented by a derived

class. ASP .NET supports multiple inheritances of interfaces

Exception Handling

ASP.NET provides robust exception handling capabilities. For

instance, the program that follows catches the exception at runtime

and allows messages to be displayed to the end user without requiring

an intermediate exit.

Delegates

Delegates give ASP.NET programmers the capability of

function pointers, basically passing a function as a parameter. For

instance, Listing 3.4 shows two delegates to be created and then

invoked.

There were four primary goals in the creation of ASP .NET language.

It is object oriented. It is independent of host platform


19/76

It contains language facilities and libraries for networking. It is designed to execute code from remote resources securely.

Object Orientation:

The first characteristics, object orientation (OO), refers to amethod of programming and language design. The main idea of OO is

to design software around the things (i.e. objects) it manipulates,rather than the action its performs. This is based on the notion that the

former change less frequently and radically than the later, making

such objects (actually the entities containing the data) the more stable

foundation for a software system design. The intent is to make large

software project easier to manage, thus improving quality and

reducing the number of failed projects.

Platform IndependenceThe second characteristics platform independence means that

programs written in the ASP .NET language must run similarly on

diverse hardware. One should be able to write a program once and run

it anywhere. Program written in native code on host hardware that

translates generic byte code into usable code on the hardware. Further,

standardized libraries are provided to allow access to features of the

host machines (such as graphics and networking) in unified ways.

The genesis to this programming flexibility occurred for tworeasons: flexibility and ease of migration and skills reuse. For

instance, millions of Visual Basic developers worldwide can choose

the ASP .NET programming language for utilizing and enhancing

their existing skills; all programming languages have similar common

features; most can be used for achieving similar results. Each,

however, has its own benefits and differentiators, but most of the

differences lie in the language syntax.


20/76

Requirement Analysis

Requirements

We need .NET Devlopment Tool. SQL Server 2000 for database


21/76

ER- Diagram


22/76

System Analysis

The Project is divided into different modules. A list of all the modules

used are:

"Start voting"/"Stop voting" :To enable/disable the mic (it's switched according to what you

choose), after disabling the label's becomes red (accuracy and

state) indicating our state.

"Use agent" :Though the agent is used only for giving feedback it's could be

useful to know if your command is heard or not. even though

you can disable it if you want or if you don't have an agent file

(can be downloaded from Microsoft, *.cs files) or if it is not

working and you still want to use the recognition (there is no

connection between the agent and the recognition !).This also is being take care if the program didn't find the agent

file or could not be loaded from any other reason.

"Add favorites" :In the "activate" state you can say the command "favorites

programs" and open a form with your favorites programs and

running them by saying the program name. This menu will open

a form showing your favorites programs so you can add/deleteor edit them as you want.

"Change character" :


23/76

This will allow you changing the agent character (can download

them from Microsoft site, *.acs files).

"Change accuracy limit" :Every recognition accuracy is displayed in the "Accuracy" label,

you can choose this menu and change the accuracy limit that

you want the program to respond to the command that he hears.

you should do this to avoid responding to any voice or sound

that he hears. you can rise this more every time that you train

your computer and increase the recognition.

"Change user profile" :If the program is being used by several users you can choose to

each user a profile and train the computer for each one (to add a

user profile enter "control panel -> speech", here you can only

choose existing one's).

"Mic training wizard" :A very important (as I explained before) for the recognition.

The first thing to do in every computer (only at the first time) is

to activate this menu and setting up your mic or if you changed

your mic to a new one.

"User training wizard" :For a better recognition (notice that the training is for the

selected user profile...).


24/76

CODING:

AmitRavi\MovieProj\App_Code

using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data ;using System.Data.SqlClient ;

///

/// Summary description for conDb///publicclassconDb{

publicstring ErrorMessages = "";string strcon = ConfigurationManager.AppSettings["conn"];

publicbool retriveRecord(refDataSet ds, string query){

try{

SqlConnection con1 = newSqlConnection(strcon);

con1.Open();SqlDataAdapter da = newSqlDataAdapter(query, con1);da.Fill(ds);con1.Close();returntrue;

}catch{

returnfalse;}

}publicbool fillGridview(refGridView grid, string query)

{try{

if (query == ""){

ErrorMessages = "Please set the Sqlcommand Text Property";returnfalse;

}

SqlConnection con1 = newSqlConnection(strcon);con1.Open();DataSet ds = newDataSet();SqlDataAdapter da = newSqlDataAdapter(query, con1);

da.Fill(ds);grid.DataSource = ds;grid.DataBind();


25/76

con1.Close();returntrue;

}catch (Exception ex){

ErrorMessages = ex.Message.ToString();returnfalse;}

}public bool FillDropDownList(refDropDownList Droplist, string

query,string TextField,string ValueField){

try{

SqlConnection con1 = newSqlConnection(strcon);con1.Open();DataSet ds = newDataSet();SqlDataAdapter da = newSqlDataAdapter(query, con1);

da.Fill(ds);

Droplist.DataSource = ds;Droplist.DataTextField = TextField;Droplist.DataValueField = ValueField;Droplist.DataBind();con1.Close();returntrue;


ErrorMessages = ex.Message.ToString();returnfalse;

}}public int nextid(string querry){

try{

DataSet ds = newDataSet ();

retriveRecord(ref ds, querry);int a =Convert.ToInt16 ( ds.Tables[0].Rows[0][0].ToString ());a = a + 1;return a;


return 0;}

}publicbool ExecuteNonqueryes(string InsertOrUpdateOrDeleteQuery){

try{

SqlConnection con1 = newSqlConnection(strcon);con1.Open();SqlCommand cmd = newSqlCommand(InsertOrUpdateOrDeleteQuery,

con1);cmd.ExecuteNonQuery();con1.Close();


26/76

return true;


ErrorMessages = ex.Message.ToString();

returnfalse;}

}

publicbool insertbyProcedure(int movieid,int theaterid,DateTimestartdate,DateTime enddate, int showtimeid )

{try{

SqlConnection con1 = newSqlConnection(strcon);con1.Open();

SqlCommand sqlcmd = newSqlCommand();sqlcmd.CommandText = "MoviesheduleEntry";sqlcmd.CommandType = CommandType.StoredProcedure;sqlcmd.Connection = con1;int NumRowsReturn = 0;sqlcmd.Parameters.Add("@movieid", SqlDbType.Int);sqlcmd.Parameters.Add("@theaterid", SqlDbType.Int);sqlcmd.Parameters.Add("@startdate", SqlDbType.DateTime);sqlcmd.Parameters.Add("@enddate", SqlDbType.DateTime);sqlcmd.Parameters.Add("@showtime", SqlDbType.Int );sqlcmd.Parameters[0].Value = movieid;sqlcmd.Parameters[1].Value = theaterid;sqlcmd.Parameters[2].Value = startdate;sqlcmd.Parameters[3].Value = enddate;sqlcmd.Parameters[4].Value = showtimeid;NumRowsReturn = sqlcmd.ExecuteNonQuery();

if (NumRowsReturn != 0){

con1.Close();returntrue;

}else{

con1.Close();returnfalse;

}


returnfalse;}

}

}


27/76

Admin.aspx

using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;

publicpartialclassAdmin : System.Web.UI.Page

{string strcon = ConfigurationManager.AppSettings["conn"];protectedvoid Page_Load(object sender, EventArgs e){

LinkButton1.Enabled = false;LinkButton2.Enabled = false;LinkButton4.Enabled = false;LinkButton7.Enabled = false;LinkButton3.Enabled = false;

}protectedvoid Button1_Click2(object sender, EventArgs e){

}protectedvoid Button2_Click(object sender, EventArgs e){


SqlConnection con = newSqlConnection(strcon);con.Open();string str = "select isnull(adminid,0) from admin where username='"

+ TextBox1.Text + "' and password='" + TextBox2.Text + "'";SqlCommand cmd = newSqlCommand(str, con);

int a = Convert.ToInt16(cmd.ExecuteScalar());if (a > 0){

Label3.Text = "WelCome To Theater";// Response.Redirect("Default2.aspx");LinkButton1.Enabled = true;LinkButton2.Enabled = true ;LinkButton4.Enabled = true;LinkButton7.Enabled = true;LinkButton3.Enabled = true;

}

else{

Label3.Text = "please Enter right Username and Password";


28/76

}con.Close();

}protectedvoid LinkButton1_Click(object sender, EventArgs e){

Response.Redirect("New Movies.aspx");}protectedvoid LinkButton2_Click(object sender, EventArgs e){

Response.Redirect("ScheduleEntry1.aspx");}protectedvoid LinkButton4_Click(object sender, EventArgs e){

Response.Redirect("Price List.aspx");

}protectedvoid LinkButton7_Click(object sender, EventArgs e){

Response.Redirect("Seat Category.aspx");}protectedvoid LinkButton3_Click(object sender, EventArgs e){

}protectedvoid LinkButton3_Click1(object sender, EventArgs e){

Response.Redirect("NewShowTime.aspx");}

}


29/76

CusShowtime.aspx

using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;

publicpartialclassCusShowtime : System.Web.UI.Page

{ protectedvoid Page_Load(object sender, EventArgs e){

conDb con= newconDb ();

string str="select theatername,showtime from showtime,theaterwhere showtime.theaterid = theater.theaterid";

con.fillGridview (ref GridView1 ,str);}

}


30/76

Customers.aspx


publicpartialclassCustomers : System.Web.UI.Page

{conDb con= newconDb ();int nextcutomerid;

protectedvoid Page_Load(object sender, EventArgs e){

this.lst1 = (ListBox)Session["list1"];this.lst2 = (ListBox)Session["list2"];this.lst3 = (ListBox)Session["list3"];

string nextcutomer = "select isnull(max(CustomerReservationId),0)from customer";

DataSet ds = newDataSet();

con.retriveRecord(ref ds, nextcutomer);nextcutomerid =Convert.ToInt16(ds.Tables[0].Rows[0][0].ToString());

TextBox1.Text = Convert.ToString(nextcutomerid);


int priceid1= Convert.ToInt16 (Session["rate1"] );int priceid2= Convert.ToInt16 (Session["rate2"] );int priceid3= Convert.ToInt16 ( Session["rate3"] );

int isreserved = 0;

int moviescheduleid =Convert.ToInt16 ( Session["moviescheduleid"]);string strinsert = "Insert into

customer(customerName,phoneNo,Address,customerAccountNo,BankName)values('" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" +TextBox5.Text + "','" + TextBox6.Text + "') ";

bool isinserted = con.ExecuteNonqueryes(strinsert);

if (isinserted){

for (int i = 0; i < lst1.Items.Count; i++){

string str = "insert into reservation(MovieScheduleId,SeatId,PriceListId,CustomerReservationId )values(" +moviescheduleid + ",'" + lst1.Items[i].Value + "',"+priceid1+"," +nextcutomerid + ")";


31/76

con.ExecuteNonqueryes(str);

isreserved = 1;}for (int i = 0; i < lst2.Items.Count; i++){

string str = "insert into reservation(MovieScheduleId,SeatId,PriceListId,CustomerReservationId )values(1,'" +lst2.Items[i].Value + "'," + priceid2 + "," + nextcutomerid + ")";

con.ExecuteNonqueryes(str);isreserved = 1;

}for (int i = 0; i < lst3.Items.Count; i++){

string str = "insert into reservation(MovieScheduleId,SeatId,PriceListId,CustomerReservationId )values(1,'" +lst3.Items[i].Value + "'," + priceid3 + "," + nextcutomerid + ")";

con.ExecuteNonqueryes(str);isreserved = 1;

}if (isreserved == 1){

Label8.Text = "Seats has been Reserved";}

}

}publicvoid FillListBox(){// ListBox1.Text =


Response.Redirect("SeatReservation.aspx");}

}


32/76

CustShowtheaters.aspx


publicpartialclassShowtheaters : System.Web.UI.Page{


string str = "select theatername from theater";conDb con = newconDb();con.fillGridview(ref GridView1, str);

}}


33/76

Homepage.aspx


publicpartialclassHomepage : System.Web.UI.Page{


}}


34/76

New Movies.aspx


publicpartialclassDefault3 : System.Web.UI.Page

{conDb con1 = newconDb();


string str= "select movieid from movie";int a= con1.nextid (str);

TextBox3.Text = Convert.ToString (a);}protectedvoid Button1_Click(object sender, EventArgs e){

SqlConnection con = newSqlConnection("Data Source=.;Initial

Catalog=kash;Integrated Security=True");con.Open();string strinsert = "Insert into

Movie(MovieName,StartingDate,EndDate,DirectedBy,ProducedBy,Actor,Actoress)values('" + TextBox4.Text + " ','" + TextBox2.Text + "','" + TextBox1.Text +" ','" + TextBox5.Text + " ','" + TextBox6.Text + "', '" + TextBox7.Text +"','" + TextBox8.Text + "')";

bool isinserted=con1.ExecuteNonqueryes(strinsert);if (isinserted){

Label10.Text = "MovieRecord Successfully Inserted";}else

{ Label10.Text = "Record not inserted";}


Response.Redirect("Admin.aspx");}

}


35/76

NewShowTime.aspx


publicpartialclassDefault2 : System.Web.UI.Page{

string strcon = ConfigurationManager.AppSettings["conn"];protectedvoid Page_Load(object sender, EventArgs e){

if (!Page.IsPostBack){

theaterlistfill();TextBox1.Text = Convert.ToString(nextid());fillgrid();

}

}publicvoid fillgrid(){

SqlConnection con = newSqlConnection(strcon);con.Open();SqlDataAdapter da = newSqlDataAdapter("select

showtimeid,showtime,theaterName from showtime,theater whereshowtime.theaterid = theater.theaterid", con);

DataSet ds = newDataSet();da.Fill(ds);GridView1.DataSource = ds;GridView1.DataBind();con.Close();

}publicint nextid(){

SqlConnection con = newSqlConnection(strcon);con.Open();

string str = "select isnull( max(showtimeid),0) from showtime ";SqlCommand cmd = newSqlCommand(str, con);int a = Convert.ToInt16(cmd.ExecuteScalar());con.Close();

return a + 1;

}


36/76

protectedvoid Button1_Click(object sender, EventArgs e){

SqlConnection con = newSqlConnection(strcon);con.Open();string strinsert = "Insert into

ShowTime(ShowTime,TheaterId)values('" + TextBox2.Text + "'," +

DropDownList1.SelectedValue + " )";SqlCommand cmd = newSqlCommand(strinsert, con);cmd.ExecuteNonQuery();con.Close();

}publicvoid theaterlistfill(){

SqlConnection con = newSqlConnection(strcon);con.Open();

string str = "select theaterid ,theatername from theater";SqlDataAdapter da = newSqlDataAdapter(str, con);

DataSet ds = newDataSet();da.Fill(ds);DropDownList1.DataSource = ds;

DropDownList1.DataTextField = "theatername";DropDownList1.DataValueField = "theaterid";DropDownList1.DataBind();con.Close();

}protectedvoid GridView1_SelectedIndexChanged( object sender, EventArgs

e){

// GridView1.row}protectedvoid GridView1_RowEditing(object sender,

GridViewEditEventArgs e){

GridView1.EditIndex = e.NewEditIndex;FillGrid();

}privatevoid FillGrid(){

}

protectedvoid GridView1_RowUpdating(object sender,GridViewUpdateEventArgs e)

{SqlConnection con = newSqlConnection(strcon);con.Open();

Response.Write("row updating......");GridViewRow row = GridView1.Rows[e.RowIndex];TextBox txt1 = (TextBox)row.Cells[1].Controls[0];// TextBox txt2 = (TextBox)row.Cells[0].Controls[0];// string str = "update showtime set showtime='"+txt1.Text+"' where

showtimeid="+txt2 .Text +"";string str = "update showtime set showtime='" + txt1.Text + "'";str=str+"where showtimeid=" +(row.Cells[0].Text )+ "";

System.Diagnostics.Debug.WriteLine(str);SqlCommand cmd = newSqlCommand(str, con);

cmd.ExecuteNonQuery();


37/76

con.Close();

fillgrid();}protectedvoid GridView1_RowDeleting(object sender,

GridViewDeleteEventArgs e){GridViewRow row = GridView1.Rows[e.RowIndex];string str = "delete from showtime where showtimeid =" +

(row.Cells[0].Text) + "";SqlConnection con = newSqlConnection(strcon);con.Open();

Response.Write("row deleting......");

System.Diagnostics.Debug.WriteLine(str);SqlCommand cmd = newSqlCommand(str, con);cmd.ExecuteNonQuery();

con.Close();}protectedvoid GridView1_PageIndexChanging(object sender,

GridViewPageEventArgs e){

GridView1.PageIndex = e.NewPageIndex;fillgrid();



}


38/76

Price List.aspx


publicpartialclassDefault4 : System.Web.UI.Page

{SqlConnection con = newSqlConnection("Data Source=.;Initial

Catalog=kash;Integrated Security=True");conDb con1 = newconDb();



string str = " select isnull( max(pricelistid),0) frompricelist";

int a= con1.nextid(str);TextBox1.Text = Convert.ToString(a);

theaterlistfill();seatcategorylistfill();ShowTimelistfill();string str1="select pricelistid,theater.theatername as

theatername, Seatcategory.seatcategoryname,Pricelist.rate from theater,seatcategory,pricelist where Pricelist.theaterid=theater.theaterid andpricelist.SeatCategoryId=seatcategory.SeatCategoryId" ;

con1.fillGridview(ref GridView1, str1);}


con.Open();SqlDataAdapter da = newSqlDataAdapter();string strinsert = "Insert into PriceList(TheaterId,

SeatCategoryId,Rate)values(" + DropDownList1.SelectedValue + ","+DropDownList3.SelectedValue + "," + TextBox2.Text + ")";

SqlCommand cmd = newSqlCommand(strinsert, con);cmd.ExecuteNonQuery();con.Close();string str1 = "select theater.theatername as theatername,

Seatcategory.seatcategoryname,Pricelist.rate from theater,seatcategory,pricelist where Pricelist.theaterid=theater.theaterid andpricelist.SeatCategoryId=seatcategory.SeatCategoryId" ;

con1.fillGridview(ref GridView1, str1);}publicvoid theaterlistfill(){

con.Open();


39/76

string str = "select theaterid ,theatername from theater";SqlDataAdapter da = newSqlDataAdapter(str, con);DataSet ds = newDataSet();da.Fill(ds);DropDownList1.DataSource = ds;DropDownList1.DataTextField = "theatername";

DropDownList1.DataValueField = "theaterid";DropDownList1.DataBind();con.Close();

}publicvoid ShowTimelistfill(){

con.Open();string str = "select ShowTimeid ,ShowTime from ShowTime where

theaterid="+DropDownList1.SelectedValue+ " ";SqlDataAdapter da = newSqlDataAdapter(str, con);DataSet ds = newDataSet();da.Fill(ds);

DropDownList2.DataSource = ds;DropDownList2.DataTextField = "ShowTime";DropDownList2.DataValueField = "ShowTimeid";DropDownList2.DataBind();con.Close();

}publicvoid seatcategorylistfill()

{

con.Open();string str = "select seatcategoryid ,seatcategoryname from

seatcategory";SqlDataAdapter da = newSqlDataAdapter(str, con);DataSet ds = newDataSet();da.Fill(ds);DropDownList3.DataSource = ds;DropDownList3.DataTextField = "seatcategoryname";DropDownList3.DataValueField = "seatcategoryid";DropDownList3.DataBind();con.Close();

}

protectedvoid DropDownList1_SelectedIndexChanged( object sender,EventArgs e)

{

}protectedvoid GridView1_RowDeleted(object sender,

GridViewDeletedEventArgs e){

}protectedvoid GridView1_RowDeleting(object sender,

GridViewDeleteEventArgs e){

string str= GridView1.Rows[e.RowIndex].Cells[0].Text ;string strforDel = "Delete from pricelist where pricelistid=" + str

+ "";


40/76

con1.ExecuteNonqueryes(strforDel);string str1 = "select pricelistid,theater.theatername as

theatername, Seatcategory.seatcategoryname,Pricelist.rate from theater,seatcategory,pricelist where Pricelist.theaterid=theater.theaterid andpricelist.SeatCategoryId=seatcategory.SeatCategoryId" ;

con1.fillGridview(ref GridView1, str1);



}


41/76

ScheduleEntry1.aspx


publicpartialclassScheduleEntry1 : System.Web.UI.Page{

int nextsheduleid;ArrayList showtime;int[] showtimeidArr;int theaterid;int movieid;

conDb con = newconDb();



string str1 = "select movieid,moviename from movie";string str2 = "select theaterid,theatername from theater";string str3 = "select moviesheduleid, Movie.moviename as

moviename,theater.theatername as theatername,Convert(varchar,Dates,110)asDates, showtime.showtime as showtime from movie, movieshedule,theater,showtime where movie.movieid=movieshedule.movieid andmovieshedule.theaterid= theater.theaterid and movieshedule.showtimeid=showtime.showtimeid";

con.FillDropDownList(ref DropDownList1, str1, "moviename","movieid");

con.FillDropDownList(ref DropDownList2, str2, "theatername","theaterid");

con.fillGridview(ref GridView1, str3);

}}protectedvoid Button1_Click(object sender, EventArgs e){

movieid = Convert.ToInt16(DropDownList1.SelectedValue);theaterid = Convert.ToInt16(DropDownList2.SelectedValue);showtimeidArr = newint[CheckBoxList1.Items.Count];

for (int i = 0; i < CheckBoxList1.Items.Count; i++){

if (CheckBoxList1.Items[i].Selected){

Int16 showtimeid =Convert.ToInt16 (CheckBoxList1.Items[i].Value);

DateTime startdate = Convert.ToDateTime(TextBox1.Text);DateTime enddate = Convert.ToDateTime(TextBox2.Text);


42/76

bool isinserted = con.insertbyProcedure(movieid, theaterid,startdate, enddate,showtimeid );

if (isinserted){

Label4.Text = "Record has been inserted";}

}}

}


{string str = "select Convert (varchar, startingdate,110)as

startingdate, Convert (varchar, enddate,110)as enddate from movie wheremovieid=" + DropDownList1.SelectedValue + "";

DataSet ds = newDataSet();con.retriveRecord(ref ds, str);

TextBox1.Text =Convert.ToString (ds.Tables[0].Rows[0][0].ToString());

TextBox2.Text = Convert.ToString ( ds.Tables[0].Rows[0][1].ToString());

//string str2 = "select theaterid,theatername from theater ";//con.FillDropDownList(ref DropDownList2,str2, "theatername",

"theaterid");}


{int theaterindex = Convert.ToInt16(DropDownList2.SelectedValue) ;string str1 = "select showtimeid ,showtime from showtime where

theaterid=" + theaterindex + "";DataSet ds1 = newDataSet();con.retriveRecord(ref ds1, str1);if (ds1.Tables[0] != null){

CheckBoxList1.DataSource = ds1;CheckBoxList1.DataTextField = "showtime";CheckBoxList1.DataValueField = "showtimeid";CheckBoxList1.DataBind();

}

}

}


43/76

Seat Category.aspx

using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;publicpartialclassSeat_Category : System.Web.UI.Page{

string strcon = ConfigurationManager.AppSettings["conn"];protectedvoid Page_Load(object sender, EventArgs e){


seatcategoryidlistfill();}


SqlConnection con = newSqlConnection(strcon);con.Open();SqlDataAdapter da = newSqlDataAdapter();string strinsert = "Insert into

seatcategory(SeatCategoryName)values(" + DropDownList1.SelectedValue + ")";SqlCommand cmd = newSqlCommand(strinsert, con);cmd.ExecuteNonQuery();con.Close();

}publicvoid seatcategoryidlistfill(){

SqlConnection con = newSqlConnection(strcon);con.Open();string str = "select seatcategoryid ,seatcategoryname from

seatcategory";SqlDataAdapter da = newSqlDataAdapter(str, con);DataSet ds = newDataSet();da.Fill(ds);DropDownList1.DataSource = ds;DropDownList1.DataTextField = "SeatcategoryName";DropDownList1.DataValueField = "SeatcategoryId";DropDownList1.DataBind();con.Close();




44/76

}

SeatReservation.aspx

using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;using System.Drawing;

publicpartialclassSeatReservation : System.Web.UI.Page{

conDb con = newconDb();

int moviescheduleid = 0;string strcon = ConfigurationManager.AppSettings["conn"];



string str1 = "select movieid,moviename from movie";string str2 = "select theaterid,theatername from theater";con.FillDropDownList(ref DropDownList1, str2, "theatername",

"theaterid");if (DropDownList1.Items.Count!=0){

string retrivemove = "select distinct( moviename),movie.movieid as movieid from movie ,movieshedule where movie.movieid=movieshedule.movieid and theaterid=" + DropDownList1.SelectedValue + "";

con.FillDropDownList(ref DropDownList2, retrivemove,"moviename", "movieid");

string retriveshowtime = "select showtime ,showtimeid fromshowtime where theaterid=" + DropDownList1.SelectedValue + "";

con.FillDropDownList(ref DropDownList4, retriveshowtime,"showtime", "showtimeid");

}if (DropDownList2.Items.Count!=0){string retrivedate= "select convert(varchar,dates,110)as dates

from movieshedule where movieid="+DropDownList2.SelectedValue+ "";con.FillDropDownList(ref DropDownList3, retrivedate, "dates",

"dates");}

Fillgridwithseat();

fillprice();


45/76

}

}


Response.Redirect("Homepage.aspx");}protectedvoid Button3_Click(object sender, EventArgs e){

findmovieid();Session["list1"] = ListBox1;Session["list2"] = ListBox2;Session["list3"] = ListBox3;Response.Redirect("Customers.aspx");

}protectedvoid DropDownList1_SelectedIndexChanged( object sender,

EventArgs e){


ListBox1.Items.Clear();ListBox2.Items.Clear();ListBox3.Items.Clear();

}protectedvoid DropDownList1_SelectedIndexChanged1( object sender,

EventArgs e){


EventArgs e){


EventArgs e){

string retrivemove = "select distinct( moviename) ,movie.movieid asmovieid from movie ,movieshedule where movie.movieid= movieshedule.movieidand theaterid=" + DropDownList1.SelectedValue + "";

con.FillDropDownList(ref DropDownList2, retrivemove, "moviename","movieid");

string retriveshowtime = "select showtime ,showtimeid from showtimewhere theaterid=" + DropDownList1.SelectedValue + "";

con.FillDropDownList(ref DropDownList4, retriveshowtime,"showtime", "showtimeid");

DataSet ds = newDataSet();DataSet ds1 = newDataSet();DataSet ds2 = newDataSet();string pricelist1 = "select Rate,pricelistid from pricelist where

theaterid=" + DropDownList1.SelectedValue + " and Seatcategoryid=1";con.retriveRecord(ref ds, pricelist1);string pricelist2 = "select Rate,pricelistid from pricelist where

theaterid=" + DropDownList1.SelectedValue + " and Seatcategoryid=2";con.retriveRecord(ref ds1, pricelist2);

string pricelist3 = "select Rate,pricelistid from pricelist wheretheaterid=" + DropDownList1.SelectedValue + " and Seatcategoryid=3";

con.retriveRecord(ref ds2, pricelist3);


46/76

Label6.Text = Convert.ToString(ds.Tables[0].Rows[0][0].ToString());Label7.Text =

Convert.ToString(ds1.Tables[0].Rows[0][0].ToString());Label8.Text =

Convert.ToString(ds2.Tables[0].Rows[0][0].ToString());Session["rate1"] =

Convert.ToInt16(ds.Tables[0].Rows[0][1].ToString());Session["rate2"] =Convert.ToInt16(ds1.Tables[0].Rows[0][1].ToString());

Session["rate3"] =Convert.ToInt16(ds2.Tables[0].Rows[0][1].ToString());

Fillgridwithseat();

}publicvoid fillprice(){

DataSet ds = newDataSet();DataSet ds1 = newDataSet();DataSet ds2 = newDataSet();

string pricelist1 = "select Rate,pricelistid from pricelist wheretheaterid=1 and Seatcategoryid=1";con.retriveRecord(ref ds, pricelist1);string pricelist2 = "select Rate,pricelistid from pricelist where

theaterid=1 and Seatcategoryid=2";con.retriveRecord(ref ds1, pricelist2);string pricelist3 = "select Rate,pricelistid from pricelist where

theaterid=1 and Seatcategoryid=3";con.retriveRecord(ref ds2, pricelist3);Label6.Text = Convert.ToString(ds.Tables[0].Rows[0][0].ToString());Label7.Text =

Convert.ToString(ds1.Tables[0].Rows[0][0].ToString());Label8.Text =

Convert.ToString(ds2.Tables[0].Rows[0][0].ToString());Session["rate1"] =

Convert.ToInt16(ds.Tables[0].Rows[0][1].ToString());Session["rate2"] =

Convert.ToInt16(ds1.Tables[0].Rows[0][1].ToString());Session["rate3"] =

Convert.ToInt16(ds2.Tables[0].Rows[0][1].ToString());

}


{ string retrivedate= "select convert(varchar,dates,110)as dates frommovieshedule where movieid="+DropDownList2.SelectedValue+"";

con.FillDropDownList(ref DropDownList3, retrivedate, "dates","dates");

Fillgridwithseat();

}protectedvoid ListBox1_SelectedIndexChanged( object sender, EventArgs

e){

ListBox1.Items.Remove(ListBox1.SelectedItem);

}protectedvoid ListBox2_SelectedIndexChanged( object sender, EventArgs

e){

ListBox2.Items.Remove(ListBox2.SelectedItem);


47/76

}publicvoid Fillgridwithseat(){

DataSet ds = newDataSet();string str1 = "select seatid from SeatPosition where seatid between

'jBA01' and 'jLO40'";bool isdatafound = con.retriveRecord(ref ds, str1);int p = 0;DataTable dt = newDataTable();for (int s = 0; s < 10; s++){

dt.Columns.Add(s.ToString());

}for (int i = 0; i < 10; i++){

DataRow row = dt.NewRow();

for (int j = 0; j < 10; j++){row[j] = ds.Tables[0].Rows[p][0].ToString();p = p + 1;string str = row[j].ToString ();

}dt.Rows.Add(row);

}GridView1.DataSource = dt;GridView1.DataBind();

for (int i = 0; i < 3; i++){

for (int j = 0; j < 10; j++){

GridView1.Rows[i].Cells[j].BackColor = Color.GreenYellow ;}

}for (int i = 3; i < 6; i++){

for (int j = 0; j < 10; j++){

GridView1.Rows[i].Cells[j].BackColor = Color.Green;}

}for (int i = 6; i < 10; i++){

for (int j = 0; j < 10; j++){

GridView1.Rows[i].Cells[j].BackColor = Color.Blue;}

}

}publicvoid FindPreviouslyReserveSeats(int moviescheduleids ){

int p = 0;int movieshid = Convert.ToInt16(Session["moviescheduleid"]);

string str = "select Seatid from Reservation whereMovieScheduleId=1 order by Seatid ";

DataSet reservationDS = newDataSet();


48/76

bool isdatafound = con.retriveRecord(ref reservationDS, str);

try{

for (int i = 0; i < 10; i++){

for (int j = 0; j < 10; j++){

int n = j + 1;string buttonColumn = "b" + n.ToString();string str3 = "";

GridViewRow row = GridView1.Rows[i];string str4 =

((Button)row.FindControl(buttonColumn)).Text;

if (p < reservationDS.Tables[0].Rows.Count)

{

str3 =reservationDS.Tables[0].Rows[p][0].ToString();

}if (str3 == str4){

GridView1.Rows[i].Cells[j].BackColor = Color.Red;p = p + 1;

}}

}


}}publicvoid findmovieid(){

DataSet ds = newDataSet();string str = "select Moviesheduleid from movieshedule where

theaterid=" + DropDownList1.SelectedValue + " and movieid =" +DropDownList2.SelectedValue + " and Dates='" + DropDownList3.SelectedValue+ "' and Showtimeid=" + DropDownList4.SelectedValue + "";

bool isrecordexist = con.retriveRecord(ref ds, str);if (isrecordexist){

ShowSeatPossition.Text = "Reservation position schedule" +ds.Tables[0].Rows[0][0].ToString();

moviescheduleid = Convert.ToInt16(ds.Tables[0].Rows[0][0]);

Session["moviescheduleid"] = moviescheduleid;if (moviescheduleid > 0){

FindPreviouslyReserveSeats(moviescheduleid);


49/76

}}

}


try{

DataSet ds = newDataSet();string str = "select Moviesheduleid from movieshedule where

theaterid=" + DropDownList1.SelectedValue + " and movieid =" +DropDownList2.SelectedValue + " and Dates='" + DropDownList3.SelectedValue+ "' and Showtimeid=" + DropDownList4.SelectedValue + "";

bool isrecordexist = con.retriveRecord(ref ds, str);if (isrecordexist){

ShowSeatPossition.Text = "Reservation position schedule" +ds.Tables[0].Rows[0][0].ToString();

moviescheduleid = Convert.ToInt16(ds.Tables[0].Rows[0][0]);

Session["moviescheduleid"] = moviescheduleid;if (moviescheduleid > 0){

FindPreviouslyReserveSeats(moviescheduleid);

}}


}

}

protectedvoid GridView1_SelectedIndexChanged( object sender, EventArgse)

{string str=

GridView1.Rows[GridView1.SelectedIndex].Cells[GridView1.SelectedIndex].ToString();


}protectedvoid GridView1_RowCommand(object sender,

GridViewCommandEventArgs e){

// Response.Write(e.CommandArgument.ToString());int movieshid = Convert.ToInt16(Session["moviescheduleid"]);SqlConnection con1 = newSqlConnection(strcon);con1.Open();string str = Convert.ToString(e.CommandArgument.ToString());

string isreserved = "select isnull(reservationid,0) fromreservation where seatid='" + str + "'and MovieScheduleId=" + movieshid +"";


50/76

SqlCommand cmd = newSqlCommand(isreserved, con1);int a = Convert.ToInt16 (cmd.ExecuteScalar());

if (a


51/76

Web.Config


52/76

Design Of Forms

Admin.aspx Form1


53/76

CusShowtime.aspx Form2


54/76

Customers.aspx Form3


55/76

CustShowtheaters.aspx Form4


56/76

Homepage.aspx Form5


57/76

New Movies.aspx Form6


58/76

NewShowTime.aspx Form7


59/76

Price List.aspx Form8


60/76

ScheduleEntry1.aspx Form9


61/76

Seat Category.aspx Form10


62/76

SeatReservation.aspx Form11


63/76

The Tables of DataBase

Admin Table


64/76

Customer Table


65/76

Movie Table


66/76

Movie Schedule Table


67/76

Price List Table


68/76

Reservation Table


69/76

Seat Catogery Table


70/76

Seat Position Table


71/76


72/76

Theater Table


73/76

Goals

The goal of this project is to save the time and money of the person

As the project is prepared in ASP.NET so it is easy for any person to

is prepare for online Seat Reservation of Movie can give better

opportunity to booking seat from anywhere.so the process will

become very fast.the result also can be declare on same day.

1. The System can be used by peoples who arehandicapped, can use keyboard.

2. The system should be capable of mapping speechcommands to Key events.

3. The system should be scalable so that newcommands can be incorporated easily to the system.

4. The speech commands and their mapping shouldstored in XML format.


74/76

Benefits

1.Booking process can be perform online.2.Time and money can be save.3.The process of Booking process become very fast.4.The person can give his reservation from anywhere from the

world.


75/76

Limitation

1. the crystalreport has not been used in this project.2.Customer can not take reservation more than one to the same

day.

3.It relies only to the functionalities provided online.4.Recognizes only the customer who is live in world.


76/76

References

1. ASP.Net How To Program - By Dietel & Dietel

2. ASP.Net PROFESSIONAL. - By Wrox

3. Reservation SDK - Microsoft Site

4. ASP.NET Processing Tutorial - Internet

project with documentaion

Documents