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";
}
}
