punjab tourism system..project
Post on 14-Apr-2018
217 Views
Preview:
TRANSCRIPT
-
7/30/2019 Punjab Tourism System..Project
1/63
1
1.COMPANY PROFILE
1.1 ORGANIZATION OVERVIEW
Telecommunications Consultants India Ltd (TCIL) is a leading ISO - 9001:2000 certifiedpublic sector undertaking. TCIL, a premier telecommunication consultancy and engineering
company with a strong base in Telecommunication & Information Technology (IT), was
incorporated in 1978 by Department of Telecommunications (DOT), Government of India
under the aegis of Ministry of Communications, headed by Minister of Communications and
Information Technology. There are four PSUs under DoT. TCIL is one of them. Other being
Bharat Sanchar Nigam Limited (BSNL),
Mahanagar Telephone Nigam Ltd. (MTNL),
ITI Limited.
Backed by the vast network of DoT / BSNL/MTNL, in terms of trained and experienced
manpower, research & development and training facilities, TCIL has made rapid strides.
Today TCIL offers total telecom solutions for projects. TCIL has working/ is works in almost
45 Countries mainly in Middle East Africa, South-East Africa, South-East Asia and Europe.
The Organizational Structure is formed with the objectives of providing globally world-class
technology and Indian expertise in all fields of Telecommunications and to provide total
Quality management & excellence in project execution. TCIL-IT, Information Technology is
a division of TCIL. Managed by ICSIL
Intelligent Communication Systems India Ltd.
About the Organization:
A joint venture of Telecommunications Consultant India Ltd.(TCIL) and Delhi StateIndustrial Development Corporation Ltd.(DSIDC)
Estabished in 1987,Authorised Capital of Rs.10 million. Registered Office address:
29,Phase-II Scheme-III,
Okhla Industrial area,
New delhi-110020,India
Tel Nos. 91-11-6385470,6385835email-icsil@del3.vsnl.net.in
http://www.dotindia.com/organization/director.htmhttp://www.dotindia.com/organization/director.htmhttp://www.bsnl.co.in/http://www.mtnl.net.in/index.htmhttp://www.itiltd-india.com/mailto:email-icsil@del3.vsnl.net.inmailto:email-icsil@del3.vsnl.net.inhttp://www.itiltd-india.com/http://www.mtnl.net.in/index.htmhttp://www.bsnl.co.in/http://www.dotindia.com/organization/director.htmhttp://www.dotindia.com/organization/director.htm -
7/30/2019 Punjab Tourism System..Project
2/63
2
Providing Services in
Repairs and maintenance of telephone exchange cards Laying communication Cables and executing related telecom and software development
projects
Supply of Computer Hardware and Computer Networking Running Information Technology Education And Training center.
TRAINING
The business of TCIL is characterized by Hi-tech mainly in the field of Telecom and IT, and
technology in this area is advancing very fast and with the view to keep update with the latest
technology TCIL undertakes training activities either through its own resources or through
external agencies. TCIL is having strategic tie-up with Advanced Level Telecom Centre of
Govt. of India.TCIL has also established its Training Centre TCIL- IT which is running
various courses duly approved by Department of Electronics, Govt. of India.
TCIL has also organized a number of training programmes catering to specific requirements
of Telecom PTTs viz. Nigeria, Kuwait, Maldives and Republic of Yemen to develop the
Telecom business in foreign countries.
TCIL has established Training centers in Afghanistan and is also in the process of training
their personnel in India.1.2 VISION
To excel in providing communication solutions globally by anticipating opportunities in
technology.
IT SERVICES
Turnkey Solution to meet end-to-end customer requirements
Networking Solutions with total System Integration and Implementations
Project Consultancy services from concept to commissioningOn-site Manpower Support
IT Training
1.3 JOINT VENTURES
To serve its clients better in different regions of the world, TCIL has entered into strategic
alliances with top national and international enterprises such as:
Hexacom India
Tamilnadu Telecom Ltd.
TCIL Bell South
-
7/30/2019 Punjab Tourism System..Project
3/63
3
TCIL Saudi
Telecom Consultants Nigeria
Regional Office- North
Telecommunications Consultants India Limited - Information Technology
(A Govt. of India Enterprise)
SCO 3017-18, Sector 22-D, Chandigarh
-
7/30/2019 Punjab Tourism System..Project
4/63
4
1. INTRODUCTION TO TECHNOLOGY
2.1 MICROSOFT .NET TECHNOLOGIES
The .NET Framework is an integral Windows component that supports building and running
the next generation of applications and XML Web services. The key components of the .NET
Framework are the common language runtime and the .NET Framework class library, which
includes ADO.NET, ASP.NET, and Windows Forms. The .NET Framework provides a
managed execution environment, simplified development and deployment, and integration
with a wide variety of programming languages.
Fig: .NET Framework in Context
-
7/30/2019 Punjab Tourism System..Project
5/63
5
Overview of the .NET Framework
The .NET Framework is a new computing platform that simplifies application development
in the highly distributed environment of the Internet.
The .NET Framework is designed to fulfill the following objectives:
To provide a consistent object-oriented programming environment whether object code isstored and executed locally, executed locally but Internet-distributed, or executed remotely.
To provide a code-execution environment that minimizes software deployment andversioning conflicts.
To provide a code-execution environment that guarantees safe execution of code, includingcode created by an unknown or semi-trusted third party.
To provide a code-execution environment that eliminates the performance problems ofscripted or interpreted environments.
To make the developer experience consistent across widely varying types of applications,such as Windows-based applications and Web-based applications.
To build all communication on industry standards to ensure that code based on the .NETFramework can integrate with any other code
The .NET Framework has two main components:
1. The Common language runtime2. The .NET Framework class library.
The Common Language Runtime:
CLR is the foundation of the .NET Framework. You can think of the runtime as an agent that
manages code at execution time, providing core services such as memory management,
thread management, and remoting, while also enforcing strict type safety and other forms of
code accuracy that ensure security and robustness. In fact, the concept of code management is
a fundamental principle of the runtime. Code that targets the runtime is known as managed
code, while code that does not target the runtime is known as unmanaged code. The class
library, the other main component of the .NET Framework, is a comprehensive, object-
oriented collection of reusable types that you can use to develop applications ranging from
-
7/30/2019 Punjab Tourism System..Project
6/63
6
traditional command-line or graphical user interface (GUI) applications to applications based
on the latest innovations provided by ASP.NET, such as Web Forms and XML Web services.
The .NET Framework can be hosted by unmanaged components that load the
common language runtime into their processes and initiate the execution of managed code,
thereby creating a software environment that can exploit both managed and unmanaged
features. The .NET Framework not only provides several runtime hosts, but also supports the
development of third-party runtime hosts.
.NET Framework Class Library:
The .NET Framework class library is a collection of reusable types that tightly integrate with
the common language runtime. The class library is object oriented, providing types from
which your own managed code can derive functionality. This not only makes the .NET
Framework types easy to use, but also reduces the time associated with learning new features
of the .NET Framework. In addition, third-party components can integrate seamlessly with
classes in the .NET Framework.
For example, the .NET Framework collection classes implement a set of interfaces that you
can use to develop your own collection classes. Your collection classes will blend seamlessly
with the classes in the .NET Framework.
As you would expect from an object-oriented class library, the .NET Framework types enable
you to accomplish a range of common programming tasks, including tasks such as string
management, data collection, database connectivity, and file access. In addition to these
common tasks, the class library includes types that support a variety of specialized
development scenarios. For example, you can use the .NET Framework to develop the
following types of applications and services:
a) Console applications.b) Windows GUI applications (Windows Forms).c) ASP.NET applications.d) XML Web services.e) Windows services.
2.2 Microsoft .NET Frameworks
.NET Framework 2.0 .NET Framework 3.0 .NET Framework 3.5
-
7/30/2019 Punjab Tourism System..Project
7/63
7
.NET Framework 4.0
Microsoft .NET Framework 4.0
The new version of .NET provides a Framework that helps in desigining portable, scalable,
and robust applications . The applications developed in .NET Framework 4.0 can be executed
in a distributed environment. Therefore, we can say that the .NET 4.0 is designed to address
the latest needs of the developers.
The Components of .NET Framework 4.0 are as follows:
Common Language Runtime Common Type System Metadata and Assemblies .NET Framework class library Windows Forms ASP.NET and ASP.NET AJAX ADO.NET Windows Workflow Foundation Windows Presentation Foundation Windows Communication Foundation Windows CardSpace LINQ
2.3 ASP.NET 4.0
ASP.NET 4.0 is a programming framework built on the common language runtime that can
be used on a server to build powerful Web applications.
ASP.NET 4.0 offers several important advantages over previous Web development models:
a) Enhanced Performance.ASP.NET 4.0 is compiled common language runtime code running onthe server. Unlike its interpreted predecessors, ASP.NET 4.0 can take advantage of early
binding, just-in-time compilation, native optimization, and caching services right out of the
box. This amounts to dramatically better performance before you ever write a line of code.
b) Excellent Tool Support.A rich toolbox and designer in the Visual Studio integrateddevelopment environment complement the ASP.NET framework. WYSIWYG editing, drag-
and-drop server controls, and automatic deployment are just a few of the features this
powerful tool provides.
c) Power and Flexibility.Because ASP.NET is based on the common language runtime, the powerand flexibility of that entire platform is available to Web application developers. The .NET
-
7/30/2019 Punjab Tourism System..Project
8/63
8
Framework class library, Messaging, and Data Access solutions are all seamlessly accessible
from the Web. ASP.NET is also language-independent, so you can choose the language that
best applies to your application or partition your application across many languages. Further,
common language runtime interoperability guarantees that your existing investment in COM-
based development is preserved when migrating to ASP.NET.
d) Simplicity.ASP.NET makes it easy to perform common tasks, from simple form submissionand client authentication to deployment and site configuration. For example, the ASP.NET
page framework allows you to build user interfaces that cleanly separate application logic
from presentation code and to handle events in a simple, Visual Basic - like forms processing
model. Additionally, the common language runtime simplifies development, with managed
code services such as automatic reference counting and garbage collection.
e) Manageability.ASP.NET employs a text-based, hierarchical configuration system, whichsimplifies applying settings to your server environment and Web applications. Because
configuration information is stored as plain text, new settings may be applied without the aid
of local administration tools. This "zero local administration" philosophy extends to
deploying ASP.NET Framework applications as well. An ASP.NET Framework application
is deployed to a server simply by copying the necessary files to the server. No server restart is
required, even to deploy or replace running compiled code.
f) Scalability and Availability.ASP.NET has been designed with scalability in mind, with featuresspecifically tailored to improve performance in clustered and multiprocessor environments.
Further, processes are closely monitored and managed by the ASP.NET runtime, so that if
one misbehaves (leaks, deadlocks), a new process can be created in its place, which helps
keep your application constantly available to handle requests.
g) Customizability and Extensibility.ASP.NET delivers a well-factored architecture that allowsdevelopers to "plug-in" their code at the appropriate level. In fact, it is possible to extend or
replace any subcomponent of the ASP.NET runtime with your own custom-written
component. Implementing custom authentication or state services has never been easier.
h) Security.With built in Windows authentication and per-application configuration, you can beassured that your applications are secure.
2.4 Visual C#.NET
Visual C# .NET is the next generation of the C, C++ & C# languages from Microsoft. With
Visual C#, you can build .NET applications, including Web services and ASP.NET Web
applications, quickly and easily. Applications made with Visual C# are built on the services
of the common language runtime and take advantage of the .NET Framework.
-
7/30/2019 Punjab Tourism System..Project
9/63
9
Visual C# has many new and improved features such as inheritance, interfaces, and
overloading that make it a more powerful object-oriented programming language. Other new
language features include free threading and structured exception handling. Visual C# fully
integrates the .NET Framework and the common language runtime, which together provide
language interoperability, garbage collection, enhanced security, and improved versioning
support. Visual C# supports single inheritance and creates Microsoft intermediate language
(MSIL) as input to native code compilers.
2.5MS SQL Server 2008
Microsoft SQL Server 2008 is a family of products that meet the data storage requirements of
the largest data processing systems and commercial Web sites, yet at the same time can
provide easy-to-use data storage services to an individual or small business.
Microsoft SQL Server 2008 Management Studio Express (SSMSE) is an integrated
environment for accessing, configuring, managing, administering, and developing all
components of SQL Server. SQL Server 2008 Management Studio Express combines a broad
group of graphical tools with a number of rich script editors to provide access to SQL Serverto developers and administrators of all skill levels. Developers get a familiar experience, and
database administrators get a single comprehensive utility that combines easy-to-use
graphical tools with rich scripting capabilities
The data storage needs of a modern corporation or government organization are very
complex. Online Transaction Processing (OLTP) systems must be capable of handling
thousands of orders placed at the same time. Increasing numbers of corporations are
implementing large Web sites as a mechanism for their customers to enter orders, contact the
service department, get information about products, and for many other tasks that previously
required contact with employees. These sites require data storage that is secure, yet tightly
integrated with the Web. Organizations are implementing off-the-shelf software packages for
critical services such as human resources planning, manufacturing resources planning, and
inventory control. These systems require databases capable of storing large amounts of data
and supporting large numbers of users.
Organizations have many users who must continue working when they do not have access to
the network. Examples are mobile disconnected users, such as traveling sales representatives
-
7/30/2019 Punjab Tourism System..Project
10/63
10
or regional inspectors. These users must synchronize the data on a notebook or laptop with
the current data in the corporate system, disconnect from the network, record the results of
their work while in the field, and then finally reconnect with the corporate network and merge
the results of their fieldwork into the corporate data store.
2.6 AJAX
Ajax (shorthand for asynchronous JavaScript and XML) is a group of interrelated web
development techniques used on the client-side to create interactive web applications. With
Ajax, web applications can retrieve data from the server asynchronously in the background
without interfering with the display and behavior of the existing page. The use of Ajax
techniques has led to an increase in interactive or dynamic interfaces on web pages. Data isusually retrieved using the XMLHttpRequest object. Despite the name, the use of JavaScript
and XML is not actually required, nor do the requests need to be asynchronous.
Like DHTML and LAMP, Ajax is not a technology in itself, but a group of technologies.
Ajax uses a combination of:
styling information.
information presented.
avoiding page reloads. The XMLHttpRequest (XHR) object is usually used, but sometimes
an I Frame object or a dynamically added tag is used instead.
-formatted
HTML, plain text, and JavaScript Object Notation (JSON). This data could be created
dynamically by some form of server-side scripting.
The Update Panel is an ASP.NET server control that updates portions of a web page without
reloading it. Through a mechanism called asynchronous post back, the HTML for the region
of the page wrapped by the control is sent by the server asynchronously through an Ajax
request. The ASP.NET controls that have been specified as content in an Update Panel are
able to cause either synchronous (traditional) or asynchronous post backs, by means of
triggers. A trigger is an event coming from an ASP.NET control that causes an Update Panel
to refresh its contents. Through triggers, an asynchronous post back can be started also by
-
7/30/2019 Punjab Tourism System..Project
11/63
11
controls that are declared outside the region of the ASP.NET page wrapped by the Update
Panel control.
2.7 Introduction to JavaScript
JavaScript is Netscape's cross-platform, object-based scripting language for client and server
applications. JavaScript lets you create applications that run over the Internet. Client
applications run in a browser, such as Netscape Navigator, and server applications run on a
server, such as Netscape Enterprise Server. Using JavaScript, you can create dynamic HTML
pages that process user input and maintain persistent data using special objects, files, and
relational databases. Through JavaScript's Live Connect functionality, your applications can
access Java and CORBA distributed-object applications.
2.8 Database Interconnectivity
i. LINQ(Language Integrated Query)
Language Integrated Query(LINQ) was introduced as a new component of .NET Framework
3.0. The basic function of LINQ is to add native data querying capabilities to .NET
Framework by using the syntax similar to Structured Query Language(SQL).LINQ allows
you to define statements that query a data source to generate the requested result set.
LINQ is a programming model that is used to provide a consistent method to obtain and
manipulate data. In ASP.NET 4.0 we can use LINQ directly programming language entities
called query expression, which are used to query and transform data from a LINQ enabled
data source.
A query is an expression that retrieves the requested data from the data source. A LINQ
quary specifies the information that you want to reterieve from the data source.
LINQ is supported by all providers like SQL SERVER, ORACLE, MS ACCESS, MYSQL.
Before LINQ is introduced if anyone work on different different database then he has to
remember query syntax for each database because query syntaxes are different for all
databases. LINQ provides common query structure for all databases. So if any one working
on diffenret databases then no need to remember query syntax for all databases.So LINQ
provides same expressive facilities like SQL Provides but that is in your language whichever
you use either c# ,VB or any other. LINQ Query does not affect the performance. It is same
as what SQL Server provides. Provides more intellisence support. Reduce the code. Provides
compile time checking syntax so no need of inline SQL or to wait until runtime to see the
result whether it is ok or not.
-
7/30/2019 Punjab Tourism System..Project
12/63
12
Types of LINQ
There are four types of LINQ providers.
LINQ to objects LINQ to SQL (Known as DLinq) LINQ to XML (Known as XLinq) LINQ to Entities (ADO.net Entities)
-
7/30/2019 Punjab Tourism System..Project
13/63
13
3.INTRODUCTION TO PROJECT
3.1Title of the project
Punjab Tourism System
3.2Abstract of the project
This project is aimed at developing for tourists are now visiting some of the most remote and
amaging on earth,travelling to Frontiers on journeys that are phschology and emotional as
well as geographical. Tourism in todays world is no more a luxury and simple sight seeing.
It involves many administrative work and co-ordination. This project is to develop and
deploy a web based application so that the different aspects of a tourism system become easy
to handle.
This system runs on multiple terminals, offers a GUI interface to its users and connects to a
database(s).
The Tools that are required for this project are:-
Front-End: ASP.NET using C# (Framework 4.0)
Back-End: SQL Server 2008
Other Technologies: CSS, JavaScript,AJAX
Functional components of the project-
Following is a list of functionalities of the System, more functionality that you find
appropriate can be added to this list. And, in places where the description of functionality is
not adequate, you can make appropriate assumptions and proceed.
Administrator is registered in the system. He must have some exclusive privileges (for
example, will accept/reject companys advertisements and can make insertion, deletion,
modifications etc to the existing advertisements in database also).
Functional components of the project
Following are the following module of this project.
Registration Admin should be able to
1. New user can login to System.
2. After login they can change his/her password.
3. It maintains the profile.
4. User profile has the personal details of the tourist, Current standard.
-
7/30/2019 Punjab Tourism System..Project
14/63
14
5. View website details.
6. Administrator has privilege to edit anybodys profile.
User:
1. User can login to system by id and password.
2. They can change their password
3. View the new events details.
4. View the tour details like schedule and date
5. User can check faculty details, tour details.
6. User can search cities , palacesetc
This project can be divided in 3tier where the back end is database tables. The middle tier
is the applications written in Asp.Net with C# which handles the database queries and fetch
relevant data. The front end represents the User Interface and sends the query to middle tier.
-
7/30/2019 Punjab Tourism System..Project
15/63
15
4.SYSTEM STUDY AND PROBLEM FORMULATION
4.1PROPOSED SYSTEM
The Punjab Tourism system has made a revolutionary difference in the time consumingproblems by providing the service online. User can save their time using online accounts and
they dont have to waste their time and spend a whole day waiting in queue for their turn.
It is cost-effective. Its a time-managed system. It is the fastest and most secure . User can just access by clicking their account 24 hrs and 7 days a week. Apart from clearance User can check any other information as well. Less effort and time required to manage records. Same information can be accessed and updated concurrently by others. Only online information need to be updated, no individual attention required.
-
7/30/2019 Punjab Tourism System..Project
16/63
16
5.SOFTWARE REQUIREMENT SPECIFICATION
5.1Introduction The Inrtoduction of Software Requirement Specification staes the goals and
objectives of the software describing in content of the computer based system.
5.2Information Description It providesdetailes description of the problem that the software
must solve. Information content, flow structure are documented. Hardware, Software and
human interfaces are described for external system element and internal software function.
5.3Functional Description A
processing narrative is provided for each function, design , constraints are stated and justified,
performance charcateristics are stated and one or more diagram are included to graphically
represent the overall structure of the software and interplat among software and other systemelements.
5.4Behavioral Description
The SRS examines the operation of software as a consequence of external element and
internally generated control characterstics.
5.5Validation Criteria It is
probably most important and iromically the most often neglacted section of the SRS. The
section is neglacted because completing it demands a through undersatnding of the software
requirements. Specification of valodation criteria acts as an implicit review of all other
requirements, so it is essential that time and attention is given to this section.
-
7/30/2019 Punjab Tourism System..Project
17/63
17
6.SYSTEM DEVELOPMENT LIFE CYCLE
SDLC methodology follows these steps
If there is an existing system, its deficiencies are identified. This is accomplished byinterviewing users and consulting with support personnel.
The new system requirements are defined including addressing any deficiencies in theexisting system with specific proposals for improvement.
The proposed system is designed. Plans are created detailing the hardware, operatingsystems, programming, and security issues.
The new system is developed. The new components and programs must be obtained andinstalled. Users of the system must be trained in its use, and all aspects of performance must
be tested. If necessary, adjustments must be made at this stage.
The system is put into use. This can be done in various ways. The new system can phased in,according to application or location, and the old system gradually replaced. In some cases, it
may be more cost-effective to shut down the old system and implement the new system all at
once.
Once the new system is up and running for a while, it should be exhaustively evaluated.Maintenance must be kept up rigorously at all times.
-
7/30/2019 Punjab Tourism System..Project
18/63
18
6.1 FEASIBILITY STUDY
Depending upon the results of the initial investigation, the survey is expanded to a more
detailed feasibility study. A feasibility study is a test of a system proposal according to its
workability, impact on the organization, ability to meet users needs and effective use of
resources. It includes thee main questions:
1. What are the users needs and how the candidate system does meet them?
2. What resources areavailable for given candidate system?
3. What are the likely impacts of the candidates system on the organization?
Three key considerations are involved in the feasibility analysis, Economical, technical,
and operational. All of these are discussed one by one in the following section.
6.2 ECONOMIC FEASIBILITY
An evaluation of development cost weighted against the ultimate income or benefit derived
from the developed system. 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 andweighs them against tangible and intangible be complicated by the criteria that vary with the
expected return on investment desired as part of companys 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.
6.3 OPERATIONAL FEASIBILITY
People are inherently resistant to change. And computers are known to facilitate change.
An estimate should be made of how strong reaction the user is likely to have towards the
development of a computerized system. The system should be simple to operate so that
layman can also understand what the system is, and how he can be benefited from the
system.
-
7/30/2019 Punjab Tourism System..Project
19/63
19
The project is operationally feasible as every care has been taken to make it easy to
operate and more over it does not require any complicated process of registration of
employers .It is a free registered online site which simplifies the search process. Also
administrator is provided with activities to perform changes in database at any time
without affecting system structure . So because of the above stated advantages the users
of the system will not be reluctant at all.
.
6.4 TECHNICAL FEASIBILTY
During technical analysis, the technical merits of the system are studied and at the same time
collecting additional information about performance, reliability, maintainability and
predictability.
Technical analysis begins with an assessment of the technical viability of the proposed
system.
What technologies are required to accomplished system function and performance?
What new materials, methods, algorithms or processes are required and what is their
development risk?
How will these obtained from technical analysis form the basis for another go/no-go
decision on the test system?If the technical risk is severe, if models indicate that the desired function cannot be achieved,
if the pieces just wont fit together smoothly-its back to the drawing board. As the software
is very much economically feasible, then it is really important for it to be technically sound.
6.5 BEHAVIORAL FEASIBILITY
Our project is behavioral feasible as the system is computerized and the GUI is extremely
easy and user friendly which provides dictionary meaning to the user.
-
7/30/2019 Punjab Tourism System..Project
20/63
20
7: Processing Environment
Steps to start-off the project
1. It needs knowledge in Web server as it has to be hosted on a web server. t needs knowledgeabout C#, Asp.net, HML,CSS etc.
2. It needs knowledge about the Object Oriented Programming.
Requirements
Hardware requirements
Number Description Alternatives (If available)
1 PC with minimum hard
disk capacity 40 Gig and
512 MB RAM
Software requirements
Number Description Alternatives (If available)
1 MS Visual Studio 2010 Any other web server
2. MS SQL Server 2005/2008
Manpower requirements: 2 persons
Need:-
Define the role of staff involved in the invitation to CMS Define the interactions between admin, student, and college of college. Monitor and control supplier relationships. time consuming process lot of paper work involved difficult in manual report generation manual work is always prone to errors
-
7/30/2019 Punjab Tourism System..Project
21/63
21
8. Implementation EnvironmentBack-End
8.1 SQL SERVER:
SQL Server is an SQL-compliant RDBMS. SQL-compliant means it use the ANSI (American
National Standard Institute) version of Structured Query Language or SQL. Structured
Query Language is a command that allow us to modify or retrieve information from the
database.
Client server means that SQL Server is designed to store data in the central location (the
server) and deliver it on demand to numerous other locations (the client). SQL Server is also
a Relational Database Management System (RDBMS).
8.2 FEATURES OF SQL SERVER 2008: Information representation Unique definition of rows Systematic treatment of Null values Guaranteed access High level Update, Insert, and Delete Retrieving information from the database. Accepting query language statements. Enforcing security specifications. Enforcing data integrity specifications Enforcing transaction consistency Managing data sharing Optimizing queries
Enterprise Manager:
SQL Server Enterprise Manager is a graphical tool that allows easy configuration and
management of Microsoft SQL Server and SQL 2000 program group.
SQL Server Enterprise Manager can also be used to:
1. Manage logins, permission and users.
2. Create a database
3. Take back-up of database and transaction logs.
4. Manage tables
-
7/30/2019 Punjab Tourism System..Project
22/63
22
8.3 Query Analyzer:
The SQL Server Query Analyzer allows us to create adhoc queries and run them
interactively. We may also execute Transact-SQL statements stored in text file and view the
result in result plane or result grid. The Query Analyzer also has a color-coded editor to assistthe user with checking of syntax. It also has context sensitive help.
-
7/30/2019 Punjab Tourism System..Project
23/63
23
9. PROJECT PLAN
Punjab Tourism System is mainly a web based application that is being developed using
ASP.NET with C# .
The application is divided into two modules. The modules are as follows:
Administrator Module : It includes the managing of users and databases of this site by the
administrator.
User Module: It includes facility for users, they can easily check the places also can
download and upload they want.
The intended audiences for this Project are:
The innovative team members.
The Professional people either freshers or the experienced people and recruiters.
-
7/30/2019 Punjab Tourism System..Project
24/63
24
10.SOFTWARE REQUIREMENT ANALYSIS
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 a detailed description of the problem that the software must solve,
describing it in the context of the computer based system.A description of each function required to solve the problem is presented in the functional
description.
A validation criterion is probably the most important and ironically the most often neglected
section of the software requirement specification.
10.1 General Description
Software requirement specification can be used for different purpose. Here are the majoruses.
1.Statement Of User Needs:
A main purpose of the product specification may be part of the products user. Sometimes,
the specification may be a part of a contact sign between the producer and the user. It could
also form part of the user manuals. A users needs are sometimes not clearly understood by
the developer. If this is the case, a careful analysis- involving much interaction with the user
should be developed to reaching a clear statement of requirements, in order to avoid possible
misunderstandings.
Sometimes, at the beginning of a project, even the user has no clear idea of what exactly the
desired product is. Think for instance of user interface, a user with no previous experience
with computer products may not appropriate the difference between, say menu driven
interaction and a command line interface. Even an exact formation of System functions and
performance may be missing an initial description produced by an inexperienced user.
2. A Statement of the Requirements for the Implementation:
-
7/30/2019 Punjab Tourism System..Project
25/63
25
Specifications are also used as a reference point during 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.
1.2 Specific Requirements
HARDWARE REQUIREMENTS
1. PROCESSOR: Pentium 3 or higher
2. RAM: 512 MB or higher
3. HARD DISK SPACE: 80GB or higher
4. GRAPHIC CARD: video graphic adaptor
SOFTWARE REQUIREMENTS
1.FRAMEWORK-Net Framework 4.0
2. ENVIRONMENT-MICROSOFT VISUAL STUDIO.NET
3.BROWSER- Internet Explorer : 6.0 or higher,Mozilla Firefox
4. DATABASE- SQL SERVER 2008
5.OPERATING SYSTEM: Windows XP or 2000 or 7 or vista
10.3Communications Interfaces
The Customer must connect to the Internet to access the Website:
Dialup Modem of 52 kbps. Broadband Internet.Dialup or Broadband Connection with a Internet Service Provider.
-
7/30/2019 Punjab Tourism System..Project
26/63
26
11.DESIGN
This phase is the first step in moving from problem domain to solution domain. In other
words starting from what is needed,design takes us towards how to specify needs.
Design phase is often divided into two separate phases:
System Design:In System design main focus is on what components are needed.
Detailed design:During detailed design focus is on specification of the internal logic for each
of the modules/components.
11.1 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 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 eachtable 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.
11.2 Code DesignWhen large volumes of data are being handled, it is important that the item be identified,
stored or selected easily and quickly. To accomplish this, each data item must have unique
identification and must be related to other items of the same type. Codes can provide brief
identification of each item, which replace longer description that would be more awkward to
store and manipulate.
-
7/30/2019 Punjab Tourism System..Project
27/63
27
The ability to interrupt codes, evaluate coding schemes and devices new or improved codes
are important skills for a system analyst. Common types of codes includes validation checks.
A common problem with computer system is that it is very easy to put incorrect data into
them. So the input data is validated to minimize errors and data entry.
A validation check is an automatic check made by computer to ensure that any data entered
into the computer is sensible. A validation check does not make sure that data has been
entered correctly.
11.3 Input Design
The input design is the link between the information system and the user. It comprises
developing specification and procedure for data preparation and those steps that are necessary
to put transaction data into a usable form for processing data entry. The activity of putting
data into the computer for processing can be achieved by instructing the computer to read
data from a written or printed document or it can occur by having people key data directly
into the system. The design of inputs focuses on controlling the amount of inputs required,
controlling errors, avoiding delay, avoiding extra steps and keeping the process simple.
11.4 Output Design
Output design is a process that involves designing necessary outputs that should be given to
various users according to their requirements. Efficient, intelligible output design should
improve the systems relationship with the user and help in decision making.
Technologies Used
.Net -It consists of two parts1. CLR stands for Common language runtime, which is run time environment to execute the
.Net programs.
2. .Net API (Application Programming Interface) that consists of inbuilt classes used in .Netprograms.
VC#.Net-.Net is Platform Dependent, Secure, Object Oriented, component oriented, Scalable,and Robust Programming Language.
ADO.Net-ADO.Net (Active X data objects) is an API, which is used for the communicationof .Net programs with different databases.
-
7/30/2019 Punjab Tourism System..Project
28/63
28
ASP.Net-ASP.Net (Active Server Pages) is also a part of .Net and is also used for server-sideprogramming but with the help of ASP.Net we can segregate the work of a web designer and
a developer.
SQL Server-SQL Server is used as database, used to store data. It is RDBMS. Scripting Languages HTML & Cascading Style Sheet (CSS) AJAX
Analysis Modelling
The intent of the analysis model is to provide a description of the required informational,
functional and behavioral domains for a computer based system. The analysis model is a
snapshot of requirements at any given time.As the analysis model evolves, certain elements
will become relatively stable providing a solid foundation for design tasks that follow.
The software engineer or analyst defines all data objects that are processed within the system,
the relationships between the data objects and other information that is pertinent to the
relationships.
Flow-orienred modeling continues to be one of the most widely used analysis notifications
today Data Flow Diagram takes input-process-output view of a system.Thatis,data objects
flow into software,are transformed by processing elements and resultant data objects flow of
the software.
-
7/30/2019 Punjab Tourism System..Project
29/63
29
12.DFD OF PRESENT SYSTEM
Data Flow Diagram
Level 0
-
7/30/2019 Punjab Tourism System..Project
30/63
30
Level 1
-
7/30/2019 Punjab Tourism System..Project
31/63
31
Level 2:
-
7/30/2019 Punjab Tourism System..Project
32/63
32
13.TESTING
Testing Methods used in this project are:
13.1 SYSTEM TESTING
The purpose of system testing is to identify and correct errors in the candidate system.
Testing is important element of software quality assurance ad represents the ultimate review
of specification, design and coding. The increasing visibility of the software as a system
element and the cost associated with a software failure are motivated forces for well planned,
through testing.
System testing was conducted in order to detect errors and for comparing then the final
system with the requirement specification reports, i.e. whether the system meets
requirements. During testing the software was executed with the set of test cases and the
output of programs for the test cases was evaluated to determine if the program is performing
as it was expected to. Testing presents an interesting challenge for the software engineers
attempt to build software from an abstract concept to an acceptable implementation. In testing
engineer create a series of test cases that occurs when errors are uncovered. Testing is the
process of executing a program for finding errors. A good test is one that has the high
probability of finding an uncovered error. A successful error is one that uncovers
undiscovered errors. The term error is used to refer the difference between actual output of
the software and the current output. Fault is a condition that causes the software to fail to
perform its required function. Software reliability is defined as a required function. Software
reliability is defined as the probability that the software will not undergoes failures for a
specified times under specified condition. Failure is the inability of a system or a component
to perform a required function according to its specification. Different levels of testing were
employed for software to make it error free, fault free and reliable.
Testing Methods used in this project are:
13.2 Black Box Testing: Black box tests are performed to access how well a program meets
its requirements, looking for incorrect or missing functionality. Functional tests typically
exercise code with valid or nearly valid input for which the expected output is known. This
includes concepts such as boundary values.
-
7/30/2019 Punjab Tourism System..Project
33/63
33
Performance tests evaluate response time, memory usage, throughput, device utilization and
execution time. Stress tests push the system to or beyond its specified limits to evaluate its
robustness and error handling capabilities. Reliability tests monitor system response to
representative user input, counting failures over time to measure or certify reliability.
Black box testing uncovers the following types of errors
Incorrect or missing functions Interface errors External database access Performance errors Initialization and termination errors
The following technique was employed during black box testing:
13.3 Unit Testing: It is technique for testing the changes made in an existing system. It is
adopted to test the programs for errors. Errors found in coding and in logic are fixed. Errors
between interactions of modules are removed.
13.4 Integration Testing:One of the most difficult aspects of software development is the
integration and testing of large untested subsystems the integrated system frequently fails insignificant and mysterious ways and it is difficult to fix it.
Integration testing exercises several units that have been combined to form a module,
subsystem or system. Integration testing focuses on the interfaces between units, to make sure
the units work together. The nature of this phase is certainly white box, as we must have
knowledge of the units to recognize if we have been successful in focusing them together in
the module.
-
7/30/2019 Punjab Tourism System..Project
34/63
34
14.IMPLEMENTATION
Implementation is the stage in the project where the theoretical design is turned into the
working system and is giving confidence to the new system for the users i.e. will work
efficiently and effectively. It involves careful planning, investigation of the current system
and its constraints on implementation, design of method to achieve the change over, an
evaluation, of change over methods. A part from planning major task of preparing the
implementation is education of users. The more complex system is implemented, the more
involved will be the system analysis and design effort required just for implementation. An
implementation coordinating committee based on policies of individual organization has been
appointed. The implementation process begins with preparing a plan for the implementationfor the system. According to this plan, the activities are to be carried out; discussions may
regarding the equipment has to be acquired to implement the new system.
Implementation is the final and important phase. The system can be implemented only after
thorough testing is done and if it found to working according to the specification.
-
7/30/2019 Punjab Tourism System..Project
35/63
35
15.SYSTEM MAINTENANCE
The last part of system development life cycle is system maintenance, which is actually the
implementation of the post-implementation plan. Hence Programmers/ Analyst spends
sufficient time for maintaining programs.
Hence maintenance will cover a wide range of activities including correcting coding and
design errors, updating documentation and test data and upgrading user support. Many
activities classified as maintenance actually fall under enhancements. Hence in maintenance
of system enhancement also takes place. Therefore in maintenance addition, modification, re-
developing of code will take place to support changes in specification.
-
7/30/2019 Punjab Tourism System..Project
36/63
36
16.TABLES
Registration Table :
-
7/30/2019 Punjab Tourism System..Project
37/63
37
Country Table :
-
7/30/2019 Punjab Tourism System..Project
38/63
38
CityTable :
-
7/30/2019 Punjab Tourism System..Project
39/63
39
Admin Table :
-
7/30/2019 Punjab Tourism System..Project
40/63
40
17. SNAPSHOT OF WEB PAGES:
HOME PAGE :
-
7/30/2019 Punjab Tourism System..Project
41/63
41
ABOUT PUNJAB:
-
7/30/2019 Punjab Tourism System..Project
42/63
42
HISTORY :
-
7/30/2019 Punjab Tourism System..Project
43/63
43
PHOTO GALLERY:
-
7/30/2019 Punjab Tourism System..Project
44/63
44
Login Page :
-
7/30/2019 Punjab Tourism System..Project
45/63
45
RegistrationPage :
-
7/30/2019 Punjab Tourism System..Project
46/63
46
Culture Page:
-
7/30/2019 Punjab Tourism System..Project
47/63
47
Where To Stay:
-
7/30/2019 Punjab Tourism System..Project
48/63
48
Plan To Trip Page:
-
7/30/2019 Punjab Tourism System..Project
49/63
49
Hotel Information:
-
7/30/2019 Punjab Tourism System..Project
50/63
50
18:SOURCE CODE OF REGISTRATION FORM
NEW USER REGISTRATION
-
7/30/2019 Punjab Tourism System..Project
51/63
51
FIRST NAME:
LAST NAME:
EMAIL ID:
PASSWORD:
CONFORM PASSWORD:
-
7/30/2019 Punjab Tourism System..Project
52/63
52
runat="server" TextMode="Password">
"(invalid
password)"
COUNTRY
CITY:
-
7/30/2019 Punjab Tourism System..Project
53/63
53
Select
SUBMIT
s
-
7/30/2019 Punjab Tourism System..Project
54/63
54
19.PROGRAMMING CODE IN C#
For Registeration page
using System;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Data.SqlClient;
usingSystem.Data;
usingSystem.Configuration;
publicpartialclassREG : System.Web.UI.Page
{ProjectDataContextDataContextobj = new
ProjectDataContextDataContext();
int a;
SqlConnection con = newSqlConnection(ConfigurationManager.ConnectionStrings["cons"].ToStrin
g());
SqlCommandcmd = newSqlCommand();
protectedvoidPage_Load(object sender, EventArgs e)
{if (!IsPostBack)
{
data();
}
}
-
7/30/2019 Punjab Tourism System..Project
55/63
55
privatevoid data()
{
var record = from rec in obj.mca1s select rec;
DropDownList1.DataSource = record;
DropDownList1.DataTextField = "cname";
DropDownList1.DataValueField = "cid";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "select");
}
protectedvoid DropDownList1_SelectedIndexChanged(object sender,
EventArgs e)
{
var record = from r in obj.city1s wherer.country ==
Convert.ToInt32(DropDownList1.Text) select r;
DropDownList2.DataSource = record;
DropDownList2.DataTextField = "city_name";
DropDownList2.DataValueField = "city_id";
DropDownList2.DataBind();
}
protectedvoid LinkButton1_Click(object sender, EventArgs e)
{
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
-
7/30/2019 Punjab Tourism System..Project
56/63
56
cmd.CommandText = "insert into
regis(f_name,l_name,e_id,pass,coun,city)
values(@f,@l,@e,@p,@co,@c)";
cmd.Parameters.Add("@f", TextBox1.Text);
cmd.Parameters.Add("@l", TextBox2.Text);
cmd.Parameters.Add("@e", TextBox3.Text);
cmd.Parameters.Add("@p", TextBox4.Text);
cmd.Parameters.Add("@co",
DropDownList1.SelectedIndex.ToString());
cmd.Parameters.Add("@c",
DropDownList2.SelectedIndex.ToString());
con.Open();
cmd.ExecuteNonQuery();
Label1.Text = "record inserted succesfully";
con.Close();
}}
-
7/30/2019 Punjab Tourism System..Project
57/63
57
19.SOURCE CODE OF LOGIN FORM
-
7/30/2019 Punjab Tourism System..Project
58/63
58
USER ID :
PASSWORD:
LOGIN
-
7/30/2019 Punjab Tourism System..Project
59/63
59
-
7/30/2019 Punjab Tourism System..Project
60/63
60
21.PROGRAMMING FOR LOGIN
using System;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
public partial class LOGIN : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void LinkButton1_Click(object sender, EventArgs e)
stringlgntype, id, pwd;
id = TextBox1.Text;
pwd = TextBox2.Text;
//code for user
var records1 = from rec in obj.mca1s where rec.cid.Equals(id)
&&rec.cname.Equals(pwd) select rec;
int r = records1.Count();
if (r > 0)
{
Session["visitor"] = id;
-
7/30/2019 Punjab Tourism System..Project
61/63
61
Response.Redirect("user.aspx");
}
else
{
Label1.Text = "Invalid id and password";
}
}
}
-
7/30/2019 Punjab Tourism System..Project
62/63
62
22.FUTURE SCOPE AND ADVANCEMENT
The Indian state of punjabis known for its cuisine, culture and history. Some of the main
cities in Punjab are Amritsar, Jalandhar, Ludhiana and Patiala. Punjab's public transportation
network provides excellent tourist transportation.
Tourists to Punjab can enjoy culture, ancient civilization, spirituality and history. Punjab has
a rich religious history incorporating Sikhism, Islam and Hinduism. The royal Punjabi
palaces, historic battle sites, shrines, temples and examples of Sikh architecture are notable
attractions. Punjabi cuisine includes a wide range of both vegetarian and non-vegetarian
dishes.
Due to the scope and depth of Punjab's history there are many places of interest. Tourism is a
swiftly expanding sector in Punjab.
-
7/30/2019 Punjab Tourism System..Project
63/63
23.BIBLIOGRAPHY
BOOKS:
1. System Analysis and Design BY Elias M. Awad, Galgotia Publications.2. Software Engineering By Roger S. Pressman, McGraw- Hill Publications.3. .NET 3.5 Wrox Box: Professional ASP.NET 3.5, Professional C# 2008, Beginning C#
3.0: An Introduction to Object Oriented Programming by Jack Purdum
4. Beginning SQL Server 2005 Programming by Robert Vieira5. SQL/PLSQl By Evan Bayross,BPB Publications
Websites:
1. http://msdn.microsoft.com/en-us/vstudio/default.aspx2. http://msdn.microsoft.com/en-us/netframework/default.aspx3. http://msdn.microsoft.com/en-us/asp.net/default.aspx4. http://msdn.microsoft.com/en-us/sqlserver/default.aspx5. ttp://www.dotnetspider.com/6. http://www.asp.net/7. http://www.microsoft.com/sql/default.mspx8. http://databases.about.com/
top related