visitor information and management system "agantuk" - jayita roy

Visitor Information and Management System “Agantuk”

Jayita RoyMBA(IT)

Reg. No. – KU/PG/00528 of 2014-15Roll No. – 99/MBA/140004

Faculty Guide : Prof.(Dr.) Manas Kumar Sanyal

Company Guide : Mr. Sandip Kumar Kundu

United Breweries Limited (Kalyani)

Copyright Jayita Roy 2015-16


Company Profile United Breweries Limited (UBL) is the flagship company of the UB Group.

Founded in 1915 from the merger of five breweries in India. Headquarter of this company is in Bangalore. UBL commands 48% of the domestic market with leading brands such as

Kingfisher, UB export , London Pilsner, Premium Ice and Kalyani Black Label etc.

The beer manufacturing giant owns 11 factories and has five regional offices.

The company was bought by late Mr. Vittal Mallya in 1947, and since then has never looked back.

Today each one of the 32,000 Beer outlets in India sells one brand or the other from United Breweries.

Introduction What is Visitor Information and Management System(VIMS)?

Ron Orchid a security consultant with over 30 years of experience once said “Visitor Information Management System is about controlling access, knowing who’s in the building and, making employees accountable for their visitors”.

What is the need of a VIMS software in UBL, Kalyani? Earlier days UBL, Kalyani branch use to track and keep Visitors record

manually by pen and paper. I tried to help UBL, Kalyani branch by developing Agantuk (VIMS software) for them.

What is “Agantuk”? “Agantuk” is a VIMS software, I gave this software name “Agantuk”

because it means “Visitors” in Hindi, Bengali and Nepali.

Copyright Jayita Roy 2015-16Copyright Jayita Roy 2015-16


System Development Life Cycle

Problem Identification

Feasibility Study

Requirement Analysis & Specification

System DesignCoding

Testing

Maintenance



Objectives

҉�To have an attractive and secure Login form. Two types of login Admin and User (Gate-Keepers).҉�Add visitor entry details in SQL database through Check-in form. Add visitor exit details in SQL database through Check-out form.҉�Check-in and Check-out details access only to User login(s). Visitor ID card generation҉�Ease of seeing all the data in database only through Admin login. Search, Print details of Employees through Admin login.҉�Search and Print Visitor details through Admin login Add, Update, Delete users through Admin login.҉�Add, Update, Delete employee through Admin login. Daily and custom reports of visitor’s information.



System Requirements Hardware requirements :

Compute Processor : Intel Core2Duo Mother Board : Intel D945GCPE A Memory : 512MB and above CPU Speed : 2.66 GHz RAM : 2GB HDD : 100GB and above Monitor : 15” colours (SVGA) Keyboard Mouse Webcam



System Requirements(contd..)

Software requirements : Operating System : Windows7 or above Application Software : Microsoft Visual Studio 2010(12) Database Requirement : SQL SERVER EXPRESS 2008


System Design (Context Level)

Copyright Jayita Roy 2015-16Copyright Jayita Roy 2015-16


Splash Screen


This is the splash screen of Agantuk


Login ScreenThis is the login screen, Admin and User can login from here.



Visitor Entry

Here User will write the name of the visitor and his/her organisation’s name, phone number, how many persons are with him/her, with whom s/he wants to visit and the purpose of visit. Also User will select the color code where the Visitor(s) will go. Visitors photo will be clicked for his/her Id card. Day In, Time In and Visitor Id is auto-generated.

(Contd..)



Visitor Entry(contd..)


This is the Visitor Entry Form


Auto-generated ID Card



Visitor ExitVisitor Exit for just requires Visitor id from Visitors Id card. User will input it and click on submit then if it matches to the database then there will be a good bye message. Or it will show an error which I have shown later. Day Out and Time Out is auto-generated.



Login Error



Input ErrorIf there is any data doesn’t match to database or if any field is blank then it will pop-up an error message.



Daily Report



Date-wise Report



Employee-wise Report



Other various custom Report(s)



Creation of User



Delete User



Edit User



Add Employee



Delete Employee



Edit Employee



Testing & Maintenance“Agantuk” went through several levels of testing and maintenance to ensure that it works accurately and efficiently.

Unit testing Black-box testing White-box testing Integration testing Interface testing Installation testing Uninstallation testing Validation testing System testing



References҉�Mathew A. Stoecker, Steve Stein Microsoft.NET Framework 3.5-Windows

Forms Application Development : Microsoft Press

Herbert Schildt C# 3.0 Beginner’s guide : Mc Graw Hill

҉�Christian Nagel, Bill Evjen, Jay Glynn, Morgan Skinner, Karli Watson Professional C# 2008 : Wiley Publishing, Inc

www.stackoverflow.com

҉�www.c-sharpcorner.com

www.tutorialspoint.com/sql

҉�www.csharp.net-informations.com


Thank you...
