public static void TmbhBarang(Barang std) { string sql = "INSERT INTO databarang VALUES (@IDBarang, @NamaBarang, @HargaBarang, @StokBarang)"; MySqlConnection con = GetConnection(); MySqlCommand cmd = new MySqlCommand(sql, con); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@IDBarang", MySqlDbType.VarChar).Value = std.ID; cmd.Parameters.Add("@NamaBarang", MySqlDbType.VarChar).Value = std.NAMA; cmd.Parameters.Add("@HargaBarang", MySqlDbType.VarChar).Value = std.HARGA; cmd.Parameters.Add("@StokBarang", MySqlDbType.VarChar).Value = std.STOK; try { cmd.ExecuteNonQuery(); MessageBox.Show("Data Berhasil Ditambahkan.", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (MySqlException e) { MessageBox.Show("Data Gagal Ditambahkan. \n" + e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } con.Close(); }
public static void UpdateBarang(Barang std, string ID) { string sql = "UPDATE databarang SET NAMA = @NamaBarang, HARGA = @HargaBarang, STOK = @StokBarang WHERE ID = @IDBarang"; MySqlConnection con = GetConnection(); MySqlCommand cmd = new MySqlCommand(sql, con); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@IDBarang", MySqlDbType.VarChar).Value = ID; cmd.Parameters.Add("@NamaBarang", MySqlDbType.VarChar).Value = std.NAMA; cmd.Parameters.Add("@HargaBarang", MySqlDbType.VarChar).Value = std.HARGA; cmd.Parameters.Add("@StokBarang", MySqlDbType.VarChar).Value = std.STOK; try { cmd.ExecuteNonQuery(); MessageBox.Show("Data Berhasil Diupdate.", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (MySqlException e) { MessageBox.Show("Data Gagal Diupdate. \n" + e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } con.Close(); }
private void btnTambah_Click(object sender, EventArgs e) { if (txtID.Text.Trim().Length <= 0) { MessageBox.Show("ID Kosong!"); return; } if (txtNama.Text.Trim().Length <= 0) { MessageBox.Show("Nama Kosong!"); return; } if (txtHarga.Text.Trim().Length <= 0) { MessageBox.Show("Harga Kosong!"); return; } if (txtStok.Text.Trim().Length <= 0) { MessageBox.Show("Stok Kosong!"); return; } if (btnTambah.Text == "Tambah") { Barang std = new Barang(txtID.Text.Trim(), txtNama.Text.Trim(), txtHarga.Text.Trim(), txtStok.Text.Trim()); CRUDBarang.TmbhBarang(std); clrscr(); } if (btnTambah.Text == "Edit") { Barang std = new Barang(txtID.Text.Trim(), txtNama.Text.Trim(), txtHarga.Text.Trim(), txtStok.Text.Trim()); CRUDBarang.UpdateBarang(std, ID); clrscr(); } _parent.Display(); }