public void Delete(IEntityManager em, Transaction tx, DebtPaymentItem debtPaymentItem) { 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("DebtPaymentId").Equal("{" + debtPaymentItem.DebtPaymentId + "}"); em.ExecuteNonQuery(q.ToSql(), tx); } catch (Exception ex) { throw ex; } }
private void PopulateDebtPaymentItem(DebtPaymentItem debtPaymentItem) { var item = new ListViewItem(debtPaymentItem.PurchaseId.ToString()); item.SubItems.Add(debtPaymentItem.Purchase.Code); item.SubItems.Add(debtPaymentItem.Cash.ToString("N0").Replace(",", ".")); item.SubItems.Add(debtPaymentItem.Bank.ToString("N0").Replace(",", ".")); item.SubItems.Add(debtPaymentItem.Giro.ToString("N0").Replace(",", ".")); item.SubItems.Add(debtPaymentItem.GiroNumber); item.SubItems.Add(debtPaymentItem.Correction.ToString("N0").Replace(",", ".")); decimal total = debtPaymentItem.Cash + debtPaymentItem.Bank + debtPaymentItem.Giro + debtPaymentItem.Correction; item.SubItems.Add(total.ToString("N0").Replace(",", ".")); item.SubItems.Add(debtPaymentItem.Purchase.GrandTotal.ToString("N0").Replace(",", ".")); lvwDebtPayment.Items.Add(item); }
public void Save(IEntityManager em, Transaction tx, DebtPaymentItem debtPaymentItem) { try { string[] columns = { "ID", "DebtPaymentId", "PurchaseId", "Cash", "Bank", "Giro", "GiroNumber", "Correction", "Total", "Notes" }; object[] values = { Guid.NewGuid(), debtPaymentItem.DebtPaymentId, debtPaymentItem.PurchaseId, debtPaymentItem.Cash, debtPaymentItem.Bank, debtPaymentItem.Giro, debtPaymentItem.GiroNumber, debtPaymentItem.Correction, debtPaymentItem.Total, debtPaymentItem.Notes }; var q = new Query().Select(columns).From(tableName).Insert(values); em.ExecuteNonQuery(q.ToSql(), tx); } catch (Exception ex) { throw ex; } }
private void SaveDebtPayment() { if (dtpDate.Value.Month != Store.ActiveMonth || dtpDate.Value.Year != Store.ActiveYear) { MessageBox.Show("Tanggal diluar periode aktif", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (lvwDebtPayment.Items.Count == 0) { MessageBox.Show("Detail tidak boleh kosong", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { var debtPayment = new DebtPayment(); debtPayment.PaymentCode = lblCode.Text; debtPayment.PaymentDate = dtpDate.Value; debtPayment.Notes = txtNotes.Text; debtPayment.TotalCash = decimal.Parse(lblCash.Text.Replace(".", "")); debtPayment.TotalBank = decimal.Parse(lblBank.Text.Replace(".", "")); debtPayment.TotalGiro = decimal.Parse(lblGiro.Text.Replace(".", "")); debtPayment.TotalCorrection = decimal.Parse(lblCorrection.Text.Replace(".", "")); debtPayment.GrandTotal = decimal.Parse(lblTotal.Text.Replace(".", "")); var debtPaymentItems = new List <DebtPaymentItem>(); foreach (ListViewItem item in lvwDebtPayment.Items) { string purchaseId = 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; DebtPaymentItem si = new DebtPaymentItem(); if (si.Purchase == null) { si.Purchase = new Purchase(); } si.Purchase.Code = item.SubItems[1].Text; si.PurchaseId = new Guid(purchaseId); 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(".", "")); debtPaymentItems.Add(si); } debtPayment.DebtPaymentItems = debtPaymentItems; if (formMode == FormMode.Add) { debtPaymentRepository.Save(debtPayment); GetLastDebtPayment(); } else if (formMode == FormMode.Edit) { debtPayment.ID = new Guid(txtID.Text); debtPayment.TotalCash = decimal.Parse(lblCash.Text.Replace(".", "")); debtPayment.TotalBank = decimal.Parse(lblBank.Text.Replace(".", "")); debtPayment.TotalGiro = decimal.Parse(lblGiro.Text.Replace(".", "")); debtPayment.TotalCorrection = decimal.Parse(lblCorrection.Text.Replace(".", "")); debtPayment.GrandTotal = decimal.Parse(lblTotal.Text.Replace(".", "")); debtPaymentRepository.Update(debtPayment); } LoadDebtPaymentItems(new Guid(txtID.Text)); DisableForm(); formMode = FormMode.View; FillCode(); this.Text = "Pembayaran Hutang"; } }