public bool AddModel(ModelBarang model) { bool result = false; query = "INSERT INTO model_barang VALUES('" + model.Id_model_barang + "','" + model.Nama_model + "')"; 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_AddModelBarang_Click(object sender, EventArgs e) { if (txt_NamaModelBarang.TextLength > 0) { s_ModelBarang = new ModelBarang(Utils.ConcatMaxID(txt_IdModelBarang.Text.ToString(), txt_IdModelBarangNum.Text.ToString()), txt_NamaModelBarang.Text.ToString()); if (s_MerekBarangManager.AddModel(s_ModelBarang)) { MessageBox.Show("Data berhasil ditambah"); txt_IdModelBarangNum.Text = Utils.DisplayMaxID(s_MerekBarangManager.GetMaxIDModelBarang().Substring((s_MerekBarangManager.GetMaxIDModelBarang().IndexOf("-")) + 1)); ClearFieldModel(); } else { MessageBox.Show("Data gagal ditambah"); } } else { MessageBox.Show("Mohon data-data dilengkapi"); } }
public bool UpdateModel(ModelBarang model) { bool result = false; query = "UPDATE model_barang SET nama_model = '" + model.Nama_model + "' WHERE id_model_barang = '" + model.Id_model_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; }