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 txtDataOrder_Leave(object sender, EventArgs e)
{
this.dgvDataOrder.Rows.Clear();
using (var dao = new PenjualanDAO(Setting.GetConnectionString()))
{
foreach (Penjualan jual in dao.SejarahPenjualan(null, Setting.GetConnectionString(), this.txtNoOrder.Text.Trim()))
{
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")
});
}
}
}
private void btnCheckout_Click(object sender, EventArgs e)
{
try
{
listPenjualan = new List <Penjualan>();
using (PenjualanDAO dao = new PenjualanDAO(Setting.GetConnectionString()))
{
string Nomor = dao.GetNoOrderBerikutnya();
foreach (CustomCntrlBrg custom in flowLayoutPnl.Controls)
{
Barang brg = custom.GetItemBarang();
int qty = custom.GetQuantityOrder();
if (qty > 0 && brg.Jumlah > 0)
{
listPenjualan.Add(new Penjualan
{
NoOrder = Nomor,
DataAkun = user,
DataBarang = brg,
Quantity = qty,
Tanggal = DateTime.Today,
Total = qty * brg.Harga
});
Nomor = $"{(int.Parse(Nomor) + 1).ToString("0000")}";
}
}
}
if (listPenjualan.Capacity > 0)
{
if (new FrmKeranjang().Run(listPenjualan) == true)
{
this.FrmUserInterface_Load(null, null);
}
}
else
{
throw new Exception("Maaf anda belum order barang");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void FrmSejarahPembelian_Load(object sender, EventArgs e)
{
using (var dao = new PenjualanDAO(Setting.GetConnectionString()))
{
listData = dao.SejarahPenjualan(user, Setting.GetConnectionString());
if (listData != null)
{
foreach (Penjualan jual in listData)
{
this.dgvDataOrder.Rows.Add(new string[]
{
jual.NoOrder.ToString(), jual.Tanggal.ToShortDateString(), jual.DataBarang.Kode,
jual.DataBarang.Nama, jual.DataBarang.Harga.ToString("n0"), jual.Quantity.ToString("n0"), jual.Total.ToString("n0")
});
}
}
this.lblNominalHarga.Text = user.Total.ToString("n0");
}
}
public void MainMenu_Load(object sender, EventArgs e)
{
try
{
//txtKuantitas.Text = "1";
listData = new BarangDAO().GetAllDataBarang();
listData.Insert(0, new Barang {
Nama = ""
});
this.cbBarang.DataSource = listData;
this.cbBarang.DisplayMember = nameof(Barang.Nama);
//QueryData();
jualDao = new PenjualanDAO(Setting.connString);
this.txtNoFaktur.Text = jualDao.GetNomorTransaksiBerikutnya(this.dtpFaktur.Value.Date);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
