/// <summary>
/// Method for populating the Charts
/// </summary>
public void populateCharts()
{
if (DbConnector.OpenSQLConnection()) // Open connection to the database
{
ReportsGenerator reportGen = new ReportsGenerator();
List <StatusAnalysis> statusAnalyis = reportGen.StatusAnalysis();
barChart.DataSource = statusAnalyis.OrderBy(i => i.Status);
barChart.Series["Defect Count"].XValueMember = "Status";
barChart.Series["Defect Count"].YValueMembers = "Count";
barChart.Series["Defect Count"].YValueType = ChartValueType.Int32;
doughnutChart.DataSource = statusAnalyis.OrderBy(i => i.Status);
doughnutChart.Series["Count"].XValueMember = "Status";
doughnutChart.Series["Count"].YValueMembers = "Count";
doughnutChart.Series["Count"].YValueType = ChartValueType.Int32;
DefectDataAccess defect = new DefectDataAccess();
var defects = defect.GetAllDefects();
drePointChart.DataSource = defect.GetAllDefects();
drePointChart.Series["DRE"].XValueMember = "DefectId";
drePointChart.Series["DRE"].YValueMembers = "DRE";
drePointChart.Series["DRE"].YValueType = ChartValueType.Int32;
List <AgeAnalysis> ageAnalysis = new List <AgeAnalysis>();
foreach (var d in defects.Zip(reportGen.calculateAge(defects), Tuple.Create))
{
ageAnalysis.Add(new AgeAnalysis
{
DefectId = d.Item1.DefectId,
Age = d.Item2
});
}
agePointChart.DataSource = ageAnalysis;
agePointChart.Series["Age"].XValueMember = "DefectId";
agePointChart.Series["Age"].YValueMembers = "Age";
agePointChart.Series["Age"].YValueType = ChartValueType.Int32;
}
else
{
// Connection could not be opened
MessageBox.Show("Connection to the database could not be established", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
DbConnector.CloseSQLConnection(); // Close connection to the database
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (DbConnector.OpenSQLConnection()) // Open connection to the database
{
// Connection opened
DefectDataAccess defect = new DefectDataAccess();
dgvAgeAnalysis.AutoGenerateColumns = false; // To only show the columns needed
var defects = defect.SearchDefectsAnalysis(txtSearchDefects.Text.Trim());
dgvAgeAnalysis.DataSource = defects;
ReportsGenerator reportGen = new ReportsGenerator();
reportGen.calculateAge(defects);
}
else
{
// Connection could not be opened
MessageBox.Show("Connection to the database could not be established", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
DbConnector.CloseSQLConnection(); // Close connection to the database
}
/// <summary>
/// Method for populating the DataDridViews
/// </summary>
public void populateDataGridAgeAnalysis()
{
if (DbConnector.OpenSQLConnection()) // Open connection to the database
{
// Connection opened
DefectDataAccess defect = new DefectDataAccess();
var defects = defect.GetAllDefects();
dgvAgeAnalysis.AutoGenerateColumns = false; // To only show the columns needed
dgvAgeAnalysis.DataSource = defects;
txtSearchDefects.Text = "";
for (int i = 0; i < defects.Count; i++)
{
ReportsGenerator reportGen = new ReportsGenerator();
dgvAgeAnalysis.Rows[i].Cells[7].Value = reportGen.calculateAge(defects)[i];
}
}
else
{
// Connection could not be opened
MessageBox.Show("Connection to the database could not be established", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
DbConnector.CloseSQLConnection(); // Close connection to the database
}