project report hotel management syst.doc
TRANSCRIPT
CERTIFICATE
APROJECT REPORT ONHOTEL MANAGEMENT SYSTEM(SUBMITTED FOR THE PARTIAL FULFILMENT FOR THE AWARD OF DIPLOMA IN COMPUTER ENGINEERING)
SUBMITTED TO:
SUBMITTED BY:
Er. Mamta Kamboj
Ankush Mangal 10096081102Lect. Computer Engg.
Ranbir Singh 10096081103
Vinod Kumar 10096081104DEPARTMENT OF COMPUTER ENGINEERING
MAA SARASWATI POLTECHNIC COLLEGE, BHAVDIN, SIRSA CERTIFICATE
TO WHOM IT MAY CONCERNThis is certify that Ankush Mangal (10096081102),Ranbir Singh (10096081103),Vinod Kumar (10096081103) are the student of Computer Engineering 6th semester has completed their project on HOTEL MANAGEMENT SYSTEM under my supervision. They have worked on this project through the semester from 2011 to 2013. To the best of my knowledge , they themselves do this project.
I wish them success in life.
Er. Mamta Kamboj HOD. COMPUTER ENGG. GOVT. POLYTECHNIC SIRSA
PREFACEAs we move through 21st century, the socio economic settings are different from what is or was long ago. There is a growing demand for better quality if life, which brings new invention in the companies towards computerization. Computers are one of them; computers no doubt enhance the capability, incearse the effective and output standard of any field in which they are applied to.
The need of todays software development id competence in GUI Based front-end tool, which can connect to database. This gives opportunity to retrieve information easily. This application gives the user to find information and information in the database easil than other ways. In the sales and Marketing department of any company the need of computer become huge, as thereis no need to do those things, which assume a lot of time and energy of employee is saved. This system is developed to provide the user with every sort of convenience. The user will be very much friendly with the system as he can do maximum work in minimum time.
Thus we see that computers are become necessity in day life. The use of computer also invokes he feelings of healthy competition with other organization.
We hope this projects succeeds in achieving the foremost goal of sales and Marketing Department to manage there billing system. ACKNOWLEDGEMENT It is a great pleasure to acknowledgement my sincere gratitude and indebtness to Er. Mamta Kamboj Lect. Computer Engg. Maa Saraswati Polytechnic Bhawdin, Sirsa for his guidance and his entire some efforts, consistent motivation & inspiration that never lot us in the waver during the course of our project work. We will never forget the devotion, dedication moral attitude ethics he has indulged in our project during this period. We consider our self-lucky for having an opportunity to work under such a project guide.We again send our heartiest thanks for everything that we get from him.
We would like to pay our sincere gratitude to Sh. Sanjeev Sethi, Principal, Maa Saraswati. Polytechnic Bhawdin, Sirsa and all staff members of Computer Engg. Department for their inspiring guidance, support and encouragement.
We are highly indebted to our parents for their financial assistance and immeasurable support.Above all I thanked Almighty with whose grace we would reach this far..!!
Presented By :-
Computer Engg 5TH Semester Ankush Mangal 10096081102 Ranbir Singh 10096081103 Vinod Kumar 10096081104
Ankush Mangal 10096081102
Ranbir Singh 10096081103 Vinod Kumar 10096081104
ABSTRACT OF THE PROJECT
Hotel Management System project is the simple and minor project, developed for the Polytechnic Institues for admission of new comers. This project fulfills all the requirements necessary for the Hotels Customer and as well as Employ and the Rooms in a Hotel.
It is user friendly as it is very easy to use and understand. It requires common hardware & software platform, thats why it also compatible. As this project is related with the hotel manager so we include a password protection in it, with a username. User will give its own name but he can access this project only by a password which is given by the administrator of the project.This project allows you to perform following tasks :
Admit new customer and also new employ. Search any particular customer and employ from hotel.
Customer and employ Details.
Update the customer and employ and also room Record.. Delete the customer record employ and also room record
Print single records of any particular customer. Also print the all customer record stayed in hotel. Also print the all employs work in hotel.Note: Update Record section of this project is protected by a PASSWORD. We include password to Update Record section for the security reason.
For access this project you just need to following steps:
Go to Start | All Programs | Hotel. When you click on Hotel, project will open.
Select Enter from the menu bar to enter in the Project.
Select About to know about the project and Help for help.
When you enter in the Project, it will ask you for Login ID and Password. Fill your name in the Login ID and type Password given by the administrator of the project.
Select New Customer for admit new customer, or
Select Customer Details for search any customer and Update Customer Record for changing any Customer information. Delete Customer Record for delete the customer record permanently from database as well as hard disk drive. (You can access Update Record facility only if you have Password given by Administrator. You cant change this and Password.)
Select EXIT exiting from projrct and then it ask question from you for exit then give to buttens ok and cancle. For access the record for the employ record there are same procdure to access the record.
For acess the room record there are also same procedure as the customer but it wants from you the password which provide by administrator for security reasons
CONTENTS
Sr no.Contents of ReportPage No.
1.Tool And Environment Used1
2.Front End2
3.Back End4
4.System Requirement6
5.Feasibility Study7
6.Software Engineering Paradigm Applied 8
7.Introduction to Visual Basic 6.0 9
8.Testing10
9.Design12
10.Coding27
TOOLS AND ENVIRONMENT USED LANGUAGE :
This project used VISUAL BASIC 6.0 is development environment that run under Microsoft Windows. It is used write programs that also run under Microsoft Windows. Visual Basic is a window programming language developed at Microsoft Corporation. It is powerful programming language to develop sophisticated window programs very quickly.Visual Basic application is very popular as front- end to many client / server data base system like SQL / SERVER, MS-ACCESS, and ORACLE etc. Visual Basic language is having several faces. One is Visaul, which comprises of objects and tools that easily assemles themselves into a modern Window interfaces. Another face is Visual Basic Language, which is an outcome of the original BASIC (Beginners All Purpose Symbolic Instruction Code). VISUAL BASIC USER INTERFACE :
Before you can draw your programs user interface and write basic code, you have to know how to use the user interface of visual basic it self. The eight main parts of visual basic interface are given, although all parts do not necessarily have to be visible are given time. PULL DOWN MENUS :
Provide access to every available visual basic command, although these menus can be confused in an intimidating to use.
TOOLBOX :
Display the types of objects (such as textbox, labels etc.). That you can draw on a form. The toolbox may not list all possible objects you can draw on a form. To get a complete list of objects you can display in your Toolbox,Ctrl + T. PROJECT EXPLORER :
Show list of all forms or report from that are used in particular project of Visual Basic. PROPERTIES WINDOWS :
Display the properties of the currently selected form. FORM LAYOUT WINDOW :
Enable you to arrange the location where your form appear on the screen. FORM :
Provide a window where you can draw objects to design your programs user Interface. IMMEDIATE WINDOW :
Enables you to debug your Visual Basic Program.
FRONT ENDWe have used Visual Basic for our project developers as front end because it is the perfect programming environment for the 1990s. It is an easy and powerful tool for developing Windows application in Basic. In our project Visual Basic used as a Front end. Visual Basic 2.0 was faster, more powerful and even much easier than Visual Basic 1.0. Visual Basic 3.0 added simple way to control the most powerful databases available. Visual Basic 4.0 added support for 32-bit development and began the process of turning Visual Basic into a fully object oriented programming language. Visual Basic 5.0 added the ability to create ture executable and even the ability to make your own controls. But we decided to use Visual Basic 6.0 because it has added some long desired features, even more Internet power and even more powerful database features to make our programming jobs easier, more Wizards. It is the latest, slickest and powerful Visual Basic yet. When using Visual Basic, the most important skill you need is to adapt at using the development environment. Without the integrated tools in the environment, Visual Basic programming would be much more cumbersome and difficult. All design would need to be done on graph paper and flow charts and it would need to be typed in line by line. Visual Basic contains many integrated tools to make the application development process simpler. This collection of tools makes up the Integrated Development Environment (IDE). Visual Basic provides a graphical environment in which we visually design the forms and the controls that become the part of our applications. Visual Basic supports many useful that will help you be more productive. These include, but are not limited to, projects, forms, class objects, templates, custom controls and database managers. You can use these tools together to complete applications in months, weeks, even in days ; producing an application using another language can take much longer. When we strart Visual Basic first time, the Project Wizard will open we will notice the new Project Dialog Box.
BACK ENDIn the computerized address diary system MS-ACCESS is used as back end to store the data. Access is a powerful database program that we can used to create the sophisticated applications. A data base is a collection of information about groups of items or individuals. Database is a structure that is provided fields-categories of information. Fields in address diary includes name, address, phone no., occupation etc. Each entry in database for one individual is called a Record. Simple database only allow you to work with one list of information at a time : one set of fields and records. More capable program like access lets you group multiple list together and list to each other, create a type of database called a Relational Database.
In a Relational Database, each list is stored in a separate table. Data validations can be put on the fields and records. Validation is a way to screen data being entered in a table or a form. Validation rules screens the data, and validation text that appears to let user know that constitutes a valid entry. When you move to a new record, Access checks to make sure that entire record is valid.
Icon : Icon provides a symbolic representation of any system entity such as file, folder, address, table and so on. A folder icon consists of group of files or other folder icons. Dialog box : It is used to capture user information or to present information to the user. Normally a dialog box is displayed to get additional information. Dialog boxes are used to indicate error message in the form of alter boxes. Check box : Such a box is used to capture information intented confirmation pertaining to any kind of action desired by the user. Menus : The functionality on a GUI system is arranged in the form of Menus such as Horizontal menus, pull down menus etc. Form the menu, the user can select any operation of his choice rather than remembering commands at each stage. Sliders : These are used to show the relative position of the contents or to move a different position. Desktop Metaphors : In desktop graphical metaphor, users are not aware of applications and they deal with files, folders, and clipboard.
SYSTEM
REQUIREMENTS
Hardware Requirements Specification :
COMPONENTSMINIMUM REQUIREMENTSRECOMMENDED
ProcessorPentium 133 MHzPentium 166 MHz or higher
Memory (RAM)256 MB512 MB or more
Hard Disk8 GB20 GB or more
Display (Resolution)VGA having 640 480 resolutionVGA having 800 600 resolution
Software Requirements Specification :
TechnologyVisual Basic 5.0 or 6.0
OS/PlatformWindows XP
FEASIBILITY STUDYFeasibility Study :
Depending on the results of the initial investigation, the survey is expanded to a more detailed feasibility study.
Feasibility Study is a test of system proposal according to its workability, impact on the organization, ability to meet user needs, and effective use of resources. The objective of the Feasibility Study is not to solve the problem but to acquire a sense of its scope. During the study, the problem defenition is crystallized and aspects of the problem to be included in the system are determined.Consequently, costs and benefits are described with greater accuracy at this stage. It consists of the following :
Statements of the problem : A carefully worded statement of the problem that lacto analysis. Summary of finding and recommendations :A list of major findings and recommendations of the study. It is ideal for the user who requires quick access to the results of the analysis of the system under study. Conclusion is stated, followed by a list of the recommendation and a justification for them. Details of findings :An outline of the methods and procedures undertaken by the existing system, followed by coverage of the objectives and procedures of the candidate system. Included are also discussions of output reports, file structure, and costs & benefits of the candidate system. Recommendations and conclusions :Specific recommendations regarding the candidate systems, including personal assignments, costs, project schedules, and target dates.Types of Feasibility :-1. Technical Feasibility :This involves financial considerations to accommodate technical enhancements. If the budget is a serious constraint, then the project is judged not feasible. In the proposed system the company will take only the cost of developing and maintaining the application into consideration. There is no needing any special hardware.2. Economical Feasibility :With the help of this application it will lead to decrease in cost of opening and maintaining officies, which will be more than the cost of developing and maintaining the application. Lesser manpower is needed to maintain an application than a branch office, which will again lead to decrease in cost.3. Operational Feasibility :This application is very easy to operate as it is made user friendly. Main consideration in users easy access to all functionality of the application.
SOFTWARE ENGINEERING PARADIGM APPLIED
The basic objectives of software engineering is to develop methods and procedures for software development that can scale up for large systems and that can be used to consistently produce high quality software at low cost and with a small cycle time. That is, the key objectives are consistency, low, cost, high quality, small cycle time and scalabilty.
The basic approach that engineering takes is to separate the development process from the software. The premise is that the development process controls the quality, scalability, consistency and productivity.Different phases of the Development Process :- Requirement Analysis :Requirement analysis is done order to understand the problem the software is to solve. The problem could be automating exiting manual process, developing a new automated system, or a combination of the two. The emphasis in requirements analysis is on identifying what is needed from the system, not how the software development a client and a developer. Software design :The purpose of the design phase is to plan a solution of the problem specified by the requirements documents. This phase is the first step in moving from the problem domain to the solution domain. The design activity is divided into two phases ; System Design and Detailed Design. In system design the focus is on identifying the modules, whereas during detailed design the focus is on designing the logic for each of the modules Coding :The goal of the coding phase is to translate the design of the system into code in a given programming language. Hence during coding, the focus should be on developing programs that are easy to read and understand , and not simply on developing programs that are easy to write. Testing : Testing is the major quality control measure used during software development. Its function is to detect error in the software. Testing not only correct errors encountered during coding, but also errors encountered during the previous phases. Thus, the goal of testing is to uncover requirement, design and coding errors in the programs. Therefore, different levels of testing are used. These levels are : Unit testing
System testing
Storage testing
Performance time testing
Procedure testing
Human factors testing INTRODUCTION OF VISUAL BASIC 6.0
Visual basic is not just a language. It is an Integrated Development Environment in which we can develop, run, test and debug our applications.
Visual Basic comes in three flavors :
The Visual Basic Language Edition :- most basic edition for the beginners.
The Visual Basic Professional Editions :- designed for professionals.
The Visual Basic Enterprise Edition :- most complete Visual Basic edition.
With Visual Basic, we can following types of applications :
Standard EXE
A Standard EXE project is a typical application. These are types of applications that developed with previous versions of Visual Basic.Active EXE, Active DLL
These types of projects are available with professional edition. ActiveX components are basic code building components that dont have a visible interface and that can add special functionality to your applications.
Active control
This type of projects is also a feature of the professional edition. This is one feature of Visual Basic that attracts all kinds of developers. They are the objects that are represented on Visual Basics toolbox with a small icon, and we can iclude them on any form to add functionality to the application that uses them.
Data project
This is a feature of enterprise edition. It adds the database ActiveX Designer to the project explorer windows. The ActiveX designers are Visual tools for accessing and manipulating database and generating reports.
Visual Basic IDE
It is made up of numbers of components. The main window, in middle of screen, contains a form named Form1. The form is the applications window, and in it we can place the elements of applications user interface. It is also the window that user sees when running an application.
TESTING
It should be clear in mind that the philosophy behind testing is to find errors.Test cases are devised with this purpose in mind. A test case is a set of data that the system will process as normal input. However, the data are created with the express intent of determining whether the system will process them correctly. For example, test cases for inventory handling should include situations in which the quantifies to be withdrawn from inventory exceed, equal and are less than the actual quantities on hand. Each test case is designed with the intent of finding errors in the way the system will process it. There are two general strategies for testing softwares :1. Code testing
2. Specification testingIn code testing , the analyst develops those cases to execute every instruction and path in a program. Under specification testing, the analyst examines the program specification and then writes test data to determine how the program operates under specific conditions. Regardless of which strategy the analyst follows, there are preferred practices to ensures that the testing is useful. The levels of tests and types of test data, combined with testing libraries, are important aspects of the actual test process. LEVELS OF TESTING :
System are not designed as entire system or they as single systems. The analyst must both unit and system testing. Unit Testing : In unit testing the analyst tests the programs making up a system. For this reasons, unit testing is sometimes called program testing. Unit testing gives stress on the modules independently of one another, to find errors. This helps the tester in detecting errors in coding and logic that are contained within that module alone. The errors resulting from the interaction between modules are initially avoided. For examples, a hotel information system consists of modules to handle reservation; guest checking and checkout; restaurant, room service and miscellaneous charges; convention activities; and accounts receivable billing. For each, it provides the ability to enter, modify or retrieve data and respond to different types of inquires or prints reports. The test cases needed for unit testing should exercise each condition and option. System Testing : The important and essential part of the system development phase, after designing and developing the software is system testing. we cannot say that every program or system design is perfect and because of lack of communication between the user and the designer, some error is there in the software development. The number and nature of error in a nwely designed system should have all the parts or sub-system works independently. This is the time to gather all the subsystem into one pool and test the whole systems to determine whether it meets the user requirements. This is the last change to detect and correct errors before the system is installed for user acceptance testing. The purpose of system testing is to consider all the likely variation to which it will be subjected and then push the system to its limits. System testing consists of the following five steps : Program Testing
String Testing
System Testing
System Documentation
User AcceptableSPECIAL SYSTEM TESTING :
There are other six tests, which fall under special category. They are described below :
Peak Load Test : It determines whether the system will handle the volume of activities that occur when the system is at the peak of its processing demand. Storage Testing : It determines the capacity of the system to store transaction data on a disk or in other files. Performance Time Testing :It determines the length of time system used by the system to process transaction data. This test is conducted prior to implementation to determine how long it takes to get a response to an inquiry, make a back up copy of a file, or send a transmission and get a response. Recovery Testing :This testing determines the ability of user to recover data of re-strat system after failure. Procedure testing :It determines the clarity of documentation on operation and use of system by having users does exactly what manuals request. Human factors Testing :It determines how users will use the system when processing data or preparing reports.
LOGING FORM :-
FORM DESIGN :-
MDI FORM DESIGN :-
NEW CUTOMER RECORD :-
MODIFY CUSTOMER RECORD :-
MODIFIED CUSTOMER RECORD :-
DELETED CUSTOMER RECORD :-
EMPLOY NEW RECORD :-
DELETED EMPLOY RECORD :-
MODIFIED EMPLOY RECORD :-
DISPLAY ROOM RECORD :-
CUSTOMERS REPORT :-
EMPLOYS REPORT :-
SINGLE CUSTOMER REPORT :-
HELP FORM :-
Customer record coding :- Dim c As New Connection
Dim r As New Recordset
Public idproof As Integer
Public i As Integer
Dim r1 As New Recordset
Private Sub back_Click()
r.MovePrevious
If r.BOF Then
MsgBox "You Are At First Record"
r.MoveFirst
Else
cname.Text = r.Fields(0)
cage.Text = r.Fields(1)
cgender.Text = r.Fields(2)
cid.Text = r.Fields(3)
cadd.Text = r.Fields(4)
cph.Text = r.Fields(5)
dov.Value = r.Fields(6)
amt.Text = r.Fields(7)
cmbroom.Text = r.Fields(8)
If dod.Text = "" Then
dod.Text = ""
Else
dod.Text = r.Fields(9)
End If
End If
End Sub
Private Sub cancel_Click()
Unload Me
End Sub
Private Sub cmbroom_GotFocus()
r1.Open "select * from room where status = 1 ", c, adOpenDynamic, adLockOptimistic
While (Not r1.EOF)
cmbroom.AddItem r1.Fields(0)
r1.MoveNext
Wend
End Sub
Private Sub cmdNext_Click()
r.MoveNext
If r.EOF Then
r.MovePrevious
MsgBox "You are at the Last Record ", vbInformation
Else
cname.Text = r.Fields(0)
cage.Text = r.Fields(1)
cgender.Text = r.Fields(2)
cid.Text = r.Fields(3)
cadd.Text = r.Fields(4)
cph.Text = r.Fields(5)
dov.Value = r.Fields(6)
amt.Text = r.Fields(7)
cmbroom.Text = r.Fields(8)
If dod.Text = "" Then
dod.Text = ""
Else
dod.Text = r.Fields(9)
End If
End If
End Sub
Private Sub delete_Click()
r.delete
cmdNext_Click
MsgBox "RECORD SUCCESSFULY DELETED", vbInformation
End Sub
Private Sub Form_Load()
c.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\hotel.mdb"
r.Open "select * from customer", c, adOpenDynamic, adLockOptimistic
If r.EOF Then
r.MovePrevious
MsgBox "You are at the Last Record ", vbInformation
Else
cname.Text = r.Fields(0)
cage.Text = r.Fields(1)
cgender.Text = r.Fields(2)
cid.Text = r.Fields(3)
cadd.Text = r.Fields(4)
cph.Text = r.Fields(5)
dov.Value = r.Fields(6)
amt.Text = r.Fields(7)
cmbroom.Text = r.Fields(8)
If dod.Text = "" Then
dod.Text = ""
Else
dod.Text = r.Fields(9)
End If
End If
End Sub
Private Sub Form_Unload(cancel As Integer)
c.Close
End Sub
Private Sub modify_Click()
customer1.setDAta
r.Update
MsgBox "RECORD SUCCESSFULY MODIFIED", vbInformation
End Sub
Private Sub save_Click()
dod.Text = "0"
Dim k As Variant
For Each k In customer1.Controls
If TypeOf k Is TextBox Then
If k.Text = "" Then
MsgBox "plz. fill all fields", vbCritical
Exit Sub
End If
End If
Next
Dim r2 As New Recordset
r2.Open "update room set status = 0 where roomno =" & cmbroom, c, adOpenDynamic, adLockOptimistic
r.AddNew
r.Fields(0) = cname.Text
r.Fields(1) = cage.Text
r.Fields(2) = cgender.Text
r.Fields(3) = cid.Text
r.Fields(4) = cadd.Text
r.Fields(5) = cph.Text
r.Fields(6) = dov.Value
r.Fields(7) = amt.Text
r.Fields(8) = cmbroom.Text
r.Update
MsgBox "Record Successfully Saved", vbInformation
customer1.setblank
End Sub
Public Sub setDAta()
r.Fields(0) = cname.Text
r.Fields(1) = cage.Text
r.Fields(2) = cgender.Text
r.Fields(3) = cid.Text
r.Fields(4) = cadd.Text
r.Fields(5) = cph.Text
r.Fields(6) = dov.Value
r.Fields(7) = amt.Text
End Sub
Public Sub setblank()
cname.Text = ""
cage.Text = ""
cgender.Text = ""
cid.Text = ""
cadd.Text = ""
cph.Text = ""
dov.Value = Date
amt.Text = ""
cmbroom.Text = ""
dod.Text = ""
End Sub
Employ record coding :- Dim c As New Connection
Dim r As New Recordset
Public id As Integer
Public i As Integer
Dim r1 As New Recordset
Private Sub back_Click()
r.MovePrevious
If r.BOF Then
MsgBox "You Are At Last Record", vbInformation
r.MoveFirst
Else
ename.Text = r.Fields(0)
eage.Text = r.Fields(1)
egender.Text = r.Fields(2)
eid.Text = r.Fields(3)
eph.Text = r.Fields(4)
edoj.Value = r.Fields(5)
esal.Text = r.Fields(6)
epost.Text = r.Fields(7)
If edol.Text = "" Then
edol.Text = ""
Else
edol.Text = r.Fields(8)
End If
End If
End Sub
Private Sub ecancel_Click()
Unload Me
End Sub
Private Sub edel_Click()
r.delete
next_Click
MsgBox "RECORD DELETED", vbInformation
End Sub
Private Sub emod_Click()
employ.setDAta
r.Update
MsgBox "record successfuly modified", vbInformation
End Sub
Private Sub esave_Click()
employ.setDAta
r.Update
MsgBox "Record Successfully Saved", vbInformation
employ.setblank
End Sub
Public Sub setDAta()
r.Fields(0) = ename.Text
r.Fields(1) = eage.Text
r.Fields(2) = egender.Text
r.Fields(3) = eid.Text
r.Fields(4) = eph.Text
r.Fields(5) = edoj.Value
r.Fields(6) = esal.Text
r.Fields(7) = epost.Text
If edol.Text = "" Then
edol.Text = ""
Else
r.Fields(8) = edol.Text
End If
End Sub
Public Sub setblank()
ename.Text = ""
eage.Text = ""
egender.Text = ""
eid.Text = ""
eph.Text = ""
esal.Text = ""
edol.Text = ""
epost.Text = ""
End Sub
Private Sub Form_Load()
c.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\hotel.mdb"
r.Open "select * from employ", c, adOpenDynamic, adLockOptimistic
If r.EOF Then
r.MovePrevious
MsgBox "You are at the Last Record ", vbInformation
Else
ename.Text = r.Fields(0)
eage.Text = r.Fields(1)
egender.Text = r.Fields(2)
eid.Text = r.Fields(3)
eph.Text = r.Fields(4)
edoj.Value = r.Fields(5)
esal.Text = r.Fields(6)
epost.Text = r.Fields(7)
If edol.Text = "" Then
edol.Text = ""
Else
edol.Text = r.Fields(8)
End If
End If
End Sub
Private Sub Form_Unload(cancel As Integer)
c.Close
End Sub
Private Sub modify_Click()
employ.setDAta
r.Update
End Sub
Private Sub next_Click()
r.MoveNext
If r.EOF Then
r.MovePrevious
MsgBox "You are at the Last Record ", vbInformation
Else
ename.Text = r.Fields(0)
eage.Text = r.Fields(1)
egender.Text = r.Fields(2)
eid.Text = r.Fields(3)
eph.Text = r.Fields(4)
edoj.Value = r.Fields(5)
esal.Text = r.Fields(6)
epost.Text = r.Fields(7)
If edol.Text = "" Then
edol.Text = ""
Else
edol.Text = r.Fields(8)
End If
End If
End Sub
Logging form coding: -
Option Explicit
Public LoginSucceeded As Boolean
Dim i As Integer
Private Sub cmdCancel_Click()
LoginSucceeded = False
Unload Me
End
End Sub
Private Sub cmdOK_Click()
If txtUserName "naveen" Then
MsgBox "INVALID USERNAME, TRY AGAIN", vbCritical
txtUserName.SetFocus
i = i + 1
ElseIf txtPassword = "khasa" Then
LoginSucceeded = True
MDIForm1.Show
Unload Me
Else
MsgBox "sorry invalid username or password", vbCritical
txtPassword.SetFocus
SendKeys "{Home}+{End}"
i = i + 1
End If
If i = 3 Then
MsgBox "YOU ARE UNAUTHORISED PERSONE,JUST OUT", vbCritical
End
End If
End Sub
Private Sub Form_Load()
txtPassword.Text = ""
End Sub
Help form coding: -Private Sub Timer1_Timer()
Helpfrm.Top = Helpfrm.Top - 25
End Sub
MDI form coding: -Dim c As New Connection
Dim r As New Recordset
Dim rep As New DataReport1
Dim rep1 As New DataReport2
Private Sub del_Click()
r.Fields(0) = ""
r.Fields(1) = ""
r.Fields(2) = ""
r.Fields(3) = ""
r.Fields(4) = ""
r.Fields(5) = ""
r.Fields(6) = ""
r.Fields(7) = ""
r.Fields(8) = ""
End Sub
Private Sub mod_Click()
search.Show
customer1.cmdNext.Visible = False
customer1.back.Visible = False
End Sub
Private Sub nr_Click()
customer1.i = 1
customer1.Show
End Sub
Private Sub call_Click()
customer1.Show
customer1.save.Visible = False
End Sub
Private Sub cdel_Click()
a = InputBox("please enter an password", "password")
If a = "naveen" Then
search.Show
search.Command3.Visible = False
search.Command4.Visible = False
search.Command5.Visible = False
customer1.modify.Visible = False
customer1.save.Visible = False
customer1.cmdNext.Visible = False
customer1.back.Visible = False
Else
MsgBox "u are not an uthorised user to DELETE the detail", vbCritical
Exit Sub
End If
End Sub
Private Sub cmod_Click()
a = InputBox("please enter an password", "password")
If a = "naveen" Then
search.Show
search.Command3.Visible = False
search.Command4.Visible = False
search.Command5.Visible = False
customer1.delete.Visible = False
customer1.save.Visible = False
customer1.cmdNext.Visible = False
customer1.back.Visible = False
Else
MsgBox "u Are not an sufficient Person to MODIFY the Record", vbCritical
End If
End Sub
Private Sub cone_Click()
search.Show
search.Command3.Visible = False
search.Command4.Visible = False
search.Command5.Visible = False
customer1.cmdNext.Visible = False
customer1.back.Visible = False
customer1.delete.Visible = False
customer1.save.Visible = False
customer1.modify.Visible = False
End Sub
Private Sub cnr_Click()
customer1.Show
customer1.dod.Enabled = False
customer1.Label8.Enabled = False
customer1.delete.Visible = False
customer1.cmdNext.Visible = False
customer1.back.Visible = False
customer1.modify.Visible = False
customer1.setblank
End Sub
Private Sub creport_Click()
DataReport1.Show
DataReport1.WindowState = 2
End Sub
Private Sub eall_Click()
employ.Show
employ.setDAta
employ.edel.Visible = False
employ.emod.Visible = False
employ.esave.Visible = f
End Sub
Private Sub edel_Click()
a = InputBox("please enter an password", "password")
If a = "naveen" Then
search.Show
search.Command1.Visible = False
search.Command4.Visible = False
search.Command5.Visible = False
employ.emod.Visible = False
Else
MsgBox "U are not an sufficient Person to DELETE the Record", vbCritical
End If
End Sub
Private Sub emod_Click()
a = InputBox("please enter an password", "password")
If a = "naveen" Then
search.Show
search.Command1.Visible = False
search.Command4.Visible = False
search.Command5.Visible = False
employ.edel.Visible = False
Else
MsgBox "Uare not an sufficient person to MODIFY the Record", vbCritical
End If
End Sub
Private Sub eone_Click()
search.Show
search.Command1.Visible = False
search.Command4.Visible = False
search.Command5.Visible = False
employ.next.Visible = False
employ.back.Visible = False
End Sub
Private Sub epd_Click()
employ.Show
employ.back.Visible = False
employ.edel.Visible = False
employ.emod.Visible = False
employ.next.Visible = False
employ.setblank
End Sub
Private Sub ereport_Click()
DataReport2.Show
End Sub
Private Sub exit_Click()
i = MsgBox("do you realy want to exit", vbOKCancel)
If i = 1 Then
End
ElseIf i = 2 Then
MDIForm1.Show
End If
End Sub
Private Sub help_Click()
Helpfrm.Show
End Sub
Private Sub rdis_Click()
search.Show
search.Command1.Visible = False
search.Command5.Visible = False
search.Command3.Visible = False
End Sub
Private Sub screcord_Click()
search.Show
search.Command1.Visible = False
search.Command3.Visible = False
search.Command4.Visible = False
End Sub
Room record coding: - Dim c As New Connection
Dim r As New Recordset
Public roomno As Integer
Dim r1 As New Recordset
Private Sub Command1_Click()
a = InputBox("please enter an password", "password")
If a = "naveen" Then
r.delete
MsgBox "record successfuly delete", vbInformation
r.MoveNext
Else
MsgBox "U are not a VALID USER to DELETE the Record", vbCritical
End If
End Sub
Private Sub Command2_Click()
Unload Me
MDIForm1.Show
End Sub
Private Sub Command3_Click()
r1.MoveNext
If r1.EOF Then
r1.MovePrevious
MsgBox "You are at the Last Record ", vbInformation
Else
room1.room.Text = r1.Fields(0)
room1.ravail.Text = r1.Fields(1)
room1.Text1.Text = r1.Fields(2)
room1.Show
End If
End Sub
Private Sub Command4_Click()
r1.MovePrevious
If r1.BOF Then
r1.MoveNext
MsgBox "you are at first record", vbInformation
Else
room1.room.Text = r1.Fields(0)
room1.ravail.Text = r1.Fields(1)
room1.Text1.Text = r1.Fields(2)
room1.Show
End If
End Sub
Private Sub Command5_Click()
a = InputBox("please enter an password", "password")
If a = "naveen" Then
r.Update
MsgBox "Record Successfuly Saved", vbInformation
Else
MsgBox "You Are Not A Valid User To MODIFY the Record", vbCritical
End If
End Sub
Private Sub Form_Load()
c.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\hotel.mdb"
r.Open "select roomno from room", c, adOpenDynamic, adLockOptimistic
r1.Open "select * from room", c, adOpenDynamic, adLockOptimistic
End Sub
Private Sub Form_Unload(cancel As Integer)
c.Close
End Sub
Search form coding: -
Dim c As New Connection
Dim r As New Recordset
Dim r1 As New Recordset
Dim r2 As New Recordset
Public roomno As Integer
Private Sub Command1_Click()
If Text1.Text = "" Then
MsgBox "plz enter id proof to search record"
End If
r2.Find "idproof ='" & Text1.Text & "'"
If r2.EOF Then
MsgBox "Record is not available ", vbExclamation
Else
customer1.cname.Text = r2.Fields(0)
customer1.cage.Text = r2.Fields(1)
customer1.cgender.Text = r2.Fields(2)
customer1.cid.Text = r2.Fields(3)
customer1.cadd.Text = r2.Fields(4)
customer1.cph.Text = r2.Fields(5)
customer1.dov.Value = r2.Fields(6)
customer1.amt.Text = r2.Fields(7)
customer1.cmbroom.Text = r2.Fields(8)
If customer1.dod.Text = "" Then
customer1.dod.Text = ""
Else
customer1.dod.Text = r.Fields(9)
End If
customer1.Show
End If
Unload Me
End Sub
Private Sub Command2_Click()
Unload Me
MDIForm1.Show
End Sub
Private Sub Command3_Click()
If Text1.Text = "" Then
MsgBox "plz enter id proof to search record"
End If
r.Find "idproof ='" & Text1.Text & "'"
If r.EOF Then
MsgBox "Record is not available ", vbInformation
Else
employ.ename.Text = r.Fields(0)
employ.eage.Text = r.Fields(1)
employ.egender.Text = r.Fields(2)
employ.eid.Text = r.Fields(3)
employ.eph.Text = r.Fields(4)
employ.edoj.Value = r.Fields(5)
employ.esal.Text = r.Fields(6)
employ.epost.Text = r.Fields(7)
If employ.edol.Text = "" Then
employ.edol.Text = ""
Else
employ.edol.Text = r.Fields(8)
End If
employ.Show
employ.next.Visible = False
employ.back.Visible = False
employ.esave.Visible = False
End If
Unload Me
End Sub
Private Sub Command4_Click()
If Text1.Text = "" Then
MsgBox "Plz Enter A Room No To Search Record"
End If
r1.Find "roomno='" & Text1.Text & "'"
If r1.EOF Then
MsgBox "Record Is Not In List", vbInformation
Else
room1.room = r1.Fields(0)
room1.ravail = r1.Fields(1)
room1.Text1 = r1.Fields(2)
room1.Show
End If
Unload Me
End Sub
Private Sub Command5_Click()
On Error Resume Next
Dim i As Integer
i = Text1.Text
r2.Find "idproof='" & Text1.Text & "'"
If r2.EOF Then
MsgBox "record not in list", vbInformation
r2.Close
Unload Me
Else
DataReport3.Show
DataEnvironment1.Command3 (i)
End If
Unload Me
End Sub
Private Sub Form_Load()
c.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\hotel.mdb"
r2.Open "select * from customer", c, adOpenDynamic, adLockOptimistic
r.Open "select * from employ", c, adOpenDynamic, adLockOptimistic
r1.Open "select * from room", c, adOpenDynamic, adLockBatchOptimistic
End Sub
Private Sub Form_Unload(cancel As Integer)
c.Close
End Sub
Start form coding: -
Private Sub Pb1_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)
formlogin.Show
End Sub
Private Sub Timer1_Timer()
Shape1.Left = Shape1.Left - 78
Shape2.Left = Shape2.Left + 75
End Sub
Private Sub Timer2_Timer()
If pb1.Value < pb1.Max Then
pb1.Value = pb1.Value + 5
Else
frmLogin.Show
Unload Me
End If
End Sub
Datareport3 coding: -
Private Sub DataReport_Terminate()
DataEnvironment1.rsCommand3.Close
End Sub
A PROJECT REPORT ON HOTEL MANAGEMENT SYSTEM
(SUBMITTED FOR THE PARTIAL FULFILMENT FOR THE AWARD OF DIPLOMA IN COMPUTER ENGINEERING)
SUBMITTED TO: SUBMITTED BY:
Mr. Rakesh Kumar Dayanand 061108010
Lect. Computer Engg. DEPARTMENT OF COMPUTER ENGINEERING
GOVERNMENT POLYTECHNIC SIRSA
SESSION 2006-09 A PROJECT REPORT ON HOTEL MANAGEMENT SYSTEM
(SUBMITTED FOR THE PARTIAL FULFILMENT FOR THE AWARD OF DIPLOMA IN COMPUTER ENGINEERING)
SUBMITTED TO: SUBMITTED BY:
Mr. Rakesh Kumar Prithvi Raj 061108035
Lect. Computer Engg. DEPARTMENT OF COMPUTER ENGINEERING
GOVERNMENT POLYTECHNIC SIRSA
SESSION 2006-09 A PROJECT REPORT ON HOTEL MANAGEMENT SYSTEM
(SUBMITTED FOR THE PARTIAL FULFILMENT FOR THE AWARD OF DIPLOMA IN COMPUTER ENGINEERING)
SUBMITTED TO: SUBMITTED BY:
Mr. Rakesh Kumar
Lect. Computer Engg. Sonu Kumar 061108059DEPARTMENT OF COMPUTER ENGINEERING
GOVERNMENT POLYTECHNIC SIRSA
SESSION 2006-09 A PROJECT REPORT ON HOTEL MANAGEMENT SYSTEM
(SUBMITTED FOR THE PARTIAL FULFILMENT FOR THE AWARD OF DIPLOMA IN COMPUTER ENGINEERING)
SUBMITTED TO: SUBMITTED BY:
Mr. Rakesh Kumar
Lect. Computer Engg. Dharmendra 051108073
DEPARTMENT OF COMPUTER ENGINEERING
GOVERNMENT POLYTECHNIC SIRSA
SESSION 2006-09 CERTIFICATE
TO WHOM IT MAY CONCERN
This is certify that DHARMENDRA (051108073), is the student of Computer Engineering 6th semester has completed their project on HOTEL MANAGEMENT SYSTEM under my supervision. They have worked on this project through the semester from JAN 2009 to MAY 2009. To the best of my knowledge , they themselves do this project.
I wish them success in life.
Mr. RAJENDER JINDAL Mr. RAKESH KUMARHOD. COMPUTER ENGG. Lect. Computer Engineering
GOVT. POLYTECHNIC SIRSA GOVT. POLYTECHNIC SIRSA
CERTIFICATE
TO WHOM IT MAY CONCERN
This is certify that SONU KUMAR (061108059) is the student of Computer Engineering 6th semester has completed their project on HOTEL MANAGEMENT SYSTEM under my supervision. They have worked on this project through the semester from JAN 2009 to MAY 2009. To the best of my knowledge , they themselves do this project.
I wish them success in life.
Mr. RAJENDER JINDAL Mr. RAKESH KUMARHOD. COMPUTER ENGG. Lect. Computer Engineering
GOVT. POLYTECHNIC SIRSA GOVT. POLYTECHNIC SIRSA
CERTIFICATE
TO WHOM IT MAY CONCERN
This is certify that PRITHVI RAJ (061108035) is the student of Computer Engineering 6th semester has completed their project on HOTEL MANAGEMENT SYSTEM under my supervision. They have worked on this project through the semester from JAN 2009 to MAY 2009. To the best of my knowledge , they themselves do this project.
I wish them success in life.
Mr. RAJENDER JINDAL Mr. RAKESH KUMARHOD. COMPUTER ENGG. Lect. Computer Engineering
GOVT. POLYTECHNIC SIRSA GOVT. POLYTECHNIC SIRSA
CERTIFICATE
TO WHOM IT MAY CONCERN
This is certify that DAYANAND (061108010) is the student of Computer Engineering 6th semester has completed their project on HOTEL MANAGEMENT SYSTEM under my supervision. They have worked on this project through the semester from JAN 2009 to MAY 2009. To the best of my knowledge , they themselves do this project.
I wish them success in life.
Mr. RAJENDER JINDAL Mr. RAKESH KUMARHOD. COMPUTER ENGG. Lect. Computer Engineering
GOVT. POLYTECHNIC SIRSA GOVT. POLYTECHNIC SIRSA