Lodge management system essay

Words: 15181 | Published: 02.24.20 | Views: 743 | Download now

A hotel can be an institution that provides paid out lodging on the short-term basis. The supply of fundamental accommodation, in times past, consisting only of a space with a understructure, a cupboard, a tiny table and a washstand has typically been changed by bedrooms with modern facilities, including ensuite bathing rooms and a/c or climate control. The fee and top quality of accommodations are usually a sign of the range and type of services available. Due to the enormous increase in travel worldwide over the last decades in the 20th hundred years, standards, especially those of smaller sized establishments, have improved noticeably.

Hotels happen to be independently evaluated in classic systems and these count heavily for the facilities presented. Today, almost all of the Hotels present goods and services using computer system. It will help to perform process in an convenient way with less time used. Some companies are become completely automated although some strive for the similar setting. Computer coders develop things like computer system the rest of us could use.

The computer programmers tell the users what to do. They make programs that users may easily use or perhaps understand. The advent of new technology gave rise to easy and hassle free discussion between and among humans. Whether it is in operation, science or whatever process a person takes on the product quality and rate of undergoing it are increased with motorisation at the core of this efficient. Today, many software has used an automation procedure like employing computer system, due to the efficient and accuracy. “Hotel Management and Services System is a supervision and purchase processing program. In this system there are more advantages rather than manual Hotel Management System. two

Project Context

Based upon the research executed, the proponents found out the problem of this study are: How will this system ensure that the management as well as the staff to have accurate service at the same time to monitor the records in the customers? This study expects to develop an Hotel Management System. This done by First, The current system is assessed. Deficiencies happen to be identified. This really is done by interviewing users of the system and consulting

with support personnel. Second, the new program requirements happen to be defined. In particular, the a reduction in the existing product is addressed with specific proposals for improvement. Next, the proposed system is designed. Programs are organized concerning the physical construction, equipment, operating systems, coding, communications, and security issues. The new product is developed. The brand new components and programs happen to be obtained and installed. Users of the system will be competed in its use, and all areas of performance will be tested. If necessary, adjustments will be made at this time. And previous, the system is usually put into use. This can be done in various ways. The new program can phased in, relating to software or location, and the older system slowly but surely replaced. In some cases, it may be more costeffective to shut down the aged system and implement the modern system all at one time. Once the fresh system is ready to go for a while, it must be exhaustively evaluated. Maintenance has to be kept up rigorously constantly. Users of the system should be kept up-to-date concerning the latest modifications and procedures.

Goal and Information

The purpose of this analyze is to develop computerized and automated Lodge Management System intended for the Leyte Park Hotel Hotel to overcome the most of the complications occurring within their existing system.

Existing method is based on manual work and everything the process are done manually, and so they keep registers and files intended for recording all the details of the program. They maintain several registers for documenting the admittance of daily transactions just like guest check-in, reservation, checkout, etc .

That they maintain the record of the guests so they help keep each and every details regarding the guests in the visitor master record. In the similar fashion they will maintain the documents of their charges so they help keep each and every data regarding their bills particulars in the expenses master document. They keep the bill Book or perhaps receipt Book to maintain the record pertaining to the fees collected by simply guest. Hence maintaining Staff information, Customer Information

Visitors data, Check-in and Check-out information and all the things are done personally. As the growing craze in InfoTech World of computer systems need of accuracy, perfectness, speed and high recollection data storage area is a must. Every problem must be solved with a least amount of time and energy.

The manual system of “Leyte Park Holiday resort Hotel is to be computerized and automated in order to overcome the difficulties, which impacts the existing manual system. Robotizing the existing program with the help of a few programming language, database bundle ease the job of the system up to a great extent.

Generally, there have been a qualifying criterion to work with any work or activity for a specific purpose. No person works without specific detailed information about the particular task he is performing. As a result, any transaction can be performed possibly customer entrance or charges collection or perhaps check-in and check-out. In the automated system, the 1st screen of the system will be a welcome message and a list of choices. These food selection contain the selection of either the leading Desk or perhaps the Restaurant. Any kind of transaction can be carried out in Motel Management and Services System i. electronic. routine 5

processes. After the transaction is completed the user can log off in the system simply by clicking the log-out press button or stopping from the program.

Aims

This kind of study aims to solve the down sides encountered by existing program and to change the manual booking. The system may be handy towards the user in the following factors: ¢ Provide quick and efficient opportinity for gathering the consumer information with their rooms, charges and finally the check-in and check-out.

¢ Automate the job such as gathering customer info, posting concept, gathering staff information.

¢ Handle the different types of studies.

¢ Increase the reliability between the supervision and personnel. ¢ Minimize time take in.

¢ Highly integrate data.

¢ Use less time in searching and retrieving of files.

¢ Make a backup of files atlanta divorce attorneys successful deal. Scope and Limitations

The “Hotel Management and Services System of the corporation is designed to get over the most in the problems taking place in the manual system by simply automating the existing system. The features of the recently proposed electronic automated program are explained in brief because below: After automating the machine, the panel of the corporation or the user of the system can end their work in least length of time and initiatives. The computerized system has many gains five

and work, which the manual system won’t be able to give, in any kind of situations. In any manual system if we have, the main difficulty arising is to maintain the volume of records and finding a particular record. In manual program the user needs to note down the check-in and check-out of each guest which is very wearisome task, however in the case of automatedsystem an individual just has to enter once and automatically all the information regarding the guest or consumers will be shown and thus the person does not have to worry because all the work done is usually automatically and the system on its own.

Computerized devices are most helpful in dealing with areas where database comes into the existence. Some type of computer can hold massive amount data in its storage devices and it can work at high speed. The user can place the entire data in the computer system and can be capable of perform almost any task which usually when done manually is usually tedious and time consuming. The new system may have the facility to sort data in respect to any certain type based on what the customer wants in a order. Also with the help of automated system in the event the user would like to access virtually any single customer’s data from many users data he can automatically find the desired data of the preferred guest or staff or perhaps bills specifics, etc . in a fraction of second which is again period saving and incredibly quick. A few of the features of the proposed system are given listed below: ¢ Preserving the Databases for guests, staff, inventory, services, abfertigung and checkout, etc .

¢ Removal of Data Redundancy.

¢ Data Consistency.

¢ Buying of foods and companies

¢ Menu powered interface.

¢ Ensure data protection.

The main features of Lodge Management System receive below: 1 . As laptop can store large amount of data it is very helpful to store data of such a huge database. Details regarding count of guests in the Accommodations. Also info regarding bills of each and every guest.

2 . The passing of ordered foods and solutions can be very easily apply to the guest and get total billing details of the guests in the peruse.

a few. Inconsistency induced due to changes in the database is definitely removed being a separate data source can be taken care of for amount of guest in the Hotels. So the repository is immediately updated reacting to the any change happening and we need not go through all the forms again.

4. Communication to various other department through the system for easily transferring and getting data.

several

Chapter II

REVIEW OF RELATED LITERATURE/SYSTEM

Some of the hotels still work with paper since the main method for recording uses such as check-in and check-out. However , this kind of business operation method has many issues including manual searching and determining for the record and so burdens the management personnel. The Lodge Management System in a position the ease of management of the resort.

Hotel Management is the program that manages the client’s data, personnel data, sales and products on hand and produce reports for all those transaction procedures in the system that can work with by the leading management because reference for decision making and therefore plan start up business strategy to satisfy the business goals as reference for making decisions and hence program new business strategy to meet the organization objectives.

According to a site its declared “Hotel Management System is an ideal software solution pertaining to Hospitality Sector that can be used by hotels, hotels, inns, resorts, lodges, hostel, military visitor houses, ranch, suites, apartments rentals, medical centers and foundation, breakfast businesses. Hotel Management System is a extensive software package consisting of integrated modules intended for various areas of hotel managing. (http://www.hotelmanagementsystem.co.in) With the power of technology nowadays, persons get interested with computer systems. They tried to indulge themselves on it to possess a productive cause a more efficient and time saving process. It really is highly highly valued in institutions like businesses, schools, clinics, government and non-government providers. However , some are still applying manual system. In this regard, we all acknowledge the cost of computerized system.

Chapter III

SPECIALIZED BACKGROUND

The proponents want to know the causes of hotel in using manual booking. The supporters conduct a report towards the subject because they will notice a number of the hotel nonetheless use manual reservation. The analysis will stress the effects of employing manual booking and how a computerized and automated reservation will be substituted. Therefore , the proponents proposed to find out how you can increase the volume of customer employing computerized computerized reservation. Conversation and specific stimulation will always be linked to the technological availability of time and place. With the transition to an information-based contemporary society, computers and transactions have got evolved from manual transaction. One of the solutions or alternatives to the problems that a hotel is usually facing, something was being created which can edit, delete, filtration, monitor and store and secured the records of the customers.

Lodge Management and Services Method is a transaction processing system that resolves the problem came across during the manual hotel booking and invoicing. The digital Hotel Management System aims to easily simplify the

manual hotel operations quickest and accurate. Database is definitely shared through Local Area Network (LAN). The proponents employ some equipment and techniques to build the project. The program uses Graphical User Interface (GUI) to help the user give instruction for the computer. The machine once implemented it will resolve the most common issues that the Resort Management encounter.

Chapter 4

STRATEGY, RESULTS AND DISCUSSION

Requirements Analysis

PIECES CLASSIFICATION OF SYSTEM REQUIREMENTS

Non-Functional

Need

Type

Explanation

Overall performance

The performance in the system will certainly depends on the readily available resources from the PCs employed. The system can easily run smoothly on Or windows 7 Service Pack 2/Vista/7 with 32/64 bit and PERSONAL COMPUTER with advised configuration. Suggested configuration to get PC is usually 1 GHz or Quicker processor, 1 GB DDR2 RAM MEMORY, 300 MEGABYTES Free Hard Disk or above that, plug and play screen with 800Ã—600 resolution and 256 shades or higher, computer keyboard, mouse. The configuration outlined can give ideal and optimum result at instance through the working of the system. Info

The system can easily process explications needed by the user including Guest Info, Check-In, Reservation, Check-Out, Rooms, Staff Details, Inventory, Sales Information and Reports necessary by the top management as reference to get decision making and hence plan start up business strategy to meet the business targets.

Economy

Using manual system is frustrating and much more prone to human error and finding records can cost much time and effort. Using computerized system may gain more advantages simply by lessen enough time and more effeciency in the

business operation thus will help improve the repairing to the customer. Control

(and Security)

Reliability features of the machine control the access legal rights of the user. The admin consumer can access all the configurations in the program like changing the room rate, adding and edit staff, edit the cost of the foods and services are available the business, and so forth, While the normal user can simply operate the device like checkin, check-out, reservation, add consumer charges and record clients order. Efficiency

The new system will have the facility to sort info according to the specific type on the basis of the particular user wants in any purchase. Also with the help of computerized system if the end user wants to access any single user’s data from various users info he can instantly get the wanted data with the desired guests or personnel or bills details, etc . in a portion of second which is once again time conserving and very quick.

Services

Any staff that registered system employing their username and password are able to use the system. Customer types happen to be classified into to 3 types which is admin, DESK CLERK and CASHIER. Each customer has gain access to rights control and configurations which can be regulated by the ADMIN. Teaching and consumer manuals can be found together with the system. The system designed as simple and easy-to-use interface this tool allows to train lodge staff in hours rather than days. 12

CAUSE AND EFFECT ANALYSIS

Trigger and Impact Analysis System Improvement Objectives

Complications or

Opportunity

Causes and Effects System Objectives System Constraint

Difficulty in

Maintenance of

Records

It is very challenging to

keep data record

inside the system because

each of the records are

moved into in the signup

and also the respective

record literature. There

are chances of the

record ebooks or data files

through which all the info

is usually kept can be torn

or wearied out or perhaps

another damages

which results in the

damaged data.

To provide an easy

and hassle free in

retaining and

tracking the records.

Securing the records

by having backups

incase of system

failure.

Limited of

information to get

moved into in the data

Time-consuming and

lack of effectiveness

It is extremely time

consuming method

to create each and

just about every entry inside the

repository register.

Also it uses a lot of

time in the event all the items

happen to be repeated. Inside the

program processes such

as making different

form of reports

preparing advantage lists

tedious measurements

happen to be examples of time

consuming process in

the program.

To provide quick

and useful means

for gathering the

customer details

with their

areas, bills

reservation, check- in

and check-out.

Systemize the

computing of bills

different types of

reports and removal of

data redundancy.

Gathering info will

depend upon which user

access privileges in the

system

Requirement Records

1 . Introduction

Leyte Area Resort Hotel Management and Services Strategy is automated management software for Glass windows. It is a total solution, beginning with selecting type of operation which is the hotel operation plus the restaurant operation going to lodge reservations, verify in/check out, ordering of foods, solutions and ending with payment and product sales reports. An individual interface is definitely carefully optimized for high-speed input and the prevention of

prevalent mistakes. Really designed for using on multiple computers, and possesses reliable and secure consent levels. Intended for managers, there is also a rich group of reports that shows an entire picture of hotel businesses and lifestyle cycles: revenue by room, sales by simply room type, sales requests in restaurants, payment strategies, acquired providers and computerized bill computations.

By standardizing the entire lodge management process, the software substantially improves top quality of guest handling and accounting.

It’s easy to install and easy to use with a extremely user-friendly user interface. This system will surely helps the organization operation more quickly and more successful. 1 . you Purpose

The suggested system is produced for the corporation for this purposes: ¢ Centralize info and gain control over business practices. ¢ Deliver constant and efficient Customer service

¢ Make Informed, snello decision

¢ Lowering of operating costs and problems.

¢ Fully built-in

¢ Rapid return on investment

doze

¢ Fast payment avoids for a.

¢ Powerful Revealing Capability

1 . 2 Background

The Hotel is a main tourism & convention complicated with its 6 hectare parkland nestled on the hill overlooking beautiful San Pedro Gulf. It provides the unique luxury of any hotel & the mood of a vacation resort.

Inaugurated long ago under the Marcos dictatorship, Leyte Park Hotel Hotel in Tacloban Town is now a mere shadow of its extravagant past. However, many good parts remain.

Leyte Area Resort Motel owned by Engr. Wilson Chan is usually conveniently located in the center of Tacloban City, the Regional Capital of East Visayas. It sits on top of a mountain overlooking the gorgeous San Juanico Strait and San Pedro Bay. Tacloban City is merely 55 a few minutes from Manila and twenty minutes coming from Cebu. 20 minutes drive by car from Air-port.

All bedrooms have air conditioned, Satellite tv, direct phone, shower/bath tub, work table, double/ king size bed and mini-bar.

1 . a few Scope

This examine mainly centered on providing organization application employing computerized program that enables businesses to track services and aims to providea accurate and trustworthy process in each transaction particularly in a hotel reservation. This study looked into a better effect of applying technology today on how that affects our day to day lives specifically being the consumer. With this kind of studies it can help to know the differences of using manual system to a computerized generation today, 13

prioritize is to confirm and to give them the right data. 1 . 4 Definitions, Acronyms and Abbreviations

To supply the readers a clearer understanding of the conditions used, the next terms will be defined as just how it is used in the study.

Administrator ” This identifies the approved person that posseses an access in updating the system.

Cashier ” the official in an business who is in charge of receiving and paying out funds and keeping financial data

Customer ” a person or company that buys services or goods. Database” is definitely an integrated collection of logically related records or perhaps files which will consolidates data into a common pool of data records that delivers data for many applications. A database is known as a collection of details that is structured so that it can easily be accessed, maintained, and updated.

Desk clerk” a motel receptionist.

Function Room- Park from the hotel where held situations such as meetings, conventions, meetings and other activities.

Visitor ” a client of a lodge or restaurant.

HMSS” Hotel Management and Providers System

LAN ” Local Area Network

Microsoft Access” A database software created by simply Microsoft Corporation for home windows based computer system.

Laptop Network ” A system of two or more computers, terminals, and

marketing communications devices linked by cables, cables, or a telecommunications system 14

in order to exchange data.

Reports ” a detailed routine account of any company’s actions, financial condition, daily guest places to stay that are provided to the owner.

Room- an area in a hotel which can be rented by the customer to get a limited time frame.

Place Types- This kind of refers to the type of rooms which have been been offered in the resort. Room facilities depends on the area types.

Supervisor” normally the one who supervise and guide the work or activities from the employees. End-user” This term as found in the study are definitely the desk clerk, cashier, and administrator who also are validated user of the hotel management. 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 Information

Motel Management and Services Method is a electronic system designed using VB. NET 2010 and MS ACCESS due to the back-end support or repository. The benefits of the Motel Management System happen to be divided into three categories, which can be settings, operations and confirming. Settings are mainly configuring the price tag on the room, form of the room and also other information. Hotel Management System also provides the operation functionalities. These kinds of operation benefits 15

contain room reservation, check-in, check-out, ordering of products and sevrvices and other features. The top managing of resort can use the report create by the Resort Management System because reference to get decision making thus plan new company strategy to fulfill the business targets. 3. Requirements and Restrictions

3. one particular Functional Requirements

Entrance Desk

¢ Reservation ” Put customer booking information

¢ Check-In ” Put customer check-in information

¢ Check-Out ” Retrieve customer data and update pertaining to check-out ¢ Change Space ” Copy guest to other place

¢ Cancel Booking ” User’s reservation info will be wiped ¢ Function Room Reservation ” Put, Update, Delete entry to get function area reservation

Monitoring

¢ Areas ” Monitor room status

¢ Guest ” Monitor guest occupied in the hotel

¢ Above Stayed Customer ” Screen the status of visitor.

¢ Inventory ” Monitor the Sales, Establishments and Goods Inventory ¢ Function Area ” Screen activities required for the function room. Supervisor

¢ User Accounts ” add, update, delete and set authorization to the customer of the ¢ Staff Supervision ” Put, Update, Delete Staff Infos 16

¢ Space Settings ” Add, Update, Delete bedrooms, room types and room rates. ¢ Extra Items ” Put, Update, Erase extra things requested simply by customers ¢ Discounts ” Add, Delete discounts for the consumer

¢ Cafe ” Change settings pertaining to the cafe

¢ Services ” Add, Upgrade, Delete companies offered in the hotel Studies

¢ Daily Occupancy

¢ Reservation Statement

¢ Inventory Report

¢ Staff Fulfillment Report

¢ Daily Sales Report

¢ Weekly Revenue Report

¢ Month-to-month Sales Survey

Restaurant

¢ Categories ” Foods and Beverages Categories

¢ Items ” Foods and Beverages available and organise by the category ¢ Ordered Food ” Set of goods that ordered by the customer ¢

several. 2 Non-Functional Requirements

System Security

¢ This features enable the user to lock the program for unauthorized user of

the program.

Databases Backup

¢ This kind of features allow the user to back-up the databases of the program to recover files incase of system crash due to computer virus or main system failure. Program Requirements Specifications

¢ Hardware Requirements of the program

There is also a list of equipment materials applied during the producing and also through the use of the proposed system. As the new system to be made into a computerized efficient system, requirement of a computer can be must. Every one of the hardware required here are generally the basic construction of a typical business office computer. A listing of the components requirement used in the system provided below: Minimum Construction:

To run the applying software of the system in the computer the minimum setup required is just as below:

¢ one particular GHz Pentium 4 processor or different compatible.

¢ 512 DDR2 MEMORY

¢ 500MB of available hard disk space

¢ A “plug and play” monitor with of 800 x 600 resolution and 256 colours ¢ Computer keyboard.

¢ Mouse.

¢ House windows Compatible Printing device

¢ DirectX being unfaithful capable video card running at 800 x six-hundred resolution screen ¢ Device, Router, UTP cable to get LAN or perhaps wireless router for WAN Recommended Setup:

The device can run on the above-mentioned system, however for perfectness and clearness experts recommend to use a personal computer having the under listed construction. The settings listed below may give best and optimum end result at occasion during the operating of the program. ¢ 1 . 6 Gigahertz or Faster processor

¢ 1GB DDR2 RAM

¢ 3GB of available hard drive space

¢ A plug and play monitor with of 1366 back button 768 image resolution and 256 colors ¢ Keyboard.

¢ Mouse.

¢ Ink Jet/Laser Printers.

¢ DirectX 9 in a position video greeting card running for 1024 by 768 or perhaps higher-resolution screen

¢ 500 Versus. A UPS. [Used in case of electricity failure]

¢ Modem, Router, UTP cable television for LAN or wireless router for WAN (2) Software Requirements of the system

Together with the hardware, found in the system it will require software to generate a system as well as to run a program with the computer hardware. Collection of several types of hardware right into a specific type can form some type of computer but it are unable to execute distinct process by itself. For effective and appropriate working of any program software must be installed. These types of soft wares may be by means of operating system or perhaps application computer software. To 19

run the program one should also use software program.

Operating-system:

¢ Windows XP (x86) with Services Pack three or more ” all editions other than Starter Model

¢ Windows Windows vista (x86 & x64) with Service Bunch 2 ” all editions except Beginner Edition

¢ Glass windows 7 (x86 & x64)

¢ Windows Storage space 2003 (x86 & x64) with Support Pack two

¢ Windows Server 2003 R2 (x86 & x64)

¢ Glass windows Server 08 (x86 & x64) with Service Bunch 2

¢ House windows Server 2008 R2 (x64)

App Softwares:

¢ Micosoft Access 2003/207/2010

¢ Microsoft DotNET Framework 3. 5

4. Conclusion

The researchers had observed the importance of Digital Hotel Supervision and Services System to Leyte Playground Resort Hotel. The suggested system will be a very essential device for this sort of task. The said program as meant will be able to get rid of the manual operate the payment process of the said lodge.

4. you Outstanding Issues

An that degree of acceptability from the respondents within the output from the study is great and is recommended.

twenty

Design of Software, Systems, Product and Process

System: Resort Reservation System Module: Existing Context Diagram Date: Process: Hotel Booking System Level: 0

Prepared by: Apr Joy T. acaban, Rj D. Madia

Jumar Val Guarino, Dion Rae De La Jones

Existing Hotel

Reservation

System

Owner

Desk Personnel Customer

Customer’s Information

Payment, Purpose

Customer’s Details

Money, Purpose

Receipt

Transaction

Reports

List of Client’s Accomodation

System: Resort Reservation Program Module: Existing Data Flow Diagram Particular date: Process: Check-In, Check-Out Level: 1

Prepared by: Apr Joy S. acaban, Rj D. Madia

Jumar Val Guarino, Dion Rae De La Johnson

Confirm Purpose

1 . 0

Consumer Inquire Area

Charge and

Room Type

2 . 0

Desk

Personnel

Purpose Inquire Room Facts.

Check-In

a few. 0

Room Usage

some. 0

Record

Receipt

Update

Record

5. zero

Room Info.

Check-Out

6. zero

Table

Staff

Payment

Paid the bill

7. zero

Customer Info.

System: Lodge Reservation Program Module: Existing Flow Chart Date: Procedure: Hotel Reservation System Level:

Prepared by: April Delight S. acaban, Rj Deb. Madia

Jumar Val Guarino, Dion Rae Entre ma Cruz

Start

Verify

Customer’s

Purpose

Inquiry?

Inquiry of Room

Rate and Room Type

Certainly

Check-In?

Validate Room

Availability

Yes

Room

Available?

Check-Out?

End

Fill-up Client’s

Customer’s

Record

Record Client’s

Details

Compute Bills

Accept Primary

Payment

Record Initial

Payment

Issue Um. R.

Update Record

Consumer Info.

Payment

O. R.

Report

Compute Bills

Accept Total

Repayment

C A

Yes

System: Resort Reservation Program Module: Existing VTOC Particular date:

Procedure: Hotel Booking System Level:

Made by: April Joy S. acaban, Rj D. Madia

Jumar Alternativ Guarino, Dion Rae Entre ma Cruz

Hotel Reservation

System

zero

Verify

Goal

1 ) 0

Inquire Room

Charge and

Room Type

installment payments on your 0

Check-In

3. zero

Room Usage

4. zero

Bring up to date

Record

your five. 0

Check-Out

6. zero

Paid out the bill

7. 0

twenty-four

System: Hotel Reservation System Component: Existing GOING PUBLIC Date:

Process: Motel Reservation Program Level:

Prepared by: The spring Joy T. acaban, Rj D. Madia

Jumar Val Guarino, Dion Rae De La Cruz

User’s Information

Room Data

Check Purpose

Inquire Room Rate and

Space Type

Check-In

Room Consumption

Check-Out

Paid the bill

Payment

Reports

Input Procedure Output

System: Resort Management and Services System

Component: Proposed Context

Plan

Time:

Procedure: Hotel Managing and Services Level: zero

Made by: April Pleasure S. acaban, Rj G. Madia

Jumar Alternativ Guarino, Dion Rae Entre ma Cruz

Hotel Managing

and Services

System

Customer’s Details

Repayment, Purpose

Customer’s Info

Money, Purpose

Receipt Purchase

Studies

Set of Customer’s

Accommodation

Staff Details

Desk

Workers

Cashier

Owner

Client

Supervisor

Different

Hotel Staff

Attendance

Job Achievement

Personnel Schedule of

Tasks

Guest Information

Cash, User’s Ordered Items

and Services, Products on hand

Transaction

Staff

Accomplishment

Report

Personnel Duties and Responsibilites

System: Motel Management and Services Program

Module: Proposed Info

Movement Diagram

Date:

Process: Personnel Management Level: 1

Prepared by: April Joy H. acaban, Rj D. Madia

Jumar Val Guarino, Dion Rae De La Cruceta

Lodge Staff

(Cashier, Table

Workers

Boss

Other Staff)

Check

Attendance

1 . 0

Staff Info.

2 . 0

Navigate to the

area of

Duties

duties and

responssibilities

Other Personnel

Workplace

Personnel

Cashier Supervisor

Perform Duties

and Functions as

Workplace Clerk

3. zero

Execute Duties

and Functions

because Restaurant

Cashier

4. zero

Carry out Duties

and Features as

Supervisor

5. 0

Conduct Duties

and Functions as

Other Staff

6th. 0

duties and

responssibilities

obligations and

responssibilities

duties and

responssibilities

obligations and

responssibilities

System: Resort Management and Services System

Component: Proposed Info

Flow Diagram

Date:

Process: Booking, Check-In, Check-Out Level: two

Made by: April Happiness S. acaban, Rj G. Madia

Jumar Val Guarino, Dion Rae Entre ma Cruz

Customer’s Data

Repayment, Purpose

Customer

Verify Purpose

3. 1

Inquire Space and

Room Types

a few. 2

Room Information. Room Details. Desk

Personnel

from Procedure 3. 0

Staff Info.

Reserve

Customer

3. several

Check-In

several. 4

Check-Out

3. 6

Add Additional

Items/Charges

3. five

Surrender Room

key and Compute

Bills

3. 7

Repayment

Buyer

Room No .

Customer

Reservation

confirmation

Reservation verification

Consumer

Items/Charges

Added

System: Hotel Managing and Solutions System

Module: Suggested Data

Flow Plan

Time:

Procedure: Ordering Foods Level: 2

Prepared by: April Joy S. Acaban, Rj M. Madia

Jumar Val Guarino, Dion Rae De La Cruz

Customer’s Info

Client

Make inquiries Items

4. 1

Buy Items

4. two

Purchased Items Repayment

Cashier

from Process four. 0

Staff Facts.

four. 3

Receipt

Staff Annonces

Director Create Staff

Routine of

Duties

5. one particular

Choose Area of

Responsibilities

5. a couple of

Owner

coming from Process five. 0

System: Lodge Management and Services Program

Component: Proposed Info

Stream Diagram

Date:

Process: Staff Scheduling Level: 2

Prepared by: 04 Joy S i9000. Acaban, Rj D. Madia

Jumar Val Guarino, Dion Rae De La Cruceta

Staff informations

Staff Info. together with

the routine of responsibilities and

area of duties

Resort Staff

(Cashier, Office

Staff

Different Staff)

Schedule of duties and

part of responsibilities

Start

Select User Type

Administrator?

Input Login name

and Password

User

Account

Desk

Personnel?

End

Found? Officer A

Input Username

and Password

User

Account

Found? Office Personnel A

Certainly

Zero

Yes No

Cashier?

Input User name

and Password

Found? Cashier A

User

Account

System: Motel Management and

Services System

Module: Proposed

Flowchart

Time:

Process: Login System Level:

Prepared by: Apr Joy T. Acaban

Rj D. Madia, Jumar Val Guarino

Dion Rae De La Cruz

Start

Select Purchase

View Room?

Yes

View Customer?

Abfertigung?

Screen Guest

Information

Display Room

Data

Validate Room

Availability

Available?

Yes

Fill-up

Customer’s

Check-In Kind

Conserve Customer’s

Info

Customer’s

Record

Customer’s Facts

Figure out Room

Usage

Select Kind of

Repayment

Mastercard?

Check

Money?

Check Credit

Card

Verify Cheque

Record Payment

Print Receipt Update Record

W D

Customer’s Information

Yes

Certainly

Yes

Not any

Reservation?

Check Room

Availability

Available? G

Get Customers

Information

Confirm

Reservation

Record

Customer’s Information

Deb

Simply no

Yes

Invoice

Program: Hotel Supervision and

Services System

Component: Proposed

Flowchart

Date:

Process: Front Desk Deals Level:

Prepared by: Apr Joy S. Acaban

Rj M. Madia, Jumar Val Guarino

Dion Rae Entre ma Cruz

Add Added

Items/Charges?

Customer’s

Data

Select Item to Add

Additional Item’s

Record

Check”Out?

Customer’s

Information

Compute Bills C

End

Start

Order Foodstuff

Products Hotel Customer?

Examine Guest

Information

Dine-In?

Display Customer’s

Buy List

Verify Client

Order

Calculate Bills

Select Sort of

Payment

Credit Card?

Check

Money?

Confirm Credit

Card

Verify Talón

Record Payment Printing Receipt Upgrade Record

C M

Certainly

Yes

Invoice

Take-Out?

Check Customer

Order

Prepare Bought

Foods

Put together Ordered

Foods

Pack Purchased Foods

Customer’s

Record

Yes

End

System: Resort Management and

Solutions System

Module: Proposed

Flowchart

Particular date:

Procedure: Restaurant Orders Level:

Prepared by: Apr Joy S. Acaban

Rj D. Madia, Jumar Val Guarino

Dion Rae Entre ma Cruz

System: Lodge Management and Services Program

Component: Visual Table of

Contents

Date:

Process: Resort Management and Services Level:

Prepared by: April Pleasure S. Acaban, Rj G. Madia

Jumar Alternativ Guarino, Dion Rae De La Cruz

Hotel

Management and

Services System

SelectAreaof

Responsibilities

MakeStaff

Scheduleof

Duties

PrintReceipt OrderItems InquireItems

Verify Goal

Make inquiries Room

and Space Types

Reserve

Customer

Check-In

AddAdditional

Items/Charges

Check-Out

SurrenderRoom

keyand

ComputeBills

Check Presence

See a area of

Responsibilities

Perform Tasks

and Functions because

Office Clerk

Perform Responsibilities

and Functions since

Cafe Cashier

Perform Duties

and Functions of

Supervisor

Perform Duties

and Features as

Other Personnel

thirty-five

Program: Hotel Administration and Companies System Component: Input Process Output Day: Process: Level:

Made by: April Pleasure S. Acaban, Rj D. Madia

Jumar Val Guarino, Dion Rae Entre ma Cruz

Customer’s Info

Place Information

Staff Activities

Client Activities

Ordered Products

Items/Charges added

Payments

Check Attendance

Navigate to the area of

Responsibilities

Perform Duties and Capabilities

because Cahier, Office Personnel

Supervisor and also other Staff

Reserve Consumer

Abfertigung

Add Additional

Items/Charges

Check-Out

Inquire Items

Order Items

Print Receipt

Make Staff Plan of Duties

Select Area of Obligations

Daily, Weekly, Regular monthly

Product sales Report

Daily Guests

Bookings, Staff

Accomplishment

Report

Inventory Survey

Customer’s Activity Record

User’s Receipt

List of Client’s

Accomodation

Input Process Output

thirty six

Development and Tests

Resort Management and Services Method is a purchase processing system that solves the problem came across during the manual hotel booking and billing. The digital Hotel Management System aims to simplify the manual hotel functions fastest and accurate. Databases is distributed thru Local Area Network (LAN). The proponents make use of a lot of tools and techniques to build the job. The system uses Graphical User Interface (GUI) to help an individual give instruction to the laptop. System assessment happens through running every its function abilities atlanta divorce attorneys field, varieties, and the databases of it is tables that connect through the project with the system. Screening is the technique of running a system with the goal of finding mistakes. Testing improves the integrity of your system simply by detecting deviations in design and style and problems in the program. Testing aims at detecting error-prone areas. It will help in the reduction of errors in a system. Testing as well adds benefit to the product by contouring to the customer requirements. System testing is a stage of implementation. This can be to check whether or not the system

works effectively and successfully before live operation begins. Testing is essential to the achievement of the program. The candidate system is susceptible to a variety of assessments: response price, volume, anxiety, recovery, secureness and simplicity tests. A series of tests are performed intended for the recommended system is looking forward to user popularity testing.

The Testing Steps will be:

¢ Unit Testing

Product testing centers efforts on the smallest device of software design. This is generally known as module screening. The segments are tested separately. Quality is completed during coding stage alone. In this step, each component is found to be operating satisfactory as regards to the anticipated output from the module. thirty seven

¢ Incorporation Testing

Data could be lost across an program. One module can provide an adverse effect on another, sub functions, when ever combined, will not be linked in desired fashion in major functions. Incorporation testing is a systematic approach for making the program structure, while at the same time executing test to uncover errors connected within the interface. The objective is always to take device tested quests and builds program structure. All the themes are merged and examined as a whole. ¢ Validation

In the culmination from the integration testing, Software is totally assembled like a package. Interfacing errors have been uncovered and corrected and a final number of software test out begin in validation testing. Approval testing may be defined in many ways, but a basic definition would be that the validation works when the computer software functions in a fashion that is anticipated by the consumer. After approval test has become conducted, one of many three conceivable conditions is present. a. The function or perhaps performance characteristics confirm to specification and they are accepted.

m. A change from requirements is exposed and a deficiency prospect lists is created. c. Proposed program under consideration have been tested through the use of validation ensure that you found to be working adequate.

¢ Result Testing

After carrying out the acceptance testing, the next step is output screening of the proposed system, as no program could be valuable if it does not produce the mandatory output within a specific structure. The output structure on the display is found to be appropriate. 38

The format was created in the system design period according to the consumer needs. Pertaining to the hard replicate also; the output comes as every the specified requirements by the user. Hence result testing would not result in any correction to get the system. ¢ User Acknowledgement Testing

End user acceptance of any system is the key factor pertaining to the success of virtually any system. The device under consideration is tested for the user acceptance by constantly keeping in touch with the prospective system users at the time of growing and producing changes whenever required.

This is done in consider to the pursuing point:

a. Input Screen Design

w. Output Display screen Design

c. Structure of information and other results.

¢ Security systems

This method is provided with authentication without which in turn no customer can go. So only the legitimate users are allowed to utilize application. If the legitimate users share the authentication data then the product is open to outsiders. 39

LOG-IN FORM ” Where the consumer type her/his username and password to the system. PRIMARY SCREEN (Front Desk)- Where the user select different menu in the system Description of the Prototype

Check-In Form- Where the customer input client information.

Reservation Form- For consumer reservation form

Booking Form- Pertaining to customer booking form

Implementation Plan

The implementation may be the final and important stage. It consists of user-training, program testing in order to ensure successful running of the proposed system. The user checks the system and changes are manufactured according for their needs. The testing involves the testing of the created system applying various kinds of data. While assessment, errors will be noted and correctness is a mode. The conversion way of Implementation to be used in execution of the system is Parallel conversion. Parallel change will be the best method to apply to ensure that key problems inside the new program have been solved before the old system is thrown away. This will lessen the errors and issues of data and enables the end-user plus the administrator to cope and to become familiarized together with the new system.

Implementation Effect

Following studying and analyzing the flow from the proposed system, the supporters would like to advise the following: The program proves to get fast exact convenient, successful and trusted for the process of reservation, abfertigung, check-out, placing your order foods and services and managing personnel. The proponents developed an automatic system well suited for the hotel; the system may save period, effort in filling and monitoring.

Phase V

RECOMMENDATIONS

Hotel Managing and Solutions System offers all the energetic versatile features required to manage hotel, and guest residence business. Lodge Management and Services System offers an functional integration between reservations, guest history, reception/ front table, Sales Ledger, and Confirming modules. Application has center to generate statement for evaluates your arranging, check in and checkout status. Hotel Management and Services System is the best fit for handling hotel assets in quite easy but effective manner with minimal attempts or time so that it boosts your earnings. This examine aims to replace the current program that would be exact for the two customer and hotel supervision. The proponents use diagrams to apply the movement of the

proposed system. Based on the effect of the researcher’s study, the following conclusions get: First, the manual procedure for transaction is within accurate intended for the customer because of possible lack of records. Second, More consuming of time in filling varieties and information. 44

APPENDIX A

Letter of request for the Proponent

Engr. Pat Chan

Proprietor

Leyte Park Resort Resort

Magsaysay Boulevard, Tacloban City

Dear Sir/Ma’am:

Great day!

The undersigned are currently using System Analysis and Design and style. In relation to this, we are requested to contemplate a system that aims to increase the current approach to your resort. In order to fulfill the requirements in the subject, we all decided to choose your motel as the respondent with the study titled “Leyte Park Resort Hotel Management and Services System. We would like might your incredibly kind authorization to execute the study to assemble more information about the company as the important thing elements of the research.

We are looking forward for your instant response regarding this subject. Thank you very much.

Respectfully your own

(SGD) APRIL HAPPINESS S. ACABAN

(SGD) DION RAE B. DE LA CRUZ

(SGD) JUMAR VAL In. GUARINO

(SGD) RJ D. MADIA

Mentioned by:

(SGD) ENGR. ARNOLD Meters. AGNER

Instructor Approved by:

(SGD) MRS. ARLENE CEBU (SGD) ENGR. WILSON CHAN

Dean, College of Pc Studies Manager

APPENDIX B

Relevant Resource Good

Front Office Form

Imports Program. Net. WebRequestMethods

Imports System. Info. OleDb

Public Class frmFrontDesk

Dim stat As Line

Subwoofer FillListCheckout()

stat = “Check-In

lvCheckout. Items. Clear()

connectdbase2()

Try

sql = “SELECT 2. FROM tblGuest WHERE status=’ & stat & “‘ ORDER SIMPLY BY room_no ASC ” cmd = New OleDbCommand(sql, con)

dr = cmd. ExecuteReader

While dr . Read()

With lvCheckout

. Things. Add(CStr(dr(“room_no)))

With. Items(. Items. Rely ” 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 Although

Get ex Since Exception

MessageBox. Show(Err. Description, “Error, MessageBoxButtons. ALRIGHT

MessageBoxIcon. Error) Finally

con. Close()

End Try

End Sub

Sub lv_settingsCheckout()

With lvCheckout. Content

. 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

In the event toolReservationList. Noticeable = Fake Then

sql sama dengan “SELECT 2. FROM tblReservation WHERE status=’Pending’ ORDER BY SIMPLY date_ arrange ASC inch

Different

sql = “SELECT * COMING FROM tblReservation PURCHASE BY date_reserve ASC ” End If perhaps

cmd = Fresh OleDbCommand(sql, con)

doctor = cmd. ExecuteReader

While dr . Read()

With lvReserve

. Things. Add(CStr(dr(“date_reserve)))

With. Items(. Items. Rely ” 1). SubItems

. Add(CStr(dr(“res_no)))

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

. Add(CStr(dr(“total)))

. Add(CStr(dr(“discount)))

. Add(CStr(dr(“charges)))

. Add(CStr(dr(“paid)))

. Add(CStr(dr(“balance)))

End With

End Whilst

Capture ex As Exception

MessageBox. Show(Err. ToString, “Error, MessageBoxButtons. OK, MessageBoxIcon. Error) Finally

con. Close()

End Try

End Sub

Bass speaker lv_settingsReserve()

With lvReserve. Columns

. Add(“Date Reserved, 140)

. Add(“Reservation Number , 140)

. Add(“Status, 70)

. Add(“Room Number , 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)

End With

End Sub

Sub likelname()

stat = “Check-In

lvCheckout. Items. Clear()

connectdbase2()

Try

sql = “SELECT 2. FROM tblGuest WHERE status=’ & stat & “‘ AND lname LIKE ‘ & txtSearchOut. Text & “%’

cmd = New OleDbCommand(sql, con)

dr = cmd. ExecuteReader

When 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 While

Catch former mate As Exclusion

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 * COMING FROM tblCheckin WHEREVER fname JUST LIKE ‘ & txtSearchOut. Text message & “%’ cmd = New OleDbCommand(sql, con)

dr = cmd. ExecuteReader

Whilst 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 While

Catch former mate As Exception

MessageBox. Show(Err. Explanation, “Error, MessageBoxButtons. OK, MessageBoxIcon. Error) Finally

que incluye. Close()

End Try

End Sub

Sub likeroomno()

lvCheckout. Items. Clear()

connectdbase2()

Try

sql = “SELECT * VIA tblGuest WHEREVER room_no LIKE ‘ & txtSearchOut. Text & “%’ cmd sama dengan New OleDbCommand(sql, con)

dr = cmd. ExecuteReader

Although 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 While

Catch ex As Exemption

MessageBox. Show(Err. Description, “Error, MessageBoxButtons. OK, MessageBoxIcon. Error) Finally

que tiene. Close()

End Make an effort

End Sub

Sub likelnameReserve()

lvReserve. Items. Clear()

connectdbase2()

Make an effort

In the event toolReservationList. Obvious = True Then

sql sama dengan “SELECT 2. FROM tblReservation WHERE lname LIKE ‘ & txtSearchReserve. Text & “%’

Else

sql sama dengan “SELECT 5. FROM tblReservation WHERE status=’Pending’ AND lname LIKE ‘ & txtSearchCancel. Text & “%’

End In the event that

cmd = New OleDbCommand(sql, con)

dr = cmd. ExecuteReader

While dr . Read()

With lvReserve

. Items. Add(CStr(dr(“date_reserve)))

With. Items(. Items. Rely ” 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)))

. 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. Meaning, “Error, MessageBoxButtons. OK, MessageBoxIcon. Error) Finally

con. Close()

End Make an effort

End Sub

Sub likefnameReserve()

lvReserve. Items. Clear()

connectdbase2()

Try

If toolReservationList. Visible = Authentic Then

sql sama dengan “SELECT 2. FROM tblReservation WHERE fname LIKE ‘ & txtSearchReserve. Text & “%’

Else

sql = “SELECT 2. FROM tblReservation WHERE status=’Pending’ AND fname LIKE ‘ & txtSearchCancel. Text & “%’

End If

cmd = Fresh OleDbCommand(sql, con)

dr = cmd. ExecuteReader

While doctor Read()

With lvReserve

. Products. Add(CStr(dr(“date_reserve)))

With. Items(. Items. Depend ” 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)))

. Add(CStr(dr(“total)))

. Add(CStr(dr(“discount)))

. Add(CStr(dr(“charges)))

. Add(CStr(dr(“paid)))

. Add(CStr(dr(“balance)))

End With

End Although

Catch ex While Exception

MessageBox. Show(ex. Message, “Error, MessageBoxButtons. OK, MessageBoxIcon. Error) Finally

con. Close()

End Try

End Sub

Sub likeroomnoReserve()

lvReserve. Products. Clear()

connectdbase2()

Try

If toolReservationList. Visible = True After that

sql = “SELECT * COMING FROM tblReservation WHEREVER room_no JUST LIKE ‘ & txtSearchReserve. Text message & “%’

Else

sql = “SELECT * COMING FROM tblReservation EXACTLY WHERE status=’Pending’ AND room_no JUST LIKE ‘ & txtSearchCancel. Text message & “%’

End If

cmd sama dengan 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)))

. 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 former mate As Exception

MessageBox. Show(ex. Communication, “Error, MessageBoxButtons. OK, MessageBoxIcon. Error) Finally

que incluye. Close()

End Make an effort

End Sub

Sub likedateReserve()

lvReserve. Items. Clear()

connectdbase2()

Make an effort

In the event toolReservationList. Noticeable = Authentic Then

sql = “SELECT 5. FROM tblReservation WHERE lname LIKE ‘ & txtSearchReserve. Text & “%’

Else

sql = “SELECT 2. FROM tblReservation WHERE status=’Pending’ AND date_reserve LIKE ‘ & txtSearchCancel. Text & “%’

cmd = New OleDbCommand(sql, con)

dr sama dengan cmd. ExecuteReader

Whilst dr . Read()

With lvReserve

. Items. Add(CStr(dr(“date_reserve)))

With. Items(. Things. 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)))

fifty four

. Add(CStr(dr(“total)))

. Add(CStr(dr(“discount)))

. Add(CStr(dr(“charges)))

. Add(CStr(dr(“paid)))

. Add(CStr(dr(“balance)))

End With

End While

End In the event

Catch ex Since Exception

MessageBox. Show(ex. ToString, “Error, MessageBoxButtons. OK, MessageBoxIcon. Error)

Finally

que incluye. Close()

End Make an effort

End Sub

Private Bass speaker frmMain_FormClosed(ByVal tv-sender As Subject, ByVal e As Program. Windows. Forms. FormClosedEventArgs) Manages Me. FormClosed

End

End Sub

Private Bass speaker Timer1_Tick(ByVal tv-sender As System. Object, ByVal e While System. EventArgs) Handles Timer1. Tick

statlblTime. Textual content = Format(Now, “Long Date) & inches ” & TimeOfDay & “ End Sub

Private Sub hotel_Click(ByVal fernsehsender As Program. Object, ByVal e While System. EventArgs) ‘frmHotel. Show()

End Sub

Private Bass speaker frmMain_Load(ByVal fernsehsender As Program. Object, ByVal e Because System. EventArgs) Handles MyBase. Load

Timer1. Start()

timerChecker. Start()

lv_settingsCheckout()

lv_settingsReserve()

MyWebBrowser. Boat dock = DockStyle. Fill

Timer2. Start()

End Sub

Private Sub user_accounts_Click(ByVal sender As System. Object, ByVal e As

Program. EventArgs)

frmUserAccounts. Show()

End Sub

Private Sub timerRefresh_Tick(ByVal tv-sender As Program. Object, ByVal e As System. EventArgs)

Myself. Refresh()

End Sub

Non-public Sub staff_management_Click(ByVal sender As System. Object, ByVal elizabeth As System. EventArgs)

frmStaffView. Show()

End Sub

Private Sub ExitToolStripMenuItem_Click(ByVal fernsehsender As System. Object, ByVal e While System. EventArgs) Handles ExitToolStripMenuItem. Click

End

End Subwoofer

Exclusive Sub HelpToolStripMenuItem_Click(ByVal sender Since System. Thing, ByVal e As System. EventArgs) Handles HelpToolStripMenuItem. Simply click

HelpToolStripMenuItem. ForeColor = Color. Dark

End Sub

Private Bass speaker SystemToolStripMenuItem_Click(ByVal fernsehsender As System. Object, ByVal e Because System. EventArgs) Handles SystemToolStripMenuItem. Click

SystemToolStripMenuItem. ForeColor = Color. Black

End Bass speaker

Personal Sub SystemToolStripMenuItem_MouseLeave(ByVal sender While Object, ByVal e While System. EventArgs) Handles SystemToolStripMenuItem. MouseLeave SystemToolStripMenuItem. ForeColor sama dengan Color. White

End Sub

Private Bass speaker SystemToolStripMenuItem_MouseMove(ByVal fernsehsender As Thing, ByVal elizabeth As System. Windows. Forms. MouseEventArgs) Handles SystemToolStripMenuItem. MouseMove SystemToolStripMenuItem. ForeColor = Color. Black

End Sub

Private Sub HelpToolStripMenuItem_MouseLeave(ByVal fernsehsender As Target, ByVal at the

While System. EventArgs) Handles HelpToolStripMenuItem. MouseLeave

HelpToolStripMenuItem. ForeColor = Color. White

End Subwoofer

Private Sub HelpToolStripMenuItem_MouseMove(ByVal sender While Object, ByVal e While System. Glass windows. Forms. MouseEventArgs) Handles HelpToolStripMenuItem. MouseMove HelpToolStripMenuItem. ForeColor sama dengan Color. Dark-colored

End Sub

Private Sub ChangeDeskClerkToolStripMenuItem_Click(ByVal sender Since System. Object, ByVal elizabeth As System. EventArgs) Grips ChangeDeskClerkToolStripMenuItem. Just click Dim side effects of msg As Integer

msg = MessageBox. Show(“Are you sure you wish to logout? , “LOGOUT, MessageBoxButtons. OKCancel, MessageBoxIcon. Question)

In the event msg = MsgBoxResult. Ok Then

frmLogin. Show()

Me personally. Hide()

End In the event

End Sub

Private Bass speaker systemlock_Click(ByVal fernsehsender As Program. Object, ByVal e Because System. EventArgs)

Dim ask As Integer

ask sama dengan (MessageBox. Show(“The system will probably be locked, Carry on? , “SYSTEM LOCK, MessageBoxButtons. OKCancel, MessageBoxIcon. Warning))

If request = MsgBoxResult. Ok In that case

Me personally. Text sama dengan “Leyte Area Resort Motel ” LOCKED

frmSysLock. ShowDialog()

End In the event that

End Sub

Private Sub LockToolStripMenuItem_Click(ByVal sender As System. Object, ByVal e While System. EventArgs) Handles LockToolStripMenuItem. Click

Dim ask As Integer

question = (MessageBox. Show(“The program will be locked, Proceed? , “SYSTEM LOCK, MessageBoxButtons. OKCancel, MessageBoxIcon. Warning))

In the event ask sama dengan MsgBoxResult. Alright Then

Me. Textual content = “Leyte Park Hotel Hotel ” LOCKED

frmSysLock. ShowDialog()

End If

End Sub

Non-public Sub UserAccoutsToolStripMenuItem_Click(ByVal sender While System. Thing, ByVal elizabeth As System. EventArgs) Grips UserAccoutsToolStripMenuItem. Click frmUserAccounts. ShowDialog()

End Sub

Private Bass speaker checkin_Click(ByVal sender As System. Object, ByVal e Because System. EventArgs) Handles checkin. Click

If checkin. Checked sama dengan True Then simply

frmCheckin. ShowDialog()

Else

frmCheckin. Close()

End If

End Bass speaker

Personal Sub CloudSearch_Click(ByVal sender While Object, ByVal e While System. EventArgs) Handles CloudSearch. Click

txtSearch. Textual content = “

End Sub

Private Bass speaker CalculatorToolStripMenuItem_Click(ByVal sender As System. Object, ByVal e While System. EventArgs) Handles CalculatorToolStripMenuItem. Click

Shell(“calc)

End Bass speaker

Private Sub NewCheckInToolStripMenuItem_Click(ByVal sender Because System. Target, ByVal electronic As Program. EventArgs) Grips NewCheckInToolStripMenuItem. Simply click frmCheckin. ShowDialog()

End Sub

Private Sub reservation_Click(ByVal fernsehsender As System. Object, ByVal e Since System. EventArgs) Handles reservation. Click

frmReservation. ShowDialog()

End Sub

Private Sub NewReservationToolStripMenuItem_Click(ByVal sender As Program. Object, ByVal e Since System. EventArgs) Handles

NewReservationToolStripMenuItem. Simply click frmReservation. ShowDialog()

End Sub

Private Subwoofer Timer2_Tick(ByVal sender As System. Object, ByVal e While System. EventArgs) Handles Timer2. Tick

Me. Opacity = Me. Opacity + 0. one particular

In the event that Me. Opacity = 1 ) 0 In that case

Timer2. Stop()

End In the event

End Sub

Private Bass speaker close_Click(ByVal sender As Program. Object, ByVal e While System. EventArgs) Handles menuclose. Click

End

End Bass speaker

Personal Sub changeuser_Click(ByVal sender Because System. Target, ByVal electronic As System. EventArgs) Manages changeuser. Just click

Poor msg While Integer

msg = MessageBox. Show(“Are you be certain to want to logout? , “LOGOUT, MessageBoxButtons. OKCancel, MessageBoxIcon. Question)

If side effects of msg = MsgBoxResult. Ok Then simply

frmLogin. Show()

Me. Hide()

End If

End Subwoofer

Exclusive Sub RoomToolStripMenuItem1_Click(ByVal sender Since System. Object, ByVal at the As System. EventArgs) Handles RoomToolStripMenuItem1. Simply click

frmAddRoom. ShowDialog()

End Subwoofer

Exclusive Sub RoomTypeToolStripMenuItem_Click(ByVal sender Since System. Target, ByVal at the As Program. EventArgs) Handles RoomTypeToolStripMenuItem. Simply click frmRType. ShowDialog()

End Sub

Private Subwoofer 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 While System. Target, ByVal elizabeth As System. EventArgs) Grips SystemBrowserToolStripMenuItem. Click ‘btnAccept. Obvious = Authentic

toolWeb. Visible = True

MyWebBrowser. Visible = Authentic

txtnav. Text sama dengan “http://www.google.com/

Call gonav. PerformClick()

End Sub

Exclusive Sub refreshweb_Click(ByVal sender Since System. Object, ByVal e As System. EventArgs) Grips refreshweb. Click

MyWebBrowser. Refresh()

End Subwoofer

Exclusive Sub gonav_Click(ByVal sender While System. Subject, ByVal at the As System. EventArgs) Handles gonav. Simply click

MyWebBrowser. Navigate(txtnav. Text)

End Sub

Private Sub home_Click(ByVal sender As Program. Object, ByVal e Since System. EventArgs) Handles house. Click

MyWebBrowser. Navigate(“http://www.google.com/)

fifty nine

txtnav. Text sama dengan “http://www.google.com/

End Bass speaker

Non-public Sub forwardnav_Click(ByVal sender As System. Thing, ByVal elizabeth As Program. EventArgs) Deals with forwardnav. Just click

MyWebBrowser. GoForward()

End Sub

Personal Sub backnav_Click(ByVal sender Since System. Thing, ByVal at the As System. EventArgs) Deals with backnav. Just click

MyWebBrowser. GoBack()

End Subwoofer

Private Sub exitweb_Click(ByVal sender As System. Thing, ByVal electronic As Program. EventArgs) Handles exitweb. Click

‘btnAccept. Visible sama dengan False

MyWebBrowser. Obvious = Fake

toolWeb. Visible = False

End Sub

Non-public Sub GoogleChromeToolStripMenuItem_Click(ByVal sender Since System. Object, ByVal e As System. EventArgs) Grips GoogleChromeToolStripMenuItem. Just click Try

Shell(“C: \Users\RJ\AppData\Local\Google\Chrome\Application\chrome. exe) Catch ex Because Exception

MessageBox. Show(“No Google Chrome Installed, “Error, MessageBoxButtons. OK, MessageBoxIcon. Error)

End Make an effort

End Sub

Private Sub MozillaFirefoxToolStripMenuItem_Click(ByVal fernsehsender As System. Object, ByVal e Since System. EventArgs) Handles MozillaFirefoxToolStripMenuItem. Click Try

Shell(“C: \Program Files\Mozilla Firefox\firefox. exe)

Catch ex As Exception

Shell(“C: \Program Files (x86)\Mozilla Firefox\firefox. exe) End Try

End Sub

Private Sub InternetExplorerToolStripMenuItem_Click(ByVal tv-sender As System. Object, ByVal e As System. EventArgs) Handles InternetExplorerToolStripMenuItem. Click Shell(“C: \Program Files\Internet Explorer\iexplore. exe) End Subwoofer

Private Sub btnAccept_Click(ByVal tv-sender As Program. Object, ByVal e As System. EventArgs) 60

Handles btnAccept. Click

gonav. PerformClick()

End Sub

Private Bass speaker DiscountsToolStripMenuItem_Click(ByVal tv-sender As Program. Object, ByVal e Because System. EventArgs) Handles DiscountsToolStripMenuItem. Click

frmDiscount. ShowDialog()

End Sub

Private Bass speaker StaffManagementToolStripMenuItem_Click(ByVal tv-sender As Program. Object, ByVal e Since System. EventArgs) Handles StaffManagementToolStripMenuItem. Click frmStaffView. Show()

End Subwoofer

Personal Sub checkout_Click(ByVal sender Since System. Target, ByVal elizabeth As Program. EventArgs) Manages checkout. Just click

btnCloseCancelReserve. PerformClick()

btnCloseReservationList. PerformClick()

FillListCheckout()

In the event that checkout. Checked out = The case Then

toolCheckout. Obvious = Accurate

lvCheckout. Visible = True

lvCheckout. Boat dock = DockStyle. Fill

lvCheckout. BringToFront()

Otherwise

toolCheckout. Visible = False

lvCheckout. Obvious = False

lvCheckout. Dock sama dengan DockStyle. None of them

End If

End Bass speaker

Personal Sub ToolStripButtonClose_Click(ByVal sender Because System. Object, ByVal e As Program. EventArgs) Manages btnCloseCheckout. Just click

peruse. Checked = False

toolCheckout. Obvious = Bogus

lvCheckout. Visible sama dengan False

End Subwoofer

Private Sub lvCheckout_SelectedIndexChanged(ByVal sender Because System. Target, ByVal e As Program. EventArgs) Grips lvCheckout. SelectedIndexChanged

If lvCheckout. SelectedItems. Count >0 Then

With lvCheckout. SelectedItems(0)

roomno =. Text

fname =. SubItems(1). Text

lname =. SubItems(2). Text

charges sama dengan. SubItems(10). Text message

advance_payment =. SubItems(11). Text

balance =. SubItems(12). Text

End With

End If

End Sub

Private Bass speaker lvCheckout_MouseDoubleClick(ByVal fernsehsender As Target, ByVal elizabeth As Program. Windows. Varieties. MouseEventArgs) Manages lvCheckout. MouseDoubleClick If lvCheckout. SelectedItems. Count >0 After that

With lvCheckout. SelectedItems(0)

roomno =. Text message

fname =. SubItems(1). Text

lname sama dengan. SubItems(2). Textual content

total =. SubItems(8). Text

charges sama dengan. SubItems(10). Textual content

advance_payment =. SubItems(11). Text

balance =. SubItems(12). Text

End With

End In the event that

connectdbase2()

Make an effort

With cmd

. Connection sama dengan con

. CommandText sama dengan “SELECT 5. 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 doctor HasRows sama dengan True Then simply

In the event that MessageBox. Show(“Check-Out Guest? , “Room inch & roomno, MessageBoxButtons. YesNo, MessageBoxIcon. Question) = vbYes Then frmPayment. ShowDialog()

End In the event

End If

End In the event that

Get ex As Exception

MessageBox. Show(Err. Description, “Error, MessageBoxButtons. OKAY, MessageBoxIcon. Error)

Finally

que incluye. Close()

End Try

End Sub

Private Subwoofer ToolStripButtonCheckout_Click(ByVal fernsehsender As Program. Object, ByVal e Because System. EventArgs) Handles btnCheckOut. Click

connectdbase2()

Try

With cmd

. Interconnection = que contiene

. CommandText = “SELECT * FROM tblRoom ” & _

“WHERE room_no=’ & roomno & “‘

End With

doctor = cmd. ExecuteReader

dr . Read()

If roomno sama dengan “ After that

MessageBox. Show(“Select guests to checkout, “Check-Out Failed, MessageBoxButtons. FINE, MessageBoxIcon. Exclamation)

Different

If perhaps dr . HasRows = True Then

If MessageBox. Show(“Check-Out Customer? , “Room ” & roomno, MessageBoxButtons. YesNo, MessageBoxIcon. Question) sama dengan vbYes Then simply frmPayment. ShowDialog()

End If

End In the event that

End If

Catch ex As Exclusion

MessageBox. Show(Err. Explanation, “Error, MessageBoxButtons. OK, MessageBoxIcon. Error) Finally

que contiene. Close()

End Try

End Sub

Private Bass speaker ChargesToolStripMenuItem_Click(ByVal tv-sender As Program. Object, ByVal e As System. EventArgs) Handles ChargesToolStripMenuItem. Click

frmCharges. ShowDialog()

End Sub

Private Subwoofer toolTxtSearch_TextChanged(ByVal fernsehsender As Object, ByVal elizabeth As Program. EventArgs) Grips txtSearchOut. TextChanged

In the event that ToolStripComboBox1. Text = “Last Name In that case

Contact likelname()

ElseIf ToolStripComboBox1. Text = “First Name Then

Call likefname()

ElseIf ToolStripComboBox1. Textual content = “Room No . Then

Call likeroomno()

Otherwise

Call FillListCheckout()

End If

End Sub

Private Bass speaker ReservationListToolStripMenuItem_Click(ByVal fernsehsender As System. Object, ByVal e Since System. EventArgs) Handles ReservationListToolStripMenuItem. Click btnCloseCheckout. PerformClick()

Call btnCloseCancelReserve. PerformClick()

toolReservationList. Obvious = The case

lvReserve. Visible sama dengan True

lvReserve. Boat dock = DockStyle. Fill

lvReserve. BringToFront()

FillListReserve()

End Sub

Private Bass speaker ToolStripButton5_Click(ByVal tv-sender As System. Object, ByVal e Because System. EventArgs) Handles btnCloseReservationList. Click

toolReservationList. Obvious = False

lvReserve. Visible = False

txtSearchReserve. Text = “

comboReserve. Text = “

End Sub

Exclusive Sub txtSearchReserve_TextChanged(ByVal sender As Object, ByVal e As System. EventArgs) Handles txtSearchReserve. TextChanged

If comboReserve. Text sama dengan “Last Name Then

Call likelnameReserve()

ElseIf comboReserve. Text message = “First Name After that

Call likefnameReserve()

ElseIf comboReserve. Text sama dengan “Room No . In that case

Call likeroomnoReserve()

ElseIf comboReserve. Text sama dengan “Date In that case

Contact likedateReserve()

Else

Call FillListReserve()

End If

End Bass speaker

Exclusive Sub CancelReservationToolStripMenuItem_Click(ByVal sender As System. Subject, 64

ByVal at the As Program. EventArgs) Deals with CancelReservationToolStripMenuItem. Click btnCloseCheckout. PerformClick()

Contact btnCloseReservationList. PerformClick()

FillListReserve()

toolCancelReserve. Visible = True

lvReserve. Visible = True

lvReserve. Dock sama dengan DockStyle. Fill up

lvReserve. BringToFront()

End Bass speaker

Personal Sub btnCloseCancelReserve_Click(ByVal sender While System. Target, ByVal e As System. EventArgs) Handles btnCloseCancelReserve. Simply click

toolCancelReserve. Visible sama dengan False

lvReserve. Noticeable = Bogus

txtSearchCancel. Text sama dengan “

comboCancel. Textual content = “

End Sub

Private Bass speaker txtSearchCancel_TextChanged(ByVal fernsehsender As Subject, ByVal e As System. EventArgs) Deals with txtSearchCancel. TextChanged

In the event that comboCancel. Text message = “Last Name In that case

Phone likelnameReserve()

ElseIf comboCancel. Text sama dengan “First Name Then

Call likefnameReserve()

ElseIf comboCancel. Textual content = “Room No . Then

Call likeroomnoReserve()

ElseIf comboCancel. Text = “Date Then

Call likedateReserve()

Different

Contact FillListReserve()

End In the event

End Sub

Private Subwoofer lvReserve_MouseDoubleClick(ByVal fernsehsender As Object, ByVal at the As Program. Windows. Varieties. MouseEventArgs) Grips lvReserve. MouseDoubleClick If toolReservationList. Visible sama dengan True Then simply

If perhaps lvReserve. SelectedItems. Count >0 Then

With lvReserve. SelectedItems(0)

cr_resno =. Text

End With

End If

End In the event that

sixty-five

End Sub

Private Sub lvReserve_SelectedIndexChanged(ByVal fernsehsender As Program. Object, ByVal e As System. EventArgs) Handles lvReserve. SelectedIndexChanged

If lvReserve. SelectedItems. Rely >0 After that

With lvReserve. SelectedItems(0)

cr_datereserve =. Text

cr_resno =. SubItems(1). Text

cr_stat sama dengan. SubItems(2). Text message

cr_roomno =. SubItems(3). Text

cr_fname =. SubItems(4). Text message

cr_lname =. SubItems(5). Text

End With

End If

End Bass speaker

Exclusive Sub btnCancelReservation_Click(ByVal sender Since System. Thing, ByVal at the As Program. EventArgs) Grips btnCancelReservation. Just click

frmCancelReserve. ShowDialog()

End Bass speaker

Non-public Sub timerChecker_Tick(ByVal sender As System. Thing, ByVal at the As Program. EventArgs) Grips timerChecker. Tick

Poor CountVacant, CountReserved, CountOccupied, CountClean As Integer connectdbase2()

sql sama dengan “SELECT * FROM tblRoom WHERE room_stat=’Vacant’ da sama dengan New OleDbDataAdapter(sql, con)

da. Fill(ds, “hmsdb)

sql2 = “SELECT 5. FROM tblRoom WHERE room_stat=’Reserved’ da2 sama dengan New OleDbDataAdapter(sql2, con)

da2. Fill(ds2, “hmsdb)

sql3 = “SELECT 5. FROM tblRoom WHERE room_stat=’Occupied’ da3 = New OleDbDataAdapter(sql3, con)

da3. Fill(ds3, “hmsdb)

sql4 = “SELECT * FROM tblRoom WHERE room_stat=’Clean’ da4 sama dengan New OleDbDataAdapter(sql4, con)

da4. Fill(ds4, “hmsdb)

con. Close()

CountVacant = ds. Tables(“hmsdb). Rows. Count

statusVacant. Textual content = “Vacant: (” & CountVacant & “)

CountReserved sama dengan ds2. Tables(“hmsdb). Rows. Rely

statusReserved. Text sama dengan “Reserved: (” & CountReserved & “) CountOccupied sama dengan ds3. Tables(“hmsdb). Rows. Count

statusOccupied. Text = “Occupied: (” & CountOccupied & “) CountClean sama dengan ds4. Tables(“hmsdb). Rows. Count number

statusClean. Text = “Clean: (” & CountClean & “)

ds. Clear()

ds2. Clear()

ds3. Clear()

ds4. Clear()

timerChecker. Stop()

End Subwoofer

Personal Sub timerChecker2_Tick(ByVal sender While System. Subject, ByVal elizabeth As System. EventArgs) Manages timerChecker2. Tick

Dim CountOccupied, CountClean As Integer

sql = “SELECT * FROM tblRoom WHEREVER room_stat=’Occupied’ de uma = Fresh OleDbDataAdapter(sql, con)

de uma. Fill(ds, “hmsdb)

sql2 = “SELECT * BY tblRoom IN WHICH room_stat=’Clean’ da2 = Fresh OleDbDataAdapter(sql2, con)

da2. Fill(ds2, “hmsdb)

con. Close()

CountOccupied sama dengan ds. Tables(“hmsdb). Rows. Count

statusOccupied. Text = “Occupied: (” & CountOccupied & “) CountClean = ds2. Tables(“hmsdb). Rows. Rely

statusClean. Text sama dengan “Clean: (” & CountClean & “)

ds. Clear()

ds2. Clear()

timerChecker2. Stop()

End Sub

Private Sub CheckOutToolStripMenuItem_Click(ByVal sender As System. Target, ByVal at the As Program. EventArgs) Grips CheckOutToolStripMenuItem. Simply click

checkout. PerformClick()

End Bass speaker

Personal Sub ToolStripButton1_Click(ByVal sender As System. Target, ByVal e As System. EventArgs) Handles ToolStripButton1. Simply click

frmChangeRoom. ShowDialog()

End Sub

Private Sub ChangeRoomToolStripMenuItem_Click(ByVal sender As System. Thing, ByVal elizabeth As System. EventArgs) Grips ChangeRoomToolStripMenuItem. Just click frmChangeRoom. ShowDialog()

End Sub

Private Subwoofer OrderCategoriesToolStripMenuItem_Click(ByVal fernsehsender As System. Object, ByVal e Because System. EventArgs) Handles OrderCategoriesToolStripMenuItem. Click frmRestaurantCategories. ShowDialog()

End Sub

Personal Sub OrderItemsToolStripMenuItem_Click(ByVal sender As System. Thing, ByVal e As Program. EventArgs) Manages OrderItemsToolStripMenuItem. Click frmRestaurantItems. ShowDialog()

End Sub

Private Subwoofer btnOpen_Click(ByVal sender As Program. Object, ByVal e Since System. EventArgs) Handles btnOpen. Click

End Sub

End Class

APPENDIX G

Test Input/Output Studies

Daily Occupancy Statement

Form

Output

Reservation Report

Form

Output

APPENDIX At the

USERS GUIDE

I. Advantages

Leyte Park Vacation resort Hotel Administration and Providers System is computerized management software intended for Windows. It is a complete answer, beginning with choosing type of procedure which is the hotel procedure and the cafe operation likely to hotel concerns, check in/check out, ordering of foods, services and ending with billing and sales reviews. The user user interface is cautiously optimized for high speed suggestions and the prevention of common mistakes. It’s designed for applying on multiple computers, and contains reliable and secure consent levels. 2. Manual

A. The Manual System

First of all in START MENU window you have to select between the two options the Front Desk (Server) and the Veranda Bistro Restaurant (Client) after

that, in Login window select consumer type then enter the user brand and username and password. User term is a worker’s user identity (login). Password is a worker’s password.

When you initially time manage Hotel Administration Services Program you need to your default end user name: admin and username and password: admin and user type is administrator. After that you will need to define users and change facilitators password.

The front Desk is the server in the system. In this article you can access the setup of the program. Note that you need to have an administrator’s access privileges to access all configurations inside the system. 71

Administrators -There are sub modules under the main component Administrators. ¢ User Accounts Configuration- Note that you should have a great administrator’s access rights to get into items settings.

To set up User Accounts setup click Manager >User Accounts. Here you are able to manage the user accounts for the suer from the system. Each user accounts has it can user identity, password, full name of the end user.

¢ Personnel Configuration

To set up Personnel configuration Simply click Administrator >Staff>.. Staff Configuration has it is sub quests the Office and Situation where you can add, edit, erase Departments and Positions. Every single Staff has it’s Worker ID, Last-name, First Name, M. I., Gender, Tackles, Contact No ., Department, and Position.

Select the Staff from your list and click Edit button to access to the staff’s profile. If you wish to add a new staff for the list of almost all staff, click Add button. To delete a staff through the list, to start with choose that worker and after that click Erase button.

¢ Rooms Configuration

To build Rooms construction you first need to include Room Types. To add Area Types Click Administrator >Put Room >Area Type. Each Room Type has is actually own Space Type Term, Number of People, Room Description. After completing the Room Types. You can now put Rooms. To do add Space, Click Manager >Room >Add Room. Every Room provides it’s personal Room Number, Room Type, Rate, Number of Persons, Place Description. Remember that you should have a great administrator’s get rights to gain access to items setup. ¢ Function Hall Setup

The function room can be where the incidents are held such as group meetings, conventions, conferences 72

and other holidays.

To create Function Hall configuration simply click Administrator >Function Hall. Every single Function Corridor has it’s Name of Events, Contact Person, Timetable, No . of Pax, Rate. ¢ Products and Expenses Configuration

To setup Items and Charges construction click Administrator >Extra Items/Charges. Each Item/Charges has it can Item/Charges term, item amount, rate. To incorporate a item or expenses click Add button. Enter in Item/Charges feature and press save. Fresh Item/Charges will probably be added to record of all existing items/charges. You can also edit item/ charges’ characteristics by hitting Edit press button. To delete an item/charges from the list of all existing items click Delete switch or work with Delete important on your key pad. ¢ Discounts Configuration

To set up Discounts setup click Administrator >Discounts. Each Discounts features it’s discount type, price cut rate.

¢ Solutions Configuration

To set up Providers configuration just click Administrator >Services. Here you add, change, delete solutions. Each Providers has it can name or perhaps type of support and cost.

¢ Restaurant Settings

To create Restaurant setup click Administrator >Restaurant Construction. Here you can add, edit, delete and view items to get the Cafe. Each has it’s category, price and ingredients.

B. The computer system

1 ) Terminal/Keyboard Familiarization

Users should have a knowledge about laptop in order for them to totally recognize the actual system could give. Standard computer expertise like beginning the computer, starting a browser and etc.

2 . First-time end users

a. Starting out

This is actually the first step within a series that show you how to use Hotel Administration and Services System. This kind of tutorial methods you throughout the process of creating the system. This allows you to set your local information, fees and room information.

When you run the application first, you are going to select between your Front Workplace and Coffee shop Veranda Cafe Menu and then in the Sign in window the program will ask you to get the User name, Password and User Type.

b. Lessons

End user Accounts

This is the to create a new Consumer. There is the Customer Accounts switch under Supervisor Menu, click that, load the information, select the permission admin, front desk, or cashier and preserve them. In this article the admin and desk clerk/cashier permissions vary as admin has the full authority in the program to improve the settings or to create new user’s account or authority however in the office clerk/cashier bank account there are no such authorities. Desk clerk/cashier can simply utilize the configured plan.

ROOM CONSTRUCTION:

Place configuration has just two things to configure we. e. space price and room type. To change these two stick to these steps:

¢ Simply click Administrator menu and go to Add Room Type.

¢ Fill up the items Room Type (as Single Room, Deluxe etc), Maximum Persons and Room Information and save.

¢ Now go to Administrator >Space and select Add Room.

¢ At this point Give the Space No ., Choose Room Type and Area Rate (price for being for twenty four hours) after that save that. You can also edit and erase these articles.

RESTAURANT CONFIGURATION:

Restaurant Settings has just likewise two things to configure i. e. products category and items. To configure those two follow these steps:

¢ Click on Supervisor menu and go to Products Category

¢ Fill up the items Category Number and Category Name then simply save this. ¢ Today go to Officer >Restaurant Settings and select Products. ¢ Today Give the Item Name., Select Item Category and Item Price in that case save it. You can also edit and delete these records.

C. Reference point Manual

1 . Open the Executable File “Hotel Management System. exe 2 . Select Operation “Front Desk or Restaurant

3. Choosing the Front Workplace will open the Login Form to get Front Desk 75

4. Insight the valid username and password in the Login Contact form

5. In the Front side Desk selecting Desk Attendant user type you can Abfertigung, Check-Out, Book Customer, Change Room, Look at Report and also other functions. Choosing Administrator you can access the configurations with the system.

6th. Selecting the Restaurant can open the Login kind for the Restaurant and there you are able to input username and password for the cashier.

7. Inside the Restaurant you are able to select purchases of the consumers according to there types. 76

APPENDIX Farreneheit

PROCESS/DATA/INFORMATION FLOW

Reserve simply by

Reservation

Buyer

Guests

Customer_ID

First Name

Last Name

Middle

Name

Address

Contact_No

Name

Books

Room

Room_no

Room_Type

Room Type

Type_ID

Term

Room Price

Manage By simply

Will pay

Payment_ID

Cutomer_ID

Room_NO

Booking

Position

Reservation_ID

Repayments

Cutomer_ID

Reservation_ID

Payment_ID

Amount

Accumulate

Cashier

Cutomer_ID

Payment_ID

Control By

System Customer

User_ID Password

Username

Admin

Handled By simply

seventy seven

APPENDIX G

CURRICULUM VITAE

Rj Dejolde Madia

Rj Dejolde Madia came to be on the 28th day of June in the year 1989, in Tacloban City. He is the third child from the four children of Mister. Ruben T. Madia Sr. and Mrs. Josephine C. Madia. He lives in Brgy. 88, Baloc you, 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 Nationwide High School, Tacloban City graduated in the year june 2006. He completed 2-year Computer Programming Dual Schooling System Program at Leyte Technological Basis College. And currently, he’s a third season Bachelor of Science in Information Technology (BSIT) student of ACLC School Tacloban. This individual attended trainings and workshops such as Seminar in Networking (March 12-15, 2007), Leyte Samar IT Summit (Sept. 07 2012)

CURRICULUM VITAE

April Happiness S. Acaban

The spring Joy S. Acaban was born on the 12th day of April back in 1992., in Calbiga Western Samar. The girl with the oldest daughter of Mr. Vivencio C. Acaban and Mrs. Rosemarie S i9000. Acaban. Your woman lives for Brgy. Patong Calbiga, Samar.

She managed to graduate in primary in Patong Elementary School back in of 2005-2006. Her supplementary education was in Calbiga Nationwide High School graduated in the year of 2008-2009. The girl with a Third yr Bachelor of Science in Information Technology (BSIT) student of ACLC School Tacloban.

She attended exercising and seminars such as Workshop Leyte Samar IT Summit (Sept. ’07 2012)

CURRICULUM VITAE

Rj Dejolde Madia

Rj Dejolde Madia was developed on the 29th day of June in the year 1989, in Tacloban City. He is the 3 rd child from the four kids of Mr. Ruben H. Madia Sr. and Mrs. Josephine C. Madia. He lives for 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 Countrywide High School, Tacloban City graduated in the year 2005. He finished 2-year Computer Programming Dual Schooling System Program at Leyte Technological Groundwork College. And currently, he can a third year Bachelor of Science in Information Technology (BSIT) student of ACLC School Tacloban. This individual attended trainings and workshops such as Workshop in Networking (March 15, 2007), Leyte Samar THAT Summit (Sept. 07 2012)

CURRICULUM VITAE

Dion Rae B. Entre ma Cruz

Dion Rae B. De La Cruz was developed on the fourteenth day of November in the year 1992., in Tacloban City. He is the most youthful child of the 3 children of Mr. Dionisio Ur. De La Cruz and Mrs. Edna N. De La Jones. He lives at Brgy. 62-B Great deal 19 Enjoyment Sagkahan Tacloban City. He graduated general in Cookware Development Basis College, Tacloban City in the year 2005-2006. His secondary education was in Hard anodized cookware Development Basis College, Tacloban City managed to graduate in the year 2009-2010. He is another year Bachelors of Scientific research in Information Technology (BSIT) pupil of ACLC College Tacloban.

He joined trainings and seminars including Seminar Leyte Samar IT Summit (Sept. 07 2012).

He attended trainings and workshops such as Workshop in Networking (March 12-15, 2007), Leyte Samar THAT Summit (Sept. 07 2012)

CURRICULUM VITAE

Jumar Val N. Guarino

Jumar Alternativ N. Guarino was born on the 16th working day of September in the year 1992.

, in Ormoc City. He is the most youthful child in the 3 kids of Mr. Valentin and Mrs. Juvilinda N. Guarino. He lives atBrgy. Salud Lide Personnel Housing Isabel, Leyte. He graduated elementary in Doane Baptisit Institution, Isabel, Leyte in the year 2005-2006. His second education was at Doane Baptist School, Isabel, Leyte managed to graduate in the year 2009-2010. He is another year Bachelor of Scientific research in Information Technology (BSIT) scholar of ACLC College Tacloban.

He joined trainings and seminars such as Seminar Leyte Samar IT Summit (Sept. 07 2012).

Aug

WEEK4 WEEK1 WEEK2 WEEK3 WEEK4 WEEK5 WEEK6 WEEK7 WEEK8

Making of Project Proposal

Project name and contents

Respondent

Requirement Specs.

Hardware, Application, End-users

Suppliers/Vendors

Interview Questionaires

Carry out Interview

Data Gathering

Price and Advantage Analysis

Logical Design

Framework Diagram (Existing & Proposed)

DFD (Existing & Proposed)

System Stream Chart (Existing & Proposed)

VTOC (Exisitng & Proposed)

IPO (Existing & Proposed)

Display Design (Proposed)

Survey and form Design (Proposed)

Menu Design (Proposed)

System Security

Network Design/Layout

LOCAL AREA NETWORK

WAN

Data source Design

Normalization

Entity-Relationship-Diagram

Physical Design

Model Design(Include software)

Program Program/Software

Network(LAN/WAN)

Installation of Computer software and Equipment

Final Prototype Design(End-User Testing)

Final Information

System Documentations

User Manual

Dental Defense(System Presentation)

a few. IMPLEMENTATION

1 . PREPARING

installment payments on your ANALYSIS

GHANT GRAPH

LENGTH IN WEEKS (AUGUST TO OCTOBER 2012)

September October

3. DESIGN AND STYLE

four. DEVELOPMENT

< Prev post Next post >

Lodge management system essay

Related posts