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