public bool DeleteBarang(Barang brg)
{
bool result = false;
query = "DELETE FROM barang WHERE id_barang = '" + brg.Id_barang + "'";
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 AddBarang(Barang brg)
{
bool result = false;
//m4verick - data yang diambil dari UI adalah 'nama' bukan 'id', perlu inner query untuk mengambil id masing-masing
query = "INSERT INTO barang VALUES('" + brg.Id_barang + "','" + brg.Jenis_sub_jenis_id_jenis_sub_jenis_fk + "',"+
"(SELECT id_ukuran_barang FROM ukuran_barang WHERE nama_ukuran = '" + brg.Ukuran_id_ukuran_barang_fk + "'),"+
"(SELECT id_model_barang FROM model_barang WHERE nama_model = '" + brg.Model_id_model_barang_fk + "'),"+
"(SELECT id_warna_barang FROM warna_barang WHERE nama_warna = '" + brg.Warna_id_warna_barang_fk + "'),"+
"(SELECT id_merek_barang FROM merek_barang WHERE nama_merek = '" + brg.Merek_id_merek_barang_fk + "'),"+
"(SELECT id_supplier FROM supplier WHERE nama_supplier = '" + brg.Supp_id_supplier_fk + "'), '" + brg.Gender + "', " + brg.Harga + ","+
"'" + brg.Status_stok + "')";
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;
}