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; }