Exemple #1
0
        private void PopulateBillReceiptItem(BillReceiptItem billReceiptItem)
        {
            var item = new ListViewItem(billReceiptItem.SalesId.ToString());

            item.SubItems.Add(billReceiptItem.Sales.Date.ToString("dd/MM/yyyy"));
            item.SubItems.Add(billReceiptItem.Sales.Code);
            item.SubItems.Add(billReceiptItem.Sales.Customer.Name);
            item.SubItems.Add(billReceiptItem.Sales.Salesman.Name);
            item.SubItems.Add(billReceiptItem.Total.ToString("N0").Replace(",", "."));

            lvwBillReceipt.Items.Add(item);
        }
        public void Delete(IEntityManager em, Transaction tx, BillReceiptItem billReceiptItem)
        {
            try
            {
                string[] columns = { "Total" };

                object[] values = { 0 };

                var q = new Query().Select(columns).From(tableName).Update(values)
                        .Where("BillReceiptId").Equal("{" + billReceiptItem.BillReceiptId + "}");

                em.ExecuteNonQuery(q.ToSql(), tx);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public void Save(IEntityManager em, Transaction tx, BillReceiptItem billReceiptItem)
        {
            try
            {
                string[] columns = { "ID", "BillReceiptId", "SalesId", "Total", "Notes" };

                object[] values = { Guid.NewGuid(),        billReceiptItem.BillReceiptId, billReceiptItem.SalesId,
                                    billReceiptItem.Total, billReceiptItem.Notes };

                var q = new Query().Select(columns).From(tableName).Insert(values);

                em.ExecuteNonQuery(q.ToSql(), tx);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #4
0
        private void SaveBillReceipt()
        {
            if (dtpDate.Value.Month != Store.ActiveMonth || dtpDate.Value.Year != Store.ActiveYear)
            {
                MessageBox.Show("Tanggal diluar periode aktif", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }

            else if (txtSalesmanName.Text == "")
            {
                MessageBox.Show("Salesman tidak boleh kosong", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
                btnBrowseSalesman.Focus();
            }
            else if (lvwBillReceipt.Items.Count == 0)
            {
                MessageBox.Show("Detail tidak boleh kosong", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                var billReceipt = new BillReceipt();

                billReceipt.Code            = lblCode.Text;
                billReceipt.BillReceiptDate = dtpDate.Value;
                billReceipt.Notes           = txtNotes.Text;
                billReceipt.SalesmanId      = new Guid(txtSalesmanId.Text);
                billReceipt.GrandTotal      = decimal.Parse(lblTotal.Text.Replace(".", ""));


                var billReceiptItems = new List <BillReceiptItem>();

                foreach (ListViewItem item in lvwBillReceipt.Items)
                {
                    string salesId = item.SubItems[0].Text;
                    string total   = item.SubItems[5].Text;

                    BillReceiptItem si = new BillReceiptItem();

                    if (si.Sales == null)
                    {
                        si.Sales = new Sales();
                    }
                    si.Sales.Code = item.SubItems[2].Text;

                    si.SalesId = new Guid(salesId);
                    si.Notes   = "";
                    si.Total   = decimal.Parse(total.Replace(".", ""));

                    billReceiptItems.Add(si);
                }


                billReceipt.BillReceiptItems = billReceiptItems;


                if (formMode == FormMode.Add)
                {
                    billReceiptRepository.Save(billReceipt);
                    ShowBillReceiptReport();
                    GetLastBillReceipt();
                }
                else if (formMode == FormMode.Edit)
                {
                    billReceipt.ID         = new Guid(txtID.Text);
                    billReceipt.GrandTotal = decimal.Parse(lblTotal.Text.Replace(".", ""));
                    billReceiptRepository.Update(billReceipt);
                    ShowBillReceiptReport();
                }

                LoadBillReceiptItems(new Guid(txtID.Text));
                DisableForm();
                formMode = FormMode.View;

                FillCode();
                this.Text = "TTNT";
            }
        }