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; }