hotel management system doc1

7/30/2019 Hotel Management System DoC1

http://slidepdf.com/reader/full/hotel-management-system-doc1 1/162154

GULABPURA, BHILWARA (RAJ.) 311021GULABPURA, BHILWARA (RAJ.) 311021

Affiliated to M.D.S. University AjmerAffiliated to M.D.S. University Ajmer

CERTIFICATE This is to certificate that the project work entitled

In Fulfillment Of the Requirement Of BCA Final

Year In Information Technology, Embodies The Work

Done By Them Under My Supervision.

Signature of the Guide

Signature of HOD

Submitted for the Project Work Viva held on ………………………….......................................



Internal Examiner External

Examiner








Signature of HOD





Examiner










Signature of HOD



Examiner

HOTEL MANAGEMENT

SYSTEM

CERTIFICATE

This is certify that the Hotel Management System in

Visual Basic is the original work done by Pratibha and Vinita

Maheshwari as regular students of “Bachelor of Computer

Application” towards the partial fulfillment of the

requirement for award of the BCA Final Year by MDS

University, Ajmer is an authentic work carried out under my supervision at INDRA PROFESSIONAL SANSTHAN COLLEGE,

GULABPURA.



This project demonstrates as good hold of students over the

field of interest. Their work reveals a high technical acumen

as well as aptitude. This work is a product of their labor and

hard work. It is approved for the award of the graduation.

External Examiner

Project Guide

Mr.Y

ogesh chhipa

Dated:

HOTEL MANAGEMENT

SYSTEM

CERTIFICATE


Visual Basic is the original work done by Pratibha kalya as

regular students of “Bachelor of Computer Application”

towards the partial fulfillment of the requirement for award

of the BCA Final Year by MDS University, Ajmer is an



authentic work carried out under my supervision at INDRA

PROFESSIONAL SANSTHAN COLLEGE, GULABPURA.





External Examiner

Project Guide

Mr.Yogesh Chhipa

Dated:

HOTEL MANAGEMENT

SYSTEM



CERTIFICATE


Visual Basic is the original work done by VinitaMaheshwari as regular students of “Bachelor of Computer

Application” towards the partial fulfillment of the

requirement for award of the BCA Final Year by MDS

University, Ajmer is an authentic work carried out under my

supervision at INDRA PROFESSIONAL SANSTHAN COLLEGE,

GULABPURA.





External Examiner Project

Guide

Mr.

Yogesh Chhipa

Dated



Table of content



S.No. Contents Page

no.

1. Acknowledgement 4

2. Abstract

3. Objectives

4. Visual basic-The Front-End

5. Access Database- The Back-

End

6 SDLC Model

7 Feasibility Study

8 Project Scheduling

9 Introduction to Project

10 Analysis Document

11 Software Process Model

12 Data Flow Diagram

13 Entity Relationship Diagram

14 Bibliography

.15 Database Structure (Tables)

16 The Project (Coding)

17 Reports



ACKNOWLEDGEMEN

T

It gives me immense pleasure in

submitting this project on A System for

Management of Performance Analysis of

Hotel Management System.

A research work owes its success from commencement to completion, to the people in love with researchers

at various stages. Let we express our gratitude to all

those who helped us in various stage of this study.

First, we would like to express our sincere gratitude

indebtedness to Mr. Nitin Jain (Principal, IPS). We

would also l ike thanking all the people who have

helped us in the project development & we are also

grateful to our guide Mr.Yogesh Sharma for the help

provided in completion of the project, which was

assigned to us.

Last but not least, we pay our sincere thanks and

gratitude to all the Staff Members of I.T Department for making our project valuable and fruitful. We are

also thankful to all my colleagues for their co-

operation and support.



P

ratibha kalya

Vinita

Maheshwari

ABSTRACT As per the available system, we have seen there are a lot of

limitations due to which organization is bearing a high cost

and more manpower. A lot of work burden is on the

management and staff members while handling stock

maintenance and its related different calculations. To

deduce the workload and to streamline the office work, it

has been decided that the computerization is must for the

organization in the present scenario.

The following are the objectives that support the Hotel

Management System:- Reduction in redundant activities.

System can be linked up with other system

Reduction in efforts of manpower engaged in office

Accuracy in the available data.

Availability of data at any site



Reliability of system and data

Very easy to process information and to retrieve data

whenever required

Recurring cost saving activity

Centralized data

OBJECTIVES

The main objectives of system for Hotel Management

System are:

1. System should support multi-user environment.

2. System should be fully automated.

3. System should provide concrete security features like

creating users and assigning privileges to users of thesystem.

4. System should be capable to keep track of all the detailed

descriptions of the client and the whole details of services

offered by the client organization.

5. Various outputs (reports) should be available online any

time.

.6. System should be able to handle extremely large

volumes of data (i.e. Large database support)






creating users and assigning privileges to users of the

system.

INTRODUCTION OF VISUAL

BASIC

Introduction:This PROJECT is for programmers and would be

programmers who want learn visual basic as quickly as

possible, you will be quickly creating applications by

following the simple example. All the applications featured

are fully functional window applications with all the usual

user-interface controls such as command buttons, labels and

textboxes. As long as you are familiar with Windows 9 X’s or

XP, you can easily create applications with Visual basic. You

don’t have to be a Widows expert, but you should feel

comfortable working with menus, the mouse and the



windows interface. If you’ve opened, closed and re-sized

windows you should have the ability to make own Visual

Basic applications in no time at all.

What is a programming

language?

A computer cannot understand any person’s spoken

language. A spoken language such as English, French, is too

general and ambiguous for computer to understand.

Therefore, we must adapt to the machine and learn the

computer language so that the computer can understand.

This is where visual basic comes into it-when you type visual

basic source code into the computer, the computer

processes these statements into Visual Basic language. The

statements in visual basic, however, do not have multiple

meanings within the same context.

A BERIF DISCRIPTION OF VISUAL

BASIC

VISUAL BASIC is a high level programming language

evolved from the earlier DOS version called BASIC.BASIC

means Beginners’ All-purpose Symbolic Instruction Code. It

is a fairly easy programming language to learn. The codes



look a bit like English Language. Different software

companies produced different version of BASIC, such as

Microsoft QBASIC, QUICKBASIC, GWBASIC, IBM’s BASIC and

so on.

VISUAL BASIC is a VISUAL and events driven

programming Language. These are the main divergence

from the old BASIC. In BASIC, programming is done in a text-

only environment and the program is executed sequentially.

In VISUAL BASIC, programming is graphical

environment. Because users may click on a certain object

randomly, so each object has to be programmed

independently to be able to response to those actions

(events). Therefore, a VISUAL BASIC program is made up of

many subprograms, each has its own program codes, and

each can be independently and at the same time each can

be linked together in one way or another.

The Visual Basic Environment:



On start up Visual Basic 6.0 will

display the following dialog box-

You can choose to starts a new

project, open an existing project or select

a list of recently opened programs. A

project is a collection of files that make

up your application. There are various types of applications

we could create; however, we shall concentrate on creating

standard EXE program (EXE means executable

program).Now, click on Standard EXE icon to go into the

actual VB programming environment .

Why I Have Used “VISUAL

BASIC” ?

• The Visual basic is technology committed to improve to

itself continually and grows along with the changes and

the improvements in operating system used.



• Visual Basic enables rapid prototyping as it has various

in-built tools, making programming with Visual Basic

easy.

INTRODUCTION OF MICROSOFT

ACCESS

Microsoft Access database development

is our profession. We have been creating Access databases

full time since 1994 and have developed large database

system’s since1980. We have Access Database Clients

across the U.S. and around the world. We consult to small

companies and corporations. Our MS Access programmers

aim is to create reliable, user friendly Microsoft Access

database at a good price with unequaled customer

support.

“Our database seems to be growing in size at an

alarming rate. It is taking longer and longer for the

database to load. Our look up lists are getting very slow



too. Is this typical with Access Databases? Is there anything

that can be done? ”

The problem is often caused by an inefficient todatabase table design with little or no table normalization.

Look up lists & Combo boxes are sometimes used

for fields but the programmer stores the actual combo

box values in the destination table rather than a simple

(small) numeric pointer to the combo box entry.

We have questioned programmer about there design

decisions & many seem in client to brag that the have

200 hundred megabytes Access Databases running

with no problem. Those 200 megabytes databases canusually be designed to be only 30 to 40 megabytes.

Microsoft Access Databases can usually we design

to hold large amounts of data efficiently. Extensive use

of lists an pointer into lists (foreign keys) can reduce

the size of a typical spreadsheet style (non-normalized)

by an order of magnitude.



There are many other techniques that can

increase the speed of specific process and function

within an Access Database.

SDLC MODEL

The step in the system development life cycle is

the preliminary investigation. It is the collecting of

information that helps the team members in evaluating the

merits of the project request and thus makes an informed

judgment about the feasibility of the proposed project.

For this proposed system we have done some preliminary

investigation and gathered data through primary methods.

Reviewing organization

documents:

Firstly we have to learn about the organization involved in or

affected by the project. We reviewed the working of the

different departments of the organization and who is the



person directly associated with the department who are

going to interact with the system.

On site observation

In this process we monitored the office environment, the

workload of the system and the user’s methods of work and

the facilities provided by the organization to the users. The

purpose of on site observation is to get as specific as

possible to the real system being studied. In this method, we

observe the activities of the system directly.

Conducting interviewsWritten documents and the on site observation techniques

tell us how the system should operate but the do not include

enough details for a decisions to be made .We prepared a

questionnaire for the users of the proposed system to learn

more about the nature of the project request and the depths

to which users may retrieve information from it . Sometimes

we also conducted interviews to provide details that further

explained the project and show whether assistance is merits

economically, operationally and technically.



FEASIBILITY STUDY Feasibility is the determination of whether or not a project is

worth doing. The process followed in making this

determination is called a feasibility study. This type of study

determines if a project can and should be taken.

This project has also undertaken in the scope of feasibility

study. As in the manual system there are so many

deficiencies so to overcome from these deficiencies new

computerized system required. But whether the new system



is feasible in the realistic condition or not for this purpose we

have seen this project from different criteria’s. Many

feasibility studies are necessary for both users and analysts.

The feasibility studies may be carried

out in three phases:-

I. Technical feasibility

II. Operational feasibility

III. Economic feasibility

Technical Feasibility

During technical analysis the technical merits of the system

concept are evaluated, at the same collecting additional

information about performance, reliability, maintainability

and produce ability. In some cases, it also includes a limited

amount of research and design.

Technical analysis begins with an assessment of the viable

of the proposed system. What technologies are required to

accomplish system function and performance? What new

method algorithms or processes are required and what is

their development risk? How will these technologies affect

cost?

Technical feasibility is frequently the most difficult area to

assess at this stage of the product engineering process.

Because objectives functions and performance are

somewhat hazy anything seems possible if the right



assumptions are made. It is essential that the process of

analysis and definition to be conducted in parallel with an

assessment of technical feasibility.

The considerations those are normally associated with

technical feasibility include:

Development Risk :

Can the system element to design so that necessary

function and performance are achieved within the

constraints uncovered during analysis?

Resource Availability: Are skilled staff available to develop

the system element in question are the other necessary

resources (hardware and software) available to build the

system?

Technology: Has the relevant technology progressed to astate that will support the system?

The considerations that are normally associated with

technical feasibility include development risk, resource

availability and technology.

Operational Feasibility:out by a small group of people who are familiar

with It is mainly related to human organizational and

political aspects. The points to be considered are:



1) What changes will be brought with the system?

2) What organizational structures are disturbed?

3) What new skills will be required?

Do the existing staff members have these skills? If not, canthey be trained in due course of time?

This feasibility study is carried information system

techniques, who understand the parts of the business that

are relevant to the project and are skilled in system

analysis and design process.

From Office management point of view it is operationally

feasible because workload also reduced and they can

utilize their valuable time in other value addition

activities. Proposed System is beneficial only if that can

termed into information system that will meet the

operating requirements of the organization. This test of

feasibility asks if the system will work when it si

developed and installed.

This is an important question that would help us perceive

any resistance that might come form the end user

community. Top management is committed to this project

and is highly supportive. End user community has

been suffering from the ill effects of the existing system

and perceives that the proposed system would ease their

work. There was no resistance from the employees for the



proposed system as they were happy to learn that the

manual system is bight automated.

End user community was tiered getting a lashing from their

management that they are not providing right and the

accurate information. They have spent countless nights in

re-working to providing accurate information. However, the

problem of timeliness still persists. The users of the

proposed system welcomed the change as they knew that

the new system would bring right, useful information as and

when required.

Economical Feasibility :

Economic analysis is the most frequently used method for

evaluating the effectiveness of a candidate system. More

commonly known as cost/benefit analysis, the procedureis to determine the benefit s and savings that are

expected from a candidate system and compare them

with costs. If benefits outweigh costs, then the decision is

made to design and implement the system. This is an

ongoing effort that improves in accuracy at each phase of

the system life cycle.

Cost-Benefit Analysis:-



Cost benefit analysis is complicated by criteria that very

with the characteristics of the system to be developed the

relative size of the project and the expected return on

investment desired as part of a company’s strategic plan.

In addition many benefits derived from computer based

system are ignitable (e.g. better design quality through

iterative intimation, increase customer satisfaction throw

programmable control, and better business, decisions

through reformatted and pre-analysis sales data ). Direct

quantities comparisons may be difficulty to achieve.

In a nutshell the following steps are

are to be followed:

1) To study the existing system

2) To define the scope of the proposed system.

3) To study the strengths and weakness of the existingsystem.

4) To study various alternatives.

5) To carry out feasibility studies

6) To get the management approvals.



PROJECT SCHEDULING

The identification of needs of the project is really a typical

job. It is very necessary to identify all the needs of the

system at beginning otherwise the whole purpose of

developing the projects becomes useless.

To identify the needs we went through a long process of

interviewing the personal of the company’s or the

candidates who seek the jobs and we asked a lot many

question to understand the requirements.We put up anti

questions so that personal or candidates could tell us what

they know by their own. We then through that in reference

of the computer are working and managed the needs so

that they can be fulfilled in an easy and comfortable

manner.

It is very important to think the needs keeping in mind the

efficiency and easy implementation. We tried our best to

convert the requirements in form of the software so that

user of the software can get the complete benefits.



The need of the software is created because everything is

going very fast..

Project Planning &

Development

DEVELOPER & DESIGNER:-

VINITA MAHESHWARI

PRATIBHA KALYA

TITLE OF PROJECT:-

Hotel Management System

Plan and Schedule for execution of Project:-

Starting Date :- 25th

DECEMBER, 09



society. Medicine, law enforcement, government,

banking, education, transportation,

planning – these are only some of the fields in which

computers are already playing the

highly significant role. Over the next few years you can

expect a vast increase in the

range of computer applications and a corresponding

increase in the effect computers will

have on our daily lives.

OBJECTIVES OF THE PROJECT

The main objectives of system for Hotel Management

System are:


2. System should be fully automated.3. System should provide concrete security features like


system.

4. System should be capable to keep track of all the detailed

descriptions of the client and the whole details of services

offered by the client organization.

5. Various outputs (reports) should be available online any

time..

6. System should be able to handle extremely large volumes

of data (i.e. Large database support)







system.

10. System should be capable to keep track of all the

detailed descriptions of the client and the whole details of

services offered by the client organization.

HARDWARE SOFTWARE REQUIERMENT

OPERATING SYSTEM: Windows XP.

FRONT END: Visual Basic 6.0

BACK END: MS-Access.



Analysis Document

Software Requirement

Specification (SRS)

1. Objective :

The objective of Hotel Management System is to help the

organization in automating the whole manual processing of the

existing system.

2. Introduction of S/W Requirement :

As the system is based on a set of complex

mathematical calculations, a high level of accuracy is

maintained throughout the whole processing. Manual

calculations are error prone and are sometimes very time &

resource consuming.

The main aim is thus to make the results accurate, fast andwith a minimum stress on the designer/end user.

3. Information description :



The main objective to develop the system is to

make the accurate & efficient decisions in different tasks at

different time at different situations. The existing system is

manual so members of the unit generally face a lot of

embarrassing situations many times. Now they need toautomate the whole process so as to make it more easy and

accurate.

As they need to expand their work and hence their

workload shall increase so they require a reliable, efficient

and supportive system. Different people who are working

under the organization handle their different tasks. Hence,

to perform all the functions under one system is required.Gathering relevant information from various people was not

an easy task. It took a lot of time to understand their

working, as they were not able to explain everything

properly.

4. Functional Description:

In this system we record customer Check in,

Check out, reservation information date wise as well as

employee information also. Different type of food and their

price are also recorded. Order delivery and their calculation

is also recorded .Salary calculation is maintained in this

system.

5. Behaviour description :

Different type of Changes made in this system can

automatically update the record store in database. We can



make update item in this system .Enquiry perform by

customer is shown by this system when it is valid.

6. Validation Criteria :

This system read only that data which is valid input entry.

Blank entry is not allowed in this system and numeric data is

valid only for numeric entry.

Software Process Models

To solve actual problems in an industry setting, a

software engineer or a team of engineers must incorporate a

development strategy that encompasses the process, methods

and tools.

A process model for software engineering is chosen based on the

nature of the project and application, the methods and tools to beused, and the controls and deliverables that are required.

Among the various available Software Process Models (Waterfall

model, Spiral model, Prototyping model, etc) the best suited for

this project is the Prototyping Model

Prototyping Model

Often, a customer defines a set of

general objectives for software but does not identify detailed input,

processing, or output requirements. In other cases, the developer



may be unsure of the efficiency of an algorithm, the adaptability of

an operating system, or the form that human-machine interaction

should take. In these and many other situations, a prototyping

paradigm may offer the best approach.

The prototyping paradigm begins with requirementsgathering. Developer and customer meet and define the overall

objectives for the software, identify whatever requirements are

known, and outline areas where further definition is mandatory. A

“quick design” then occurs.

The quick design focuses on a representation of those

aspects of the software that will visible to the customer/user

(e.g., input approaches and output formats). The quick design

leads t the construction of a prototype. The prototype is

evaluated by the customer/user and is used to refine

requirements for the software to be developed. Iteration occurs

as the prototype is tuned to satisfy the needs of the customer, at

the same time enabling the developer to better understand what

needs to be done.

Ideally, the prototype serves as a mechanism for identifying

software requirements. If a working prototype is built, the

developer attempts to make use of existing program fragments

or applies tools (e.g., report generators, window manager, etc.)

that enable working programs to be generated quickly.



DFD (DATA FLOW DIAGRAM)

Data Flow Diagrams:

Data Flow Diagrams (DFD), also known as bubble chart. It is

used for the purpose of clarifying system requirements and

identifying the major transformation that will become program in

system design, so it is a starting point of the designing phase that

functionally decomposes the requirements specification down tothe lower level of details. A Data Flow Diagram consists of series

of bubbles joined by lines. The bubbles represent the data

transformation and the line represents the data flow in the

system.

Data Flow Diagram Symbols: There are four types of

symbols that are used to design DFD, these are:

1) A SQUARE: A Square defines a source and the destination

of the system Data.

2 ) AN ARROW : An Arrow identifies the Data Flow.

3) A CIRCLE or BUBBLE : A Circle or Bubble represents

the process that transforms incoming Data Flow into outgoing

Data Flow.

4) OPEN RECTANGLE: It represents Data Storage.



The Project entitled “HOTEL MANAGEMENT SYSTEM” is also

designed to solve the purpose of clarifying system requirements

and identifying the major transformation in an Institute related to

their Students, Books issue,

So, Data Flow Diagram plays a major role that

functionally decomposes the requirements

specification down to the lower level of details

andhelps in presenting an effective and efficient

system for Client.

The following level one data flow diagram

characterizes the types of inputs and outputs

and the interactions that the staff may expect

from the hotel reservation system.

Level One Data Flow Diagram



Breakdown of the SystemModules

A more detailed analysis of the modules that will be involved

in creating a functional hotel management system revealsthe need to break the larger system down into a series of

sub modules. Each of these sub modules has a well defined

interface and a series of precise input and output

requirements. The following level two data flow diagram

breaks down the system more precisely into its component

modules.



Level Two Data Flow

Diagram



The following textual description of the

major system Features and functions

further illustrates the information needs

and the output of the various modules

depicted in the level two dataflowdiagram.



OPNING A NEW ROOM

CHECK IN OF A NEW CUSTOMER



RECORD MODIFICATION



CHECK OUT A NEW

CUSTOMER



LISTING OF CUSTOMER



GENRATING BILL OF CUSTOMER



LIST OF ALL RECORDS



E-R Diagram

Entity-relationship model

The entity-relationship model or entity-relationship diagram

(ERD) is a data model or diagram for high-level descriptions of

conceptual data model, and it provides a graphical notation for



representing such data models in the form of entity-relationship

diagrams.

Such models are typically used in the first stage of

information-system design; they are used, for example, to

describe information needs and/or the type of information that is

to be stored in the database during the requirement analysis.

The datamodelling technique, however, can be used to

describe any ontology (i.e. an overview and classifications of

used terms and their relationships) for a certain universe of

discourse (i.e. area of interest).

In the case of the design of an information system that

is based on a database, the conceptual data model is, at a later

stage (usually called logical design), mapped to a logical data

model, such as the relational model; this in turn is mapped to a

physical model during physical design. Note that sometimes, both

of these phases are referred to as "physical design".

There number of conventions for entity-relationship diagrams

(ERDs). The classical notation is described in the remainder of

this article, and mainly relates to conceptual modeling. There are

a range of notations more typically employed in logical and

physical database design

HOTEL CUSTOMER



Bibliography

BOOK NAME AUTHOR



Mastering Of Envangelos Petroutsos(BPB

Visual basic Publication)Screen

Of

Layou

t

database



Login Table (HMS.MDB)



Reservation Table (HMS.MDB)



CHECK IN TABLE (HMS.MDB)



CHECK OUT TABLE (HMS.MDB)



EDIT ENTRY TABLE (HMS.MDB)



Make Payment Table (HMS.MDB)



EMPLOYEE TABLE

(HMS.MDB)



Staff Payroll Table (HMS.MDB)



Design Document Database document is the process of

producing a detailed data model of a database.

This model contains all the needed

logical and physical design choices and

physical storage parameters needed to

generate a design in a Data Definition

Language, which can then be used to create a



database. A fully attributed data model

contains detailed attributes for each entity.

The term database design can be used to

describe many different parts of the design of

an overall database system. Principally, andmost correctly,

it can be thought of as the logical

design of the base data structures used to

store the data - in the relational model these

are the table and view. However, the term

database design could also be used to apply tothe overall process of designing, not just the

base data structures, but also the forms and

queries used as part of the overall database

application within the Database Management

System or DBMS.

Source Code



Moduel Form

Public cn As New ADODB.Connection

Public rs As New ADODB.Recordset

Public Sub main()

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " _

& App.Path & ".\HMS.mdb;Persist Security Info=False"

frmwelcome.Show

End Sub

Welcome Form



Coding of Welcome Form

Option expiclit

Private Sub Form_Load()

pb.Value = 0

End Sub

Private Sub Timer1_Timer()

If pb.Value < 100 Then

pb.Value = pb.Value + 0.5

Else

Unload Me



frmlogin.Show

End If

End Sub

Login Form



Coding of Login Form

Option Explicit

Private Sub Command2_Click()

Unload Me

End Sub

Private Sub cmdok_Click()

If txtusername.Text = "" And txtpassword.Text = "" Then

MsgBox " Enter UserName and Password"

Else

If txtusername.Text = rs.Fields(0).Value And txtpassword.Text

= rs.Fields(1).Value Then

mainfrm.Show

Unload Me



Exit Sub

Else

MsgBox "Invalid Username or Password, try again!",

vbCritical, "Login"

txtusername.Text = ""

txtpassword.Text = ""

txtusername.SetFocus

End If

End If

End Sub


rs.Open "select * from Login", cn, adOpenKeyset,

adLockOptimistic

End Sub

Private Sub Form_Unload(Cancel As Integer)

rs.Close

End Sub



Main MDI Form

Coding of Menu Form

Private Sub calu_Click()

Shell "calc"

End Sub

Private Sub charges_Click()

frmcharges.Show

End Sub



Private Sub check_Click()

frmcheckin.Show

End Sub

Private Sub chekout_Click()

frmcheckout.Show

End Sub

Private Sub chngpass_Click()

frmChangepassword.Show

End Sub

Private Sub custreport_Click()

DataReport1.Show

End Sub

Private Sub edit_Click()

frmeditentry.Show

End Sub

Private Sub emp_Click()

frmsearchemprecord.Show

End Sub

Private Sub emply_Click()

frmemployee.Show

End Sub

Private Sub empreport_Click()



DataReport2.Show

End Sub

Private Sub Form_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As

Single)

Label1.BackColor = &HFF8080

Label1.ForeColor = vbWhite













End Sub

Private Sub exit_Click()

End

End Sub



Private Sub guest_Click()

frmSearchGuest.Show

End Sub

Private Sub Label1_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As

Single)

Label1.BackColor = vbWhite

Label1.ForeColor = &HFF8080

End Sub

Private Sub Label1_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As

Single)

If Button = vbLeftButton Then

PopupMenu guests, vbPopupMenuLeftAlign, 500, 3500

End If

End Sub


Single)



End Sub


Single)


PopupMenu empl, vbPopupMenuLeftAlign, 2000, 3500

End If

End Sub


Single)





End Sub


Single)


PopupMenu sear, vbPopupMenuLeftAlign, 3890, 3500

End If

End Sub


Single)



End Sub


Single)


PopupMenu view, vbPopupMenuLeftAlign, 5700, 3500

End If

End SubPrivate Sub Label5_MouseMove(Button As Integer, Shift As Integer, X As Single,

Y As Single)



PopupMenu rep, vbPopupMenuLeftAlign, 8400, 3500

End Sub


Single)





End Sub


Single)


PopupMenu util, vbPopupMenuLeftAlign, 9800, 3500

End If

End Sub

Private Sub Label7_Click()

End

End Sub


Single)



End Sub

Private Sub Make_Click()

frmMakepayment.Show

End Sub

Private Sub not_Click()

Shell "notepad"

End Sub

Private Sub pmtreport_Click()

DataReport3.Show



End Sub

Private Sub res_Click()

frmrservation.Show

End Sub

Private Sub stafpay_Click()

frmstaffpayroll.Show

End Sub

Private Sub status_Click()

frmstatushotel.Show

End Sub

Reservation Form



Coding of Reservation

Form

Option Explicit

Dim i As Integer

Public Sub Blank()

txtname.Text = ""

txtaddress.Text = ""

txtcity.Text = ""

txtState.Text = ""

txtCountry.Text = ""



txtcompany.Text = ""

txtdesignation.Text = ""

txttelephone.Text = ""

cboRoomType.ListIndex = -1

cboRoomNo.ListIndex = -1

txtadvance.Text = ""

End Sub

Private Sub cboRoomType_Click()

If cboRoomType.List(cboRoomType.ListIndex) = "Single Room"

Then

For i = 1 To 50

cboRoomNo.AddItem Str(i)

Next

End If

If cboRoomType.List(cboRoomType.ListIndex) = "Double

Room" Then

For i = 51 To 100


Next

End If

If cboRoomType.List(cboRoomType.ListIndex) = "Deluxesuite

Room" Then

For i = 100 To 150




Next

End If

If cboRoomType.List(cboRoomType.ListIndex) = "Suiter Room"

Then

For i = 150 To 20


Next

End If

End Sub

Private Sub cmdAdd_Click()

If txtname.Text = "" Then

MsgBox "fill the name"

txtname.SetFocus

Exit Sub

End If

If txtaddress.Text = "" Then

MsgBox "fill the address"

txtaddress.SetFocus

Exit Sub

End If

If txtcity.Text = "" Then

MsgBox "fill the city"



txtcity.SetFocus

Exit Sub

End If

If txtState.Text = "" Then

MsgBox "fill the state name"

txtState.SetFocus

Exit Sub

End If

If txtCountry.Text = "" Then

MsgBox "fill the country name"

txtCountry.SetFocus

Exit Sub

End If

If txtcompany.Text = "" Then

MsgBox "fill the company name"

txtcompany.SetFocus

Exit Sub

End If

If txtdesignation.Text = "" Then

MsgBox "fill the Designation"

txtdesignation.SetFocus

Exit Sub

End If



If cboRoomType.Text = "" Then

MsgBox "select the room type"

cboRoomType.SetFocus

Exit Sub

End If

If txtadvance.Text = "" Then

MsgBox "fill the advanced payment"

txtadvance.SetFocus

Exit Sub

End If

If cboRoomType.ListIndex = -1 Then

MsgBox "Select Room Type"


Exit Sub

ElseIf cboRoomNo.ListIndex = -1 Then

MsgBox "Select Room No."

cboRoomNo.SetFocus

Exit Sub

End If

rs.AddNew

rs.Fields(1).Value = txtname.Text

rs.Fields(2).Value = txtaddress.Text

rs.Fields(3).Value = txtcity.Text

rs.Fields(4).Value = txtState.Text



rs.Fields(5).Value = txtCountry.Text

rs.Fields(6).Value = txtcompany.Text

rs.Fields(7).Value = txtdesignation.Text

rs.Fields(8).Value = txttelephone.Text

rs.Fields(9).Value = DTPicker1

rs.Fields(10).Value = cboRoomType.Text

rs.Fields(11).Value = cboRoomNo.Text

rs.Fields(12).Value = txtadvance.Text


rs.Update

Call Blank

MsgBox "save the existing record"

txtname.SetFocus

End Sub

Private Sub cmdcancel_Click()

Unload Me

End Sub

Private Sub DTPicker1_Change()

DTPicker1.Value = DTPicker1

End Sub


DTPicker.Value = DTPicker2



End Sub


rs.Open "select * from Reservation", cn, 3, 2

End Sub


rs.Close

End Sub

Check In Form



Coding of Check In Form

Option Explicit

Dim i As Integer

Public Sub Blank()

txtname.Text = ""


txtcity.Text = ""

txtState.Text = ""








cboRoomNo.ListIndex = -1


End Sub



Then

For i = 1 To 50


Next

End If


Room" Then

For i = 51 To 100


Next

End If


Room" Then

For i = 100 To 150


Next

End If




Then

For i = 150 To 20


Next

End If

End Sub


If txtname.Text = "" Then

MsgBox "fill the name"

txtname.SetFocus

Exit Sub

End If

If txtaddress.Text = "" Then

MsgBox "fill the address"

txtaddress.SetFocus

Exit Sub

End If

If txtcity.Text = "" Then

MsgBox "fill the city"

txtcity.SetFocus

Exit Sub

End If

If txtState.Text = "" Then



MsgBox "fill the state name"

txtState.SetFocus

Exit Sub

End If

If txtCountry.Text = "" Then

MsgBox "fill the country name"

txtCountry.SetFocus

Exit Sub

End If

If txtcompany.Text = "" Then

MsgBox "fill the company name"

txtcompany.SetFocus

Exit Sub

End If

If txtdesignation.Text = "" Then

MsgBox "fill the Designation"

txtdesignation.SetFocus

Exit Sub

End If

If cboRoomType.Text = "" Then

MsgBox "select the room type"




Exit Sub

End If

If txtadvance.Text = "" Then

MsgBox "fill the advanced payment"

txtadvance.SetFocus

Exit Sub

End If

If cboRoomType.ListIndex = -1 Then

MsgBox "Select Room Type"


Exit Sub

ElseIf cboRoomNo.ListIndex = -1 Then

MsgBox "Select Room No."

cboRoomNo.SetFocus

Exit Sub

End If

rs.AddNew

rs.Fields(1).Value = txtname.Text

rs.Fields(2).Value = txtaddress.Text

rs.Fields(3).Value = txtcity.Text

rs.Fields(4).Value = txtState.Text

rs.Fields(5).Value = txtCountry.Text

rs.Fields(6).Value = txtcompany.Text

rs.Fields(7).Value = txtdesignation.Text



rs.Fields(8).Value = txttelephone.Text


rs.Fields(10).Value = cboRoomType.Text

rs.Fields(11).Value = cboRoomNo.Text

rs.Fields(12).Value = txtadvance.Text

rs.Update

Call Blank

'rs.MoveNext

MsgBox "save the existing record"

txtname.SetFocus

End Sub


Unload Me

End Sub


DTPicker1.Value = DTPicker1

End Sub


rs.Open "select * from Chkin", cn, adOpenKeyset,adLockOptimistic

End Sub




rs.Close

End Sub

Private Sub lbldate_Click()

lbldate.Caption = Date

End Sub

Private Sub Timer1_Timer()

lbldate.Caption = Datelbltime.Caption = Time

End Sub



Checkout Form

Coding of CheckOut Form

Option Explicit

Public Sub Blank()

cboGuID.ListIndex = -1

txtname.Text = ""


txtcity.Text = ""



txtState.Text = ""





txtRoomType.Text = ""

txtRoomNo.Text = ""


'txtDOChkin.Text = ""

txtTOChkIn.Text = ""

txtBalance.Text = ""

txtTotalBill.Text = ""

End Sub

Private Sub cboGuID_Click()

cmddelete.Enabled = True

With RS_GuestIn

rs.MoveFirst

While Not .EOF

If cboGuID.List(cboGuID.ListIndex) = rs.Fields(1) Then

DTPicker1.Text = rs.Fields(0)

txtname.Text = rs.Fields(2)

txtaddress.Text = .Fields(3)

txtcity.Text = rs.Fields(4)

txtState.Text = rs.Fields(5)

txtCountry.Text = rs.Fields(6)

txtcompany.Text = rs.Fields(7)



txtdesignation.Text = rs.Fields(8)

txttelephone.Text = rs.Fields(9)

txtRoomType.Text = rs.Fields(10)

txtRoomNo.Text = rs.Fields(11)

Wend

End Sub


Unload Me

End Sub


rs.Open "select * from CheckOut_Table", cn, adOpenKeyset,

adLockOptimistic

Me.Top = 3000

Me.Left = 3000

lbldate.Caption = Date

lbltime.Caption = Time

While Not rs.EOF

cboGuID.AddItem rs.Fields(1)

rs.MoveNext

Wend

End Sub

Edit Entry Form



Coding of Edit Entry Form

Option Explicit

Dim StrSql As String

Dim i As Integer



Then

For i = 1 To 50


Next

End If




Room" Then

For i = 51 To 100


Next

End If


Room" Then

For i = 100 To 150


Next

End If


Then

For i = 150 To 20


Next

End If

End Sub

Public Sub RoomAdd1()


Then

RS_SingleRoom.MoveFirst



Smart_SingleRoom:

If cboRoomNo.List(cboRoomNo.ListIndex) =

RS_SingleRoom.Fields(0) Then

RS_SingleRoom.Delete

cboRoomNo.RemoveItem cboRoomNo.ListIndex

Else

RS_SingleRoom.MoveNext

GoTo Smart_SingleRoom

End If

ElseIf cboRoomType.List(cboRoomType.ListIndex) = "DoubleRoom" Then

RS_DoubleRoom.MoveFirst

Smart_DoubleRoom:


RS_DoubleRoom.Fields(0) Then

RS_DoubleRoom.Delete


Else

RS_DoubleRoom.MoveNext

GoTo Smart_DoubleRoom

End If

ElseIf cboRoomType.List(cboRoomType.ListIndex) = "Suite

Room" Then

RS_SuiteRoom.MoveFirst

Smart_SuiteRoom:




RS_SuiteRoom.Fields(0) Then

RS_SuiteRoom.Delete


Else

RS_SuiteRoom.MoveNext

GoTo Smart_SuiteRoom

End If

ElseIf cboRoomType.List(cboRoomType.ListIndex) = "Deluxe

Suite" Then

RS_DeluxeSuite.MoveFirst

Smart_DeluxeSuite:


RS_DeluxeSuite.Fields(0) Then

RS_DeluxeSuite.Delete


Else

RS_DeluxeSuite.MoveNext

GoTo Smart_DeluxeSuite

End If

End If

'.Update

End Sub



Public Sub LCK()

txtname.Locked = False

txtaddress.Locked = False

txtcity.Locked = False

txtState.Locked = False

txtCountry.Locked = False

txtcompany.Locked = False

txtdesignation.Locked = False

txttelephone.Locked = False

'txtRoomType.Locked = False

'txtRoomNo.Locked = False

txtadvance.Locked = False

txtDOChkin.Locked = False

txtTOChkIn.Locked = False

End Sub

Public Sub Blank()


txtname.Text = ""


txtcity.Text = ""

txtState.Text = ""







txtRoomType.Text = ""

txtRoomNo.Text = ""


txtDOChkin.Text = ""

txtTOChkIn.Text = ""

End Sub

Private Sub cboGuID_Click()

If cboGuID.ListIndex = -1 Then

cmdEdit.Enabled = False

Exit Sub

End If

cmdEdit.Enabled = True

With RS_Edit

.MoveFirst

While Not .EOF

If cboGuID.List(cboGuID.ListIndex) = .Fields(1) Then

txtDOChkin.Text = .Fields(0)

txtname.Text = .Fields(2)


txtcity.Text = .Fields(4)

txtState.Text = .Fields(5)

txtCountry.Text = .Fields(6)

txtTOChkIn.Text = .Fields(7)



txtcompany.Text = .Fields(8)

txtdesignation.Text = .Fields(9)

txttelephone.Text = .Fields(10)

txtRoomType.Text = .Fields(11)

txtRoomNo.Text = .Fields(12)

txtadvance.Text = .Fields(13)

End If

.MoveNext

Wend

End With

End Sub


If cboRoomType.ListIndex = 0 Then

cboRoomNo.Clear

Label3.Visible = False

cboRoomNo.Visible = False

Exit Sub

End If


Then

cboRoomNo.Clear

With RS_SingleRoom

.MoveFirst

i = 0



For i = 1 To .RecordCount

cboRoomNo.AddItem .Fields(0)

.MoveNext

Next

End With

ElseIf cboRoomType.List(cboRoomType.ListIndex) = "Double

Room" Then

cboRoomNo.Clear

With RS_DoubleRoom

.MoveFirst

i = 0



.MoveNext

Next

End With

ElseIf cboRoomType.List(cboRoomType.ListIndex) = "Suite

Room" Then

cboRoomNo.Clear

With RS_SuiteRoom

.MoveFirst

i = 0



.MoveNext

Next

End With



ElseIf cboRoomType.List(cboRoomType.ListIndex) = "Deluxe

Suite" Then

cboRoomNo.Clear

With RS_DeluxeSuite

.MoveFirst

i = 0



.MoveNext

Next

End With

End If

Label3.Visible = True

cboRoomNo.Visible = True

End Sub

Private Sub cmdCancel_Click()

Unload Me

End Sub

Private Sub cmdEdit_Click()

cmdUpdate.Enabled = True


LCK


cboRoomType.Visible = True




End Sub

Private Sub cmdUpdate_Click()

RS_Edit.MoveFirst

If cboRoomType.ListIndex >= 1 And cboRoomNo.ListIndex <>

-1 Then

StrSql = "UPDATE CheckIn_Table SET Name = '" &

txtname.Text & "'," _

& "Address = '" & txtaddress.Text & "'," _

& "City = '" & txtcity.Text & "'," _

& "State = '" & txtState.Text & "'," _

& "Country = '" & txtCountry.Text & "'," _

& "TOChk = '" & txtTOChkIn.Text & "'," _

& "Company = '" & txtcompany.Text & "'," _

& "Designation = '" & txtdesignation.Text & "'," _

& "Phone = '" & txttelephone.Text & "'," _

& "Advance = '" & txtadvance.Text & "', " _

& "DOChk = '" & txtDOChkin.Text & "', " _

& "RoomType = '" &cboRoomType.List(cboRoomType.ListIndex) & "', " _

& "RoomNo = '" &

cboRoomNo.List(cboRoomNo.ListIndex) & "' " _

& "WHERE GuID = '" &

cboGuID.List(cboGuID.ListIndex) & "';"



cnn.Execute StrSql

RS_Edit.Update

RoomAdd1

RoomAdd2

MsgBox "Record is Updated"

ElseIf cboRoomType.ListIndex <= 0 Then













& "RoomType = '" & txtRoomType.Text & "', " _

& "RoomNo = '" & txtRoomNo.Text & "' " _



cnn.Execute StrSql

RS_Edit.Update




ElseIf cboRoomType.ListIndex >= 1 And cboRoomNo.ListIndex

= -1 Then

MsgBox "Select Room Type & Room No", vbOKOnly +

vbInformation, "Information"


Exit Sub

End If

cmdUpdate.Enabled = False

Blank


cboRoomType.Visible = False




cboGuID.SetFocus

RS_Edit.Requery

End Sub


Me.Top = 3000

Me.Left = 3000

Connect

With RS_Edit

While Not .EOF



cboGuID.AddItem .Fields(1)

.MoveNext

Wend

End With







cboRoomType.AddItem "None"

cboRoomType.AddItem "Single Room"

cboRoomType.AddItem "Double Room"

cboRoomType.AddItem "Suite Room"

cboRoomType.AddItem "Deluxe Suite"

End Sub



Make Payment Form

Coding of MakePayment Form

Dim DOA As String

Dim result, i As Integer



Private Sub Combo1_Click()

With RS_Guest

.MoveFirst

While Not .EOF

If Combo1.List(Combo1.ListIndex) = .Fields(1) Then

Text1.Text = .Fields(2)



DOA = .Fields(0)

result = Date - CDate(DOA)

If result = 0 Then

result = 1

End If

If .Fields(11).Value = "Single Room" Then

Text4.Text = result * Rs_Rate.Fields(0)

Text5.Text = Text4.Text - Text2.Text

End If

If .Fields(11).Value = "Double Room" Then



End If

If .Fields(11).Value = "Suite Room" Then



End If

If .Fields(11).Value = "Deluxe Suite" Then





End If

End If

.MoveNext

Wend

End With

End Sub


With RS_Paymentlog

.MoveFirst

While Not .EOF

If Combo1.Text = .Fields(0) Then

.AddNew

.Fields(0) = Combo1.Text

.Fields(1) = Text1.Text





.Fields(8) = Val(Text3.Text) + Val(Text2.Text)


.Fields(10) = Date

.Fields(11) = UserName

.Update



End If

.MoveNext

Wend

End With

With RS_Payment

.MoveFirst

While Not .EOF


.Update






.Fields(8) = Val(Text3.Text) + Val(Text2.Text)


.Fields(11) = Date


End If

.MoveNext

Wend

End With

MsgBox "Payment Successfully Updated", vbOKOnly,

"Payment"

'Command2_Click

End Sub




Text1.Text = ""

Text2.Text = ""

Text3.Text = ""

Text4.Text = ""

Text5.Text = ""

Text6.Text = ""

Combo1.ListIndex = -1

Me.Hide

End Sub


Me.Top = 3000

Me.Left = 3000

Connect

With RS_Guest

.MoveFirst

While Not .EOF

Combo1.AddItem .Fields(1)

.MoveNext

Wend

End With

Combo2.AddItem "Accomodation"

Combo2.AddItem "Bar"

Combo2.AddItem "Laundry"



Combo2.AddItem "Restaurant"End Sub



EMPLOYEE MENU



EMPLOYEE DETAIL FORM

Coding of EmployeeDetail

Form

Option Explicit

'Variable Declaration

Dim str As String

Dim strMonth, result As String

Dim num, i As Integer

Public Sub Blank()



txtemployeename.Text = ""


txtcity.Text = ""

txtstate.Text = ""

txtpin.Text = ""

txtphone.Text = ""

txteduqualification.Text = ""


txtExp.Text = ""

cboDepartment.ListIndex = -1

End Sub


If txtemployeename.Text = "" Or txtaddress.Text = "" Or _

txtcity.Text = "" Or txtstate.Text = "" Or _

txtpin.Text = "" Or txtphone.Text = "" Or _

txteduqualification.Text = "" Or txtExp.Text = "" Then

MsgBox "Fill Complete Information", vbInformation,

"Information"

txtemployeename.SetFocus

Exit Sub

ElseIf cboDepartment.ListIndex = -1 Then

MsgBox "Select the department", vbInformation,

"Information"

cboDepartment.SetFocus

Exit Sub

Else



With rs

.AddNew

.Fields(0) = lblID.Caption

.Fields(1) = txtemployeename.Text

.Fields(2) = txtaddress.Text

.Fields(3) = txtcity.Text

.Fields(4) = txtstate.Text

.Fields(5) = txtpin.Text

.Fields(6) = txtphone.Text

.Fields(7) = lblDate.Caption

.Fields(8) = txteduqualification.Text

.Fields(9) = txtdesignation.Text

.Fields(10) = cboDepartment.List(cboDepartment.ListIndex)

.Fields(11) = txtExp.Text

.Update

MsgBox "Record Entered Successfully"

Blank

If .RecordCount = 0 Then

lblID.Caption = str & strMonth & "-" & num

Else

.MoveLast

i = .RecordCount

num = num + i


End If



End With

End If

End Sub

Private Sub cmdEdit_Click()

cmdUpdate.Enabled = True


LCK


cboRoomType.Visible = True


End Sub

Private Sub cmdUpdate_Click()

RS_Edit.MoveFirst

If cboRoomType.ListIndex >= 1 And cboRoomNo.ListIndex <>

-1 Then















& "RoomType = '" &

cboRoomType.List(cboRoomType.ListIndex) & "', " _

& "RoomNo = '" &

cboRoomNo.List(cboRoomNo.ListIndex) & "' " _



cnn.Execute StrSql

RS_Edit.Update

RoomAdd1

RoomAdd2


ElseIf cboRoomType.ListIndex <= 0 Then













& "RoomType = '" & txtRoomType.Text & "', " _



& "RoomNo = '" & txtRoomNo.Text & "' " _



cnn.Execute StrSql

RS_Edit.Update


ElseIf cboRoomType.ListIndex >= 1 And

cboRoomNo.ListIndex = -1 Then

MsgBox "Select Room Type & Room No", vbOKOnly +

vbInformation, "Information"


Exit Sub

End If


Blank






cboGuID.SetFocus

RS_Edit.Requery

End Sub


Unload Me

Me.Visible = False



End Sub


Me.Top = 3000

Me.Left = 3000

num = 100

str = "EmpID"

strMonth = Month(Date)

lblDate.Caption = Date

cboDepartment.AddItem "Front Office"

cboDepartment.AddItem "House Keeping"

cboDepartment.AddItem "Food & Beverage"

cboDepartment.AddItem "Security"

cboDepartment.AddItem "Maintenance"

cboDepartment.AddItem "Purchase & Stores"

cboDepartment.AddItem "Sales & Marketing"

Blank

With rs

If .RecordCount = 0 Then


Else

.MoveLast

i = .RecordCount

num = num + i




End If

End With

End Sub

Staff Payroll Form



Coding of Staff Payroll Form

Dim HW, HR, BS, TA, MA, GP As String

Dim TAX, PEN, SA, NP As String


With Rs_Details

.MoveFirst

While Not .EOF


Label4.Caption = .Fields(1)





End If

.MoveNext

Wend

End With

Text1.Text = ""

Text2.Text = ""

Text3.Text = ""

Text4.Text = ""

Text5.Text = ""

Text6.Text = ""

Text7.Text = ""

Text8.Text = ""

Text10.Text = ""

End Sub


With RS_Payroll

.MoveFirst

While Not .EOF













MsgBox "Record Already Exist for the month"

End If

.MoveNext

Wend

End With

End Sub


BS = Val(Text3.Text)

TA = Val(Text4.Text)

MA = Val(Text5.Text)

TAX = Val(Text7.Text)

PEN = Val(Text8.Text)

NP = Val(Text10.Text)

GP = BS + TA + MA

Text6.Text = GP

TAX = BS / 100 * 5

Text7.Text = TAX

NP = GP - TAX - Val(Text8.Text)

Text10.Text = NP

End Sub




Blank

Me.Hide

End Sub


If Text1.Text = "" Or Text2.Text = "" Or Text4.Text = "" Or

Text5.Text = "" Then

MsgBox "Pls Input the Required Fields", vbCritical

Exit Sub

End If

With RS_Payroll

.MoveFirst

While Not .EOF



MsgBox "U have already Processed Payment for this

Month", vbCritical, "Process Error"

Exit Sub

End If

End If

.MoveNext

Wend

.AddNew


.Fields(1) = Label4.Caption















.Fields(14) = Date


.Update

MsgBox "Payroll Record Successfully Updated", vbInformation,

"Update Record"

Blank

End With

End Sub


ResetPay.Show 1

End Sub




Me.Top = 3000

Me.Left = 3000

Connect

With Rs_Details

.MoveFirst

While Not .EOF

Combo1.AddItem .Fields(0)

.MoveNext

Wend

End With

Label4.Caption = ""

Label5.Caption = ""

Label7.Caption = ""

Combo2.AddItem "January"

Combo2.AddItem "February"

Combo2.AddItem "March"

Combo2.AddItem "April"

Combo2.AddItem "May"

Combo2.AddItem "June"

Combo2.AddItem "July"

Combo2.AddItem "August"

Combo2.AddItem "September"

Combo2.AddItem "October"

Combo2.AddItem "November"

Combo2.AddItem "December"



End Sub

Private Sub Text3_GotFocus()

If Text1.Text = "" Or Text2.Text = "" Then

MsgBox "Pls Enter values for the required fields for BasicSalary to be calculate", vbOKOnly

Exit Sub

Else

HW = Val(Text1.Text)

HR = Val(Text2.Text)

BS = Val(HW) * Val(HR)

Text3.Text = BS

End If

End Sub

Sub Blank()

Text1.Text = ""

Text2.Text = ""

Text3.Text = ""

Text4.Text = ""

Text5.Text = ""

Text6.Text = ""

Text7.Text = ""

Text8.Text = ""

Text10.Text = ""





Label4.Caption = ""

Label5.Caption = ""

Label7.Caption = ""

End Sub



SEARCH MENU



Public Sub FindX()

Dim Cnxn As New ADODB.Connection

Dim rstName As New ADODB.Recordset

Dim strCnxn As String

Dim strSQLTitles As String

Dim mark As Variant

Dim count As Integer

lblcount.Caption = ""

Set Cnxn = New ADODB.Connection

strCnxn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _

& App.Path & "\database\HMS.mdb;Persist Security

Info=False"

Cnxn.Open strCnxn

Set rstName = New ADODB.Recordset

strSQLTitles = "SELECT Name FROM CheckIn_Table"

rstName.Open strSQLTitles, Cnxn, adOpenStatic, adLockReadOnly,

adCmdTextcount = 0

rstName.Find "Name LIKE '" & txtName.Text & "%'"

Do While Not rstName.EOF

lstGuestName.AddItem rstName!Name

count = count + 1

mark = rstName.Bookmark

rstName.Find "Name LIKE '" & txtName.Text & "%'", 1,

adSearchForward, mark



Loop

If count = 0 Then

MsgBox "No Match Found", vbOKOnly + vbInformation,

"Information"

txtName.SetFocus

Else

lblcount.Caption = "Total Matches found " & count

End If

rstName.Close

Cnxn.Close

Set rstName = Nothing

Set Cnxn = Nothing

End Sub


Unload Me

End Sub

Private Sub cmdGo_Click()

lstGuestName.Clear

fraDetails.Visible = False

If txtName.Text = "" Then

MsgBox "Enter the name", vbOKOnly + vbCritical, "Error"

txtName.SetFocus



Exit Sub

End If

FindX

End Sub





Dim strSQLEmpName As String

Dim mark As Variant




strCnxn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _


Info=False"

Cnxn.Open strCnxn


strSQLEmpName = "SELECT * FROM Checkin_Table"

rstName.Open strSQLEmpName, Cnxn, adOpenStatic,

adLockReadOnly, adCmdText

count = 0

With rstName

.MoveFirst

While Not .EOF



lstGuestName.AddItem .Fields(2)

.MoveNext

Wend

count = .RecordCount

End With

If count = 0 Then


"Information"

txtName.SetFocus

Else


End If

rstName.Close

Cnxn.Close


Set Cnxn = Nothing

End Sub



Me.Top = 3000

Me.Left = 3000

Connect

lstGuestName.Clear

End Sub

Private Sub lstGuestName_Click()



With Rs_Detail

.MoveFirst

While Not .EOF

If lstGuestName.List(lstGuestName.ListIndex) = .Fields(2) Then














Text1.Locked = True

Text2.Locked = True

Text3.Locked = True

Text4.Locked = True

Text5.Locked = True

Text6.Locked = True

Text7.Locked = True

Text8.Locked = True

Text9.Locked = True



Text10.Locked = True




End If

.MoveNext

Wend

fraDetails.Visible = True

End With

End Sub

Searching the Employee Form



Coding of Searchin The

Employee Form

Option Explicit

Dim StrSql As String

Public Sub FindX()





Dim mark As Variant






strCnxn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="

_


Info=False"

Cnxn.Open strCnxn


strSQLEmpName = "SELECT Name FROM PresentEmp_Table"


adLockReadOnly, adCmdTextcount = 0

rstName.Find "Name LIKE '" & txtName.Text & "%'"

Do While Not rstName.EOF

lstEmpName.AddItem rstName!Name

count = count + 1

mark = rstName.Bookmark

rstName.Find "Name LIKE '" & txtName.Text & "%'", 1,

adSearchForward, mark

Loop

If count = 0 Then


"Information"

txtName.SetFocus

Else


End If



rstName.Close

Cnxn.Close


Set Cnxn = Nothing

End Sub


Unload Me

End Sub

Private Sub cmdGo_Click()

lstEmpName.Clear


If txtName.Text = "" Then

MsgBox "Enter the name", vbOKOnly + vbCritical, "Error"

txtName.SetFocus

Exit Sub

End If

FindX

End Sub


FindAll

End Sub





Me.Top = 3000

Me.Left = 3000

Call Connect

lstEmpName.Clear

End Sub

Private Sub lstEmpName_Click()

With Rs_Details

.MoveFirst

While Not .EOF

If lstEmpName.List(lstEmpName.ListIndex) = .Fields(1) Then

txtEmpNo.Text = .Fields(0)


txtcity.Text = .Fields(3)

txtstate.Text = .Fields(4)

txtpin.Text = .Fields(5)

txtphone.Text = .Fields(6)

txtDOJ.Text = .Fields(7)

txteduqualification.Text = .Fields(8)

txtdesignation.Text = .Fields(9)

txtDept.Text = .Fields(10)

txtExp.Text = .Fields(11)

End If

.MoveNext

Wend

fraDetails.Visible = True

End With



End Sub

Public Sub FindAll()





Dim mark As Variant




strCnxn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="

_


Info=False"

Cnxn.Open strCnxn


strSQLEmpName = "SELECT * FROM PresentEmp_Table"


adLockReadOnly, adCmdText

count = 0

With rstName

.MoveFirst

While Not .EOF

lstEmpName.AddItem .Fields(1)

.MoveNext



Wend

count = .RecordCount

End With

If count = 0 Then

MsgBox "No Match Found", vbOKOnly + vbInformation,"Information"

txtName.SetFocus

Else


End If

' clean up

rstName.Close

Cnxn.Close


Set Cnxn = Nothing

End Sub

VIEW MENU



Status of the Hotel Form



List of Rates of Room Form



Report of Employes Detail



Report of Customer Detail



Report of Payment Detail



Change Password Form



Notepad Form



TESTING

Software testing is the process of executingsoftware and comparing the observed behavior

to the desired behavior.Software testing is a

critical element of software quality assurance

and represents the ultimate review of

specification, design and code generation.The

increasing visibility of software as a systemelement and the a

ttendant ‘costs’ associated with a software

failure are motivating forces for well planned

through testing. The software must be tested

to uncover as many errors as possible before

delivery to the customer.

The software testing techniques provide

systematic guidance for designing tests that:

1) Exercise the internal logic of the

software components

2) Exercise the input and output domain

of the program to uncover errors In the



Program function, behavior and

performance.

Testing is the phase where the errorsremaining from all the pervious phases must

be detected. It is a critical element of the

software assurances and represents the

ultimate review of specification, design and

coding.

Testing Objective

Certain rules that we take as testing objectives

are:

1) Testing is a process of executing a

program with the intent of finding an error.

2) A good test case is one that has a high

probability of finding an as-yet-

undiscovered error.

3) A successful test is one that uncovers

as-yet-undiscovered error.

Software testing is of two types-

1) White Box Testing – knowledge of the

internal working of the item being tested



are used to select the test data. Concerned

with the internal operations of the software

system.

Various criteria of white box testing are-

a) Statement Coverage criteria

b) Edge Coverage Criteria

c)Path Coverage Criteria

d) Control structure Testing Criteria

2) Black Box testing- complementary approach to white box testing technique

which is performed at later stages in the

testing. Focuses on the functional

requirements of the software, for which a

set of inputs are provided to fully exercise

these functional requirements and toachieve the desired results.

Various techniques of black box testing are

–

a) graph based testing method

b) Equivalence Partitioning andBoundary value Analysis

c)Cause – Effect Graphing

d) Comparison Testing



systematic technique for constructing the

program structure while at the same time

conducting tests to uncover errors associated

with interfacing.

Approaches to integration testing-

Incremental and non incremental integration

strategies.

Incremental integration Testing Approach.

Top down Integration Testing.

Bottom up Integration Testing.

Regression Testing.

Smoke Testing.

Big Bang Integration Testing Approach.Improved Big Bang Integration Testing

Approach.

Validation testing-

Taking another turn outward on the spiral,we encounter validation testing where

requirements established as part of software

requirements are validated against the

software that has been constructed.



The Hotel Management System (HMS) is

for computerizing the work in a hotel. The

software take care of all the requirements of

an average hotel and is capable to provide

easy and effective storage of informationrelated to customer that come up to the hotel.

It generates various reports; which

provide Customers details including various

entities such as customer name, address proof

etc. And billing detail for hotel and restaurant.

hotel management system doc1

Documents