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