public void populate()
{
CaseDataBase caseDB = new CaseDataBase();
list_case = caseDB.Select_All();
CaseGridView.DataSource = list_case;
}
private void btnDelete_Click(object sender, EventArgs e)
{
c = new Case();
c.caseID = Convert.ToInt32(CaseGridView.CurrentRow.Cells[0].Value.ToString());
CaseDataBase caseDB = new CaseDataBase();
caseDB.delete(c);
populate();
}
private void btnSave_Click_1(object sender, EventArgs e)
{
CaseDataBase caseDB = new CaseDataBase();
c = new Case();
c.caseType = txtCaseType.Text;
c.startingDate = txtStartingDate.Text;
c.endingDate = txtEndingDate.Text;
c.officerBatchID = Convert.ToInt32(txtOfficerID.Text);
c.solved = txtSolved.Text;
c.victimID = Convert.ToInt32(txtVictimID.Text);
c.crimeID = Convert.ToInt32(txtCrimeID.Text);
caseDB.insert(c);
populate();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
CaseDataBase caseDB = new CaseDataBase();
c = new Case();
c.caseID = Convert.ToInt32(CaseGridView.CurrentRow.Cells[0].Value.ToString());
c.caseType = txtCaseType.Text;
c.startingDate = txtStartingDate.Text;
c.endingDate = txtEndingDate.Text;
c.officerBatchID = Convert.ToInt32(txtOfficerID.Text);
c.solved = txtSolved.Text;
c.victimID = Convert.ToInt32(txtVictimID.Text);
c.crimeID = Convert.ToInt32(txtCrimeID.Text);
caseDB.update(c);
populate();
}