private void button2_Click(object sender, EventArgs e) { this.Hide(); Complain cm = new Complain(); cm.Show(); }
private void PoliceComplaiButton_Click(object sender, EventArgs e) { this.Hide(); Complain c = new Complain(); c.Show(); }
private void button2_Click(object sender, EventArgs e) { int selectedrowindex = ComplainListGridView.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = ComplainListGridView.Rows[selectedrowindex]; string a = Convert.ToString(selectedRow.Cells["Complain_id"].Value); SqlConnection myConnection = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\anowe\OneDrive\Documents\Visual Studio 2012\Projects\JailManagement\JailManagement\Employee.mdf;Integrated Security=True;Connect Timeout=30"); string sql = "Delete From Complain Where Complain_id = @Complain_id "; SqlCommand cmd = new SqlCommand(sql, myConnection); cmd.Parameters.AddWithValue("@Complain_id", a); myConnection.Open(); int i = cmd.ExecuteNonQuery(); myConnection.Close(); MessageBox.Show("Complain Deleted"); this.Hide(); Complain fr = new Complain(); fr.Show(); }
private void ComplainRegisterButton_Click(object sender, EventArgs e) { SqlConnection myConnection = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\anowe\OneDrive\Documents\Visual Studio 2012\Projects\JailManagement\JailManagement\Employee.mdf;Integrated Security=True;Connect Timeout=30"); string sql = "INSERT INTO Complain (Complain_id,Full_Name,National_id,Date_of_Birth,Gender,Address,Nationality,Complain_Against,Complain_Date,Details) VALUES (@Complain_id,@Full_Name,@National_id,@Date_of_Birth,@Gender,@Address,@Nationality,@Complain_Against,@Complain_Date,@Details)"; SqlCommand cmd = new SqlCommand(sql, myConnection); cmd.Parameters.AddWithValue("@Complain_id", Complain_Id.Text); cmd.Parameters.AddWithValue("@Full_Name", Full_Name.Text); cmd.Parameters.AddWithValue("@National_id", National_Id.Text); cmd.Parameters.AddWithValue("@Address", ComplainAddress.Text); cmd.Parameters.AddWithValue("@Nationality", Complain_Nationality.Text); cmd.Parameters.AddWithValue("@Complain_Against", Complain_Against.Text); cmd.Parameters.AddWithValue("@Complain_Date", Complain_Date.Value); cmd.Parameters.AddWithValue("@Date_of_Birth", Complain_reDate.Value); string value = ""; bool isChecked = ComplainmG.Checked; if (isChecked) { value = ComplainmG.Text; } else { value = ComplainMf.Text; } cmd.Parameters.AddWithValue("@Gender", value); cmd.Parameters.AddWithValue("@Details", ComplainDetails.Text); myConnection.Open(); int i = cmd.ExecuteNonQuery(); myConnection.Close(); DialogResult result = MessageBox.Show("Complain Addded..Want to add a criminal?", "The Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1); if (result == DialogResult.Yes) { this.Hide(); CriminalInformation_Id c = new CriminalInformation_Id(); c.Show(); } else { this.Hide(); Complain c = new Complain(); c.Show(); } }