Time Sheet Management System .Net Project

The main aim of developing this Time Sheet management System .Net Project is to provide automated work Time sheet for allocated projects all employees in the organisation.

The main Users are Employee, Manager and Admin.

Employee functionalities:

where employees can login with their credentials and view their details, modify existing details, enter new time sheets, view time sheet, update time sheet, delete sheets

Manager functionalities:

Where manager has actions like release, update, view, change & allocation time sheet functions.

Admin functionalities:

Where admin can add employees, approve time sheets, create projects, view projects, create employee id’s, project billing actions, etc.

Database Tables below:

Project Table:

 

Column Name Data Type
UniqId int
ProjectId Varchar(50)
Project Name Varchar(50)
Started Date Varchar(50)
Estimated Date Varchar(50)
Client Name Varchar(50)
Client Location Varchar(50)
Address Varchar(50)
Poc Varchar(50)
PO Varchar(50)
Scope Document Varchar(50)
Estimated Cost Varchar(50)
Types Varchar(50)
Pay For Manager Varchar(50)
Pay For Employee Varchar(50)
Technology Required Varchar(50)
Data Bases Varchar(50)
AssgineTo Varchar(50)

Employee table:

Column Naame Data Type
UniqId int
EmpId Varchar(50)
First Name Varchar(50)
Last name Varchar(50)
Password Varchar(50)
Gender Varchar(50)
Phone Number Varchar(50)
Email Varchar(50)
AltEmail Varchar(50)
Experience Varchar(50)
Date Of Join Varchar(50)
Address Varchar(50)
City Varchar(50)
State Varchar(50)
Country Varchar(50)
Pincode Varchar(50)
Position Varchar(50)
Status Varchar(50)

Timesheet Table:

Column Name Data Type
TimeSheet Id int
EmpId Varchar(50)
Date Varcar(50)
Analasys Requirement Varcar(50)
Preparing Functional Design Document Varcar(50)
 Preparing High Level Design Varcar(50)
  Preparing  Loe Level Design Varcar(50)
   Writing Code Varcar(50)
  Preparing Tcehnical Design Document Varcar(50)
Analasys & Fixing Bug Varcar(50)
Unit Testing Varcar(50)
System Testing Varcar(50)
 Integrity Testing Varcar(50)
Preparing Test cases Varcar(50)
Totaltime Varcar(50)
Status Varcar(50)

 

Column Name Data Type
Allocated Id int
Allocated By Varcar(50)
Project Id Varcar(50)
Project Name Varcar(50)
Allocated To Varcar(50)
Status Varcar(50)

 

Column Name Data Type
Uniq Id int
Project Id Varcar(50)
Emp Id Varcar(50)
Total Work Hrs Varcar(50)
Payment Varcar(50)

Download the Time Sheet Management System .Net Project Source code

College Visitor Management System .Net Project

Abstract: “College Visitor Management System” is a process of managing the information of the visitors visiting the College campus. For any organization maintaining the information of the visitor is a very major issue. This system will replace the manual maintenance system and will help the authorities to keep track of the visitors visiting the campus.

This software is being build with help of ASP.NET. The data of the new visitors visiting the campus will be stored in the database. With this system the visitor’s information can be stored in the database, so that in the future it shall be used for the reference. The data will be stored in the SQL SERVER as the backend. This software will help an organization to do the job effectively and give an all round development of the project.

The major features of the College Visitor Management System are:

  1. The in and out time of the visitors is stored in the database.
  2. Name, address and all other information regarding the visitor.
  3. There will also be provision to retrieve the data from the database for the future references.
  4. The reason for which the visitor is going to visit the campus.
  5. When the visitor visits the campus for the first time he/she needs to register. He/she will be provided with an id so that whenever he/she wants to visit next time they can refer through this particular id.
  6. Appointments of the Visitors with the Faculty will also be stored in the database.

Requirement Analysis

Module:

College Visitor Management System

Overview Statement:

The purpose of this module is to store the information of the visitor’s visiting the campus.

Customer:

Visitor

System Functions 

Ref # Function Category
R 1.1 Visitor should be able to add his details. Evident
R 2.1 System should be able to save the new visitor details. Hidden
R 1.2 Visitor should be able to get the appointment from the faculty. Evident
R 2.2 System should be able to save the appointment time & intimate the visitor about the availability of the concerned faculty. Hidden
R 1.3 The security personnel should be able to update the IN time of the visitor. Evident
R 2.3 System should be able to inform the concerned faculty regarding the visitor. Hidden
R 1.4 After the visitor had paid his visit to the concerned faculty, the system should save it. Hidden
R 2.4 System should inform the security post that the visitor has met the faculty/staff. Hidden
R 1.5 The security personnel should enter the OUT time of the visitor. Evident
R 2.5 System should be able to save it. Hidden

 System Attributes 

Attribute Detail and Boundary Constraint
Software Microsoft ASP.NET
Hardware Web Camera, PC with 250 GB hard disk & 4 GB RAM.
Network Local Area Network

 List of Use Cases and Scenarios

 Use case # 1 /Maintaining Users

Scenario # 1 / Adding a User.

Scenario # 2 / Deleting a User.

Use case # 2 / Maintaining the Roll

Scenario # 1 / Adding a new Roll.

Use case # 3 / Maintaining Visitor information.

Scenario #1 / Adding a new visitor.

Scenario #2 / Editing the Visitor information.

Scenario #3 / Searching for a Visitor Data.

Use Case # 4 /Maintaining Appointments

Scenario # 1 / checking the appointments of the faculty.

Scenario # 2 / Fixing the Appointment for the visitor.

Use Case # 5 / Maintaining the Appointments details.

Scenario # 1 / Reason of the Appointment.

Scenario # 2 / Faculty/staff member with whom the visitor wants to meet.

Use Case # 6 /Maintaining the meeting details.

Scenario # 1 / IN & OUT time of the visitor, meeting with the faculty/staff.

Use Case Diagram:

Data Flow Diagram:

PROJECT FORMS

Form 1 Homepage

• This is the Home Page.
• The user needs to type http://localhost/College/webform2.aspx in order to get this page.
• There is a calendar showing the current date and year.
• There are two hyperlink buttons on this page
o NEW VISITOR
o SEARCH
• On the left hand side of the form there are 3 hyperlinks
o About NIST
o FACULTY
o COURSES OFFERED

Form 3. New Visitor Entry Page

• When the user clicks the NEW VISITOR button from the homepage this page is displayed.
• The user enters the necessary data in this form and clicks the Save button in order to save the data in the database.
• After the data has been saved the user clicks the Home page in order to return to the Homepage.
• If the user wants to refresh the data entered he/she has click the refresh button.

Form 2. Search Page

• This page is obtained on clicking the SEARCH button from the Homepage.
• The user needs to select anyone of the search criteria.

Form 2.1 Search form where the search criterion is Visitor ID.

• The user enters the visitor id and clicks the search button.
• The entire detail of the visitor is displayed in the data grid.

Form 2.2 Search Form where the search criterion is name.

• The user enters the first name of the visitor and clicks the search button.
• The entire detail of the visitor is being displayed in the data grid.

Form 2.3 Search Form where the search criterion is Place

• The user enters the place and clicks the search button.
• The entire detail of the visitor is being displayed in the data grid.

Form 2.4 Search Form where search criterion is Date.

• The user enters the date in the mm/dd/yyyy format or selects the date from the calendar as shown in the above form.
• The entire detail of the visitor is being displayed in the data grid.

Form 3 Visitor Detail Page.

• When the user clicks the SELECT hyperlink from the data grid, this page is being displayed.
• The user clicks the Appointment button to move to the Appointment page.
• The user may click the Home button to return back to the Homepage.

Form 4.1 Appointment Form.

• This page is displayed when the user clicks the appointment button from the visitor details form or enters the visitor id in the search page and clicks the appointment button in the search button itself.
• The user then clicks the show calendar button to display the calendar.

Form 4.2 Appointment Page showing the calendar.

• The user selects a particular date from the calendar, which is being displayed in the textbox (mm/dd/yyyy format).
• Then the user selects the faculty with whom the appointment is to be taken.
• The image of the faculty is being displayed in the faculty/staff image box.
• Then the user mentions the reason for appointment and selects the timing.
• The user then clicks the save button to display the batch.

Form 5. Faculty Information Page.

• The user may select any of the hyperlink in order to display the page showing the information regarding the concerned faculty.

Simple Intra Network Sniffer .Net Project Synopsis

PURPOSE OF THE PROJECT

Intra Network Sniffer is a tool designed for the purpose of searching for files and folders which are shared over a Local Area Network. It is particularly useful in organizations where a lot of folders are shared on individual systems.

Here’s how the application works. We need to specify an IP range. The tool searches for live hosts. It then determines the list of folders shared by each system and looks for files (according to a keyword that we specify).

PROBLEM IN EXISTING SYSTEM

In the existing system, workgroup list won’t populate or is incomplete.  Says network resources are unavailable or cites permission problem. The system doesn’t understand sharing files among all range of system IP address. There is no interface designed to search the files on a specific LAN. High-level views of the system network activity are not provided by the existing system. In applications ranging from financial institutions to manufacturing facilities, network engineers will find Serial test easy to work with but loaded with features.

SOLUTION OF THESE PROBLEMS

In the proposed system workgroup will be populated in the interface completely, by using this workgroup the only administrator will know the architecture of the LAN. The proposed system is a passive and easy-to-use network monitor that helps network personnel understand what is occurring on their communications LANs.

By observing the workgroup range administrator will arrange the IP address range in the proposed system. A high-level view of the system network activity is provided in this proposed system. A good user interface will provide the administrator to watch the network sharing files among the LAN. Whenever a file is transferring between a range of IP addresses, the administrator can watch the file content on its own file mode.

Software Requirements:

  • WINDOWS OS
  • Visual Studio .Net
  • Internet Information Server
  • Visual Studio .Net Framework (Minimal for Deployment)
  • Microsoft Visual C# .Net

PROPOSED SYSTEM

In the proposed system workgroup will be populated in the interface completely, by using this workgroup the only administrator will know the architecture of the LAN. The proposed system is a passive and easy-to-use network monitor that helps network personnel understand what is occurring on their communications LANs.
By observing the workgroup range administrator will arrange the IP address range in the proposed system. High-level view of the system network activity is provided in this proposed system. A good user interface will provide the administrator to watch the network sharing files among the LAN. Whenever a file is transferring between a range of IP addresses, the administrator can watch the file content on its own file mode.

UML Diagrams:

Use case Diagram:

Sequence Diagram:

INPUT AND OUTPUT

The major inputs and outputs and major functions of the system follow:
Inputs:
• Specify the IP address range
• Select the File or Folder Type
• Give any keyword for searches like file name or extension
• Open the file in different file modes.

Outputs:

• The search starts for the given IP address range
• Catch the file depends on the file type
• The selected file will be opened depends on the file mode.

PROCESS MODEL USED WITH JUSTIFICATION

In this system, two types of process modules are developed.
• Text Module
• File Module
Text Module
Text module is the method in which the image is uploaded in the required path and then text to be hidden is given in the textbox and a retrieval key is given in the module to retrieve the information from the image while the extraction occurs.
File Module
File module is the method in which the whole file is extracted from a local disk and it is sent to another location by hiding the file and it is extracted to a required location with help of the key.

Project Execution Process:

  • Home Page Before Execution
  • Select a Bit Map Image
  • Add a string for Key
  • Type Secret Message and Hide the Message
  • Save the Hide Message in another Image
  • Extract the Secret Message Using Image (Uploading Image for Message Extracting)
  • Press Extract Button for Retrieving Secret Code
  • Finally, Secret Code Received

Query Redressal System .Net Project

The Query Redressal System is designed for the customers of the Global Bank. Through this system, the bank will manage the complaints from the customers and provide the better services for their customers.

The other target of the bank is to provide the services to its customers all over the world. This project enables the customers of the Global Bank to see the general information about the products, services, and schemes offered by the bank.

The Customers of the bank will be given an email id for each product, where they can send an e-mail when they have a query to register.

The email will be converted into complaints and then assigned to the persons handling the product. Persons handling the complaint will have a facility to communicate with the customer via emails through the system.

Advantages:

  • No wastage of time to send a query.
  • We also can know the complaint details.
  • Requires less man power.

Modules:

  • Administrator
  • Products
  • Services
  • complaints

UML Diagrams:

ER Diagram:

Class Diagram:

Use Case Diagram:

Sequence Diagram:

SOFTWARE REQUIREMENTS

Operating System: MS

Languages: Asp.Net with C#

Database System: MS-SQL Server

Web Server: MS IIS

Download Query Redressal System .Net Project.

Development of RunAway Holidays .Net Project

Our Development of RunAway Holidays Project has one Module and it had developed by using .net technologies.

  1. Agent

Administrator:-

Features:-
1.  Register
2.  Forgot Password
3.  Login
4.  Edit Profile
5   Agent Menu
a.  Booking Details

  1. Retrieve booking
  2. Check Fare
  3. Cancellation

Description:-

The administrator has to register first of all.
* Registration is allowed for only one administrator i.e once an admin is registered no other person is allowed to register again.
* After registering, if he/she forgets his/her password, he can get it by giving valid id & emailid and then answering the secret question correctly.
* Once admin provides valid id & password for login, he/she can go to the menu. 

Using this menu admin can

  • edit his/her profile.
  • Add/update/delete/view Booking Details

UML DIAGRAMS

USECASE DIAGRAM:

Use Case Diagram for Agent

Activity Diagram for Agent

Deployment Diagram

Login Flow Diagram

State Diagram:

Database Table:

Output Screens include:

  • Home Page:
  • Agent Login Page:
  • Agent Home Page:
  • Booking Details Page:
  • Retrieve Booking Page:
  • Fares Page:
  • Cancellation Page:
  • Ticket Cancelled Page:

SOFTWARE REQUIREMENTS:

Operating System: Windows

Database: Sql Server

Server side technology: ASP.Net

Server side scripting : ASP

Client-side scripting : HTML, JavaScript

Web-Server : IIS

Database Details below:

Admin Table

  • admin name
  • admin password

Agent Table

  • first name
  • last name
  • mno
  • email id
  • date of birth
  • address
  • city
  • state
  • country
  • pin code
  • agname
  • agpswd
  • agcpswd
  • pswdhint

bbooking Table

  • tname
  • bno
  • type
  • nos
  • bfrom
  • bto
  • atime
  • dtime
  • tcost
  • bdate

Bus Table

  • tname
  • bno
  • type
  • nos

Card table

  • type
  • bname
  • validity
  • number
  • hname

Customer Table

  • fname
  • lname
  • mno
  • eid
  • dob
  • address
  • city
  • state
  • country
  • pin
  • uname
  • upswd
  • ucpswd
  • pswdhint

Feed Table

  • fto
  • ffrom
  • sug
  • per

hbooking Table

  • hname
  • reg
  • type
  • noa
  • nona
  • place
  • address
  • phno
  • ac
  • nonac
  • cac
  • cnonac

hcard Table

  • type
  • bname
  • validity
  • number
  • hname

Hotel Table

  • hname,
  • reg
  • type,
  • noa
  • nona
  • place,
  • address,
  • phno

hticket

  • hticket
  • uname
  • hname
  • reg
  • aday
  • dday
  • type
  • typer
  • place
  • nor
  • cost

Map Table

  • place
  • district
  • state
  • country
  • img_pk
  • img_stream
  • img_type

tcard Table

  • type
  • bname
  • validity
  • number
  • hname

Ticket Table

  • ticketid
  • uname
  • bname
  • bno
  • type
  • nos
  • bfrom
  • bto
  • atime
  • dtime
  • cost
  • bdate

Tour Table

  • packid
  • package
  • nop
  • cost

tticket Table

  • tticketid
  • uname
  • packid
  • package
  • nop
  • cost

Download Development of RunAway Holidays .Net Project Code and Database