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