Exemple #1
0
        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 btnLogIn_Click(object sender, EventArgs e)
        {
            try
            {
                using (var daoAkun = new AkunDAO(Setting.GetConnectionString()))
                {
                    Akun temp = daoAkun.GetDataCustomerByUsername(txtUsername.Text);

                    if (temp.Password.Equals(txtPassword.Text))
                    {
                        if (temp.Username.ToLower().Equals("admin"))
                        {
                            FrmAdminInterface frm = new FrmAdminInterface(temp);
                            this.Hide();
                            frm.ShowDialog();

                            FrmLogInMember_Load(null, null);
                            this.Show();
                        }
                        else
                        {
                            FrmUserInterface frm = new FrmUserInterface(temp);
                            this.Hide();
                            frm.ShowDialog();

                            FrmLogInMember_Load(null, null);
                            this.Show();
                        }
                    }
                    else
                    {
                        throw new Exception();
                    }
                }
            }
            catch (Exception)
            {
                this.lblAccountError.Visible = true;
                this.txtUsername.Text        = "";
                this.txtPassword.Text        = "";
                this.txtUsername.Focus();
            }
        }
Exemple #3
0
        private void txtDataMember_Leave(object sender, EventArgs e)
        {
            this.dgvDataMember.DataSource = null;
            using (var dao = new AkunDAO(Setting.GetConnectionString()))
            {
                this.dgvDataMember.DataSource = dao.GetAllDataAccount(new Akun
                {
                    Nama     = this.txtNamaUser.Text.Trim(),
                    Username = this.txtUsername.Text.Trim(),
                    Password = null,
                    Pict     = null,
                    Total    = 0
                });

                this.dgvDataMember.Columns[0].DataPropertyName = nameof(Akun.Username);
                this.dgvDataMember.Columns[1].DataPropertyName = nameof(Akun.Nama);
                this.dgvDataMember.Columns[2].DataPropertyName = nameof(Akun.Total);
            }
        }
Exemple #4
0
        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();
            }
        }