private void FormFindBarang_Load(object sender, EventArgs e)
{
Koneksi.openConn();
comboBox1.SelectedIndex = 0;
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 hpp h, barang b, stok s where b.id_barang=h.id_barang and s.id_barang=b.id_barang and status='Aktif' order by b.id_barang", Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
Koneksi.conn.Close();
loadlistbarang();
settingdatagrid();
this.ActiveControl = comboBox1;
}
private void FormSupplier_Load(object sender, EventArgs e)
{
Koneksi.openConn();
this.ActiveControl = btnNew;
if (FormFindSupplier.index != -1)
{
tbId.Text = FormFindSupplier.listid[FormFindSupplier.index];
btnPrev.Enabled = true;
btnNext.Enabled = true;
btnEdit.Enabled = true;
}
Koneksi.conn.Close();
}
public void loaddatasupplier()
{
Koneksi.openConn();
listnamasupplier.Clear();
cmd = new MySqlCommand("select * from supplier", Koneksi.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
listnamasupplier.Add(dr.GetString(1));
}
cbSupplier.DataSource = listnamasupplier;
Koneksi.conn.Close();
}
public void loadkategori()
{
Koneksi.openConn();
cmd = new MySqlCommand("select nama_kategori from kategori", Koneksi.conn);
MySqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
listkategori.Add(dr.GetString(0));
}
cbKategori.DataSource = listkategori;
Koneksi.conn.Close();
}
private void button2_Click(object sender, EventArgs e)
{
Koneksi.openConn();
cmd = new MySqlCommand("update kategori set nama_kategori='" + textBox1.Text + "' where nama_kategori='" + nama + "'", Koneksi.conn);
cmd.ExecuteNonQuery();
button2.Enabled = false;
button1.Enabled = true;
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;
Koneksi.conn.Close();
}
private void cbBarang_TextChanged(object sender, EventArgs e)
{
try
{
Koneksi.openConn();
cmd = new MySqlCommand("select id_barang from barang where nama_barang='" + cbBarang.Text + "'", Koneksi.conn);
tbKodeBarang.Text = cmd.ExecuteScalar().ToString();
cmd = new MySqlCommand("select stok from stok where id_barang='" + tbKodeBarang.Text + "'", Koneksi.conn);
lbStok.Text = cmd.ExecuteScalar().ToString();
Koneksi.conn.Close();
}
catch (Exception x)
{}
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
Koneksi.openConn();
cmd = new MySqlCommand("update promo set status='0' where id_promo='" + dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString() + "'", Koneksi.conn);
cmd.ExecuteNonQuery();
Koneksi.conn.Close();
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();
}
public static void loadlistcustomer()
{
string stm = "select id_customer as \"ID\", nama_customer as Nama, alamat_customer as Alamat, kota_customer as Kota, status as Status from customer";
Koneksi.openConn();
MySqlCommand cmd = new MySqlCommand(stm, Koneksi.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
listid.Add(dr.GetString(0));
}
Koneksi.conn.Close();
}
private void btnDelete_Click(object sender, EventArgs e)
{
Koneksi.openConn();
cmd = new MySqlCommand("update barang set status='Tidak Aktif' where id_barang='" + tbId.Text + "'", Koneksi.conn);
cmd.ExecuteNonQuery();
Koneksi.conn.Close();
int ind = FormFindBarang.index;
FormFindBarang.listid.Clear();
FormFindBarang.loadlistbarang();
MessageBox.Show("Berhasil Menghapus Data");
tbId.Text = FormFindBarang.listid[ind];
FormFindBarang.index = ind;
}
public void isidatanota()
{
tbKodeBeli.Text = "B";
string temp = FormFindPembelian.listnonota[FormFindPembelian.index];
string[] nota = temp.Split('-');
tbKodeBeli1.Text = nota[0];
tbKodeBeli2.Text = nota[1];
Koneksi.openConn();
cmd = new MySqlCommand("select tanggal from beli where id_beli='" + temp + "'", Koneksi.conn);
string tanggal = cmd.ExecuteScalar().ToString();
tbTanggal.Text = tanggal;
Koneksi.conn.Close();
}
public static void loadlistbarang()
{
string stm = "select id_barang as \"ID Barang\", nama_barang as \"Nama Barang\", satuan_barang as Satuan, harga_barang as Harga, id_kategori as \"ID Kategori\", deskripsi as Deskripsi, status as Status from barang where status='Aktif' order by id_barang";
Koneksi.openConn();
MySqlCommand cmd = new MySqlCommand(stm, Koneksi.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
listid.Add(dr.GetString(0));
}
Koneksi.conn.Close();
}
public static void loadlistbarang()
{
string stm = "select b.id_barang as \"ID Barang\", b.nama_barang as \"Nama Barang\", 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, hpp h where b.id_barang=h.id_barang and status='Aktif' order by b.id_barang";
Koneksi.openConn();
MySqlCommand cmd = new MySqlCommand(stm, Koneksi.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
listid.Add(dr.GetString(0));
}
Koneksi.conn.Close();
}
private void FormDetailPembayaran_Load(object sender, EventArgs e)
{
try
{
Koneksi.openConn();
da = new MySqlDataAdapter("select kode as Kode, id_jual as \"Nomer Nota\",tanggal as Tanggal, format(dibayarkan,0,'de_DE') as Jumlah from dpiutang where kode='" + FormBayarPiutang.kodenota + "' and id_jual ='" + FormBayarPiutang.nonota + "' order by tanggal desc", Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.Columns["Jumlah"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Koneksi.conn.Close();
}
catch (Exception x)
{}
}
public static void loadlistsupplier()
{
string stm = "select id_supplier as ID, nama_supplier as Nama, alamat_supplier as Alamat, kota_supplier as Kota from supplier";
Koneksi.openConn();
MySqlCommand cmd = new MySqlCommand(stm, Koneksi.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
listid.Add(dr.GetString(0));
}
Koneksi.conn.Close();
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (tbIDPromo.Text != "")
{
DialogResult res = MessageBox.Show("Disabled Promo?", "Notice", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
Koneksi.openConn();
cmd = new MySqlCommand("update promo set status='1' where id_promo='" + tbIDPromo.Text + "'", Koneksi.conn);
cmd.ExecuteNonQuery();
Koneksi.conn.Close();
loadnamapromo();
}
}
}
public void loadnota(string jenis)
{
Koneksi.openConn();
listnota.Clear();
string stm = "select * from jual where kode='" + jenis + "' order by id_jual desc";
MySqlCommand cmd = new MySqlCommand(stm, Koneksi.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
listnota.Add(dr.GetString(1));
}
loaddetailnota(jenis, listnota[listnota.Count() - 1]);
Koneksi.conn.Close();
}
public void isidatanota()
{
tbKodeJual.Text = FormFindPenjualan.kode;
string temp = FormFindPenjualan.listnonota[FormFindPenjualan.index];
string[] temp2 = temp.Split('-');
tbKodeJual1.Text = temp2[0];
tbKodeJual2.Text = temp2[1];
Koneksi.openConn();
cmd = new MySqlCommand("select tanggal from jual where kode='" + FormFindPenjualan.kode + "' and id_jual='" + temp2[0] + "-" + temp2[1] + "'", Koneksi.conn);
string tanggal = cmd.ExecuteScalar().ToString();
tbTanggal.Text = tanggal;
Koneksi.conn.Close();
}
private void tbKodeCust_TextChanged(object sender, EventArgs e)
{
Koneksi.openConn();
try
{
sql = "select nama_customer from customer where id_customer='" + tbKodeCust.Text + "'";
cmd = new MySqlCommand(sql, Koneksi.conn);
string nama = cmd.ExecuteScalar().ToString();
cbCustomer.Text = nama;
//this.ActiveControl = tbKodeBarang;
}
catch (Exception x)
{
}
Koneksi.conn.Clone();
}
public void loaddatacustomer(string idcust)
{
Koneksi.openConn();
string stm = "select * from customer where id_customer='" + idcust + "'";
cmd = new MySqlCommand(stm, Koneksi.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
cbCustomer.Text = dr.GetString(1);
tbAlamat.Text = dr.GetString(2);
tbKota.Text = dr.GetString(3);
}
tbKodeCust.Text = idcust;
Koneksi.conn.Close();
}
private void FormFindPenjualan_Load(object sender, EventArgs e)
{
comboBox1.SelectedIndex = 0; comboBox2.SelectedIndex = 0;
string stm = "select kode as Kode, id_jual as \"Nomer Nota\", id_customer as \"Kode Customer\", tanggal as Tanggal, format(totaljual,0,'de_de') as Total from jual order by id_jual desc";
Koneksi.openConn();
da = new MySqlDataAdapter(stm, Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
loadnota(comboBox2.Text);
DataGridViewColumn col = dataGridView1.Columns[4];
col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
this.ActiveControl = comboBox2;
}
private void btnSearch_Click(object sender, EventArgs e)
{
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 and s.nama_supplier like '%" + tbSearch.Text + "%' 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 = 80; dataGridView1.Columns["Total"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Koneksi.conn.Close();
count();
}
public void loadbarang()
{
Koneksi.openConn();
listnamabarang.Clear();
string stm = "select * from barang order by nama_barang";
MySqlCommand cmd = new MySqlCommand(stm, Koneksi.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
listnamabarang.Add(dr.GetString(1));
}
Koneksi.conn.Close();
cbBarang.Text = "";
cbBarang.DataSource = listnamabarang;
}
private void Kategori_Load(object sender, EventArgs e)
{
this.ActiveControl = textBox1;
Koneksi.openConn();
try
{
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;
}
catch (Exception x)
{ MessageBox.Show(x.Message); }
Koneksi.conn.Close();
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (tbId.Enabled == false)
{
if (tbStatus.Text == "PJ" || tbStatus.Text == "LP")
{
Koneksi.openConn();
cmd = new MySqlCommand("update customer set nama_customer = '" + tbNama.Text + "', alamat_customer = '" + tbAlamat.Text + "', kota_customer = '" + tbKota.Text + "',telpon='" + tbTelp.Text + "', status = '" + tbStatus.Text + "' where id_customer='" + tbId.Text + "' ", Koneksi.conn);
cmd.ExecuteNonQuery();
btnCancel.Enabled = false;
btnConfirm.Enabled = false;
disabletextbox();
Koneksi.conn.Close();
}
else
{
MessageBox.Show("Status Harus Berisi PJ / LP");
}
}
else if (tbId.Text != "" && tbNama.Text != "" && tbAlamat.Text != "" && tbKota.Text != "" && tbStatus.Text != "" && tbId.TextLength == 4 && tbTelp.Text != "")
{
if (tbStatus.Text == "PJ" || tbStatus.Text == "LP")
{
Koneksi.openConn();
cmd = new MySqlCommand("insert into customer values('" + tbId.Text + "','" + tbNama.Text + "','" + tbAlamat.Text + "','" + tbKota.Text + "','" + tbStatus.Text + "', '" + tbTelp.Text + "')", Koneksi.conn);
cmd.ExecuteNonQuery();
disabletextbox();
btnCancel.Enabled = false;
btnConfirm.Enabled = false;
btnNew.Enabled = true;
kosongitextbox();
this.ActiveControl = btnNew;
Koneksi.conn.Close();
btnConfirm.Enabled = false;
}
else
{
MessageBox.Show("Status Customer Hanya PJ / LP");
}
}
else
{
MessageBox.Show("Data Belum Lengkap");
btnConfirm.Enabled = true;
}
refreshlist(); newbtn = false;
}
public void loadnamapromo()
{
Koneksi.openConn();
listnamapromo.Clear();
cmd = new MySqlCommand("select nama from promo where status='0'", Koneksi.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
listnamapromo.Add(dr.GetString(0));
}
Koneksi.conn.Close();
cbSearch.Text = "";
cbSearch.Items.Clear();
cbSearch.Items.AddRange(listnamapromo.ToArray <string>());
cbSearch.AutoCompleteSource = AutoCompleteSource.ListItems;
cbSearch.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
}
private void cbBarang_TextChanged(object sender, EventArgs e)
{
try
{
Koneksi.openConn();
cmd = new MySqlCommand("select id_barang,satuan_barang from barang where nama_barang='" + cbBarang.Text + "'", Koneksi.conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
tbKodeBarang.Text = dr.GetString(0);
tbKemasan.Text = dr.GetString(1);
}
Koneksi.conn.Close();
}
catch (Exception x)
{ }
}
public void loaddetailnota(string jenis, string nonota)
{
try
{
Koneksi.openConn();
string stm = "select nama_barang as \"Nama Barang\", jumlah_barang as \"Jumlah\", hargasatuan as \"Harga\", diskon1 as \"Nama Barang\", diskon2 as \"Nama Barang\",totalharga as \"Nama Barang\" from djual where kode='" + jenis + "' and id_jual='" + nonota + "' order by nama_barang";
da = new MySqlDataAdapter(stm, Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
Koneksi.conn.Close();
}
catch (Exception x)
{
MessageBox.Show(x.Message);
}
}
private void tbKodeBarang_TextChanged(object sender, EventArgs e)
{
try
{
Koneksi.openConn();
cmd = new MySqlCommand("select nama_barang from barang where id_barang='" + tbKodeBarang.Text + "'", Koneksi.conn);
string nama = cmd.ExecuteScalar().ToString();
cbBarang.Text = nama;
cmd = new MySqlCommand("select hpp from hpp where id_barang='" + tbKodeBarang.Text + "'", Koneksi.conn);
tbHpp.Text = cmd.ExecuteScalar().ToString();
this.ActiveControl = cbBarang;
Koneksi.conn.Close();
}
catch (Exception x)
{
}
}
private void btnBayar_Click(object sender, EventArgs e)
{
if (tbJumlah.Text != "" && nonota != "")
{
int tag = 0; int bay = 0;
tag = Convert.ToInt32(tbTagihan.Text.Replace(".", ""));
bay = Convert.ToInt32(tbJumlah.Text.Replace(".", ""));
if (tag - bay < 0)
{
MessageBox.Show("Periksa Kembali Nominal Anda");
this.ActiveControl = tbJumlah;
}
else
{
Koneksi.openConn();
cmd = new MySqlCommand("update piutang set dibayarkan=dibayarkan+'" + tbJumlah.Text.Replace(".", "") + "' where kode='" + kodenota + "' and id_jual='" + nonota + "' ", Koneksi.conn);
cmd.ExecuteNonQuery();
if (tag - bay == 0)
{
cmd = new MySqlCommand("update piutang set status='1' where kode='" + kodenota + "' and id_jual='" + nonota + "' ", Koneksi.conn);
cmd.ExecuteNonQuery();
}
Koneksi.conn.Close();
DateTime dt = DateTime.Now;
//insert into table dpiutang
Koneksi.openConn();
cmd = new MySqlCommand("insert into dpiutang values('" + kodenota + "','" + nonota + "','" + dt.ToString("dd-MM-yy") + "','" + tbJumlah.Text.Replace(".", "") + "')", Koneksi.conn);
cmd.ExecuteNonQuery();
Koneksi.conn.Close();
tbTagihan.Text = ""; tbJumlah.Text = "";
kodenota = ""; nonota = "";
}
}
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 = null;
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
dataGridView1.DataSource = ds.Tables[0];
settingdatagrid();
Koneksi.conn.Close(); count();
}
private void FormFindPembelian_Load(object sender, EventArgs e)
{
comboBox1.SelectedIndex = 0;
string stm = "select id_beli as \"Nomer Nota\", id_supplier as Supplier, tanggal as Tanggal, format(totalbeli,0,'de_DE') as Total from beli order by id_beli desc";
Koneksi.openConn();
da = new MySqlDataAdapter(stm, Koneksi.conn);
ds = new DataSet();
da.Fill(ds);
Koneksi.conn.Close();
dataGridView1.DataSource = ds.Tables[0];
DataGridViewColumn col = dataGridView1.Columns[3];
col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
col.Width = 95;
loadnota();
}
