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