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