public bool AddSubJenisBarang(SubJenisBarang subJnsBrg)
{
bool result = false;
query = "INSERT INTO sub_jenis_barang VALUES('" + subJnsBrg.Id_sub_jenis_barang + "','" + subJnsBrg.Nama_sub_jenis + "')";
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 UpdateSubJenisBarang(SubJenisBarang subJnsBrg)
{
bool result = false;
query = "UPDATE sub_jenis_barang SET nama_sub_jenis = '" + subJnsBrg.Nama_sub_jenis + "' WHERE id_sub_jenis_barang = '" + subJnsBrg.Id_sub_jenis_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;
}
