public bool DeleteTRPembelian(TransaksiPembelian trPembelian)
{
bool result = false;
query = "DELETE FROM transaksi_pembelian WHERE id_transaksi_pembelian = '" + trPembelian.Id_transaksi_pembelian + "'";
try
{
connect.Open();
cmd = new MySqlCommand(query, connect);
cmd.ExecuteNonQuery();
result = true;
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message.ToString());
result = false;
}
finally
{
connect.Close();
}
return result;
}
public bool AddTRPembelian(TransaksiPembelian trPembelian)
{
bool result = false;
query = "INSERT INTO transaksi_pembelian VALUES('" + trPembelian.Id_transaksi_pembelian + "','" + trPembelian.Tgl_tr_pembelian + "')";
try
{
connect.Open();
cmd = new MySqlCommand(query, connect);
cmd.ExecuteNonQuery();
result = true;
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message.ToString());
result = false;
}
finally
{
connect.Close();
}
return result;
}
