public bool AddJenisBarang(JenisBarang jnsBrg)
{
bool result = false;
query = "INSERT INTO jenis_barang VALUES('" + jnsBrg.Id_jenis_barang + "','" + jnsBrg.Nama_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 UpdateJenisBarang(JenisBarang jnsBrg)
{
bool result = false;
query = "UPDATE jenis_barang SET nama_jenis = '" + jnsBrg.Nama_jenis + "' WHERE id_jenis_barang = '" + jnsBrg.Id_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;
}
