1

1. INTRODUCTION

1.1 ABSTRACT:
Travel Agency plans to become a market leader by our augmenting its human travel agents
with an automated travel agency system for providing tour packages. The automated travel agent
will assist travelers in booking, changing and canceling tour packages, hotel reservation.
The automated travel agent system will process a wide range of tour packages with hotel
reservation. Travel agency provides total security for the user, it also provides fast services to the
users. Depending upon user’s criteria different offer is applied.
Any user can visit our website & requests to book tour packages, hotels. User can inquire about
different city packages, availability of different hotels including 5*, 3*, 2* category. After that
user can select a payment method & specifies delivery services for the tickets & travel itineraries.

Overview of Present working System

Whenever a user visit our website, if user wants to know about our
website then he can select the link about us. If the user wants to know about the different tour
packages then user will select source and destination city. After selecting the source and
destination city the details of tour packages will be displayed. If the user is interested to book a
tour package then user will login for a registration. For registration purpose if the user is new then
sign up for new account. After that for payment purpose user has to enter credit card number &
CVV number. Then it will show the successful registration, user has to note down the registration
ID. After that detail receipt will be displayed.
For hotel booking user has to select hotel link then user has to select city. Then list of
5*, 3*, 2* and other hotels will be displayed, user has to select one of them. Then the detail of
hotels will be displayed. Then user can enter number of days he wants to stay. The administrator
can login for updating the database.
 2

1.2 Introduction to project:

We apply technology with innovation and responsibility to achieve two broad objectives:
 Effectively address the business issues our customers face today.
 Generate new opportunities that will help them stay ahead in the future.
This approach rests on:
 A strategy where we architect, integrate and manage technology services and solutions -
we call it AIM for success.
 A robust offshore development methodology and reduced demand on customer resources.
 A focus on the use of reusable frameworks to provide cost and times benefits.
They combine the best people, processes and technology to achieve excellent results -
consistency. We offer customers the advantages of:
 Speed:
They understand the importance of timing, of getting there before the
competition. A rich portfolio of reusable, modular frameworks helps jump-start projects.
Tried and tested methodology ensures that we follow a predictable, low - risk path to achieve
results. Our track record is testimony to complex projects delivered within and evens before
schedule.

 Expertise:
Our teams combine cutting edge technology skills with rich domain expertise.
What’s equally important- they share a strong customer orientation that means they actually
start by listening to the customer. They’re focused on coming up with solutions that serve
customer requirements today and anticipate future needs.
 3

2. REQUIREMENTS AND SPECIFICATION

2.1 Hardware Requirements:

Processor : Core 2 duo or any another

Ram : 128MB or more

Cache : 512 KB
Hard disk : 16 GB hard disk recommended for primary portions.

2.2 Software Requirements:

Operating system : All editions: Window2000 or later or windows
Front End Software: Visual Studio 2008 standard edition

Back End Software : Microsoft SQL Server 2005

2.3 ABOUT ASP.NET 2.0

2.3.1 An introduction to ASP.NET application Development

For years, the Active Server Pages (ASP) technology was arguably the leading
choice for web developers building dynamic web sites on Windows web servers, as it offered
flexible yet powerful scripting capabilities. Early in 2002, Microsoft released a new technology
for Internet development called ASP.NET. ASP.NET represents a leap forward from ASP both in
its sophistication and the productivity gains it achieves for developers. It continues to offer
flexibility in terms of language support, but rather than a range of simple scripting languages,
several fully-fledged programming languages are now at the fingertips of ASP.NET developers.
Development in ASP.NET requires not only an understanding of HTML and web design, but also
 4

a firm grasp of the concepts of object oriented programming and development. ASP.NET is a
server-side technology for developing web applications based on the Microsoft .NET Framework.

2.3.2 The components of the .NET Framework:

ASP.NET uses the Microsoft .NET Framework. The .NET Framework collects all the
technologies needed for building Windows desktop applications, web applications, web services,
and so on, into a single package, and makes them available to more than 40 programming
languages.

2.3.3 Description
The .NET Framework is the infrastructure for the Microsoft .NET platform. The .NET
Framework is an environment for building, deploying, and running Web applications and Web
Services. The .NET Framework contains a common language runtime and common class libraries
- like ADO.NET, ASP.NET and Windows Forms - to provide advanced standard services that can
be integrated into a variety of computer systems. The .NET Framework provides a feature-rich
application environment, simplified development and easy integration between a number of
different development languages. The .NET Framework is language neutral. Currently it supports
C++, C#, Visual Basic, and JScript (Microsoft's version of JavaScript).Microsoft's Visual
Studio.NET is a common development environment for the .NET Framework.

2.3.4 Three environments for developing ASP.NET applications

Three common ways to set up a development environment for coding and testing
ASP.NET applications.As you’ll see, each setup has its advantages and disadvantages. The
environment you choose will depend on your development needs and on the resources that are
available to you.
The simplest development environment is a standalone environment. In this case, a single
computer serves as both the client and the server. Because of that, it must run an operating system
that supports ASP.NET development, and it must have the .NET Framework and Visual Studio
 5

2005 installed. Because Visual Studio 2005 comes with its own development server for local
testing, you don’t have to install IIS when you use a standalone environment. Also, since Visual
Studio comes with SQL Server 2005 Express Edition (or just SQL Server Express), you don’t
have to install a separate database product.
The second development environment works with separate client and server computers that are
connected via a local area network. Here, the client computer has Windows, the .NET
Framework, and Visual Studio 2005 installed, while the server runs Windows 2000 Server with
the .NET Framework, IIS, and FrontPage Server Extensions (FPSE). FPSE provides the services
that Visual Studio 2005 uses to communicate with a web site on a remote computer. In addition,
the server uses SQL Server to handle database access. With this environment, more than one
programmer can work on the same application, but all of the programmers are located at the same
site. With the third development environment, the client computers are connected to the server via
the Internet rather than a LAN. This makes it possible to work with a web site that’s hosted on
another server. This environment requires an FTP server, which is used to copy the files in a web
site between the client computer and the server.

2.3.5 FEATURES
1. Rapid – application development
2. Database features to create fast, high performance applications and components
3. Team development and scalability features with Microsoft visual Modeler, Visual
Database Tools, Visual Source safe and SQL server.
4. The ability to create reusable Active X components for traditional Client/server
Architecture, Internet, and Microsoft Transaction Server.
5. Native code compiles that can be optimized for speed, size and even for Pentium
preprocessor’s.

2.3.6 Objects/Controls available in Asp.net:

 Label control displays text a user cannot interact with or modify

 Text Box Control provides an area to enter and display text.

 Frames Control provides a visual and functional container for control.

 6

 Command Button Control out a command or action when a user chooses it.

 Combo Box Control combines a text box with a list box. Allows a user to type in a
selection or select from drop-down list.

2.3.7 Advantages of ASP.NET:

Asp.net is used to create web pages and web technologies and is the integral part of
the .NET framework. ASP stands for active server pages and is the successor of ASP. There are
so many advantages related to this technology that it has become the hot favorite for the
programmers who are engaged in web development. There are many advantages that I would like
to bring in front of you. They are as follows:

 Consistent programming model

You will definitely find that the coding can be done in any one of the
language either it is C sharp or VB.NET. You will definitely find it to be very useful as far
as CLR (Common language runtime) is concerned. With .NET the programming
technique looks similar either you are coding in C sharp or you are coding in VB.NET.
There is only a little bit of syntactical difference between the two programming language.
Hence you can say that the .net framework is very versatile as far as programming
languages are concerned. You can do the coding in any language among those provided.

 Less code
The ASP.NET provides us the pleasure to do the least coding and still come
out with the best results. You will really find the IDE environment more users friendly.
However you cannot decline that they are also machine friendly.

 More secure
You will really find it to be more secure since there is a built in authentication
and pre-application configuration. It uses industry standard protocols like TCP/IP, SOAP,
XML and HTTP for distributed applications communication.

 Rich toolkit
ASP.NET is equipped with the very good toolkit provide with visual studio
 7

software. You will definitely find drag and drop server control, automatic deployment to
be very handy when you will do the coding of your project. You will also find
WYSIWYG editor.

2.4 Microsoft SQL Server 2005:

Microsoft SQL server is a Relational Database Management System

(RDBMS) designed to run on platforms ranging from laptops to large multiprocessor servers.
SQL server is commonly used as backend systems for websites and corporate CRM’s and can
supports thousands of concurrent users. SQL server comes with a number of tools to help you
with your database administration and programming tasks. SQL server is much more robust and
scalable than a desktop database management system such as Microsoft access. Anyone who has
ever tried using access as a backend to a website will probably be familiar with the errors that
were generated when too many users tried to access the database! Although SQL server can also
be run as a desktop system, it is most commonly used as a server database system.

2.4.1 Server Database System:

Server based database system are designed to run on a central server, so that
multiple user can access the same data simultaneously. The user normally access the database
through an application .for example a website could store all its content in a database. As you
know, websites aren’t normally limited to just one user. So, at any given moment, a website could
be serving up hundreds or even thousands of articles to its website visitors. At the same time,
other user could be updating their personal profile in the member’s area, or subscribing to
newsletters or anything else that website users do. Generally, it’s the application that provides the
functionality to these visitors. It is the database that stores the data and makes it available. Having
said this, SQL server does include some useful features that can assist the application in providing
its functionality.

2.4.2 About SQL:

SQL stands for Structured Query Language. SQL is language that enables
you to work with a database. Using SQL, you can insert records, update records, and delete
records. You can also create new database objects such as databases and tables. And you can drop
(delete) them. More advanced features include creating stored procedure (self contained script),
 8

views (pre-made queries), and setting permission on database objects (such as tables, stored
procedures, and views).
Although SQL is an ANSI (American National standard institute) standard, there are many
different versions of SQL. Different database vendors have their own variations of the languages.
Having said this, to be in compliance with the ANSI standard, they need to at least support the
major commands such as DELETE, INSERT, UPDATE, WHERE, etc. also, you will find that
many vendors have their own extensions to the languages-features that are only supported in their
database system.

2.4.3 Using SQL:

If you need to build a websites with a database proving the content, you will generally
need the following:
 A server side scripting language (i.e. Cold Fusion, PHP, ASP/.NET )
 A database query language(i.e. SQL)
 A client side Markup language and style sheets(i.e. HTML/CSS)

2.4.5 Overview of concepts in SQL server 2005:

SQL server is a powerful application, and this tutorial has provided an overview of
the main concept involved in administering SQL server.
To recap briefly, we’ve:
 Create databases
 Create database tables
 Insert data into those tables
 Use of the query Analyzer to run a query
 Create a login account
 Create and execute a DTS package
 Execute that same DTS package via a schedule job

2.5 C#.NET V2.0:

2.5.1 Introduction to C#.net programming language:

C# is a Multi-paradigm programming language that encompasses functional,

 9

imperative, generic object-oriented (class-based), and components -oriented programming

disciplines. It was developed by Microsoft as part of the .NET initiative and later approved as a
standard by Ecma (ECMA-334) and ISO (ISO/IEC 23270). C# is one of the programming
languages designed for the Common Language Infrastructure.
C# intended to be a simple, modern, general purpose, object-oriented programming language. Its
development team is led by Anders-Hejlsberg, the designers of Borland’s Turbo Pascal. It has an
object -oriented syntax based on C++. It was initially named cool, which stood for "C-like object
oriented language ",.However, in July 2000,when Microsoft made the project public, the name of
the programming language was given as C#. The most recent version of the language is 3.0 which
was released in conjunction with .NET Framework 3.5 in 2007 .The next proposed version ,4.0 is
in development.

2.5.2 Design Goals:

The Ecma standard lists these design goals for C#:

 C# is intended to be a simple, modern, general -purpose, object-oriented programming
language.
 Because software robustness, durability and programmer productivity are important, the
language should include strong type checking, array bounds checking, and detection of
attempts to use uninitialized variables, source code portability, and automatic garbage
collection.
 The language intended for use in developing software components that can take
advantages of distributed environments.
 Programmer portability is very important, especially for those programmers already
familiar with C and C++.
 Support for internationalization is very important.
 C# is intended to be suitable for writing applications for both hosted and embedded
systems , ranging from the very large that use sophisticated operating systems, down to
the very small having dedicated functions.
 Although C# applications are intended to be economical with regard to memory and
processing power requirements, the language is not.
 Intended to compete directly on performance and size with C.
 10

2.5.3 Features:

By design, C# is the programming language that most directly reflects the

underlying Common Language Infrastructure (CLI).Most of its intrinsic types corresponds to
value -types implemented by the CLI framework. However, the language specification does not
state the code generation requirements of the compiler that is, it does not state that a C# compiler
must target a Common Language Runtime, or generate Common Intermediate Language (CIL), or
generate any other specific format. Theoretically, a C# compiler could generate machine code like
traditional compilers of C++ or FORTRAN. In practice, all existing compiler implementations
target CIL.
Some notable C# distinguishing features are:
 There are no global variables or functions .All methods and members must be declared
within classes. Static members of public classes can substitute for global variables and
functions.
 Local variables cannot shadow variables of the enclosing block, unlike C and C++.
Variable shadowing is often considered confusing by C++ texts.
 Managed memory cannot be explicitly freed; instead, it is automatically garbage
collected .Garbage collection addresses memory leaks by freeing the programmer of
responsibility for releasing memory which is no longer needed. C# also provides direct
support for deterministic finalization with the using statement (supporting the Resource
Acquisitionists initialization idiom).
 Multiple inheritances are not supported, although a class can implement any number of
interfaces. This was a design decision by the language's lead architect to avoid
complication, avoid dependency hell and simplify architectural requirements throughout
CLI.
 Enumeration members are placed in their own scope.
 C# provides properties as syntactic sugar for a common pattern in which a pair of methods,
accessor (getter) and mutator (setter) encapsulate operations on a single attribute of a
class.
 Full type reflection and discovery is available.
 11

 C# currently (as of 3 June 2008) has 77 reserved words.

3. DESIGN AND IMPLEMENTATION

3.1 System Design

The two design objectives continuously sought by developers are reliability and
maintenance.
3.1.1 Reliable System
There are two levels of reliability. The first is meeting the right requirements. A careful
and through systems study is needed to satisfy this aspect of reliability. The second level of
systems reliability involves the actual working delivered to the user. At this level, the systems
reliability is interwoven with software engineering and development. There are three approaches
to reliability.
1. Error avoidance: Prevents errors from occurring in software.
2. Error detection and correction: In this approach errors are recognized whenever they are
encountered and correcting the error by effect of error, of the system does not fail.
3. Error tolerance: In this approach errors are recognized whenever they occur, but enables the
system to keep running through degraded perform or by applying values that instruct the
system to continue process.

3.1.2 Maintenance:
The key to reducing need for maintenance, while working, if possible to do essential tasks.
1. More accurately defining user requirement during system development.
2. Assembling better systems documentation.
3. Using more effective methods for designing, processing, login and communicating
information with project team members.
4. Making better use of existing tools and techniques.
5. Managing system engineering process effectively.

.
 12

3.2 Database Design

 BILLING TABLE:

 HOTEL2 TABLE:

 CANCEL TABLE:

 CITY TABLE:

 HOTEL3 TABLE:
 DETAILTOURINFO TABLE:

 SOURCE TABLE:

 FAIRLIST TABLE:

 HOTEL5 TABLE:
 13

 NORTHTOURPACKAGES TABLE:

 ZONE TABLE:

 HOTELS TABLE:

3.3 PROGRAM FLOW DIAGRAM

 14

START

Tour Hotel Login About Us Contact Us

Display Display
B C D

STOP
 15

START

Select Zone

Select Source and

Destination

Display Tour Package

Information

Show Detail Tour

Information

If want to
register then
click on Add

Log in

If you r
new user

Sign Up

Enter your Acc No &

CVV No

Successful registration

Show receipt

STOP
 16

START

Select City

Select Hotel from

5*, 3* or 2*

Display Hotel details

Show fair

Administrator

START

Change in Change in Change in Change in

Billing Table Source Table City Table Detail tour
Info.

Change in North Change in Change in Fair

Tour Package Zone Table List Table

STOP
 17

3.4 Coding
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class StartUp : System.Web.UI.Page

{
protected void Page_Load(object sender, EventArgs e)
{
}
}
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class Tourpackage : System.Web.UI.Page

{
protected void Page_Load(object sender, EventArgs e)
{
}
}
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class Fairlist : System.Web.UI.Page
{
 18

int a;
protected void Page_Load(object sender, EventArgs e)
{
String sese = (String)Session["nameasdf"];
SqlConnection con;
SqlCommand cmd;
SqlDataReader dr;
con = new SqlConnection(@"Data Source=.\SQLEXPRESS; AttachDbFilename=|
DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
con.Open();
cmd = new SqlCommand("select * from FAIRLISTTABLE where
[NAMETOURPACKAGES]=@se", con);
cmd.Parameters.AddWithValue("se", sese);
dr = cmd.ExecuteReader();
while (dr.Read())
{
a = Convert.ToInt32(dr[5]);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Session["Username"]==null)
{
Response.Redirect("Login.aspx?num=" + a);
}
else
{
Response.Redirect("BillingForm.aspx?num=" + a);
}
}
}
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;
public partial class Login : System.Web.UI.Page
{
protected void Login3_LoggedIn(object sender, EventArgs e)
{
if (Roles.IsUserInRole(Login3.UserName,"admin"))
{
Session.Add("Username", Login3.UserName);
Login3.DestinationPageUrl = @"~\admin\adminwelcome.aspx";
}
else if (Roles.IsUserInRole(Login3.UserName, "user"))
{
Session.Add("Username", Login3.UserName);
Login3.DestinationPageUrl = @"~\StartUp.aspx";
}
else
 19

{
Response.Redirect("~/Login.aspx");
}
}
}
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class Signup : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e)
{
Roles.AddUserToRole(CreateUserWizard1.UserName, "user");
}
protected void CreateUserWizard1_ContinueButtonClick(object sender,
EventArgs e)
{
Response.Redirect(@"~\StartUP.aspx");
}
}
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class BillingForm : System.Web.UI.Page
{
int amount1;
int amount;
int Total;
int TotalfromHotel;
int TotalfromTour;
protected void Page_Load(object sender, EventArgs e)
{
TotalfromTour=Convert.ToInt32(Request["num"]);

TotalfromHotel = Convert.ToInt32(Request["aa"]);
 20

if (TotalfromHotel > 0)
{
Total = TotalfromHotel;
}
else
{
Total = TotalfromTour;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
String sese = (String) Session["nameasdf"];
SqlConnection con;
SqlCommand cmdBilling,cmdFairList,cmdInsert;
SqlDataReader dr,drFairList,drInsert;
con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
con.Open();
cmdBilling = new SqlCommand("select AMOUNT from BILLINGTABLE where
CARDNO=@CARDNO and CVVNO=@CVVNO", con);
cmdFairList = new SqlCommand("update BILLINGTABLE set AMOUNT =@AMOUNT
where CARDNO=@CARDNO ", con);
String CardNumber = TextBox1.Text.ToString();
String CvvNumber = TextBox2.Text.ToString();
Double PCardNumber= Convert.ToDouble(CardNumber);
Response.Write(PCardNumber);
cmdBilling.Parameters.AddWithValue("@CARDNO", CardNumber);
cmdBilling.Parameters.AddWithValue("@CVVNO", CvvNumber);
dr = cmdBilling.ExecuteReader();
while (dr.Read())
{
amount=Convert.ToInt32(dr[0]);
}
dr.Close();

if (amount >= Total)

{
amount1 = amount;
cmdInsert = new SqlCommand("insert into CANCELTABLE (CARDNO,
AMOUNT,TOTAL) values(@CARDNO,@AMOUNT,@TOTAL)", con);
cmdInsert.Parameters.AddWithValue("@CARDNO", PCardNumber);
cmdInsert.Parameters.AddWithValue("@AMOUNT", amount);
cmdInsert.Parameters.AddWithValue("@TOTAL", Total);
cmdInsert.ExecuteNonQuery();
Response.Redirect("Success.aspx?num="+PCardNumber);
}
else
{
Response.Redirect("Error.aspx");
}
}
}
using System;
using System.Collections;
using System.Configuration;
using System.Data;
 21

using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class ShowReceipt : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Label7.Visible = false;
Label8.Visible = false;
Label9.Visible = false;
Label10.Visible = false;
Label11.Visible = false;
Label12.Visible = false;
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;
AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User
Instance=True" );
String NAMETOURPACKAGES= Session["nameasdf"].ToString();
con.Open();
SqlDataReader dr;
SqlCommand cmd = new SqlCommand("select * from FAIRLISTTABLE where
[NAMETOURPACKAGES]=@NAMEOFTOURPACKAGES", con);
cmd.Parameters.Add("NAMEOFTOURPACKAGES", NAMETOURPACKAGES);
dr = cmd.ExecuteReader();
while (dr.Read())
{
Label7.Visible = true;
Label8.Visible = true;
Label9.Visible = true;
Label10.Visible = true;
Label11.Visible = true;
Label12.Visible = true;
Label7.Text = dr[0].ToString();
Label8.Text=dr[1].ToString();
Label9.Text = dr[2].ToString();
Label10.Text = dr[3].ToString();
Label11.Text = dr[4].ToString();
Label12.Text = dr[5].ToString();
}
}
}
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
 22

using System.Xml.Linq;
using System.Data.SqlClient;
public partial class Success : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Label1.Visible = false;
int Total = Convert.ToInt32(Request["num"]);
SqlConnection con;
SqlCommand cmd;
SqlDataReader dr;
con = new SqlConnection(@"DataSource=.\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
con.Open();
cmd = new SqlCommand("select REGISTRATIONID from CANCELTABLE where
CARDNO=@t", con);
cmd.Parameters.AddWithValue("t",Total);
dr = cmd.ExecuteReader();
while (dr.Read())
{
Label1.Visible = true;
Label1.Text = dr[0].ToString();
}
}
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class Hotelinfo : System.Web.UI.Page
{
protected void Button1_Click(object sender, EventArgs e)
{
String dd2 = DropDownList1.SelectedValue;
Session["Source"] = dd2;
Response.Redirect("Hotellink.aspx");
}
}
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
 23

public partial class Hoteldetails : System.Web.UI.Page

{
protected void Page_Load(object sender, EventArgs e)
{
Session["FiveStarName"] = Request["Name"];
Session["type"] = Request["type"];
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Session["Username"] == null)
{
Response.Redirect("Login.aspx");
}
else
{
Button1.PostBackUrl = "~/moreinfo.aspx";
}
}
}
 24

3.5 Output Screens

Start up:

Tour Form:
 25

North tour form:

Tour package info form

 26

Fair list form

Login Form
 27

Sign Up

Billing Form
 28

Registration Form

Receipt Form
 29

Hotel Booking Info Form

Hotel link form

 30

Hotel Detail Form

4. PERFORMANCE ANALYSES
 31

4.1 Requirements Speciation of the Proposed System

The very first question that should click in our mind before the
implementation of proposed system is that whether it should be feasible to develop a new
computerized system for the existing system. A requirement is a feature that must be included in
the system. Before the actual design and implementation starts, getting to know the system to be
implemented is of prime importance.

Taking these into mind we have emphasize on the following:

 The input to the system.

 The output expected from the system.
 The people involve in the working of the system.
 The volume of the data (input) and the amount of information (outputs) that will be
involved.

With respect to the system itself, the following facts should be taken into consideration:

 The major processes involved.

 The crux of the application.
 The processing rules for the collected data. This mainly involves the business rules etc. that
are followed in the organization.
 The exception that may be presents.
 The checks that should be place in order to avoid wrong entries.

5. CONCLUSION
 32

Any user can visit our website & requests to book tour packages, hotels. User
can inquire about different city packages, availability of different hotels including 5*, 3*, 2*
category. After that user can select a payment method & specifies delivery services for the tickets
& travel itineraries.
Thus we have seen that how our project will help in today’s online application &
give better quality of service & better customer satisfaction.
Thus our project is running successfully, whose evidence is attached herewith. It
also provides good security.

6. FUTURE SCOPE
 33

The project has met the standards required to work at Reservation system. If the
business logic remains same the project can be ported to any other reservation system (Airline
Reservation, Bus Reservation) company with minor changes in the working procedure of the
project. The project can be used as an availability to develop a project for a different company
with different business logic wherein the commonalties in certain areas remain the same at any
business level. By using the common features in future development the development time as well
as the cost of development can be decreased considerably.
This project is based on Standalone application platform. To modify the project to take the
advantage of geographical remote area. By shifting the project to the Networking & Internet
platform the project can be made into a Mobile Accessible Application by which the restrictions
of the software & hardware requirements can be scaled down, which is not possible using
Standalone platform.

6. REFERENCES
 34

[1] “ASP.NETCOMPLETE REFERENCE”, TMH.

[2] “ASP.NET2008”, Wrox Publication.

[1] Roger Pressman,“Software Engineering”