private void FrmUserInterface_Load(object sender, EventArgs e) { try { this.flowLayoutPnl.Controls.Clear(); this.lblNama.Text = user.Nama; this.pbUser.Image = new ImageConverter().ConvertFrom(user.Pict) as Image; using (var dao = new BarangDAO(Setting.GetConnectionString())) { if (dao.GetAllDataBarang().Capacity > 0) { listBarang = dao.GetAllDataBarang(); foreach (var brg in listBarang) { CustomCntrlBrg custom = new CustomCntrlBrg(brg); this.flowLayoutPnl.Controls.Add(custom); } } } } catch (Exception ex) { MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btn_ok_Click(object sender, EventArgs e) { try { using (var barangdao = new BarangDAO()) { foreach (var item in list) { Barang before = barangdao.GetDataBarangByKode(item.Kode); Barang brng = new Barang { Kode = item.Kode, Nama = item.Nama, Stok = (item.Jumlah + Int32.Parse(before.Stok)).ToString(), Harga = item.Harga }; barangdao.UpdateStok(brng); } } MessageBox.Show("Success", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void FrmTampilBarang_Load(object sender, EventArgs e) { using (var dao = new BarangDAO(sqlString)) { if (dao.GetAllDataBarang(brg).Capacity > 0) { this.dgvDataBarang.DataSource = null; this.dgvDataBarang.DataSource = dao.GetAllDataBarang(brg); this.dgvDataBarang.Columns[0].DataPropertyName = "kode"; this.dgvDataBarang.Columns[1].DataPropertyName = "nama"; this.dgvDataBarang.Columns[2].DataPropertyName = "jumlah"; this.dgvDataBarang.Columns[3].DataPropertyName = "harga"; this.dgvDataBarang.Columns[4].DataPropertyName = "Pajak"; } } if (listOrder == null) { this.listOrder = new List <Order>(); } else { this.dgvDataOrder.Rows.Clear(); foreach (Order ord in listOrder) { this.dgvDataOrder.Rows.Add(new string[] { ord.DataBarang.Kode, ord.DataBarang.Nama, ord.DataBarang.Harga.ToString("c"), ord.JumlahBeli.ToString(), $"{ord.Pajak.ToString()} %", ord.SubTotal.ToString("c") }); } } this.lblTotal.Text = temp.ToString("c"); }
private void btnHapus_Click(object sender, EventArgs e) { using (var dao = new BarangDAO(sqlString)) { dao.DeleteBarang(brg.Kode); } MessageBox.Show("Barang sudah terhapus", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
private void btn_add_Click(object sender, EventArgs e) { //this.dgvMainMenu.DataSource = null; //this.dgvMainMenu.DataSource = frmTambah.listData; BarangDAO barangDAO = new BarangDAO(); //barangDAO.Insert(); //if (cbBarang.Text.ToString() == ) }
private void btnSimpan_Click(object sender, EventArgs e) { if (this.txtKodeBarang.Text.Trim() == "") { MessageBox.Show("Sorry, kode barang tidak boleh kosong ...", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.txtKodeBarang.Focus(); } else if (this.txtNamaBarang.Text.Trim() == "") { MessageBox.Show("Sorry, nama barang tidak boleh kosong ...", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.txtNamaBarang.Focus(); } else if (this.txtJumlahBarang.Text.Trim() == "") { MessageBox.Show("Sorry, jumlah tidak boleh kosong ...", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.txtJumlahBarang.Focus(); } else if (this.txtHargaBarang.Text.Trim() == "") { MessageBox.Show("Sorry, harga tidak boleh kosong ...", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.txtHargaBarang.Focus(); } else { try { using (var dao = new BarangDAO(sqlString)) { Barang barang = new Barang { Kode = this.txtKodeBarang.Text.Trim(), Nama = this.txtNamaBarang.Text.Trim(), Jumlah = int.Parse(this.txtJumlahBarang.Text.Trim()), Harga = Convert.ToDecimal(this.txtHargaBarang.Text.Trim()), Pajak = int.Parse(this.txtPajak.Text.Trim()) }; if (brg != null) { dao.UpdateBarang(barang); } else { dao.AddBarang(barang); } } this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void FrmEditDataBarang_Load(object sender, EventArgs e) { Barang barang = new BarangDAO().GetDataBarangByKode(_kode); if (barang != null) { this.txtKode.Text = barang.Kode; this.txtNama.Text = barang.Nama; this.txtHarga.Text = barang.Harga.ToString(); this.txtPajak.Text = barang.Pajak.ToString(); } }
private void btnSimpan_Click(object sender, EventArgs e) { using (var barangdao = new BarangDAO()) { list = barangdao.GetAllDataBarang(); } if (txtKode.Text.Trim() == "" || txtNama.Text.Trim() == "" || txtHarga.Text.Trim() == "" || txtPajak.Text.Trim() == "") { MessageBox.Show("Tolong isi semua data yang diperlukan!", "Kosong", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (txtKode.Text.Length > 4) { MessageBox.Show("Kode Barang tidak boleh melebihi 4 karakter!", "Kode Barang", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (txtNama.Text.Length > 50) { MessageBox.Show("Nama tidak boleh melebihi 50 karakter !", "Nama Terlalu Panjang", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (Decimal.Parse(txtPajak.Text) > 100) { MessageBox.Show("Pajak tidak boleh melebihi 100%", "Pajak Melebihi Batas", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (list.Find(i => i.Kode.ToLower().ToString().Trim() == txtKode.Text.Trim().ToLower()) != null) { MessageBox.Show("Kode barang invalid ! Coba kode lain!", "Kode Invalid", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { try { using (var barangdao = new BarangDAO()) { barangdao.Insert(new Barang { Kode = txtKode.Text, Nama = txtNama.Text, Harga = Double.Parse(txtHarga.Text), Pajak = Decimal.Parse(txtPajak.Text) }); } MessageBox.Show("Penambahan Barang Berhasil", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } catch (Exception ex) { throw ex; } } }
private void FrmEditDataBarang_Load(object sender, EventArgs e) { Barang barang = new BarangDAO().GetDataBarangByKode(_kode); if (barang != null) { this.txtKode.Text = barang.Kode; this.txtNama.Text = barang.Nama; this.txtHarga.Text = barang.Harga; this.cboSatuan.Text = barang.Satuan; this.txtStok.Text = barang.Stok; } }
private void FrmAdminInterface_Load(object sender, EventArgs e) { try { this.lblAdmin.Text = admin.Nama; this.pictureBox1.Image = new ImageConverter().ConvertFrom(admin.Pict) as Image; using (var dao = new BarangDAO(Setting.GetConnectionString())) { this.dgvDataBarang.DataSource = null; this.dgvDataBarang.DataSource = dao.GetAllDataBarang(); this.dgvDataBarang.Columns[0].DataPropertyName = nameof(Barang.Kode); this.dgvDataBarang.Columns[1].DataPropertyName = nameof(Barang.Nama); this.dgvDataBarang.Columns[2].DataPropertyName = nameof(Barang.Jumlah); this.dgvDataBarang.Columns[2].DefaultCellStyle.Format = "n0"; this.dgvDataBarang.Columns[3].DataPropertyName = nameof(Barang.Harga); this.dgvDataBarang.Columns[3].DefaultCellStyle.Format = "c0"; } using (var dao = new AkunDAO(Setting.GetConnectionString())) { this.dgvDataMember.DataSource = null; this.dgvDataMember.DataSource = dao.GetAllDataAccount(); this.dgvDataMember.Columns[0].DataPropertyName = nameof(Akun.Username); this.dgvDataMember.Columns[1].DataPropertyName = nameof(Akun.Nama); this.dgvDataMember.Columns[2].DataPropertyName = nameof(Akun.Total); this.dgvDataMember.Columns[2].DefaultCellStyle.Format = "c0"; } using (var dao = new PenjualanDAO(Setting.GetConnectionString())) { this.dgvDataOrder.DataSource = null; listData = dao.SejarahPenjualan(null, Setting.GetConnectionString()); foreach (Penjualan jual in listData) { this.dgvDataOrder.Rows.Add(new string[] { jual.NoOrder.ToString(), jual.Tanggal.ToShortDateString(), jual.DataBarang.Kode, jual.DataBarang.Nama, jual.DataAkun.Nama, jual.DataBarang.Harga.ToString("c0"), jual.Quantity.ToString("n0"), jual.Total.ToString("c0") }); } } } catch (Exception ex) { MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void FrmTampilBarang_Load(object sender, EventArgs e) { using (var dao = new BarangDAO(sqlString)) { if (dao.GetAllDataBarang().Capacity > 0) { this.dataGridView1.DataSource = null; this.dataGridView1.DataSource = dao.GetAllDataBarang(); this.dataGridView1.Columns[0].DataPropertyName = "kode"; this.dataGridView1.Columns[1].DataPropertyName = "nama"; this.dataGridView1.Columns[2].DataPropertyName = "harga"; this.dataGridView1.Columns[3].DataPropertyName = "jumlah"; } } }
private void FrmDgvResupply_Load(object sender, EventArgs e) { try { using (var dao = new BarangDAO()) { this.dgvData.DataSource = dao.GetAllDataBarang(); this.dgvData.Columns[0].DataPropertyName = "kode"; this.dgvData.Columns[1].DataPropertyName = "nama"; this.dgvData.Columns[2].DataPropertyName = "harga"; } } catch (Exception ex) { MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void FrmTambahBarang_Load(object sender, EventArgs e) { if (brg != null) { this.txtKodeBarang.Text = brg.Kode; this.txtKodeBarang.Enabled = false; this.txtNamaBarang.Text = brg.Nama; this.txtJumlahBarang.Text = Convert.ToInt32(brg.Jumlah).ToString(); this.txtHargaBarang.Text = Convert.ToDecimal(brg.Harga).ToString(); } else { var dao = new BarangDAO(sqlString); this.txtKodeBarang.Text = dao.GetKodeBarangBerikutnya(); this.txtKodeBarang.Enabled = false; this.btnHapus.Visible = false; } }
private void btnDelete_Click(object sender, EventArgs e) { try { using (var barangdao = new BarangDAO()) { barangdao.Delete(dgv1.CurrentCell.Value.ToString()); } MessageBox.Show("Barang berhasil dihapus!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { throw ex; } finally { btnRefresh_Click(null, null); } }
private void btnOrder_Click(object sender, EventArgs e) { DSPenjualan ds = new DSPenjualan(); if (MessageBox.Show("Apakah anda yakin membeli barang ini ?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { foreach (Penjualan jual in listPenjualan) { var row = ds.Penjualan.NewPenjualanRow(); row.NoOrder = jual.NoOrder; row.NamaBarang = jual.DataBarang.Nama; row.NamaCustomer = jual.DataAkun.Nama; row.Quantity = jual.Quantity.ToString(); row.Tanggal = jual.Tanggal.ToShortDateString(); row.SubTotal = jual.Total.ToString("n0"); row.Total = $"Rp. {tempTotalHrg.ToString("n0")}"; ds.Penjualan.AddPenjualanRow(row); _result = new PenjualanDAO(Setting.GetConnectionString()).AddPenjualan(jual) > 0; using (var dao = new BarangDAO(Setting.GetConnectionString())) { dao.UpdateQuantity(jual.DataBarang, jual.Quantity); } using (var dao = new AkunDAO(Setting.GetConnectionString())) { dao.UpdateTotal(jual.DataAkun, jual.Total); } } FrmReceipt frmReceipt = new FrmReceipt(ds); frmReceipt.ShowDialog(); MessageBox.Show("Order telah diproses.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { this.Close(); } }
private void btnDelete_Click(object sender, EventArgs e) { if (this.dgvDataBarang.SelectedRows.Count > 0 && MessageBox.Show("Hapus Item Data Terpilih ?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { using (var dao = new BarangDAO(Setting.GetConnectionString())) { if (dao.DeleteBarang(this.dgvDataBarang.SelectedRows[0].Cells[0].Value.ToString().Trim()) > 0) { FrmAdminInterface_Load(null, null); } } } catch (Exception ex) { MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void txtKodeBarang_Leave(object sender, EventArgs e) { this.dgvDataBarang.DataSource = null; using (var dao = new BarangDAO(Setting.GetConnectionString())) { this.dgvDataBarang.DataSource = dao.GetAllDataBarang(new Barang { Nama = this.txtNamaBarang.Text.Trim(), Kode = this.txtKodeBarang.Text.Trim(), Gambar = null, Harga = 0, Jumlah = 0, }, int.Parse(this.txtJumlahMin.Text, System.Globalization.NumberStyles.AllowThousands), int.Parse(this.txtJumlahMax.Text, System.Globalization.NumberStyles.AllowThousands), int.Parse(this.txtHargaMin.Text, System.Globalization.NumberStyles.AllowThousands), int.Parse(this.txtHargaMax.Text, System.Globalization.NumberStyles.AllowThousands)); } this.dgvDataBarang.Columns[0].DataPropertyName = nameof(Barang.Kode); this.dgvDataBarang.Columns[1].DataPropertyName = nameof(Barang.Nama); this.dgvDataBarang.Columns[2].DataPropertyName = nameof(Barang.Jumlah); this.dgvDataBarang.Columns[3].DataPropertyName = nameof(Barang.Harga); }
private void btnSimpan_Click(object sender, EventArgs e) { try { using (var barangdao = new BarangDAO()) { barangdao.Insert(new Barang { Kode = txtKode.Text, Nama = txtNama.Text, Harga = Double.Parse(txtHarga.Text), Pajak = Int32.Parse(txtPajak.Text) }); } MessageBox.Show("Penambahan Barang Berhasil", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { throw ex; } }
private void Form1_Load(object sender, EventArgs e) { listBelanja = new List <Belanja>(); Form1_Resize(null, null); try { using (var barangdao = new BarangDAO()) { listBrg = barangdao.GetAllDataBarang(); } dgv1.DataSource = listBrg; dgv1.Columns[0].DataPropertyName = "Kode"; dgv1.Columns[1].DataPropertyName = "Nama"; dgv1.Columns[2].DataPropertyName = "Harga"; dgv1.Columns[3].DataPropertyName = "Pajak"; } catch (Exception ex) { throw ex; } }
private void tbNamaBrg_Leave(object sender, EventArgs e) { if (tbNamaBrg.Text.Trim().Equals("")) { this.tbNamaBrg.Focus(); } else { BarangDAO dao = new BarangDAO(Setting.GetConnectionString()); result = dao.GetNamaBarang(tbNamaBrg.Text); if (result == null) { MessageBox.Show("Maaf, Barang tidak ditemukan", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.tbNamaBrg.Text = null; this.tbNamaBrg.Focus(); } else { this.tbHarga.Text = result.HargaBarang; } } }
private void FrmTampilBarang_Load(object sender, EventArgs e) { using (var dao = new BarangDAO(sqlString)) { if (dao.GetAllDataBarang().Count >= 0) { this.dgvDataBarang.DataSource = null; this.dgvDataBarang.DataSource = dao.GetAllDataBarang(); this.dgvDataBarang.Columns[0].DataPropertyName = nameof(Barang.Kode); this.dgvDataBarang.Columns[1].DataPropertyName = nameof(Barang.Nama); this.dgvDataBarang.Columns[2].DataPropertyName = nameof(Barang.Jumlah); this.dgvDataBarang.Columns[3].DataPropertyName = nameof(Barang.Harga); this.dgvDataBarang.Columns[3].DefaultCellStyle.Format = "c"; this.dgvDataBarang.Columns[4].DataPropertyName = nameof(Barang.Pajak); } } if (listOrder == null) { this.listOrder = new List <Order>(); } else { this.dgvDataOrder.Rows.Clear(); foreach (Order ord in listOrder) { this.dgvDataOrder.Rows.Add(new string[] { ord.DataBarang.Kode, ord.DataBarang.Nama, ord.DataBarang.Harga.ToString("c"), ord.JumlahBeli.ToString(), $"{ord.Pajak.ToString()} %", ord.SubTotal.ToString("c") }); } } this.lblTotal.Text = temp.ToString("c"); }
private void txtKode_Leave(object sender, EventArgs e) { using (var dao = new BarangDAO(sqlString)) { if ((brg = dao.GetDataBarangByKode(this.txtKode.Text)) != null) { this.txtNama.Text = brg.Nama; this.txtHarga.Text = brg.Harga.ToString(); this.txtStock.Text = brg.Jumlah.ToString(); this.txtPajak.Text = brg.Pajak.ToString(); } else { this.txtKode.Text = ""; this.txtHarga.Text = ""; this.txtJumlah.Text = ""; this.txtNama.Text = ""; this.txtPajak.Text = ""; this.txtStock.Text = ""; this.txtKode.Focus(); this.label3.Visible = true; } } }