ISSUE Tracking Document
ISSUE Tracking Document
ISSUE Tracking Document
(2015-2018)
Submitted by
S.AISHWARYA
15BCA02
( Re-accredited (2nd cycle) by NAAC with Grade “A” CGPA-3.46 on a 4-points scale )
Madurai – 625002.
ISSUE TRACKING SYSTEM
( Re-accredited (2nd cycle) by NAAC with Grade “A” CGPA-3.46 on a 4-points scale )
Madurai – 625002.
CERTIFICATE
This is to certify that this Project titled ISSUE TRACKING SYSTEM work done by
S.AISHWARYA(15BCA02) in Partial Fulfillment for the award of the degree of Bachelor of
Computer Application of The American College for the Academic Year 2015-2018.
DECLARATION
I here by declare that this project was carried out by me under the guidance of
MR.M.MARTIN PORUS,M.SC.,PGDCA., Department of Computer Application, The
American College, Madurai.
I also declare that this project report is the result of my own effort and that it has not been
copied from any one and has not been submitted by anybody in anywhere.
Date: 15bca02
ISSUE TRACKING SYSTEM
ACKNOWLEDGEMENT
Also I would like to thank my Teachers, Friends and my well wishers who have helped me
during the course of completion of this project.
ISSUE TRACKING SYSTEM
INTRODUCTION
ISSUE TRACKING SYSTEM
1.INTRODUCTION
1.1 ABSTRACT:
The main aim of the project is to decrease the time cost in manual work, text
classification techniques are applied to conduct automatic bug triage. Issues handled by
the programmer are tracked in the project. In this project a manager view all bug history
and status details. In main page they view bug summary. In each bug they view the
detailed history of the bug. In these bug data sets they made a report about a bug triage.
Report clearly shows that how many bugs are raised, in this how many bugs are
assigned and fixed. The report is view in a chart format.
ISSUE TRACKING SYSTEM
SYSTEM ANALYSIS
ISSUE TRACKING SYSTEM
2.SYSTEM ANALYSIS
2.1Existing system:
Modeling Bug Data to investigate the relationships in bug data, form a bug report
network to examine the dependency among bug reports. This developer social network is
helpful to understand the developer community and the project evolution. By mapping bug
priorities to developers, identify the developer prioritization in open source bug repositories.
The developer prioritization can distinguish developers and assist tasks in software
maintenance. Bug triage aims to assign an appropriate developer to fix a new bug
The problem of automatic bug triage to reduce the cost of manual bug triage. They
apply text classification techniques to predict related developers. Examine multiple techniques
on bug triage, including data preparation and typical classifiers.
DISADVANTAGES
This main aim is to simultaneously reduce the scales of the bug dimension and the word
dimension and to improve the accuracy of bug triage. We build a binary classifier to predict
the order of applying instance selection and feature selection. Data reduction for bug triage
aims to build a small-scale and high-quality set of bug data by removing bug reports and words,
which are redundant or non-informative. The extension, we add new attributes extracted from
bug data sets, prediction for reduction orders, and experiments on four instance selection
algorithms, four feature selection algorithms, and their combinations. We evaluate the reduced
bug data according to two criteria: the scale of a data set and the accuracy of bug triage.
ADVANDAGES
SYSTEM REQUIREMENT
ISSUE TRACKING SYSTEM
3.SYSTEM REQIUREMENTS
PROJECT DESCRIPTION
ISSUE TRACKING SYSTEM
4.Project Description:
The Project “Issue tracking system” is mainly used to form proper network
among the manager, programmer and tester of the concern. This system easily track bug
information for a particular project. It is very easy and high secure application. Issue Tracking
System is an ideal solution to track the bug information of a project. It allows individual or
groups of developers to keep track of outstanding bugs in their produce effectively.
Project assessment
In this module an authorized manager entered into the system using their
user id and password. They upload project details such as project name software
details, version information and number of modules in this project. They assign
developers and testers for the project. The project manager assigns a tester for
each developer to test a project and send notification to appropriate developer
and tester. They fully control the entire system.
ISSUE TRACKING SYSTEM
Registration
In this module, using a registration module a tester get a login credential
such as user id and password to access the system. After a login process a tester
view their assigned programmer details from project manager notification. In
this module, an authorized developer entered into the system and views their
allotted tester details send by a manager.
Issue raising
In this module the testers test all the project files that send by the developer. A
tester raising a bug such as assigns a new bug to an appropriate developer. Bug
triage aims to assign an appropriate developer to fix a new bug, i.e., to determine
who should fix a bug.
Developer
In this module the developers view all bug notification details that is
assigned to them and bug report information. They respond to a bug
notification and fixing the bug. They send a bug fixing details and
clarification details also to a tester.
In this module a project manager view all bug history and status details.In main
page they view bug summary.In each bug they view the detailed history of the bug. In these
ISSUE TRACKING SYSTEM
bug data sets they made a report about bug triage.Report clearly shows that how many bugs
are assignd and fixed.The report is view in a chart format.
ISSUE TRACKING SYSTEM
SYSTEM DESIGN
ISSUE TRACKING SYSTEM
5.SYSTEM DESIGN
Leve l. 0 :
Manager
Tester
Programmer
Database
ISSUE TRACKING SYSTEM
level 1:
Project
detail
Manager
Job
assign
User id
Password
Track bug View bug Database
history info
Authenticatio
n
Report Data reduction
generation
Bug
approved
Bug
Programmer assign Tester
Bug
fixing
Bug
suggestion
ISSUE TRACKING SYSTEM
5.2Database design:
Projectmanager
Username Varchar(60)
password Varchar(60)
Programmerinfo
Pgid Int
pgname Varchar(60)
designation Varchar(60)
experience Varchar(60)
mailid Varchar(80)
password Varchar(60)
Testerinfo
Tsid Int
tsname Varchar(60)
designation Varchar(60)
experience int
mailid Varchar(80)
ISSUE TRACKING SYSTEM
password Varchar(60)
Projectinfo
Pid Int
pname Varchar(60)
software Varchar(60)
frontend Varchar(60)
backend Varchar(50)
version Varchar(60)
modulesnum int
Protesallocation
Pid Int
pname Varchar(60)
pgid Int
tsid Int
ISSUE TRACKING SYSTEM
pgname Varchar(80)
tsname Varchar(70)
Buginfo
Bid Int
bugname Varchar(60)
pid Int
pname Varchar(60)
pgid Int
tsid Int
reason Varchar(50)
status Varchar(50)
bugtype Varchar(100)
priority Varchar(50)
assigndate Datetime
ISSUE TRACKING SYSTEM
Bughistory
Queryid Int
bid Int
pgid Int
tsid Int
reason Varchar(45)
correction Varchar(55)
files Varchar(200)
taskdate Datetime
bugstatus Varchar(50)
ISSUE TRACKING SYSTEM
LANGUAGE
DESCRIPTION
ISSUE TRACKING SYSTEM
6. LANGUAGE DESCRIPTION:
“.NET” is also the collective name given to various software components built upon the
.NET platform. These will be both products (Visual Studio.NET and Windows.NET Server,
for instance) and services (like Passport, .NET My Services, and so on).
The CLR is described as the “execution engine” of .NET. It provides the environment within
which programs run. The most important features are
Managed Code
The code that targets .NET, and which contains certain extra
Information - “metadata” - to describe itself. Whilst both managed and unmanaged code can
run in the runtime, only managed code contains the information that allows the CLR to
guarantee, for instance, safe execution and interoperability.
Managed Data
With Managed Code comes Managed Data. CLR provides memory allocation
and Deal location facilities, and garbage collection. Some .NET languages use Managed Data
by default, such as C#, Visual Basic.NET and JScript.NET, whereas others, namely C++, do
not. Targeting CLR can, depending on the language you’re using, impose certain constraints
on the features available. As with managed and unmanaged code, one can have both managed
and unmanaged data in .NET applications - data that doesn’t get garbage collected but instead
is looked after by unmanaged code.
The CLR uses something called the Common Type System (CTS) to strictly enforce
type-safety. This ensures that all classes are compatible with each other, by describing types in
a common way. CTS define how types work within the runtime, which enables types in one
language to interoperate with types in another language, including cross-language exception
handling. As well as ensuring that types are only used in appropriate ways, the runtime also
ensures that code doesn’t attempt to access memory that hasn’t been allocated to it.
ISSUE TRACKING SYSTEM
The CLR provides built-in support for language interoperability. To ensure that you
can develop managed code that can be fully used by developers using any programming
language, a set of language features and rules for using them called the Common Language
Specification (CLS) has been defined. Components that follow these rules and expose only
CLS features are considered CLS-compliant.
The set of classes is pretty comprehensive, providing collections, file, screen, and
network I/O, threading, and so on, as well as XML and database connectivity.
The class library is subdivided into a number of sets (or namespaces), each
providing distinct areas of functionality, with dependencies between the namespaces kept to
a minimum.
The multi-language capability of the .NET Framework and Visual Studio .NET enables
developers to use their existing programming skills to build all types of applications and XML
Web services. The .NET framework supports new versions of Microsoft’s old favourites Visual
Basic and C++ (as VB.NET and Managed C++), but there are also a number of new additions
to the family.
ISSUE TRACKING SYSTEM
Visual Basic .NET has been updated to include many new and improved
language features that make it a powerful object-oriented programming language. These
features include inheritance, interfaces, and overloading, among others. Visual Basic also now
supports structured exception handling, custom attributes and also supports multi-threading.
Visual Basic .NET is also CLS compliant, which means that any CLS-compliant
language can use the classes, objects, and components you create in Visual Basic .NET.
Managed Extensions for C++ and attributed programming are just some of the
enhancements made to the C++ language. Managed Extensions simplify the task of migrating
existing C++ applications to the new .NET Framework.
Active State has created Visual Perl and Visual Python, which enable .NET-
aware applications to be built in either Perl or Python. Both products can be integrated into the
Visual Studio .NET environment. Visual Perl includes support for Active State’s Perl Dev Kit.
FORTRAN
COBOL
Eiffel
ISSUE TRACKING SYSTEM
Operating System
C#.NET is also compliant with CLS (Common Language Specification) and supports
structured exception handling. CLS is set of rules and constructs that are supported by the
CLR (Common Language Runtime). CLR is the runtime environment provided by the .NET
Framework; it manages the execution of the code and also makes the development process
easier by providing services.
Constructors are used to initialize objects, whereas destructors are used to destroy
them. In other words, destructors are used to release the resources allocated to the object.
In C#.NET the sub finalize procedure is available. The sub finalize procedure is used to
complete the tasks that must be performed when an object is destroyed. The sub finalize
ISSUE TRACKING SYSTEM
procedure is called automatically when an object is destroyed. In addition, the sub finalize
procedure can be called only from the class it belongs to or from derived classes.
GARBAGE COLLECTION
In C#.NET, the garbage collector checks for the objects that are not currently in use by
applications. When the garbage collector comes across an object that is marked for
garbage collection, it releases the memory occupied by the object.
OVERLOADING
a class.
MULTITHREADING:
There are different types of application, such as Windows-based applications and Web-
based applications.
FEATURES OF SQL-SERVER
The OLAP Services feature available in SQL Server version 7.0 is now called
SQL Server 2000 Analysis Services. The term OLAP Services has been replaced with the term
Analysis Services. Analysis Services also includes a new data mining component. The
Repository component available in SQL Server version 7.0 is now called Microsoft SQL Server
2000 Meta Data Services. References to the component now use the term Meta Data Services.
The term repository is used only in reference to the repository engine within Meta Data
Services
They are,
1. TABLE
2. QUERY
ISSUE TRACKING SYSTEM
3. FORM
4. REPORT
5. MACRO
TABLE:
VIEWS OF TABLE:
1. Design View
2. Datasheet View
Design View
Datasheet View
To add, edit or analyses the data itself we work in tables datasheet view
mode.
QUERY:
A query is a question that has to be asked the data. Access gathers data that answers
the question from one or more table. The data that make up the answer is either dynaset (if you
edit it) or a snapshot (it cannot be edited).Each time we run query, we get latest information in
the dynaset. Access either displays the dynaset or snapshot for us to view or perform an action
on it, such as deleting or updating.
ISSUE TRACKING SYSTEM
Implementation is the stage in the project where the theoretical design is turned into a working
system. The implementation phase constructs, installs and operates the new system. The most
crucial stage in achieving a new successful system is that it will work efficiently and
effectively.
There are several activities involved while implementing a new project they are
System Design
The successful implementation of the new system will purely upon the involvement of the
officers working in that department. The officers will be imparted the necessary training on the
new technology.
The education of the end user start after the implementation and testing is over. When the
system is found to be more difficult to understand and complex, more effort is put to educate
ISSUE TRACKING SYSTEM
the end used to make them aware of the system, giving them lectures about the new system and
providing them necessary documents and materials about how the system can do this.
SYSTEM TESTING
The purpose of testing is to discover errors. Testing is the process of trying to discover
every conceivable fault or weakness in a work product. It provides a way to check the
functionality of components, sub assemblies, assemblies and/or a finished product It is the
process of exercising software with the intent of ensuring that the
Software system meets its requirements and user expectations and does not fail in an
unacceptable manner. There are various types of test. Each test type addresses a specific testing
requirement.
TYPES OF TESTS
Unit testing
Unit testing involves the design of test cases that validate that the internal program
logic is functioning properly, and that program inputs produce valid outputs. All decision
branches and internal code flow should be validated. It is the testing of individual software
units of the application .it is done after the completion of an individual unit before integration.
This is a structural testing, that relies on knowledge of its construction and is invasive. Unit
tests perform basic tests at component level and test a specific business process, application,
and/or system configuration. Unit tests ensure that each unique path of a business process
ISSUE TRACKING SYSTEM
performs accurately to the documented specifications and contains clearly defined inputs and
expected results.
Integration testing
Integration tests are designed to test integrated software components to determine if
they actually run as one program. Testing is event driven and is more concerned with the basic
outcome of screens or fields. Integration tests demonstrate that although the components were
individually satisfaction, as shown by successfully unit testing, the combination of components
is correct and consistent. Integration testing is specifically aimed at exposing the problems
that arise from the combination of components.
Functional test
Functional tests provide systematic demonstrations that functions tested are available as
specified by the business and technical requirements, system documentation, and user manuals.
System Test
System testing ensures that the entire integrated software system meets requirements. It
tests a configuration to ensure known and predictable results. An example of system testing is
ISSUE TRACKING SYSTEM
the configuration oriented system integration test. System testing is based on process
descriptions and flows, emphasizing pre-driven process links and integration points.
Test objectives
All field entries must work properly.
Pages must be activated from the identified link.
The entry screen, messages and responses must not be delayed.
Features to be tested
Verify that the entries are of the correct format
ISSUE TRACKING SYSTEM
The task of the integration test is to check that components or software applications,
e.g. components in a software system or – one step up – software applications at the company
level – interact without error.
Test Results: All the test cases mentioned above passed successfully. No defects encountered.
Test Results: All the test cases mentioned above passed successfully. No defects
encountered.
ISSUE TRACKING SYSTEM
CONCLUSION
ISSUE TRACKING SYSTEM
CONCLUSION:
FUTURE ENHANCEMENT
ISSUE TRACKING SYSTEM
11.FUTURE ENHANCEMENT
It is not possible to develop a system that makes all the requirements of the user.
User requirements keep changing as the system is being used. Some of the future enhancements
that can be done to this system are:
Extending this application by providing Authorisation service.
Creating Database and maintaining users.
Increasing the effectiveness of the application by providing Voice Chat.
Extending it to Web Support.
ISSUE TRACKING SYSTEM
APPENDIX
ISSUE TRACKING SYSTEM
SCREENSHOTS
Module 1
Project assessment
ISSUE TRACKING SYSTEM
Module 2
Registration
ISSUE TRACKING SYSTEM
Tester
ISSUE TRACKING SYSTEM
Module 3
Issue raising
ISSUE TRACKING SYSTEM
ISSUE TRACKING SYSTEM
Module 4
Developer
ISSUE TRACKING SYSTEM
Modules 5
SOURCE CODE
ISSUE TRACKING SYSTEM
11.1.SOURCE CODE
Programmer
</tr>
<tr>
<td>
<asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Names="Andalus"
Text="PROGRAMMER S.NO"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox1" runat="server"
ReadOnly="True"></asp:TextBox></td>
</tr>
<tr>
<td>
<asp:Label ID="Label2" runat="server" Font-Bold="True" Font-Names="Andalus"
Text="PROGRAMMERNAME"></asp:Label>
</td>
ISSUE TRACKING SYSTEM
<td>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td><asp:Label ID="Label3" runat="server" Font-Bold="True" Font-
Names="Andalus"
Text="DESIGNATION"></asp:Label>
</td>
<td>
<asp:DropDownList ID="DropDownList1" runat="server"
>
<asp:ListItem>PLEASE SELECT</asp:ListItem>
<asp:ListItem>TRAINEE</asp:ListItem>
<asp:ListItem>SOFTWARE ENGINEER</asp:ListItem>
<asp:ListItem>TEAM LEADER</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td>
<asp:Label ID="Label4" runat="server" Font-Bold="True" Font-Names="Andalus"
Text="EXPERIENCE"></asp:Label>
</td>
<td>
<asp:TextBox ID="TextBox4" runat="server" ></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label5" runat="server" Font-Bold="True" Font-Names="Andalus"
Text="MAILID"></asp:Label>
</td>
<td>
ISSUE TRACKING SYSTEM
using System;
using System.Collections.Generic;
ISSUE TRACKING SYSTEM
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using Microsoft.VisualBasic;
using System.Configuration;
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
string cs =
ConfigurationManager.ConnectionStrings["BuginfoConnectionString"].ConnectionString.To
String();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "insert into
programmerinfo(pgname,designation,experience,mailid,password)values(@pname,@designa
tion,@experience,@mailid,@password)";
//cmd.Parameters.AddWithValue("@pid",Convert.ToInt32(TextBox1.Text));
cmd.Parameters.AddWithValue("@pname", TextBox2.Text.ToString());
cmd.Parameters.AddWithValue("@designation",
DropDownList1.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@experience", TextBox4.Text.ToString ());
ISSUE TRACKING SYSTEM
cmd.Parameters.AddWithValue("@mailid", TextBox5.Text.ToString());
cmd.Parameters.AddWithValue("@password", TextBox6.Text.ToString());
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Interaction.MsgBox("Your profile is created", MsgBoxStyle.OkOnly, "bugtracking");
SqlCommand cmd1 = new SqlCommand();
cmd1.Connection = con;
cmd1.CommandText = "select max(pgid) from programmerinfo";
SqlDataReader rs = cmd1.ExecuteReader();
if (rs.Read())
{
int id =Convert.ToInt32(rs.GetValue(0).ToString());
Interaction.MsgBox("your user id is " + id.ToString(), MsgBoxStyle.OkOnly,
"Issue Tracking System");
Response.Redirect("login.aspx");
}
else
{
Interaction.MsgBox("Sorry!!!your profile is not created", MsgBoxStyle.OkOnly,
"Issue Tracking System");
}
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
}
}
Issue
Text="DETAIL"></asp:Label> </td>
<td>
<asp:TextBox ID="txtreason" runat="server" ></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label6" runat="server" Font-Bold="True" Font-Names="Andalus"
ForeColor="Black"
</tr>
<tr>
<td>
<asp:Label ID="Label5" runat="server" Font-Bold="True" Font-Names="Andalus"
ForeColor="Black"
Text="PRIORITY:"></asp:Label> </td>
<td>
<asp:RadioButtonList ID="rblpriority" runat="server" ForeColor="Black"
RepeatDirection="Horizontal"
>
<asp:ListItem>Critical</asp:ListItem>
<asp:ListItem>High</asp:ListItem>
<asp:ListItem>Medium</asp:ListItem>
<asp:ListItem>Low</asp:ListItem>
</asp:RadioButtonList> </td>
</tr>
<tr>
<td align="center" colspan="2">
<asp:LinkButton ID="LinkButton1" runat="server" Font-Bold="True" Font-
Names="Times New Roman"
Font-Overline="False"
Font-Size="X-Large" onclick="LinkButton1_Click">Bug Assign</asp:LinkButton>
</td>
</tr>
</table>
</asp:Content>
using System;
using System.Collections.Generic;
using System.Linq;
ISSUE TRACKING SYSTEM
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using Microsoft.VisualBasic;
using System.Configuration;
using System.Data;
tsid = Request.QueryString["tsid"].ToString();
llbtsid.Text = tsid;
string cs =
ConfigurationManager.ConnectionStrings["BuginfoConnectionString"].ConnectionString.To
String();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "select pid,pname,pgid from protesallocation where tsid=@tsid";
cmd.Parameters.AddWithValue("@tsid", Convert.ToInt32(tsid));
SqlDataReader rs;
rs = cmd.ExecuteReader();
ISSUE TRACKING SYSTEM
if (rs.Read())
{
txtprojectid.Text = rs.GetValue(0).ToString();
txtprojectname.Text = rs.GetValue(1).ToString();
pgid.Text = rs.GetValue(2).ToString();
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
string cs =
ConfigurationManager.ConnectionStrings["BuginfoConnectionString"].ConnectionString.To
String();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "insert into
buginfo(bugname,pid,pname,pgid,tsid,reason,status,bugtype,priority,assigndate)
values(@bugname,@pid,@pname,@pgid,@tsid,@reason,@status,@bugtype,@priority,@ass
igndate)";
cmd.Parameters.AddWithValue("@bugname", txtbugname.Text.ToString());
cmd.Parameters.AddWithValue("@pid", Convert.ToInt32(txtprojectid.Text));
cmd.Parameters.AddWithValue("@pname", txtprojectname.Text.ToString());
cmd.Parameters.AddWithValue("@pgid", Convert.ToInt32(pgid.Text));
cmd.Parameters.AddWithValue("@tsid", Convert.ToInt32(llbtsid.Text));
cmd.Parameters.AddWithValue("@reason", txtreason.Text.ToString());
cmd.Parameters.AddWithValue("@status", "Bug Assigned");
cmd.Parameters.AddWithValue("@bugtype", ddlbugtype.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@priority", rblpriority.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@assigndate", DateTime.Now);
ISSUE TRACKING SYSTEM
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Interaction.MsgBox("bug information is sent", MsgBoxStyle.OkOnly, "Issue
Tracking System");
clear();
}
}
protected void clear()
{
txtbugname.Text = "";
txtreason.Text = "";
}
}
ISSUE TRACKING SYSTEM
BIBLOGRAPHY
ISSUE TRACKING SYSTEM
BIBLIOGRAPHY
Sites Referred:
http://www.asp.net.com
http://www.dotnetspider.com/
http://www.dotnetspark.com
ISSUE TRACKING SYSTEM
Abbreviations: