Employees to Employer Conference .Net Project

Abstract:

In this Employees to Employer Conference project, we will provide an enhanced way of communication between team members and employees working for an organization.

There are 2 modules

  1. Admin
  2. Employee

Admin:

Admin will login into the application by giving the default username and password and admin can create the branches by giving its id and he can also add departments for respective branches and add employees for respective branches and departments that are added by admin. Admin can view the added branches, Departments and employees of all branches. Admin can delete the employees.

Employee:

Employee will login into the application by the admin given user-id and password and selecting the department, after logging in an employee can view his profile and also add the documents required for any type projects which are made in the organization. While uploading documents he can give the description for what kind of this document is. He can also enter into the conference and discuss with the other team members in the respective branch and department about the project details. Employee can also view the list of documents uploaded by him.

Existing System:

In the existing system communication between employees is lacking which leads to a non-healthy environment and may decrease the growth of the organisation so the above mentioned will be sorted out with this application. 

Database Tables:

Database tables for Employee, branch, Data and Department

Data Flow Diagrams:

Proposed System:

In Proposed System admin will create the employee and branches and departments and employees who are in the same department and same branch can login into the application by the admin given username and passwordand they upload the documents required for projects and enter into conference and discuss about the on-going project.

UML Diagrams:

Class Diagram:

State Diagram:

ER Diagram:

Download Employees to Employer Conference .Net Project Source Code, Project Report final Documentation and PPT Presentations.

Road Transport Authority RTA Information System .Net Project

Abstract:

Road Transport Authority is a C#.Net based web application which enhances the use of RTA Services with ease. In this .Net Project there are 3 Modules

  1. RTO
  2. Employee
  3. Apply For LLR (User)

Employee:

In This Application RTO Will add the employees with details the employee can login by the given username and password. The employee can add the LLR details received from the user. An employee can also renew the LLR of the users. The employee can also generate the payment against issued challan.

Employee performs the following Functions

  • Issue of Challans
  • View Renewed LLR Details
  • View Renewed PL Details
  • View Registered Vehicle Details
  • View New LLR Registrations
  • Can Also view the registration details Monthly Wise

RTO:

RTO Can add the employee details and can view the registration of vehicle details and issue of LLR and PL Details and renewals of LLR and PL. 

User:

The user can simply for LLR by giving all necessary details and then clicking on submitting we are taken to the challan payment page after successful completion of payment we should write the Test for Learning License. After Exam completion, the result will be shown.

UML Diagrams:

Object Diagram:

Activity Diagram Renewal of Learner License And Permanent Licence:

Use Case Diagram:

Class Diagram:

Sequence Diagram:

Existing & Proposed System:

Nowadays we see that using the internet has grown a lot so we need to implement everything online to provide fast and efficient services to the public or users. Users in the earlier days must visit the RTO office to complete the registration of a newly Brought vehicle or to apply an LLR or Pl, which takes a lot of time. Using this application, the RTO and Employee can register the vehicles Using their applications. In this application, we also provided and LLR Test to written online, but in practical to write an LLR we must go to RTO Office and register and wait for a long time. The Whole process is made Simple By this application.

Now in this application generating or extracting the user details are just matter of time because everything which is registered or added is made to store in a centralized database so extracting the details and generating the monthly reports was easy. Previous days we used to maintain or write the records manually, so to search the details or providing the monthly reports was a big task. 

Data Dictonary

  • Table Name: Challana details
Column Name Type Size
cno nvarchar 50
name varchar 50
amount nvarchar 50
ianame varchar 50
Ides varchar 50
Vfrom Varchar 50
Vto Varchar 50
  • Table Registration details
Column Name Type Size
regno nvarchar 50
regdate varchar 50
nameofapp varchar 50
sdwof varchar 50
age varchar 50
Add1 varchar 50
Add2 varchar 50
city varchar 50
state varchar 50
phno varchar 50
nameadd varchar 50
typeofveh varchar 50
date1 varchar 50
chassisno varchar 50
engineno varchar 50
Seatcap varchar 50
Fuel varchar 50
  • Table Name: LLR details
Column Name Type Size
Img_pk Int 4
Img_title varchar 50
Img_stream Image 16
Img_type Varchar 50
llrno Varchar 50
ldate Varchar 50
name Varchar 50
swd Varchar 50
dob Varchar 50
bg Varchar 50
a1 Varchar 50
a2 Varchar 50
City Varchar 50
State Varchar 50
Phone Varchar 50
Mark Varchar 50
Vfrom Varchar 50
Vto Varchar 50
Type Varchar 50
  • Table Name: Admin
Column Name Type Size
Id nvarchar 50
Password nvarchar 50
  • Table Name: LLR Exam
Column Name Type Size
Examno Varchar 50
Ans1 Varchar 50
Ans2 Varchar 50
Ans3 Varchar 50
Ans4 Varchar 50
Ans5 Varchar 50
Ans6 Varchar 50
Ans7 Varchar 50
Ans8 Varchar 50
Ans9 Varchar 50
Ans10 Varchar 50
name Varchar 50
Edate Varchar 50
chalno Varchar 50
  • Table Name:Addemp
Column Name Type Size
Id nvarchar 50
Password nvarchar 50
Name varchar 50
Address varchar 50
phno varchar 50
  • Table Name: Renewal of LLR and PL
Column Name Type Size
llr nvarchar 50
dateofiss varchar 50
dateofren varchar 50
typelicence varchar 50
name varchar 50
sdw varchar 50
dob varchar 50
bloodg varchar 50
Add1 varchar 50
Add2 varchar 50
city varchar 50
state varchar 50
phno varchar 50
Ident1 varchar 50
Ident2 varchar 50
vfrom varchar 50
vto varchar 50
chano varchar 50
amount varchar 50
  • Table Name:Result
Column Name Type Size
aname nvarchar 50
examno nvarchar 50
cno varchar 50
edate varchar 50
marks varchar 50
result Varchar 50

Conclusion:

In all the above advantages we must use this application for fast completion of Process and secure payments using challan details.

Download Road Transport Authority RTA Information System .Net Project Source Code, Project Report

Paint Editor Application .Net Project

This is a Paint Editor Application tool where the user can create amazing designs on his own very easily.

In this editor/application with the following features This is similar to paint application but with the added features.

Features Below:

1. User will be able to create an empty page
2. On click of a text icon in tool box, User will be able to create the text at any place on the page.
3. On click of an img icon in tool box, User will also be able to import images on to the page.
4. On click of a ‘+’ icon in tool box, user will also be able to add new page.
5. User can do all the manipulations on the new page for text and images.
6. User will be able to duplicate the page on clicking the “duplicate page” button in toolbox.
7. User will be able to edit the text, move the text, rotate and be able to scale it.
8. User will be able to create multiple copies of the text.
9. User will be able to change the color of the text, by clicking on the text and choosing the color.
10. User will be able to change the font, style (like bold, italic), theme (TimesNewRoman, Calibri) of the text.
11. User will be able to browse through the local file system and select desired image and be able to import it onto the page.
12. User will have the ability to import multiple images on to the page.
13. User will also be able to make multiple copy/copies of the imported image.
14. User will be able to move, rotate, and scale the images.
15. User will be able to move the objects forward if there is another object on top of them. For eg: if there is a text on top of which there is an image. If user wants the text to be displayed on top of the image, he can select the text on click on fwd. button on top of the page.
16. User will be able to move the objects backward if there is another object on behind them. For eg: if there is a text behind an image and the user wants the text to be displayed on top of the image, he can select the image and click on bkd. icon on top of the page, to move the image backward.

Though the requirements seems to be very simple, we need to create a brand new Windows application using .NET and exhaustive testing needs to be done.

Technology: .NET

Contents of output package: exe of the developed application, clear documentation and readme file.

Introduction

1. Welcome to Paint Editor Application

2. It allows you to do major functionalities similar to paint application.

Configuration

1. Downloaded folder contains 2 files

2. Both should be placed in the same folder to run the application.

Modules:

1. Create New Page
2. Open

3. Save

4. Delete, Redo, Undo

5. Cut, Copy, Paste

6. Insert, Move, Scale, Rotate image files.

7. Insert, Move, Scale, Rotate Text.

8. Change Font Size, Font Family, Font Colour and basic font functionalities (Bold, Italic) for TEXT.

Download The Paint Editor Application .Net Project Source Code

Airline Catering Services .Net Project

Purpose

India has a major market where there is a strong demand for top quality in flight catering services. A complicated system like airline catering needs to consider various issues. It is the independent international system which provides a collaboration work made easy by chef and administrator.

Project Scope

Airline Catering Services software provides a better user interface in the catering system. Here we maintain all the details of the chef and we maintain the all the goods available in the store. This makes the chef work more reliable. Apart from this Airline Catering Services application we also maintain transport details we have different vehicles to carry different food materials.

Communication interfaces:

System Design:

Study of Existing system

“India is a major market where there is a strong demand for top quality in-flight catering services”. A complicated system like airline catering needs to consider various issues. Till now this type of system is not yet integrated to provide automated catering services.

Technical architecture:

Proposed system

Airline catering services is the independent international airline caterer services which provides a collaboration work made easy by chef and administrator. Transport and Retrieval System have been devised manually, making the entire material handling/stacking process completely mechanized.

Using this Airline Catering Services application administrator can get the details such as number of passengers traveling in the aircraft, the items to be packed for the airlines, what type of food Items (veg or non-veg), beverages that are to be supplied. He can send the required information for administrator.

UML Diagrams:

Use Case Diagram:

Class Diagram:

Sequence Diagram for User:

Sequence Diagram for Admin:

Sequence Diagram for Chef:

Database design:

Requirements

Functional requirements

The following modules are present in this Airline Catering Services application:

  • Administration System: In this module admin can send all the details required to other members. Details like number of passengers travelling in the aircraft, the items to be packed for the airlines, what type of food items (veg or non-veg), beverages that are to be supplied will be configured.
  • Chef: The chef should have the details like number of dishes to be prepared. He will plan what are the items and beverages to be purchased from the vendor. He has to take care of each and every goods that is required for the chef, and he has to maintain each and every flight timings and what the food to be served for that particular airline he has to maintain all that details
  • Care taker: He is responsible to transfer the goods from the transporter to airlines. He plays a major role, he has to maintain all the records of what all the goods he delivered and at what time he received the good. He has check whether the food is good or spoiled during the traveling.

Database tables

TABLE NAME:  Airreg

Column name Data type Length Allow null
Id int 4 0
name varchar 50 0
email varchar 50 1

 

telephone varchar 50 1

 

address varchar 150 1

 

pin varchar 50 1

 

city varchar 50 1
status char 10 0

TABLE NAME:  Chef_Orderproducts

Column name Data type Length Allow null
chefProductsId int 4 0
ProductsOrdered varchar 2000 1
OrderId int 4 1
ChefEmpId int 4 1

TABLE NAME:  roles

Column name Data type Length Allow null
role_Id Int 4 0
role varchar 50 0

TABLE NAME:  Flightdetails

Column name Data type Length Allow null
FlightId int 4 0
FlightName varchar 50 1
FlightTimings varchar 50 1
Deliverytime varchar 50 1
Reporteename varchar 50 1
Reporteephno varchar 50 1


TABLE NAME
:  Food_Type

Column name Data type Length Allow null
foodTypeId int 4 0
foodType varchar 50 1
description varchar 150 1
status bit 1 1

TABLE NAME:  ItemImages

Column name Data type Length Allow null
imageId int 4 0
imageName varchar 50 1
imagePath varchar 50 1
IsActive bit 1 1

TABLE NAME:  Items

Column name Data type Length Allow null
ItemId int 4 0
itemName varchar 50 0
itemDescription varchar 150 1
itemCost float 8 1
ItemTypeId int 4 0
imageId int 4 1
foodTypeId int 4 1
categoryId int 4 1
ItemTempId varchar 50 1
IsActive bit 1 0

TABLE NAME:  Item temperature

Column name Data type Length Allow null
ItemTempId int 4 0
Temperature varchar 50 1

TABLE NAME:  Itemtype

Column name Data type Length Allow null
ItemTypeId int 4 0
ItemType varchar 50 1
description varchar 150 1
status bit 1 1

 Software :

  • Language : Microsoft C#
  • Microsoft ASNet
  • Runtime : Microsoft Framework
  • Environment : Microsoft Visual Studio IDE
  • Web server: Internet Information Services (IIS)
  • Database : Microsoft SQL Server
  • Operating system : Microsoft Windows

6.2 Test cases:

Test case number #01
Module Airline
Description Registration
Input Provide the details in the registration page for the airlines
Expected Output Request for username and password to be entered
Actual output Request for username and password to be entered
Test case number #02
Module Airline
Description registration
Input Provide the login details
Expected Output Displays a message that registration is successful
Actual output Displays a message that registration is successful
Test case number #03
Module Airline
Description login
Input Provide the login details and select the user option in dropdown
Expected Output Displays catering services home page
Actual output Displays catering services home page
Test case number #04
Module Airline
Description Home page
Input Click on about us link
Expected Output Displays the catering management information
Actual output Displays the catering management information
Test case number #05
Module Airline
Description Home page
Input Click on contact us
Expected Output Displays the address of catering services
Actual output Displays the address of catering services
Test case number #06
Module Airline
Description Place an order page
Input Select the food timings and food type
Expected Output Displays the item name, image, description and quantity information
Actual output Displays the item name, image, description and quantity information
Test case number #07
Module Admin
Description Home page
Input Click on orders link
Expected Output Displays the flight details, order details and delivery time
Actual output Displays the flight details, order details and delivery time
Test case number #08
Module Admin
Description Home page
Input Click on orders and view
Expected Output Displays the order details previously entered and  the items ordered
Actual output Displays the order details previously entered and  the items ordered
Test case number #09
Module Admin
Description Home page
Input Click on orders and accept
Expected Output Request to select the chef to whom order has to be assigned
Actual output Request to select the chef to whom order has to be assigned
Test case number #10
Module Admin
Description Home page
Input Select the chef from the drop down list
Expected Output Displays the particular chef information
Actual output Displays the particular chef information
Test case number #11
Module Admin
Description Home page
Input Click on submit
Expected Output Displays a message that the order has assigned successfully
Actual output Displays a message that the order has assigned successfully
Test case number #12
Module Chef
Description View order
Input Click on order link
Expected Output Displays the order item details and order status
Actual output Displays the order item details and order status
Test case number #13
Module Admin
Description view status
Input Click on order status
Expected Output Displays status as product ordered by chef
Actual output Displays status as product ordered by chef
Test case number #14
Module Chef
Description if the order is ready
Input Click on chef inprocess order link
Expected Output Click on completed preparing food link
Actual output Click on completed preparing food link

Output Screens shots

  1. Login
  2. “User” home page
  3. Select Food as per our choice
  4. Place Order
  5. Admin Login
  6. “ADMIN” check for orders with respective of flight details , food types. He sends order information to “CHEF”
  7. CHEF logins and check his orders and prepares food .

Conclusion:

This  proposed  project  “Airline Catering services” is  analyzed ,designed , developed and  tested in the specified  period  of time  using the Advanced Microsoft  .Net technology   to automate the general operations held in a catering system

Track Machine Management for Railways .Net Project

Railways is a big organization which need to maintain the details of different things like tracks and their material so it is tedious job to maintain all these details manually,in order to overcome this problem track procurement management system is providing the successful tools and techniques to a broad range of activities like maintaining  inventory of the material needed for tracks like bolts,nuts,joints etc…,the project mainly contains the modules like material purchasing,material issuing, stock maintenance, zonal issuing,monitoring of track machines.

This project is about the maintenance of Railway tracks of particular region.

UML Diagrams:

Class Diagram:

Sequence Diagram for Employee, Administrator, Manager & Supplier:

Data Flow Diagrams:

And this project consists of four modules.

  1. Admin
  2. Manager
  3. Employee
  4. Supplier

Administrator

  • Views the details of manager,employee, Supplier.
  • Updates,deletes details.
  • To view the details ,admin should login

  • Admin logins by using user name –admin
  • User type admin
  • Views the details of manager,employee and supplier.
  • These details are stored in database using MS-SQL server 2000 where these data is stored in the form of Tables.
  • Similarly data is stored for manager,employee in database.
  • Admin can add new shipping address Requirements
  • When admin wants to add new shipping address
  • He can by filling the add new shipping address form

Manager

  • Orders material requested by employee
  • Gets the information of material supplied to employee from supplier.
  • Logins by using username,password and Type-manager
  • He can view his personal details, employee details and supplier details.
  • He gets the details of the material supplied to the employee.
  • He can delete employee details from database
  • Approve material
  • This information is given to manager by employee.
  • Received material information is forwarded by supplier
  • When supplier delivers material to employee.

Employee:

  • Third module
  • Logins by using user type-employee
  • Views personal details, supplier details, received materials, requested materials.

Supplier:

  • Sends material to the employee directly
  • Gives information of the material delivered to employee ,to the manager.
  • i.e both manager and employee can view received material
  • Delivers the material from shipment
  • He can view personal details, requested material and send material

SOFTWARE REQUIREMENTS

Operating System      :        MS Windows

Languages                   :        Asp.Net with C#

Database System       :       MS-SQL Server

Download this Track Machine Management for Railways .Net Project Source Code & Database.