private void PopulatePayablePaymentItem(PayablePaymentItem payablePaymentItem) { var item = new ListViewItem(payablePaymentItem.SalesId.ToString()); item.SubItems.Add(payablePaymentItem.Sales.Code); item.SubItems.Add(payablePaymentItem.Cash.ToString("N0").Replace(",", ".")); item.SubItems.Add(payablePaymentItem.Bank.ToString("N0").Replace(",", ".")); item.SubItems.Add(payablePaymentItem.Giro.ToString("N0").Replace(",", ".")); item.SubItems.Add(payablePaymentItem.GiroNumber); item.SubItems.Add(payablePaymentItem.Correction.ToString("N0").Replace(",", ".")); decimal total = payablePaymentItem.Cash + payablePaymentItem.Bank + payablePaymentItem.Giro + payablePaymentItem.Correction; item.SubItems.Add(total.ToString("N0").Replace(",", ".")); item.SubItems.Add(payablePaymentItem.Sales.GrandTotal.ToString("N0").Replace(",", ".")); lvwPayablePayment.Items.Add(item); }
public void Delete(IEntityManager em, Transaction tx, PayablePaymentItem payablePaymentItem) { try { string[] columns = { "Cash", "Bank", "Giro", "Correction", "Total" }; object[] values = { 0, 0, 0, 0, 0, 0 }; var q = new Query().Select(columns).From(tableName).Update(values) .Where("PayablePaymentId").Equal("{" + payablePaymentItem.PayablePaymentId + "}"); em.ExecuteNonQuery(q.ToSql(), tx); } catch (Exception ex) { throw ex; } }
public void Save(IEntityManager em, Transaction tx, PayablePaymentItem payablePaymentItem) { try { string[] columns = { "ID", "PayablePaymentId", "SalesId", "Cash", "Bank", "Giro", "GiroNumber", "Correction", "Total", "Notes" }; object[] values = { Guid.NewGuid(), payablePaymentItem.PayablePaymentId, payablePaymentItem.SalesId, payablePaymentItem.Cash, payablePaymentItem.Bank, payablePaymentItem.Giro, payablePaymentItem.GiroNumber, payablePaymentItem.Correction, payablePaymentItem.Total, payablePaymentItem.Notes }; var q = new Query().Select(columns).From(tableName).Insert(values); em.ExecuteNonQuery(q.ToSql(), tx); } catch (Exception ex) { throw ex; } }
private void SavePayablePayment() { if (dtpDate.Value.Month != Store.ActiveMonth || dtpDate.Value.Year != Store.ActiveYear) { MessageBox.Show("Tanggal diluar periode aktif", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (lvwPayablePayment.Items.Count == 0) { MessageBox.Show("Detail tidak boleh kosong", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { var payablePayment = new PayablePayment(); payablePayment.PaymentCode = lblCode.Text; payablePayment.PaymentDate = dtpDate.Value; payablePayment.Notes = txtNotes.Text; payablePayment.TotalCash = decimal.Parse(lblCash.Text.Replace(".", "")); payablePayment.TotalBank = decimal.Parse(lblBank.Text.Replace(".", "")); payablePayment.TotalGiro = decimal.Parse(lblGiro.Text.Replace(".", "")); payablePayment.TotalCorrection = decimal.Parse(lblCorrection.Text.Replace(".", "")); payablePayment.GrandTotal = decimal.Parse(lblTotal.Text.Replace(".", "")); var payablePaymentItems = new List <PayablePaymentItem>(); foreach (ListViewItem item in lvwPayablePayment.Items) { string salesId = item.SubItems[0].Text; string cash = item.SubItems[2].Text; string bank = item.SubItems[3].Text; string giro = item.SubItems[4].Text; string giroNumber = item.SubItems[5].Text; string correction = item.SubItems[6].Text; string total = item.SubItems[7].Text; PayablePaymentItem si = new PayablePaymentItem(); if (si.Sales == null) { si.Sales = new Sales(); } si.Sales.Code = item.SubItems[1].Text; si.SalesId = new Guid(salesId); si.Notes = ""; si.Cash = int.Parse(cash.Replace(".", "")); si.Bank = decimal.Parse(bank.Replace(".", "")); si.Giro = decimal.Parse(giro.Replace(".", "")); si.GiroNumber = txtGiroNumber.Text; si.Correction = decimal.Parse(correction.Replace(".", "")); si.Total = decimal.Parse(total.Replace(".", "")); payablePaymentItems.Add(si); } payablePayment.PayablePaymentItems = payablePaymentItems; if (formMode == FormMode.Add) { payablePaymentRepository.Save(payablePayment); ShowPayablePaymentReport(); GetLastPayablePayment(); } else if (formMode == FormMode.Edit) { payablePayment.ID = new Guid(txtID.Text); payablePayment.TotalCash = decimal.Parse(lblCash.Text.Replace(".", "")); payablePayment.TotalBank = decimal.Parse(lblBank.Text.Replace(".", "")); payablePayment.TotalGiro = decimal.Parse(lblGiro.Text.Replace(".", "")); payablePayment.TotalCorrection = decimal.Parse(lblCorrection.Text.Replace(".", "")); payablePayment.GrandTotal = decimal.Parse(lblTotal.Text.Replace(".", "")); payablePaymentRepository.Update(payablePayment); ShowPayablePaymentReport(); } LoadPayablePaymentItems(new Guid(txtID.Text)); DisableForm(); formMode = FormMode.View; FillCode(); this.Text = "Pelunasan Piutang"; } }