Complaints Resolver Application .Net Project

Abstract:

Customer Complaints resolver is a web application which we can find the solutions to the problems we have raised and registered in the application. In this Final Year Project, we have 3 modules

  1. Admin
  2. Servicemen
  3. User

In Daily life we get a lot of problems for the devices we are using so each and every time we cannot make the way for the shop, then in this application user can find the solutions to the queries.

Admin:

Admin Will login into the application with the default username and password. After logging admin can view the registered user details. Admin can add servicemen by giving service id and all the necessary details, he can also view the status of the user complaints, admin can view the complaints given by users and then admin will assign the users complaints to a serviceman. Admin can view the feedback provided by users.

Serviceman:

A serviceman can log in with the admin given username and password and he can view the complaints assigned to him by admin then he will respond or send solution according to the query.

User:

The user will register by providing all necessary details and then he will log in with the username and password after logging user can send the complaint by giving user-id and complaint description user can also give the feedback of how the response provided by the serviceman.

UML Diagrams:

Data Flow Diagram:

Class Diagram:

Use Case Diagram:

Sequence Diagram:

Activity Diagram:

Existing System:

In Existing System user needs to contact the persons for each and every problem he got, this is annoying and wastes a lot of time. We may not get the best solution in some cases.

Proposed System:

The proposed system, the user just needs to register into the application and then using the username and password and then just describe the problem and then submit the rest is dine by admin and serviceman. The user will have the least amount of work and if he is not satisfied with the solution he can give feedback to admin.

Database Design:

Download Complaints Resolver Automation System .Net Project Code, Project Report, Output Screens, UML Diagrams, etc

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

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

Online Bus Ticket Booking Project Synopsis

Abstract

This Online Bus Ticket Booking project will provide an Online bus ticket booking platform and thereby leverage the tedious manual ticket booking activity for a customer. We can come up with features like saving favorite routes and providing discounts for the same. We can provide a feature that will allow the customer to get a ticket booked without much hassle.

Existing System:

Initially, customers used to book tickets manually by queuing in lines at bus stations or go to travel agents who in turn used to book tickets for them. This was actually a tedious process and was leading to wastage of time.  It also had issues like having incorrect names or other information used to book tickets.

Proposed System:

We can eliminate the drawbacks by developing an application which will allow customers to register themselves and book tickets, cancel tickets or postpone or prepone travel dates with feasibility. This actually is a welcome step for customers as they can access the application from anywhere and will also avoid wastage of time that was caused due to the drawbacks in the previous way of booking tickets manually.

User Types: Admin, Customer, Employee

Modules: 

Admin
Employees
Route management
Bus management
Bus Staff Management
Customer
Manage bookings
View bookings
Cancellations
Dashboard

Admin:

It will be used by admin to create or manage Bus information and create bus staff information. Link the bus staff to different buses that are managed.

It will also have the option to view all bookings that were done for all buses on a day or month or quarterly basis. View all cancellations and rescheduled bookings. Will be able to confirm reschedule bookings. Will be able to handle transactions related to cancellations.

It will have the option to confirm rescheduled bookings and confirm the same to the customer.

The dashboard of admin will basically have a view which will show no of buses running, no of bookings on a specific day, no of cancellations on a day, no of hits to the site.

It will have the option to review and approve employee logins.

It will have the option to add routes for which buses will be linked.

Employees:

The staff of website can register themselves and send an approval request to admin. Admin will assign a role and approve the login. Once logged in they can view the no of bookings on a specific day, no of cancellations on a day and rescheduled booking requests. They will be able to update and confirm rescheduled bookings, also take care of canceled bookings and its transactions.

Route management:

This module will be accessible to admin and employee both. Information related to all roots will be added in this module. Information like From Where to Where, the distance between two locations, stoppages in a route etc. Depending Upon the distance saved bus travel time will be calculated.

Bus management:

Will have options to add all information related to buses that are plying and then link it to different routes. Bus features like AC/ Non A/c, Two by Two or Sleeper or Pushback etc will all be added in this module.

Bus Staff management:

It will be accessible to employees and admin both. It will allow saving info related to a bus like a bus driver, cleaner, and attendant. Details, like name, phone no, email id, home address, alternate address, an alternate contact number will all be saved for each and every staff.

Customer: This will allow a customer to search for buses on any route with date search criteria. Bus listings will be shown as per search criteria and will also show information related to features of the bus that are playing the specified route. Book option will be provided to confirm booking. No of passengers has to be provided and then booking can be confirmed.  A customer will also have Manage bookings module which will show the history of all bookings that were done till date. The customer can reschedule a booking or cancel a booking from Manage bookings module as two options will be provided for the same.  Dashboard for a customer will show most recent bookings and depart time and date initially in a grid format.

Future Enhancements:

We can provide SMS based alerts and email notifications for bookings.

WThe wallet can be developed to handle discounts on the points basis. It can also be used to provide referral code concept for referring friends.

Chat feature can be included in the application to chat with customer care.

We can come with a feature that will allow the customer to save favourite routes and provide discounts for same.

Introduce coupon management for providing coupons which customers can use to avail discounts.

System Requirement Specification: 

Hardware Requirements:
Intel Core processor
RAM 4GB and Above
HDD 100 GB Hard Disk Space and Above
64 or 32 bit OS Windows 8 and above

Software Requirements:

Technology: HTML,CSS, Jquery, PHP

Back End: SQLServer or Mysql

Operating System: Windows7 and more

Frame Work: Larvel or Phalcon 

Or it can also be done in .Net

OPERATING PLATFORM: WINDOWS 7 or later

Database:           SQLSERVER 2008 or  more

IDE & Tools:           VStudio.Net 2010 or more

Web Server:           IIS 6.0

Web Technologies:           Asp. Net, C#, Javascript, HTML, CSS