private void btn_cari_Click(object sender, EventArgs e)
{
if (txt_cari.Text == "")
{
MessageBox.Show("Masukan Kata Kunci Cari");
}
data_barang db = new data_barang();
if (cb_cari.Text == "Kode Barang")
{
try
{
db.kd_barang = txt_cari.Text;
DataSet ds = new data_barang_dao().cari_kode_barang(db);
dgv_data_barang.DataSource = ds;
dgv_data_barang.DataMember = "tb_barang";
eventclickgrid();
}
catch (DataException)
{
MessageBox.Show("Data Tidak Di Temukan");
}
}
else if (cb_cari.Text == "Nama Barang")
{
try
{
db.nama_barang = txt_cari.Text;
DataSet ds = new data_barang_dao().cari_nama_barang(db);
dgv_data_barang.DataSource = ds;
dgv_data_barang.DataMember = "tb_barang";
eventclickgrid();
}
catch
{
MessageBox.Show("Data Tidak Di Temukan");
}
}
else if (cb_cari.Text == "Jenis Barang")
{
try
{
db.jenis_barang = txt_cari.Text;
DataSet ds = new data_barang_dao().cari_jenis_barang(db);
dgv_data_barang.DataSource = ds;
dgv_data_barang.DataMember = "tb_barang";
}
catch
{
MessageBox.Show("Data Tidak Di Temukan");
}
}
}
private void simpan_Click(object sender, EventArgs e)
{
if ((txt_no_rak.Text == "") || (txt_nama_barang.Text == "") || (txt_jumlah.Text == "") || (txt_harga_jual.Text == "") || (txt_harga.Text == ""))
{
MessageBox.Show("Data Kurang Lengkap");
}
else
{
data_barang db = new data_barang();
db.kd_barang = txt_kd_barang.Text;
db.nama_barang = txt_nama_barang.Text;
db.jenis_barang = jenis_barang.Text;
db.tgl_masuk = dt_tanggal_masuk.Value.ToString("yyyy-MM-dd");
db.tgl_exp = dt_exp.Value.ToString("yyyy-MM-dd");
db.no_rak = txt_no_rak.Text;
db.harga = Convert.ToDouble(txt_harga.Text);
db.harga_jual = Convert.ToDouble(txt_harga_jual.Text);
db.jumlah_masuk = Convert.ToInt16(txt_jumlah.Text);
string tgl_masuk = dt_tanggal_masuk.Value.ToString("yyyy-MM-dd");
string tgl_exp = dt_exp.Value.ToString("yyyy-MM-dd");
if (tgl_masuk == tgl_exp)
{
MessageBox.Show("Barang Sudah Kadaluarsa");
}
else if (new data_barang_dao().tambah_barang(db))
{
MessageBox.Show("Input Barang Sukses");
DialogResult dialogresult = MessageBox.Show("Apakah Anda Akan Menambahkan Data Lagi ? ", "Pesan", MessageBoxButtons.YesNo);
if (dialogresult == DialogResult.Yes)
{
txt_kd_barang.Text = "";
txt_kd_barang.Text = "";
txt_nama_barang.Text = "";
txt_jumlah.Text = "";
txt_harga_jual.Text = "";
txt_harga.Text = "";
dt_exp.Text = "";
txt_no_rak.Text = "";
jenis_barang.Text = "";
}
else
{
this.Close();
}
}
}
}
private void btn_update_Click(object sender, EventArgs e)
{
data_barang db = new data_barang();
db.kd_barang = txt_kd_barang.Text;
db._stock = Convert.ToInt16(stock.Text);
db.jumlah_masuk = Convert.ToInt16(txt_jumlah.Text);
if (new data_barang_dao().update_data(db))
{
MessageBox.Show("Update Data Barang Sukses");
}
}
private void btn_ubah_Click(object sender, EventArgs e)
{
data_barang db = new data_barang();
db.kd_barang = txt_kd_barang.Text;
db.nama_barang = txt_nama_barang.Text;
db.jenis_barang = cb_jenis_barang.Text;
db.harga_jual = Convert.ToDouble(txt_hrg_jual.Text);
if (new data_barang_dao().update_barang(db))
{
MessageBox.Show("Data Berhasil Di Ubah");
binding();
}
}
public bool tambah_barang(data_barang db)
{
bool stat = false;
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "INSERT INTO tb_barang VALUES ('" + db.kd_barang + "'," + "'" + db.nama_barang + "'," + "'" + db.jenis_barang + "'," + "'" + db.jumlah_masuk + "'," + "'" + db.tgl_masuk + "'," + "'" + db.tgl_exp + "'," + "'" + db.no_rak + "'," + "'" + db.harga + "'," + "'" + db.harga + "'," + "'" + db.harga_jual + "')";
query.ExecuteNonQuery();
stat = true;
return(stat);
}
public bool tambah_stock_barang(data_barang db)
{
bool stat = false;
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "UPDATE tb_barang " + " SET stock = '" + db.stock + "'," + " tgl_masuk = '" + db.tgl_masuk + "'," + " tgl_exp = '" + db.tgl_exp + "' " + " WHERE kd_barang = '" + db.kd_barang + "'";
query.ExecuteNonQuery();
stat = true;
conn.Close();
return(stat);
}
public DataSet cari_jenis_barang(data_barang db)
{
DataSet ds = new DataSet();
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "SELECT * FROM tb_barang WHERE jenis_barang = '" + db.jenis_barang + "'";
MySqlDataAdapter data = new MySqlDataAdapter(query);
data.Fill(ds, "tb_barang");
conn.Close();
return(ds);
}
public bool hapus_data_barang(data_barang db)
{
bool stat = false;
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "DELETE FROM tb_barang WHERE kd_barang = '" + db.kd_barang + "'";
query.ExecuteNonQuery();
stat = true;
conn.Close();
return(stat);
}
public bool update_barang_keluar(data_barang db)
{
bool stat = false;
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
query.CommandText = "UPDATE tb_barang " + " SET stock = '" + db.stock_brg() + "' WHERE kd_barang = '" + db.kd_barang + "' ";
query.ExecuteNonQuery();
stat = true;
conn.Close();
return(stat);
}
public bool update_barang(data_barang db)
{
bool stat = false;
conn.Open();
MySqlCommand query = new MySqlCommand();
query.Connection = conn;
//query.CommandText = "UPDATE t_mahasiswa " + "SET nama ='" + m.nama + "'," + "ttl ='" + m.tempatlahir + "'," + "tgl = '" + m.tgllahir + "'," + "alamat = '" + m.alamat + "'" + " WHERE nim = '" + m.nim + "'";
query.CommandText = "UPDATE tb_barang " + "SET nama_barang = '" + db.nama_barang + "'," + "jenis_barang = '" + db.jenis_barang + "'," + " harga_jual = '" + db.harga_jual + "' " + " WHERE kd_barang = '" + db.kd_barang + "' ";
query.ExecuteNonQuery();
stat = true;
conn.Close();
return(stat);
}
private void btn_hapus_Click(object sender, EventArgs e)
{
if (txt_kd_barang.Text == "")
{
MessageBox.Show("Kode Barang Kosong", "Pesan", MessageBoxButtons.OK);
}
DialogResult dialogresult = MessageBox.Show("Apakah Anda Akan Menghapus ", "Pesan", MessageBoxButtons.YesNo);
if (dialogresult == DialogResult.Yes)
{
data_barang db = new data_barang();
db.kd_barang = txt_kd_barang.Text;
if (new data_barang_dao().hapus_data_barang(db))
{
MessageBox.Show("Data Berhasil Di Hapus");
binding();
}
}
}
private void check_Click(object sender, EventArgs e)
{
if (txt_kd_barang.Text == "")
{
MessageBox.Show("Kode Barang Tidak Boleh Kosong");
}
else
{
data_barang db = new data_barang();
db.kd_barang = txt_kd_barang.Text;
DataSet ds = new data_barang_dao().cari_kode_barang(db);
//txtFname.Text = dsView.Tables[0].Rows[3][0].ToString();
try
{
btn_simpan.Hide();
btn_update.Show();
db.kd_barang = txt_kd_barang.Text;
txt_nama_barang.Text = ds.Tables[0].Rows[0][1].ToString();
txt_harga.Text = ds.Tables[0].Rows[0][8].ToString();
dt_tanggal_masuk.Text = ds.Tables[0].Rows[0][4].ToString();
dt_exp.Text = ds.Tables[0].Rows[0][5].ToString();
txt_no_rak.Text = ds.Tables[0].Rows[0][6].ToString();
txt_harga_jual.Text = ds.Tables[0].Rows[0][9].ToString();
jenis_barang.Text = ds.Tables[0].Rows[0][2].ToString();
stock.Text = ds.Tables[0].Rows[0][3].ToString();
}
catch (Exception)
{
btn_simpan.Show();
btn_update.Hide();
MessageBox.Show("Data Tidak Di Temukan ");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
data_barang db = new data_barang();
db.kd_barang = txt_kd_barang.Text;
// db.tgl_exp = dt_exp.Value.ToString("yyyy-MM-dd");
db.tgl_masuk = dt_tgl_masuk.Value.ToString("yyyy-MM-dd");
db.tgl_exp = dt_tgl_exp.Value.ToString("yyyy-MM-dd");
string tgl_masuk = dt_tgl_masuk.Value.ToString("yyyy-MM-dd");
string tgl_exp = dt_tgl_exp.Value.ToString("yyyy-MM-dd");
db.stock = Convert.ToInt16(txt_stock_brg.Text);
if (tgl_masuk == tgl_exp)
{
MessageBox.Show("Barang Sudah Kadaluarsa");
}
else if (new data_barang_dao().tambah_stock_barang(db))
{
MessageBox.Show("Stock Barang berhasil Di Tambahkan", "Pesan");
}
}
private void btn_tambah_Click(object sender, EventArgs e)
{
// Cari Data
try
{
data_barang_keluar dbk = new data_barang_keluar();
data_barang db = new data_barang();
db.kd_barang = txt_kd_brg.Text;
DataSet ds = new data_barang_dao().cari_kode_barang(db);
lbl_nama.Text = ds.Tables[0].Rows[0][1].ToString();
// Proses
dbk.jumlah = Convert.ToInt16(txt_jumlah.Text);
string str_harga_jual = ds.Tables[0].Rows[0][9].ToString();
dbk.harga_jual = Convert.ToDouble(str_harga_jual);
lbl_total.Text = str_harga_jual;
// Input Data
dbk.kd_barang = txt_kd_brg.Text;
dbk.tanggal = dt_tangal.Value.ToString("yyyy-MM-dd");
dbk.jumlah = Convert.ToInt16(txt_jumlah.Text);
//Simpan barang Keluar
int stock_brg = Convert.ToInt16(ds.Tables[0].Rows[0][3].ToString());
db.stock = stock_brg;
db.jml_keluar = Convert.ToInt16(txt_jumlah.Text);
//ambil kode transaksi barang keluar
DataSet dk = new data_barang_keluar_dao().tampil_jmlah_data();
int jml_data = Convert.ToInt16(dk.Tables[0].Rows[0][0].ToString());
if (jml_data == 0)
{
txt_kd_berikut.Text = "1001";
}
else
{
int jml_dt = jml_data - 1;
DataSet kd_tr = new data_barang_keluar_dao().tampil_transaksi_barang_keluar();
string kd = kd_tr.Tables[0].Rows[jml_dt][0].ToString();
int kd_berikut;
kd_berikut = Convert.ToInt16(kd_tr.Tables[0].Rows[jml_dt][0].ToString()) + 1;
txt_kd_berikut.Text = Convert.ToString(kd_berikut);
}
dbk.kode_transaksi = txt_kd_berikut.Text;
if (new data_barang_keluar_dao().input_temp_keluar(dbk))
{
DataSet dt = new data_barang_keluar_dao().total_harga();
lbl_total.Text = dt.Tables[0].Rows[0][0].ToString();
if (new data_barang_dao().update_barang_keluar(db))
{
}
}
binding();
txt_kd_brg.Text = "";
txt_jumlah.Text = "";
}
catch
{
MessageBox.Show("Kode Barang Kosong");
}
}
private void btn_cek_Click(object sender, EventArgs e)
{
btn_tambah.Show();
if (rd_kosong.Checked)
{
DataSet ds = new data_barang_dao().tampildatabarang_kosong();
dgv_data_barang.DataSource = ds;
dgv_data_barang.DataMember = "db_indomart";
eventclickgrid();
DataGridViewColumn kolom0 = dgv_data_barang.Columns[0];
kolom0.Width = 100;
kolom0.HeaderText = "Kode Barang";
DataGridViewColumn kolom1 = dgv_data_barang.Columns[1];
kolom1.Width = 150;
kolom1.HeaderText = "Nama Barang";
DataGridViewColumn kolom2 = dgv_data_barang.Columns[2];
kolom2.Width = 150;
kolom2.HeaderText = "Jenis Barang";
DataGridViewColumn kolom3 = dgv_data_barang.Columns[3];
kolom3.Width = 120;
kolom3.HeaderText = "Stock Barang";
DataGridViewColumn kolom4 = dgv_data_barang.Columns[4];
kolom4.Width = 120;
kolom4.HeaderText = "Tanggal Masuk";
DataGridViewColumn kolom5 = dgv_data_barang.Columns[5];
kolom5.Width = 140;
kolom5.HeaderText = "Tanggal Expire Date";
DataGridViewColumn kolom6 = dgv_data_barang.Columns[6];
kolom6.Width = 120;
kolom6.HeaderText = "Nomor Rak";
DataGridViewColumn kolom7 = dgv_data_barang.Columns[7];
kolom7.Width = 120;
kolom7.HeaderText = "Harga";
DataGridViewColumn kolom8 = dgv_data_barang.Columns[8];
kolom8.Width = 130;
kolom8.HeaderText = "Harga Akhir";
DataGridViewColumn kolom9 = dgv_data_barang.Columns[9];
kolom9.Width = 130;
kolom9.HeaderText = "Harga Akhir";
}
else if (rd_kadaluarsa.Checked)
{
btn_tambah.Hide();
data_barang db = new data_barang();
db.tgl_sekarang = dtp_tanggal.Value.ToString("yyyy-MM-dd");
DataSet ds = new data_barang_dao().cari_barang_kadaluarsa(db);
dgv_data_barang.DataSource = ds;
dgv_data_barang.DataMember = "tb_barang";
eventclickgrid();
DataGridViewColumn kolom0 = dgv_data_barang.Columns[0];
kolom0.Width = 100;
kolom0.HeaderText = "Kode Barang";
DataGridViewColumn kolom1 = dgv_data_barang.Columns[1];
kolom1.Width = 150;
kolom1.HeaderText = "Nama Barang";
DataGridViewColumn kolom2 = dgv_data_barang.Columns[2];
kolom2.Width = 150;
kolom2.HeaderText = "Jenis Barang";
DataGridViewColumn kolom3 = dgv_data_barang.Columns[3];
kolom3.Width = 120;
kolom3.HeaderText = "Stock Barang";
DataGridViewColumn kolom4 = dgv_data_barang.Columns[4];
kolom4.Width = 120;
kolom4.HeaderText = "Tanggal Masuk";
DataGridViewColumn kolom5 = dgv_data_barang.Columns[5];
kolom5.Width = 140;
kolom5.HeaderText = "Tanggal Expire Date";
DataGridViewColumn kolom6 = dgv_data_barang.Columns[6];
kolom6.Width = 120;
kolom6.HeaderText = "Nomor Rak";
DataGridViewColumn kolom7 = dgv_data_barang.Columns[7];
kolom7.Width = 120;
kolom7.HeaderText = "Harga";
DataGridViewColumn kolom8 = dgv_data_barang.Columns[8];
kolom8.Width = 130;
kolom8.HeaderText = "Harga Akhir";
DataGridViewColumn kolom9 = dgv_data_barang.Columns[9];
kolom9.Width = 130;
kolom9.HeaderText = "Harga Akhir";
}
else
{
btn_tambah.Hide();
MessageBox.Show("Pilih Salah Satu Pilihan");
}
}
