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