Email: Password:       Forgot Password 
    .netCodeSG
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
 
TECHNOLOGIES:
 

An Open Source Project- R-VisitorManagementSystem

Article:
Viewed:  1547 
Posted On:  3/1/2015 1:06:58 AM 
This is an open source project developed in ASP.NET c# using SQL Server 2008. 

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

1.png 

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:

2.png

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:

3.png

Image 3.

Now run the application:

Here I have 2 types of Users one is Admin and second one is User:

4.png

Image 4.

5.png

Image 5.

Now click on Add New Visitor link:

6.png

Image 6.

7.png

Image 7.

From here employee can search any visitor, can make log out. . .

8.png

Image 8.

9.png

Image 9.

10.png

Image 10.

Now Log in As ADMIN:

11.png

Image 11.

12.png

Image 12.

Now click here Manage Employee link:

13.png

Image 13.

14.png

Image 14.

Now again click on ADMIN link -> and click on Manage Visitors Link.

15.png

Image 15.

16.png

Image 16.

Admin can search visitor, can delete any visitor from here.

17.png

Image 17.

Now again click on ADMIN link: -> Click on View visitors By Employee

18.png

Image 18.

19.png

Image 19.

Select Employee and click on Search visitor Button:

20.png

Image 20.

21.png

Image 21.

Enjoy My Project  J  Happy Coding !

  Comment:
 
By dotnet  On  4/6/2016 1:28:31 AM
Stock Management System Project with Source Code http://allittechnologies.blogspot.in/2015/05/stock-management-system-project-for-asp.net-beginners-experience-in-software-it-technologies.html Stock Management System Project
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us