//delete patient history
private void button2_Click(object sender, EventArgs e)
{
int hospitalized = 0;
int surgery = 0;
ConnectDB EMRDatabase = new ConnectDB();
for (int i = 0; i < PMHCB_Item.Count(); i++)
{
if (PMHCB_Hospitalized[i] == "Yes")
{
hospitalized = 1;
}
else
{
hospitalized = 0;
}
if (PMHCB_Surgery[i] == "Yes")
{
surgery = 1;
}
else
{
surgery = 0;
}
EMRDatabase.RemoveMedHistory(PatientInfo[2], PMHCB_Item[i], hospitalized, surgery, PMHCB_Date[i]);
}
List <DataGridViewRow> toDelete = new List <DataGridViewRow>();
foreach (DataGridViewRow row in dataGridView2.Rows)
{
DataGridViewCheckBoxCell cell = row.Cells[4] as DataGridViewCheckBoxCell;
if ((bool)cell.EditedFormattedValue == true)
{
toDelete.Add(row);
}
}
foreach (DataGridViewRow row in toDelete)
{
dataGridView2.Rows.Remove(row);
}
dataGridView2.ClearSelection();
button2.Enabled = false;
}