To install StudyMoose App tap and then “Add to Home Screen”
Save to my list
Remove from my list
A hotel is an establishment that provides paid lodging on a short-term basis. The provision of basic accommodation, in times past, consisting only of a room with a bed, a cupboard, a small table and a washstand has largely been replaced by rooms with modern facilities, including ensuite bathrooms and air-conditioning or climate control. The cost and quality of hotels are usually indicative of the range and type of services available. Due to the enormous increase in tourism worldwide during the last decades of the 20th century, standards, especially those of smaller establishments, have improved considerably.
Hotels are independently assessed in traditional systems and these rely heavily on the facilities provided. Today, most of the Hotels provide goods and services using computer system. It helps to perform task in an easy way with less time consumed. Some companies are become fully automated while others strive for the similar setting. Computer programmers develop things like computer system that the rest of us could use.
Verified writer
Proficient in: Management
5 (234)
“ Very organized ,I enjoyed and Loved every bit of our professional interaction ”
The computer programmers tell the users what to do. They make programs that users can easily use or understand. The advent of new technology gave rise to easy and hassle free interaction between and among humans. Whether it is in business, science or whatever task a person takes on the quality and speed of carrying it out are enhanced with automation at the core of this efficient. Today, many systems have used an automation process like using computer system, due to the efficient and accuracy. “Hotel Management and Services System” is a management and transaction processing system.
In this system there are more advantages rather than a manual Hotel Management System. 2
Project Context
Based on the research conducted, the proponents found out the problem of this study are: How will this system help the management and the staff to have an accurate service at the same time to monitor the records of the customers? This study intends to develop an Hotel Management System. This done by First, The existing system is evaluated. Deficiencies are identified. This is done by interviewing users of the system and consulting
with support personnel. Second, the new system requirements are defined. In particular, the deficiencies in the existing system is addressed with specific proposals for improvement. Next, the proposed system is designed. Plans are laid out concerning the physical construction, hardware, operating systems, programming, communications, and security issues. The new system is developed. The new components and programs are obtained and installed. Users of the system will be trained in its use, and all aspects of performance are tested. If necessary, adjustments will be made at this stage. And last, 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 costeffective 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. Users of the system should be kept up-to-date concerning the latest modifications and procedures.
Purpose and Description
The purpose of this study is to develop computerized and automated Hotel Management System for the Leyte Park Resort Hotel to overcome the most of the problems occurring in their existing system.
3
Existing system is based on manual work and all the process are done manually, so they maintain registers and files for recording all the details of the system. They maintain several registers for recording the entry of daily transactions such as guest check-in, reservation, checkout, etc.
They maintain the record of the guests so they keep each and every information regarding the guests in the guest master file. In the similar fashion they maintain the records of their bills so they keep each and every information regarding their bills details in the bills master file. They keep the bill Book or receipt Book to maintain the record for the fees collected by guest. Thus maintaining Staff information, Guest Information,
Visitors information, Check-in and Check-out information and all the things are done manually. As the growing trend in InfoTech World of computers need of accuracy, perfectness, speed and high memory data storage is a must. Each and every problem must be solved with a least amount of time and energy.
The manual system of “Leyte Park Resort Hotel” is to be computerized and automated in order to overcome the problems, which affects the existing manual system. Automating the existing system with the help of some programming language, database package ease the work of the system up to a great extent.
Generally, there has been a criterion to work on any job or task for a specific purpose. Nobody works without specific detailed information about the particular task he is performing. Thus, any transaction can be performed either customer admission or bills collection or check-in and check-out. In the automated system, the first screen of the system would be a welcome message and a list of menus. These menus contain the options of either the Front Desk or the Restaurant. Any transaction can be performed in Hotel Management and Services System i.e. routine 4
processes. After the transaction is completed the user can log off from the system by simply clicking the log-out button or quitting from the system.
Objectives
This study aims to solve the problems encountered by the existing system and to change the manual reservation. The system can be handy to the user in the following reasons: • Provide quick and efficient means for gathering the customer information along with their rooms, bills and finally the check-in and check-out.
• Automate the work such as gathering customer information, posting message, gathering staff information.
• Automate the different types of reports.
• Increase the security between the management and staff. • Lessen time consume.
• Highly integrate data.
• Spend less time in searching and retrieving of files.
• Create a backup of files in every successful transaction. Scope and Limitations
The “Hotel Management and Services System” of the organization is developed to overcome the most of the problems occurring in the manual system by automating the existing system. The features of the newly proposed computerized automated system are described in brief as below: After automating the system, the committee of the organization or the user of the system can finish their work in least amount of time and efforts. The automated system has many gains 5
and efforts, which the manual system can’t give, in any type of situations. In any manual system if we take, the main problem arising is to maintain the number of records and finding a particular record. In manual system the user has to note down the check-in and check-out of each and every guest which is very tedious task, but in the case of automatedsystem the user just has to enter once and automatically all the information about the guest or customers will be displayed and thus the user does not have to worry because all the work done is automatically and the system itself.
Computerized systems are most helpful in dealing with areas where database comes into the existence. A computer can hold large amount of data in its storage devices and it can operate at very high speed. The user can put the entire information in the computer and can be able to perform any type of task which when done manually is tedious and time consuming. The new system will have the facility to sort data according to any specific type on the basis of what the user wants in any order. Also with the help of automated system if the user wants to access any single user’s data from many users data he can automatically get the desired data of the desired guest or staff or bills details, etc. in a fraction of second which is again time saving and very quick. Some of the features of the proposed system are given below: • Maintaining the Database for guest, staff, inventory, services, check-in and checkout, etc.
• Removal of Data Redundancy.
• Data Consistency.
• Ordering of foods and services
• Menu driven interface.
• Ensure data security.
6
The main features of Hotel Management System are given below: 1. As computer can store large amount of data it is very useful to store information of such a large database. Any information regarding total number of guest in the Hotels. Also information regarding bills of each and every guest.
2. The passing of ordered foods and services can be easily apply to the guest and get total billing information of the guest in the checkout.
3. Inconsistency caused due to changes in the database is removed as a separate database can be maintained for total number of guest in the Hotels. So the database is directly updated in response to the any change taking place and we don’t have to go through all the forms once again.
4. Communication to other department through the system for easily passing and getting information.
7
Chapter II
REVIEW OF RELATED LITERATURE/SYSTEM
Some of the hotels still use paper as the main method for recording purposes such as check-in and check-out. However, this business operation method has many issues such as manual searching and calculating for the record and hence burdens the management staff. The Hotel Management System able the ease of management of the hotel.
Hotel Management System is the system that manages the customer’s data, staff data, sales and inventory and create reports for all transaction processes in the system that can use by the top management as reference for decision making and hence plan new business strategy to meet the business objectives as reference for decision making and hence plan new business strategy to meet the business objectives.
According to a website its said that “Hotel Management System is an ideal software solution for Hospitality Industry that can be used at hotels, motels, inns, resorts, lodges, hostel, military guest houses, ranch, suites, apartments, medical centers and bed, breakfast operations. Hotel Management System is a comprehensive software suite consisting of integrated modules for various aspects of hotel management. (http://www.hotelmanagementsystem.co.in)” With the power of technology nowadays, people get interested with computers. They tried to indulge themselves on it to have a productive result in a more efficient and time saving process. It is highly valued in institutions like business enterprises, schools, hospitals, government and non-government services. However, some of them are still using manual system. In this regard, we acknowledge the value of computerized system.
8
Chapter III
TECHNICAL BACKGROUND
The proponents want to know the reasons of hotel in using manual reservation. The proponents conduct a study towards the topic because they notice some of the hotel still use manual reservation. The study will emphasize the effects of using manual reservation and how a computerized and automated reservation will be substituted. Therefore, the proponents purported to find out how to increase the number of customer using computerized automated reservation. Interaction and individual stimulation have always been linked to the technological availability of the time and place. With the transition to an information-based society, computers and transactions have evolved from manual transaction. One of the solutions or alternatives to the problems that a hotel is facing, a system was being developed which can edit, delete, filter, monitor and store and secured the records of the customers.
Hotel Management and Services System is a transaction processing system that solves the problem encountered during the manual hotel reservation and billing. The computerized Hotel Management System aims to simplify the
manual hotel operations fastest and accurate. Database is shared thru Local Area Network (LAN). The proponents make use of some tools and techniques to build the project. The system uses Graphical User Interface (GUI) to help the user give instruction to the computer. The system once implemented it will solve the most common problems that the Hotel Management encounter.
9
Chapter IV
METHODOLOGY, RESULTS AND DISCUSSION
Requirements Analysis
PIECES CLASSIFICATION OF SYSTEM REQUIREMENTS
Non-Functional
Requirement
Type
Explanation
Performance
The performance of the system will depends on the available resources of the PCs used. The system can run smoothly on Windows XP Service Pack 2/Vista/7 with 32/64 bit and PC with recommended configuration. Recommended configuration for PC is 1 GHz or Faster processor, 1 GB DDR2 RAM , 300 MB Free Hard Disk or above that, plug and play monitor with 800x600 resolution and 256 colors or higher, keyboard, mouse. The configuration listed can give best and optimum result at instance during the working of the system. Information
The system can process informations needed by the the user such as Guest Information, Check-In, Reservation, Check-Out, Rooms, Staff Information, Inventory, Sales Information and Reports needed by the top management as reference for decision making and hence plan new business strategy to meet the business objectives.
Economy
Using manual system is time consuming and much more prone to human error and retrieving records can cost much time and effort. Using computerized system can gain more advantages by lessen the time and more effeciency in the
business operation thus can help to improve the servicing to the customer. Control
(and Security)
Security features of the system control the access rights of the user. The admin user can access all the settings in the system like changing the room rate, adding and edit staff, edit the price of the foods and services offered in the business, etc., While the normal user can only operate the system like checkin, check-out, reservation, add customer charges and record customers order. Efficiency
The new system will have the facility to sort data according to any specific type on the basis of what the user wants in any order. Also with the help of computerized system if the user wants to access any single user’s data from many users data he can automatically get the desired data of the desired guest or staff or bills details, etc. in a fraction of second which is again time saving and very quick.
Services
Any staff that registered system using their username and password can use the system. User types are classified into to 3 types which is the ADMIN, DESK CLERK and CASHIER. Each user has access rights control and settings which can be controlled by the ADMIN. Training and user manuals are available together with the system. The system designed as simple and easy-to-use interface this tool allows to train hotel staff in hours instead of days. 10
CAUSE AND EFFECT ANALYSIS
Cause and Effect Analysis System Improvement Objectives
Problems or
Opportunity
Causes and Effects System Objectives System Constraint
Difficulty in
Maintenance of
Records
It is very difficult to
maintain data record
in the system as
all the records are
entered in the register
or the respective
record books. There
are chances of the
record books or files
in which all the data
is kept may be torn
or wearied out or
some other damages
which results in the
destroyed data.
To provide an easy
and hassle free in
maintaining and
tracking the records.
Securing the records
by having backups
incase of system
failure.
Limited of
information to be
entered in the records
Time Consuming and
lack of efficiency
It is very time
consuming process
to write each and
every entry in the
database register.
Also it takes a lot of
time if all the entries
are repeated. In the
system processes such
as making different
type of reports,
preparing merit lists,
tedious calculations
are examples of time
consuming process in
the system.
To provide quick
and efficient means
for gathering the
customer information
along with their
rooms, bills,
reservation, check- in
and check-out.
Automate the
computing of bills,
different types of
reports and removal of
data redundancy.
Gathering info will
depends on the user
access rights in the
system
11
Requirement Documentation
1. Introduction
Leyte Park Resort Hotel Management and Services System is automated management software for Windows. It is a complete solution, beginning with selecting type of operation which is the hotel operation and the restaurant operation going to hotel reservations, check in/check out, ordering of foods, services and ending with billing and sales reports. The user interface is carefully optimized for high speed input and the prevention of
common mistakes. It’s designed for using on multiple computers, and contains reliable and secure authorization levels. For managers, there is a rich set of reports that shows a complete picture of hotel operations and life cycles: sales by room, sales by room type, sales orders in restaurants, payment methods, acquired services and automatic bill calculations.
By standardizing the entire hotel management process, the software radically improves quality of guest handling and accounting.
It’s easy to install and easy to use with a very user-friendly interface. This system will surely helps the business operation faster and more efficient. 1.1 Purpose
The proposed system is developed for the organization for the following purposes: • Centralize data and gain control over business practices. • Deliver consistent and efficient Customer service
• Make Informed, agile decision
• Reduction in operating costs and errors.
• Fully integrated
• Rapid return on investment
12
• Fast billing avoids queue.
• Powerful Reporting Capability
1.2 Background
The Resort is a major tourism & convention complex with its 6 hectare parkland nestled on a hill overlooking beautiful San Pedro Bay. It exudes the distinctive luxury of a hotel & the ambiance of a resort.
Inaugurated way back under the Marcos dictatorship, Leyte Park Resort Hotel in Tacloban City is now a mere shadow of its extravagant past. But some good parts remain.
Leyte Park Resort Hotel owned by Engr. Wilson Chan is conveniently located in the heart of Tacloban City, the Regional Capital of Eastern Visayas. It sits atop a hill overlooking the beautiful San Juanico Strait and San Pedro Bay. Tacloban City is just 55 minutes from Manila and 20 minutes from Cebu. 20 minutes drive by car from Airport.
All rooms have air conditioned, Cable TV, direct phone, shower/bath tub, work desk, double/ king size bed and mini-bar.
1.3 Scope
This study mainly focused on providing business application using computerized system that enables businesses to track services and aims to providea accurate and reliable process on every transaction especially in a hotel reservation. This study looked into a better impact of using technology today on how it affects our daily lives especially for being the customer. With this studies it can help to know the differences of using manual system to a computerized generation today, 13
prioritize is to prove and to give them the right information. 1.4 Definitions, Acronyms and Abbreviations
In order to provide the readers a clearer understanding of the terms used, the following terms are defined as how it is used in the study.
Administrator – This refers to the authorized person that has an access in updating the system.
Cashier - an official in an organization who is responsible for receiving and paying out money and keeping financial records
Customer – a person or company that buys goods or services. Database– is an integrated collection of logically related records or files which consolidates records into a common pool of data records that provides data for many applications. A database is a collection of information that is organized so that it can easily be accessed, managed, and updated.
Desk clerk– a hotel receptionist.
Function Room- Park of the hotel where held events such as meetings, conventions, conferences and other special occasions.
Guest - a customer of a hotel or restaurant.
HMSS– Hotel Management and Services System
LAN – Local Area Network
Microsoft Access– A database program created by Microsoft Corporation for windows based computer.
Computer Network - A system of two or more computers, terminals, and
communications devices linked by wires, cables, or a telecommunications system 14
in order to exchange data.
Reports – a detailed periodic account of a company’s activities, financial condition, daily guest accommodations that are presented to the owner.
Room- an area within a hotel that are rented by the customer for a limited period of time.
Room Types- This refers to the type of rooms that are been offered in the hotel. Room facilities depends on the room types.
Supervisor– the one who oversee and guide the work or activities of the employees. End-user– This term as used in the study are the desk clerk, cashier, and administrator who are validated user of the hotel management system. 1.5 References
http://www.hotelmanagementsystem.co.in
http://directrooms.com/philippines/hotels/leyte-park-resort-hotel-20918.htm http:/www.glinttech,com
http://www.abacre.com
2. General Project Description
Hotel Management and Services System is a computerized system designed using VB.NET 2010 and MS ACCESS for its back-end support or database. The functionalities of the Hotel Management System are divided into three categories, which are settings, operations and reporting. Settings are mainly configuring the price of the room, type of the room and other information. Hotel Management System also provides the operation functionalities. These operation functionalities 15
include room reservation, check-in, check-out, ordering of goods and sevrvices and other features. The top management of hotel can use the report generate by the Hotel Management System as reference for decision making and hence plan new business strategy to meet the business objectives. 3. Requirements and Constraints
3.1 Functional Requirements
Front Desk
• Reservation - Add customer reservation information
• Check-In - Add customer check-in information
• Check-Out - Retrieve customer information and update for check-out • Change Room - Transfer guest to other room
• Cancel Reservation - Customer’s reservation info will be deleted • Function Room Reservation - Add, Update, Delete entry for function room reservation
Monitoring
• Rooms - Monitor room status
• Guest - Monitor guest occupied in the hotel
• Over Stayed Guest - Monitor the status of guest.
• Inventory - Monitor the Sales, Facilities and Goods Inventory • Function Room - Monitor activities done in the function room. Administrator
• User Accounts - add, update, delete and set permission to the user of the • Staff Management - Add, Update, Delete Staff Informations 16
• Room Settings - Add, Update, Delete rooms, room types and room rates. • Extra Items - Add, Update, Delete extra items requested by customers • Discounts - Add, Delete discounts for the customer
• Restaurant - Edit settings for the restaurant
• Services - Add, Update, Delete services offered in the hotel Reports
• Daily Occupancy
• Reservation Report
• Inventory Report
• Staff Accomplishment Report
• Daily Sales Report
• Weekly Sales Report
• Monthly Sales Report
Restaurant
• Categories - Foods and Beverages Categories
• Items - Foods and Beverages available and arrange by its category • Ordered Foods - List of goods that ordered by the customer •
3.2 Non-Functional Requirements
System Security
• This features enable the user to lock the system for unauthorized user of
the system.
Database Backup
17
• This features enable the user to backup the database of the system to recover files incase of system crash due to virus or operating system failure. System Requirements Specifications
• Hardware Requirements of the system
There is a list of hardware materials used during the making and also during the use of the proposed system. As the new system to be made into a computerized functional system, requirement of a computer is must. All the hardware needed here are generally the basic configuration of a typical office computer. A list of the hardware requirement used in the system given below: Minimum Configuration:
To run the application software of the system in the computer the minimum configuration required is as below:
• 1 GHz Pentium® 4 processor or other compatible.
• 512 DDR2 RAM
• 500MB of available hard disk space
• A plug and play monitor with of 800 x 600 resolution and 256 colors • Keyboard.
• Mouse.
• Windows Compatible Printer
• DirectX 9 capable video card running at 800 x 600 resolution display • Modem, Router, UTP cable for LAN or wireless router for WAN Recommended Configuration:
18
The system can run on the above-mentioned system, however for perfectness and clearness it is recommended to use a computer system having the below listed configuration. The configuration listed below can give best and optimum result at instance during the working of the system. • 1.6 GHz or Faster processor
• 1GB DDR2 RAM
• 3GB of available hard disk space
• A plug and play monitor with of 1366 x 768 resolution and 256 colors • Keyboard.
• Mouse.
• Ink Jet/Laser Printers.
• DirectX 9 capable video card running at 1024 x 768 or higher-resolution display
• 500 V.A UPS. [Used in case of power failure]
• Modem, Router, UTP cable for LAN or wireless router for WAN (2) Software Requirements of the system
Along with the hardware, used in the system it requires software to make a system as well as to run a system with the computer hardware. Collection of different types of hardware into a specific type can form a computer but it cannot execute different process on its own. For efficient and proper working of any system software must be installed. These soft wares may be in the form of operating system or application software. To 19
run the system one also needs to use software.
Operating System:
• Windows XP (x86) with Service Pack 3 - all editions except Starter Edition
• Windows Vista (x86 & x64) with Service Pack 2 - all editions except Starter Edition
• Windows 7 (x86 & x64)
• Windows Server 2003 (x86 & x64) with Service Pack 2
• Windows Server 2003 R2 (x86 & x64)
• Windows Server 2008 (x86 & x64) with Service Pack 2
• Windows Server 2008 R2 (x64)
Application Softwares:
• Micosoft Access 2003/207/2010
• Microsoft DotNET Framework 3.5
4. Conclusion
The researchers had observed the importance of Computerized Hotel Management and Services System to Leyte Park Resort Hotel. The proposed system will be a very essential tool for such task. The said system as intended will be able to eliminate the manual work in the billing process of the said hotel.
4.1 Outstanding Issues
An that level of acceptability of the respondents on the output of the study is excellent and is highly recommended.
20
Design of Software, Systems, Product and/or Process
System:Hotel Reservation System Module: Existing Context Diagram Date: Process:Hotel Reservation System Level: 0
Prepared by:April Joy S. acaban, Rj D. Madia,
Jumar Val Guarino, Dion Rae De La Cruz
Existing Hotel
Reservation
System
0
Owner
Desk Personnel Customer
Customer’s Information
Payment, Purpose
Customer’s Information
Cash, Purpose
Receipt
Transaction
Reports,
List of Customer’s Accomodation
21
System:Hotel Reservation System Module: Existing Data Flow Diagram Date: Process:Check-In, Check-Out Level: 1
Prepared by:April Joy S. acaban, Rj D. Madia,
Jumar Val Guarino, Dion Rae De La Cruz
Verify Purpose
1.0
Customer Inquire Room
Rate and
Room Type
2.0
Desk
Personnel
Purpose Inquire Room Info.
Check-In
3.0
Room Usage
4.0
Record
Receipt
Update
Record
5.0
Room Info.
Check-Out
6.0
Desk
Personnel
Payment
Paid the bill
7.0
Customer Info.
22
System:Hotel Reservation System Module: Existing Flow Chart Date: Process:Hotel Reservation System Level:
Prepared by:April Joy S. acaban, Rj D. Madia,
Jumar Val Guarino, Dion Rae De La Cruz
Start
Verify
Customer’s
Purpose
Inquiry?
Inquiry of Room
Rate and Room Type
Yes
Check-In?
Verify Room
Availability
Yes
Room
Available?
Check-Out?
No
No
End
Fill-up Customer’s
Registration Form
Customer’s
Record
Record Customer’s
Information
Compute Bills
Accept Initial
Payment
Record Initial
Payment
Issue O. R.
Update Report
B
Customer Info.
Payment
Payment
O. R.
Report
B
Compute Bills
Accept Full
Payment
C
C A
A
Yes
No
23
System:Hotel Reservation System Module: Existing VTOC Date:
Process:Hotel Reservation System Level:
Prepared by:April Joy S. acaban, Rj D. Madia,
Jumar Val Guarino, Dion Rae De La Cruz
Hotel Reservation
System
0
Verify
Purpose
1.0
Inquire Room
Rate and
Room Type
2.0
Check-In
3.0
Room Usage
4.0
Update
Record
5.0
Check-Out
6.0
Paid the bill
7.0
24
System:Hotel Reservation System Module: Existing IPO Date:
Process:Hotel Reservation System Level:
Prepared by:April Joy S. acaban, Rj D. Madia,
Jumar Val Guarino, Dion Rae De La Cruz
Customer’s Information
Room Information
Verify Purpose
Inquire Room Rate and
Room Type
Check-In
Room Usage
Check-Out
Paid the bill
Payment,
Reports
Input Process Output
25
System:Hotel Management and Services System
Module: Proposed Context
Diagram
Date:
Process:Hotel Management and Services Level: 0
Prepared by:April Joy S. acaban, Rj D. Madia,
Jumar Val Guarino, Dion Rae De La Cruz
Hotel Management
and Services
System
0
Customer’s Information
Payment, Purpose
Customer’s Information
Cash, Purpose
Receipt Transaction
Reports,
List of Customer’s
Accommodation,
Staff Information
Desk
Personnel
Cashier
Owner
Customer
Supervisor
Other
Hotel Staff
Attendance,
Job Accomplishment
Staff Schedule of
Duties
Guest Information
Cash, Customer’s Ordered Goods
and Services, Inventory
Transaction
Staff
Accomplishment
Report
Staff Duties and Responsibilites
26
System:Hotel Management and Services System
Module: Proposed Data
Flow Diagram
Date:
Process:Staff Management Level: 1
Prepared by:April Joy S. acaban, Rj D. Madia,
Jumar Val Guarino, Dion Rae De La Cruz
Hotel Staff
(Cashier, Desk
Personnel,
Supervisor,
Other Staff)
Check
Attendance
1.0
Staff Info.
2.0
Go to the
area of
Responsibilities
duties and
responssibilities
Other Staff
Desk
Personnel
Cashier Supervisor
Perform Duties
and Functions as
Desk Clerk
3.0
Perform Duties
and Functions
as Restaurant
Cashier
4.0
Perform Duties
and Functions as
Supervisor
5.0
Perform Duties
and Functions as
Other Staff
6.0
duties and
responssibilities
duties and
responssibilities
duties and
responssibilities
duties and
responssibilities
27
System:Hotel Management and Services System
Module: Proposed Data
Flow Diagram
Date:
Process:Reservation, Check-In, Check-Out Level: 2
Prepared by:April Joy S. acaban, Rj D. Madia,
Jumar Val Guarino, Dion Rae De La Cruz
Customer’s Information
Payment, Purpose
Customer
Verify Purpose
3.1
Inquire Room and
Room Types
3.2
Room Info. Room Info. Desk
Personnel
from Process 3.0
Staff Info.
Reserve
Customer
3.3
Check-In
3.4
Check-Out
3.6
Add Additional
Items/Charges
3.5
Surrender Room
key and Compute
Bills
3.7
Payment
Customer
Room No.
Customer
Reservation
confirmation
Reservation confirmation
Customer
Items/Charges
Added
28
System:Hotel Management and Services System
Module: Proposed Data
Flow Diagram
Date:
Process:Ordering Foods Level: 2
Prepared by:April Joy S. Acaban, Rj D. Madia,
Jumar Val Guarino, Dion Rae De La Cruz
Customer’s Information
Customer
Inquire Items
4.1
Order Items
4.2
Ordered Items Payment
Cashier
from Process 4.0
Staff Info.
4.3
Print
Receipt
Receipt
29
Staff Informations
Supervisor Create Staff
Schedule of
Duties
5.1
Select Area of
Responsibilities
5.2
Owner
from Process 5.0
System:Hotel Management and Services System
Module: Proposed Data
Flow Diagram
Date:
Process:Staff Scheduling Level: 2
Prepared by:April Joy S. Acaban, Rj D. Madia,
Jumar Val Guarino, Dion Rae De La Cruz
Staff informations
Staff Info. together with
the schedule of duties and
area of responsibilities
Hotel Staff
(Cashier, Desk
Personnel,
Other Staff)
Schedule of duties and
area of responsibilities
30
Start
Select User Type
Administrator?
Input Username
and Password
User
Account
Desk
Personnel?
End
Found? Administrator A
Input Username
and Password
User
Account
Found? Desk Personnel A
Yes
Yes
No
Yes No
No
Cashier?
Input Username
and Password
Found? Cashier A
User
Account
No
No
A
System:Hotel Management and
Services System
Module: Proposed
Flowchart
Date:
Process:Login System Level:
Prepared by:April Joy S. Acaban,
Rj D. Madia, Jumar Val Guarino,
Dion Rae De La Cruz
31
Start
Select Transaction
View Room?
Yes
View Guest?
No
Check-In?
Display Guest
Information
Display Room
Information
A
A
A
Verify Room
Availability
Available?
A
Yes
Yes
No
Yes
No
Fill-up
Customer’s
Check-In Form
Save Customer’s
Info
Customer’s
Record
Customer’s Info
Compute Room
Usage
Select Type of
Payment
Credit Card?
Cheque
Cash?
Verify Credit
Card
Verify Cheque
Record Payment
B
Print Receipt Update Record
B D
Customer’s Info
Yes
Yes
Yes
No
No
Reservation?
Verify Room
Availability
Available? D
Get Customers
Information
Confirm
Reservation
Reservation
Record
Customer’s Info
D
1
No
No
C
No
Yes
Receipt
System:Hotel Management and
Services System
Module: Proposed
Flowchart
Date:
Process:Front Desk Transactions Level:
Prepared by:April Joy S. Acaban,
Rj D. Madia, Jumar Val Guarino,
Dion Rae De La Cruz
32
1
Add Additional
Items/Charges?
Customer’s
Information
Select Item to Add
Additional Item’s
Record
D
Check—Out?
Customer’s
Information
Compute Bills C
End
D
33
Start
Order Food
Items Hotel Guest?
Read Guest
Information
Dine-In?
Display Customer’s
Order List
Verify Customer
Order
Compute Bills
Select Type of
Payment
Credit Card?
Cheque
Cash?
Verify Credit
Card
Verify Cheque
Record Payment Print Receipt Update Record
C D
Yes
Yes
Yes
Receipt
Take-Out?
Verify Customer
Order
Prepare Ordered
Foods
Prepare Ordered
Foods
Pack Ordered Foods
A
A
Customer’s
Record
Yes
Yes
No
Yes
B
B
End
D
C
System:Hotel Management and
Services System
Module: Proposed
Flowchart
Date:
Process:Restaurant Transactions Level:
Prepared by:April Joy S. Acaban,
Rj D. Madia, Jumar Val Guarino,
Dion Rae De La Cruz
34
System:Hotel Management and Services System
Module: Visual Table of
Contents
Date:
Process: Hotel Management and Services Level:
Prepared by:April Joy S. Acaban, Rj D. Madia,
Jumar Val Guarino, Dion Rae De La Cruz
Hotel
Management and
Services System
SelectAreaof
Responsibilities
MakeStaff
Scheduleof
Duties
PrintReceipt OrderItems InquireItems
Verify Purpose
Inquire Room
and Room Types
Reserve
Customer
Check-In
AddAdditional
Items/Charges
Check-Out
SurrenderRoom
keyand
ComputeBills
Check Attendance
Go to the area of
Responsibilities
Perform Duties
and Functions as
Desk Clerk
Perform Duties
and Functions as
Restaurant Cashier
Perform Duties
and Functions of
Supervisor
Perform Duties
and Functions as
Other Staff
35
System:Hotel Management and Services System Module: Input Process Output Date: Process: Level:
Prepared by:April Joy S. Acaban, Rj D. Madia,
Jumar Val Guarino, Dion Rae De La Cruz
Customer’s Information
Room Information
Staff Activities
Customer Activities
Ordered Items
Items/Charges added
Payments
Check Attendance
Go to the area of
Responsibilities
Perform Duties and Functions
as Cahier, Desk Personnel,
Supervisor and Other Staff
Reserve Customer
Check-In
Add Additional
Items/Charges
Check-Out
Inquire Items
Order Items
Print Receipt
Create Staff Schedule of Duties
Select Area of Responsibilities
Daily, Weekly, Monthly
Sales Report
Daily Occupancy,
Reservations, Staff
Accomplishment
Report
Inventory Report
User’s Activity Log
Customer’s Receipt
List of Customer’s
Accomodation
Input Process Output
36
Development and Testing
Hotel Management and Services System is a transaction processing system that solves the problem encountered during the manual hotel reservation and billing. The computerized Hotel Management System aims to simplify the manual hotel operations fastest and accurate. Database is shared thru Local Area Network (LAN). The proponents make use of some tools and techniques to build the project. The system uses Graphical User Interface (GUI) to help the user give instruction to the computer. System testing happens through running all its function abilities in every field, forms, and the database of its tables that connect through the project of the system. Testing is the process of running a system with the intention of finding errors. Testing enhances the integrity of a system by detecting deviations in design and errors in the system. Testing aims at detecting error-prone areas. This helps in the prevention of errors in a system. Testing also adds value to the product by conforming to the user requirements. System testing is the stage of implementation. This is to check whether the system
works accurately and efficiently before live operation commences. Testing is vital to the success of the system. The candidate system is subject to a variety of tests: response rate, volume, stress, recovery, security and usability tests. A series of tests are performed for the proposed system is ready for user acceptance testing.
The Testing Steps are:
• Unit Testing
Unit testing focuses efforts on the smallest unit of software design. This is known as module testing. The modules are tested separately. The test is carried out during programming stage itself. In this step, each module is found to be working satisfactory as regards to the expected output from the module. 37
• Integration Testing
Data can be lost across an interface. One module can have an adverse effect on another, sub functions, when combined, may not be linked in desired manner in major functions. Integration testing is a systematic approach for constructing the program structure, while at the same time conducting test to uncover errors associated within the interface. The objective is to take unit tested modules and builds program structure. All the modules are combined and tested as a whole. • Validation
At the culmination of the integration testing, Software is completely assembled as a package. Interfacing errors have been uncovered and corrected and a final series of software test begin in validation testing. Validation testing can be defined in many ways, but a simple definition is that the validation succeeds when the software functions in a manner that is expected by the customer. After validation test has been conducted, one of the three possible conditions exists. a. The function or performance characteristics confirm to specification and are accepted.
b. A deviation from specification is uncovered and a deficiency lists is created. c. Proposed system under consideration has been tested by using validation test and found to be working satisfactory.
• Output Testing
After performing the validation testing, the next step is output testing of the proposed system, since no system could be useful if it does not produce the required output in a specific format. The output format on the screen is found to be correct. 38
The format was designed in the system design time according to the user needs. For the hard copy also; the output comes as per the specified requirements by the user. Hence output testing did not result in any correction for the system. • User Acceptance Testing
User acceptance of a system is the key factor for the success of any system. The system under consideration is tested for the user acceptance by constantly keeping in touch with the prospective system users at the time of developing and making changes whenever required.
This is done in regard to the following point:
a. Input Screen Design
b. Output Screen Design
c. Format of reports and other outputs.
• Security mechanisms
This system is provided with authentication without which no user can pass. So only the legitimate users are allowed to use the application. If the legitimate users share the authentication information then the system is open to outsiders. 39
LOG-IN FORM - Where the user type her/his username and password to enter the system. MAIN SCREEN (Front Desk)- Where the user select different menu in the system Description of the Prototype
40
Check-In Form- Where the user input customer information.
Reservation Form- For customer reservation form
41
Reservation Form- For customer reservation form
42
Implementation Plan
The implementation is the final and important phase. It involves user-training, system testing in order to ensure successful running of the proposed system. The user tests the system and changes are made according to their needs. The testing involves the testing of the developed system using various kinds of data. While testing, errors are noted and correctness is the mode. The conversion method of Implementation to be used in implementation of the system is Parallel conversion. Parallel conversion will be the best method to implement to ensure that all major problems in the new system have been solved before the old system is discarded. This will minimize the errors and conflicts of data and enables the end-user and the administrator to cope and to be familiarized with the new system.
Implementation Result
After studying and analyzing the flow of the proposed system, the proponents would like to recommend the following: The system proves to be fast accurate convenient, efficient and reliable for the process of reservation, check-in, check-out, ordering foods and services and managing staff. The proponents developed an automated system suitable for the hotel; the system could save time, effort in filling and monitoring.
43
Chapter V
RECOMMENDATIONS
Hotel Management and Services System has all the dynamic versatile features required to run hotel, and guest house business. Hotel Management and Services System offers an operational integration between reservations, guest history, reception/ front desk, Sales Ledger, and Reporting modules. Software has facility to generate report for analyzes your booking, check in and checkout status. Hotel Management and Services System is the best suit for managing hotel resources in very simple but effective manner with minimal efforts or time so that it increases your revenue. This study aims to change the current system that would be accurate for both customer and hotel management. The proponents use diagrams to implement the flow of the
proposed system. Based on the result of the researcher’s study, the following conclusions are given: First, the manual process of transaction is in accurate for the customer because of possible loss of records. Second, More consuming of time in filling forms and reports. 44
APPENDIX A
Letter of request for the Proponent
Engr. Wilson Chan
Proprietor
Leyte Park Resort Hotel
Magsaysay Boulevard, Tacloban City
Dear Sir/Ma’am:
Good day!
The undersigned are currently taking up System Analysis and Design. In relation to this, we are tasked to conceptualize a system that aims to improve the current system of your hotel. In order to meet the requirements of the subject, we decided to choose your hotel as the respondent of the study entitled “Leyte Park Resort Hotel Management and Services System”. We would like to ask your very kind approval to conduct the study to gather more information about the institution as the key elements of the study.
We are looking forward for your immediate response regarding this matter. Thank you very much.
Respectfully yours,
(SGD) APRIL JOY S. ACABAN
(SGD) DION RAE B. DE LA CRUZ
(SGD) JUMAR VAL N. GUARINO
(SGD) RJ D. MADIA
Noted by:
(SGD) ENGR. ARNOLD M. AGNER
Instructor Approved by:
(SGD) MRS. ARLENE CEBU (SGD) ENGR. WILSON CHAN
Dean, College of Computer Studies Proprietor
45
APPENDIX B
Relevant Source Good
Front Desk Form
Imports System.Net.WebRequestMethods
Imports System.Data.OleDb
Public Class frmFrontDesk
Dim stat As String
Sub FillListCheckout()
stat = “Check-In”
lvCheckout.Items.Clear()
connectdbase2()
Try
sql = “SELECT * FROM tblGuest WHERE status=’” & stat & “’ ORDER BY room_no ASC “ cmd = New OleDbCommand(sql, con)
dr = cmd.ExecuteReader
While dr.Read()
With lvCheckout
.Items.Add(CStr(dr(“room_no”)))
With .Items(.Items.Count - 1).SubItems
.Add(CStr(dr(“fname”)))
.Add(CStr(dr(“lname”)))
.Add(CStr(dr(“date_in”)))
.Add(CStr(dr(“date_out”)))
.Add(CStr(dr(“nights”)))
.Add(CStr(dr(“adult”)))
.Add(CStr(dr(“children”)))
.Add(CStr(dr(“total”)))
.Add(CStr(dr(“discount”)))
.Add(CStr(dr(“charges”)))
.Add(CStr(dr(“paid”)))
.Add(CStr(dr(“balance”)))
End With
End With
End While
Catch ex As Exception
MessageBox.Show(Err.Description, “Error”, MessageBoxButtons.OK,
MessageBoxIcon.Error) Finally
46
con.Close()
End Try
End Sub
Sub lv_settingsCheckout()
With lvCheckout.Columns
.Add(“Room No.”, 80)
.Add(“First Name”, 130)
.Add(“Last Name”, 130)
.Add(“Date In”, 140)
.Add(“Date Out”, 140)
.Add(“No. of Nights”, 100)
.Add(“Adult”, 70)
.Add(“Children”, 60)
.Add(“Total”, 60)
.Add(“Discount Type”, 80)
.Add(“Additional Charges”, 100)
.Add(“Paid”, 60)
.Add(“Balance”, 60)
End With
End Sub
Sub FillListReserve()
lvReserve.Items.Clear()
connectdbase2()
Try
If toolReservationList.Visible = False Then
sql = “SELECT * FROM tblReservation WHERE status=’Pending’ ORDER BY date_ reserve ASC “
Else
sql = “SELECT * FROM tblReservation ORDER BY date_reserve ASC “ End If
cmd = New OleDbCommand(sql, con)
dr = cmd.ExecuteReader
While dr.Read()
With lvReserve
.Items.Add(CStr(dr(“date_reserve”)))
With .Items(.Items.Count - 1).SubItems
.Add(CStr(dr(“res_no”)))
.Add(CStr(dr(“status”)))
.Add(CStr(dr(“room_no”)))
.Add(CStr(dr(“fname”)))
47
.Add(CStr(dr(“lname”)))
.Add(CStr(dr(“address”)))
.Add(CStr(dr(“phone1”)))
.Add(CStr(dr(“phone2”)))
.Add(CStr(dr(“date_arrival”)))
.Add(CStr(dr(“date_departure”)))
.Add(CStr(dr(“nights”)))
.Add(CStr(dr(“adult”)))
.Add(CStr(dr(“children”)))
.Add(CStr(dr(“total”)))
.Add(CStr(dr(“discount”)))
.Add(CStr(dr(“charges”)))
.Add(CStr(dr(“paid”)))
.Add(CStr(dr(“balance”)))
End With
End With
End While
Catch ex As Exception
MessageBox.Show(Err.ToString, “Error”, MessageBoxButtons.OK, MessageBoxIcon.Error) Finally
con.Close()
End Try
End Sub
Sub lv_settingsReserve()
With lvReserve.Columns
.Add(“Date Reserved”, 140)
.Add(“Reservation No.”, 140)
.Add(“Status”, 70)
.Add(“Room No.”, 60)
.Add(“First Name”, 130)
.Add(“Last Name”, 130)
.Add(“Address”, 200)
.Add(“Phone1”, 50)
.Add(“Phone2”, 50)
.Add(“Date of Arrival”, 140)
.Add(“Date of Departure”, 140)
.Add(“No. of Nights”, 65)
.Add(“Adult”, 40)
.Add(“Children”, 55)
.Add(“Total”, 100)
.Add(“Discount Type”, 100)
.Add(“Charges”, 100)
.Add(“Paid”, 100)
.Add(“Balance”, 120)
48
End With
End Sub
Sub likelname()
stat = “Check-In”
lvCheckout.Items.Clear()
connectdbase2()
Try
sql = “SELECT * FROM tblGuest WHERE status=’” & stat & “’ AND lname LIKE ‘” & txtSearchOut.Text & “%’”
cmd = New OleDbCommand(sql, con)
dr = cmd.ExecuteReader
While dr.Read()
With lvCheckout
.Items.Add(CStr(dr(“room_no”)))
With .Items(.Items.Count - 1).SubItems
.Add(CStr(dr(“fname”)))
.Add(CStr(dr(“lname”)))
.Add(CStr(dr(“date_in”)))
.Add(CStr(dr(“date_out”)))
.Add(CStr(dr(“nights”)))
.Add(CStr(dr(“adult”)))
.Add(CStr(dr(“children”)))
.Add(CStr(dr(“total”)))
.Add(CStr(dr(“discount”)))
.Add(CStr(dr(“charges”)))
.Add(CStr(dr(“paid”)))
.Add(CStr(dr(“balance”)))
End With
End With
End While
Catch ex As Exception
MessageBox.Show(ex.ToString, “Error”, MessageBoxButtons.OK, MessageBoxIcon.Error) Finally
con.Close()
End Try
End Sub
Sub likefname()
lvCheckout.Items.Clear()
connectdbase2()
Try
sql = “SELECT * FROM tblCheckin WHERE fname LIKE ‘” & txtSearchOut.Text & “%’” cmd = New OleDbCommand(sql, con)
49
dr = cmd.ExecuteReader
While dr.Read()
With lvCheckout
.Items.Add(CStr(dr(“room_no”)))
With .Items(.Items.Count - 1).SubItems
.Add(CStr(dr(“fname”)))
.Add(CStr(dr(“lname”)))
.Add(CStr(dr(“date_in”)))
.Add(CStr(dr(“date_out”)))
.Add(CStr(dr(“nights”)))
.Add(CStr(dr(“adult”)))
.Add(CStr(dr(“children”)))
.Add(CStr(dr(“total”)))
.Add(CStr(dr(“discount”)))
.Add(CStr(dr(“charges”)))
.Add(CStr(dr(“paid”)))
.Add(CStr(dr(“balance”)))
End With
End With
End While
Catch ex As Exception
MessageBox.Show(Err.Description, “Error”, MessageBoxButtons.OK, MessageBoxIcon.Error) Finally
con.Close()
End Try
End Sub
Sub likeroomno()
lvCheckout.Items.Clear()
connectdbase2()
Try
sql = “SELECT * FROM tblGuest WHERE room_no LIKE ‘” & txtSearchOut.Text & “%’” cmd = New OleDbCommand(sql, con)
dr = cmd.ExecuteReader
While dr.Read()
With lvCheckout
.Items.Add(CStr(dr(“room_no”)))
With .Items(.Items.Count - 1).SubItems
.Add(CStr(dr(“fname”)))
.Add(CStr(dr(“lname”)))
.Add(CStr(dr(“date_in”)))
.Add(CStr(dr(“date_out”)))
.Add(CStr(dr(“nights”)))
.Add(CStr(dr(“adult”)))
50
.Add(CStr(dr(“children”)))
.Add(CStr(dr(“total”)))
.Add(CStr(dr(“discount”)))
.Add(CStr(dr(“charges”)))
.Add(CStr(dr(“paid”)))
.Add(CStr(dr(“balance”)))
End With
End With
End While
Catch ex As Exception
MessageBox.Show(Err.Description, “Error”, MessageBoxButtons.OK, MessageBoxIcon.Error) Finally
con.Close()
End Try
End Sub
Sub likelnameReserve()
lvReserve.Items.Clear()
connectdbase2()
Try
If toolReservationList.Visible = True Then
sql = “SELECT * FROM tblReservation WHERE lname LIKE ‘” & txtSearchReserve.Text & “%’”
Else
sql = “SELECT * FROM tblReservation WHERE status=’Pending’ AND lname LIKE ‘” & txtSearchCancel.Text & “%’”
End If
cmd = New OleDbCommand(sql, con)
dr = cmd.ExecuteReader
While dr.Read()
With lvReserve
.Items.Add(CStr(dr(“date_reserve”)))
With .Items(.Items.Count - 1).SubItems
.Add(CStr(dr(“status”)))
.Add(CStr(dr(“room_no”)))
.Add(CStr(dr(“fname”)))
.Add(CStr(dr(“lname”)))
.Add(CStr(dr(“address”)))
.Add(CStr(dr(“phone1”)))
.Add(CStr(dr(“phone2”)))
.Add(CStr(dr(“date_arrival”)))
.Add(CStr(dr(“date_departure”)))
.Add(CStr(dr(“nights”)))
.Add(CStr(dr(“adult”)))
51
.Add(CStr(dr(“children”)))
.Add(CStr(dr(“total”)))
.Add(CStr(dr(“discount”)))
.Add(CStr(dr(“charges”)))
.Add(CStr(dr(“paid”)))
.Add(CStr(dr(“balance”)))
End With
End While
Catch ex As Exception
MessageBox.Show(ex.Message, “Error”, MessageBoxButtons.OK, MessageBoxIcon.Error) Finally
con.Close()
End Try
End Sub
Sub likefnameReserve()
lvReserve.Items.Clear()
connectdbase2()
Try
If toolReservationList.Visible = True Then
sql = “SELECT * FROM tblReservation WHERE fname LIKE ‘” & txtSearchReserve. Text & “%’”
Else
sql = “SELECT * FROM tblReservation WHERE status=’Pending’ AND fname LIKE ‘” & txtSearchCancel.Text & “%’”
End If
cmd = New OleDbCommand(sql, con)
dr = cmd.ExecuteReader
While dr.Read()
With lvReserve
.Items.Add(CStr(dr(“date_reserve”)))
With .Items(.Items.Count - 1).SubItems
.Add(CStr(dr(“status”)))
.Add(CStr(dr(“room_no”)))
.Add(CStr(dr(“fname”)))
.Add(CStr(dr(“lname”)))
.Add(CStr(dr(“address”)))
.Add(CStr(dr(“phone1”)))
.Add(CStr(dr(“phone2”)))
.Add(CStr(dr(“date_arrival”)))
.Add(CStr(dr(“date_departure”)))
.Add(CStr(dr(“nights”)))
.Add(CStr(dr(“adult”)))
52
.Add(CStr(dr(“children”)))
.Add(CStr(dr(“total”)))
.Add(CStr(dr(“discount”)))
.Add(CStr(dr(“charges”)))
.Add(CStr(dr(“paid”)))
.Add(CStr(dr(“balance”)))
End With
End With
End While
Catch ex As Exception
MessageBox.Show(ex.Message, “Error”, MessageBoxButtons.OK, MessageBoxIcon.Error) Finally
con.Close()
End Try
End Sub
Sub likeroomnoReserve()
lvReserve.Items.Clear()
connectdbase2()
Try
If toolReservationList.Visible = True Then
sql = “SELECT * FROM tblReservation WHERE room_no LIKE ‘” & txtSearchReserve.Text & “%’”
Else
sql = “SELECT * FROM tblReservation WHERE status=’Pending’ AND room_no LIKE ‘” & txtSearchCancel.Text & “%’”
End If
cmd = New OleDbCommand(sql, con)
dr = cmd.ExecuteReader
While dr.Read()
With lvReserve
.Items.Add(CStr(dr(“date_reserve”)))
With .Items(.Items.Count - 1).SubItems
.Add(CStr(dr(“status”)))
.Add(CStr(dr(“room_no”)))
.Add(CStr(dr(“fname”)))
.Add(CStr(dr(“lname”)))
.Add(CStr(dr(“address”)))
.Add(CStr(dr(“phone1”)))
.Add(CStr(dr(“phone2”)))
.Add(CStr(dr(“date_arrival”)))
.Add(CStr(dr(“date_departure”)))
.Add(CStr(dr(“nights”)))
.Add(CStr(dr(“adult”)))
53
.Add(CStr(dr(“children”)))
.Add(CStr(dr(“total”)))
.Add(CStr(dr(“discount”)))
.Add(CStr(dr(“charges”)))
.Add(CStr(dr(“paid”)))
.Add(CStr(dr(“balance”)))
End With
End With
End While
Catch ex As Exception
MessageBox.Show(ex.Message, “Error”, MessageBoxButtons.OK, MessageBoxIcon.Error) Finally
con.Close()
End Try
End Sub
Sub likedateReserve()
lvReserve.Items.Clear()
connectdbase2()
Try
If toolReservationList.Visible = True Then
sql = “SELECT * FROM tblReservation WHERE lname LIKE ‘” & txtSearchReserve. Text & “%’”
Else
sql = “SELECT * FROM tblReservation WHERE status=’Pending’ AND date_reserve LIKE ‘” & txtSearchCancel.Text & “%’”
cmd = New OleDbCommand(sql, con)
dr = cmd.ExecuteReader
While dr.Read()
With lvReserve
.Items.Add(CStr(dr(“date_reserve”)))
With .Items(.Items.Count - 1).SubItems
.Add(CStr(dr(“status”)))
.Add(CStr(dr(“room_no”)))
.Add(CStr(dr(“fname”)))
.Add(CStr(dr(“lname”)))
.Add(CStr(dr(“address”)))
.Add(CStr(dr(“phone1”)))
.Add(CStr(dr(“phone2”)))
.Add(CStr(dr(“date_arrival”)))
.Add(CStr(dr(“date_departure”)))
.Add(CStr(dr(“nights”)))
.Add(CStr(dr(“adult”)))
.Add(CStr(dr(“children”)))
54
.Add(CStr(dr(“total”)))
.Add(CStr(dr(“discount”)))
.Add(CStr(dr(“charges”)))
.Add(CStr(dr(“paid”)))
.Add(CStr(dr(“balance”)))
End With
End With
End While
End If
Catch ex As Exception
MessageBox.Show(ex.ToString, “Error”, MessageBoxButtons.OK, MessageBoxIcon. Error)
Finally
con.Close()
End Try
End Sub
Private Sub frmMain_FormClosed(ByVal sender As Object, ByVal e As System.Windows. Forms.FormClosedEventArgs) Handles Me.FormClosed
End
End Sub
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
statlblTime.Text = Format(Now, “Long Date”) & “ “ & TimeOfDay & “” End Sub
Private Sub hotel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) ‘frmHotel.Show()
End Sub
Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Timer1.Start()
timerChecker.Start()
lv_settingsCheckout()
lv_settingsReserve()
MyWebBrowser.Dock = DockStyle.Fill
Timer2.Start()
End Sub
Private Sub user_accounts_Click(ByVal sender As System.Object, ByVal e As
System. EventArgs)
frmUserAccounts.Show()
55
End Sub
Private Sub timerRefresh_Tick(ByVal sender As System.Object, ByVal e As System. EventArgs)
Me.Refresh()
End Sub
Private Sub staff_management_Click(ByVal sender As System.Object, ByVal e As System. EventArgs)
frmStaffView.Show()
End Sub
Private Sub ExitToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ExitToolStripMenuItem.Click
End
End Sub
Private Sub HelpToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles HelpToolStripMenuItem.Click
HelpToolStripMenuItem.ForeColor = Color.Black
End Sub
Private Sub SystemToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SystemToolStripMenuItem.Click
SystemToolStripMenuItem.ForeColor = Color.Black
End Sub
Private Sub SystemToolStripMenuItem_MouseLeave(ByVal sender As Object, ByVal e As System.EventArgs) Handles SystemToolStripMenuItem.MouseLeave SystemToolStripMenuItem.ForeColor = Color.White
End Sub
Private Sub SystemToolStripMenuItem_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles SystemToolStripMenuItem.MouseMove SystemToolStripMenuItem.ForeColor = Color.Black
End Sub
Private Sub HelpToolStripMenuItem_MouseLeave(ByVal sender As Object, ByVal e
As System.EventArgs) Handles HelpToolStripMenuItem.MouseLeave
HelpToolStripMenuItem.ForeColor = Color.White
End Sub
Private Sub HelpToolStripMenuItem_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles HelpToolStripMenuItem.MouseMove HelpToolStripMenuItem.ForeColor = Color.Black
56
End Sub
Private Sub ChangeDeskClerkToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ChangeDeskClerkToolStripMenuItem.Click Dim msg As Integer
msg = MessageBox.Show(“Are you sure you want to logout?”, “LOGOUT”, MessageBoxButtons.OKCancel, MessageBoxIcon.Question)
If msg = MsgBoxResult.Ok Then
frmLogin.Show()
Me.Hide()
End If
End Sub
Private Sub systemlock_Click(ByVal sender As System.Object, ByVal e As System. EventArgs)
Dim ask As Integer
ask = (MessageBox.Show(“The system will be locked, Proceed?”, “SYSTEM LOCK”, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning))
If ask = MsgBoxResult.Ok Then
Me.Text = “Leyte Park Resort Hotel - LOCKED”
frmSysLock.ShowDialog()
End If
End Sub
Private Sub LockToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LockToolStripMenuItem.Click
Dim ask As Integer
ask = (MessageBox.Show(“The system will be locked, Proceed?”, “SYSTEM LOCK”, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning))
If ask = MsgBoxResult.Ok Then
Me.Text = “Leyte Park Resort Hotel - LOCKED”
frmSysLock.ShowDialog()
End If
End Sub
Private Sub UserAccoutsToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles UserAccoutsToolStripMenuItem.Click frmUserAccounts.ShowDialog()
End Sub
Private Sub checkin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles checkin.Click
If checkin.Checked = True Then
frmCheckin.ShowDialog()
Else
57
frmCheckin.Close()
End If
End Sub
Private Sub CloudSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles CloudSearch.Click
txtSearch.Text = “”
End Sub
Private Sub CalculatorToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CalculatorToolStripMenuItem.Click
Shell(“calc”)
End Sub
Private Sub NewCheckInToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NewCheckInToolStripMenuItem.Click frmCheckin.ShowDialog()
End Sub
Private Sub reservation_Click(ByVal sender As System.Object, ByVal e As System. EventArgs) Handles reservation.Click
frmReservation.ShowDialog()
End Sub
Private Sub NewReservationToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
NewReservationToolStripMenuItem.Click frmReservation.ShowDialog()
End Sub
Private Sub Timer2_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer2.Tick
Me.Opacity = Me.Opacity + 0.1
If Me.Opacity = 1.0 Then
Timer2.Stop()
End If
End Sub
Private Sub close_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles menuclose.Click
End
End Sub
Private Sub changeuser_Click(ByVal sender As System.Object, ByVal e As System. EventArgs) Handles changeuser.Click
Dim msg As Integer
58
msg = MessageBox.Show(“Are you sure you want to logout?”, “LOGOUT”, MessageBoxButtons.OKCancel, MessageBoxIcon.Question)
If msg = MsgBoxResult.Ok Then
frmLogin.Show()
Me.Hide()
End If
End Sub
Private Sub RoomToolStripMenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RoomToolStripMenuItem1.Click
frmAddRoom.ShowDialog()
End Sub
Private Sub RoomTypeToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RoomTypeToolStripMenuItem.Click frmRType.ShowDialog()
End Sub
Private Sub DailySalesReportToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DailySalesReportToolStripMenuItem.Click frmDailyOccupancy.ShowDialog()
End Sub
Private Sub SystemBrowserToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SystemBrowserToolStripMenuItem.Click ‘btnAccept.Visible = True
toolWeb.Visible = True
MyWebBrowser.Visible = True
txtnav.Text = “http://www.google.com/”
Call gonav.PerformClick()
End Sub
Private Sub refreshweb_Click(ByVal sender As System.Object, ByVal e As System. EventArgs) Handles refreshweb.Click
MyWebBrowser.Refresh()
End Sub
Private Sub gonav_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles gonav.Click
MyWebBrowser.Navigate(txtnav.Text)
End Sub
Private Sub home_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles home.Click
MyWebBrowser.Navigate(“http://www.google.com/”)
59
txtnav.Text = “http://www.google.com/”
End Sub
Private Sub forwardnav_Click(ByVal sender As System.Object, ByVal e As System. EventArgs) Handles forwardnav.Click
MyWebBrowser.GoForward()
End Sub
Private Sub backnav_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles backnav.Click
MyWebBrowser.GoBack()
End Sub
Private Sub exitweb_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles exitweb.Click
‘btnAccept.Visible = False
MyWebBrowser.Visible = False
toolWeb.Visible = False
End Sub
Private Sub GoogleChromeToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles GoogleChromeToolStripMenuItem.Click Try
Shell(“C:UsersRJAppDataLocalGoogleChromeApplicationchrome.exe”) Catch ex As Exception
MessageBox.Show(“No Google Chrome Installed”, “Error”, MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try
End Sub
Private Sub MozillaFirefoxToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MozillaFirefoxToolStripMenuItem.Click Try
Shell(“C:Program FilesMozilla Firefoxfirefox.exe”)
Catch ex As Exception
Shell(“C:Program Files (x86)Mozilla Firefoxfirefox.exe”) End Try
End Sub
Private Sub InternetExplorerToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles InternetExplorerToolStripMenuItem.Click Shell(“C:Program FilesInternet Exploreriexplore.exe”) End Sub
Private Sub btnAccept_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) 60
Handles btnAccept.Click
gonav.PerformClick()
End Sub
Private Sub DiscountsToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DiscountsToolStripMenuItem.Click
frmDiscount.ShowDialog()
End Sub
Private Sub StaffManagementToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles StaffManagementToolStripMenuItem.Click frmStaffView.Show()
End Sub
Private Sub checkout_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles checkout.Click
btnCloseCancelReserve.PerformClick()
btnCloseReservationList.PerformClick()
FillListCheckout()
If checkout.Checked = True Then
toolCheckout.Visible = True
lvCheckout.Visible = True
lvCheckout.Dock = DockStyle.Fill
lvCheckout.BringToFront()
Else
toolCheckout.Visible = False
lvCheckout.Visible = False
lvCheckout.Dock = DockStyle.None
End If
End Sub
Private Sub ToolStripButtonClose_Click(ByVal sender As System.Object, ByVal e As System. EventArgs) Handles btnCloseCheckout.Click
checkout.Checked = False
toolCheckout.Visible = False
lvCheckout.Visible = False
End Sub
Private Sub lvCheckout_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lvCheckout.SelectedIndexChanged
If lvCheckout.SelectedItems.Count > 0 Then
With lvCheckout.SelectedItems(0)
roomno = .Text
fname = .SubItems(1).Text
61
lname = .SubItems(2).Text
charges = .SubItems(10).Text
advance_payment = .SubItems(11).Text
balance = .SubItems(12).Text
End With
End If
End Sub
Private Sub lvCheckout_MouseDoubleClick(ByVal sender As Object, ByVal e As System. Windows.Forms.MouseEventArgs) Handles lvCheckout.MouseDoubleClick If lvCheckout.SelectedItems.Count > 0 Then
With lvCheckout.SelectedItems(0)
roomno = .Text
fname = .SubItems(1).Text
lname = .SubItems(2).Text
total = .SubItems(8).Text
charges = .SubItems(10).Text
advance_payment = .SubItems(11).Text
balance = .SubItems(12).Text
End With
End If
connectdbase2()
Try
With cmd
.Connection = con
.CommandText = “SELECT * FROM tblRoom “ & _
“WHERE room_no=’” & roomno & “’”
End With
dr = cmd.ExecuteReader
dr.Read()
If roomno = “” Then
MessageBox.Show(“Select guest to checkout”, “Check-Out Failed”, MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
Else
If dr.HasRows = True Then
If MessageBox.Show(“Check-Out Guest?”, “Room “ & roomno, MessageBoxButtons.YesNo, MessageBoxIcon.Question) = vbYes Then frmPayment.ShowDialog()
End If
End If
End If
Catch ex As Exception
MessageBox.Show(Err.Description, “Error”, MessageBoxButtons.OK, MessageBoxIcon. Error)
62
Finally
con.Close()
End Try
End Sub
Private Sub ToolStripButtonCheckout_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCheckOut.Click
connectdbase2()
Try
With cmd
.Connection = con
.CommandText = “SELECT * FROM tblRoom “ & _
“WHERE room_no=’” & roomno & “’”
End With
dr = cmd.ExecuteReader
dr.Read()
If roomno = “” Then
MessageBox.Show(“Select guest to checkout”, “Check-Out Failed”, MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
Else
If dr.HasRows = True Then
If MessageBox.Show(“Check-Out Guest?”, “Room “ & roomno, MessageBoxButtons.YesNo, MessageBoxIcon.Question) = vbYes Then frmPayment.ShowDialog()
End If
End If
End If
Catch ex As Exception
MessageBox.Show(Err.Description, “Error”, MessageBoxButtons.OK, MessageBoxIcon.Error) Finally
con.Close()
End Try
End Sub
Private Sub ChargesToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ChargesToolStripMenuItem.Click
frmCharges.ShowDialog()
End Sub
Private Sub toolTxtSearch_TextChanged(ByVal sender As Object, ByVal e As System. EventArgs) Handles txtSearchOut.TextChanged
If ToolStripComboBox1.Text = “Last Name” Then
Call likelname()
ElseIf ToolStripComboBox1.Text = “First Name” Then
63
Call likefname()
ElseIf ToolStripComboBox1.Text = “Room No.” Then
Call likeroomno()
Else
Call FillListCheckout()
End If
End Sub
Private Sub ReservationListToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ReservationListToolStripMenuItem.Click btnCloseCheckout.PerformClick()
Call btnCloseCancelReserve.PerformClick()
toolReservationList.Visible = True
lvReserve.Visible = True
lvReserve.Dock = DockStyle.Fill
lvReserve.BringToFront()
FillListReserve()
End Sub
Private Sub ToolStripButton5_Click(ByVal sender As System.Object, ByVal e As System. EventArgs) Handles btnCloseReservationList.Click
toolReservationList.Visible = False
lvReserve.Visible = False
txtSearchReserve.Text = “”
comboReserve.Text = “”
End Sub
Private Sub txtSearchReserve_TextChanged(ByVal sender As Object, ByVal e As System. EventArgs) Handles txtSearchReserve.TextChanged
If comboReserve.Text = “Last Name” Then
Call likelnameReserve()
ElseIf comboReserve.Text = “First Name” Then
Call likefnameReserve()
ElseIf comboReserve.Text = “Room No.” Then
Call likeroomnoReserve()
ElseIf comboReserve.Text = “Date” Then
Call likedateReserve()
Else
Call FillListReserve()
End If
End Sub
Private Sub CancelReservationToolStripMenuItem_Click(ByVal sender As System.Object, 64
ByVal e As System.EventArgs) Handles CancelReservationToolStripMenuItem.Click btnCloseCheckout.PerformClick()
Call btnCloseReservationList.PerformClick()
FillListReserve()
toolCancelReserve.Visible = True
lvReserve.Visible = True
lvReserve.Dock = DockStyle.Fill
lvReserve.BringToFront()
End Sub
Private Sub btnCloseCancelReserve_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCloseCancelReserve.Click
toolCancelReserve.Visible = False
lvReserve.Visible = False
txtSearchCancel.Text = “”
comboCancel.Text = “”
End Sub
Private Sub txtSearchCancel_TextChanged(ByVal sender As Object, ByVal e As System. EventArgs) Handles txtSearchCancel.TextChanged
If comboCancel.Text = “Last Name” Then
Call likelnameReserve()
ElseIf comboCancel.Text = “First Name” Then
Call likefnameReserve()
ElseIf comboCancel.Text = “Room No.” Then
Call likeroomnoReserve()
ElseIf comboCancel.Text = “Date” Then
Call likedateReserve()
Else
Call FillListReserve()
End If
End Sub
Private Sub lvReserve_MouseDoubleClick(ByVal sender As Object, ByVal e As System. Windows.Forms.MouseEventArgs) Handles lvReserve.MouseDoubleClick If toolReservationList.Visible = True Then
If lvReserve.SelectedItems.Count > 0 Then
With lvReserve.SelectedItems(0)
cr_resno = .Text
End With
End If
End If
65
End Sub
Private Sub lvReserve_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lvReserve.SelectedIndexChanged
If lvReserve.SelectedItems.Count > 0 Then
With lvReserve.SelectedItems(0)
cr_datereserve = .Text
cr_resno = .SubItems(1).Text
cr_stat = .SubItems(2).Text
cr_roomno = .SubItems(3).Text
cr_fname = .SubItems(4).Text
cr_lname = .SubItems(5).Text
End With
End If
End Sub
Private Sub btnCancelReservation_Click(ByVal sender As System.Object, ByVal e As System. EventArgs) Handles btnCancelReservation.Click
frmCancelReserve.ShowDialog()
End Sub
Private Sub timerChecker_Tick(ByVal sender As System.Object, ByVal e As System. EventArgs) Handles timerChecker.Tick
Dim CountVacant, CountReserved, CountOccupied, CountClean As Integer connectdbase2()
sql = “SELECT * FROM tblRoom WHERE room_stat=’Vacant’” da = New OleDbDataAdapter(sql, con)
da.Fill(ds, “hmsdb”)
sql2 = “SELECT * FROM tblRoom WHERE room_stat=’Reserved’” da2 = New OleDbDataAdapter(sql2, con)
da2.Fill(ds2, “hmsdb”)
sql3 = “SELECT * FROM tblRoom WHERE room_stat=’Occupied’” da3 = New OleDbDataAdapter(sql3, con)
da3.Fill(ds3, “hmsdb”)
sql4 = “SELECT * FROM tblRoom WHERE room_stat=’Clean’” da4 = New OleDbDataAdapter(sql4, con)
da4.Fill(ds4, “hmsdb”)
con.Close()
66
CountVacant = ds.Tables(“hmsdb”).Rows.Count
statusVacant.Text = “Vacant: (“ & CountVacant & “)”
CountReserved = ds2.Tables(“hmsdb”).Rows.Count
statusReserved.Text = “Reserved: (“ & CountReserved & “)” CountOccupied = ds3.Tables(“hmsdb”).Rows.Count
statusOccupied.Text = “Occupied: (“ & CountOccupied & “)” CountClean = ds4.Tables(“hmsdb”).Rows.Count
statusClean.Text = “Clean: (“ & CountClean & “)”
ds.Clear()
ds2.Clear()
ds3.Clear()
ds4.Clear()
timerChecker.Stop()
End Sub
Private Sub timerChecker2_Tick(ByVal sender As System.Object, ByVal e As System. EventArgs) Handles timerChecker2.Tick
Dim CountOccupied, CountClean As Integer
sql = “SELECT * FROM tblRoom WHERE room_stat=’Occupied’” da = New OleDbDataAdapter(sql, con)
da.Fill(ds, “hmsdb”)
sql2 = “SELECT * FROM tblRoom WHERE room_stat=’Clean’” da2 = New OleDbDataAdapter(sql2, con)
da2.Fill(ds2, “hmsdb”)
con.Close()
CountOccupied = ds.Tables(“hmsdb”).Rows.Count
statusOccupied.Text = “Occupied: (“ & CountOccupied & “)” CountClean = ds2.Tables(“hmsdb”).Rows.Count
statusClean.Text = “Clean: (“ & CountClean & “)”
ds.Clear()
ds2.Clear()
timerChecker2.Stop()
67
End Sub
Private Sub CheckOutToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CheckOutToolStripMenuItem.Click
checkout.PerformClick()
End Sub
Private Sub ToolStripButton1_Click(ByVal sender As System.Object, ByVal e As System. EventArgs) Handles ToolStripButton1.Click
frmChangeRoom.ShowDialog()
End Sub
Private Sub ChangeRoomToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ChangeRoomToolStripMenuItem.Click frmChangeRoom.ShowDialog()
End Sub
Private Sub OrderCategoriesToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OrderCategoriesToolStripMenuItem.Click frmRestaurantCategories.ShowDialog()
End Sub
Private Sub OrderItemsToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OrderItemsToolStripMenuItem.Click frmRestaurantItems.ShowDialog()
End Sub
Private Sub btnOpen_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOpen.Click
End Sub
End Class
68
APPENDIX D
Sample Input/Output Reports
Daily Occupancy Report
Form
Output
69
Reservation Report
Form
Output
70
APPENDIX E
USERS GUIDE
I. Introduction
Leyte Park Resort Hotel Management and Services System is automated management software for Windows. It is a complete solution, beginning with selecting type of operation which is the hotel operation and the restaurant operation going to hotel reservations, check in/check out, ordering of foods, services and ending with billing and sales reports. The user interface is carefully optimized for high speed input and the prevention of common mistakes. It’s designed for using on multiple computers, and contains reliable and secure authorization levels. II. Manual
A. The Manual System
First of all in START MENU window you need to select between the two options the Front Desk (Server) and the Veranda Cafe Restaurant (Client) after
that, in Login window select user type and then enter your user name and password. User name is a worker’s user name (login). Password is a worker’s password.
When you first time run Hotel Management Services System you need to enter the default user name: admin and password: admin and user type is administrator. After that you should define users and change administrators password.
Front Desk is the server of the system. Here you can access the configuration of the system. Note that you should have an administrator’s access rights to access all configurations in the system. 71
Administrators -There are sub modules under the main module Administrators. • User Accounts Configuration- Note that you should have an administrator’s access rights to access items configuration.
To set up User Accounts configuration click Administrator > User Accounts. Here you can manage the user accounts for the suer of the system. Each user account has it’s user name, password, full name of the user.
• Staff Configuration
To set up Staff configuration Click Administrator > Staff>.. Staff Configuration has its sub modules the Department and Position where you can add, edit, delete Departments and Positions. Each Staff has it’s Employee ID, Last Name, First Name, M.I., Gender, Addresses, Contact No., Department, and Position.
Choose the Staff from the list and click Edit button to access to the staff’s profile. If you wish to add a new staff to the list of all staff, click Add button. To delete a staff from the list, first of all choose that worker and then click Delete button.
• Rooms Configuration
To set up Rooms configuration you first need to add Room Types. To add Room Types Click Administrator > Add Room > Room Type . Each Room Type has it’s own Room Type Name, Number of Persons, Room Description. After filling the Room Types. You can now add Rooms. To do add Room, Click Administrator > Room > Add Room. Each Room has it’s own Room No., Room Type, Rate, Number of Persons, Room Description. Note that you should have an administrator’s access rights to access items configuration. • Function Hall Configuration
The function room is where the events are held such as meetings, conventions, conferences 72
and other special occasions.
To set up Function Hall configuration click Administrator > Function Hall. Each Function Hall has it’s Name of Events, Contact Person, Schedule, No. of Pax, Rate. • Items and Charges Configuration
To set up Items and Charges configuration click Administrator > Extra Items/Charges. Each Item/Charges has it’s Item/Charges name, item quantity, rate. To add a item or charges click Add button. Enter Item/Charges attribute and press save. New Item/Charges will be added to the list of all existing items/charges. Also you can edit item/ charges’ attributes by clicking Edit button. To delete an item/charges from the list of all existing items click Delete button or use Delete key on your keyboard. • Discounts Configuration
To set up Discounts configuration click Administrator > Discounts. Each Discounts has it’s discount type, discount rate.
• Services Configuration
To set up Services configuration click Administrator > Services. Here you add, edit, delete services. Each Services has it’s name or type of service and price.
• Restaurant Configuration
To set up Restaurant configuration click Administrator > Restaurant Configuration. Here you can add, edit, delete and view items for the Restaurant. Each has it’s category, price and ingredients.
73
B. The computer system
1. Terminal/Keyboard Familiarization
Users should have a basic knowledge about computer in order for them to fully recognize what the system could give. Basic computer skills like opening the computer, opening a browser and etc.
2. First-time end users
a. Getting Started
This is the first step in a series that show you how to use Hotel Management and Services System. This tutorial steps you through the process of setting up the system. This allows you to set your regional information, charges and room information.
When you run the application first, you will select between the Front Desk and Cafe Veranda Restaurant Menu and then in the Login window the system will ask you for the User name, Password and User Type.
b. Lessons
User Accounts
This is the to create a new User. There is the User Accounts button under Administrator Menu, click on that, fill the information, select the permission admin, front desk, or cashier and save them. Here the admin and desk clerk/cashier permissions are different as admin has the full authority in the program to change the configuration or to create new user’s account or authority but in the desk clerk/cashier account there are no such authorities. Desk clerk/cashier can simply use the configured program.
74
ROOM CONFIGURATION :
Room configuration has just two things to configure i.e. room price and room type. To configure these two follow these steps:
• Click on Administrator menu and go to Add Room Type.
• Fill the entries Room Type (as Single Room, Deluxe etc), Maximum Persons and Room Description and save.
• Now go to Administrator > Room and select Add Room.
• Now Give the Room No., Select Room Type and Room Rate (price for staying for 24 hours) then save it. You can also edit and delete these entries.
RESTAURANT CONFIGURATION:
Restaurant Configuration has just also two things to configure i.e. items category and items. To configure these two follow these steps:
• Click on Administrator menu and go to Items Category
• Fill the entries Category No. and Category Name then save it. • Now go to Administrator > Restaurant Settings and select Items. • Now Give the Item Name., Select Item Category and Item Price then save it. You can also edit and delete these entries.
C. Reference Manual
1. Open the Executable File “Hotel Management System.exe” 2. Select Operation “Front Desk or Restaurant”
3. Selecting the Front Desk will open the Login Form for Front Desk 75
4. Input the valid username and password in the Login Form
5. In the Front Desk selecting Desk Clerk user type you can Check-In, Check-Out, Reserve Customer, Change Room, View Report and other functions. Selecting Administrator you can access the configurations of the system.
6. Selecting the Restaurant will open the Login form for the Restaurant and there you can input username and password for the cashier.
7. In the Restaurant you can select orders of the customers according to there categories. 76
APPENDIX F
PROCESS/DATA/INFORMATION FLOW
Reserve by
Reservation
Customer
Guest
Customer_ID
First Name
Last Name
Middle
Name
Address
Contact_No
Name
Books
Room
Room_no
Room_Type
Room Type
Type_ID
Name
Room Price
Manage By
Pays
Payment_ID
Cutomer_ID
Room_NO
Reservation
Status
Reservation_ID
Payments
Cutomer_ID
Reservation_ID
Payment_ID
Amount
Collect
Cashier
Cutomer_ID
Payment_ID
Manage By
System User
User_ID Password
Username
Admin
Handled By
77
APPENDIX G
CURRICULUM VITAE
Rj Dejolde Madia
Rj Dejolde Madia was born on the 28th day of June in the year 1989, in Tacloban City. He is the 3rd child of the four children of Mr. Ruben S. Madia Sr. and Mrs. Josephine C. Madia. He lives at Brgy. 88, Baloc 1, San Jose, Tacloban City.
He began his first education in San Jose Central School, Tacloban City in the year 1995. His secondary education was in San Jose National High School, Tacloban City graduated in the year 2005. He finished 2-year Computer Programming Dual Training System Course at Leyte Technological Foundation College. And currently, he is a third year Bachelor of Science in Information Technology (BSIT) student of ACLC College Tacloban. He attended trainings and seminars such as Seminar in Computer Networking (March 15, 2007), Leyte Samar IT Summit (Sept. 07 2012),
78
CURRICULUM VITAE
April Joy S. Acaban
April Joy S. Acaban was born on the 12th day of April in the year 1992. , in Calbiga Western Samar. She is the eldest daughter of Mr. Vivencio C. Acaban and Mrs. Rosemarie S. Acaban. She lives at Brgy.Patong Calbiga, Samar.
She graduated in elementary in Patong Elementary School in the year of 2005-2006. Her secondary education was in Calbiga National High School graduated in the year of 2008-2009. She is a Third year Bachelor of Science in Information Technology (BSIT) student of ACLC College Tacloban.
She attended trainings and seminars such as Seminar Leyte Samar IT Summit (Sept. 07 2012),
79
CURRICULUM VITAE
Rj Dejolde Madia
Rj Dejolde Madia was born on the 28th day of June in the year 1989, in Tacloban City. He is the 3rd child of the four children of Mr. Ruben S. Madia Sr. and Mrs. Josephine C. Madia. He lives at Brgy. 88, Baloc 1, San Jose, Tacloban City.
He began his first education in San Jose Central School, Tacloban City in the year 1995. His secondary education was in San Jose National High School, Tacloban City graduated in the year 2005. He finished 2-year Computer Programming Dual Training System Course at Leyte Technological Foundation College. And currently, he is a third year Bachelor of Science in Information Technology (BSIT) student of ACLC College Tacloban. He attended trainings and seminars such as Seminar in Computer Networking (March 15, 2007), Leyte Samar IT Summit (Sept. 07 2012),
80
CURRICULUM VITAE
Dion Rae B. De La Cruz
Dion Rae B. De La Cruz was born on the 14th day of November in the year 1992. , in Tacloban City. He is the youngest child of the 3 children of Mr. Dionisio R. De La Cruz and Mrs. Edna B. De La Cruz. He lives at Brgy. 62-B Lot 19 Bliss Sagkahan Tacloban City. He graduated elementary in Asian Development Foundation College, Tacloban City in the year 2005-2006. His secondary education was in Asian Development Foundation College, Tacloban City graduated in the year 2009-2010. He is a Second year Bachelor of Science in Information Technology (BSIT) student of ACLC College Tacloban.
He attended trainings and seminars such as Seminar Leyte Samar IT Summit (Sept. 07 2012).
He attended trainings and seminars such as Seminar in Computer Networking (March 15, 2007), Leyte Samar IT Summit (Sept. 07 2012),
81
CURRICULUM VITAE
Jumar Val N. Guarino
Jumar Val N. Guarino was born on the 16th day of September in the year 1992.
, in Ormoc City. He is the youngest child of the 3 children of Mr. Valentin and Mrs.Juvilinda N. Guarino. He lives atBrgy. Libertad Lide Staff Housing Isabel,Leyte. He graduated elementary in Doane Baptisit School, Isabel ,Leyte in the year 2005-2006. His secondary education was in Doane Baptist School, Isabel, Leyte graduated in the year 2009-2010. He is a Second year Bachelor of Science in Information Technology (BSIT) student of ACLC College Tacloban.
He attended trainings and seminars such as Seminar Leyte Samar IT Summit (Sept. 07 2012).
82
August
WEEK4 WEEK1 WEEK2 WEEK3 WEEK4 WEEK5 WEEK6 WEEK7 WEEK8
Making of Project Proposal
Project title and contents
Respondent
Requirement Specs.
Hardware, Software, End-users,
Suppliers/Vendors
Interview Questionaires
Conduct Interview
Data Gathering
Cost and Benefit Analysis
Logical Design
Context Diagram (Existing & Proposed)
DFD (Existing & Proposed)
System Flow Chart (Existing & Proposed)
VTOC (Exisitng & Proposed)
IPO (Existing & Proposed)
Screen Design (Proposed)
Report and form Design (Proposed)
Menu Design (Proposed)
System Security
Network Design/Layout
LAN
WAN
Database Design
Normalization
Entity-Relationship-Diagram
Physical Design
Prototype Design(Include software)
Application Program/Software
Network(LAN/WAN)
Installation of Software and Hardware
Final Prototype Design(End-User Testing)
Final Documentations
System Documentations
User Manual
Oral Defense(System Presentation)
5.IMPLEMENTATION
1.PLANNING
2.ANALYSIS
GHANT CHART
DURATION IN WEEKS (AUGUST TO OCTOBER 2012)
September October
3. DESIGN
4.DEVELOPMENT
Hotel Management System. (2016, Mar 31). Retrieved from https://studymoose.com/hotel-management-system-essay
👋 Hi! I’m your smart assistant Amy!
Don’t know where to start? Type your requirements and I’ll connect you to an academic expert within 3 minutes.
get help with your assignment
