Hello everyone
welcome to my new channel
from today
i am going to start a new series
on
web development and today
i will show a project on hotel room
management system with
asp dot net c sharp
i am just using the
2015 of
of visual studio version 2015
okk
first of all
open your visual studio and
and go to file new project
o solution
and select asp.net web application
and then
and then rename your
web application name
and then select ok
and then you have a option
to select empty or webform
from this you can select webform
and then click ok
after the project has been open
go to the solution explorer
and then find out the site.master and open it
after opening the site.master
find out the
div
i mean the class navbar collapse collapse
and under this class
you have to edit the list item i mean the li
as there are more than one li
and you have to just edit the home and about section only
okk, after editing
this li
now take five new webform
five new webform
named as delhi tokyo rome
paris and beijing
which are the cities
in our hotel management system this five
webform
named them as delhi tokyo rome paris
and beijing
and
the default.aspx webform
named it as a home.aspx
now
now we have to design the home.aspx webform
to designing the home.aspx webform you have to write
some code i mean the html source code
which is
on my
which is on my description tag
you can collect this and paste on your
visual studio
i just do some
i just do some simple code
with html i have some trs
some tds and after doing the designing
after having the designing
the webform will be look like this
there are one search
box or text box
there is a one text box which is use as a search box
and a dropdown list
for selecting the rooms
and two calendars for checkin and checkout
on the dropdown list
control
there are
five values
one is select rooms which
value is minus one
second is one room
one bed which value is also one room one bed
third is one room two bed
fourth is two room one bed
fifth is two room two bed
okk, after doing this designing part
we have to go to the webform
which is the cities
which is one of the cities
okk, after going the
after go to the paris.aspx file
we have to design this webform
which code is also give in my
description link you can collect this
code and paste it
to your
source code in your source code
okk
in this code i have design the
paris.aspx file
where on the left side i have a
picture and on the center
i have the description of hotel
in paris and on the right side
the value of the hotel
i mean the hotel rate and there is a button control
for booking the hotel
okk
in the html source code i have
use the same thing
i have do the same thing
and i use three
images for the
hotel and give the description for three hotels and
there is a hotel rate also three hotel rate
and there is a three button three separate button
for booking the hotel
okk
and after designing the paris.aspx webform
we have to design the other four webforms as like
paris.aspx webform design
and it is just simple
we have design
and
after designing part of paris.aspx
delhi.aspx beijing.aspx tokyo.aspx
and rome.aspx
we have to go to the home.aspx
file
and
we have
we have a button control which name is
search and
and now we have to write a code
for this search button
which have a
click event name search button click event
which is
which is to redirect this page to
our hotels which
we have created named as paris delhi
rome beijing tokyo
okk
go to the home.aspx and
double click on the search button
and there is a
event
generated for you on the home.aspx
.cs file which name is search
underscore click and which have two parameters object sender
and event args e
on this
event
we have to write a code with if else
first we have write a code if
text city search dot text equal equal
delhi or text city search dot equal equal delhi
it means that
first delhi is uppercase and the second delhi
is lowercase
and then it will redirect
your home.aspx webform to delhi.aspx
and we have to do the same work for tokyo beijing
rome paris
and
at last there is else statement which will
redirect you if you don't choose
this cities
i mean the delhi tokyo beijing
rome paris
and it will be redirect you to the home
and it will be redirect you to the same page
after that
write a code for page load event
on this cs file
which is for the calendar check in calendar and checkout
calendar
which is by default to false
after doing all of this design we have to design the
design the login and register webform
for login and register as a user
which is already has been created
in our
project
to find the login and register webform
we have to go to the solution explorer and
find out the account folder
expanding the account folder we can find out
the login register webform
now we have to design the login webform
when you select our project as a webform the login
the login and register webform is
autometically created
we have to do nothing
for this login webform
we have to just add a hyperlink for this webform
which will redirect
to the register
register webform i mean the registration page
and on the login page
there is code for us
which is email and password
we have to do nothing for this page
and the source code for this page will
give in the description part
you can collect this from this description part
after editing the login page
after editing the login page we have to go the registration page
registration page which is register.aspx
and in this webform we have to edit this webform
this webform
where we have to add
some new
fields like confirm password phone
adress email name
and you can add more things you want
as you want and this code
and this code
html code for this webform
will be given in the description part you can
collect this and paste to this webform
and
in this webform we
also have to add
validators which is required field validator
for name email password confirm password
phone adress and for the email
field we have to
select the
text mode property as email
and for the password field we have to
select the text mode property to
to password
and
for confirm password
for the confirm password we have to use the compare
compare
validator to compare the
confirm password with password
so if it is matched then
it will be show the confirm password and password will matched
is matched and otherwise it will be show a
error to the user
one the paris.aspx webform we have to
take a button
we have already take button named as book now
on this button click button write a code
for redirecting to the login page
it means that when we click on the book now button
it means when we book some hotel
then it will redirect to us a login page
page
if we are already
already a registered user then we can login
then we can login or otherwise we can click
click on the hyperlink to registered as a new
user okk
we have to write the same code for
delhi.aspx
tokyo.aspx beijing.aspx and rome.aspx
on this four webforms
we have already take book now button
button control and we have to write the same code
for this book now button
controlclick event
we have complete all of task for designing
designing our project
now we have to make some
functionalities or features
for our project so
so
after doing this all of things we have to
design our database to make functional
or make some features for our project we have to
make a database on sql
server management studio i mean the mySQL
now
go to the
sql server management studio ssms and create a
database named as hotel management system
and you can
named the database as
hotel room management system or hms
hm system or anything you want and
after creating a database
we have to create four
tables for the database which we will
we will use on our project
by creating a connection string on web.config
which i wil show you on this
part
first of all create a table name
admin user table
which exist
the column
name email name password
password of a user which exist three columns
email name and password and email column
column is the primary key
of this table which is varchar
and name column which is also a varchar
and password which is also a varchar
and when we creating this
this table adminuser table we have to
check out the
not null property
and after creating the adminsuer table
we have to create now
a non admin user table
which have the following columns
name email name password phone
address and id
which have
six column and the email column
is the primary key of this table
which is varchar and the name password which is also
which is also a varchar
and the phone column type is integer
and address column type is varchar and id
which is unique for non admin user
which is also a varchar and which is a
auto increment property
after that
we have created another table third table
which name is city name table
which has two column
id and city name
and the id column is primary key
which is automatically increment property
which is automatically increment property
in this table
there are two column id and city name
type of id is integer not null
and the type of city name column is varchar
which is also a not null
after that at last we have to crate the last table
named hotel info which has
five columns name hms id it means that
hotel management system id hms id cities
checkin time checkout time and
rooms
okk
the hms id will be the primary key and
and the cities checkin checkout
rooms are the other columns in this table
and the cities column is
nvarchar and checkin is nvarchar
checkout is nvarchar and room is nvarchar and
and this five columns will be not null
we have to check out the not null property
okk
we have done the
creation of a database and we
we have also created four tables now we have to take
take the project on our
now
we have to take the database on our project
by using a connection string on our web.config file
now back to the visual studio
and go to the solution explorer and find out the web.config file
u can see it on the last
or on the bottom
of your solution explorer
open the web.config file and write a
write a connection string
there is must be a connection string for u
we have to write
another connection string for our
database
hotel management system
first of all
we have to add
our name which is dbconnection
which can be
hms connection or hotel management connection or anything
i just name the
connection as dbconnection and the connectionstring
and in the connection string part there is a
property is data source in this part
you have to write your server name which will
your server name of your
ssms of your sql server management studio
to find the server name
we have to go to the
sql server management studio and go to the object explorer
and right click on it
and click connect
there is server name and authentication
and the authentication will be by default windows authentication
and the server name will be your
desktop or computer name copy this name
copy this name and paste it in your data source field
field and
and then write the initial catelog
which is your
which is your database name hotel management system
and
and give a semicolon and after that write the
the integrated security to true which is always
by default to true after that write a
provider name which is system.data.sqlclient
okk thats it for your connection string and now
build your project you can see
see database on your project
now to build your project
on visual studio go to the visual studio and
click
press control shift and B
control shift and B
now the project
hotel room management system project will be build and
go to the server explorer on the left
of your
on the visual studio and
expand the
and expand the data connection
you will be see your database on your data connection
which named as dbconnection
onj this part we have just discussed the
designing part and how to create our
database for using on our
project on the next part we will
show the functionalities and features
to create for our project
Thank you
please like share
my video and subscribe to channel to
get more
videos
or to get the second part of this hotel management system Thank you
For more infomation >> Man stabbed in stomach near Treasure Island hotel-casino - Duration: 0:14. 
For more infomation >> Aegialis Hotel & Spa, Greece (Europe). The best of Aegialis Hotel & Spa in Aegiali - Duration: 5:12. 
For more infomation >> Crowne Plaza Hotel Riyadh Minhal, Saudi Arabia (Middle East) - Duration: 5:02. 
Không có nhận xét nào:
Đăng nhận xét