public bool UpdateUkuran(UkuranBarang ukuran) { bool result = false; query = "UPDATE ukuran_barang SET ukuran = '" + ukuran.Ukuran_barang + "' WHERE id_ukuran_barang = '" + ukuran.Id_ukuran_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; }
public bool AddUkuran(UkuranBarang ukuran) { bool result = false; query = "INSERT INTO ukuran_barang VALUES('" + ukuran.Id_ukuran_barang + "','" + ukuran.Ukuran_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; }
private void btn_AddUkuranBarang_Click(object sender, EventArgs e) { if (txt_NamaUkuranBarang.TextLength > 0) { s_UkuranBarang = new UkuranBarang(Utils.ConcatMaxID(txt_IdUkuranBarang.Text.ToString(), txt_IdUkuranBarangNum.Text.ToString()), txt_NamaUkuranBarang.Text.ToString()); if (s_MerekBarangManager.AddUkuran(s_UkuranBarang)) { MessageBox.Show("Data berhasil ditambah"); txt_IdUkuranBarangNum.Text = Utils.DisplayMaxID(s_MerekBarangManager.GetMaxIDUkuranBarang().Substring((s_MerekBarangManager.GetMaxIDUkuranBarang().IndexOf("-")) + 1)); ClearFieldUkuran(); } else { MessageBox.Show("Data gagal ditambah"); } } else { MessageBox.Show("Mohon data-data dilengkapi"); } }