private void cmdmnuApproveDecline_Click(object sender, EventArgs e)
{
SupervisorTabControl.SelectTab("approveDecline");
cmdmnuIncident.BackColor = Color.LightSteelBlue;
cmdmnuPersons.BackColor = Color.LightSteelBlue;
cmdmnuReportExtra.BackColor = Color.LightSteelBlue;
cmdmnuNarrative.BackColor = Color.LightSteelBlue;
cmdmnuApproveDecline.BackColor = Color.SteelBlue;
}
private void cmdApproveReport_Click(object sender, EventArgs e)
{
MySqlConnection con = new MySqlConnection("Server=sql29409.db.10825756.hostedresource.com;Database=sql29409;Uid=sql29409;Pwd=Aa3969889!;");
MySqlCommand cmd = new MySqlCommand("UPDATE Incident Set FinalReportVersion = 'Approved' WHERE ReportNumber = '" + lblSReportNo.Text + "' ");
cmd.Connection = con;
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read() != false)
{
if (reader.IsDBNull(0) == true)
{
cmd.Connection.Close();
reader.Dispose();
cmd.Dispose();
//return false;
}
else
{
cmd.Connection.Close();
reader.Dispose();
cmd.Dispose();
//return true;
}
}
else
{
//return false;
}
MessageBox.Show(" - Final Report was Officially Approved! The Report will be saved into Archives. - ", " Supervisor Reports");
//Clear Fields from Database Search
lblSAgency.Text = "";
lblSReportNo.Text = "";
lblSsupplementNo.Text = "";
lblSReportedDate.Text = "";
lblSReportedTime.Text = "";
lblSConfidential.Text = "";
lblSCmdrRpt.Text = "";
lblSIncidentEIDNo.Text = "";
lblSCADCallNo.Text = "";
lblSstatus.Text = "";
lblSNatureOfCall.Text = "";
lblSPropertyId.Text = "";
lblSUnitNo.Text = "";
lblSCity.Text = "";
lblSZipCode.Text = "";
lblSRepDist.Text = "";
lblSBeat.Text = "";
lblSArea.Text = "";
lblSFromDate.Text = "";
lblSFromTime.Text = "";
lblSToDate.Text = "";
lblSToTime.Text = "";
lblSOfficer.Text = "";
lblSAssignment.Text = "";
lblS2ndOfficer.Text = "";
lblS2ndAssignment.Text = "";
lblSEnteredby.Text = "";
lblSAssignmentCopy.Text = "";
lblSReviewOfficer.Text = "";
lblSRCStatus.Text = "";
lblSRCStatusDate.Text = "";
lblSRCStatusTime.Text = "";
rtxtExtratoReport.Text = "";
lblSPInvolvement.Text = "";
lblSPInvlNo.Text = "";
lblSPType.Text = "";
lblSPName.Text = "";
lblSPMNI.Text = "";
lblSPRace.Text = "";
lblSPSex.Text = "";
lblSPDOB.Text = "";
lblSPAge.Text = "";
lblSPToAge.Text = "";
lblSPJuvenile.Text = "";
lblSPHeight.Text = "";
lblSPToHeight.Text = "";
lblSPWeight.Text = "";
lblSPToWeight.Text = "";
lblSPHairColor.Text = "";
lblSPEyeColor.Text = "";
lblSPSkin.Text = "";
lblSPEthnicity.Text = "";
//chkbxConfidential
lblSPMeansOfAttack.Text = "";
lblSPExtentOfInjury.Text = "";
lblSPDomViolence.Text = "";
lblSPRelationshiptoOffender.Text = "";
lblSPPOB.Text = "";
rtxtNarrative.Text = "";
//Select Incident Tab
SupervisorTabControl.SelectTab("Incident");
cmdmnuIncident.BackColor = Color.SteelBlue;
cmdmnuPersons.BackColor = Color.LightSteelBlue;
cmdmnuReportExtra.BackColor = Color.LightSteelBlue;
cmdmnuNarrative.BackColor = Color.LightSteelBlue;
cmdmnuApproveDecline.BackColor = Color.LightSteelBlue;
//Disable TabControl
SupervisorTabControl.Enabled = false;
cmdmnuIncident.Enabled = false;
cmdmnuPersons.Enabled = false;
cmdmnuReportExtra.Enabled = false;
cmdmnuNarrative.Enabled = false;
cmdmnuApproveDecline.Enabled = false;
}
