/// <summary>
/// Handles navigation button click events
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void nav_click(object sender, EventArgs e)
{
Control flatbtn = (FlatButton_WOC)sender;
if (flatbtn.TabIndex == 0)
{
Home_Tab.getInstance().populateCharts();
Home_Tab.getInstance().populateDataGridAgeAnalysis();
Home_Tab.getInstance().populateDataGridDREAnalysis();
Home_Tab.getInstance().populateDataGridDRRAnalysis();
materialSkinManager.ColorScheme = new ColorScheme(Primary.BlueGrey900, Primary.Red700, Primary.Red700, Accent.Red700, TextShade.WHITE);
}
if (flatbtn.TabIndex == 1)
{
Users_Tab.getInstance().populateDataGridView();
materialSkinManager.ColorScheme = new ColorScheme(Primary.Red700, Primary.Red700, Primary.Red700, Accent.Red700, TextShade.WHITE);
}
else if (flatbtn.TabIndex == 2)
{
Projects_Tab.getInstance().populateDataGridView();
materialSkinManager.ColorScheme = new ColorScheme(Primary.Red700, Primary.Red700, Primary.Red700, Accent.Red700, TextShade.WHITE);
}
else if (flatbtn.TabIndex == 3)
{
Defects_Tab.getInstance().populateDataGridView();
materialSkinManager.ColorScheme = new ColorScheme(Primary.Red700, Primary.Red700, Primary.Red700, Accent.Red700, TextShade.WHITE);
}
navAdapter.ShowTab((flatbtn).TabIndex);
}
/// <summary>
/// Override OnLoad event
/// </summary>
/// <param name="e"></param>
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
MaximizedBounds = Screen.FromHandle(Handle).WorkingArea; // Set the MaximumBounds to the screen size excluding the taskbar
if (role == "Developer" || role == "Tester")
{
btnNavHome.Visible = false;
btnNavUser.Visible = false;
btnNavProject.Visible = false;
btnNavHome.Selected = false;
btnNavDefect.Selected = true;
Defects_Tab.getInstance().BringToFront();
materialSkinManager.ColorScheme = new ColorScheme(Primary.Red700, Primary.Red700, Primary.Red700, Accent.Red700, TextShade.WHITE);
}
else if (role == "Manager")
{
btnNavHome.Visible = true;
btnNavUser.Visible = false;
btnNavProject.Visible = false;
btnNavHome.Selected = true;
btnNavDefect.Selected = false;
Home_Tab.getInstance().BringToFront();
btnNavUser.Selected = false;
btnNavProject.Selected = false;
btnNavDefect.Selected = false;
Home_Tab.getInstance().populateCharts();
materialSkinManager.ColorScheme = new ColorScheme(Primary.BlueGrey900, Primary.Red700, Primary.Red700, Accent.Red700, TextShade.WHITE);
}
else
{
btnNavHome.Visible = true;
btnNavUser.Visible = true;
btnNavProject.Visible = true;
btnNavHome.Selected = true;
btnNavDefect.Selected = false;
Home_Tab.getInstance().BringToFront();
btnNavUser.Selected = false;
btnNavProject.Selected = false;
btnNavDefect.Selected = false;
Home_Tab.getInstance().populateCharts();
materialSkinManager.ColorScheme = new ColorScheme(Primary.BlueGrey900, Primary.Red700, Primary.Red700, Accent.Red700, TextShade.WHITE);
}
}
/// <summary>
/// Setup navigation between tabs
/// </summary>
private void SetupNavigation()
{
navAdapter.AddTab(Home_Tab.getInstance(), true);
navAdapter.AddTab(Users_Tab.getInstance(), false);
navAdapter.AddTab(Projects_Tab.getInstance(), false);
navAdapter.AddTab(Defects_Tab.getInstance(), false);
panelTabs_Holder.Controls.Add(Users_Tab_Child.getInstance());
Users_Tab_Child.getInstance().Dock = DockStyle.Fill;
panelTabs_Holder.Controls.Add(Projects_Tab_Child.getInstance());
Projects_Tab_Child.getInstance().Dock = DockStyle.Fill;
panelTabs_Holder.Controls.Add(Modules_Tab.getInstance());
Modules_Tab.getInstance().Dock = DockStyle.Fill;
panelTabs_Holder.Controls.Add(Modules_Tab_Child.getInstance());
Modules_Tab_Child.getInstance().Dock = DockStyle.Fill;
panelTabs_Holder.Controls.Add(Defects_Tab_Child.getInstance());
Defects_Tab_Child.getInstance().Dock = DockStyle.Fill;
panelTabs_Holder.Controls.Add(Defects_Tab_Child2.getInstance());
Defects_Tab_Child2.getInstance().Dock = DockStyle.Fill;
}
/// <summary>
/// Handle the function of adding a defect to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDefectSave_Click(object sender, EventArgs e)
{
string projectName = comboBoxProject.Text;
string moduleName = comboBoxModule.Text;
string description = txtDescription.Text.Trim();
string steps = txtSteps.Text.Trim();
string raisedBy = txtRaisedBy.Text.Trim();
string assignedTo = comboBoxAssignedTo.Text;
string status = comboBoxStatus.Text;
string priority = "";
if (RadioButtonPriorityLow.Checked == true)
{
priority = "Low";
}
else if (RadioButtonPriorityMed.Checked == true)
{
priority = "Medium";
}
else
{
priority = "High";
}
if (projectName != "" && moduleName != "" && description != "" && raisedBy != "" && status != "") // Check if required fields are filled
{
if (DbConnector.OpenSQLConnection()) // Open connection to the database
{
// Connection opened
DefectDataAccess defect = new DefectDataAccess();
if (btnDefectSave.Text == "Save")
{
if (defect.InsertDefect(projectName, moduleName, description, steps, raisedBy, priority))
{
// Record inserted successfully
MessageBox.Show("Record has been inserted successfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
Defects_Tab.getInstance().BringToFront();
Defects_Tab.getInstance().populateDataGridView();
}
else
{
// Record was not inserted
MessageBox.Show("The record could not be saved", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (btnDefectSave.Text == "Update")
{
UserDataAccess user = new UserDataAccess();
DateTime? dateClosed;
if (defect.UpdateDefect(defectId, projectName, moduleName, description, steps, assignedTo, status, priority,
comboBoxStatus.Text == "Closed" ? dateClosed = DateTime.Now.Date : null, comboBoxStatus.Text != defectStatus && (comboBoxStatus.Text == "Rejected" ||
comboBoxStatus.Text == "Duplicate") ? drr - 1 : drr, comboBoxStatus.Text != defectStatus && (comboBoxStatus.Text == "Rejected" ||
comboBoxStatus.Text == "Duplicate") ? dre - 1 : comboBoxStatus.Text != defectStatus && comboBoxStatus.Text == "Re-Opened" ? dre + 1 : dre) &&
user.UpdateUserStatus(currentAssigned, "Available") &&
(user.UpdateUserStatus(comboBoxStatus.Text == "Closed" || comboBoxStatus.Text == "Rejected" || comboBoxStatus.Text == "Duplicate" ?
assignedTo = null : comboBoxAssignedTo.Text, "Assigned")))
{
// Record updated successfully
MessageBox.Show("Record has been updated successfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
Defects_Tab.getInstance().BringToFront();
Defects_Tab.getInstance().populateDataGridView();
}
else
{
// Record was not updated
MessageBox.Show("The record could not be updated", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
// Connection could not be opened
MessageBox.Show("Connection to the database could not be established", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
// Fields not filled correctly
MessageBox.Show("Please fill all the required fields", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <summary>
/// Navigate to the Defects List view
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDefectsCancel_Click(object sender, EventArgs e)
{
Defects_Tab.getInstance().BringToFront();
Defects_Tab.getInstance().populateDataGridView();
}
private void btnGoBack_Click(object sender, System.EventArgs e)
{
Defects_Tab.getInstance().BringToFront();
Defects_Tab.getInstance().populateDataGridView();
}
