private void btnsave_Click(object sender, EventArgs e)
{
String Sql = "Insert into Table_Accused(Accused_fullname, Section_of_Law, Complain_Status, Complain_Details, Victim_Name, Accused_Name) " +
"values('" + txtfullname.Text + "', '" + txtfathername.Text + "', '" + txtaddress.Text + "', '" + txtnic.Text + "', '" + txtgender.Text + "', '" + txtstatus.Text + "', '" + txtcontact.Text + "', '" + txtemail.Text + "')".ToString();
accusedgridview.DataSource = DBConnection.GetTableByQuery(Sql);
dataload();
}
private void btndelete_Click(object sender, EventArgs e)
{
string query = "Delete from Table_InvestigationOfficer where Officer_ID = '" + txtofficerid.Text + "'";
Officergridview.DataSource = DBConnection.GetTableByQuery(query);
MessageBox.Show("Officer Record Deleted Successfully");
dataLoad();
}
private void btnsave_Click(object sender, EventArgs e)
{
String Sql = "Insert into Table_Complain(Complain_Date, Section_of_Law, Complain_Status, Complain_Details, Victim_Name, Accused_Name) " +
"values('" + txtcomplaindate.Text + "', '" + txtsectionoflaw.Text + "', '" + txtcomplainstatus.Text + "', '" + txtcomplaindetails.Text + "', '" + txtvictimname.Text + "', '" + txtaccusedname.Text + "')".ToString();
complaingridview.DataSource = DBConnection.GetTableByQuery(Sql);
dataload();
}
private void btndelete_Click(object sender, EventArgs e)
{
string query = "Delete from Table_Complain where Complain_ID = '" + txtcomplainid.Text + "'";
complaingridview.DataSource = DBConnection.GetTableByQuery(query);
MessageBox.Show("Complaint Deleted Successfully");
dataload();
}
private void btnsave_Click(object sender, EventArgs e)
{
String Sql = "Insert into Table_InvestigationOfficer(Full_Name, Rank) " +
"values('" + txtfullname.Text + "', '" + txtrank.Text + "')".ToString();
Officergridview.DataSource = DBConnection.GetTableByQuery(Sql);
dataLoad();
}
private void btndelete_Click(object sender, EventArgs e)
{
string query = "Delete from Table_Accused where Accused_ID = '" + txtaccusedid.Text + "'";
accusedgridview.DataSource = DBConnection.GetTableByQuery(query);
MessageBox.Show("Accused Deleted Successfully");
dataload();
}
private void btnupdate_Click(object sender, EventArgs e)
{
String query = "update Table_Accused set fullname='" + txtfullname.Text + "',Section_of_Law='" + txtfathername.Text + "',Complain_Status='" + txtaddress.Text + "',Complain_Details='" + txtnic.Text + "',Victim_Name='" + txtgender.Text + "',Accused_Name='" + txtstatus.Text + "' where Accused_ID='" + txtaccusedid.Text + "' ";
accusedgridview.DataSource = DBConnection.GetTableByQuery(query);
MessageBox.Show("Data Updated Successfully");
dataload();
btnsave.Enabled = true;
}
private void btnupdate_Click(object sender, EventArgs e)
{
String query = "update Table_Complain set Complain_Date='" + txtcomplaindate.Text + "',Section_of_Law='" + txtsectionoflaw.Text + "',Complain_Status='" + txtcomplainstatus.Text + "',Complain_Details='" + txtcomplaindetails.Text + "',Victim_Name='" + txtvictimname.Text + "',Accused_Name='" + txtaccusedname.Text + "' where Complain_ID='" + txtcomplainid.Text + "' ";
complaingridview.DataSource = DBConnection.GetTableByQuery(query);
MessageBox.Show("Data Updated Successfully");
dataload();
btnsave.Enabled = true;
}
private void btnupdate_Click(object sender, EventArgs e)
{
String query = "update Table_InvestigationOfficer set Full_Name='" + txtfullname.Text + "',Rank='" + txtrank.Text + "' where Officer_ID='" + txtofficerid.Text + "' ";
Officergridview.DataSource = DBConnection.GetTableByQuery(query);
MessageBox.Show("Data Updated Successfully");
dataLoad();
btnsave.Enabled = true;
}
public void OfficerDataLoad()
{
String Sql = "Select * from Table_InvestigationOfficer";
OfficerGridView.DataSource = DBConnection.GetTableByQuery(Sql);
}
public void PetDataLoad()
{
String Sql = "Select * from Table_Petitioner";
petgridview.DataSource = DBConnection.GetTableByQuery(Sql);
}
public void dataload()
{
String Sql = "Select * from Table_Complain";
complaingridview.DataSource = DBConnection.GetTableByQuery(Sql);
}
public void ComplainDataLoad()
{
String Sql = "Select * from Table_Complain";
ComplainGridView.DataSource = DBConnection.GetTableByQuery(Sql);
}
public void VictimDataLoad()
{
String Sql = "Select * from Table_Victim";
VictimGridView.DataSource = DBConnection.GetTableByQuery(Sql);
}
public void dataload()
{
String Sql = "Select * from Table_Accused";
accusedgridview.DataSource = DBConnection.GetTableByQuery(Sql);
}
public void dataLoad()
{
String sql = "Select * from Table_InvestigationOfficer";
Officergridview.DataSource = DBConnection.GetTableByQuery(sql);
}
public void FIRDataLoad()
{
String Sql = "Select * from Table_FIR";
FIRGridView.DataSource = DBConnection.GetTableByQuery(Sql);
}
