public bool AddMerek(MerekBarang merk) { bool result = false; query = "INSERT INTO merek_barang VALUES('" + merk.Id_merek_barang + "','" + merk.Nama_merek + "')"; 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; }
private void btn_AddMerekBarang_Click(object sender, EventArgs e) { if (txt_NamaMerekBarang.TextLength > 0) { s_MerekBarang = new MerekBarang(Utils.ConcatMaxID(txt_IdMerekBarang.Text.ToString(), txt_IdMerekBarangNum.Text.ToString()), txt_NamaMerekBarang.Text.ToString()); if (s_MerekBarangManager.AddMerek(s_MerekBarang)) { MessageBox.Show("Data berhasil ditambah"); txt_IdMerekBarangNum.Text = Utils.DisplayMaxID(s_MerekBarangManager.GetMaxIDMerekBarang().Substring((s_MerekBarangManager.GetMaxIDMerekBarang().IndexOf("-")) + 1)); ClearFieldMerek(); } else { MessageBox.Show("Data gagal ditambah"); } } else { MessageBox.Show("Mohon data-data dilengkapi"); } }
public bool UpdateMerek(MerekBarang merk) { bool result = false; query = "UPDATE merek_barang SET nama_merek = '" + merk.Nama_merek + "' WHERE id_warna_barang = '" + merk.Id_merek_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 DeleteMerek(MerekBarang merk) { bool result = false; query = "DELETE FROM merek_barang WHERE id_merek_barang = '" + merk.Id_merek_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; }