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