This is my open source project named as R-VisitorManagementSystem.
Now a day you see every companies are keeping record of
every visitor to keep information on line ie: who visit company, what was
his/her purpose to visit, whom he/she wants to meet etc.
Now I am explaining my Project:
Here I developed this project using Visual Studio 2012
and SQL Server 2008 R2.
Below are the tables detail used in this project:
1. Employee
Image 1.
Script of my Table is:
CREATE TABLE [dbo].[Employee](
[EMP_ID] [int]
IDENTITY(1,1) NOT NULL,
[Email]
[varchar](500) NULL,
[Password]
[varchar](50) NULL,
[Name]
[varchar](50) NULL,
[User_Type]
[varchar](10) NULL,
[Created_Date]
[datetime] NULL,
CONSTRAINT [PK_Employee] PRIMARY
KEY CLUSTERED
(
[EMP_ID] ASC
)WITH (PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS
= ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Employee] ADD CONSTRAINT
[DF_Employee_Created_Date] DEFAULT (getdate()) FOR [Created_Date]
GO
2. Visitors:
Image 2.
Script of my table:
CREATE TABLE [dbo].[Visitor](
[Visitor_ID]
[int] IDENTITY(1,1) NOT NULL,
[Emp_ID] [int]
NULL,
[Name]
[varchar](500) NULL,
[Mobile]
[varchar](50) NULL,
[Organization]
[varchar](500) NULL,
[City]
[varchar](50) NULL,
[Address]
[varchar](2000)
NULL,
[Visit_Department]
[varchar](500) NULL,
[VisitPurpose]
[varchar](5000)
NULL,
[Visit_Date]
[date] NULL,
[In_Time]
[varchar](50) NULL,
[Out_Time]
[varchar](50) NULL,
CONSTRAINT [PK_Visitor] PRIMARY
KEY CLUSTERED
(
[Visitor_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS
= ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Visitor] ADD CONSTRAINT
[DF_Visitor_Visit_Date] DEFAULT (getdate()) FOR [Visit_Date]
GO
Now in below figure I am trying to explain my project
working:
Image 3.
Now run the application:
Here I have 2 types of Users one is Admin and second
one is User:
Image 4.
Image 5.
Now click on Add New Visitor link:
Image 6.
Image 7.
From here employee can search any visitor, can make log
out. . .
Image 8.
Image 9.
Image 10.
Now Log in As ADMIN:
Image 11.
Image 12.
Now click here Manage Employee link:
Image 13.
Image 14.
Now again click on ADMIN link -> and click on Manage
Visitors Link.
Image 15.
Image 16.
Admin can search visitor, can delete any visitor from
here.
Image 17.
Now again click on ADMIN link: -> Click on View
visitors By Employee
Image 18.
Image 19.
Select Employee and click on Search visitor Button:
Image 20.
Image 21.
Enjoy My Project
J
Happy Coding !