project on multiplex ticket bookingn system globsyn2014
DESCRIPTION
TRANSCRIPT
Globsyn Skills, Globsyn Crystals, 1st Floor, XI - 11 and 12, Block EP, Sector V, Salt Lake, Kolkata - 700091
(Using ASP.Net)
Group Members:
MD IMRAN, ASANSOL ENGINEERING COLLEGE, 121080110051 PRIYANKA MONDAL, ASANSOL ENGINEERING COLLEGE, 121080110066
PRIYANKA SINGH, ASANSOL ENGINEERING COLLEGE, 121080110068 RINA SHARMA, ASANSOL ENGINEERING COLLEGE, 121080110078
www.globsynskills.com 2
Table of Contents
Acknowledgement
Project Objective
Software Development Life Cycle
Requirement and Feasibility Analysis
System Requirement
Data Flow Diagram
Tables Used In Database
Snapshots
Codes
Reference
Certificate
www.globsynskills.com 3
Acknowledgement
We take this opportunity to express our profound sense of gratitude and respect to all those who helped us throughout the duration of this project.
W e exp ress ou r s i nce re g ra t i t ude and
thankfulness towards Mr. RUPESH KUMAR SAW, our
training teacher provided by Globsyn, for his valuable time
and guidance throughout the development of the project.
It would not be possible to complete the project
without the support of my friends, teachers and group members. Md. Imran Priyanka Mondal Priyanka Singh Rina Sharma
4 www.globsynskills.com
Project Objective
The primary objective of the design is to deliver the requirements as specified in the
Feasibility report. These are the some of the objectives, which I kept in mind.
Practicality: The system is quite stable and can be operated by the people
With average intelligence.
Efficiency: I tried to involve accuracy, timeliness and comprehensiveness of
The system output.
Cost: It is desirable to aim for the system with a minimum cost subject to the
Condition that it must satisfy the entire requirement.
Flexibility: I have tried that the system should be modifiable depending on
The changing needs of the user. Such modifications should entail extensive
Reconstructing or recreation of software. It should also be portable to
Different computer systems.
Security: This is very important aspect which I followed in this designing
Phase and tried to covers the areas of hardware reliability, fallback
Procedures, and physical security of data. www.globsynskills.com 5
SOFTWARE DEVELOPMENT LIFE CYCLE
FEASIBILILTY ANALYSIS
Feasibility study is done so that an ill-conceived system is recognized early in definition phase.
During system engineering, however, we concentrate our attention on four primary areas of
interest. This phase is really important as before starting with the real work of building the
System it was very important to find out whether the idea thought is possible or not.
Economic Feasibility: An evaluation of development cost weighted against the ultimate
Income or benefit derived from the developed system.
Technical Feasibility: A study of function, performance and constraints that may affect the
Ability to achieve an acceptable system.
Operational Feasibility: A study about the operational aspects of the system.
ECONOMIC ANALYSIS
Among the most important information contained in feasibility study is Cost Benefit Analysis and
Assessment of the economic justification for a computer based system project. Cost Benefit
Analysis delineates costs for the project development and weighs them against tangible and
Intangible benefits of a system. Cost Benefits Analysis is complicated by the criteria that vary
with the characteristics of the system to be developed, the relative size of the project and the
expected return on investment desired as part of company's strategic plan. In addition, many
benefits derived from a computer-based system are intangible (e.g. better design quality
Through iterative optimization, increased customer satisfaction through programmable control
etc.)As this is an in-house project for the company, to be used for its own convenience and also it is
not that big a project. So neither it requires a huge amount of money nor any costly tools or
Infrastructure need to be set up for it.
www.globsynskills.com
REQUIRMENT AND
FEASIBILITY ANALYSIS
INTRODUCTION:
What Is A Feasibility Study?
Prior to stating whether the system we have to develop is feasible or not we believe that we should
emphasize on what is implied by the word "Feasibility". Feasibility is the measure of how beneficial or
practical the development of the system will be to the organization. It is a preliminary survey for the
systems investigation. It aims to provide information to facilitate a later in-depth investigation.
The report produced at the end of the feasibility study contains suggestions and reasoned arguments to help management decide whether to commit further resources to the proposed project.
For e.g. - Is the system within the budget allowed for it?
Will the organization’s needs, be met by the new proposed system as originally envisaged?
If and when the objectives of the system are met and the new system is approved, then the more Specific details in the proposal should be considered and approved.
TYPES OF FEASIBILITY
There are various measures of feasibility that helps to decide whether a particular project is feasible or not. These measures include-
Operational Feasibility
Technical Feasibility
Economical and Financial Feasibility
Each of these types will be explained in detail throughout the project report.
Operational Feasibility
A proposed system is beneficial only if it can be turned into an information system that will meet the
Operational requirements of an organization. A system often fails if it does not fit within existing
Operations and if users resist the change.
Important issues a systems developer must look into are:
Will the new system be used if implemented in an organization?
Are there major barriers to implementation or is proposed system accepted
without destructive resistance?
The new system is more user-friendly, which enables the end-user to complete his/her work
efficiently and accurately with interest. After taking the above fact into consideration we can state the
operating of the proposed system within the organization is feasible.
In this phase of the feasibility study the following two main topics
Technical Performance Aspect
Acceptance within the organization
Technical performance aspect is explained in the technical feasibility report and there is no new
Information is needed in this to explain it again, but as for the acceptance within the organization the
following points are important and those are explained according to the topics
1. Whether the system provides right information to
the right place
In the current system which is the semi computerized system the information may be lost in the Process of sending from one place to another. This is mainly due to human interaction in the process Of the transferring information from one place to another.
2. Whether the new system affect the current users in the system
System Security System security is a vital aspect when it comes to developing a system. The system should
Ensure the facility of preventing unauthorized personnel from accessing the information and
The data within the system. The system should provide total protection for each user's information
so that the integrity of data is sustained and also prevent hackers from hacking
The system.
The proposed system ensures the security and the integrity of data. This is done by providing a
Password login system for each authorized users. And for example the System Administrator has
Access to all kinds of information.
Economical and Financial Feasibility In making recommendations a study of the economics of the proposed system should be
Made. The proposed system must be justifiable in terms of cost and benefit, to ensure that
The investment in a new/changed system
provide a reasonable return.
According to the computerized system we propose, the costs can be broken down to two categories.
1. Costs associated with the development of the system.
2. Costs associated with operating the system.
Software Requirement Specification
The software requirement specification is produced at the culmination of the analysis task. The
function and performance allocated to software as part of system engineering are refined
by establishing a complete information description, a detailed functional description, a
representation of system behavior, an indication of performance requirement and design
Constraints appropriate validation criteria, and other information pertinent to requirement. The
introduction to software requirements specification states the goals and objectives of the
software, describing it in the context of the computer based system. The Information
Description provides detailed description of the problem that the Software must solve.
Information content, flow and structure are documented. A description of each function required
to solve the problem is presented in the Functional Description.
A statement of the requirements for the implementation: Specifications are also used as a reference point during product implementation. In fact, the
Ultimate goal of the implementation is to build a product that needs specification. Thus the
implementers use specifications during design to make design decisions and during the
Verification activity to check that the implementation compiles with specifications.
DATABASE DESIGN:
The overall objective in the development of the database technology has been to treat data as
an organizational resource and as an integrated whole. Database management system allows
data to be protected and organize separately from other resources. Database is an integrated
collection of data. The most significant of data as seen by the programs and data as stored on
the direct storage access storage devices. This is the difference between logical and physical
data. The organization of data in the database aims to achieve free major Objectives:
Data Integration
Data Integrity
Data Independence The databases are implemented using a DBMS package. Each particular DBMS has
Unique characteristics and general techniques for Database Design.
The proposed Management Information System stores the information relevant for
Processing in the Microsoft SQL Server Database. This MS SQL Server contains tables, where
each table is called a field or column. A table also contains records which is a set of fields. All
Records, in a table the same set of fields with different information. Each table contains key
fields that establish relationships in a MS SQL server database and how the records are
Stored. There are primary key fields that uniquely identify a record in a table. There are also
Fields that contain the primary key from another table called foreign keys. It is a known fact that
the program cannot be written until the data are defined, so the database must be defined.
The starting point for this process is data dictionary. The records Data structures and elements to
be stored in each database are identified and extracted.
SYSTEM REQUIREMENTS
The basic system requirements for running this project are listed below:
Microsoft Windows 2000 professional, Microsoft Windows XP Home editions,
Microsoft Windows XP Professional edition and above
Sql Server 2008
Microsoft .net Framework 3.5
Pentium or equivalent microprocessor (400 MHz or faster)
At least 256 MB of RAM
At least 10MB of free hard disk space
DATA FLOW DIAGRAM
Data flows are data structures in motion, while data stores are data structures. Data flows
are paths or ‘pipe lines’, along which data structures travel, whereas the data stores are
place where data structures are kept until needed.
Data flows are data structures in motion, while data stores are data structures at
rest. Hence it is possible that the data flow and the data store would be made up of the
same data structure.
Data flow diagrams is a very handy tool for the system analyst because it gives the
analyst the overall picture of the system, it is a diagrammatic approach.
A DFD is a pictorial representation of the path which data takes from its initial
interaction with the existing system until it completes any interaction. The diagram will
describe the logical data flows dealing the movements of any physical items. The DFD also
gives the insight into the data that is used in the system i.e., who actually uses it is
temporarily stored.
A DFD does not show a sequence of steps. A DFD only shows what the
different process in a system is and what data flows between them.
The following are some DFD symbols used in the project
External entities
DATAFLOWS
Process: A transaction of information that resides within
the bounds of the system to be module.
DATASTORE:A repository of data that is to be
stored for use by one or more processes, may
be as simple as buffer of queue or as a
relational database.
RULES FOR DFD:
Fix the scope of the system by means of context diagrams.
Organize the DFD so that the main sequence of the actions
reads left to right and top to bottom.
Identify all inputs and outputs.
Identify and label each process internal to the system with
rounded circles.
A process is required for all the data transformation and
transfers. Therefore, never connect a data store to a data source
or the destinations or another data store with just a data flow
arrow.
Do not indicate hardware and ignore control information.
Make sure the names of the processes accurately convey
everything the process is done.
There must not be unnamed process.
Indicate external sources and destinations of the data, with
squares.
Number each occurrence of repeated external entities.
Identify all data flows for each process step, except simple
Record retrievals.
Label data flow on each arrow.
Use details flow on each arrow.
Use the details flow arrow to indicate data movements.
There can’t be unnamed data flow.
A data flow can’t connect two external entities.
LEVELS OF DFD:
The complexity of the business system means that it is a responsible to represent
the operations of any system of single data flow diagram. At the top level, an
Overview of the different systems in an organization is shown by the way of context
analysis diagram. When exploded into DFD
They are represented by:
LEVEL-0 : SYSTEM INPUT/OUTPUT
LEVEL-1:SUBSYSTEM LEVEL DATAFLOW FUNCTIONAL
LEVEL-2: FILE LEVEL DETAIL DATA FLOW.
The input and output data shown should be consistent from one level to the next.
LEVEL-0: SYSTEM INPUT/OUTPUT LEVEL
A level-0 DFD describes the system-wide boundaries, dealing inputs to and
outputs from the system and major processes. This diagram is similar to the
combined user-level context diagram.
LEVEL-1: SUBSYSTEM LEVEL DATA FLOW
A level-1 DFD describes the next level of details within the system, detailing
the data flows between subsystems, which make up the whole.
LEVEL-2: FILE LEVEL DETAIL DATA FLOW
All the projects are feasible given unlimited resources and infinite time. It is
both necessary and prudent to evaluate the feasibility of the project at the earliest
possible time. Feasibility and the risk analysis are pertained in many ways. If
project risk is great.
FIRST LEVEL DTAFLOW DIAGRAM
Reports on the user Information
Reports on movie Information
7
Reports user Profile and
Available Seats
Administrator Information
Movie
World
Management
Use Information
Module
DFD for User Account
User Master
Insert User Account Verify Data
2.1
Verify Data
2.2
Verify Data
User Master
Page
Check for the User Profile
Insert
User Master
Check for the User
Account Details
DFD for Booking
Home Master
Insert user Verify Data
2.1
Verify Data
2.2
Verify Data
2.3
Home Master
Search for the
Available seats
Insert
Admin Master
Check for the
Admin Address
CODE FOR ADMIN LOGIN using System; using System.Collections.Generic;
using System.Linq; using System.Web;
using System.Web.UI; using System.Web.UI.WebControls;
using System.Data;
public partial class Admin_LogIn : System.Web.UI.Page {
DBHandler dalObject = new DBHandler();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnALogin_Click(object sender, EventArgs e)
{
bool check = ValidateUser();
if (check == true)
{
//Redirect to User Home Page
Response.Redirect("AdminHome.aspx");
}
else
{
//Error Message
}
}
public bool ValidateUser()
{
string Select = "Select EmailID,Password from adminregistration where EmailID='"
+ txtAEmail.Text + "' and Password='" + txtAPassword.Text + "'";
DataSet dsValidate = dalObject.FillAndReturnDataSet(Select);
if (dsValidate.Tables[0].Rows.Count == 0)
{
return false;
}
else
{
//How to Add values to session Variable..
Session["User"] = dsValidate.Tables[0].Rows[0].ItemArray[0].ToString();
Session["EntireDataSet"] = dsValidate;
Session.Add("Email", dsValidate.Tables[0].Rows[0].ItemArray[1].ToString());
return true;
}
} }
CODE OF
ADMIN
EDIT
MOVIE 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; public partial class admin_Default : System.Web.UI.Page { protected void Button1_Click1(object sender, EventArgs e) { string imagedata = string.Empty; if (FileUpload1.HasFile) { FileUpload1.SaveAs(Server.MapPath("~/images/" + FileUpload1.FileName)); imagedata = "~/images/" + FileUpload1.FileName; } SqlConnection con = new SqlConnection(); con.ConnectionString = @"Data Source=.\sqlexpress;Initial Catalog=master;Integrated Security=True"; con.Open(); //SqlCommand cmd1 = new SqlCommand(); //cmd1.Parameters.AddWithValue("@movieimage", imagedata); // cmd1.CommandText = "insert into tblmovie(movieimage) values(@movieimage)"; //cmd1.Connection = con; SqlCommand cmd = new SqlCommand("INSERT INTO tblmovie (moviename,director,movieactres,movierating,movieimage) VALUES('" + txtmname.Text + "','" + txtmdir.Text + "','" + txtactres.Text + "','" + txtmrating.Text + "','"+ imagedata +"')", con);
cmd.Parameters.AddWithValue("@moviename", txtmname.Text); cmd.Parameters.AddWithValue("@director", txtmdir.Text); cmd.Parameters.AddWithValue("@movieactres", txtactres.Text); cmd.Parameters.AddWithValue("@movierating", txtmrating.Text); cmd.Parameters.AddWithValue("@movieimage", imagedata); // cmd.CommandText = "insert into tblmovie(moviename) values('"+txtmname+"')"; int count=cmd.ExecuteNonQuery(); if (count> 0) { Response.Write("<script>alert('record inserted')</script>"); // FileUpload1.SaveAs(Server.MapPath("~/Admin/images//" + txtmname.Text + ".jpg")); } con.Close(); } protected void Button2_Click(object sender, EventArgs e) { txtmname.Text = ""; txtmdir.Text = ""; txtactres.Text = ""; txtmrating.Text = ""; txtmdir.Focus(); txtactres.Focus(); txtmrating.Focus(); txtmname.Focus(); } protected void txtmname_TextChanged(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); con.ConnectionString = @"Data Source=.\sqlexpress;Initial Catalog=master;Integrated Security=True"; con.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from tblmovie where moviename='" + txtmname.Text + "'", con); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { Response.Write("<script>alert('this movie already Exist')</script>"); txtmname.Text = ""; }
con.Close(); } }
CODE OF USER
EDIT THEATRE
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; public partial class admin_Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button2_Click(object sender, EventArgs e) { txttname.Text = ""; txttaddress.Text = ""; txttcost.Text = ""; txttmanager.Text = ""; txttsize.Text = ""; txttaddress.Focus(); txttcost.Focus(); txttmanager.Focus(); txttsize.Focus(); txttname.Focus(); }
protected void Button3_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); con.ConnectionString = @"Data Source=.\sqlexpress;Initial Catalog=master;Integrated Security=True"; con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO tbltheatre (tname, taddress, tmanager,tsize,ttcost) VALUES('" + txttname.Text + "','" + txttaddress.Text + "','" + txttmanager.Text + "'," + txttsize.Text + "," +txttcost.Text + ")", con); //SqlCommand cmd = new SqlCommand("INSERT INTO TABLE1 (tname, taddress, tmanager,tsize,ttcost) VALUES ('" + nametbox.Text + "," + addtbox.Text + "," + mailtbox.Text + "," + phonetbox.Text + "," + dobtbox.Text + "')"); cmd.Parameters.AddWithValue("@tname", txttname.Text); cmd.Parameters.AddWithValue("@taddress",txttaddress.Text); cmd.Parameters.AddWithValue("@tmanager", txttmanager.Text); cmd.Parameters.AddWithValue("@tsize", txttsize.Text); cmd.Parameters.AddWithValue("@ttcost", txttcost.Text); if (cmd.ExecuteNonQuery() > 0) { Response.Write("<script>alert('record inserted')</script>"); } else Response.Write("<script>alert('Error')</script>"); con.Close(); } }
CODE OF ASSIGN MOVIE 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; public partial class admin_Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Getdata(); } } private void Getdata() { SqlConnection con = new SqlConnection(); con.ConnectionString = @"Data Source=.\sqlexpress;Initial Catalog=master;Integrated Security=True"; //throw new Exception("The method or operation is not implemented."); con.Open(); SqlDataAdapter da = new SqlDataAdapter("select moviename from tblmovie ", con); DataSet ds1 = new DataSet(); da.Fill(ds1); mname.DataSource = ds1; mname.DataTextField = "moviename"; mname.DataValueField = "moviename"; mname.DataBind(); SqlDataAdapter da2 = new SqlDataAdapter("select tname from tbltheatre ", con); DataSet ds = new DataSet(); da2.Fill(ds); tname.DataSource = ds; tname.DataTextField = "tname"; tname.DataValueField = "tname"; tname.DataBind(); con.Close(); } protected void Button4_Click(object sender, EventArgs e) { } protected void Button3_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); con.ConnectionString = @"Data Source=.\sqlexpress;Initial Catalog=master;Integrated Security=True"; con.Open();
SqlDataAdapter da = new SqlDataAdapter("select moviename,theatrename from tbassignmovie", con); DataSet ds2 = new DataSet(); da.Fill(ds2); int cnt = 0; for (int i = ds2.Tables[0].Rows.Count - 1; i >= 0; i--) { if (ds2.Tables[0].Rows[i][0].ToString() == mname.SelectedItem.Text && ds2.Tables[0].Rows[i][1].ToString() == tname.SelectedItem.Text) { cnt++; } } if (cnt == 0) { SqlCommand cmd = new SqlCommand("insert into tbassignmovie(moviename,theatrename,dateavailable) values('" + mname.SelectedItem.Text + "','" + tname.Text + "','" + TextBox1.Text + "')", con); cmd.Parameters.AddWithValue("@moviename", mname.SelectedItem.Text); cmd.Parameters.AddWithValue("@taddress", tname.Text); cmd.Parameters.AddWithValue("@tmanager", TextBox1.Text); if (cmd.ExecuteNonQuery() > 0) Response.Write("<script>alert('Inserted')</script>"); else Response.Write("<script>alert('Error')</script>"); } else Response.Write("<script>alert('Already Exist')</script>"); con.Close(); } }
CODE OF USER BOOKING
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; public partial class _Default : System.Web.UI.Page { int tsize; int s; protected void Page_Load(object sender, EventArgs e) { //Response.Write(Request.Cookies["tname"].Value); SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=.\sqlexpress;Initial Catalog=master;Integrated Security=True"; // con.Open(); SqlDataAdapter cmd6 =new SqlDataAdapter("select tsize,ttcost from tbltheatre where tname='" + Request.Cookies["tname"].Value + "'", con); DataSet ds2 = new DataSet(); cmd6.Fill(ds2); tsize = Convert.ToInt16(ds2.Tables[0].Rows[0]["tsize"].ToString()); Label1.Text ="Ticket Cost RS "+ ds2.Tables[0].Rows[0]["ttcost"].ToString()+"/"; s = tsize / 5; int i, j,k,l,m,n,o,p,q,r; for ( i = 1; i <= s; i++) { CheckBox ch = new CheckBox(); ch.ID = i.ToString(); ch.Text = i.ToString(); PlaceHolder1.Controls.Add(ch); } for ( j = i; j <= s+s; j++) { CheckBox ch1 = new CheckBox(); ch1.ID = j.ToString(); ch1.Text = j.ToString(); PlaceHolder2.Controls.Add(ch1); } for (k = j; k <= s+s+s; k++) { CheckBox ch2 = new CheckBox(); ch2.ID = k.ToString(); ch2.Text = k.ToString(); PlaceHolder3.Controls.Add(ch2); } for (l = k; l <= s+s+s+s; l++) { CheckBox ch3 = new CheckBox(); ch3.ID = l.ToString(); ch3.Text = l.ToString(); PlaceHolder4.Controls.Add(ch3); } for (m = l; m <= s + s + s+s+s; m++) { CheckBox ch4 = new CheckBox(); ch4.ID = m.ToString(); ch4.Text = m.ToString(); PlaceHolder5.Controls.Add(ch4); } string u=""; SqlDataAdapter da = new SqlDataAdapter("select seatno from tblbooking where tname='" + Request.Cookies["tname"].Value + "' and mname='" + Request.QueryString["mname"].ToString() + "' and showdate='" + Request.Cookies["bdate"].Value + "' and showtime='" + Request.Cookies["stime"].Value + "'", con); DataSet ds = new DataSet(); da.Fill(ds);
int rcount=ds.Tables[0].Rows.Count; if (rcount > 0) { rcount = rcount - 1; while (rcount >= 0) { u = ds.Tables[0].Rows[rcount][0].ToString(); //string u = "32,55,1,4,8"; string[] a = u.Split(new char[] { ',' }); int b, c, d, f, z, y; for (y = 0; y <= a.Length - 1; y++) { for (z = 1; z <= s; z++) { CheckBox lc = (CheckBox)PlaceHolder1.FindControl(z.ToString()); if (lc.Text == a[y]) { lc.Enabled = false; } } for (b = z; b <= s + s; b++) { CheckBox lc1 = (CheckBox)PlaceHolder2.FindControl(b.ToString()); if (lc1.Text == a[y]) { lc1.Enabled = false; } } for (c = b; c <= s + s + s; c++) { CheckBox lc2 = (CheckBox)PlaceHolder3.FindControl(c.ToString()); if (lc2.Text == a[y]) { lc2.Enabled = false; } } for (d = c; d <= s + s + s + s; d++) { CheckBox lc3 = (CheckBox)PlaceHolder4.FindControl(d.ToString()); if (lc3.Text == a[y]) { lc3.Enabled = false; } } for (f = d; f <= s + s + s + s + s; f++) { CheckBox lc4 = (CheckBox)PlaceHolder5.FindControl(f.ToString()); if (lc4.Text == a[y]) { lc4.Enabled = false;
} } } rcount = rcount - 1; } } // con.Close(); } protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); con.ConnectionString = @"Data Source=.\sqlexpress;Initial Catalog=master;Integrated Security=True"; con.Open(); SqlDataAdapter cmd5 = new SqlDataAdapter("select tsize,ttcost from tbltheatre where tname='" + Request.Cookies["tname"].Value + "'", con); DataSet ds1 = new DataSet(); cmd5.Fill(ds1); tsize = Convert.ToInt16(ds1.Tables[0].Rows[0]["tsize"].ToString()); int tcost = Convert.ToInt16(ds1.Tables[0].Rows[0]["ttcost"].ToString()); s = tsize / 5; int ss = 0; string sno=""; //int s = 100 / 5; int b, c, d, f, z, y; for (z = 1; z <= s; z++) { CheckBox lc = (CheckBox)PlaceHolder1.FindControl(z.ToString()); if (lc.Checked==true) { ss++; if (ss <= 9) sno = lc.Text + "," + sno; } if (ss > 3) { lc.Checked = false; } } for (b = z; b <= s + s; b++) { CheckBox lc1 = (CheckBox)PlaceHolder2.FindControl(b.ToString()); if (lc1.Checked==true) { ss++; if (ss <= 3) sno = sno + "," + lc1.Text; } if (ss > 3) { lc1.Checked = false; } } for (c = b; c <= s + s + s; c++)
{ CheckBox lc2 = (CheckBox)PlaceHolder3.FindControl(c.ToString()); if (lc2.Checked==true) { ss++; if (ss <= 3) sno = sno + "," + lc2.Text; } if (ss > 3) { lc2.Checked = false; } } for (d = c; d <= s + s + s + s; d++) { CheckBox lc3 = (CheckBox)PlaceHolder4.FindControl(d.ToString()); if (lc3.Checked==true) { ss++; if (ss <= 3) sno = sno + "," + lc3.Text; } if (ss > 3) { lc3.Checked = false; } } for (f = d; f <= s + s + s + s + s; f++) { CheckBox lc4 = (CheckBox)PlaceHolder5.FindControl(f.ToString()); if (lc4.Checked==true) { ss++; if (ss <= 3) sno = sno + "," + lc4.Text; } if (ss > 3) { lc4.Checked = false; } } if (ss > 5 || ss==0) { Response.Write("<script>alert(' select lessthan 4')</script>"); } if(ss<=5 && ss>0) { int tcst = ss * Convert.ToInt16(ds1.Tables[0].Rows[0]["ttcost"].ToString()); SqlCommand cmd = new SqlCommand("insert into tblbooking values('" + LoginName1.ToString()+ "','" + Request.Cookies["tname"].Value + "','" + Request.QueryString["mname"].ToString() + "','" + Request.Cookies["bdate"].Value + "','" + Request.Cookies["stime"].Value + "'," + ss + ",'" + sno +"',"+tcst+ ")", con); if (cmd.ExecuteNonQuery() > 0) { Response.Write("<script>alert('Booking Successfull ')</script>");
SqlDataAdapter da4 = new SqlDataAdapter("select * from tblbooking where bookid =(select max(bookid) from tblbooking)", con); DataSet ds4 = new DataSet(); da4.Fill(ds4); DetailsView1.DataSource = ds4.Tables[0].DefaultView; DetailsView1.DataBind(); Response.Write("<script>alert('please note down uname & bookid for further use....')</script>"); } else Response.Write("<script>alert('Error')</script>"); } con.Close(); } }
CONCLUSION OF THE PROJECT The project has been developed successfully and the performance of the system has been found satisfactory. The security has been incorporated as required by any placement firm. Use of computer helps the user in reducing the time wasted in non-productive work. It further helps the user in having immediate access to the information as well as to share the limited resources effectively. User friendly menu driven interface has been provided to the user to interact with the system. Users can traverse through the website provided the users have the access right set. The users can register themselves through a registration form and then can use the services of the website.
LIMITATIONS OF THE PROJECT
The following are the limitations of the project:
No Multi-User Support Is Provider At a time only one user can use the software. In same companies, the computers are interconnected to form a network. But this software will work on only one computer at a time.
Login Password Is Not Encrypted The username and password provided to us is not encrypted properly. Any person that gets to know the username and password of a user can access his account. So keep your password safe.
No Backup And Restore Utilities Are Incorporated In these times of uncertainties, incorporation of the facilities of backup and restoration of last details is necessary. Any computer can crash or become affected by a virus at any time. So it is imperative to take the backup of the data, but this software does not provide this utility.
www.globsynskills.com 8
REFERENCES
1. www.google.com 2. www.howstuffworks.com 3. www.wikiepedia.org
4. www.microsoft.com
5. ASP.NET (BIBLE)-MRUDULA PARIHAR
6. Beginning SQL Server 2000 by -Thereon Willis wrox publications
Certificate
This is to certify that Md.Imran of Asansol Engineering College, registration number: 121080110051 , has successfully completed a project on MULTIPLEX TICKET BOOKING SYSTEM by ASP.net using C# under the guidance of Mr. Rupesh Kumar Saw.
…………………………………
Rupesh Kumar Saw
Globsyn Finishing School
www.globsynskills.com 10
Certificate
This is to certify that Ms. Priyanka Mondal of Asansol Engineering College, registration number: 121080110066 , has successfully completed a project on MULTIPLEX TICKET BOOKING SYSTEM by ASP.net using C# under the guidance of Mr. Rupesh Kumar Saw. ………………………………… Rupesh Kumar Saw Globsyn Finishing School
www.globsynskills.com 11
Certificate This is to certify that Ms.Priyanka Singh of Asansol Engineering College, registration number: 121080110068 , has successfully completed a project on MULTIPLEX TICKET BOOKING SYSTEM by ASP.net using C# under the guidance of Mr. Rupesh Kumar Saw. ………………………………… Rupesh Kumar Saw Globsyn Finishing School
www.globsynskills.com 12
Certificate
This is to certify that Ms.Rina Sharma of Asansol Engineering College, registration number: 121080110078, has successfully completed a project on Multiplex Ticket Booking System by ASP.net using C# under the guidance of Mr. Ruesh Kumar Saw.
--- ---------------------------------------------------
-
Rupesh Kumar Saw
Globsyn Finishing School
www.globsynskills.com 13