project report travel management.doc

15

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 users 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.

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. Whats equally important- they share a strong customer orientation that means they actually start by listening to the customer. Theyre focused on coming up with solutions that serve customer requirements today and anticipate future needs.

2. REQUIREMENTS AND SPECIFICATION2.1 Hardware Requirements:

Processor : Core 2 duo or any anotherRam : 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 20052.3 ABOUT ASP.NET 2.02.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 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 youll 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 2005 installed. Because Visual Studio 2005 comes with its own development server for local testing, you dont 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 dont 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 thats 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 FEATURES1. 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 preprocessors.

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.

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 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 CRMs 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 arent 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 members area, or subscribing to newsletters or anything else that website users do. Generally, its 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), 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, weve:

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 job2.5 C#.NET V2.0:

2.5.1 Introduction to C#.net programming language:

C# is a Multi-paradigm programming language that encompasses functional, 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 Borlands 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.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.

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

3. DESIGN AND IMPLEMENTATION3.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.

.

3.2 Database Design

BILLING TABLE:

CANCEL TABLE:

CITY TABLE:

DETAILTOURINFO TABLE:

SOURCE TABLE:

FAIRLIST TABLE:

HOTEL2 TABLE:

HOTEL3 TABLE:

HOTEL5 TABLE:

HOTELS TABLE:

NORTHTOURPACKAGES TABLE:

ZONE TABLE:

3.3 PROGRAM FLOW DIAGRAM

3.4 Codingusing 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.Data;

using System.Linq;

using System.Web;







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

{


{

}

}using System;



using System.Data;

using System.Linq;

using System.Web;







using System.Data.SqlClient;

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

{

int a;


{

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.Data;

using System.Web;







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

{

Response.Redirect("~/Login.aspx");

}

}

}

using System;



using System.Data;

using System.Linq;

using System.Web;







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

{


{

}

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.Data;

using System.Linq;

using System.Web;








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"]);

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.Data;

using System.Linq;

using System.Web;








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

{


{

Label7.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);


while (dr.Read())

{

Label7.Visible = true;






Label7.Text = dr[0].ToString(); Label8.Text=dr[1].ToString();

Label9.Text = dr[2].ToString();




}

}

}using System;



using System.Data;

using System.Linq;

using System.Web;








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

{


{


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


while (dr.Read())

{



}

}

using System;



using System.Data;

using System.Linq;

using System.Web;







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.Data;

using System.Linq;

using System.Web;







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

{


{

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

}

}

}

3.5 Output Screens

Start up:

Tour Form:

North tour form:

Tour package info form

Fair list form

Login Form

Sign Up

Billing Form

Registration Form

Receipt Form

Hotel Booking Info Form

Hotel link form

Hotel Detail Form

4. PERFORMANCE ANALYSES4.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 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 todays 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 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

[1] ASP.NETCOMPLETE REFERENCE, TMH.[2] ASP.NET2008, Wrox Publication.

[1] Roger Pressman,Software Engineering

Show fair

Display Hotel details

Select Hotel from 5*, 3* or 2*

Select City

START

C

STOP

Show receipt

Successful registration

Sign Up

If you r new user

Log in

If want to register then click on Add

Show Detail Tour Information

Display Tour Package Information

B

START

Select Zone

Select Source and Destination

START

A

STOP

B

C

D

Display

Display

Contact Us

About Us

Login

Hotel

Tour

Enter your Acc No & CVV No

Administrator

START

Change in Billing Table

Change in Source Table

Change in City Table

Change in Detail tour Info.

Change in North Tour Package

Change in Zone Table

Change in Fair List Table

STOP