private void BtnEdit_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(ComboBoxJasaLayanan.Text))
{
MessageBox.Show("Silahkan pilih data terlebih dahulu", "Warning");
return;
}
else
{
conn.Open();
TransaksiProduk tr = new TransaksiProduk();
adapter = new MySqlDataAdapter("update detail_transaksi_jasalayanan dt, transaksi tr SET dt.ID_JASA_LAYANAN = '" + ComboBoxJasaLayanan.SelectedValue + "', dt.JUMLAH = '" + JumlahJasaLayananText.Text + "' WHERE dt.ID_TRANSAKSI = tr.ID_TRANSAKSI AND tr.ID_TRANSAKSI = '" + idTransaksi + "' AND dt.ID_DETAILTRANSAKSI_JASALAYANAN = '" + idDetail + "'", conn);
adapter.Fill(ds, "detail_transaksi_jasalayanan");
MessageBox.Show("Edit berhasil!", "Success");
conn.Close();
this.Close();
}
}
private void Window_Closing(object sender, System.ComponentModel.CancelEventArgs e)
{
TransaksiProduk TP = new TransaksiProduk();
TP.GetRecords();
}