private void btnConfirm_Click(object sender, EventArgs e)
{
if (tbId.Enabled == false)
{
Koneksi.openConn();
cmd = new MySqlCommand("update supplier set nama_supplier = '" + tbNama.Text + "', alamat_supplier = '" + tbAlamat.Text + "', kota_supplier = '" + tbKota.Text + "' where id_supplier='" + tbId.Text + "' ", Koneksi.conn);
cmd.ExecuteNonQuery();
btnCancel.Enabled = false;
btnConfirm.Enabled = false;
disabletextbox();
Koneksi.conn.Close();
}
else if (tbId.Text != "" && tbNama.Text != "" && tbAlamat.Text != "" && tbKota.Text != "" && tbId.TextLength == 4)
{
Koneksi.openConn();
cmd = new MySqlCommand("insert into supplier values('" + tbId.Text + "','" + tbNama.Text + "','" + tbAlamat.Text + "','" + tbKota.Text + "')", Koneksi.conn);
cmd.ExecuteNonQuery();
disabletextbox();
btnCancel.Enabled = false; btnConfirm.Enabled = false;
btnNew.Enabled = true;
kosongitextbox();
this.ActiveControl = btnNew;
Koneksi.conn.Close();
}
else
{
MessageBox.Show("Data Belum Lengkap");
}
btnConfirm.Enabled = false;
refreshlist();
}
private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
if (checkBox1.Checked == true)
{
status = "1";
}
else
{
status = "0";
}
Koneksi.openConn();
da = new MySqlDataAdapter("select h.id_beli as Nomer, b.tanggaljatuhtempo as \"Jatuh Tempo\", s.nama_supplier as Supplier ,format(h.total,0,'de_DE') as Total from hutang h, beli b, supplier s where h.id_beli = b.id_beli and h.status='" + status + "' and h.id_supplier = s.id_supplier order by b.tanggaljatuhtempo asc,Nomer desc", Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
DataGridViewColumn col;
col = dataGridView1.Columns[0]; col.Width = 80;
col = dataGridView1.Columns[1]; col.Width = 75;
col = dataGridView1.Columns[2]; col.Width = 200;
col = dataGridView1.Columns[3]; col.Width = 120;
col = dataGridView1.Columns[3]; col.Width = 100; dataGridView1.Columns["Total"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Koneksi.conn.Close();
count();
}
private void button1_Click(object sender, EventArgs e)
{
Koneksi.openConn();
string user = textBox1.Text;
string pass = textBox2.Text;
string passdb = "";
sql = "select password_user from user where nama_user='******'";
try
{
cmd = new MySqlCommand(sql, Koneksi.conn);
passdb = cmd.ExecuteScalar().ToString();
if (passdb == pass)
{
sql = "select pangkat from user where nama_user='******'";
cmd = new MySqlCommand(sql, Koneksi.conn);
string pangkat = cmd.ExecuteScalar().ToString();
MdiParent f = new MdiParent();
f.Show();
}
else
{
MessageBox.Show("Password Salah");
}
}
catch (Exception)
{
MessageBox.Show("User Salah");
}
Koneksi.conn.Close();
}
private void FormPromo_Load(object sender, EventArgs e)
{
Koneksi.openConn();
loadnamapromo();
this.ActiveControl = cbSearch;
Koneksi.conn.Close();
}
private void cbBarang_TextChanged(object sender, EventArgs e)
{
try
{
Koneksi.openConn();
//this.ActiveControl = tbJumlah;
sql = "select id_barang from barang where nama_barang='" + cbBarang.Text + "'";
cmd = new MySqlCommand(sql, Koneksi.conn);
string id = cmd.ExecuteScalar().ToString();
tbKodeBarang.Text = id;
Koneksi.conn.Close();
Koneksi.openConn();
sql = "select satuan_barang from barang where id_barang='" + tbKodeBarang.Text + "'";
cmd = new MySqlCommand(sql, Koneksi.conn);
string satuan = cmd.ExecuteScalar().ToString();
tbSatuan.Text = satuan;
Koneksi.conn.Close();
Koneksi.openConn();
cmd = new MySqlCommand("select hpp from hpp where id_barang='" + tbKodeBarang.Text + "'", Koneksi.conn);
tbHarga.Text = cmd.ExecuteScalar().ToString();
Koneksi.conn.Close();
}
catch (Exception x)
{}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (tbIDPromo.Text != "")
{
activate(); loadbarang();
string idpromo = tbIDPromo.Text;
tbNamaPromo.Text = cbSearch.Text;
isidatagrid.Clear();
cbSearch.Enabled = false; cbSearch.Text = "";
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
string nama = dataGridView1.Rows[i].Cells[0].Value.ToString();
string jumlah = dataGridView1.Rows[i].Cells[1].Value.ToString();
string kemasan = dataGridView1.Rows[i].Cells[2].Value.ToString();
string poin = dataGridView1.Rows[i].Cells[3].Value.ToString();
isidatagrid.Add(nama + "-" + jumlah + "-" + kemasan + "-" + poin);
}
Koneksi.openConn();
cmd = new MySqlCommand("delete from dpromo where id_promo='" + idpromo + "'", Koneksi.conn);
cmd.ExecuteNonQuery();
Koneksi.conn.Close();
cbStart.Enabled = true; cbEnd.Enabled = true; cbYear.Enabled = true;
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
activate(); loadbarang(); btnCancel.Enabled = false;
string nonota = tbKodeBeli1.Text + "-" + tbKodeBeli2.Text;
Koneksi.openConn();
cmd = new MySqlCommand("select nama_barang,jumlah_barang from dbeli where id_beli='" + nonota + "'", Koneksi.conn);
dr = cmd.ExecuteReader();
List <string> namabarang = new List <string>();
List <string> qty = new List <string>();
while (dr.Read())
{
namabarang.Add(dr.GetString(0));
qty.Add(dr.GetString(1));
}
Koneksi.conn.Close();
Koneksi.openConn();
for (int i = 0; i < namabarang.Count; i++)
{
cmd = new MySqlCommand("select id_barang from barang where nama_barang='" + namabarang[i] + "'", Koneksi.conn);
string idbarang = cmd.ExecuteScalar().ToString();
int change = Convert.ToInt32(qty[i]);
cmd = new MySqlCommand("update stok set masuk=masuk-" + change + ", stok=stok-" + change + " where id_barang='" + idbarang + "'", Koneksi.conn);
cmd.ExecuteNonQuery();
}
Koneksi.conn.Close();
Koneksi.openConn();
cmd = new MySqlCommand("delete from dbeli where id_beli='" + nonota + "'", Koneksi.conn);
cmd.ExecuteNonQuery();
cmd = new MySqlCommand("delete from beli where id_beli='" + nonota + "'", Koneksi.conn);
cmd.ExecuteNonQuery();
Koneksi.conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (textBox1.Text != "")
{
Koneksi.openConn();
sql = "select count(*) from kategori";
cmd = new MySqlCommand(sql, Koneksi.conn);
string temp = cmd.ExecuteScalar().ToString();
int urutan = Convert.ToInt32(temp) + 1;
string kodekategori = urutan.ToString().PadLeft(4, '0');
cmd = new MySqlCommand("insert into kategori values('" + kodekategori + "','" + textBox1.Text + "')", Koneksi.conn);
cmd.ExecuteNonQuery();
da = new MySqlDataAdapter("select nama_kategori as \"Nama Kategori\" from kategori", Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
col = dataGridView1.Columns[0]; col.Width = 150;
textBox1.Text = "";
this.ActiveControl = textBox1;
Koneksi.conn.Close();
}
else
{
MessageBox.Show("Kategori Tidak Boleh Kosong");
}
}
catch (Exception x)
{}
}
private void btnCancel_Click(object sender, EventArgs e)
{
deactivate(); clearDatagrid();
if (tbIDPromo.Text != "")
{
for (int i = 0; i < isidatagrid.Count; i++)
{
string[] temp = isidatagrid[i].Split('-');
dataGridView1.Rows.Add(temp[0], temp[1], temp[2], temp[3]);
}
Koneksi.openConn();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
cmd = new MySqlCommand("select id_barang from barang where nama_barang='" + dataGridView1.Rows[i].Cells[0].Value.ToString() + "'", Koneksi.conn);
string namabarang = cmd.ExecuteScalar().ToString();
cmd = new MySqlCommand("insert into dpromo values('" + tbIDPromo.Text + "','" + namabarang + "','" + dataGridView1.Rows[i].Cells[1].Value.ToString() + "','" + dataGridView1.Rows[i].Cells[3].Value.ToString() + "')", Koneksi.conn);
cmd.ExecuteNonQuery();
}
Koneksi.conn.Close();
cbSearch.Text = tbNamaPromo.Text;
tbNamaPromo.Text = "";
deactivate();
}
else
{
tbKodeBarang.Text = ""; cbBarang.Text = "";
tbJumlah.Text = "0"; tbPoin.Text = "0";
tbIDPromo.Text = ""; tbNamaPromo.Text = "";
btnNew.Enabled = true; btnEdit.Enabled = true;
btnDelete.Enabled = true; btnFind.Enabled = true;
updating = false;
cbSearch.Enabled = true;
this.ActiveControl = btnNew;
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
Koneksi.openConn();
if (cbBarang.Text != "")
{
dataGridView1.DataSource = null;
dataGridView1.Refresh();
da = new MySqlDataAdapter("select b.tanggal as Tanggal, b.kode as Kode, b.id_beli as \"Nomer Nota\", s.nama_supplier as \"Customer/Supplier\", format(db.jumlah_barang,0,'de_DE') as Jumlah from beli b,supplier s,dbeli db where b.tanggal>='" + dtStart.Value.ToString("dd-MM-yy") + "' and b.tanggal<='" + dtEnd.Value.ToString("dd-MM-yy") + "' and b.kode=db.kode and b.id_beli=db.id_beli and b.id_supplier=s.id_supplier and db.nama_barang='" + cbBarang.Text + "' " +
"union " +
"select j.tanggal as Tanggal, j.kode as Kode, j.id_jual as \"Nomer Nota\", c.nama_customer as \"Customer/Supplier\", concat('-',format(dj.jumlah_barang,0,'de_DE')) as Jumlah from jual j,djual dj,customer c where j.tanggal>='" + dtStart.Value.ToString("dd-MM-yy") + "' and j.tanggal<='" + dtEnd.Value.ToString("dd-MM-yy") + "' and j.kode=dj.kode and j.id_jual=dj.id_jual and j.id_customer=c.id_customer and dj.nama_barang='" + cbBarang.Text + "' " +
"union" +
" select k.tanggal as Tanggal, k.kode, k.id_nota, 'Supervisor', dk.jumlah from koreksistok k, dkoreksistok dk, barang b where k.id_nota=dk.id_nota and b.id_barang=dk.id_barang and b.nama_barang='" + cbBarang.Text + "' and k.tanggal>='" + dtStart.Value.ToString("dd-MM-yy") + "' and k.tanggal<='" + dtEnd.Value.ToString("dd-MM-yy") + "' order by Tanggal", Koneksi.conn);
//da = new MySqlDataAdapter("select j.tanggal as Tanggal,j.kode as Kode, j.id_jual as \"Nomer Nota\", c.nama_customer as \"Customer/Supplier\", concat('-',format(dj.jumlah_barang,0,'de_DE')) as Jumlah from jual j,djual dj,customer c where j.tanggal>='" + dtStart.Value.ToString("dd-MM-yy") + "' and j.tanggal<='" + dtEnd.Value.ToString("dd-MM-yy") + "' and j.kode=dj.kode and j.id_jual=dj.id_jual and j.id_customer=c.id_customer and dj.nama_barang='" + cbBarang.Text + "' union select b.tanggal as Tanggal, b.kode as Kode, b.id_beli as \"Nomer Nota\", s.nama_supplier as \"Customer/Supplier\", format(db.jumlah_barang,0,'de_DE') as Jumlah from beli b,supplier s,dbeli db where b.tanggal>='" + dtStart.Value.ToString("dd-MM-yy") + "' and b.tanggal<='" + dtEnd.Value.ToString("dd-MM-yy") + "' and b.kode=db.kode and b.id_beli=db.id_beli and b.id_supplier=s.id_supplier and db.nama_barang='" + cbBarang.Text + "' union select k.tanggal as Tanggal, k.kode, k.id_nota, 'Supervisor', dk.jumlah from koreksistok k, dkoreksistok dk, barang b where k.id_nota=dk.id_nota and b.id_barang=dk.id_barang and b.nama_barang='" + cbBarang.Text + "' and k.tanggal>='" + dtStart.Value.ToString("dd-MM-yy") + "' and k.tanggal<='" + dtEnd.Value.ToString("dd-MM-yy") + "' order by Tanggal", Koneksi.conn);
//da = new MySqlDataAdapter("select j.tanggal as Tanggal,j.kode as Kode, j.id_jual, c.nama_customer, concat('-',format(dj.jumlah_barang,0,'de_DE')) as Jumlah from jual j,djual dj,customer c where j.tanggal between '"+dtStart.Value.ToString("yyyy-MM-dd")+"' and '"+dtEnd.Value.ToString("yyyy-MM-dd")+"' and j.kode=dj.kode and j.id_customer=c.id_customer and dj.nama_barang='Avian Cat Kayu 1 kg';", Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
DataGridViewColumn col;
col = dataGridView1.Columns[0]; col.Width = 65;
col = dataGridView1.Columns[1]; col.Width = 45;
col = dataGridView1.Columns[2]; col.Width = 80;
col = dataGridView1.Columns[3]; col.Width = 170;
col = dataGridView1.Columns[4]; col.Width = 60;
col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
Koneksi.conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
string search = textBox1.Text;
loadlistbarang();
Koneksi.openConn();
if (comboBox1.Text == "ID")
{
da = new MySqlDataAdapter("select b.id_barang as \"ID Barang\", b.nama_barang as \"Nama Barang\", format(s.stok,0,'de_DE') as Stok, b.satuan_barang as Satuan, format(b.harga_barang,0,'de_DE') as Harga, b.nama_kategori as \"Nama Kategori\", b.deskripsi as Deskripsi, b.status as Status, format(h.hpp,0,'de_DE') as HPP from barang b, stok s, hpp h where b.id_barang=h.id_barang and s.id_barang=b.id_barang and b.id_barang like '%" + search + "%' and b.status='Aktif'", Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
else if (comboBox1.Text == "NAMA")
{
da = new MySqlDataAdapter("select b.id_barang as \"ID Barang\", b.nama_barang as \"Nama Barang\", format(s.stok,0,'de_DE') as Stok, b.satuan_barang as Satuan, format(b.harga_barang,0,'de_DE') as Harga, b.nama_kategori as \"Nama Kategori\", b.deskripsi as Deskripsi, b.status as Status, format(h.hpp,0,'de_DE') as HPP from barang b, stok s, hpp h where b.id_barang=h.id_barang and s.id_barang=b.id_barang and b.nama_barang like '%" + search + "%' and b.status='Aktif' ", Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
else if (comboBox1.Text == "KATEGORI")
{
try
{
da = new MySqlDataAdapter("select b.id_barang as \"ID Barang\", b.nama_barang as \"Nama Barang\", format(s.stok,0,'de_DE') as Stok, b.satuan_barang as Satuan, format(b.harga_barang,0,'de_DE') as Harga, b.nama_kategori as \"Nama Kategori\", b.deskripsi as Deskripsi, b.status as Status, format(h.hpp,0,'de_DE') as HPP from barang b, stok s, hpp h where b.id_barang=h.id_barang and s.id_barang=b.id_barang and b.nama_kategori='" + textBox1.Text + "' and b.status='Aktif' ", Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
catch (Exception x)
{}
}
settingdatagrid();
Koneksi.conn.Close();
}
private void btnSave_Click(object sender, EventArgs e)
{
string tglnow = tbTanggal.Text;
string[] splittgl = tglnow.Split('-');
string insertedtanggal = splittgl[2] + "-" + splittgl[1] + "-" + splittgl[0];
//insert into table koreksistok
Koneksi.openConn();
cmd = new MySqlCommand("insert into koreksistok values('AS','" + tbKodeNota1.Text + "-" + tbKodeNota2.Text + "','" + insertedtanggal + "','" + tbKeterangan.Text + "')", Koneksi.conn);
cmd.ExecuteNonQuery();
Koneksi.conn.Close();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
string namabarang = dataGridView1.Rows[i].Cells[0].Value.ToString();
string jumlah = dataGridView1.Rows[i].Cells[1].Value.ToString();
//get id barang per item
Koneksi.openConn();
cmd = new MySqlCommand("select id_barang from barang where nama_barang='" + namabarang + "'", Koneksi.conn);
string idbarang = cmd.ExecuteScalar().ToString();
Koneksi.conn.Close();
//insert into table dkoreksistok
Koneksi.openConn();
cmd = new MySqlCommand("insert into dkoreksistok values('" + tbKodeNota1.Text + "-" + tbKodeNota2.Text + "','" + idbarang + "','" + jumlah + "')", Koneksi.conn);
cmd.ExecuteNonQuery();
Koneksi.conn.Close();
//update table stok
int stok, masuk, keluar;
if (Convert.ToInt32(jumlah) < 0)
{
//masuk penjualan & update keluar
Koneksi.openConn();
int qty = Convert.ToInt32(jumlah) * -1;
cmd = new MySqlCommand("update stok set keluar=keluar+'" + qty + "' where id_barang='" + idbarang + "'", Koneksi.conn);
cmd.ExecuteNonQuery();
Koneksi.conn.Close();
}
else
{
//masuk pembelian & update masuk
Koneksi.openConn();
cmd = new MySqlCommand("update stok set masuk=masuk+'" + jumlah + "' where id_barang='" + idbarang + "'", Koneksi.conn);
cmd.ExecuteNonQuery();
Koneksi.conn.Close();
}
//ganti stok
Koneksi.openConn();
cmd = new MySqlCommand("update stok set stok=stok+'" + jumlah + "' where id_barang='" + idbarang + "'", Koneksi.conn);
cmd.ExecuteNonQuery();
Koneksi.conn.Close();
//deactivate
deactivate();
cleardatagrid();
}
}
private void cbBarang_TextChanged(object sender, EventArgs e)
{
try
{
Koneksi.openConn();
tbDiskon1.Text = "0.00"; tbDiskon2.Text = "0.00";
this.ActiveControl = tbJumlah;
sql = "select id_barang from barang where nama_barang='" + cbBarang.Text + "'";
cmd = new MySqlCommand(sql, Koneksi.conn);
string id = cmd.ExecuteScalar().ToString();
tbKodeBarang.Text = id;
sql = "select harga_barang from barang where id_barang='" + tbKodeBarang.Text + "'";
cmd = new MySqlCommand(sql, Koneksi.conn);
string harga = cmd.ExecuteScalar().ToString();
tbHarga.Text = harga;
sql = "select satuan_barang from barang where id_barang='" + tbKodeBarang.Text + "'";
cmd = new MySqlCommand(sql, Koneksi.conn);
string satuan = cmd.ExecuteScalar().ToString();
tbSatuan.Text = satuan;
string[] temp = tbHarga.Text.Split('.');
string gabungan = "";
foreach (string a in temp)
{
gabungan = gabungan + a;
}
hitungtotalperbarang(tbJumlah.Text, gabungan, tbDiskon1.Text, tbDiskon2.Text);
Koneksi.conn.Close();
}
catch (Exception x)
{
}
}
public void generatekodejual(string jenis, string tahunbulan)
{
DateTime date = DateTime.Now;
string tanggal = date.Day.ToString();
string bulan = date.Month.ToString();
string tahun = date.Year.ToString();
tanggal = tanggal.PadLeft(2, '0');
bulan = bulan.PadLeft(2, '0');
string thn = tahun.Substring(2, 2);
string tanggalfull = tanggal + "-" + bulan + "-" + thn;
tbTanggal.Text = tanggalfull;
tbKodeJual1.Text = thn + bulan;
Koneksi.openConn();
sql = "select count(*) from jual where kode='" + jenis + "' and substr(id_jual,1,4)='" + tahunbulan + "';";
cmd = new MySqlCommand(sql, Koneksi.conn);
string temp = cmd.ExecuteScalar().ToString();
Koneksi.conn.Close();
int urutan = Convert.ToInt32(temp) + 1;
string kodejual = urutan.ToString().PadLeft(4, '0');
tbKodeJual2.Text = kodejual;
tbKodeJual.Text = jenis;
}
private void btnCount_Click(object sender, EventArgs e)
{
string tahun = cbTahun.Text;
string start = cbStart.Text;
//declare datatable
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Nama", typeof(string)));
dt.Columns.Add(new DataColumn("Nomer", typeof(string)));
dt.Columns.Add(new DataColumn("Total", typeof(Int32)));
dt.Columns.Add(new DataColumn("Tanggal", typeof(DateTime)));
Koneksi.openConn();
cmd = new MySqlCommand("select s.nama_supplier as Nama, h.id_beli as ID, h.total, b.tanggaljatuhtempo as Tanggal from hutang h, supplier s, beli b where h.id_supplier=s.id_supplier and b.id_beli=h.id_beli and tanggal>='01-" + start + "-" + tahun + "' and tanggal<='31-" + start + "-" + tahun + "' order by Nama asc, ID asc", Koneksi.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
dt.Rows.Add(dr.GetString(0), dr.GetString(1), dr.GetString(2), dr.GetString(3));
}
Koneksi.conn.Close();
LaporanHutang lh = new LaporanHutang();
lh.Database.Tables["Piutang"].SetDataSource(dt);
lh.SetParameterValue("start", Function.getMonth(start));
lh.SetParameterValue("tahun", "20" + tahun);
ReportViewer v = new ReportViewer();
v.crvTransaksi.ReportSource = null;
v.crvTransaksi.ReportSource = lh;
v.Show();
}
private void cbSearch_TextChanged(object sender, EventArgs e)
{
try
{
Koneksi.openConn();
cmd = new MySqlCommand("select id_promo from promo where nama='" + cbSearch.Text + "' ", Koneksi.conn);
tbIDPromo.Text = cmd.ExecuteScalar().ToString();
Koneksi.conn.Close();
Koneksi.openConn();
da = new MySqlDataAdapter("select b.nama_barang as \"Nama Barang\", d.jumlah as Jumlah,b.satuan_barang as Satuan ,d.poin as Poin from barang b, dpromo d where d.id_barang=b.id_barang and d.id_promo='" + tbIDPromo.Text + "'", Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
clearDatagrid();
settingdatagrid();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
dataGridView1.Rows.Add(ds.Tables[0].Rows[i][0].ToString(), ds.Tables[0].Rows[i][1].ToString(), ds.Tables[0].Rows[i][2].ToString(), ds.Tables[0].Rows[i][3].ToString());
}
Koneksi.conn.Close();
Koneksi.openConn();
cmd = new MySqlCommand("select * from promo where id_promo='" + tbIDPromo.Text + "'", Koneksi.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
tbPeriodePromo.Text = dr.GetString(2) + " - " + dr.GetString(3) + ", " + dr.GetString(4);
cbStart.Text = dr.GetString(2);
cbEnd.Text = dr.GetString(3);
cbYear.Text = dr.GetString(4);
}
Koneksi.conn.Close();
}
catch (Exception x)
{}
}
private void button1_Click(object sender, EventArgs e)
{
button1.Enabled = false; btnUpdate.Enabled = false;
Koneksi.openConn();
cmd = new MySqlCommand("delete from user where nama_user='******'", Koneksi.conn);
cmd.ExecuteNonQuery();
Koneksi.conn.Close();
load();
}
public void load()
{
Koneksi.openConn();
da = new MySqlDataAdapter("select nama_user as Username, password_user as Pass, pangkat as Pangkat from user", Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
Koneksi.conn.Close();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
btnUpdate.Enabled = false; button1.Enabled = false;
Koneksi.openConn();
cmd = new MySqlCommand("update user set password_user ='******', nama_user='******' where nama_user='******'", Koneksi.conn);
cmd.ExecuteNonQuery();
Koneksi.conn.Close();
load();
}
private void btnAdd_Click(object sender, EventArgs e)
{
Koneksi.openConn();
cmd = new MySqlCommand("insert into user values('" + tbUser.Text + "','" + tbPass.Text + "','" + tbPangkat.Text + "')", Koneksi.conn);
cmd.ExecuteNonQuery();
Koneksi.conn.Close();
button1.Enabled = false; btnUpdate.Enabled = false;
load();
}
private void tbId_TextChanged(object sender, EventArgs e)
{
if (tbId.TextLength == 4)
{
this.ActiveControl = tbNama;
}
Koneksi.openConn();
sql = "select nama_supplier from supplier where id_supplier='" + tbId.Text + "'";
cmd = new MySqlCommand(sql, Koneksi.conn);
try
{
string nama = cmd.ExecuteScalar().ToString();
lbStatus.Text = "Unavailable";
btnConfirm.Enabled = false;
}
catch (Exception)
{
lbStatus.Text = "Available";
btnConfirm.Enabled = true;
}
Koneksi.conn.Close();
if (FormFindSupplier.index != -1 && newbtn == false)
{
Koneksi.openConn();
cmd = new MySqlCommand("select * from supplier where id_supplier='" + tbId.Text + "'", Koneksi.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
tbNama.Text = dr.GetString(1);
tbAlamat.Text = dr.GetString(2);
tbKota.Text = dr.GetString(3);
}
Koneksi.conn.Close();
Koneksi.openConn();
try
{
cmd = new MySqlCommand("select sum(totalbeli) from beli where id_supplier='" + tbId.Text + "' group by id_supplier", Koneksi.conn);
tbTotalBeli.Text = Function.separator(cmd.ExecuteScalar().ToString());
}
catch (Exception)
{
tbTotalBeli.Text = "0";
}
Koneksi.conn.Close();
Koneksi.openConn();
try
{
cmd = new MySqlCommand("select sum(total) from hutang where id_supplier='" + tbId.Text + "' group by id_supplier", Koneksi.conn);
tbHutang.Text = Function.separator(cmd.ExecuteScalar().ToString());
}
catch (Exception)
{
tbHutang.Text = "0";
}
}
}
private void tbId_TextChanged(object sender, EventArgs e)
{
cekstatus();
if (FormFindBarang.index != -1 && newbarang == false)
{
try
{
Koneksi.openConn();
cmd = new MySqlCommand("select * from barang where id_barang='" + tbId.Text + "' ", Koneksi.conn);
MySqlDataReader dr;
dr = cmd.ExecuteReader();
string kategori = "";
while (dr.Read())
{
tbNama.Text = dr.GetString(1);
tbKemasan.Text = dr.GetString(2);
tbHarga.Text = dr.GetString(3);
kategori = dr.GetString(4);
tbDeskripsi.Text = dr.GetString(5);
}
cmd = new MySqlCommand("select nama_kategori from kategori where id_kategori='" + kategori + "'", Koneksi.conn);
cbKategori.Text = cmd.ExecuteScalar().ToString();
cmd = new MySqlCommand("select * from stok where id_barang='" + tbId.Text + "'", Koneksi.conn);
MySqlDataReader drr;
drr = cmd.ExecuteReader();
while (drr.Read())
{
tbMasuk.Text = drr.GetString(1);
tbKeluar.Text = drr.GetString(2);
tbStok.Text = drr.GetString(3);
}
Koneksi.conn.Close();
}
catch (Exception x)
{
}
}
else
{
Koneksi.openConn();
sql = "select nama_barang from barang where id_barang='" + tbId.Text + "'";
cmd = new MySqlCommand(sql, Koneksi.conn);
try
{
string nama = cmd.ExecuteScalar().ToString();
lbStatus.Text = "Unavailable";
btnConfirm.Enabled = false;
}
catch (Exception)
{
lbStatus.Text = "Available";
btnConfirm.Enabled = true;
}
Koneksi.conn.Close();
}
}
public void loaddata()
{
Koneksi.openConn();
da = new MySqlDataAdapter("select id_barang as \"ID Barang\", nama_barang as \"Nama Barang\", satuan_barang as Satuan, format(harga_barang,0,'de_DE') as Harga, nama_kategori as \"Nama Kategori\", deskripsi as Deskripsi, status as Status from barang where status='Tidak Aktif' order by id_barang", Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = null;
dataGridView1.DataSource = ds.Tables[0];
Koneksi.conn.Close();
}
private void btnConfirm_Click(object sender, EventArgs e)
{
Koneksi.openConn();
cmd = new MySqlCommand("update hpp set hpp='" + tbHpp.Text.Replace(".", "") + "' where id_barang='" + tbKodeBarang.Text + "'", Koneksi.conn);
cmd.ExecuteNonQuery();
cmd = new MySqlCommand("select hpp from hpp where id_barang='" + tbKodeBarang.Text + "'", Koneksi.conn);
tbHpp.Text = Function.separator(cmd.ExecuteScalar().ToString());
Koneksi.conn.Close();
MessageBox.Show("Berhasil Update");
}
private void DeletedPromo_Load(object sender, EventArgs e)
{
Koneksi.openConn();
da = new MySqlDataAdapter("select id_promo as ID, nama as Nama,start as Start,end as End, tahun as Tahun from promo where status='1'", Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = null;
dataGridView1.DataSource = ds.Tables[0];
Koneksi.conn.Close();
}
private void btnSearch_Click(object sender, EventArgs e)
{
Koneksi.openConn();
da = new MySqlDataAdapter("select p.kode as Kode, p.id_jual as Nomor, j.tanggaljatuhtempo as \"Jatuh Tempo\", c.nama_customer as Customer ,format(p.total,0,'de_DE') as Total, format(p.dibayarkan,0,'de_DE') as Dibayarkan from piutang p, jual j, customer c where p.kode = j.kode and p.id_jual = j.id_jual and p.id_customer = c.id_customer and p.status='" + status + "' and c.nama_customer like '%" + tbSearch.Text + "%' order by j.tanggaljatuhtempo asc,Nomor desc", Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
settingdatagrid();
Koneksi.conn.Close(); count();
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
string id = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
Koneksi.openConn();
cmd = new MySqlCommand("update barang set status='Aktif' where id_barang='" + id + "'", Koneksi.conn);
cmd.ExecuteNonQuery();
Koneksi.conn.Close();
loaddata();
}
private void FormNotaSupplier_Load(object sender, EventArgs e)
{
Koneksi.openConn();
da = new MySqlDataAdapter("select kode as Kode, id_beli as \"Nomer Nota\", tanggal as Tanggal, format(totalbeli,0,'de_DE') as Total from beli where id_supplier='" + FormSupplier.idsupp + "' order by id_beli desc", Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.Columns["Total"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Koneksi.conn.Close();
}
private void btnNew_Click(object sender, EventArgs e)
{
Koneksi.openConn();
enabletextbox();
kosongitextbox();
btnCancel.Enabled = true;
btnConfirm.Enabled = true;
this.ActiveControl = tbId;
Koneksi.conn.Close();
}
private void tbId_TextChanged(object sender, EventArgs e)
{
Koneksi.openConn();
sql = "select nama_customer from customer where id_customer='" + tbId.Text + "'";
cmd = new MySqlCommand(sql, Koneksi.conn);
try
{
string nama = cmd.ExecuteScalar().ToString();
lbStatus.Text = "Unavailable";
btnConfirm.Enabled = false;
}
catch (Exception)
{
lbStatus.Text = "Available";
btnConfirm.Enabled = true;
}
Koneksi.conn.Close();
if (FormFindCustomer.index != -1 && newbtn == false)
{
Koneksi.openConn();
cmd = new MySqlCommand("select * from customer where id_customer='" + tbId.Text + "'", Koneksi.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
tbNama.Text = dr.GetString(1);
tbAlamat.Text = dr.GetString(2);
tbKota.Text = dr.GetString(3);
tbStatus.Text = dr.GetString(4);
tbTelp.Text = dr.GetString(5);
}
Koneksi.conn.Close();
Koneksi.openConn();
try
{
cmd = new MySqlCommand("select sum(totaljual) from jual where id_customer='" + tbId.Text + "' group by id_customer", Koneksi.conn);
tbTotalBeli.Text = Function.separator(cmd.ExecuteScalar().ToString());
}
catch (Exception)
{
tbTotalBeli.Text = "0";
}
Koneksi.conn.Close();
Koneksi.openConn();
try
{
cmd = new MySqlCommand("select sum(total-dibayarkan) from piutang where id_customer='" + tbId.Text + "' group by id_customer", Koneksi.conn);
tbHutang.Text = Function.separator(cmd.ExecuteScalar().ToString());
}
catch (Exception)
{
tbHutang.Text = "0";
}
Koneksi.conn.Close();
}
}