INTRODUCTION

GENERAL: Office correspondence and auto questionnaire java based project are developed as per the requirements of the mechanical department.

OFFICE CORRESPONDENCE

Mechanical department deals with the different type of letters. The letters which are received by the mechanical department are incoming letters and the letters which are sending through the department are the outgoing letters.

The different types of letters received and sent by the mechanical department are as follows:

• Local letters
• Headquarters letters
• Others

LOCAL LETTERS

The letters received from and send to other departments of Vijayawada division are termed as local letters.

INCOMING LOCAL LETTERS

The letters received from other departments of Vijayawada division are termed as incoming local letters.

OUTGOING LOCAL LETTERS

The letters sent to other departments of Vijayawada division are termed as outgoing local letters.

HEADQUARTER LETTERS

Secundrabad division is headquarters of the Vijayawada division. So the letters received from and send to Secunderabad division are termed as headquarters letters.

INCOMING HEAD QUARTER LETTERS

The letters received from Secunderabad division are termed as incoming head quarter Letter.

OUTGOING HEAD QUARTER LETTERS

The letters sent to Secunderabad division are termed as outgoing headquarters Letters.

OTHERS

The letters received from and send to the divisions other than Vijayawada and Secunderabad are termed as other letters.

INCOMING OTHER LETTERS

The letters received from the divisions other than Vijayawada and Secunderabad are termed as incoming other letters.

OUTGOING OTHER LETTERS

The letters sent to the divisions other than Vijayawada and Secunderabad are termed as outgoing other letters.

If the reply for the above letters is to be given immediately then those letters are marked as demi official letters.

So different types of demi official letters can be

• Incoming Local demi official letter
• Outgoing Local demi official letter
• Incoming Head quarters demi official letters
• Outgoing Head quarters demi official letters
• Incoming Other demi official letters
• Outgoing Other demi official letters

All the incoming letters are received by the chief office superintendent and are marked to different sections of the mechanical department with the authorized signature of the senior divisional mechanical engineer. Then the respective task is performed by section accordingly to the letter which is received by it and sends the reply to the chief office superintendent. Then the chief office superintendent with authorized signature of the senior divisional mechanical engineer sends the letter as an outgoing letter.

The mechanical department consists of seven sections.

• Contract/tenders
• Carriage & wagon staff
• General/pass
• Rolling stock
• Stores
• Budget
• Power

AUTO QUESTIONNAIRE

The test to avail the promotion is conducted for the employees of the Vijayawada division. The question bank offered to the employees for preparation comprises of the following type of questions.

• Long answers
• Short answers
• Fill in the blanks
• Multiple choices
• Expansions

STATEMENT OF THE PROBLEM 

OFFICE CORRESPONDENCE

To maintain the details of different types of letters, to show the status of the letter and also to generate the reports. 

AUTO QUESTIONNAIRE

To maintain the questions and to generate the questions randomly when appropriate type of question is selected.

EXISTING SYSTEM

OFFICE CORRESPONDENCE

In the existing system, the details of the letter are being maintained manually by entering different types of letters in different books. To know the present status of the letter, it is very difficult in the existing system because one has to verify all the entries in that particular book. So it is time-consuming. 

AUTO QUESTIONNAIRE

In the existing system, question paper is set manually by selecting the type of questions from the printed question bank. It is very difficult and time-consuming to set question paper manually because when selecting a question one has to verify whether it was previously given or not.  One has totally the maximum marks for which paper was given and marks allotted for each question and he should also consider the choices for each type of question.

PROPOSED SYSTEM 

OFFICE CORRESPONDENCE

The proposed System is a web-based application. It maintains details of all the letters within the mechanical department. The present system shows the pending letters and reports. 

AUTO QUESTIONNAIRE

In the proposed system the question paper is set automatically by selecting random questions when an appropriate number of question type is selected.

OBJECTIVES OF STUDY 

OFFICE CORRESPONDENCE

• Automating the manual work.
• To generate the status of the letter
• reminder  provision for pending letters

AUTO QUESTIONNAIRE

• To generate the question paper quickly from the available database.         

REQUIREMENT ANALYSIS   

FUNCTIONAL REQUIREMENTS

OFFICE CORRESPONDENCE

• The user can add the details of all the letters into the database and view the pending letters.
• The authorized user can edit the details of the letters and delete the letters from the database.

AUTO QUESTIONNAIRE

• The authorized person can add, delete and update the questions in the database.

SYSTEM DESIGN SPECIFICATION 

SOFTWARE REQUIREMENTS

Operating system: Windows XP professional

Programming Language: JAVA

Web Technology : J2EE (JDBC, Servlets, JSP, HTML)

Browser: Internet Explorer

Web application server: Apache Tomcat

Model Design: Rational rose

IDE: Net Beans 6.7.1

Data Base: Oracle 10g, MS Access. 

HARDWARE REQUIREMENTS

Processor: Intel p4

RAM: 256MB RAM

Hard disk: 20GB or more

Required Software’s:

• Oracle 9i
• Java
• Netbeans 6.7.1
• Mozilla Firefox

Instructions to Deploy:

1. Install the required software’s
2. Open Netbeans and open the project from source code
3. Configure database connections from DBConn package of Source Packages under the root PPO & Technical
4. Right click on CreateTab.java under Test Packages under the root PPO & Technical and click on run
5. Right click on root and click on run

Note: In case of reference problems right click on root and click on resolve reference problems, and select the library files.

Output Screens:

• Homepage in office correspondence
• Selection of letter type in office correspondence
• Reports generation using a serial number in office correspondence
• Report generation using by date in office correspondence
• Report generation using between dates in office correspondence
• Report generation using marked in office correspondence
• Report generation using received from in office correspondence
• Report generation using send to in office correspondence
• Report generation using general in office correspondence
• Report generation using remainders in office correspondence
• Pending letters in office correspondence
• Editing of the letter in office correspondence
• Login page for deleting the letter in office correspondence
• Letter deleted successfully in office correspondence
• Login page in the auto questionnaire
• Operations on question bank in the auto questionnaire
• View of multiple choice questions in the database
• Default question paper in the auto questionnaire
• Question generator in the auto questionnaire
• window to open or cancel generated question paper in the auto questionnaire
• Generated question paper opened in MS word in the auto questionnaire

CONCLUSION 

The primary goal of this project is to reduce the work which is being done manually. By maintaining the details of all the letters in the database we view the letters based on different fields such as serial number, marked to, date and so on. The letters which are pending can be viewed easily and the remainder is generated. Editing and deleting the details of letters is also possible.

The question paper is being generated by selecting the questions randomly from the database. We need to mention the maximum marks and the type of question. Creation of our own template is also possible. This system is very user-friendly.

SCOPE 

The application i.e., office correspondence which we developed is a standalone one i.e., within the department we can use. The letters are received in paper format and then they are saving them in the database. Due to this time gets wasted. If we develop a web-based application the letters received by the department are sent through emails then a lot of time gets saved.

Download Office Correspondence and Auto Questionnaire Java Project Code

The manual procedure for interaction between the PPO users and the other users in ELS (Electric Loco Shed) is prone to certain limitations.  The existing system has been facing certain limitations like communication gap between various departments of ELS and maintaining the details manually which is a time-consuming process. So, it is becoming very difficult to maintain the Loco information, its Schedule, its Failures and the time to time communications between the departments.

To Overcome these drawbacks The Proposed system is an enhancement to the existing system covering some of its limitations by automating the process. The PPO which maintains the information of the Locos, Schedules the Locos, Assigns the work to different departments, Finds the repairs and all other work is computerized. This general introduction includes the scope of the system.

SCOPE OF SYSTEM

• View all the details regarding the Locos.
• Maintain all the details regarding locos like a loco number, loco schedule.
• Maintain the Loco failure details.
• Activities like the update, deletions, and creations done in the system by the developer in future.

PURPOSE OF THE SYSTEM

The main aim of the Planning & Technical Management System project is to reduce the paperwork and duration of work process and to maintain the data of Electric Loco Shed efficiently the maintenance of all details is undergoing manually in the existing system. So it is becoming very difficult for the communication between the various departments of ELS and also to maintain & refer to the Loco information.

To overcome these drawbacks, computerizing the details of the Locos related to a particular Electric Loco Shed is needed. So this system is built to access the information of the loco in an easier way. The system also provides information regarding the staff attendance so that the top management can have an easy way to handle the staff members’ regularity.

EXISTING SYSTEM

The existing system is entirely being operated manually. All the registers are being maintained in hardcopy files, which is quite difficult to maintain and harder to access. It is very much time consuming and requires a lot of requisites for the information to be passed from one department to another department. And in case of replacements, if spares are not readily available, tenders are being issued so as to opt for the best quote that is obtained which is more cost efficient. Also, there is a possibility of encountering errors due to the human intervention.

PROPOSED SYSTEM

The proposed system is the computerized version of the existing system wherein all the files are digitized and stored in a database which can be accessed by only privileged users. Information regarding any worker or a loco can be instantly known at any time. Our proposed system also enhances security by maintaining the digital signatures of workers who work on a particular loco for future reference. The communication between the users of different departments is made very easier in the system.

OBJECTIVES OF STUDY

• Maintaining digitized data for easier access.
• Remote access to data for all the departments of ELS.
• User-friendly environment to get the required information. 

REQUIREMENT ANALYSIS 

FUNCTIONAL REQUIREMENTS

This section describes the functional requirements of the system for those requirements which are expressed in the natural language style. They are as follows:

• Automate tedious manual work.
• Automatic alert provision for task completion on locos.
• They should be able to view the required reports related to locos.

NON-FUNCTIONAL REQUIREMENTS

• Performance: The completely separate business logic at the server side from the user interface ensures good performance.
• Interface: the User interface is web browser based. The client-side user interface is developed using HTML and JSP.
• Usability: This section includes all of those requirements that affect usability. It will be very easy to use for the naïve user.
• Supportability: Choosing Java platform makes this system cross-platform independent.
• Reliability: The system is more reliable as it inherits the Java platform qualities.

SYSTEM REQUIREMENTS AND SPECIFICATIONS 

SOFTWARE REQUIREMENTS

Operating System: Windows XP Professional

Programming Language: JAVA

Web Technology: J2EE (JDBC, JavaScript, JSP, HTML)

Browser: Mozilla Firefox

Web application server: Apache Tomcat 6.0

Model Design: Rational Rose

Data Base: Oracle 9i

IDE: NetBeans 6.7.1 

HARDWARE REQUIREMENTS

Processor: Intel P4/AMD Athlon

RAM: 256MB RAM

Hard Disk: 20GB or more

Output Screens of the project:

1 The home page of Planning & Technical Management System
2 Login page for all departments
3 Daily Schedule Page
4 Loco Schedule Update Page
5 Loco Important Parts Update Page
6 View Loco History Page
7 PPO department Work Allotment Page
8 PPO Department Work Description Page
9 General Work Allotment View Page
10 Sectional Work Allotments Page
11 Sectional View Work Page
12 Staff Description Page
13 Attendance Report Type Selection Page
14 Daily Attendance Report of the whole Department
15 Monthly Attendance Report of the whole Department
16 Daily Attendance of Individual Staff Member
17 Monthly Attendance Report of Individual Staff Member
18 Yearly Report of Individual Staff Member

Conclusion:

The primary goal of this project is to computerize the entire process being done in the Electric Loco Shed (ELS/BZA) and provide instant access to the work that is being carried out in various departments to the authorities. It further aims at providing a digital database of all the records that are currently being stored in hard copies. This is all done with user-friendly GUI and easy to understand functionalities.

The project has been successfully completed by including all the specified features. Our project team members worked hard with the help of our guide to develop the system in such a way that we can retrieve information in all dimensions.  We can confirm that the entire project has been completed as per the stated requirements.

Download Planning & Technical Management System Java Project Source Code and Database.

Though, all the user requirement have been meet , the road does not end here. Future development can be undertaken to enhance the functionality and to increase the efficiency of the “Traction Loco Control ”

The fact that this system is going to evolve everyday in the upcoming month. The team can’t just sit back new technologies package has to be incorporated in the system to make it fully secure and full proof. Also additional care has to be take to maintain the database which is going to increase and migrate it to other platform which can handle excessive load.

Coding:

[php]

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

class help implements ActionListener

{

private JDialog dialog = new JDialog((Frame)null, "Help", true);

JLabel l1=new JLabel("COACH MAINTANANCE SYSTEM");

JLabel l2=new JLabel("Please Contact :- Sujeet Kumar Singh");

JLabel l3=new JLabel("Address             :-  C/O-R.C.Matho,Veer Sivajee path");

JLabel l4=new JLabel("North S.k.puri,dist-Patna");

JLabel l5=new JLabel("Bihar,   pin-800013");

JLabel l6=new JLabel("Contact no        :- 9308105802");

JLabel l7=new JLabel("Special Thanks For Mr. Rajesh Kumar");

JLabel l8=new JLabel("And Logic Solution");

JLabel image=new JLabel(new ImageIcon("logo2.gif"));

JButton b1=new JButton("Ok");

JPanel p=new JPanel();

help()

{

Container Pane=dialog.getContentPane();

dialog.setBounds(200,200,500,400);

p.setLayout(null);

l1.setBounds(50,30,475,30);

l1.setFont(new Font("",Font.BOLD,22));

l2.setBounds(100,75,300,30);

l2.setFont(new Font("",Font.BOLD,16));

l3.setBounds(100,100,400,30);

l3.setFont(new Font("",Font.BOLD,16));

l4.setBounds(230,125,300,30);

l4.setFont(new Font("",Font.BOLD,16));

l5.setBounds(230,150,300,30);

l5.setFont(new Font("",Font.BOLD,16));

l6.setBounds(100,180,300,30);

l6.setFont(new Font("",Font.BOLD,16));

l7.setBounds(95,275,400,25);

l7.setFont(new Font("",Font.BOLD,16));

l8.setBounds(175,300,400,25);

l8.setFont(new Font("",Font.BOLD,16));

image.setBounds(200,225,100,50);

b1.setBounds(210,325,80,30);

p.add(l1);p.add(l2);p.add(l3);p.add(l4);p.add(l5);

p.add(l6);p.add(l7);p.add(image);p.add(l8);p.add(b1);

b1.addActionListener(this);

Pane.add(p,"Center");

dialog.setVisible(true);

}

public void actionPerformed(ActionEvent e)

{

if(e.getSource()==b1)dialog.setVisible(false);

}

public static void main(String sr[])

{

new help();

}

}

[/php]

Future Application

This Project can be easily updated according to the needs of Mechanical Department of any railway zone.  This is made in such a way that it can be easily modified in a more advanced form if there will be such need.  The database of this software maintains the records of the details of Coaches who have been attached to the rake and the details of maintenance schedule of the coach.  These records will have a lot of use in future related to any enquiry.

This database can seamlessly be used by other candidate systems to be developed in future. It can be further developed as a net-centric database. The transactions are also revealed in this project.  Any financial enquiry can be satisfied easily through this software.  Hence, this project covers all-important details regarding the “Number Allocation System for Coach” of the Railway Zone. Therefore in future it will help to provide some important information’s, which may help in development of the company.

The main scopes and future enhancements are as follows–

• Proposed system can be delivered on a 3-tier architecture so as to improve scalability and performance
• Browser Enabled User Interface for distributed Application
• Arrangement for automatic back up and replication of database.
• Enhanced security features like e-signature and public key encryption technology features for secure transfer of confidential data
• On-Line help feature for “Expert Advice and Error Shooting”.

INTRODUCTION OF THE PROJECT 

Indian Railway is lifeline of India.. Ever Since the evolution of human being on this earth it has been a matter of immense curiosity for them to invent new things in life to make life easier and hassle free. Owing to its nature humans have always kept inventing and discovering for better livelihood. Going back to our past we see some Great inventions of mankind and one such is that of Railway.

The noval plan for the introduction of Indian rail system, Transformed whole history of INDIAN RAILWAY. The innoavative plan was first propsed in 1832, however auxiliary actions were taken for over a decade. In the year 1844, private enterpreneurs were allowed to launch a rail system by lord Hardinge, who was the Governer-Genral of India. By the year 1845, two companies were formed and east India Company was requested to support them in the matter.

  INDIAN RAILWAY have been divide into nine (9) zones- Western, Central, Northan, North Eastern, Northeast, Frontier, Southern, South Central, South-central & South-eastern covering the largest route length of cover 63000 kms of total Indian boundary. The last stations of the four directional boundaries are West-Mumbai South-Kanyakumari, East-Guwahati, and North-Jammu.

There are five types of trains which are running in the Indian Railways that are given below:

  1. Passenger train

                     2. Mail/Express

                     3. Shatabadi train

                     4. Jan-Shatabdi

                     5. Rajdhani

The Shatabdi train is the fastest among all these trains and covering only some of the destination. In the Indian Railway Coach Maintenance Department is the most important. There are many work handles in POH SHOP, these are given below:

• Carraige Poh Shop
• Wagon Poh Shop
• Diesel Poh Shop
• Production Poh Shop
• Electric Rolling Poh Shop
• Electric Shop

There are many production-units from where the coaches are newly manufactured that are:

• Chittaranjan Locomotive Works
• Diesel Locomotive Works, Varanasi
• Integral Coach  Factory, Perambur
• Rail Coach Factory, Kapurthala
• Wheel & Axle Plant, Bangalore
• Diesel Component Works, Patiala
• The research Design and Standard Organization, Lucknow, provides vital inputs in R&D towards modernization.
• 6 prestigious public sector undertaking : IRCON, RITES, CRIS, CONCOR, IRFC and Konkan Railway corporation. 

When, the coach is prepared in the POH SHOP. The train go to the yard. A Railway yard is an area having a network of railway tracks and siding for Storage and maintenance of cars and engineers. In the marshalling yard of Indian railway in which trains are assembled and good are loaded. In the marshalling yard railway wagons are Shunted and made up into trains.

In the yard, the  coaches are maintained in 3-schedules namely:-

1.A-Schedule

2.B-Schedule and

3.C-Schedule

1. A-Schedule:- A Schedule is primary schedule. This schedule is done every month for any coach.
2. B-Schedule:- This schedule is done in any coach after 3-month in the yard.
3. C-Schedule:- This schedule is done in any coach after 6-month in the yard.

IOH means intermediate over holding. In this shop the coaches are maintained any time when necessary.

Apart from these register the organization has to publish reports about the coaches to supervisior.

Seceondary Detachment

Some times during running of the train some faults occur in a coach or number of coaches or entire rake. Then coaches are detached from that rake and sent for maintenance. This is called secondary detachment of coach.

My Job is to convert these entire manual jobs to a computerized system. My project work is the outcome as solution to the aforementioned manual jobs. This project is being done under DRM Office, Danapur (ECR).