Complaints Resolver Application

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 done 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:

Front End: ASP.NET

Back End: SQL Server

Time Sheet Management System

Abstract:

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 Name 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)
Alt Email 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 Varchar(50)
Analysis Requirement Varchar(50)
Preparing Functional Design Document Varchar(50)
Preparing High Level Design Varchar(50)
 Preparing  Low Level Design Varchar(50)
   Writing Code Varchar(50)
  Preparing Tcehnical Design Document Varchar(50)
Analysis & Fixing Bug Varchar(50)
Unit Testing Varchar(50)
System Testing Varchar(50)
 Integrity Testing Varchar(50)
Preparing Test cases Varchar(50)
Totaltime Varchar(50)
Status Varchar(50)
Column Name Data Type
Allocated Id Int
Allocated By Varchar(50)
Project Id Varchar(50)
Project Name Varchar(50)
Allocated To Varchar(50)
Status Varchar(50)
Column Name Data Type
Uniq Id Int
Project Id Varchar(50)
Emp Id Varchar(50)
Total Work Hrs Varchar(50)
Payment Varchar(50)

Front End: ASP.NET

Back End: SQL Server

Web based Rental Application

Abstract:

The online rental application is a web-based application in which both the customers and vendors are logged into the application and view the showcased products and purchase them. Admin will login into the application after logging he can view the new inquiries and the feedback received from the customers. admin can also recover the password if he forgets by providing keyword. The user will register into the application by giving all details and provide the card details for payments. After logging, he can add the products that he wishes to advertise. After posting he can view all the products and if any products he wants to delete he can delete.

In this rental application, we are having 2 Modules

  1. Admin
  2. Customer

Modules Description: 

Admin:

Admin will login into the application using the default username and password after logging he can view the inquiries and feedbacks from the customers.

Customer:

Customer will register into the application by providing all the necessary details after successful completion of registration customer will log in and advertise the products that he wants to keep them for rent. He can also view all the products that he added.

Existing System:

In Existing System, the user cannot do this process from one location to another location means if a customer is shifting to a new place and he want to take a bike for rent before he reaches there so that cannot be done in the existing system.

Proposed System:

In Proposed System, the application is independent of location means from any location you can access this application and complete your procedure by just registering and logging.

Front End: ASP.NET

Back End: SQL Server

Sales Management Portal

Definition:

The Sales Management System should have, but not limited to, the features and functionalities as below

1)  Search: allows users to staff find clients by names, either on the complete or partial match.

2)  A filter for browsing: can shorten the list and separate prospects from current clients.

3)  A sign-in form

4)  Manager Console: Managers can create user accounts, view, and update entries, leave comments on entries, and send messages to staff, etc.

5)  Pipeline Reports: Managers should also be able to run various reports such as lists of prospects, reports of opportunities or proposals by dates, sales projections by month or by the salesperson, project tracking, etc.

Features described in this document may require, but not limited to, the following advanced technical knowledge and skills for:

  • HTML programming and CSS styling
  • Responsive design
  • The user authenticates and authorization
  • SQL database and programming
  • Site navigation
  • Application of state and cookies
  • Validation controls
  • API and Web service programming
  • Test and debug

Students should study and try to incorporate as many features and functionalities as possible in their projects

Portal Homepage

Main page after user logged-in

  • Announcements section displays manager’s messages in the order of dates.
  • Left-hand side panel displays a list of all clients in alphabetical order.
  • Users can search clients by names, also can filter the list by types, client or prospect.
  • The new prospect can be added by clicking Add Client.

Illustration of a pipeline for a client

After staff selects a client from the main client list, the page shows a sales pipeline for the selected client: General Info, Contacts, Notes, Opportunities, Proposals, and Projects.

The illustration shows the Contacts page

Database Design

Below are some essential information used in a real-world sales pipeline. It is recommended to incorporate them in your database design.

Pipeline: Opportunities

  • Opportunities Name
  • Added by
  • Date Added
  • Chance to close (percentage)
  • Estimated Budget
  • Opportunity Duration
  • Opportunity Type (a list of major products and services )
  • Contact Name
  • Contact Telephone
  • Opportunity Description
  • Opportunity Notes

Pipeline: Proposals

  • Proposal Name
  • Account Manager
  • Date Added
  • Chance to Close (percentage)
  • Estimated Budget
  • Proposal Duration
  • Proposal Amount
  • Total Revenue
  • Proposal Status (a project is automatically created when proposal status is set to accept )
  • Rejection Reason
  • Contact Name
  • Contact Telephone
  • Description
  • Proposal Notes

Pipeline: Projects

  • Project Name
  • Project Manager
  • Date Added
  • Project Amount
  • Total Revenue
  • Project Duration
  • Project Status
  • Launch Date
  • Contact Name
  • Contact Telephone
  • Project Description
  • Project Notes

Front End: ASP.NET

Back End: SQL Server

Simple Intra Network Sniffer

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

Front End: ASP.NET

Back End: MS SQL

Online Test Management Application

Definition:

Online test application will provide an Online platform wherein students will attend online objective questions. Grades will be provided as per the number of questions that were answered correctly. This concept will use an admin panel as the backend for loading the questions and also identify whether the student has selected a correct answer or not. Questions will be segregated on the basis of different subjects.

The option will be there to add subjects also. Admin panel will be saving the data and communicating with DB via web service or API.  It will have a flow wherein a subject will be selected and that will load respective questions. Once all questions are answered result will be published there and then.

A student can see grades as per the number of questions that were answered correctly or will calculate the marks for all correct answers and show percentage of marks.

The whole process of conducting the test and checking them and then grading them was a tedious manual process and time consuming too. This whole process can be avoided by adapting to a new online text conducting application that will allow  a easy to approach UI wherein students can save their answers and also being graded much faster and their by publish results soon.

This software will also be secured as it will provide code match system which admin will provide to the student which each of them has to enter to start the exam. Student will also register themselves to appear to this exam. After successful registration admin will approve the registration and then the student will login to the online application system. We can also implement time constraint check for the completion of the exam after which student cannot attempt any question.

User Types: Admin and Student

Modules:

Admin:

  • Subject: Will have the option to add subjects for which questions will be uploaded.
  • Questions: This module will select a subject and then add questions to it along with correct answers for the same. This actually helps in checking whether student gave the correct answer or not. This part is basically admin panel which manages the question and answer that are save in DB and then provide instant results too.
  • Student: Admin will approve student registration for attending test online. Will also post results for different subjects for which student has appeared.
  • Grades: Admin will define grades as per percentage of correct answers given by the student. All those calculation are taken care in this module.

Student:

  • Exam: Once logged in a student will have set of questions which will be objective and he or she has to select the correct answer. It  will be a UI with question set being loaded on the basis of the subject selected.
  • View Result: This module will be a UI where in result will be shown in a grid grouping them subject wise. Grade and percentage of marks will also be shown for the student who has appeared for the exam.

Contact Us: Will show info related to contact numbers and also search filters.

Future Enhancements:

  • We can provide email notifications and SMS integration. This will require web service or API integration with SMS providers and SMTP configuration to handle emails. It will notify students once results are posted by admin.
  • Add Blogs that can be posted by students.
  • We can plan a social platform in the same application where in students can chat with other registered students. Can also like comment and share posts from other students. Admin can also post info and students can access it. Post pics and share them too in groups created by students.

Software Requirements:

Technical Aspects:
Database: Sql Server 2008  and more
Language: C# and Asp
Framework: .Net
Front end: HTML, CSS, Javascript

It can also be done in Php, MySql as the back end with other frameworks

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.

Front End: ASP.NET

Back End: My SQL

 

Query Redressal System

Definition:

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

Front End: ASP.NET

Back End: MS-Sql

Road Transport Authority RTA Information System

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 Dictionary

  • Table Name: Challan 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.

Front End: ASP.NET

Back End: SQL Server

Online Resume Management

Definition:

Online resume management will basically provide an online platform that will provide an option to upload a resume and then search for jobs relevant to the skill set. It will have admin panel which will allow admin to manage different features. It will maintain information related to users who will register and apply for jobs as per skills. This application will provide an option to apply for different Functions or Verticals and allow users to apply for different skills as per choice.

User Types: Admin, Users

Modules:

Admin Module:

It will be accessible to Admin and he or she can add or manage Filters, Employers of Choice, and Job Openings.
→ Job Openings will have the option to add info related to Job title, Company name, Skills, Location, Experience, Posted On, Company Logo, HR Name, Contact no
→ Filters will have options to add different values to filters, like Bangalore / Hyderabad etc in Location. The grid will be provided with different Filter Names and will have the option to add/ Edit option to add Filter values. The option will also be there to add Filter heads.
→ Employers of choice will have the option to add a company logo. Description / About US, Jobs of that company. Admin can add as many Employers of choice and they will be added to the dashboard.

Home Dashboard:

This is basically the dashboard for all users (registered or unregistered). It will show different options like Search filters, Employers of Choice, Login / Register, Upload resume, Job Openings etc. Employers of choice will be added by admin. Job openings info will be added by admin.
Search: This module will provide filters that will allow searches for different conditions. Filters related to Skills, Function, Industry, Location, startups etc will be provided. This module will be accessible to both admin and user. Admin will manage filter updates, like adding and removing different filter values. Users will able to see these filters managed by admin in the home dashboard.

Registration Module:

It will have a complete and comprehensive form which will lot of options to be selected and save relevant information. It will have options to save First name, Last name, Middle name, Password, Re-Confirm password, Current Location, Total Exp, Industry, Function, Key Skills etc for submitting initial registration information.

Notifications:

This module will show notifications whenever admin adds new Job Openings or add Employers of choice.

Contact Us:

Will show info related to contact numbers and also search filters.

Future Enhancements:

→ We can provide email notifications and SMS integration. This will require web service or API integration with SMS providers and SMTP configuration to handle emails.

→ Provide package plans for users with related services.
 Add Blogs that can be posted by users.

Software Requirements:

Technical Aspects:

Database: SQL Server 2008 and more

Language: C# and Asp

Framework: .Net

Front-end: HTML, CSS, JavaScript

It can also be done in Php, MySql as back end with other frameworks

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

Front End: ASP.NET

Back End: MySql

Paint Editor Application

Definition:

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.

Front End: ASP.NET

Back End: Paint Editor