private void btnHapus_Click(object sender, RoutedEventArgs e)
{
var button = (FrameworkElement)sender;
var row = (DataGridRow)button.Tag;
if (dgPasien.SelectedCells.Count > 0)
{
MessageBoxResult result = MessageBox.Show("Hapus Data Pasien?", "Konfirmasi", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable);
koneksi.SendQuery("DELETE FROM mydentist.tbl_pasien WHERE mydentist.tbl_pasien.id_pasien = " + GetIndexpasien(row), null);
koneksi.Commit(true);
ShowDataTabel();
koneksi.Dispose();
}
}
}
private void btnHapus_Click(object sender, RoutedEventArgs e)
{
var button = (FrameworkElement)sender;
var row = (DataGridRow)button.Tag;
if (dgTerapi.SelectedCells.Count > 0)
{
MessageBoxResult result = MessageBox.Show("Hapus Data Terapi?", "Konfirmasi", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable);
koneksi.SendQuery("DELETE FROM mydentist.tbl_terapi WHERE mydentist.tbl_terapi.id_terapi = " + GetIndexpasien(row), null);
koneksi.Commit(true);
ShowDataTabel();
koneksi.Dispose();
}
}
}