hoel managment doc
TRANSCRIPT
-
8/6/2019 Hoel Managment Doc
1/78
INTRODUCTION
This is a Project work undertaken in context of partial fulfillment of Msc. Computer science. I have tried my best to make the
complicated process of Hotel Management System as simple as possible using Structured & Modular technique & Menu orientedinterface. I have tried to design the software in such a way that user may not have any difficulty in using this package & further
expansion is possible without much effort. Even though I cannot claim that this work to be entirely exhaustive, the main purpose ofmy exercise is perform each Employees activity in computerized way rather than manually which is time consuming.
I am confident that this software package can be readily used by non-programmingpersonal avoiding human handled chance of error. This project is used by two types of
users
i. Users.(Hotel Authorize employees)ii. Administrator (manager of the Hotel).
users can do the computerize work which is related to hotel management just like customer reservation , check in, check out etc. &Administrator can maintain daily updates in the hotel records. Administrator is must be an authorized user. He can further change the
password set the user permission etc main work. The main aim of the entire activity is to automate the process of day to day activities
of Hotel like Room activities, Admission of a New Customer, Assign a room according to customers demand, checkout of acomputer and releasing the room and finally compute
the bill etc.The limited time and resources have restricted us to incorporate, in this project, only a
main activities that are performed in a HOTEL Management System, but utmost care has been taken to make the system efficient anduser friendly. HOTEL Management
System has been designed to computerized the following functions that are performed
by the system.1. Room Detail Functions
2. Opening a New Room3. Modification to room assigned
4. New Customer registration
5. New Employee registration6. Reservation of Customer
7. Check-In of Customer Detail Functions8. Check-Out of Customer Detail Functions
9. Room Change10.Room assigning related to customers need.
11.Statement of Customer Details
12.Other services assign to customer13.Customer Billing
14.Total number of Customers in the Hotel
15.Individual customer Report
-
8/6/2019 Hoel Managment Doc
2/78
OBJECTIVE
During the past several decades personnel function has been transformed from arelatively obscure record keeping staff to central and top level management function.
There are many factors that have influenced this transformation like technologicaladvances, professionalism, and general recognition of human beings as most important
resources.
A computer based management system is designed to handle all the primaryinformation required to calculate monthly statements. Separate database is
maintained to handle all the details required for the correct statement calculationand generation. This project intends to introduce more user friendliness in the various activities such as record updation, maintenance,
and searching.
The searching of record has been made quite simple as all the details of thecustomer can be obtained by simply keying in the identification of that customer.
Similarly, record maintenance and updation can also be accomplished by usingthe identification of the customer with all the details being automatically
generated. These details are also being promptly automatically updated in themaster file thus keeping the record absolutely up-to-date. The entire information has maintained in the database or Files and whoever
wants to retrieve cant retrieve, only authorization user can retrieve the necessary information which can be easily be accessible from
the file.The main objective of the entire activity is to automate the process of day to day
activities of Hotel like.
1. Room activities,
2. Registration of a New Customer,3. Assign a room according to customers demand,
4. Customer reservation5. Check In of a computer and assigning the room
6. Other services provide to customer7. Room change function
8. Check Out of a computer and releasing the room
9. Finally compute the bill etc.6. Packages available.
8. Reservation Cancellation.
9. List of Regular customers.10. Feedbacks.
-
8/6/2019 Hoel Managment Doc
3/78
This project have some more features:
1. System Connectivity
2. No data duplication3. No Paper Work Required
4. Time Efficient5. Cost Efficient
6. User friendly environment7. Data security and reliability
8. Fast data insertion & retrieval
9. Easy performance check
-
8/6/2019 Hoel Managment Doc
4/78
ADVANTAGE:
I have designed the given proposed system in the C# to automate the process of Hotels. This project is useful for the authoritieswhich keep track of all the users registered in a particular state. The authority can add hotel packages, room details, availability of
rooms, Reservation Check In Check Out Other services etc. The following steps that give the detailed information of the need of
proposed system are,
Performance:
During past several decades, the records are supposed to be manually handled for all activities. The manual handling of the record
is time consuming and highly prone to error. To improve the performance of the Hotel Management System, the computerized system
is to be undertaken. This project is fully computerized and user friendly even that any of the members can see the report and status ofthe company.
Efficiency:
The basic need of this Software is efficiency. The Software should be efficientso that whenever a new user submits his/her details the Software is updated automatically. This record will be useful for other users
instantly.
Control:
The complete control of the project is under the hands of authorized person who
has the password to access this project and illegal access is not supposed to deal with. All the control is under the administrator andthe other members have the rights to just see the records not to change any transaction or entry.
-
8/6/2019 Hoel Managment Doc
5/78
Security:
Security is the main criteria for the proposed system. Since illegal access may
corrupt the database. So security has to be given in this project.
System Study & Analysis
PRINCIPLES OF SYSTEM ANALYSIS
1. Understand the problem before you begin to create the analysis model.
2. Develop prototypes that enable a user to understand how human machine interactionwill occur.
3. Record the origin of and the reason for every requirement.4. Use multiple views of requirements like building data, function and behavioral
models.5. Work to eliminate ambiguity.
ENTITY RELATIONSHIP DIAGRAM (ERD)
Entity Relationship Diagram: This depicts relationship between data objects.
The attribute of each data objects noted in the entity- relationship diagram can bedescribed using a data object description. Data flow diagram serves two
-
8/6/2019 Hoel Managment Doc
6/78
purposes:1. To provide an indication of how data are transformed as they move through
the system.
2. To depict the functions that transformation the data flow.
Data Objects:
A data object is a representation of almost any composite information that must be understood by the software. By compositeinformation, we mean something that has a number of different properties or attributes. A data object encapsulates data only there is
no reference within a data object to operations that act on the data.
Attributes:
Attributes define the properties of a data object and take on one of three different characteristics. They can be used to: Namean instance of data object. Describe the instance. Make reference to another instance in other table.
Relationships:
Data objects are connected to one another in a variety of different ways. We can define a set of object relationship pairs that
define therelevant relationships.
CARDINALITY AND MODALITY:
Cardinality:
The data model must be capable of representing the number of
occurrences of objects in a given relationship. The cardinality of an
object relationship pair is
One- T0-One (1:1):An occurrence of object A can relate to one and only one occurrence of object B and vice versa.
One-To-Many (1:N):
-
8/6/2019 Hoel Managment Doc
7/78
One occurrence of object A can relate to one or may occurrences of object B but an occurrence of object B can
relate to only one occurrence of object A.
Many-To-Many (M: N):An occurrences of B and an occurrence of B can relate to one or many occurrence oA.
Modality:
The modality of a relationship is zero if there is no explicit need for the relationship to occur or the relationship isoptional. The Modality is one if the occurrence of the relationship is mandatory. The object relationship pair can be
represented graphically using the Entity Relationship Diagrams. A set of primary components are identified for the Entity
Relationship Diagram,
1. Attributes,
2. Relationships and
3. Various Type Indicators.
The primary purpose of the Entity Relationship Diagram is to represent
data objects and their relationships.
Function Details
The basic objective ofHOTEL MANAGEMENT SYSTEM is to generalize andsimplify the monthly or day to day activities of Hotel like Room activities, Registration of new customer, reservation of register
Customer, Check in of register Customer, Check out of customer, Assigning a room according to customer requirement, and changing
the room as per customer request finally compute the bill etc. which has to be erformed repeatedly on regular basis. To provide
-
8/6/2019 Hoel Managment Doc
8/78
efficient, fast, reliable and user-friendly system is the basic motto behind this exercise. Let us now discuss how different functionshandle the structure and data files:
1 Password
In this module, this software is for multiple authorize users & admin. If a User enters a password and the software checks itsvalidity. If the password is valid then option is given to change the password, otherwise Invalid User/Password message is
displayed. There is an option for password recovery, log out, login, new users sign in. The Administrator can also update changes inthe site after login.
2 Creating new Entity (Hotel, Room, Customers, Employee etc.)
This is used to add a new customer details, add a new employee details, delete entity details and view the details. In thatscreen, the automatic item is created. In this function, whenever a new entity is required to be added the corresponding forms are
opened and the database is manipulated to check whether the data is already existing
or not. If it already exists, then it prompts that Entry already existing and if not than thedata is entered with the various validation checks.
3.Function NEW_ROOM()
This is the function used to open a new room for a customer so that he/she can
assign a separate room . In that screen, the manually room number is created. After opening a new room for the customer, finally a
room is assigned to a customer and the room records are appended in the data file.
4.Function RESERVATION_CUSTOMER()
This function is used to advance booking of a customer in our Hotel after entering his all personal details like Name, Address,
Phone, Sex, valid photo id & address proof and then he/she is assigned a room from NEW_ROOM() function. On reservation date.
5.Function CHECKIN_CUSTOMER()
This function is used to admit a customer in our Hotel after entering his all
personal details like Name, Address, Phone, Sex, valid photo id & address proof and then he/she is assigned a room from NEW_ROOM() function.
-
8/6/2019 Hoel Managment Doc
9/78
6.Function CHECKOUT_CUSTOMER()
This function is used to checkout the customer details from database. When theuser inputs his Folio number, the same room number will be checked in the database, if the Folio number is matched in the database,
then the customer will be check-out from the database and transferred the record of the checkout to another table of database so thatthe Hotel Management has the record of customers who have check-out to fulfill his legal liabilities.
7.Function GENERATE_BILL()
When any customer check-out, his/her bill is generated automatically bycalculated check-out date minus check-in date and getting multiplied it by daily
room charge plus other charges and the bill has to be saved in the table in thedatabase. If possible some customer get discount on given hotel package etc.
8.Function DISPLAY_CUST_DETAILS()
This function is used to display all the information including the customer name, address, phone, etc. This is a global report todisplay all the transaction records in the screen.
9. Validation of Data Entered by the User & Error Handling
In this function, the validity of data entered by the user during the various business processes is checked through various
validation checks. For example, there should not be any characters entered in the numeric fields, likewise if there is any error occursthan it should handle that particular error and give the required messages.
10 Searching
In this function, room, customer well as members can search details from the database according to their authentications.
11: Report Generation
-
8/6/2019 Hoel Managment Doc
10/78
In this function reports are generated for the following entities:
1. Individual customer details report.
2. All available customer report.3. Check In report of individual customer.
4. Check Out report of individual customer.5. Reservation history report.
6. Check in history report.7. Check out history report.
8. Room details report.
9. Billing detail report.10. Employee detail report.
11. Customer detail report.Many more reports related to small modules.
-
8/6/2019 Hoel Managment Doc
11/78
Scope of Future Application
This project can be used in the hotel after adding some more useful modules in the project for which hotel are providing
services. Utmost care and back-up procedures must be established to ensure 100% success full implementation of the computerizedhotel management system. In case of system failure, the organization should be in a position to process with another system which are
the part of that organization or if the worst comes to the worst, it should be in a position to complete it manually.
-
8/6/2019 Hoel Managment Doc
12/78
Scope of Improvement
Now a days hotel are providing many other facilities, this project can also be improved with the improvement in the Hotels.Utmost care and back-up procedures must be established to ensure 100% successful implementation of the computerized hotel
management system. In case of system failure, the organization should be in a position to process with another system which are thepart of that organization or if the worst comes to the worst, it should be in a position to complete it manually.
-
8/6/2019 Hoel Managment Doc
13/78
CONCLUSION
This project is designed to meet the requirements of Hotel Management. It has
been developed in C# .NET keeping in mind the specifications of the system. for designing the system we have used simple data flowdiagrams. Overall the project teaches us the essential skills like:
Using system analysis and design techniques like data flow diagram in designing the
system understanding the database handling and query processing.Computer has got clear advantage over the manual system. The computerized system is more reliable, efficient and fast at the
end of the project, I can say that computer play a very crucial role in the development of firm. All the daily reports generated by thesystem are to be checked by the concerned official so as to ensure that all the management have been put through in appropriate.
Computer does maximum work with in minimum time. Because it is used in every field so that it provides comfort and
suitability to everyone. Providing maximum facilities and comfort to customers to customers is main goal of the firm. To achieve thisgoal, other modern facilities relating to computer should have to be provided.
-
8/6/2019 Hoel Managment Doc
14/78
ACKNOWLEDGEMNT
Project development is not an easy task. It requires corporation and help of various people. It always happens that word run out
when we are really thankful and sincerely want to inspire my feeling of gratitude towards the one when helped in the completion of
the project. First my grateful thank to Mr. Kishor Pawar (principal) K.S.K.W. Arts. Sci. & Com. College, Nasik. Today after
completing my project work, I am immensely satisfied. There were many times during the span of making the project when the clock
beats you to learn out of energy and you just want to finish at forever but Miss. Sheetal sonawne helped me such situation & also givevaluable help and guidance.
I would also like to say thanks Mrs. Vaishali Shewale (H.O.D.) for his valuable help and guidance. She was always keep in
touch with our progress and with the timely encouragement, suggestion and guidance. We are extremely thankful for the guidance and
untiring attention, which she bestowed upon us right from start to the successful completion of the assigned project.
Miss. Sheetal Sonawane( project manager & guide) gave me the practical knowledge of computerized system of hotel
management. She also helped me to have a theoretical knowledge about the computerized system.
We are also immensely indebted to all other staff member of the college for their support and timely help.
-
8/6/2019 Hoel Managment Doc
15/78
PREFACE
During our studies here in the final year and working in Techgarner, I performed a project on the basis of job training. I felt a
golden opportunity for me while working on this project on hotel management system. The project contains a detailed study about
how is the inventory managed, how is billing done and what all a business activities ared one to manage the business and making it
more fruitful. In this project some screens and reports are also included. It also tells the files used by the company to do their work and
given the whole knowledge and information about the Hotel management System.
-
8/6/2019 Hoel Managment Doc
16/78
DEPARTMENT OF COMPUTER SCIECCEK.S.K.W. COLLEGE NASIK CITY
CERTIFICATE
-
8/6/2019 Hoel Managment Doc
17/78
This is to certify that the project on HOTEL MANAGEMENT SYSTEM
has been completed under my supervision & guidance by Mrs. Shewale madam.
University Roll no.
for the partial fulfillment of a Msc. Computer during the session
2010-2011. It is further certified that the work done in this report is
candidates own efforts.
We wish them all the success in his future endeavors.Mrs.Head
Deptt. Of computer science
Mr.
LecturerDeptt. Of computer science
K.S.K.W. COLLEGE NASIK CITY
Mr. Kishor PawarPrincipal
K.S.K.W. COLLEGE NASIK CITY
-
8/6/2019 Hoel Managment Doc
18/78
The motive
The motive of our project is to control various activities performed. In the Hotel using the computer with the work of HOTELMANGEMENT SYSTEM. From the beginning, the
important thing in our mind is that we should concentrate our project work on a subject that is easy to understand and is according toour daily requirement. By keeping this in mind, the
subject chosen by us is hotel management system.In the present time there is a great rush in hotels, as these have become necessity for middle and upper class of the society.
People travel a lot, stay in hotels, goes to the hotels for functions, meeting and refreshment. Our project is developed keeping in mind
the general needs of the customers when he goes to the hospital. An important uniqueness about the described Hotels restaurants andbar are available to only those customers who have already booked room or hall in hotel.
-
8/6/2019 Hoel Managment Doc
19/78
Problem Definition
Existing System
Difficulties in keeping the track of detail information of members
Maintenance and updating of master data such as member profile, contact information, Source preference.
Difficulties in searching members based on diverse aspects such as city, profession, caste, religion, economic standard,
job status, age, height, family background etc., .
Time consuming process of maintains members according to membership taken by member and payment information.
Difficulties in keeping track of members whose documents and contact details are verified and which of them are
accepted.
Members have difficulties in finding their suitable partner living in a remote place and matching his/her specific interests
and requirements.
Difficulties to contact and meet persons from all over the world. You can not share your likes and dislikes with them.
Time consuming and lengthy process and manual work affects performance.
-
8/6/2019 Hoel Managment Doc
20/78
Scope of the system ( Check & Change require)
The complete matrimonial web site manager includes features for three types of users.
Visitors
Registered Members
Administrators
Visitors Section
Member registration (paid or free) as per the rules set by the site admin
Browse categories that are sorted by region, community, religion
Basic search, advance search with additional parameters on homepage
-
8/6/2019 Hoel Managment Doc
21/78
Non-members can see results of listings but with limited info
Members have unrestricted access to the complete profile
Registered Users Section
Configure e-mail alert preferences, Upgrade free account to paid. Self-profile management section enables a registered
user to post content about him/her such as (contact profile, work / career profile, location profile, physical profile, religious
profile, community profile, personality profile, family profile, photographs) or about the person who wishes to marry using
the portal. The matrimony web site manager enables a registered user to provide information through use to neat and well-
organized forms.
Partner profile manager enables a registered user to set preferences for the partner the user is looking for and save these
preferences. The web site monitoring system continuously performs searches on existing database to extract profile matches
against partner preferences. The system also performs automatic short listing of candidates from the user database.
A registered user is able to accept messages from administrator and track communication threads. Also, can Express
Interests ,Accept or Decline received interests.
Registered members of the matrimony web site can selectively mark other profiles as favorites. These profiles are then
available to them under the favorites section.
The matrimonial web site system comes pre-packaged with a powerful search system to enable web site visitors and
registered users to perform extensive searches on the existing profiles.
Administrative Section
The administrator account is the all powerful user account of the web site and is allowed maximum functionality in the system. The
administrator is enabled to control access privileges of other users as well.
-
8/6/2019 Hoel Managment Doc
22/78
Perform Remove, Activate, Deactivate, Search and Sort operations on
o Administrators
o Registered Users
Remove, Activate, Deactivate, Search and Sort the following items
o Registered user Contact Profile
o Registered user Personality Profile
o Registered user Photographs
o Registered user Payments
Feasibility Study
When new application is proposed, it normally goes through feasibility study before it is approved for development.
Three types of feasibility study addressed are:
Technical Feasibility
Technical feasibility is the study of hardware and software required running the new system in well manner that is technical
requirements of the system. It involves whether the work for the project can be done with the current procedure, existing software
technology and available personnel. If new technology needed whether alternatives will be needed in the present structure and work
echoes should also be considered. This requires close examination of the present system.
Economical Feasibility
-
8/6/2019 Hoel Managment Doc
23/78
This feasibility study checks whether it is economically feasible to develop a new system or not. It identifies the alternatives,
determines the cost and expected saving of each of the alternatives the cost may include both one time cost and recurring cost. It is
observed that the system is feasible economically as its benefits the organization in ways.
Operational Feasibility
This feasibility study deals with the attitude and reaction of the people who will be the end users of the system, will the system is used
if it is implemented and questions like these could be encountered while undertaking the above type analysis. It aims at checking if
system will help the user to work in an efficient way. The system itself restricts the user from performing any undesirable tasks.
Hardware and Software Requirements
Hardware Specification
Processor: - Pentium IV D and onwards.
Primary Memory:- 256MB.
HardDisk: - 40GB.
Monitor
Keyboard
-
8/6/2019 Hoel Managment Doc
24/78
Mouse
Software Requirement
Operating System: -Windows 2000/XP.
Software: - Microsoft Visual Studio.
Language: - C#.
Front End: - C#.net.
Back End-: SQL Server.
TECHNICAL MANUAL
1. PROJECT OBJECTIVE: To develop a project which maintain booking of rooms, providing other services and handle account of a hotel
2. PROJECT FEATURES:
-
8/6/2019 Hoel Managment Doc
25/78
2.1 HOTELS ROOM INFORMATION:
It provide User to easily search about rooms availability , its type, category & easy updating of the rooms
records.
2.2 BILLING FACILITY
Operator, using this project can easily generate the bill for the customer,
He need not make any calculation for it
2.3 REPORT GENERATION
This feature help in easy maintenance of record of customer & their report
Generation
2.4 PASSWORD PROTECTED
This feature provide privacy to customers personal detail information
2.5 DIFFERENT LOGIN LEVELS
This feature provide protected login at different levels.
2.5.1 ADMINISTRATOR:
Administrator can add and delete rooms.
2.5.2 USER
-
8/6/2019 Hoel Managment Doc
26/78
User can do everything except adding & deleting the hotel records.
3.EXTENSIBLITY
3.1 CUSTOMERS INFORMATION:
Operator has information of customer for providing rebate or Discount
for their regular customer ,if they provide any such scheme in future.
3.2 NEW BRANCHES
This feature provides confirm advance booking of room in
another branch of that hotel .
3.3 NEW USER This feature allows for the addition of a new user.
4. FORMS AND MODULE DESCRIPTION
4.1 LOGIN FORM
This form is used to verify the authenticity of the
user or administrator by checking the Password.
This form consists of following modules:
-
8/6/2019 Hoel Managment Doc
27/78
Login_click()This module is used to verify password for adminstrator or user.
This form calls the form admin home_win form or user_win form.
Logout_click()
This module is used to exit from this form
Text1_change()
This module is used to type password .
4.2 USER_WIN FORM
As the user login into the project the this form. This form contains all menus by which user can switch over to anyof the desired form.
This form contains following modules:
update_click()
This module load update form.
cancle_click()
This module load cancellation form.
Reservation_click()
This module is used to display reservation form.
Checkin_click()This module is used to display Check in form.
Checkout_click()
This module is used to display Bill form.
-
8/6/2019 Hoel Managment Doc
28/78
Manual Testing ( Test cases design )
RESERVATION FORM
-
8/6/2019 Hoel Managment Doc
29/78
Test
No.
TestDesign
Input ExpectedOutput
ActualOutput
Remark
-
8/6/2019 Hoel Managment Doc
30/78
1 Check forReservationNumber
1. Vaibhav Not Accepted Not Accepted Pass
2. 1234 Not Accepted Not Accepted Pass
3.No need ofinput(Autogenrated for each time)
Autogenrated andevery time genratenew number.
Autogenratedand every timegenrate new
number.
Pass
2 Check for Lastname
1. Dighe. Not Accepted Accepted Fail
2 .Surywanshi123. Not Accepted Accepted Fail
3. #@!123vaibhav. Not Accepted Accepted Fail
4.?#! Not Accepted Accepted Fail
5.Selected fromCustomer lookupfrom
Get Last name Dighe Pass
3 Check for First
name1. Ragahv Not Accepted Accepted Fail
2 .Surywanshi123. Not Accepted Accepted Fail
3. #@!123vaibhav. Not Accepted Accepted Fail
4.?#! Not Accepted Accepted Fail
5.Autoselectedfrom Customerlookup from
Get Last name Ganesh Pass
4 Check forMiddle name
1. Ragahv Not Accepted Accepted Fail
2 .Surywanshi123. Not Accepted Accepted Fail
3. #@!123vaibhav. Not Accepted Accepted Fail
4.?#! Not Accepted Accepted Fail
5.Autoslected fromCustomer lookupfrom
Get Last name Ganesh Pass
-
8/6/2019 Hoel Managment Doc
31/78
5 Check forRes.Address
1.Daulat polt no-21(A) B/H rishiroopcompany nearsadguru ngr satpurnashik-422007(AllSpecialchar,number analphabets
accepted)
Not accepted Accepted Fail
5.Autoselectedfrom Customerlookup from
Get particularselected personaddress
1.Daulat polt no-21(A) B/Hrishiroopcompany nearsadguru ngrsatpur nashik-422007(AllSpecialchar,number analphabets
accepted)
Pass
6 Check forPer.Address
1.Daulat polt no-21(A) B/H rishiroopcompany nearsadguru ngr satpurnashik-422007(AllSpecialchar,number analphabets
accepted)
Not accepted Accepted Fail
5.Autoselectedfrom Customerlookup from
Get particularselected personaddress
1.Daulat polt no-21(A) B/Hrishiroopcompany nearsadguru ngrsatpur nashik-422007(AllSpecialchar,number analphabets
accepted)
Pass
-
8/6/2019 Hoel Managment Doc
32/78
7 Check for State. 1.Maharastra. Not Accepted Accepted Fail
2.Nashik. Not Accepted Accepted Fail
3.!SWE#* Not Accepted Accepted Fail
4.Autoselectedfrom Customerlookup from
Get particularselected person'sState
Maharastra Pass
8 Check for
Country1.Enter Nashik Not accepted Not accepted Pass
2.Select Perticularcountry fromDDL,i.e. India
Not Accepted Accepted Fail
3.Autoselectedfrom Customerlookup from
Get particularselected person'sCountry
India Pass
9 Check forZipcode
1. 422007 Not accepted Accepted Fail
2.EDRSW$#! Not accepted Accepted Fail
3. 12345567 Not accepted Accepted Fail
4.Autoselectedfrom Customerlookup from
Get particularselected person'sZipcode
422007 Pass
10 Check forCompany
1.Enter Nashik Ltd. Not accepted Not accepted Pass
2.Select Perticularfrom DDL,i.e. IndiaPvt ltd.
Accepted Accepted Pass
11 Check for Idtype
1.Enter CompanyId.
Not accepted Not accepted Pass
2.Select PerticularfromDDL,i.e.Passport.
Accepted Accepted Pass
12 Check for Id
type number
1.Mh15/23/123456 Accepted Accepted Pass
-
8/6/2019 Hoel Managment Doc
33/78
2.AU4567ED2H Accepted Accepted Pass
3. 6401 Accepted Accepted Pass
13 Check forVehicle type
1.i20(Hundai) Accepted Accepted Pass
2.Vardhanchi. Accepted Accepted Pass
3. 6401 Accepted Accepted Fail
14 Check forvehicle number
1.Mh15/23/123456 Accepted Accepted Pass
2.AU4567ED2H Accepted Accepted Pass
3. 6401 Accepted Accepted Pass
15 Check for DateIn
1. First timeautogenratedsystem datedisplay
Accepted Accepted Pass
2.Enter12/05/2011
Accepted
3.Enter12/05/2011
Accepted
4.Enter 2011-10-10 Not accepted
16 Check for DateOut
1. First timeautogenratedsystem date+1day date display.
Accepted Accepted Pass
2.Enter12/05/2011
Accepted
3.Enter12/05/2011
Accepted
4.Enter 2011-10-10 Not accepted
17 Check for No ofday
1. 12 Accepted Accepted Pass
2. One. Not accepted
3. Twenty2 Not accepted
-
8/6/2019 Hoel Managment Doc
34/78
4. #2 Not accepted
18 Check for ExtraAdults
1. 12 Accepted Accepted Pass
2. One. Not accepted
3. Twenty2 Not accepted
4. #2 Not accepted
19 Check for ExtraChildrens
1. 12 Accepted Accepted Pass
2. One. Not accepted
3. Twenty2 Not accepted
4. #2 Not accepted
20 Check forBusiness
Source
1.Enter Nashiktravels
Not accepted Not accepted Pass
2.Select Perticularbusiness sourcefrom DDL,i.e. IndiaTravels
Accepted Accepted Pass
21 Check for note. 1. Customerhaving refrencefrom hotel CEO, Plsgive them 25%discount.
Accepted( Any typeof script)
Accepted Pass
2. J12 Room. Accepted( Any typeof script)
Accepted Pass
3. &jhgf Accepted( Any typeof script)
Accepted Pass
22 Check paymentmode
1.Enter Cash Not accepted Not accepted Pass
2.Select Perticularfrom DDL,i.e.Master card
Accepted Accepted Pass
-
8/6/2019 Hoel Managment Doc
35/78
23 Check Roomtype
1.Enter A/C room Not accepted Not accepted Pass
2.Select Perticularfrom DDL,i.e.Delux room
Accepted Accepted Pass
24 Check rate type 1.Enter Single Not accepted Not accepted Pass
2.Select Perticularfrom DDL,i.e.Double
Accepted Accepted Pass
25 Check RoomNo.
1.Enter 120. Not accepted Not accepted Pass
2.Select Perticularfrom DDL,i.e. 102
Accepted Accepted Pass
26 Check for roomrate
1. Enter 1000/- Notaccepted Accepted Fail
2. Auto genratedwhen select Roomtype,rate,no.
Accepted Accepted Pass
27 Check for extraperson charges
1. Enter 500/- Not accepted Accepted Fail
2. Autogenratedwhen select No ofAdults.
Accepted Accepted Pass
28 Check for extra
childrencharges
1. Enter 500/- Not accepted Accepted Fail
2. Autogenratedwhen select No ofChild
Accepted Accepted Pass
30 Check for othercharges
1. Enter 1200 amt. Not accepted Accepted Fail
2. Blank( red only). Accepted Accepted Pass
-
8/6/2019 Hoel Managment Doc
36/78
31 Check forSubtotal
1. Enter 1200 amt. Not accepted Accepted Fail
2. Autogenrated. Accepted Accepted Pass
33 Check forDiscount
1. 120% Accepted Accepted Fail
2. 23% Accepted Accepted Pass 3. A12 Not accepted
34 Check for total 1. Enter 1200 amt. Not accepted Accepted Fail
2. Autogenrated. Accepted Accepted Pass
35 Check forAmount paid.
1. 12000 Accepted Accepted Pass
2.ASD Notaccepted Accepted Fail
36 Check forBalance
1. Enter 1200 amt. Not accepted Accepted Fail
2. Autogenrated. Accepted Accepted Pass
37 Check for SaveButton
1. No record fill &click on SaveButton
Not accepted Not accepted Pass
2. All Record Fill &click on Savebutton.
Accepted Accepted &Show Msg.Record
Successfullysave.
Pass
3. Fill all record &click on SaveButton 3 times.
Notaccepted Not accepted Pass
38 Check forCancel button
1. All Record fill,click on Savebutton then clickon cancel button
All record fields arenull but reservationno. fieldautogenrated.
Accepted Pass
-
8/6/2019 Hoel Managment Doc
37/78
2. Fill incompletform then click onCancel Button
All record fields arenull but reservationno. fieldautogenrated.
Accepted Pass
39 Check Printbutton
1. All Record fill,click on Savebutton then click
on Print button
Accepted get printof that record
2. All Record fillbut not Save thenclick on Printbutton
Msg-Sorry Can'tprint
3. Null from. Msg-Sorry Can'tprint
40 Check for Homelink
1. Click on HomeLink.
Go to home page Go to home page Pass
41 Check for
logout link1.Click on LogoutLink
Go to Login screen Go to Loginscreen
Pass
CHECK IN
TestNo.
Test Design Input ExpectedOutput
ActualOutput
Remark
1 Check for FolioNumber
1. Vaibhav Not Accepted Not Accepted Pass
2. 1234 Not Accepted Not Accepted Pass
-
8/6/2019 Hoel Managment Doc
38/78
-
8/6/2019 Hoel Managment Doc
39/78
5 Check forRes.Address
1.Daulat polt no-21(A) B/H rishiroopcompany nearsadguru ngr satpurnashik-422007(AllSpecialchar,number analphabets
accepted)
Not accepted Accepted Fail
5.Autoselectedfrom Customerlookup from
Get particularselected personaddress
1.Daulat polt no-21(A) B/Hrishiroopcompany nearsadguru ngrsatpur nashik-422007(AllSpecialchar,number analphabets
accepted)
Pass
6 Check forPer.Address
1.Daulat polt no-21(A) B/H rishiroopcompany nearsadguru ngr satpurnashik-422007(AllSpecialchar,number analphabets
accepted)
Not accepted Accepted Fail
5.Autoselectedfrom Customerlookup from
Get particularselected personaddress
1.Daulat polt no-21(A) B/Hrishiroopcompany nearsadguru ngrsatpur nashik-422007(AllSpecialchar,number analphabets
accepted)
Pass
-
8/6/2019 Hoel Managment Doc
40/78
7 Check for State. 1.Maharastra. Not Accepted Accepted Fail
2.Nashik. Not Accepted Accepted Fail
3.!SWE#* Not Accepted Accepted Fail
4.Autoselectedfrom Customerlookup from
Get particularselected person'sState
Maharastra Pass
8 Check for Country 1.Enter Nashik Not accepted Not accepted Pass
2.Select Perticularcountry fromDDL,i.e. India
Not Accepted Accepted Fail
3.Autoselectedfrom Customerlookup from
Get particularselected person'sCountry
India Pass
9 Check forZip code 1. 422007 Not accepted Accepted Fail
2.EDRSW$#! Not accepted Accepted Fail 3. 12345567 Not accepted Accepted Fail
4.Autoselectedfrom Customerlookup from
Get particularselected person'sZipcode
422007 Pass
10 Check forCompany
1.Enter Nashik Ltd. Not accepted Not accepted Pass
2.Select Perticularfrom DDL,i.e. India
Pvt ltd.
Accepted Accepted Pass
11 Check for Id type 1.Enter CompanyId.
Not accepted Not accepted Pass
2.Select PerticularfromDDL,i.e.Passport.
Accepted Accepted Pass
12 Check for Id typenumber
1.Mh15/23/123456 Accepted Accepted Pass
2.AU4567ED2H Accepted Accepted Pass
-
8/6/2019 Hoel Managment Doc
41/78
3. 6401 Accepted Accepted Pass
13 Check for Vehicletype
1.i20(Hundai) Accepted Accepted Pass
2.Vardhanchi. Accepted Accepted Pass
3. 6401 Accepted Accepted Fail
14 Check for vehiclenumber
1.Mh15/23/123456 Accepted Accepted Pass
2.AU4567ED2H Accepted Accepted Pass
3. 6401 Accepted Accepted Pass
15 Check for Date In 1. First timeautogenratedsystem datedisplay
Accepted Accepted Pass
2.Enter
12/05/2011
Accepted
3.Enter12/05/2011
Accepted
4.Enter 2011-10-10
Not accepted
16 Check for DateOut
1. First timeautogenratedsystem date+1day date display.
Accepted Accepted Pass
2.Enter12/05/2011
Accepted
3.Enter12/05/2011
Accepted
4.Enter 2011-10-10
Not accepted
17 Check for No ofday
1. 12 Accepted Accepted Pass
2. One. Not accepted
3. Twenty2 Not accepted
-
8/6/2019 Hoel Managment Doc
42/78
4. #2 Not accepted
18 Check for ExtraAdults
1. 12 Accepted Accepted Pass
2. One. Not accepted
3. Twenty2 Not accepted
4. #2 Not accepted
19 Check for ExtraChildrens
1. 12 Accepted Accepted Pass
2. One. Not accepted
3. Twenty2 Not accepted
4. #2 Not accepted
20 Check forBusiness Source
1.Enter Nashiktravels
Not accepted Not accepted Pass
2.Select Perticularbusiness sourcefrom DDL,i.e. IndiaTravels
Accepted Accepted Pass
21 Check for note. 1. Customerhaving refrencefrom hotel CEO,Pls give them 25%discount.
Accepted( Anytype of script)
Accepted Pass
2. J12 Room. Accepted( Any
type of script)
Accepted Pass
3. &jhgf Accepted( Anytype of script)
Accepted Pass
22 Check paymentmode
1.Enter Cash Not accepted Not accepted Pass
2.Select Perticularfrom DDL,i.e.Master card
Accepted Accepted Pass
23 Check Room type 1.Enter A/C room Not accepted Not accepted Pass
-
8/6/2019 Hoel Managment Doc
43/78
2.Select Perticularfrom DDL,i.e.Delux room
Accepted Accepted Pass
24 Check rate type 1.Enter Single Not accepted Not accepted Pass
2.Select Perticularfrom DDL,i.e.Double
Accepted Accepted Pass
25 Check Room No. 1.Enter 120. Not accepted Not accepted Pass
2.Select Perticularfrom DDL,i.e. 102
Accepted Accepted Pass
26 Check for roomrate
1. Enter 1000/- Notaccepted Accepted Fail
2. Auto genratedwhen select Roomtype,rate,no.
Accepted Accepted Pass
27 Check for extraperson charges
1. Enter 500/- Not accepted Accepted Fail
2. Autogenratedwhen select No ofAdults.
Accepted Accepted Pass
28 Check for extrachildren charges
1. Enter 500/- Not accepted Accepted Fail
2. Autogenratedwhen select No ofChild
Accepted Accepted Pass
30 Check for othercharges
1. Enter 1200 amt. Not accepted Accepted Fail
2. Blank( red only). Accepted Accepted Pass
31 Check for Subtotal 1. Enter 1200 amt. Not accepted Accepted Fail
2. Autogenrated. Accepted Accepted Pass
-
8/6/2019 Hoel Managment Doc
44/78
33 Check forDiscount
1. 120% Accepted Accepted Fail
2. 23% Accepted Accepted Pass
3. A12 Not accepted
34 Check for total 1. Enter 1200 amt. Not accepted Accepted Fail
2. Autogenrated. Accepted Accepted Pass
35 Check for Amountpaid.
1. 12000 Accepted Accepted Pass
2.ASD Notaccepted Accepted Fail
36 Check for Balance 1. Enter 1200 amt. Not accepted Accepted Fail
2. Autogenrated. Accepted Accepted Pass
37 Check for CheckIn Button
1. No record fill &click on Check InButton
Not accepted Not accepted Pass
2. All Record Fill &click on Check Inbutton.
Msg-Check Insucessfully done
Data store inCurrent checkin.
Pass
3. Fill all record &click on Check InButton 3 times.
Notaccepted onlyfirst timr recordsave.
Not accepted Pass
38 Check for Cancelbutton
1. All Record fill,click on Check Inbutton then clickon cancel button
All record fieldsare null butreservation no.field autogenrated.
Accepted Pass
2. Fill incompletform then click onCancel Button
All record fieldsare null butreservation no.field autogenrated.
Accepted Pass
-
8/6/2019 Hoel Managment Doc
45/78
39 Check Printbutton
1. All Record fill,click on Savebutton then clickon Print button
Accepted get printof that record
2. All Record fillbut not Save thenclick on Printbutton
Msg-Sorry Can'tprint
3. Null from. Msg-Sorry Can'tprint
40 Check for Homelink
1. Click on HomeLink.
Go to home page Go to homepage
Pass
41 Check for logoutlink
1.Click on LogoutLink
Go to Login screen Go to Loginscreen
Pass
CANCEL UPDTE RESERVATION
-
8/6/2019 Hoel Managment Doc
46/78
Test
No.
Test Design Input ExpectedOutput
ActualOutput
Remark
1 Check for Folio &ReservationNumber
1. Vaibhav Not Accepted Not Accepted Pass
2. 1234 Not Accepted Not Accepted Pass
3.No need ofinput(Autogenrated for each time &read only)
Autogenrated andevery time genratenew number.
Autogenratedand every timegenrate newnumber.
Pass
2 Check for Lastname
1. Dighe. Not Accepted Accepted Fail
2 .Surywanshi123. Not Accepted Accepted Fail
3. #@!123vaibhav.
Not Accepted Accepted Fail
4.?#! Not Accepted Accepted Fail 5.Selected from
Customer lookupfrom
Get Last name Dighe Pass
3 Check for Firstname
1. Ragahv Not Accepted Accepted Fail
2 .Surywanshi123. Not Accepted Accepted Fail
3. #@!123vaibhav.
Not Accepted Accepted Fail
4.?#! Not Accepted Accepted Fail 5.Autoselected
from Customerlookup from
Get Last name Ganesh Pass
4 Check for Middlename
1. Ragahv Not Accepted Accepted Fail
2 .Surywanshi123. Not Accepted Accepted Fail
3. #@!123vaibhav.
Not Accepted Accepted Fail
4.?#! Not Accepted Accepted Fail
-
8/6/2019 Hoel Managment Doc
47/78
5.Autoslectedfrom Customerlookup from
Get Last name Ganesh Pass
5 Check forRes.Address
1.Daulat polt no-21(A) B/Hrishiroop companynear sadguru ngr
satpur nashik-422007(All Specialchar,number analphabetsaccepted)
Not accepted Accepted Fail
5.Autoselectedfrom Customerlookup from
Get particularselected personaddress
1.Daulat poltno-21(A) B/Hrishiroopcompany nearsadguru ngrsatpur nashik-
422007(AllSpecialchar,numberan alphabetsaccepted)
Pass
6 Check forPer.Address
1.Daulat polt no-21(A) B/Hrishiroop companynear sadguru ngr
satpur nashik-422007(All Specialchar,number analphabetsaccepted)
Not accepted Accepted Fail
-
8/6/2019 Hoel Managment Doc
48/78
5.Autoselectedfrom Customerlookup from
Get particularselected personaddress
1.Daulat poltno-21(A) B/Hrishiroopcompany nearsadguru ngrsatpur nashik-422007(AllSpecial
char,numberan alphabetsaccepted)
Pass
7 Check for State. 1.Maharastra. Not Accepted Accepted Fail
2.Nashik. Not Accepted Accepted Fail
3.!SWE#* Not Accepted Accepted Fail
4.Autoselectedfrom Customerlookup from
Get particularselected person'sState
Maharastra Pass
8 Check for
Country1.Enter Nashik Not accepted Not accepted Pass
2.Select Perticularcountry fromDDL,i.e. India
Not Accepted Accepted Fail
3.Autoselectedfrom Customerlookup from
Get particularselected person'sCountry
India Pass
9 Check forZipcode
1. 422007 Not accepted Accepted Fail
2.EDRSW$#! Not accepted Accepted Fail
3. 12345567 Not accepted Accepted Fail
4.Autoselectedfrom Customerlookup from
Get particularselected person'sZipcode
422007 Pass
10 Check forCompany
1.Enter NashikLtd.
Not accepted Not accepted Pass
-
8/6/2019 Hoel Managment Doc
49/78
2.Select Perticularfrom DDL,i.e. IndiaPvt ltd.
Accepted Accepted Pass
11 Check for Id type 1.Enter CompanyId.
Not accepted Not accepted Pass
2.Select Perticular
fromDDL,i.e.Passport.
Accepted Accepted Pass
12 Check for Id typenumber
1.Mh15/23/123456 Accepted Accepted Pass
2.AU4567ED2H Accepted Accepted Pass
3. 6401 Accepted Accepted Pass
13 Check for Vehicletype
1.i20(Hundai) Accepted Accepted Pass
2.Vardhanchi. Accepted Accepted Pass 3. 6401 Accepted Accepted Fail
14 Check for vehiclenumber
1.Mh15/23/123456 Accepted Accepted Pass
2.AU4567ED2H Accepted Accepted Pass
3. 6401 Accepted Accepted Pass
15 Check for Date In 1. First time
autogenratedsystem datedisplay
Accepted Accepted Pass
2.Enter12/05/2011
Accepted
3.Enter12/05/2011
Accepted
4.Enter 2011-10-10
Not accepted
-
8/6/2019 Hoel Managment Doc
50/78
16 Check for DateOut
1. First timeautogenratedsystem date+1day date display.
Accepted Accepted Pass
2.Enter12/05/2011
Accepted
3.Enter
12/05/2011
Accepted
4.Enter 2011-10-10
Not accepted
17 Check for No ofday
1. 12 Accepted Accepted Pass
2. One. Not accepted
3. Twenty2 Not accepted
4. #2 Not accepted
18 Check for ExtraAdults 1. 12 Accepted Accepted Pass
2. One. Not accepted
3. Twenty2 Not accepted
4. #2 Not accepted
19 Check for ExtraChildrens
1. 12 Accepted Accepted Pass
2. One. Not accepted
3. Twenty2 Not accepted
4. #2 Not accepted
20 Check forBusiness Source
1.Enter Nashiktravels
Not accepted Not accepted Pass
2.Select Perticularbusiness sourcefrom DDL,i.e. IndiaTravels
Accepted Accepted Pass
-
8/6/2019 Hoel Managment Doc
51/78
-
8/6/2019 Hoel Managment Doc
52/78
26 Check for roomrate
1. Enter 1000/- Can not bechange( Read only)
Can not bechange( Readonly)
Pass
2. Auto genratedwhen select Roomtype,rate,no.
Can not bechange( Read only)
Can not bechange( Readonly)
Pass
27 Check for extraperson charges 1. Enter 500/- Not accepted Accepted Fail
2. Autogenratedwhen select No ofAdults.
Accepted Accepted Pass
28 Check for extrachildren charges
1. Enter 500/- Not accepted Accepted Fail
2. Autogenratedwhen select No of
Child
Accepted Accepted Pass
30 Check for othercharges
1. Enter 1200 amt. Not accepted Accepted Fail
2. Blank( readonly).
Accepted Accepted Pass
3.Autogenrated(Read only)
Accepted Accepted Pass
31Check forSubtotal 1. Enter 1200 amt. Not accepted Accepted Pass
2.Autogenrated(Read only)
Accepted Accepted Pass
33 Check forDiscount
1. 120% Accepted Accepted Fail
2. 23% Accepted Accepted Pass
3. A12 Not accepted
34 Ch k f l 1 E 1200 N d A d F il
-
8/6/2019 Hoel Managment Doc
53/78
34 Check for total 1. Enter 1200 amt. Not accepted Accepted Fail
2.Autogenrated(Read only)
Accepted Accepted Pass
35 Check forAmount paid.
1. 12000 Accepted Accepted Pass
2.ASD Notaccepted Accepted Fail
36 Check forBalance
1. Enter 1200 amt. Not accepted Not accepted Pass
2. Autogenrated.(Read only)
Accepted Accepted Pass
37 Check for CheckIn Button
1. Click on checkin button beforeUpdate
Not accepted Not accepted Pass
2. All Record fieldsare updated &click on Updatebutton.
Check inButtonVisible & then docheck in
Check inButtonVisible & thendo check in
Pass
3. All Record fieldsare updated &then click onCheckin button only onetime.
Msg-Check insucessfully done.
Not accepted Pass
4. All Record fieldsare updated &
then click onCheckin button At a time5 times.
Only 1 time check indone
Only 1 timecheck in done
Pass
38 Check forCancelReservation button
1.Click on cancelreservation button
Current reservationcancel
Currentreservationcancel( update, checkin,cancelReseration &print Buttons
are invisible)
Pass
-
8/6/2019 Hoel Managment Doc
54/78
39 Check Printbutton
1. All Record fill,click on Savebutton then clickon Print button
Accepted get printof that record
2. All Record fillbut not Save then
click on Printbutton
Msg-Sorry Can'tprint
3. Null from. Msg-Sorry Can'tprint
40 Check for Updatebutton
1. Withoutchangeclick onupdate buttion
Data updated Data updated Pass
2. Updated somepossible visible
field & then clickon update
Data updated Data updated Pass
41 Check for Homelink
1. Click on HomeLink.
Go to home page Go to homepage
Pass
42 Check for logoutlink
1.Click on LogoutLink
Go to Login screen Go to Loginscreen
Pass
CANCEL UPDATE CHECK IN
Test
No.
TestDesign
Input ExpectedOutput
ActualOutput
Remark
1 Check for FolioNumber
1. Vaibhav Not Accepted Not Accepted Pass
2. 1234 Not Accepted Not Accepted Pass
3 N d f A t t d A t t d P
-
8/6/2019 Hoel Managment Doc
55/78
3.No need ofinput(Autogenrated for each time &read only)
Autogenratedand every timegenrate newnumber.
Autogenratedand every timegenrate newnumber.
Pass
2 Check for Lastname
1. Dighe. Not Accepted Accepted Fail
2 .Surywanshi123. Not Accepted Accepted Fail
3. #@!123vaibhav. Not Accepted Accepted Fail 4.?#! Not Accepted Accepted Fail
5.Selected fromCustomer lookupfrom
Get Last name Dighe Pass
3 Check for Firstname
1. Ragahv Not Accepted Accepted Fail
2 .Surywanshi123. Not Accepted Accepted Fail
3. #@!123vaibhav. Not Accepted Accepted Fail
4.?#! Not Accepted Accepted Fail
5.Autoselectedfrom Customerlookup from
Get Last name Ganesh Pass
4 Check forMiddle name
1. Ragahv Not Accepted Accepted Fail
2 .Surywanshi123. Not Accepted Accepted Fail
3. #@!123vaibhav. Not Accepted Accepted Fail
4.?#! Not Accepted Accepted Fail 5.Autoslected fromCustomer lookupfrom
Get Last name Ganesh Pass
5 Check forRes.Address
1.Daulat polt no-21(A) B/H rishiroopcompany nearsadguru ngr satpurnashik-422007(AllSpecial
char,number an
Not accepted Accepted Fail
alphabets
-
8/6/2019 Hoel Managment Doc
56/78
alphabetsaccepted)
5.Autoselectedfrom Customerlookup from
Get particularselected personaddress
1.Daulat poltno-21(A) B/Hrishiroopcompany nearsadguru ngrsatpur nashik-422007(AllSpecialchar,numberan alphabetsaccepted)
Pass
6 Check forPer.Address 1.Daulat polt no-21(A) B/H rishiroopcompany nearsadguru ngr satpurnashik-422007(AllSpecialchar,number analphabetsaccepted)
Not accepted Accepted Fail
5.Autoselectedfrom Customer
lookup from
Get particularselected person
address
1.Daulat poltno-21(A) B/H
rishiroopcompany nearsadguru ngrsatpur nashik-422007(AllSpecialchar,numberan alphabetsaccepted)
Pass
7 Check for State. 1.Maharastra. Not Accepted Accepted Fail
2 Nashik Not Accepted Accepted Fail
-
8/6/2019 Hoel Managment Doc
57/78
2.Nashik. Not Accepted Accepted Fail
3.!SWE#* Not Accepted Accepted Fail
4.Autoselectedfrom Customerlookup from
Get particularselectedperson's State
Maharastra Pass
8 Check for
Country
1.Enter Nashik Not accepted Not accepted Pass
2.Select Perticularcountry fromDDL,i.e. India
Not Accepted Accepted Fail
3.Autoselectedfrom Customerlookup from
Get particularselectedperson'sCountry
India Pass
9 Check forZipcode
1. 422007 Not accepted Accepted Fail
2.EDRSW$#! Not accepted Accepted Fail
3. 12345567 Not accepted Accepted Fail
4.Autoselectedfrom Customerlookup from
Get particularselectedperson'sZipcode
422007 Pass
10 Check forCompany
1.Enter Nashik Ltd. Not accepted Not accepted Pass
2.Select Perticular
from DDL,i.e. IndiaPvt ltd.
Accepted Accepted Pass
11 Check for Idtype
1.Enter CompanyId.
Not accepted Not accepted Pass
2.Select PerticularfromDDL,i.e.Passport.
Accepted Accepted Pass
12 Check for Id
type number
1.Mh15/23/123456 Accepted Accepted Pass
2 AU4567ED2H Accepted Accepted Pass
-
8/6/2019 Hoel Managment Doc
58/78
2.AU4567ED2H Accepted Accepted Pass
3. 6401 Accepted Accepted Pass
13 Check forVehicle type
1.i20(Hundai) Accepted Accepted Pass
2.Vardhanchi. Accepted Accepted Pass
3. 6401 Accepted Accepted Fail
14 Check for
vehicle number1.Mh15/23/123456 Accepted Accepted Pass
2.AU4567ED2H Accepted Accepted Pass
3. 6401 Accepted Accepted Pass
15 Check for DateIn
1. First timeautogenratedsystem datedisplay
Accepted Accepted Pass
2.Enter12/05/2011
Accepted
3.Enter12/05/2011
Accepted
4.Enter 2011-10-10 Not accepted
16 Check for DateOut
1. First timeautogenratedsystem date+1day date display.
Accepted Accepted Pass
2.Enter12/05/2011
Accepted
3.Enter12/05/2011
Accepted
4.Enter 2011-10-10 Not accepted
17 Check for No ofday
1. 12 Accepted Accepted Pass
2. One. Not accepted
3. Twenty2 Not accepted
4. #2 Not accepted
-
8/6/2019 Hoel Managment Doc
59/78
18 Check for ExtraAdults
1. 12 Accepted Accepted Pass
2. One. Not accepted
3. Twenty2 Not accepted
4. #2 Not accepted
19 Check for ExtraChildrens
1. 12 Accepted Accepted Pass
2. One. Not accepted
3. Twenty2 Not accepted
4. #2 Not accepted
20 Check forBusinessSource
1.Enter Nashiktravels
Not accepted Not accepted Pass
2.Select Perticular
business sourcefrom DDL,i.e. IndiaTravels
Accepted Accepted Pass
21 Check for note. 1. Customerhaving refrencefrom hotel CEO, Plsgive them 25%discount.
Accepted( Anytype of script)
Accepted Pass
2. J12 Room. Accepted( Anytype of script)
Accepted Pass
3. &jhgf Accepted( Anytype of script)
Accepted Pass
22 Check paymentmode
1.Enter Cash Not accepted Not accepted Pass
2.Select Perticularfrom DDL,i.e.Master card
Accepted Accepted Pass
23 Check Room 1 Enter A/C room Can not be Can not be Pass
-
8/6/2019 Hoel Managment Doc
60/78
23 Check Roomtype
1.Enter A/C room Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
2.Select Perticularfrom DDL,i.e.Delux room
Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
24 Check rate type 1.Enter Single Can not be
change( Readonly)
Can not be
change( Readonly)
Pass
2.Select Perticularfrom DDL,i.e.Double
Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
25 Check RoomNo.
1.Enter 120. Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
2.Select Perticularfrom DDL,i.e. 102
Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
26 Check for roomrate
1. Enter 1000/- Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
2. Auto genratedwhen select Roomtype,rate,no.
Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
27 Check for extra
person charges
1. Enter 500/- Not accepted Accepted Fail
2. Autogenratedwhen select No ofAdults.
Accepted Accepted Pass
28 Check for extrachildrencharges
1. Enter 500/- Not accepted Accepted Fail
2. Autogenratedwhen select No of
Child
Accepted Accepted Pass
-
8/6/2019 Hoel Managment Doc
61/78
2. All Record fields Check inButton Check Pass
-
8/6/2019 Hoel Managment Doc
62/78
2. All Record fieldsare updated & clickon Update button.
Check inButtonVisible & thendo check in
CheckinButtonVisible & thendo check in
Pass
3. All Record fieldsare updated &then click onCheckin button only one
time.
Msg-Check insucessfullydone.
Not accepted Pass
4. All Record fieldsare updated &then click onCheckin button At a time5 times.
Only 1 timecheck in done
Only 1 timecheck in done
Pass
38 Check Printbutton
1. All Record fill,click on Savebutton then clickon Print button
Accepted getprint of thatrecord
2. All Record fillbut not Save thenclick on Printbutton
Msg-Sorry Can'tprint
3. Null from. Msg-Sorry Can'tprint
39 Check forUpdate button
1. Withoutchangeclick onupdate buttion
Data updated Data updated Pass
2. Updated somepossible visiblefield & then clickon update
Data updated Data updated Pass
40 Check for Homelink
1. Click on HomeLink.
Go to homepage
Go to homepage
Pass
41 Check forlogout link
1.Click on LogoutLink
Go to Loginscreen
Go to Loginscreen
Pass
-
8/6/2019 Hoel Managment Doc
63/78
EMPLOYEE REGISTRATION
TestNo
.
TestDesign
Input ExpectedOutput
ActualOutput
Remark
1 Check forLast name
1. Dighe. Accepted Accepted Pass
2 .Surywanshi123. Not Accepted Accepted Pass
3. #@!123vaibhav. Not Accepted Accepted Fail
4.?#! Not Accepted Accepted Fail
2 Check forFirst name
1. Vaibhav Accepted Accepted Pass
2 .Ganesh123. Accepted Accepted Pass
3. #@!123vaibhav. Not Accepted Accepted Fail 4.?#! Not Accepted Accepted Fail
3 Check forMiddle name
1. Vaibhav Accepted Accepted Pass
2 .Ganesh123. Accepted Accepted Pass
3. #@!123vaibhav. Not Accepted Accepted Fail
4.?#! Not Accepted Accepted Fail
4 Check forRes.Address 1.Daulat polt no-21(A) B/Hrishiroop company nearsadguru ngr satpur nashik-422007(All Specialchar,number an alphabetsaccepted)
Accepted Accepted Pass
2. Nashik Pls enter detailaddress.
Accepted Fail
5 Check for 1.Daulat polt no-21(A) B/H Accepted Accepted Pass
-
8/6/2019 Hoel Managment Doc
64/78
Per.Addressp ( ) /
rishiroop company nearsadguru ngr satpur nashik-422007(All Specialchar,number an alphabetsaccepted)
p p
2. Nashik Pls enter detail
address.
Accepted Fail
6 Check forState.
1.Maharastra. Accepted Accepted Pass
2.Nashik. Not Accepted Accepted Fail
3.!SWE#* Not Accepted Accepted Fail
7 Check forCountry
1.Enter Nashik Not accepted Notaccepted
Pass
2.Select Perticular country
from DDL,i.e. India
Accepted Accepted Pass
8 Check forZipcode
1. 422007 Accepted Accepted Pass
2.EDRSW$#! Not accepted Accepted Fail
3. 12345567 Accepted Accepted Pass
9 Check forContact no
1. 9271736362 Accepted Accepted Pass
2. 0253-2361197 Accepted Accepted Pass
3.AVAIBH!)( Not accepted Notaccepted
Pass
4.1234561234561234564512QAS!(*
Not accepted Notaccepted
Pass
10 Check forEmail Id
Accepted Accepted Pass
2.Ganesh 123 yahoo.co.in Not accepted Notaccepted
Pass
3. 123456ADSC Not accepted Not
accepted
Pass
4.!#$%^&*( )( Not accepted Not Pass
mailto:[email protected]:[email protected]:[email protected]:[email protected] -
8/6/2019 Hoel Managment Doc
65/78
$ (_)( paccepted
11 Check for Idtype
1.Enter Company Id. Not accepted Notaccepted
Pass
2.Select Perticular fromDDL,i.e.Passport.
Accepted Accepted Pass
3.1234
12 Check for Idtype number
1.Mh15/23/123456 Accepted Accepted Pass
2.AU4567ED2H Accepted Accepted Pass
3. 6401 Accepted Accepted Pass
12 Check forEmployee
Photo
1.Add photo from specificpath.
Display photo Displayphoto
Pass
2.Cant add photo Show Msg-*field aremadatory
Show Msg-*field aremadatory
Pass
13 Check forQualification.
1. M.C.A. Accepted Accepted Pass
3.12th Pass Accepted Accepted Pass
3. Diplama inHotel
Management
Accepted Accepted Pass
4. /*-+ZA! Notaccepted Accepted Fail
14 Check forExperience.
1. Last time working inhotelobey roy as an managerhaving3 r experience.
Accepted( Anytype of script)
Accepted Pass
2. J12 Room. Accepted( Anytype of script)
Accepted Pass
3. &jhgf Accepted( Anytype of script)
Accepted Pass
-
8/6/2019 Hoel Managment Doc
66/78
15 Check fordepartment
1. Admin Not Accepted NotAccepted
Fail
2. Computer deparment. Not Accepted NotAccepted
Fail
3. Security Not Accepted NotAccepted
Fail
4. Select from DDL particualrdepartment and assign
Accepted Accepted Pass
16 Check forjoining date
1. 12/12/2011. Accepted Accepted Pass
2. 12 April 2011. Not accepted Notaccepted
Fail
3. Current syatem datehaving format dd/mm/yyyy
Accepted Accepted Pass
4. #2 Not accepted
17 Check forScale
1. 12000/- Accepted Accepted Pass
2. ASDFG Not accepted Notaccepted
Fail
3. ZXC!#SD45 Not accepted Notaccepted
Fail
18 Check forpost
1. Manager Accepted Accepted Pass
2. Admin. Accepted Accepted Pass
3.!*()!123 Not accepted Notaccepted
Fail
19 Check forSave Button
1. No record fill & click onSave Button
Not accepted Notaccepted
Pass
2. All Record Fill & click on Accepted Accepted & Pass
-
8/6/2019 Hoel Managment Doc
67/78
Save button. Show Msg.RecordSuccessfully save.
3. Fill all record & click onSave Button 3 times.
Notaccepted Notaccepted
Pass
20 Check forCancelbutton
1. All Record fill, click onSave button then click oncancel button
All recordfields are nullbutreservationno. fieldautogenrated.
Accepted Pass
2. Fill incomplet form thenclick on Cancel Button
All recordfields are nullbutreservationno. fieldautogenrated.
Accepted Pass
CUSTOMER REGISTRATION
TestNo.
TestDesign
Input ExpectedOutput
ActualOutput
Remark
1 Check for Lastname
1. Dighe. Accepted Accepted Pass
2 .Surywanshi123. Not Accepted Accepted Pass
3. #@!123vaibhav. Not Accepted Accepted Fail
4.?#! Not Accepted Accepted Fail
2 Check forFirst name
1. Vaibhav Accepted Accepted Pass
2 .Ganesh123. Accepted Accepted Pass
3. #@!123vaibhav. Not Accepted Accepted Fail
-
8/6/2019 Hoel Managment Doc
68/78
4.?#! Not Accepted Accepted Fail
3 Check forMiddle name
1. Vaibhav Accepted Accepted Pass
2 .Ganesh123. Accepted Accepted Pass
3. #@!123vaibhav. Not Accepted Accepted Fail
4.?#! Not Accepted Accepted Fail
4 Check forRes.Address
1.Daulat polt no-21(A) B/Hrishiroop company nearsadguru ngr satpur nashik-422007(All Specialchar,number an alphabetsaccepted)
Accepted Accepted Pass
2. Nashik Pls enterdetailaddress.
Accepted Fail
5 Check forPer.Address
1.Daulat polt no-21(A) B/Hrishiroop company nearsadguru ngr satpur nashik-422007(All Specialchar,number an alphabetsaccepted)
Accepted Accepted Pass
2. Nashik Pls enter
detailaddress.
Accepted Fail
6 Check forState.
1.Maharastra. Accepted Accepted Pass
2.Nashik. Not Accepted Accepted Fail
3.!SWE#* Not Accepted Accepted Fail
7 Check forCountry
1.Enter Nashik Not accepted Notaccepted
Pass
2.Select Perticular countryf i di
Accepted Accepted Pass
-
8/6/2019 Hoel Managment Doc
69/78
from DDL,i.e. India
8 Check forZipcode
1. 422007 Accepted Accepted Pass
2.EDRSW$#! Not accepted Accepted Fail
3. 12345567 Accepted Accepted Pass
9 Check forMobile no
1. 9271736362 Accepted
2. 0253-2361197 Accepted
3.AVAIBH!)( Not accepted
4.1234561234561234564512QAS!(*
Not accepted
10 Check forEmail Id
Accepted Accepted Pass
2.Ganesh 123 yahoo.co.in Not accepted Notaccepted
Pass
3. 123456ADSC Not accepted Notaccepted
Pass
4.!#$%^&*(_)( Not accepted Notaccepted
Pass
11 Check for Telno.
1. 9271736362 Not accepted
2. 2361195 Accepted
3.AVAIBH!)( Not accepted4.1234561234561234564512QAS!(*
Not accepted
12 Check forFAX NO.
1. 2362514 Accepted
2. 9325656522 Not accepted
3.AVAIBH!)( Not accepted
4.1234561234561234564512QAS!(*
Not accepted
mailto:[email protected]:[email protected]:[email protected]:[email protected] -
8/6/2019 Hoel Managment Doc
70/78
CHECK OUT
Test
No.
TestDesign
Input ExpectedOutput
ActualOutput
Remark
1 Check for FolioNumber
1. Vaibhav Not Accepted Not Accepted Pass
2. 1234 Not Accepted Not Accepted Pass
3.No need ofinput(Autogenratedfor each time &read only)
Autogenratedand every timegenrate newnumber.
Autogenrated andevery timegenrate newnumber.
Pass
2 Check for Last
name1. Dighe. Not Accepted Accepted Fail
2 .Surywanshi123. Not Accepted Accepted Fail
3. #@!123vaibhav. Not Accepted Accepted Fail
4.?#! Not Accepted Accepted Fail
5.Selected fromCustomer lookupfrom
Get Last name Dighe Pass
3 Check for Firstname
1. Ragahv Not Accepted Accepted Fail
2 .Surywanshi123. Not Accepted Accepted Fail
3. #@!123vaibhav. Not Accepted Accepted Fail
4.?#! Not Accepted Accepted Fail
5.Autoselected fromCustomer lookupfrom
Get Last name Ganesh Pass
4 Check for 1.Enter Nashik Ltd. Not accepted Not accepted Pass
Company
-
8/6/2019 Hoel Managment Doc
71/78
2.Select Perticularfrom DDL,i.e. IndiaPvt ltd.
Accepted Accepted Pass
5 Check for DateIn
1.Autogenrated( read only data)
Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
2.12/12/2011 Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
6 Check for DateOut
1.Autogenrated( read only data)
Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
2.12/12/2011 Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
7 Check for RoomNo
1.Autogenrated( read only data)
Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
2. 120 Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
8 Check for nodays
1.Autogenrated( read only data)
Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
2.Enter 12 Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
9 Check for no ofAdults
1.Autogenrated( read only data)
Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
2.Enter 1 Can not bechange( Read
only)
Can not bechange( Read
only)
Pass
0 Ch k f f d C b C b
-
8/6/2019 Hoel Managment Doc
72/78
10 Check for no ofchildren
1.Autogenrated( read only data)
Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
2.Enter 2 Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
11 Check forPayment mode
1.Select CashfromDDL
Accepted Accepted Pass
2. Enter Master card Not Accepted Not Accepted Pass
12 Check forrentail period
1.Autogenrated( read only data)
Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
2.Enter 1200/- Can not bechange( Read
only)
Can not bechange( Read
only)
Pass
13 Check for extraperson charges
1.Autogenrated( read only data)
Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
2.Enter 1200/- Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
14 Check for other
charges
1. Get other charge
details from Othercharge look up
Perticular folio
no other chargebill & Bind thattextbox
Perticular folio no
other charge bill &Bind that textbox
Pass
2. Enter 1200 amt Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
15 Check forSubtotal
1. Get other chargedetails from Othercharge look up
Perticular foliono other chargebill & Bind thattextbox
Perticular folio noother charge bill &Bind that textbox
Pass
2. Enter 11200 amt Can not bechange( Read
Can not bechange( Read
Pass
-
8/6/2019 Hoel Managment Doc
73/78
change( Readonly)
change( Readonly)
16 Check forDiscount
1. Enter 25%Discount
Get 25%Discount on totalamount
Get 25% Discounton total amount
Pass
2. 200% Discount Not Accepted Not accepted Fail
17 Check for total 1.Autogenrated( read only data)
Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
2.Enter 15000 Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
18 Checkforbalance
1.Autogenrated( read only data)
Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
2.Enter 1200/- Can not bechange( Readonly)
Can not bechange( Readonly)
Pass
19 Amount paid 1. Enter particularpersons paidamount
Accepted Accepted Pass
2. balnk field Accepted Accepted Pass
20 Check Printbutton
1. All Record fill,click on Save buttonthen click on Printbutton
Accepted getprint of thatrecord
2. All Record fill butnot Save then clickon Print button
Msg-Sorry Can'tprint
3. Null from. Msg-Sorry Can't
print
-
8/6/2019 Hoel Managment Doc
74/78
21 Check forCheckOut button
1. Click on Checkout button
Customerchectedout &Details show inCheck outhistory
Data updated Pass
LIMITATIONS
1. This project cant be used for hotel having different branches.
2. This project doesnt assigns unique id to each customer to distinguish between him or her. Selecting the id from some given list.
However, both the methods of specifying the product are too vague.
ERROR HANDLING
Error no Message Error Correction
1 Fill entry properly Cannot enter alphabets
and some special
symbols in this field
Enter numbers ,
- hyphen,
( opening bracket or
) closing bracket
2 Fill entry properly Cannot enter numbers
d i l b l i
Enter only alphabets
-
8/6/2019 Hoel Managment Doc
75/78
and special symbols in
this field
3 Entry already
existing
Duplicate value
entered. Cannot enter
already existing values
in room add form.
Enter other unique
Room no.
4 Enter LOGIN and
PASSWORD
Enter LOGIN and
PASSWORD field do
not match.
Enter same value in
LOGIN and PASSWORD
fields
-
8/6/2019 Hoel Managment Doc
76/78
CONFIGURATION
Provides authentication and access control through:
1. Login and password:
This facility ask the user to enter correct login name and password
for accessing the system. Thus preventing the system from
unauthorized users.
-
8/6/2019 Hoel Managment Doc
77/78
-
8/6/2019 Hoel Managment Doc
78/78
Regis tration For MakesAdminHa s
Employee
Search
Customer
Contains
Com pany Regular
Us e
Other S ervices
Fo rReservation
Check In
Check OutMakes
Makes
Assign
Room
Has
R oom S tat us Room C harges Room Ty pe R oom R at e
Add In
Bill
Create
Makes
Search
Pay
Contain
1
1 11 1
1
*
**
*
*
*
1
*
*
*
1
1
1
1
1 1